PART II Introduction to the Foundation of information Technologies Session 8-9 Data resource management
HUANG Lihua, Fudan University Session 8-9 Data Resource Management PART Ⅱ Introduction to the Foundation of Information Technologies
Content Database Concepts technology Experiment: ACCESS Database Trends Data Trends of application Data Warehouse OLAP DATA Mining Creating database Environment
HUANG Lihua, Fudan University Content • Database Concepts & Technology – Experiment: ACCESS • Database Trends • Data Trends of Application – Data Warehouse – OLAP – DATA Mining • Creating Database Environment
DATA Streams of raw facts representing events such as business transactions. simple observations of the state of the world
HUANG Lihua, Fudan University DATA • Streams of raw facts representing events such as business transactions, simple observations of the state of the world
FILE ORGANIZATION A computer system organizes data in a hierarchy that begins with bits, and proceeds to bytes, fields, records, files, and database. File Record Record Field Field Field Filed Byte Byte Byte Byte Bit Bit Bit Bit
HUANG Lihua, Fudan University FILE ORGANIZATION • A computer system organizes data in a hierarchy that begins with bits, and proceeds to bytes, fields, records, files, and database. File Record Record Field Field Field Filed Byte Byte Byte Byte Bit Bit Bit Bit
FILE ORGANIZATION BIT: Binary Digit(0, 1, Y,N; On, Off) BYTE: Combination of bits which represent a CHARACTEr FIELD: A logical grouping of characters into a word, a group of words, or a complete number RECORD Collection of fields which reflect a TRANSACTION FILE: A Collection of similar reCords DATABASE: An Organization's electronic Library of fIles
HUANG Lihua, Fudan University FILE ORGANIZATION • BIT: Binary Digit (0,1;Y,N;On, Off) • BYTE: Combination of BITS which represent a CHARACTER • FIELD: A logical grouping of characters into a word, a group of words, or a complete number. • RECORD: Collection of FIELDS which reflect a TRANSACTION • FILE: A Collection of Similar RECORDS • DATABASE: An Organization’s Electronic Library of FILES