Chapter 6: Databases and Data WarehousesCase study: WikipediaIssues: Governance of a database including rights to modify, delete, add entries. Definitions: Data, Database (Collection of records), Information, Knowledge, Mining, DBMS, Query, Schema (A description of objects represented in the database and the relationship amongst them)1. Database fundamentalsa. Data vs. information vs. knowledge: Importance of each for the organization.b. Characteristics of high quality information: Type (transactional or analytic), Timeliness (real-time vs. batch processing), Accuracy, Completeness, consistency, uniquenessc. What is the problem with the following database? What can this cost the company?d. Relational database fundamentals i. Most prevalent.ii. Entities (person, place, thing, transaction, event, or an object about which the information needs to be stored), attributes (fields or columns in a table. They are also characteristics or properties of an entitiy class), keys (primary key and foreign key), and relationships.iii. Advantages (flexibility, Scalability, redundancy, integrity, security e. Database management systems e.g. oracle, db2, sql, access etc.2. Data Warehouse fundamentalsa. Data warehouse fundamentals i. Datawarehouse aggregates infomraiotn throughout an organization into a single repository for easier consumption.ii. All data are not equal (e.g. Two orders A:$10K, B:$20K – you only have 20K worth of stuff. Who do you service?) iii. Relying on just data stored in one database can be disastrous. iv. Datawarehouses can be multidimensional instead of two-dimensional relational databases.b. Data mining and business intelligencei. Data Mining: Process of analyzing data to extract
View Full Document
Unlocking...