ADMS 2511 Lecture Notes - Lecture 3: Sql, Master Data Management, Online Transaction Processing

• School: York University
• Department: Administrative Studies
• Course: ADMS 2511
• Professor: Carl Lapp

Document Summary

Data is obtained from multiple sources: external, internal, personal, clickstream data - produced by visitors and customers when they visit a website and click on hyperlinks. Data degrades over time, people move, etc. Data are subject to data rot, data stored in 8 tracks are worthless unless converted to. Organizations turning to data governance government regulations, bill 198, which requires companies to account for how information is being managed and holds executives accountable for disclosure of this info. Master data management - a process that spans all of an organization"s business processes and applications. Master data - set of core data, such as customer, product, employee, vendor, and geographic location, that span all of the enterprise"s information systems. Transaction data - are generated and captured by operational systems, describe the activities, or transactions, of the business. In contrast, master data involve multiple transactions and are used to categorize, aggregate, and evaluate the transaction data.