Ch. 5
Ch. 5
Ch. 5
Ch. 5
Ch. 5
100
Generalized categories representing a person, place, or thing on which we store and maintain information
What is Entity
100
Presents data as end users would perceive them
What is logical view
100
Creates a subset consisting of all records in the file that meet stated criteria. Combines relational tables to provide the user with more information than is available in individual tables. Creates a subset consisting of columns in a table.
What is Operations of relational database (select, join, project)
100
Finding hidden patterns and relationships in data
What is Data Mining
100
Recognizes patterns that describe the group to which an item belongs
What is Classification
200
Specific characteristics of an entity
What is Attributes
200
Shows how data are actually organized and structured on physical storage media
What is Physical View
200
Stores the data and procedures that act on those data, as objects that can be automatically retrieved and shared
What is Object oriented database
200
Detecting and correcting data
What is Data Cleansing
200
Uses predictions
What is Forecasting
300
Most common, organizes data into two-dimensional tables with columns and rows
What is relational database
300
Specify the structure of the content of the database
What is Data definition
300
Stores data
What is data warehouse
300
Occurrences linked to a single event
What is Association
300
Specifies the rules for sharing and acquiring information. Responsible for the specific policies and procedures through which data can be managed
What is Information Policy and Data Administration
400
Identifier for all the information in any row of the table and cant be duplicated
What is Primary Key
400
Information about the database documented here
What is Data dictionary
400
Subset and focused portion of data exists
What is data mart
400
Events are linked over time
What is Sequence
400
Eliminating duplicate or inconsistent data
What is Ensuring data quality
500
Software for creating, storing, organizing, and accessing data from a database
What is Database Management System
500
Ability to add, change, delete, and retrieve data
What is Data Manipulation
500
View the same data in different ways
What is Multidimensional data analysis and online analytical processing
500
Similar to classification but no groups have been defined
What is Clustering
500
Survey of the accuracy of the data
What is Data quality audit