BUSINESS INTELLIGENCE &
DATABASE SYSTEMS TERMINOLOGIES
Attribute โ ANS characteristic of an entity
Business Intelligence (BI) โ ANS transform raw data into useful information
concurrency control โ ANS two or more people attempting to access the same record at
the same time
data center โ ANS data servers in a building that is climate controlled
Data Hierarchy โ ANS Data in a database organized into sequential levels
data item โ ANS specific value of an attribute
data mart โ ANS subset of warehouse for a single asset like finance
data mining โ ANS Discover patterns and relationships
data model โ ANS diagram of data and there relationship
data redundancy โ ANS data is copies and separated in several locations
data warehouse โ ANS stores historical data - like transactions
database approach โ ANS data shared with multiple application
Database as a service (DaaS) โ ANS accessed by client through network like cloud
computing
Database Management Systems (DBMS) โ ANS interface between the database and
the user
DBMS โ ANS Used to create one or more tables
Entity Class โ ANS Representing a row and a generalized class of people, pace or thing
Entity-relationship diagram โ ANS graphical symbols to show data
Field (column) โ ANS stores a different element of data
flat file โ ANS records with no relationships to others
pg. 1
