MIS 180 Ch. 3
query-and-reporting tools
(a data-mining tool) similar to QBE tools, SQL, and report generators in the typical database environment
multidimensional analysis (MDA) tools
(a data-mining tool)slice-and-dice techniques that allow you to view multidimensional information from different perspectives (turning the cube to see a different perspective)
database management system (DBMS)
helps you specify the logical organization for a database and access and use the information within a database
attributes
pieces of information
relational database
uses a series of logically related two-dimensional tables or files to store information in the form of a database
DBMS engine, data definition, data administration, data manipulation, application generation
The five subsystems of a DBMS
database
a collection of information that you organize and access according to the logical structure of that information. (group of information)
primary key
a field (or group of fields in some cases) that uniquely describes each record. cannot be blank.
data warehouse
a logical collection of information- gathered from many different operational databases- used to create business intelligence that supports decision-making tasks (NOT transaction based)
foreign key
a primary key of one file that appears in another file
data mart
a subset of a data warehouse in which only a focused portion of the data warehouse information is kept
data manipulation subsystem
a subsystem of DBMS that helps you add, change, and delete information in a database and query it for valuable information
data definition subsystem
a subsystem of DBMS that helps you create and maintain the data dictionary and define the structure of the files in a database
data administration subsystem
a subsystem of DBMS that helps you manage the overall database environment by providing facilities for backup and recovery, security management, query optimization, concurrency control, and change management.
DBMS engine
accepts logical requests from the various other DBMS subsystems, convert them into their physical equivalent, and actually accesses the database and data dictionary as they exist on a storage device.
competitive intelligence (CI)
business intelligence focused on the external competitive environment
Business Intelligence (BI)
collective information about your customers, your competitors, your business partners, your competitive environment, and your own internal operations-that gives you the ability to make effective, important. and often strategic business decisions
data dictionary
contains the logical structure for the information in a database. Contains important information about your information
physical view
deals with how information is physically arranged, stored, and accessed on some type of storage device such as a hard disk
relation
describes each two-dimensional table or file in the relational model
digital dashboard
displays key information gathered from several sources on a computer screen in a format tailored to the needs and wants of an individual knowledge worker.
logical view
focuses on you as a knowledge worker need to arrange and access information to meet your particular business needs
Query-by-example (QBE) tools
helps you graphically design the answer to a question
report generators
helps you quickly define formats of reports and what information you want to see in a report
Structured query language (SQL)
same function as a QBE, but asks in the form of Select...from..where... Instead of clicking and dragging
application generation subsystem
subsystem of a DBMS that contains facilities to help you develop transaction-intensive applications. includes tools for creating visually appealing and easy-to-use data entry screens, programming languages specific to a particular DBMS
database 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
data administration
the function in an organization that plans for, oversees the development of, and monitors the information resource.
Online transaction processing (OLTP)
the gathering of input information, processing that information, and updating existing information to reflect the gathered and processed information (often referred to as operational database)
Online Analytical processing (OLAP)
the manipulation of information to support decision making
data-mining tools
the software tools you use to query information in a data warehouse