Bài giảng Management information systems - Chapter 3: Databases and Data Warehouses: Supporting the Analytics-Driven Organization

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 today’s 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 informationRelation = 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 fileCustomer Number is the primary key for Customer and appears in Order as a foreign keyDATABASE MANAGEMENT SYSTEM TOOLSDatabase management system (DBMS) – helps you specify the logical requirements for a database and access and use the information in a database5 Components of a DBMSDBMS engineData definition subsystemData manipulation subsystemApplication generation subsystemData administration subsystemDATA WAREHOUSES 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 – subset 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