Chapter 6 Flashcards
Study Chapter 6
Differences between entities, tables, Rose, and attributes
An entity is something you collect data about, such as people or classes. We often think of entities as tables, where each row is a record and each column is an attribute. A record is a collection of related attributes about a single instance of an entity. Each record typically consists of many attributes, which are individual pieces of information. For example, a name in a social security number are attributes of a particular person
SQL
The most common language used to interface with databases
Operational systems
The systems that are used to interact with customers and run a business in real time
Business intelligence
The use of information systems to gather and analyze information from both external and internal sources to make better decisions, and the data derived from these processes
Informational systems
System designed to support decision-making based on the Stable point – in – time for historical data.
Master data management
Consolidating master data so as to facilitate arriving at a single version of the truth
Data warehouse
And integration of multiple, large databases and other information sources into a single repository or access point that is suitable for direct querying, analysis or processing
Ad hoc query
Request for information created due to unplanned information needs that is typically not saved for later use
Scheduled reports
Reports produced at predefined intervals – daily, weekly, or monthly – to support routine decisions
Key – indicator reports
Reports that provide a summary of critical information on a recurring schedule
Exception reports
Reports that Highlad situations that are out of the normal range
Drill – down reports
Reports that provide greater detail, so as to help analyze my key indicator is not under at an appropriate level or why an exception occurred.
Ad hoc queries
Queries answering unplanned information request to support a nonroutine decision; typically not seem to be run again
Online analytical processing OLAP
The process of quickly conducting complex analysis of data stored in a database, typically using graphical software tools
Measures
The values and numbers a user wants to analyze
Dimensions
A way to summarize data, such as region, time, or product line.
OLAP Cube
A data structure allowing for multiple dimensions to be added to a traditional two – dimensional table for detailed analysis.
Slicing and dicing
Analyzing the data on subsets of the dimensions. Example: a slice Michau sales by product type and region only for the second quarter of 2012. Another slice may only show scale for desktops in the western region
Information visualization
The display of complex data relationships using a variety of graphical methods
Digital dashboards
A display delivering summary information to managers and executives to provide warnings, action notices, and summaries of business conditions.
Push reporting
Quick overview of key performance indicators and other key operational statistics and trends
Exception reporting
Alert user of any items that require immediate attention
Pull reporting
To analyze the root causes of an exception or perform other analysis he can drill down or perform self-service ad hoc queries
