CH-2 - DATABASES AND INFORMATION MANAGEMENT

《CH-2 - DATABASES AND INFORMATION MANAGEMENT》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、ManagementInformationSystemsMANAGINGTHEDIGITALFIRM,12THEDITIONChapter2DATABASESANDINFORMATIONMANAGEMENTVIDEOCASESCase1:MarutiSuzukiBusinessIntelligenceandEnterpriseDatabasesCase2:DataWarehousingatREI:UnderstandingtheCustomerManagementInformationSystemsMANAGINGTHEDIGITALFIRM,12THEDITIO

2、NManagementInformationSystemsCHAPTER6:FOUNDATIONSOFBUSINESSINTELLIGENCE:DATABASESANDINFORMATIONMANAGEMENTLearningObjectives•Describehowtheproblemsofmanagingdataresourcesinatraditionalfileenvironmentaresolvedbyadatabasemanagementsystem•Describethecapabilitiesandvalueofadatabasemanageme

3、ntsystem•Applyimportantdatabasedesignprinciples•Evaluatetoolsandtechnologiesforaccessinginformationfromdatabasestoimprovebusinessperformanceanddecisionmaking•Assesstheroleofinformationpolicy,dataadministration,anddataqualityassuranceinthemanagementofafirm’sdataresources3©PrenticeHall2

4、011ManagementInformationSystemsCHAPTER6:FOUNDATIONSOFBUSINESSINTELLIGENCE:DATABASESANDINFORMATIONMANAGEMENTOrganizingDatainaTraditionalFileEnvironment•Problemswiththetraditionalfileenvironment(filesmaintainedseparatelybydifferentdepartments)–Dataredundancy:•Presenceofduplicatedatainmu

5、ltiplefiles–Datainconsistency:•Sameattributehasdifferentvalues–Program-datadependence:•Whenchangesinprogramrequireschangestodataaccessedbyprogram–Lackofflexibility–Poorsecurity–Lackofdatasharingandavailability4©PrenticeHall2011ManagementInformationSystemsCHAPTER6:FOUNDATIONSOFBUSINESS

6、INTELLIGENCE:DATABASESANDINFORMATIONMANAGEMENTOrganizingDatainaTraditionalFileEnvironmentFIGURE6-2Theuseofatraditionalapproachtofileprocessingencourageseachfunctionalareainacorporationtodevelopspecializedapplications.Eachapplicationrequiresauniquedatafilethatislikelytobeasubsetofthema

7、sterfile.Thesesubsetsofthemasterfileleadtodataredundancyandinconsistency,processinginflexibility,andwastedstorageresources.5©PrenticeHall2011ManagementInformationSystemsCHAPTER6:FOUNDATIONSOFBUSINESSINTELLIGENCE:DATABASESANDINFORMATIONMANAGEMENTRRDonnelleyTriestoMasterItsData•Problem:

8、Explo