DB211 – Chapter 1 Key Terms

data dependence
When all data access programs are subject to change when any of the file’s data storage characteristics change (that is, changing the data type)
ad hoc query
a spur-of-the-moment question to the DBMS, the DBMS returns an answer, also known as a query result set.
analytical databases
Focus primarily on storing historical data and business metrics used exclusively for tactical or strategic decision making.
business intelligence
Describes a comprehensive approach to capture and process business data with the purpose of generating information to support business decision making.
centralized database
A database that supports data located at a single site.
Data are raw facts. Meaning the facts have not yet been processed to reveal their meaning.
data inconsistency
Exsists when different versions of the same data appear in different places.
data processing (DP) specialist
Hired to create a computer-based system that would track data and produce required reports.
data quality
a comprehensive approach to promoting the accuracy, validity, and timeliness of the data.
data warehouse
a specialized database that stores data in a format optimized for decision support. The data warehouse contains historical data obtained from the operational databases as well as data from other external sources.
A shared, integrated computer structure that stores a collection of:
End-user data–that is, raw facts of interest to the end user.
Metadata, or data about data, through which the end-user data are integrated and managed.
database design
refers to the actuates that focus on the design of the database structure that will be used to store and manage end-user data.
Database Management System (DBMS)
A collection of programs that manages the database strutter and controls access to the data stored in the database.
desktop database
A single-user database that runs on a personal computer.
discipline-specific database
Contain data focused on specific subject areas.
distributed database
A database that supports data distributed across several different sites.
enterprise database
When the database is used by the entire organization and supports many users (more than, usually hundreds) across many departments.
Extensible Markup Language (XML)
A special language used to represent and manipulate data elements in a textual format.
A character or group of characters (alphabetic or numeric) that has a specific meaning. A field is used to define and store data.
A collection of related records. For example, a file might contain data about the students currently enrolled at Gigantic University.
general-purpose database
Contain wide variety of data used in multiple disciplines–for example, a census database that contains general demographic data, and the LexisNexis and ProQuest database that contain newspaper, magazine, and journal articles for a variety of topics.
The result of processing raw data to reveal its meaning. Data processing can be as simple as organizing data to reveal patterns or as complex as making forecasts or daring inferences using statistical modeling.
the body of information and facts about a specific subject.
data about data, through which the end-user data are integrated and managed.
multiuser database
supports multiple users at the same time.
NoSQL (Not Only SQL)
Generally used to describe a new generation of database management systems that is not based on the traditional relational database model.
online analytical processing
A set of tools that work together to provide an advanced data analysis environment for retrieving, processing, and modeling data from the data warehouse.
operational database
A database that is designed primarily to support a company’s day-to-day operations. Also known as an online transaction processing (OLTP), transactional, or productional database.
A specific request issued to the DBMS for data manipulation. Simply a query is a question.
query result set
the answer given when an ad hoc query is preformed.
A logically connected set of one or more fields that describes a person, place, or thing. For example, the fields that constitute a customer record might consist of the customer’s name, address, phone number, state of birth, credit limit, and unpaid balance.
single-user database
supports only one user at a time.
social media
Refers to Web and mobile technologies that enable “anywhere, anytime, always on” human interactions.
structural dependence
access to a file is dependent on its structure.
structural independence
exists when you can change the file structure without affecting the applications ability to access the data.
structural data
The result of formatting unstructured data to facilitate storage, use, and the generation of information.
unstructured data
Data that exist in their original (raw) state–that is, in which they were collected. Therefore, unstructured data exist in a format that does not lend itself to the processing that yells information.
workgroup database
When a multiuser database supports a relatively small number of users ( usually fewer than 50) or a specific department
XML database
Supports the storage and management of semistructured XML data.
data independence
exists when you can change the data storage characteristics without affecting the program’s ability to access the data.
logical data format
how the human being views the data
physical data format
how the computer must work with the data
islands of information
storage of the same basic data in different locations
Data redundancy
exists when the same data are stored unnecessarily at different places.
data integrity
the condition in which al data in the database are consistent with real-world events and conditions.
*Data is accurate
*Data is verifiable
data anomaly
develops when not all of the required changes in the redundant data are made successfully
database system
refers to an organization of components that define and regulate the collection, storage, management, and use of data within a database environment.
performance tuning
relates to the activities that make the database perform more efficiently in terms of storage and access speed.
query language
a nonprocedural language–one that lets the user specify what must be done without having to specify how.
Structured Query Language (SQL)
the de facto query language and data access standard supported by the majority of DBMS vendors.