d ata and k nowledge m anagement. 2 m anaging data and information usually too much data rather than...
Post on 22-Dec-2015
215 views
TRANSCRIPT
![Page 1: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/1.jpg)
DATA AND KNOWLEDGE MANAGEMENT
![Page 2: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/2.jpg)
2
MANAGING DATA AND INFORMATION Usually too much data rather than too little in
organizations How does an organization organize all this data and
information? Database – a collection of integrated and related files
Ebay Proquest MBNA
MBNA
![Page 3: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/3.jpg)
3-3
WHAT IS DATABASE TECHNOLOGY ?
A collection of related data organized in a way that makes it valuable and useful
Allows organizations to retrieve, store, and analyze information easily
Is vital to an organization’s success in running operations and making decisions
![Page 4: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/4.jpg)
3-4
RELATIONSHIP OF DBMS CONCEPTS TO OTHERS?
![Page 5: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/5.jpg)
5
THE HIERARCHY OF DATA
![Page 6: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/6.jpg)
3-6
VIEW OF A DATABASE TABLE OR FILEAttribute
(One Column)
Record(One Row)
AttributeType
Entity Attribute
![Page 7: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/7.jpg)
7
THE TRADITIONAL APPROACH
Figure 3.3: The Traditional Approach to Data Management
U of L example
![Page 8: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/8.jpg)
8
THE DATABASE APPROACH
Figure 3.4: The Database Approach to Data Management
Washington hospitalhttp://www.microsoft.com/casestudies/casestudy.aspx?casestudyid=52519
![Page 9: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/9.jpg)
3-9
FILE PROCESSING VS. DATABASE APPROACH
File Processing Approach (Old School)• Storage Media: sequential tapes or files • Data: stored in long sequential files• Organization: redundant data in multiple files• Efficiency: data embedded to support processing• Updates: requires multiple updates in many files• Processing: slower query/faster processing
Data Base Approach (New School-TODAY)• Storage Media: Direct Access Storage Device (DASD) • Data: stored in related tables• Organization: redundant data minimized/eliminated• Efficiency: data stored only in tables• Updates: requires few or one update for a data field• Processing: faster query/slower processing
![Page 10: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/10.jpg)
3-10
ADVANTAGES OF THE DATABASE APPROACH
![Page 11: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/11.jpg)
3-11
COSTS OR RISKS OF THE DATABASE APPROACH
![Page 12: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/12.jpg)
3-12
DATABASE SYSTEMS ACTIVITIES – DATA ENTRY
EnterForms
Employment Applications
(Form Entry Screen) (Form Entry Program) (Employment DB)
Example• Data is entered from paper employment
applications into a form entry screen• The entry forms are designed to match the
paper forms for ease of entry • The form data is processed by the entry
program and then stored in the employment database
![Page 13: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/13.jpg)
3-13
DATABASE SYSTEMS ACTIVITIES – QUERY
(Query Request) (Query Program) (Employment Query)
SQL (Structured Query Language)
QBE (Query by Example)
Query – A database function that extracts and displays information from a database given selection parameters.
Example – Display applicants entered in the last 30 days
Query parameters are selected in the query request screen
The database program uses SQL to query and present the result
![Page 14: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/14.jpg)
3-14
DATABASE SYSTEMS ACTIVITIES – REPORT
(Query Request) (Query Program) (Employment Report)
Report Generator
Report – A database function that extracts and formats information from a database for printing and presentation
Example – Report on applicants entered in the last 30 days• Report parameters are selected in the report request screen• The database program uses SQL to query and present the result
![Page 15: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/15.jpg)
3-15
DESIGNING DATABASES – DATA MODEL
Example: ERD (Entity Relationship Diagram)
Data Model• A map or diagram that represents entities and their
relationships• Used by Database Administrators to design tables with
their corresponding associations
![Page 16: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/16.jpg)
3-16
DESIGNING DATABASES – KEYS
Primary Key- Student ID
ENTITIES
Compound Primary Key- Student ID - Course ID - Sec No.- Term
SecondaryKey- Major
Entities are translated into Tables
(Students and Grades)
Entities arejoined by commonattributes
![Page 17: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/17.jpg)
3-17
THE RELATIONAL MODEL
• Most common type of database model used today in organizations
• Is a three-dimensional model compared to the traditional two-dimensional database models - Rows (first-dimension)
- Columns (second-dimension)
- Relationships (third-dimension)
![Page 18: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/18.jpg)
3-18
THE RELATIONAL MODEL - EXAMPLE
![Page 19: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/19.jpg)
3-19
ONLINE TRANSACTIONAL PROCESSING (OLTP)
Online Transactional Processing• The mechanism by which customers, suppliers, and employees
process business transactions for an organization • These users conduct transactions online through internal systems
and external websites for processing and storage
Example
![Page 20: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/20.jpg)
3-20
OPERATIONAL VS. INFORMATIONAL SYSTEMS
![Page 21: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/21.jpg)
3-21
ORGANIZATIONAL USE OF DATABASES
DepartmentDatabases
Data Warehouse
Data Mart
Operational Informational
ExtractData
ExtractData
ExtractData
ExtractData
•Day-to-day department transactions
•Used primarily by departments
• Extracted department transactions
• Used for business analysis
• Extracted subset of a data warehouse
• Used for highly specific business analysis
Hong Kong Airport
![Page 22: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/22.jpg)
HONG KONG AIRPORT
1. Identify three operational database applications that Hong Kong airport would utilize.
2. Identify three informational uses of database applications that Hong Kong airport would utilize.
Hong Kong Airport
![Page 23: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/23.jpg)
23
DATA WAREHOUSES, DATA MARTS, AND DATA MINING
Data warehouse: collects business information from many sources in the enterprise
Data mart: a subset of a data warehouse
Data mining: an information-analysis tool for automated discovery of patterns and relationships in a data warehouse or a data mart
Online Analytical Processing -Graphical software tools that provide complex analysis of data stored in a database
![Page 24: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/24.jpg)
24
• Data warehouses are not transaction-oriented.
• Data warehouses support online analytical processing (OLAP).
![Page 25: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/25.jpg)
25
DATA WAREHOUSES, DATA MARTS, AND DATA MINING (CONTINUED)
Figure 3.17: Elements of a Data Warehouse
![Page 26: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/26.jpg)
3-26
KNOWLEDGE MANAGEMENT DEFINITIONS
Knowledge AssetsAll underlying skills routines, practices, principles, formulae, methods, heuristics, and intuitions whether explicit or tacit
Tacit Knowledge
Explicit Knowledge
Knowledge ManagementThe process an organization uses to gain the greatest value from its knowledge assets
![Page 27: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/27.jpg)
3-27
KNOWLEDGE MANAGEMENT SYSTEM (KMS)
Primary ObjectiveHow to recognize, generate, store, share, manage this tacit knowledge (Best Practices) for deployment and use
TechnologyGenerally not a single technology but rather a collection of tools that include communication technologies (e.g. e-mail, groupware, instant messaging), and information storage and retrieval systems (e.g. database management system) to meet the Primary Objective
Best PracticesProcedures and processes that are widely accepted as being among the most effective and/or efficient
![Page 28: D ATA AND K NOWLEDGE M ANAGEMENT. 2 M ANAGING DATA AND INFORMATION Usually too much data rather than too little in organizations How does an organization](https://reader035.vdocuments.us/reader035/viewer/2022062421/56649d7f5503460f94a636e7/html5/thumbnails/28.jpg)
A NOT SO PERFECT MATCH
With the increasing power of Data mining techniques, comes ever increasing and reaching uses of this powerful technology.
Is this DNA application an application that has gone too far?
Do you agree with this statement
"There should be a familial searching policy that is constitutional and legal in the Canada”
A not so perfect match