Introduction to Data, Information and Knowledge ManagementIntroduction to Data, Information and Knowledge ManagementData ManagementAn Example Database SystemMetadataFunctional ArchitectureDBMS Design IssuesTypes of Database SystemsRelational Database: ExampleExample Class HierarchyExample Composite ObjectDistributed Database SystemData DistributionInteroperability of Heterogeneous Database SystemsDifferent Data ModelsFederated Database ManagementFederated Data and Policy ManagementOutline of Part I: Information ManagementWhat is Information Management?Data WarehouseData MiningMultimedia Information ManagementImage Processing: Example: Change Detection:Semantic WebKnowledge Management ComponentsIntroduction to Data, Information and Knowledge Management Dr. Bhavani ThuraisinghamThe University of Texas at DallasLecture #3Data, Information and Knowledge ManagementJanuary 27, 2012Introduction to Data, Information and Knowledge ManagementDr. Bhavani ThuraisinghamThe University of Texas at DallasLecture #3Data, Information and Knowledge ManagementJanuary 27, 2012Data ManagementConcepts in database systemsTypes of database systemsDistributed Data ManagementHeterogeneous database integrationFederated data managementAn Example Database SystemDatabaseDatabase Management SystemApplicationProgramsUsersAdapted from C. J. Date, Addison Wesley, 1990MetadataMetadata describes the data in the database-Example: Database D consists of a relation EMP with attributes SS#, Name, and SalaryMetadatabase stores the metadata -Could be physically stored with the databaseMetadatabase may also store constraints and administrative informationMetadata is also referred to as the schema or data dictionaryFunctional ArchitectureUser Interface ManagerQueryManagerTransaction ManagerSchema(Data Dictionary)Manager (metadata)Security/IntegrityManagerFileManagerDiskManagerData ManagementStorage ManagementDBMS Design IssuesQuery Processing-Optimization techniquesTransaction Management-Techniques for concurrency control and recoveryMetadata Management-Techniques for querying and updating the metadatabaseSecurity/Integrity Maintenance-Techniques for processing integrity constraints and enforcing access control rulesStorage management-Access methods and index strategies for efficient access to the databaseTypes of Database SystemsRelational Database SystemsObject Database SystemsDeductive Database SystemsOther-Real-time, Secure, Parallel, Scientific, Temporal, Wireless, Functional, Entity-Relationship, Sensor/Stream Database Systems, etc.Relational Database: ExampleRelation S:S# SNAME STATUS CITYS1 Smith 20 LondonS2 Jones 10 ParisS3 Blake 30 ParisS4 Clark 20 LondonS5 Adams 30 AthensRelation P:P# PNAME COLOR WEIGHT CITYP1 Nut Red 12 LondonP2 Bolt Green 17 ParisP3 Screw Blue 17 RomeP4 Screw Red 14 LondonP5 Cam Blue 12 ParisP6 Cog Red 19 LondonRelation SP:S# P# QTYS1 P1 300S1 P2 200S1 P3 400S1 P4 200S1 P5 100S1 P6 100S2 P1 300S2 P2 400S3 P2 200S4 P2 200S4 P4 300S4 P5 400Example Class HierarchyDocumentClassD1D2Book SubclassB1# of ChaptersVolume #Print-doc-att(ID)Method1:JournalSubclassJ1Print-doc(ID)Method2: ID Name Author PublisherExample Composite ObjectCompositeDocumentObjectSection 1ObjectSection 2ObjectParagraph 1ObjectParagraph 2ObjectDistributed Database SystemCommunication NetworkDistributed Processor 1DBMS 1Data-base 1Data-base 3Data-base 2DBMS 2DBMS 3Distributed Processor 2Distributed Processor 3Site 1Site 2Site 3Data DistributionEMP1SS# Name Salary1 John 20 2 Paul 303 James 404 Jill 50 605 Mary6 Jane 70 D#102020 201020DnameD# MGR10 30 40Jane David Peter DEPT1SITE 1SITE 2EMP2SS# Name Salary9 Mathew70 D#50DnameD# MGR50MathJohn PhysicsDEPT2David 80 30Peter 90 4078C. Sci. English French20PaulInteroperability of Heterogeneous Database SystemsDatabase System ADatabase System BNetworkDatabase System C(Legacy)Transparent accessto heterogeneousdatabases - both usersand application programs;Query, Transactionprocessing(Relational)(Object-Oriented)Different Data ModelsNode ANode BDatabaseDatabaseRelationalModelNetworkModelNode CDatabaseObject-Oriented ModelNetworkNode DDatabaseHierarchicalModelDevelopments: Tools for interoperability; commercial productsChallenges: Global data modelFederated Database ManagementDatabase System ADatabase System BDatabase System CCooperating databasesystems yet maintainingsome degree ofautonomyFederation F1Federation F2Federated Data and Policy ManagementExportData/PolicyComponentData/Policy for Agency AData/Policy for FederationExportData/PolicyComponentData/Policy for Agency CComponentData/Policy for Agency BExportData/PolicyOutline of Part I: Information ManagementInformation Management FrameworkInformation Management OverviewSome Information Management TechnologiesKnowledge ManagementWhat is Information Management?Information management essentially analyzes the data and makes sense out of the dataSeveral technologies have to work together for effective information management-Data Warehousing: Extracting relevant data and putting this data into a repository for analysis-Data Mining: Extracting information from the data previously unknown-Multimedia: managing different media including text, images, video and audio-Web: managing the databases and libraries on the webData WarehouseOracleDBMS forEmployeesSybaseDBMS forProjectsInformixDBMS forMedicalData Warehouse:Data correlatingEmployees WithMedical Benefitsand ProjectsCould beany DBMS; Usually based on the relational data modelUsersQuerythe WarehouseData MiningData MiningKnowledge MiningKnowledge Discoveryin DatabasesData ArchaeologyData DredgingDatabase MiningKnowledge ExtractionData Pattern ProcessingInformation HarvestingSiftwareThe process of discovering meaningful new correlations, patterns, and trends by sifting through large amounts of data, often previously unknown, using pattern recognition technologies and statistical and mathematical techniques(Thuraisingham 1998)Multimedia Information ManagementVideoSourceScene ChangeDetectionSpeakerChangeDetectionSilenceDetectionCommercialDetectionKey
View Full Document