MIS 301 Chapter Notes - Chapter 11: Data Cube, Enterprise Software, Database Application
11 views3 pages
4 Jan 2017
School
Department
Course
Professor
Chapter 11: Databases, Business Intelligence, and Competitive Advantage
1. What does data look like today?
a. Increasingly standardized
b. Rich, third party data sets
c. Cheap, fast computing and easy-to-use software
d. New-aged data enables data-driven, fact-based decision making
2. Business intelligence: a term combining aspects of reporting, data exploration and ad hoc
queries and sophisticated data modeling and analysis
a. Queries and reporting tools give users a subset of requested data
b. Canned reports: summaries of information in a predetermined format
c. Ad hoc reporting tools: create own report by selecting own parameters
d. Dashboards: heads-up display of critical indicators—glance at performance metrics
e. Online analytical processing: a methods of querying and reporting that takes data from
standard relational databases, calculates/summarizes and then stores the data in a data
cube
i. Data cube: a special database used to store data in OLAP reporting
ii. OLAP is FAST compared to performing queries against conventional DBs
3. Analytics: a term describing the extensive use of data, statistical and quantitative analysis,
explanatory and predictive models, and fact-based management to drive decisions
4. Data leverage and data mastery = COMPETITIVE ADVANTAGE
5. Data (raw facts and figures) information (data presented in a context to answer a question or
support a decision) knowledge (insight derived from experience and expertise)
6. Database: a single table or collection of related tables
a. Databases can be focused on any combination of functional areas, geographical area or
business units
b. Data management systems: dataase softare; softare for reatig, aitaiig,
and manipulating data.
i. Oracle is the largest DBMS
c. Database application: a collection of forms, reports, queries and application programs
that process a database
d. Structured query language (SQL): most common language for creating a manipulating
databases
i. My“QL is O““! Mirosoft’s high-end database = SQL Serve
e. Database administrator: directs and manages databases
i. Design, creation, implementation, maintenance, back up or recovery
ii. Ee if you’re ot a DBA, YOU WILL BE EXPO“ED TO DATABA“E“
f. Table or file: refer to a list of data
g. Column or field: defines the data that a table can hold
h. Row or record: represents a single instance of whatever the table keeps track of
i. Key: the field used to relate tables in a database
i. Primary key: column or group of columns that identifies a unique row in a table
ii. Foreign key: non-key column of field in one table that links to primary key in
another table (i.e. UTEID in email table)
iii. Common keys show RELATIONSHIPS
j. Relational tables: databases whereby tables are related based on common keys
k. Query: questions asked to a database that pulls records that meet certain criteria
l. Forms: makes it easier to enter data into a database by providing fields asking for field
information
find more resources at oneclass.com
find more resources at oneclass.com