Scavenger Hunt 8 Flashcards
What is the rate of data growth?
Doubling every 6 months…unprecedented and will continue regardless of budget restraints
What is “information overload”? What is its alleged impact?
Vast flood of info is disruptive, liking drinking from a fire hydrant
People’s cant do their jobs with so much data
By contrast, what is “information abundance” and what are its implications for knowledge workers?
Take advantage of the presence of all the new data to learn how to make meaningful info from it and gain managerial knowledge
Geek up!
Business Intelligence
Combining aspects of reporting, data exploration & ad hoc queries, & sophisticated data modeling & analysis
Analytics
Statistical and quantitative analysis of data
Explanatory and predictive models, and fact-based management to drive decisions and actions
Data
Raw facts and figures
Tells you nothing alone
Information
Data that has been presented in such a way that it answers questions or supports decision making
Knowledge
Insight derived from experience and enterprise-savvy information
Structured Data
Organized data that conforms to a model so that it can be searched, analyzed, and queried using traditional analysis tools
Unstructured Data
Not organized, no schema
Ex. Text, email, Facebook pages, news stories
Binary
Table
Organized collection of data made up of records and fields
Record
Part of table
Row of data
Individual observation
Fields
Part of table
Column
Attribute for data (fixed schema-textual data)
Relational Database
A database that correlates data from multiple tables
Relational Database Benefits
Combines and simplifies data
Relational Database Key Field
One of the fields in a table marked with a key so that the data items are unique for that row
Never repeat
Relational Database Valid Relationship Types
One:One -> Exactly one occurrence in the key field and Table B has only 1 occurrence as well
One:Many -> One occurrence in the key field but many occurrences in other tables
Relational Database Views
Display data from multiple tables relationships by combining them for reporting and display