Term
| Database management system (DBSM) |
|
Definition
| A group of programs that manipulate the database and provide an interface between the database and the user of the database and other application programs |
|
|
Term
| Database administrator (DBA) |
|
Definition
| A skilled IS proffessional who directs all activities related to an organzation's database |
|
|
Term
|
Definition
| a basic building block of information, consisting of uppercase letters, lowercase letters, numeric digits, or special symbols |
|
|
Term
|
Definition
| Typically a name, number or combination of characters that describes an aspect of a business object or activity |
|
|
Term
|
Definition
| A collection of related data fields |
|
|
Term
|
Definition
| a collection of related records |
|
|
Term
|
Definition
| Bits, characters, feilds, records, files, and databases |
|
|
Term
|
Definition
| a generalized class of people, places, or things for which data is collected, stored, and maintained |
|
|
Term
|
Definition
| a charactaristic of an entity |
|
|
Term
|
Definition
| the specific value of an attribute |
|
|
Term
|
Definition
| a field or set of fields in a record that is used to identify the record |
|
|
Term
|
Definition
| a field or set of fields that uniquely identifies the record |
|
|
Term
| traditional approach to data management |
|
Definition
| an approach whereby separate data files are created and stored for each application program |
|
|
Term
| database approach to data management |
|
Definition
| an approach whereby a pool of related data is shared by multiple application programs |
|
|
Term
|
Definition
| a way of organizing data in which the logical database is altered so that certain data entities are combined, summary totals are carried in the data records rather than calculated from elemental data, and some data attributes are repeated in more than one data entity to improve database performance |
|
|
Term
|
Definition
| a diagram of data entities and their relationships |
|
|
Term
|
Definition
| data modeling done at the level of the entire enterprise |
|
|
Term
| entity-relationship (ER) diagrams |
|
Definition
| data models that use basic graphical symbols to show the organiztion of and relationships between data |
|
|
Term
|
Definition
| a database model that describes data in which all data elements are placed in two-dimensional tables, called relations, which are the logical equivalent of files |
|
|
Term
|
Definition
| the allowable calues for data attributes |
|
|
Term
|
Definition
| manipulating data to eliminate rows according to certain criteria |
|
|
Term
|
Definition
| manipulating data to eliminate columns in a table |
|
|
Term
|
Definition
| manipulating data to combine two or more tables |
|
|
Term
|
Definition
| data manipulation that combines two or more tables using common data attributes to form a new table with only the unique data attributes |
|
|
Term
|
Definition
| a description of the entire database |
|
|
Term
| data definition language (DDL) |
|
Definition
| a collection of instructions and commands used to define and describe and relationships in a specific database |
|
|
Term
|
Definition
| a detailed description of all the data used in the database |
|
|
Term
|
Definition
| a method dealing with a situation in which two or more people need to access the same record in a database at the same time |
|
|
Term
| data manipulation language (DML) |
|
Definition
| the commands that are used to manipulate the data in a database |
|
|
Term
|
Definition
| a nontechnical position responsible for defining and implementing consistent principles for a variety of data issues |
|
|
Term
|
Definition
| a database that collects business information from many sources in the enterprise, covering all aspects of the company's processes, products, and customers. |
|
|
Term
|
Definition
| an information-analysis tool that involves the automated discovery of patterns and relationships in a data warehouse |
|
|
Term
|
Definition
| a form of data mining that combines historical data with assumptions about future conditions to predict outcomes of events, such as future product sales or the probability that customer will default on a loan |
|
|
Term
|
Definition
| the process of gathering enough of the right informatino in a timely manner and usable form and analyzing it to have a positive impact on business strategy, tactics, or operations |
|
|
Term
|
Definition
| one aspect of business intelligence limited to information about competitors and the ways that knowledge affects strategy, tactics, and operations |
|
|
Term
|
Definition
| the steps an organization takes to protect information sought by "hostile" intelligence gatherers |
|
|
Term
|
Definition
| a database in which the data can be spread avross several smaller databases connected via telecommunications devices |
|
|
Term
|
Definition
| a database that holds a duplicate set of frequently used data |
|
|
Term
| online analytical processing (OLAP) |
|
Definition
| Software that allows users to explore data from a number of perspectives |
|
|
Term
|
Definition
| a database that stores both data and its processinf instructions |
|
|
Term
| object-oriented database management system (OODBMS) |
|
Definition
| a group of programs that manipulate an object- oriented database and provide a user interface and connections to other aplication programs |
|
|
Term
| object- relational database management system (ORDBMS) |
|
Definition
| a DBMS capable of manipulating audio, video, and graphical data |
|
|
