Chapter 6 review

Chapter 6 review - stored-Entity Classes(table –...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 6 Database advantages (pp. 180-182) - Increased flexibility – Good data base could handle changes quickly and easily, as the business changes. - Increased scalability and performance – scalability refers to how well a system can adapt to increased demands. Performance measures how quickly a system performs a certain process or transactions. - Reduced Redundancy – Duplication of information, costs money and time. - Increased Integrity (quality) – quality of the information (accurately) - Increased security – Protection. Multidimensional analysis (pp. 193-194) Data analysis process that groups data into cube. Users of the data could pick which types of data are needed and only use it for its purpose. Data Mining (pp. 197-199) Def – the process of analyzing data to extract information not offered by the raw data alone. (analyze the data and find out why it is changing) Relational database fundamentals (pp. 182-183) Entities, Entity Classes, and Attributes - Entity – person, place, thing, transaction, or event about which information is
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: stored.-Entity Classes (table) – collection of similar entities-Attributes (fields or columns) – characteristics or properties of an entity class. Keys and Relationships-Primary key – field that uniquely identifies a given entity in a table.-Foreign Key – in a relational database model is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables. Data Warehouse (pp. 192-193) Def – a logical collection of information – gathered from many different operational database – that supports business analysis activities and decision making tasks. ETL – Extraction, Transformation, and loading – this is used to extract data internally and externally than transform the data in to common set of enterprise definitions and loads the information to data warehouse. Data Mart – contains a subset of data warehouse information....
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online