Data Resource Manage

《Data Resource Manage》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、Chapter5DataResourceManagementLearningObjectivesExplainthebusinessvalueofimplementingdataresourcemanagementprocessesandtechnologiesinanorganization.Outlinetheadvantagesofadatabasemanagementapproachtomanagingthedataresourcesofabusiness,comparedtoafilep

2、rocessingapproach.Explainhowdatabasemanagementsoftwarehelpsbusinessprofessionalsandsupportstheoperationsandmanagementofabusiness.LearningObjectivesProvideexamplestoillustrateeachofthefollowingconcepts:MajortypesofdatabasesDatawarehousesanddataminingLo

3、gicaldataelementsFundamentaldatabasestructuresDatabasedevelopmentExamplesoflogicaldataelementsFundamentalDataConceptsCharacter:singlealphabetic,numericorothersymbolFieldordataitem:agroupingofrelatedcharactersRepresentsanattribute(acharacteristicorqual

4、ity)ofsomeentity(object,person,placeorevent)Example:salaryRecord:groupingofallthefieldsusedtodescribetheattributesofanentityExample:payrollrecordwithname,SSNandrateofpayFundamentalDataConceptsFileortable:agroupofrelatedrecordsDatabase:anintegratedcoll

5、ectionoflogicallyrelateddataelementsElectricUtilityDatabaseSource:AdaptedfromMichaelV.Mannino,DatabaseApplicationDevelopmentandDesign(BurrRidge,IL:McGraw-Hill/Irwin,2001),p.6.DatabaseStructuresHierarchicalNetworkRelationalObject-orientedMultidimension

6、alHierarchicalStructureEarlyDBMSstructureRecordsarrangedintree-likestructureRelationshipsareone-to-manyHierarchicalStructureNetworkStructureUsedinsomemainframeDBMSpackagesMany-to-manyrelationshipsNetworkStructureRelationalStructureMostwidelyusedstruct

7、ureDataelementsareviewedasbeingstoredintablesRowrepresentsrecordColumnrepresentsfieldCanrelatedatainonefilewithdatainanotherfileifbothfilesshareacommondataelementRelationalStructureRelationalOperationsSelect:Createasubsetofrecordsthatmeetastatedcriter

8、ionExample,selectemployeeswhomakemorethan$30,000JoinCombinetwoormoretablestemporarilyLookslikeonebigtableProjectCreateasubsetofcolumnsinatableMultidimensionalStructureVariationofrelationalmodelUsesmultidimensionalstructurestoorganizedataDatael