data and knowledge management - wordpress.com · • entity-relationship modeling •...
TRANSCRIPT
![Page 1: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/1.jpg)
Data and Knowledge Management
5
![Page 2: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/2.jpg)
1. Discuss ways that common challenges in managing data can be addressed using data governance.
2. Define Big Data, and discuss its basic characteristics. 3. Explain how to interpret the relationships depicted in
an entity-relationship diagram. 4. Discuss the advantages and disadvantages of relational
databases. 5. Explain the elements necessary to successfully
implement and maintain data warehouses. 6. Describe the benefi ts and challenges of implementing
knowledge management systems in organizations.
![Page 3: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/3.jpg)
1.Managing Data 2.Big Data 3.The Database Approach 4.Database Management Systems 5.Data Warehouses and Data Marts 6.Knowledge Management
![Page 4: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/4.jpg)
[ Opening Case Tapping the Power of Big Data ]
• What We Learned from This Case
![Page 5: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/5.jpg)
Managing Data 5.1 • The Difficulties of Managing Data • Data Governance
![Page 6: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/6.jpg)
Difficulties in Managing Data
• Data increases exponentially with time • Multiple sources of data • Data rot, or data degradation • Data security, quality, and integrity • Government Regulation
![Page 7: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/7.jpg)
Multiple Sources of Data
• Internal Sources – Corporate databases, company documents
• Personal Sources – Personal thoughts, opinions, experiences
• External Sources – Commercial databases, government reports, and
corporate Web sites.
![Page 8: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/8.jpg)
Data Governance
• An approach to managing information across an entire organization.
• Master Data • Master Data Management
![Page 9: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/9.jpg)
Big Data 5.2 • Defining Big Data • Characteristics of Big Data • Managing Big Data • Leveraging Big Data
![Page 10: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/10.jpg)
Defining Big Data
• Big data is difficult to define • Two Descriptions of Big Data
![Page 11: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/11.jpg)
From Gartner Research (Big Data Description 1 of 2) • Diverse, high-volume, high-velocity information
assets that require new forms of processing to enable enhanced decision making, insight discovery, and process optimization. (www.gartner.com)
![Page 12: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/12.jpg)
From the Bid Data Institute (Big Data Description 2 of 2) • Exhibit variety • Includes structured, unstructured, and semi-structured
data • Are generated at high velocity with an uncertain pattern • Do not fit neatly into traditional, structured, relational
databases • Can be captured, processed, transformed, and analyzed in
a reasonable amount of time only by sophisticated information systems.
• (www.the-bigdatainstitute.com)
![Page 13: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/13.jpg)
Defining Big Data
• Big Data Generally Consist of: – Traditional enterprise data – Machine-generated/sensor data – Social Data – Images captured by billions of devices located
around the world • Digital cameras, camera phones, medical scanners, and
security cameras
![Page 14: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/14.jpg)
Characteristics of Big Data
• Volume • Velocity • Variety
![Page 15: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/15.jpg)
Managing Big Data
• When properly analyzed big data can reveal valuable patterns and information.
• Database environment • Traditional relational databases versus
NoSQL databases • Open source solutions
![Page 16: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/16.jpg)
Leveraging Big Data
• Creating Transparency • Enabling Experimentation • Segmenting Population to Customize
Actions • Replacing/Supporting Human Decision
Making with Automated Algorithms • Innovating New Business Models, Products,
and Services • Organizations Can Analyze Far More Data
![Page 17: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/17.jpg)
The Database Approach 5.3 • The Data Hierarchy • Designing the Database
![Page 18: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/18.jpg)
Databases Minimize Three Main Problems
• Data Redundancy • Data Isolation • Data Inconsistency
![Page 19: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/19.jpg)
Databases Maximize the Following
• Data Security • Data Integrity • Data Independence
![Page 20: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/20.jpg)
Data Hierarchy
• Bit • Byte • Field • Data File or Table • Database
![Page 21: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/21.jpg)
Designing the Database
• Key Terms – Data Model – Entity – Instance – Attribute – Primary Key – Secondary Keys
![Page 22: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/22.jpg)
Designing the Database
• Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality
![Page 23: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/23.jpg)
Database Management Systems
5.4 • The Relational Database Model • Databases in Action
![Page 24: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/24.jpg)
The Relational Database Model
• Based on the concept of two-dimensional tables
• Database Management System (DBMS) • Query Languages • Data Dictionary • Normalization
![Page 25: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/25.jpg)
[about business]
Database Solution for the German Aerospace Center
![Page 26: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/26.jpg)
Data Warehouses and Data Marts
5.5 • Describing Data Warehouses and
Data Marts • A Generic Data Warehouse
Environment
![Page 27: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/27.jpg)
Describing Data Warehouses & Data Marts • Data Warehouse
– A repository of historical data that are organized by subject to support decision makers in the organization
• Data Mart – A low-cost, scaled-down version of a data
warehouse designed for end-user needs in a strategic business unit (SBU) or individual department.
![Page 28: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/28.jpg)
Describing Data Warehouses & Data Marts • Basic characteristics of data warehouses
and data marts – Organized by business dimension or subject – Use online analytical processing (OLAP) – Integrated – Time variant – Nonvolatile – Multidimensional
![Page 29: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/29.jpg)
A Generic Data Warehouse Environment
• Source Systems – Data Integration – Storing the Data
• Metadata • Data Quality • Data Governance • Users
![Page 30: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/30.jpg)
[about business]
Hospital Improves Patient Care with Data Warehouse
![Page 31: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/31.jpg)
Knowledge Management 5.6 • Concepts and Definitions • Knowledge Management Systems • The KMS Cycle
![Page 32: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/32.jpg)
Concepts & Definitions
• Knowledge Management (KM) – A process that helps manipulate important
knowledge that comprises part of the organization’s memory, usually in an unstructured format.
• Knowledge • Explicit & Tacit Knowledge • Knowledge Management System (KMS)
![Page 33: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/33.jpg)
Knowledge Management Systems (KMS)
• Refer to the use of modern information technologies – the Internet, intranet, extranets, databases – to systematize, enhance, and expedite intrafirm and interfirm knowledge management. – Best practices
![Page 34: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/34.jpg)
The KMS Cycle
• Create Knowledge • Capture Knowledge • Refine Knowledge • Store Knowledge • Manage Knowledge • Disseminate Knowledge
![Page 35: Data and Knowledge Management - WordPress.com · • Entity-Relationship Modeling • Entity-Relationship Diagram • Cardinality • Modality . Database Management Systems . 5.4](https://reader030.vdocuments.us/reader030/viewer/2022013110/5b92b5c709d3f206218be00d/html5/thumbnails/35.jpg)
[ Closing Case Can Organizations Have Too Much Data? ]
• The Problem • The Solution • The Results