MIS 301 Chapter Notes - Chapter 11: Data Cube, Enterprise Software, Database Application

11 views3 pages
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 indicatorsglance 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: dataase softare; softare for reatig, aitaiig,
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““! Mirosoft’s high-end database = SQL Serve
e. Database administrator: directs and manages databases
i. Design, creation, implementation, maintenance, back up or recovery
ii. Ee 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
Unlock document

This preview shows page 1 of the document.
Unlock all 3 pages and 3 million more documents.

Already have an account? Log in

Get OneClass Notes+

Unlimited access to class notes and textbook notes.

YearlyBest Value
75% OFF
$8 USD/m
Monthly
$30 USD/m
You will be charged $96 USD upfront and auto renewed at the end of each cycle. You may cancel anytime under Payment Settings. For more information, see our Terms and Privacy.
Payments are encrypted using 256-bit SSL. Powered by Stripe.