《数据库原理（第6版）英文版》教学课件—ch08Big Data, Data Warehouses, and Business Intelligence Systems.pptxVIP

Chapter EightBig Data, Data Warehouses, andBusiness Intelligence SystemsChapter Objectives8-Learn the basic concepts of Big Data, structured storage, and the MapReduce processLearn the basic concepts of data warehouses and data martsLearn the basic concepts of dimensional databasesLearn the basic concepts of business intelligence (BI) systemsLearn the basic concepts of Online Analytical Processing (OLAP)Big Data8-The rapidly expanding amount of data being stored and used in enterprise information systemsSearch toolsGoogleBingWeb 2.0 social networksFacebookLinkedInTwitterStorage Capacity TermsFigure 8-1: Storage Capacity Terms8-Heather Sweeney Designs Review:Database Design8-Heather Sweeney Designs:HSD Database Diagram in SQL Server 2008 R2 Figure 8-2: The HSD Database Diagram8-5Business Intelligence Systems8-Business intelligence (BI) systems are information systems thatAssist managers and other professionals in the analysis of current and past activities and in the prediction of future events.Do not support operational activities, such as the recording and processing of orders.These are supported by transaction processing systems.Support management assessment, analysis, planning and control.BI systems fall into two broad categories:Reporting systems that sort, filter, group, and make elementary calculations on operational data.Data mining applications that perform sophisticated analyses on data; analyses that usually involve complex statistical and mathematical processing.The Relationship Among Operational and BI ApplicationsFigure 8-3: The Relationship Between Operational and BI Applications8-Characteristics of Business Intelligence ApplicationsFigure 8-4: Characteristics of Business Intelligence Applications8-Components of aData WarehouseFigure 8-5: Components of a Data Warehouse8-Problems with Operational Data8-“Dirty Data”Example – “G” for GenderExample – “213” for AgeMissing ValuesInconsistent DataExample – data that has changed, such as a customer’s phon