ADMS 2511 Lecture Notes - Lecture 3: Data Cube, Core Data, Online Transaction Processing

• School: York University
• Department: Administrative Studies
• Course: ADMS 2511
• Professor: John Kucharczuk

Document Summary

We need sophisticated tools to manage such data. We transform data into information by sorting the data and making it easier to read. Then, professionals use this organized data (information) and their experience to address a business problem. Data needs to be high quality: complete, accurate, timely, consistent, accessible, relevant and concise. Scattered throughout organization that is collected by various methods of different individuals: numerous servers and locations, different computing systems, databases, formats and human and computer languages. Corporate databases and company documents: personal sources. Commercial databases, government reports and corporate websites: clickstream data: data that visitors and customers produce when they visit a website and click on hyperlinks. Provides user browsing patterns and users" activities in the website. Hard to find pc with floppy disk reader. Data errors information that is out of date, inaccurate, or technically corrupt. Data security legal requirements relating to data differ among countries and industries; change periodically.