Chapter 6 Flashcards
Business Intelligence
The use of information systems to gather and analyze data and information from internal and external sources in order to make better business decisions
Big Data
High volume, high variety, high velocity
Structured Data
Neatly fits into spreadsheets or databases; transaction data
Semi-Structured Data
Clickstreams and sensor data
Unstructured Data
Audio, video data, comments on a social network
Continuous Planning Process
Organizations continuously monitor and analyze data and business processes; the results lead to ongoing adjustments to how the organization is managed, but the results are also reflected in ongoing updates to the organizational plans
DBMS
- Database Management System
- Use to interact with data in databases
- Software application with which create, store, organize, and retrieve data from a single database or several databases
Entity
Something you collect data about, such as people or classes
Tables
Often represent entities
Record
Collection of related attributes about a single instance of an entity
Attribute
Column in a table; individual pieces of information about an entity
RDBMS
- Relational Database Management System
- Attempts to balance efficiency of storage needs, ease of retrieval, and other factors by storing data in tables linked via relationships
Data Model
Map or diagram that represents entities and their relationships
Data Type
Helps the DBMS organize and sort the data, complete calculations, and allocate storage space
Data Dictionary
Document Explaining several pieces of information for each attribute, such as name, type of data expected and valid values
Business Rules
Who has authority to update a piece of data, are captured by the designers of the database and included in the data dictionary to prevent illegal or illogical entries from entering the database
Form
Typically has blanks where the user can enter information or make choices each of which represents an attribute within a database record
Report
Compilation of data from the database that is organized and produced in printed format
Report Generators
Help users quickly build interactive reports and visualizations to present the data in a useful format
Query
Used to retrieve data from a database
Structured Language Query
- SQL
- Most common Language used to interface with RDBMss
Query By Example
Enable to fill out a grid, template in order to construct a sample or description of the data we would like to see