Chapter 1 Flashcards
Analytical Database
Stores historical data and business metrics specifically for tactical and strategic decision making
Business Intelligence
Captures and processes business data to suppor decision making
Data Dictionary
Stores information about the data elements and their relationships
Data Integrity
All data in database is consistent with real world. Accurate and verifiable
Field
Character or group of characters with a specific meaning used to define and store data. Defined as an intersection of rows and columns but commonly used interchangeably with column
File
Collection of related records
Record
Logically connected set of one or more fields that describe a person place or thing. A row
Logical data format
How the human being views the data
Physical data format
How the computer must work with the data
NoSQL
Non-relational database with dynamic schema for unstructured data
Online analytical processing (OLAP)
Approach to answering multi-dimensional analytical queries swiftly in computing.
Online transaction processing (OLTP)
Similar to OLAP but less complex. Used for transaction oriented applications typically data entry.
Operational Database
A database used to support the day-to-day operations of a business. Also referred to as transactional or production database
Performance tunning
Activities that improve the performance of a database in terms of storage and speed of access
Query
Specific request made to the DBMS for data manipulation
