Upgrade to remove ads
Only SGD 41.99/year
-
Flashcards
-
Learn
-
Test
-
Match
-
Flashcards
-
Learn
-
Test
-
Match
Terms in this set [16]
Characteristics of a data warehouse
- Subject-oriented
- Integrated
- Non-volatile
- Time variant
Data warehouse
- Used for data retrieval and analysis
- Integrated data
- Historical and descriptive
data
- Organized by subject
- Non-volatile data
- Relational database structure
- Redundant data
- Multi-dimensional data model
- Fewer but larger tables
- Data for analyzing the business
- Summarized data
- Contains data about data [metadata]
- Queries are unplanned and cannot be easily or quickly optimized
Traditional database
- Used to run daily business transactions
-
Application-specific data
- Current, changing, and incomplete data
- Organized for performance
- Updated data
- Relational database structure
- Normalized data
- Normalized data model
- Large number, but smaller tables
- Data for running the business
- Raw data
- Contains only data
- Queries are pre-defined, small, and can be optimized
- Time element may or may not be contained in key structure
Star schema
Most widely-used method for implementing a multi-dimensional model in a relational database
- Not normalized model
Denormalization
Provides the flexibility for addressing requirements that are ad hoc and unplanned
Database partitioning
Break up data into smaller physical units that can be managed independently. Provides more flexibility in data management for designers and operations personnel.
Aggregation
To improve the performance of queries, data can be aggregated or accumulated along pre-defined attributes. Determined by the number of factors including the frequency of queries
Levels of data
- Current
detailed data
- Lightly summarized data
- Highly summarized data
Current detailed data
- Lowest level of granularity [detail]
- Represent snapshots in time, transactions
Lightly summarized data
- Summarization is based on the fact that most users run queries that repeatedly access and analyze the same data elements at a
summarized level.
- Provides ease of access, performance, and storage requirements
Highly summarized data
- Source can be lightly summarized or current detailed data
- Primary users are senior executives and strategic users
- Allow drill-down on data
Data models
- Logical
- Physical
Logical data model
- Depicts the information requirements of a business.
- Combines the business requirements and data structure.
- Independent of a physical data storage device.
- Includes relationships, cardinality, attributes, and keys
- ERD is created by a data modeler based upon the requirements specified by business experts
Physical data model
-
Created from the logical data model
- Basis for physical database design and implementation
- Activities include denormalizing the data, selecting keys, creating indexes, building referential integrity
Five steps of database design
- Planning and analysis
- Conceptual design
- Logical design
- Physical design
- Implementation
ERD
Entity-Relationship Diagram
Sets found in the same folderChapter 1 - Understanding Decision Support Systems
9 terms
richelletherese
Chapter 2 - Evolution of Data Warehousing
16 terms
richelletherese
Database management systems [DBMS]
37 terms
smwalla
Data Warehousing and OLAP
73 terms
paulyn_romero
Other sets by this creatorMIS 567 - Finals Summary
5 terms
richelletherese
MIS 567 - Midterm Summary Notes
37 terms
richelletherese
Midterm - Practice Test
73 terms
richelletherese
MIS 567 - Midterm Summary Abbreviations
34 terms
richelletherese
Verified questions
computer science
Let HALF-CLIQUE=$\{\langle G\rangle | G$ is an undirected graph having a complete subgraph with at least m/2 nodes, where m is the number of nodes in G}. Show that HALF-CLIQUE is NP-complete.
Verified answer
computer science
Serendipity Booksellers has a book club that awards points to its customers based on the number of books purchased each month. The points are awarded as follows: - If a customer purchases 0 books, he or she earns 0 points. - If a customer purchases 1 book, he or she earns 5 points. - If a customer purchases 2 books, he or she earns 15 points. - If a customer purchases 3 books, he or she earns 30 points. - If a customer purchases 4 or more books, he or she earns 60 points. Write a program that asks the user to enter the number of books that he or she has purchased this month and then displays the number of points awarded.
Verified answer
computer science
What are the three major activities of an operating system with regard to secondary-storage management?
Verified answer
computer science
True/False: GUIs are generally easier to write than text-based interfaces.
Verified answer
Recommended textbook solutionsInformation Technology Project Management: Providing Measurable Organizational Value
5th EditionJack T. Marchewka
346 solutions
Fundamentals of Database Systems
7th EditionRamez Elmasri, Shamkant B. Navathe
687 solutions
Service Management: Operations, Strategy, and Information Technology
7th EditionJames Fitzsimmons, Mona Fitzsimmons
103 solutions
Information Technology Project Management: Providing Measurable Organizational Value
5th EditionJack T. Marchewka
346 solutions
Other Quizlet setsEcon Unit 4
70 terms
chz_bri
lecture guide test
98 terms
cbecke77912
personality psych midterm 2: jung
56 terms
kellydeng
Related questionsQUESTION
T/F: Information density is a key characteristic of performance dashboards.
3 answers
QUESTION
In digital fluoroscopy, what equipment should be used to view the image?
15 answers
QUESTION
What are the two types of direct digital imaging
7 answers
QUESTION
shadow:inset 1px 1px 0 rgba[0,0,0,.1],inset 0
2 answers