1、Chapter 3Databases and Data Warehouses:Supporting the Analytics-Driven Organization INTRODUCTIONBusiness intelligence(BI)collective information that gives you the ability to make effective,important,and strategic business decisionsAnalytics the science of fact-based decision makingBoth are huge in t
2、odays business worldOLTP,OLAP,and Business IntelligenceRELATIONAL DATABASE MODELDatabase collection of information that you organize and access according to the logical structure of the informationRelational database series of logically related two-dimensional tables or files for storing information
3、Relation=table=fileMost popular database modelDatabase Collection of InformationDatabase Logical Ties within the InformationPrimary key field(or group of fields)that uniquely describes each recordForeign key primary key of one file that appears in another fileDATABASE MANAGEMENT SYSTEM TOOLSDatabase
4、 management system(DBMS)helps you specify the logical requirements for a database and access and use the information in a database5 Components of a DBMS1.DBMS engine2.Data definition subsystem3.Data manipulation subsystem4.Application generation subsystem5.Data administration subsystemDATA WAREHOUSE
5、S AND DATA MININGHelp you build and work with BI and some forms of knowledgeData warehouse collection of information(from many places)that supports business analysis activities and decision makingThe Tool Set of the Analytics ProfessionalDigital DashboardThe Analytics Life CycleData MartsData mart s
6、ubset of a data warehouse in which only a focused portion of the data warehouse information is keptINFORMATION OWNERSHIPInformation is a resource you must manage and organize to help the organization meet its goals and objectivesYou need to considerStrategic management supportSharing information with responsibilityInformation cleanliness
