DATABASE SYSTEMS & BUSINESS INTELLIGENCE
Attribute - ANScharacteristic of an entity
Business Intelligence (BI) - ANStransform raw data into useful information
concurrency control - ANStwo or more people attempting to access the same record at the same time
data center - ANSdata servers in a building that is climate controlled
Data Hierarchy - ANSData in a database organized into sequential levels
data item - ANSspecific value of an attribute
data mart - ANSsubset of warehouse for a single asset like finance
data mining - ANSDiscover patterns and relationships
data model - ANSdiagram of data and there relationship
data redundancy - ANSdata is copies and separated in several locations
data warehouse - ANSstores historical data - like transactions
database approach - ANSdata shared with multiple application
Database as a service (DaaS) - ANSaccessed by client through network like cloud computing
Database Management Systems (DBMS) - ANSinterface between the database and the user
DBMS - ANSUsed to create one or more tables
Entity Class - ANSRepresenting a row and a generalized class of people, pace or thing
Entity-relationship diagram - ANSgraphical symbols to show data
Field (column) - ANSstores a different element of data
flat file - ANSrecords with no relationships to others
joining - ANScombines two or more tables
linking - ANScombines two or more tables that share at least one common data
Logical design - ANSabstract model of data that needs to be structured
OLAB - ANSSoftware that can explore data in multiple perspectives
Physical design - ANSlogical database with cost considerations
Primary key - ANSField or set of fields that uniquely identifies the record
projecting - ANSeliminates columns
Record (row) - ANSData for one item, person or transaction
relational database model - ANSdescribes data using a standard tabular format
, DATABASE SYSTEMS & BUSINESS INTELLIGENCE
relationship database - ANSorganized data into multiple tables
selecting - ANSeliminating and picking rows
single user - ANSone person can use it at a time
SQL - From - ANSspecify table
SQL - Select - ANSSpecify attribute
SQL - Where - ANSSpecify the condition
Structured query language (SQL) - ANSstandard language for relational databases
Traditional approach - ANSdata files dedicated to each system
Attribute - ANScharacteristic of an entity
Business Intelligence (BI) - ANStransform raw data into useful information
concurrency control - ANStwo or more people attempting to access the same record at the same time
data center - ANSdata servers in a building that is climate controlled
Data Hierarchy - ANSData in a database organized into sequential levels
data item - ANSspecific value of an attribute
data mart - ANSsubset of warehouse for a single asset like finance
data mining - ANSDiscover patterns and relationships
data model - ANSdiagram of data and there relationship
data redundancy - ANSdata is copies and separated in several locations
data warehouse - ANSstores historical data - like transactions
database approach - ANSdata shared with multiple application
Database as a service (DaaS) - ANSaccessed by client through network like cloud computing
Database Management Systems (DBMS) - ANSinterface between the database and the user
DBMS - ANSUsed to create one or more tables
Entity Class - ANSRepresenting a row and a generalized class of people, pace or thing
Entity-relationship diagram - ANSgraphical symbols to show data
Field (column) - ANSstores a different element of data
flat file - ANSrecords with no relationships to others
joining - ANScombines two or more tables
Attribute - ANScharacteristic of an entity
Business Intelligence (BI) - ANStransform raw data into useful information
concurrency control - ANStwo or more people attempting to access the same record at the same time
data center - ANSdata servers in a building that is climate controlled
Data Hierarchy - ANSData in a database organized into sequential levels
data item - ANSspecific value of an attribute
data mart - ANSsubset of warehouse for a single asset like finance
data mining - ANSDiscover patterns and relationships
data model - ANSdiagram of data and there relationship
data redundancy - ANSdata is copies and separated in several locations
data warehouse - ANSstores historical data - like transactions
database approach - ANSdata shared with multiple application
Database as a service (DaaS) - ANSaccessed by client through network like cloud computing
Database Management Systems (DBMS) - ANSinterface between the database and the user
DBMS - ANSUsed to create one or more tables
Entity Class - ANSRepresenting a row and a generalized class of people, pace or thing
Entity-relationship diagram - ANSgraphical symbols to show data
Field (column) - ANSstores a different element of data
flat file - ANSrecords with no relationships to others
joining - ANScombines two or more tables
linking - ANScombines two or more tables that share at least one common data
Logical design - ANSabstract model of data that needs to be structured
OLAB - ANSSoftware that can explore data in multiple perspectives
Physical design - ANSlogical database with cost considerations
Primary key - ANSField or set of fields that uniquely identifies the record
projecting - ANSeliminates columns
Record (row) - ANSData for one item, person or transaction
relational database model - ANSdescribes data using a standard tabular format
, DATABASE SYSTEMS & BUSINESS INTELLIGENCE
relationship database - ANSorganized data into multiple tables
selecting - ANSeliminating and picking rows
single user - ANSone person can use it at a time
SQL - From - ANSspecify table
SQL - Select - ANSSpecify attribute
SQL - Where - ANSSpecify the condition
Structured query language (SQL) - ANSstandard language for relational databases
Traditional approach - ANSdata files dedicated to each system
Attribute - ANScharacteristic of an entity
Business Intelligence (BI) - ANStransform raw data into useful information
concurrency control - ANStwo or more people attempting to access the same record at the same time
data center - ANSdata servers in a building that is climate controlled
Data Hierarchy - ANSData in a database organized into sequential levels
data item - ANSspecific value of an attribute
data mart - ANSsubset of warehouse for a single asset like finance
data mining - ANSDiscover patterns and relationships
data model - ANSdiagram of data and there relationship
data redundancy - ANSdata is copies and separated in several locations
data warehouse - ANSstores historical data - like transactions
database approach - ANSdata shared with multiple application
Database as a service (DaaS) - ANSaccessed by client through network like cloud computing
Database Management Systems (DBMS) - ANSinterface between the database and the user
DBMS - ANSUsed to create one or more tables
Entity Class - ANSRepresenting a row and a generalized class of people, pace or thing
Entity-relationship diagram - ANSgraphical symbols to show data
Field (column) - ANSstores a different element of data
flat file - ANSrecords with no relationships to others
joining - ANScombines two or more tables
