CHAPTER 13

Data and Databases

STUDY OBJECTIVES

This chapter will help you gain an understanding of the following concepts:

imagesThe need for data collection and storage

images Methods of storing data and the interrelationship between storage and processing

images The differences between batch processing and real-time processing

images The importance of databases and the historical progression from flat-file databases to relational databases

imagesThe need for normalization of data in a relational database

images Data warehouse and the use of a data warehouse to analyze data

images The use of OLAP and data mining as analysis tools

imagesDistributed databases and advantages of the use of distributed data

imagesCloud-based databases

imagesControls for data and databases

imagesEthical issues related to data collection and storage, and their use in IT systems

THE REAL WORLD

images

Think about the volume of sales transactions that occur on the websites of large Internet retailers such as L.L. Bean, Lands' End, and J.Crew. These companies each process an average of approximately 120,000 transactions each day on their websites. For each of these transactions, important data must be collected about the customer, location, payment, and the items sold.

Even more overwhelming is the volume of sales transactions that are processed by Wal-Mart on any given day. In addition to its Web-based sales, consider Walmart's thousands of retail centers with several check-out lines at each location and long hours of operation. Think about the number of accountants and computers that might be required to manage all of the related records. It is no wonder that Walmart has one of the largest databases of any business organization in the world.

The Walmart database continually grows with new transactions. Some estimate that Walmart adds 1 billion rows of data per day. In addition to the size of the database, it is also growing faster. The company attaches RFID chips to merchandise so that inventory purchases, movement to stores, and sales are tracked in real time. Since the data for these events get added to the database so quickly, the database grows and becomes more useful for immediate analysis. This allows Walmart to more quickly analyze and forecast inventory needs.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.135.213.214