Search for notes by fellow students, in your own course and all over the country.
Browse our notes for titles which look like what you need, you can preview any of the notes via a sample of the contents. After you're happy these are the notes you're after simply pop them into your shopping cart.
Title: BUSINESS INTELLIGENCE & DATABASE SYSTEMS TERMINOLOGIES-
Description: Business Intelligence & Database Systems Terminologies. This resource offers a comprehensive overview of key terminologies essential for understanding business intelligence and database systems. It is designed to enhance knowledge and facilitate effective communication in the field, making it a valuable tool for students and professionals alike.
Description: Business Intelligence & Database Systems Terminologies. This resource offers a comprehensive overview of key terminologies essential for understanding business intelligence and database systems. It is designed to enhance knowledge and facilitate effective communication in the field, making it a valuable tool for students and professionals alike.
Document Preview
Extracts from the notes are below, to see the PDF you'll receive please use the links above
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
joining – ANS combines two or more tables
linking – ANS combines two or more tables that share at least one common data
Logical design – ANS abstract model of data that needs to be structured
OLAB – ANS Software 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
BUSINESS INTELLIGENCE & DATABASE SYSTEMS TERMINOLOGIES
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
BUSINESS INTELLIGENCE & DATABASE SYSTEMS TERMINOLOGIES
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
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
BUSINESS INTELLIGENCE & DATABASE SYSTEMS TERMINOLOGIES
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
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
BUSINESS INTELLIGENCE & DATABASE SYSTEMS TERMINOLOGIES
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
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
BUSINESS INTELLIGENCE & DATABASE SYSTEMS TERMINOLOGIES
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
Title: BUSINESS INTELLIGENCE & DATABASE SYSTEMS TERMINOLOGIES-
Description: Business Intelligence & Database Systems Terminologies. This resource offers a comprehensive overview of key terminologies essential for understanding business intelligence and database systems. It is designed to enhance knowledge and facilitate effective communication in the field, making it a valuable tool for students and professionals alike.
Description: Business Intelligence & Database Systems Terminologies. This resource offers a comprehensive overview of key terminologies essential for understanding business intelligence and database systems. It is designed to enhance knowledge and facilitate effective communication in the field, making it a valuable tool for students and professionals alike.