Ch. 3 Databases & Datawarehouses Flashcards
the science of fact-based decision making.
analytics
the gathering of input information, processing that information, and updating existing information to reflect the gathered and processed information
(OLTP) online transaction processing
databases that support OLTP
operational databases
the manipulation of information to support decision making
(OLAP) online analytical processing
a collection of information that you organize and access according to the logical structure of that information
database
uses a series of logically related two-dimensional tables or files to store information in the form of a database
relational database
describes the two-dimensional table or file in the relational model
relation
contains the logical structure for the information in a database
data dictionary
a field (or group of fields in some cases) that uniquely describe each record
primary key
a primary key of one file that appears in another file
foreign key
rules that help ensure the quality of the information
integrity constraints
helps you specify the logical organization for a database and access and use the information within a database
(DBMS) Database Management System
accepts logical requests from the various other dbms subsystems, converts them into their physical equivalent and actually accesses he database and data dictionary as they exist on a storage device
DBMS engine
helps you create and maintain the data dictionary and define the structure of the files in a database
data definition subsystem
helps you add, change, and delete information in the database and query it for valuable information
data manipulation subsystems
allows you to see the contents of the database file, make whatever changes you want, perform simple sorting, and query to find the location of specific information
views
help you quickly define formats of reports and what info you want to see in a report
report generators
help you graphically design the answer to a question
(QBE) query by example tools
a standardized fourth generation query language found in most DBMSs
(SQL) structured query language
contains facilities to help you develop transaction-intensive applications
application generation subsystem
helps you manage the overall database environment by providing facilities for backup and recovery, security management, query optimization, concurrency control, and change management
data administration subsystem
a copy of info stored on computer
backup
the process of reinstalling the backup info in the event the info was lost
recovery
a logical collection of information-gathered from many different operational databases -used to create business intelligence that supports business analysis activities and decision-making tasks
data warehouse
the software tools you use to query info in a data warehouse
data mining tools
slice and dice techniques that allow you to view multidimensional info from different perspectives
(MDA) multidimensional analysis tools
displays key performance info gathered from several sources on a computer screen in a format tailored to the needs and wants of an individual knowledge worker
digital dashbaord
the most essential and important quantifiable measures used in analytics initiatives to monitor success of a business activity
(KPIs) key performance indicators
a subset of a data warehouse in which only a focused portion of the data warehouse information is kept
data mart
the function in an organization that plans for, oversees the development of, and monitors the information resource
data administration
the function in an organization that is responsible for the more technical and operational aspects of managing the information contained in organizational information repositories (databases, data warehouses, and data marts).
database administration
