ADM 2372 Lecture Notes - Hierarchical Database Model, Database Model, Data Warehouse
15 Apr 2012
School
Department
Course
Professor
Document Summary
Chapter 7 databases and data warehouses: databases. Integrating data among multiple databases: data warehousing. Each database, each file, each group of data should have one unique identifier. We all have an individual student id, no two students have the same id. You need to have unique identifiers for elements in the database. If you do analysis, and you want to retrieve information, you will get duplicate information and it would get messy, confusing and inaccurate. Data is raw numbers, and information is analyzed data, or data with meaning. Data are raw facts that describe the characteristics of an event. Information is data converted into a meaningful and useful context (aspect of granularity) The higher you go up in an organization, the more you look at the big picture, rather than the tiny details, because you want to do the planning and forecasting. Information granularity refers to the extent of detail within the information (fine and detailed or coarse and abstract)
