Term
|
Definition
| generalized category representing a person, place, or thing which we store and maintain information |
|
|
Term
|
Definition
| specific characteristics of an entity |
|
|
Term
|
Definition
| most common type of database. organizes data into two-dimensional tables with columns and rows |
|
|
Term
|
Definition
| commonly refereed to as rows or tuples |
|
|
Term
|
Definition
| field in a database table that enables users to find related info in another database table |
|
|
Term
| entity-relationship diagram |
|
Definition
| used to clarify table relationships in a relational database |
|
|
Term
|
Definition
| process of creating small, stable data structures from complex groups of data when designing a relational database |
|
|
Term
| database management system |
|
Definition
| software for creating, storing, organizing, and accessing data from a database. Ex: Microsoft Access |
|
|
Term
|
Definition
| capability to specify the structure of the content of the database |
|
|
Term
|
Definition
| automated or manual file that stores definitions of data elemtns and their characteristics |
|
|
Term
| data manipulation language |
|
Definition
| specialized language used by data management systems |
|
|
Term
|
Definition
| stores data and procedures that act on those data as objects that can be automatically retrieved and shared |
|
|
Term
|
Definition
| database that stores current and historical data of potential interest to decision makers throughout the company |
|
|
Term
|
Definition
| subset of a data warehouse in which a summarized or highly focused portion of the organization's data is placed in a separate database for a specific population of users |
|
|
Term
|
Definition
| applications and technologies to help users make better business decisions |
|
|
Term
| online analytical prcoessing |
|
Definition
| supports multidimensional data analysis, enabling user to view the same data in different ways using multiple dimensions |
|
|
Term
|
Definition
| provides insights into corporate data that cannot be obtained by finding hidden patterns and relationships in large databases and inferring rules from them to predict future behavior |
|
|
Term
|
Definition
| uses data mining techniques, historical data, and assumptions about future conditions to predict outcomes of events |
|
|
Term
|
Definition
| a computer in a client/server environment that is responsible for running a DBMS to process SQL statements and perform database management tasks |
|
|
Term
|
Definition
| responsible for specific policies and procedures through which data can be managed as an organizational resource |
|
|
Term
|
Definition
| refers to the more technical and operational aspects of managing data, including physical database design and maintenance |
|
|
Term
|
Definition
| stuctured survey of the accuracy and level of completeness of the data in an information system |
|
|
Term
|
Definition
| activities for detecting and correcting data in a database that are incorrect |
|
|
