A data warehouse is a logical collection of information gathered from different operational databases and used to create business intelligence that supports decision making tasks and business analysis activities. Walmart is known for having the biggest data warehouse used, which is larger then 4 Petabytes. Wal-Mart is very secretive about their data warehouse. After achieving a major milestone Teradata, Wal-Mart’s data warehouse supplier, was given permission to announce a few shallow facts about Wal-Mart’s data warehouse.
• Wal-Mart has indeed the world’s largest, non military, database with a size of one-half a petabyte.
• It is the world’s largest data warehouse
...view middle of the document...
With this the suppliers were able to view almost everything in the data warehouse, were able to perform the same analysis and exchange idea for improving their business.
Wal-mart turned its data warehouse into an operational system for managing daily store operations by refreshing the information its data warehouse holds every hour. The massive data warehouse is not just a customer of CRM systems but it also serves as the base for Wal-marts RetailLink support system. Teradata is Wal-marts data warehouse vendor.
A data mart is a subset of data warehouse in which only a focused portion of data warehouse information is kept. Originally Walmart did use data marts. They started out with many small data marts, its first being in IBM DB2 and the second in IBM VM/SQL. Eventually the Teradata system was introduced and enabled Walmart to manage all of the information into one database so they built a big data mart. The POS table at Walmart was 1.2 billion records. Within a six months of this, Walmart then decided to turn it into a data warehouse with several tables over 500 million rows.
Data mining software is one of a number of analytical tools for analyzing data. It allows users to analyze data from many different dimensions or angles, categorize it, and summarize the relationships identified. Technically, data mining is the process of finding correlations or patterns among dozens of fields in large relational databases.
WalMart is pioneering massive data mining to transform its supplier relationships. WalMart captures point-of-sale transactions from over 2,900 stores in 6 countries and continuously transmits this data to its massive 7.5 terabyte Teradata data warehouse. WalMart allows more than 3,500 suppliers, to access data on their...