200 likes | 328 Views
1242.2219 Information System Economic s INFORMATION MANAGEMENT. INFORMATION MANAGEMENT. Issues Types of information Data problems The DBA Database issues Data mining Data warehousing Information Knowledge Intelligence Where next?. INFORMATION MANAGEMENT. Issues
E N D
1242.2219 Information System Economics INFORMATION MANAGEMENT
INFORMATION MANAGEMENT • Issues • Types of information • Data problems • The DBA • Database issues • Data mining • Data warehousing • Information • Knowledge • Intelligence • Where next?
INFORMATION MANAGEMENT • Issues Types of Information • Data what • Information why • Knowledge how to • Intelligence solve
INFORMATION MANAGEMENT • Inconsistent Data Definitions • Names • Grades • Dates • 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 Dates 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. McNurlin and Ralph H. Sprague, Jr. Information Systems Management in Practice, 4th Ed. Prentice-Hall ISBN: 0-13-847971-2 Library of Congress: T58.64.I54 1998 Dewey Decimal: 658.4’038-dc21 97-1245
INFORMATION MANAGEMENT Role of the DBA • 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 • What data to keep? • How to organize them
INFORMATION MANAGEMENT Data Mining • Problems in Data Mining • Which relationships to evaluate? • Identification of interesting/meaningful relationships
INFORMATION MANAGEMENT Knowledge • Types of Knowledge • descriptive knowledgedata information • procedural knowledge knowledge • problem solving knowledge intelligence • creative knowledge
INFORMATION MANAGEMENT Where Next? Starting Point Internal External Record BasedTraditional Public EDP/MIS Databases Word processing Corporate Document BasedDocument library management web sites
INFORMATION MANAGEMENT Where Next? Data bases are becoming: • distributed • heterogeneous • unfederated • multimedia
INFORMATION MANAGEMENT Where Next? Problems • distribution => control problems • heterogeneity => integration problems • unfederated => no common schema • multimedia => how to specify and retrieve multiple media
INFORMATION MANAGEMENT Where Next? Solution Directions • for applications - refederation • for information retrieval – intelligent search • intelligent routing • route learning and specialization • natural language querying
INFORMATION MANAGEMENT • Summary • Types of information • Data problems • The DBA • Database issues • Data mining • Data warehousing • Information • Knowledge • Intelligence • Where next?