Term
|
Definition
| confirms that only textual characters are entered in a database field |
|
|
Term
|
Definition
| accumulating transaction data until a certain point is reached, then processing those transactions all at once |
|
|
Term
| Binary Large Object (BLOB) |
|
Definition
| in databases, a type of object that holds extremely large chunks of data in binary form, which are usually video clips, pictures, or audio clips |
|
|
Term
|
Definition
|
|
Term
|
Definition
| info. captured about each vclick that users make as they navigate a Web site |
|
|
Term
|
Definition
| ensures that all data base fields defiend as 'required' have data entered into them |
|
|
Term
|
Definition
| numeric field in a database that is filled as the result of a computation |
|
|
Term
|
Definition
| comparing the value of data in a database field against established parameters to determine whether the value is reasonable |
|
|
Term
|
Definition
| having all data in one central location (usually a database). Data centralization helps ensure data integrity by requiring data to be updated only in one place if the data changes |
|
|
Term
| data dictionary (database schema) |
|
Definition
| defines the name, data type, and length of each field in the database |
|
|
Term
|
Definition
| differences in data in lists cauded when data exists in multiple lists and not all lists are updated when a piece of data changes |
|
|
Term
|
Definition
| when data contained in a datbase is accurate and reliable |
|
|
Term
|
Definition
| small slices of a data warehouse |
|
|
Term
|
Definition
| the process by which great amounts of data are analyzed and investigated to spot significant patterns or trends within the data that would otherwise not be obvious |
|
|
Term
|
Definition
| when the same data exists in more than one place in a database |
|
|
Term
|
Definition
| a 3-step process: extracting data from source databases, transforming the data, and storing the data in a data warehouse |
|
|
Term
|
Definition
| indicates what type of data can be stored in the database field or memory location |
|
|
Term
|
Definition
a large-scale electronic repository of data that contains and organizes in one place all the data related to an organization |
|
|
Term
| database administrator (database designer) |
|
Definition
| an individual trained in the design, construction, and maintenance of databases |
|
|
Term
| database management system (DBS) |
|
Definition
| specially designed application software (oracle or microsoft access) that interacts with the user, other applications, and the database to capture and analyze data |
|
|
Term
|
Definition
| an inquiry the user poses to the database to extract a meaningful subset of data |
|
|
Term
|
Definition
| electronic collections of related data that are organized and searchable |
|
|
Term
|
Definition
| fields in a database that hold date data such as birthdays, due dates, and so on |
|
|
Term
| decision support system (DSS) |
|
Definition
| a system designed to help managers develop solutions for specific problems |
|
|
Term
|
Definition
| the values a databse will use for fields unless the user enters another value |
|
|
Term
|
Definition
| a report generated with data from a database that shows the individual transactions that occurred during a certain time period |
|
|
Term
|
Definition
| reports that show conditions that are unusual or that need attention by users of a system |
|
|
Term
|
Definition
| a system designed to replicate the decision-making processes of human experts to solve specific problems |
|
|
Term
|
Definition
| putting data into an electronic file in a format that another applcation can understand |
|
|
Term
|
Definition
| any source not owned by the company that owns a decision support system, such as customer demographic data purchased from third parties |
|
|
Term
|
Definition
| where a category of info. in a database is stored. fields are displayed in columns |
|
|
Term
|
Definition
| properties that must be satisfied for an entry to be accepted into the database field |
|
|
Term
|
Definition
the primary key of another database table that is included for purposed of establishing relationships with another table |
|
|
Term
|
Definition
| allows the interjection of experiential learning into the equation by considering probabilities |
|
|
Term
|
Definition
| a system that includes data, people, procedures, harware, and software and is used to gather and analyze info. |
|
|
Term
|
Definition
| provides a view of the data fields to be filed in a database, with appropriate labels to assist databse users in populating the data |
|
|
Term
|
Definition
| a database query that links two database tables using a common field in both tabels and extracts the relevant data from each |
|
|
Term
|
Definition
| a support system that provides additional intelligence that supplements the user's own intellect and makes a decision support system (DSS) more effective |
|
|
Term
| management information systems (MIS) |
|
Definition
| a system that provides timely and accurate info. that enables managers to make critical business decisions |
|
|
Term
|
Definition
| text fields in a database that are used to hold long pieces of text |
|
|
Term
|
Definition
| software that assists in building management models in decision uspport systems (DSS) |
|
|
Term
| multidimensional database |
|
Definition
| a database that stores data in multiple dimensions and is organized in a cube format |
|
|
Term
| natural language processing system (NLPS) |
|
Definition
| a system that enables users to communicate with computer systems using a natural spoken or written language as opposed to using computer programming languages |
|
|
Term
|
Definition
| the process of recording data only once in a database to reduce data redundancy |
|
|
Term
|
Definition
| a databse that stores data in objects, not in tables |
|
|
Term
| object query language (OQL) |
|
Definition
| a query language that is used to extract info. from an object-oriented database |
|
|
Term
|
Definition
| a system (such as microsoft office) designed to assist employees in accomplishing their day-to-day tasks and to improve communications |
|
|
Term
|
Definition
| the unique field that each database record in a table must have |
|
|
Term
|
Definition
| the process of requesting of info. from a database |
|
|
Term
|
Definition
| language used to retrieve and isplay records. a query language consists of its own cocab. and sentence structure, used to frame the requests |
|
|
Term
|
Definition
| process of updating a database( or info. system) immediately as changes are made |
|
|
Term
|
Definition
| collection of related fields in a database |
|
|
Term
|
Definition
| for each value in the foreign key of one table, there is a corresponding value in the primary key of the related table |
|
|
Term
|
Definition
| use of English-like expressions that have variables and operations, much like algebraic equations |
|
|
Term
|
Definition
| organizes data in table format by logically grouping similar data into relations that contain related data |
|
|
Term
|
Definition
| database tables that contain related data |
|
|
Term
|
Definition
| in relational databases, the links between tables that define how the data are related |
|
|
Term
|
Definition
| a query that displays a subset of data from a table based on the criteria the user specifies |
|
|
Term
structured (analytical) data |
|
Definition
data that can be identified and classified as discrete bite of info. (such as name or phone number). unstructured data includes nontraditional data such as audio clips (including mp3 files), video clips, and pictures that must be viewed in their entirety as oppoosed to discrete segments |
|
|
Term
|
Definition
| in databses, a group of related records |
|
|
Term
|
Definition
| data that doesn't all pertain to one period in time, such as data in a data warehouse |
|
|
Term
| transaction processing systems (TPS) |
|
Definition
| a system used to keep track of everyday business activites (such as sales products) |
|
|
Term
|
Definition
| rules that are set up in a database to alert the user to possible wrong entries |
|
|
