1242 2219 Information System Economics INFORMATION MANAGEMENT INFORMATION

1242. 2219 Information System Economics INFORMATION MANAGEMENT

INFORMATION MANAGEMENT Issues v Types of information v Data problems v The DBA v Database issues v Data mining v Data warehousing v Information v Knowledge v Intelligence v. Where next?

INFORMATION MANAGEMENT Issues Types of Information v v Data Information Knowledge Intelligence what why how to solve

INFORMATION MANAGEMENT Inconsistent Data Definitions v Names v Grades v Dates v Catalog(ue) numbers

INFORMATION MANAGEMENT Inconsistent Data Definitions Peoples’ Names - Order of names Western: first_name, middle_name(s), family_name (christian_name) (surname), generation e. g. Henry C. Lucas, III Oriental: family_name first_name second_name (Western_name)

INFORMATION MANAGEMENT Inconsistent Data Definitions Peoples’ Names - Order of names But see exceptions: Hungary, westernized oriental names Relational names: Abu Mussa, Ibn Saud, Umm Khaltoum, Bint Hana Shapira, Shapirena, Shapiraita Gender information contained in names/unisex names

INFORMATION MANAGEMENT Inconsistent Data Definitions Dates Different calendar schemes – solar vs. lunar starting points 28 February 2000 = 22 Adar I 5760 = 22 Shawwal 1420 Order: 3/4/1999 = March 4 or April 3?

INFORMATION MANAGEMENT Inconsistent Data Definitions Date semantics: Transaction date Date recorded Value date Time and date zone differences: “I got your message tomorrow”

INFORMATION MANAGEMENT Inconsistent Data Definitions Catalog Numbers Supplier’s catalog number vs. internal organizational number Internal sub-organization catalog numbers Subsidiaries catalog numbers Example: Barbara C. Mc. Nurlin and Ralph H. Sprague, Jr. Information Systems Management in Practice, 4 th Ed. Prentice-Hall ISBN: 0 -13 -847971 -2 Library of Congress: T 58. 64. I 54 1998 Dewey Decimal: 658. 4’ 038 -dc 21 97 -1245

INFORMATION MANAGEMENT Role of the DBA v v v Design DBMS application Rationalize data inconsistencies Maintain data dictionary Control data distribution and sharing Maintain data accuracy Manage data back ups

INFORMATION MANAGEMENT Data Mining

INFORMATION MANAGEMENT Data Mining From On-line Analytic Processing (OLAP) via Data Mining to Knowledge Discovery in Data Bases (KDD)

INFORMATION MANAGEMENT Data Warehousing Problems in Data Warehousing v What data to keep? v How to organize them

INFORMATION MANAGEMENT Data Mining Problems in Data Mining v Which relationships to evaluate? v Identification of interesting/meaningful relationships

INFORMATION MANAGEMENT Knowledge Types of Knowledge v descriptive knowledge data information v procedural knowledge v problem solving knowledge intelligence v creative knowledge

INFORMATION MANAGEMENT Where Next? Starting Point Internal Record Based EDP/MIS External Traditional Databases Word processing Corporate Document Based Document management web sites Public library

INFORMATION MANAGEMENT Where Next? Data bases are becoming: v distributed v heterogeneous v unfederated v multimedia

INFORMATION MANAGEMENT Where Next? Problems v distribution => v heterogeneity => v unfederated => v multimedia => control problems integration problems no common schema how to specify and retrieve multiple media

INFORMATION MANAGEMENT Where Next? Solution Directions v for applications - refederation v for information retrieval – intelligent search Ï intelligent routing Ï route learning and specialization Ï natural language querying

INFORMATION MANAGEMENT Summary v Types of information v Data problems v The DBA v Database issues v Data mining v Data warehousing v Information v Knowledge v Intelligence v. Where next?