Get ahead with a $300 test prep scholarship
| Enter to win by Tuesday 9/24
Terms in this set (73)
In a database, confirms that only textual characters are entered in a field.
The branch of computer science that deals with the attempt to create computers that think like humans.
The accumulation of transaction data until a certain point is reached, at which time several transactions are processed at once.
binary large object (BLOB)
See unstructured data.
business intelligence systems
Systems used to analyze and interpret data in order to enable managers to make informed decisions about how best to run a business.
Software used on company websites to capture information about each click that users make as they navigate through the site.
In a database, ensures that all required fields have been completed.
In a database, compares the values of data in two or more fields to see if those values are reasonable.
A digital collection of related data that can be stored, sorted, organized, and queried.
database administrator (database designer)
An information technology professional responsible for designing, constructing, and maintaining databases.
database management system (DBMS)
A specially designed application software used to create and manage databases.
When data is maintained in only one file.
data dictionary (database schema)
A map of a database that defines the features of the fields in the database.
Data for a record being different in two different lists.
When the data in a database is accurate and reliable.
Small slices of a data warehouse grouped together and separated from the main body of data in the data warehouse so that related sets of data can be analyzed.
The process by which great amounts of data are analyzed and investigated. The objective is to spot significant patterns or trends within the data that would otherwise not be obvious.
Duplicated data in a list.
The act of formatting data from source databases before fitting it into a data warehouse; it consists of three steps: extraction, transformation, and storage.
data type (field type)
(1) Describes the kind of data being stored at the memory location; each programming language has its own data types (although there is some degree of overlap). (2) In a database, indicates what type of data can be stored in a field and prevents the wrong type of data from being entered into the field.
A large-scale collection of data that contains and organizes in one place all the data from an organization's multiple databases.
decision support system (DSS)
A type of business intelligence system designed to help managers develop solutions for specific problems.
The value a database automatically uses for a field unless the user enters another value.
A report generated by a management information system that provides a list of the transactions that occurred during a certain time period.
enterprise resource planning (ERP) system
A business intelligence system that accumulates in a central location all information relevant to running a business and makes it readily available to whoever needs it to make decisions.
A report generated by a management information system that shows conditions that are unusual or that need attention by system users.
A system that tries to replicate the decision-making processes of human experts in order to solve specific problems.
The component of a database in which the database stores each category of information.
A property that must be satisfied for an entry to be accepted into the field.
A way of describing how a database stores different categories of information.
In an Access database table, the field name, data type, and other data elements.
Defines the maximum number of characters that a field can hold in a database.
In a database, temporarily displays records that match certain criteria.
In a relational database, the common field between tables that's not the primary key.
Enables the interjection of experiential learning into knowledge-based systems by allowing the consideration of probabilities.
A system that includes data, people, procedures, hardware, and software that help in planning and decision making; a software-based solution used to gather and analyze information.
Used to control how new data is entered into a shared database.
A query used to extract data that's in two or more tables in a database.
A business intelligence system that provides intelligence that supplements the user's own intellect and makes the decision support system more effective.
management information system (MIS)
A type of business intelligence system that provides timely and accurate information that enables managers to make critical business decisions.
In a relational database, records in one table are related to multiple records in a second table, and vice versa.
Data that describes other data.
model management system
Software that assists in building management models in decision support systems; an analysis tool that, through the use of internal and external data, provides a view of a particular business situation for the purposes of decision making.
A database that stores data from different perspectives, called dimensions, and organizes data in cube format.
natural language processing (NLP) system
A knowledge-based business intelligence system that enables users to communicate with computer systems using a natural spoken or written language instead of a computer programming language.
A process to ensure data is organized most efficiently in a database.
In a database, confirms that only numbers are entered in a field.
A database that stores data in objects rather than in tables.
Object Query Language (OQL)
A query language used by many object-oriented databases.
In a relational database, a record appears only once in one table while having the capability of appearing many times in a related table.
In a relational database, for each record in a table there's only one corresponding record in a related table.
online analytical processing (OLAP)
Software that provides standardized tools for viewing and manipulating data in a data warehouse.
online transaction processing (OLTP)
The real-time processing of database transactions online.
primary key field
In a database, a field that has a value unique to a record.
In a database, a way of retrieving information that defines a particular subset of data; can be used to extract data from one or more tables.
A specially designed computer language used to manipulate data in or extract data from a database.
Ensures that the data entered into the field of a database falls within a certain range of values.
The processing of database transactions in which the database is updated while the transaction is taking place.
A group of related fields in a database.
In a relational database, a condition where, for each value in the foreign key table, there's a corresponding value in the primary key table.
The use of English-like expressions that have variables and operations, much like algebraic equations, to extract data from databases using Structured Query Language.
A database type that organizes data into related tables based on logical groupings.
In a relational database, a link between tables that defines how the data is related.
In Structured Query Language, displays a subset of data from a table (or tables) based on the criteria specified.
structured (analytical) data
Data such as "Bill" or "345," as opposed to unstructured data.
Structured Query Language (SQL)
A database programming language used to construct queries to extract data from relational databases; one example of a fourth-generation language.
A report generated by a management information system that provides a consolidated picture of detailed data; these reports usually include some calculation or visual displays of information.
A group of related records in a database.
Data that doesn't pertain to one period in time.
A type of business intelligence system for keeping track of everyday business activities.
Audio clips, video clips, pictures, and extremely large documents. Also called binary large object (BLOB).
The process of ensuring that data entered into a field of a database meets specified guidelines.
In a database, generally defined as part of the data dictionary and specified in the field properties for each field; violations result in an error message and a suggested action.