ADM 1370 Lecture Notes - Online Analytical Processing, Data Mining, Affinity Analysis
Document Summary
Data and information: data raw facts describing characteristics of an event. Information data converted into meaningful and useful context: database maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses) Data vs information: data: shares in a stock market. How does the performance compare to other stocks: firms need to make their data easily accessible by managers and employees. Transactional data and analytical information: transactional data (packing slips, sales receipts etc) are put into a database which then provides analytical information (trends, product stats, sales projections etc. , analysts = fine transactional data, executives = coarse analytical data. Traditional file processing allows for functional areas to develop specialized applications: applications have master file which will inturn have subsets. Subsets can contain redundancies, processing inflexibilities, and wasted storage resources . Sources: customers intentionally enter inaccurate information for privacy, different system data/information has different standards and formats o o.