Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
55 Cards in this Set
- Front
- Back
Database
|
-usually a group of files |
|
File
|
-all files are integrated |
|
Record |
-Group of related fields |
|
Data Hierarchy
|
?? |
|
Critical component of information systems
|
-Any type of analysis that's done is based on data available in the database |
|
Database Management System (DBMS)
|
-Creating, storing, maintaining, and accessing database files |
|
Advantages over a flat file system
|
??? |
|
Internal Data
|
-Collected within organization |
|
External Data
|
- outside sources |
|
Sequential File Structure
|
-Organized based on a "primary key" -Usually used for backup and archive files |
|
Random Access File Structure
|
-Records can be accessed in any order -Fast and very effective when a small number of records needs to be processed daily or weekly |
|
Indexed sequential access method (ISAM)
|
-Depending on the number being accessed |
|
Indexed access
|
Indexed value Pointer to the disk location of the record mathing the indexed value |
|
Physical view
|
-How data is stored on and retrieved from storage media
|
|
Logical view
|
-How it can be organized and retrieved -Can be more than one logical view |
|
Data Model
|
?? |
|
Hierarchical model |
?? |
|
Network Model
|
?? |
|
Relational Model
|
?? |
|
Data Dictionary
|
?? |
|
Primary keys
|
?? |
|
Foreign Key
|
?? |
|
Normalization |
?? |
|
Data retrieval
|
?? |
|
Components of DBMS
|
??
|
|
Database Engine
|
?? |
|
Data Definition
|
slide 21 |
|
Data Manipulation
|
slide 22?? |
|
Application Generation
|
?? |
|
Data Administration
|
slide 24?? |
|
Recent Trends in Database design and use
|
25?? |
|
Data-Driven Web Sites
|
26??
|
|
Distribution Database
|
27?? |
|
Object-oriented database
|
?? |
|
Encapsulation
|
?? |
|
Inheritance |
?? |
|
Data Warehouse
|
-Collection of data used to support decision-making applications and generate business intelligence |
|
What are characteristics of "Data Warehouse" in contrast to data in a database? |
-Integrated -Time variant -Type of data -Purpose |
|
What is subject oriented?
|
Database created to serve a specific problem |
|
What is integrated? |
when you can pull data for different subjects in one.
|
|
what is Time variant?
|
defines time in data
|
|
What are the variety of Input sources for data warehouse?
|
-Database -Transaction Files -ERP systems -CRM systems |
|
What does ETL stand for?
|
Extraction, Transformation, and Loading |
|
What is Extraction?(ETL)
|
-Converting data into a format that can be used in transformation processing |
|
What is Transformation Processing |
-Makes sure data meets the data warehouse's needs
|
|
What is loading?(ETL)
|
-Process of transferring data to the data warehouse |
|
What is "storage"?
|
-Summary data -Metadata (collection of everything) |
|
What does Data warehouse do with output?
|
-Supports different type of analysis and generates reports for decision making. |
|
What is Online Analytical Processing (OLAP)? |
-Uses multiple sources of information and provides -Hypercube -Drill down and drill up |
|
What is data-mining analysis
|
-Discover patterns and relationships |
|
What do data warehouse reports allow you to do?
|
-Find patterns and trends that can't be found with databases -Analyze large amounts of historical data quickly -Assist management in making well-informed business decisions |
|
What is Data Mart?
|
-Smaller version of data warehouse -Used by singled department or function (smaller coverage basically..) |
|
What advantages does Data Mart have over data warehouse?
|
?? |
|
What is Business Analytics (BA)?
|
-uses data and statistical methods to gain insight into the data -provide decision makers with information to act on |
|
What are the different types of BA methods?
|
-Predictive analytics |