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