Verified Document

Database Implementation Term Paper

Database System in a Retail Environment We are in a world of information boom and efficient management of data holds the key for success in this new business environment. The world of Internet has opened new vitas for corporations to take their business into a global level. Data management is at the center of all business applications and database systems are the very core of this new business perspective. Database systems have helped us take a huge stride in our ability to collect, interpret, and even assist in our decision making process. In short we can say that database management systems have bought a paradigm shift to our mode of business and have evolved from being simple store houses of data to more complex and highly efficient business decision making tools. Let us take Wall-Mart, the giant retailer as our case study and how the company profited from the implementation of a highly sophisticated database management system. In the process we will also analyze some of the problems faced by the company and possible solutions for the same.

Summary

Wall-Mart (Data Warehouse)

Wal-Mart Inc. is one of the biggest retailers in the United States with more than $200 billion in annual sales. Spread throughout the nation with more than 2600 discount stores and around 480 SAM clubs Wal-Mart has an exhaustive presence within the United States and even in Canada. Managing such a huge network of stores is no easy task and in order to integrate the different stores and to and optimize its performance Wall-mart had turned to information technology for intelligent business management solutions. Wal-Mart was quick to recognize the role of I.T in the decision making process and with this view it implemented...

Wal-Mart had a pact with NCR (in 1997) to provide the data warehouse solutions. NCR provided Wal-Mart with the "NCR WorldMark 5100M," a very extensive parallel processing database server and also constructed a huge 22 terabytes data warehouse. Armed with this massive data warehouse and integration between all the stores national wide Wal-Mart was able to have an exhaustive analysis of the trends in business and the local stores were able to better understand the buying patterns of their customers. [Tom Chester]
Data Mining

Customer service was taken to new heights with access and intelligent interpretation of data from more than 2800 stores. With excellent interconnectivity each customer can have access to the details pertaining to products from any of the stores around the country. Wal-Mart also invested on data mining software to enable better analysis of data from its massive data warehouse. The data mining software is very useful in pruning through the huge pile of information in the data warehouse and in identifying the best prospects for the business. Wal-Mart turned to Neo-Vista Software Inc. To deliver its data mining needs. The Neo-Vista decision series ™ was tailored to match the requirements of the database environment of Wal-Mart. One important advantage of the implementing the data-mining tool was that the company was able to optimize the inventory management. (Better management of stocks). According to said Randy Mott, the senior vice president and the chief information officer of Wal-Mart,

Our investment in data mining is part of Wal-Mart's drive to deliver what it's customers want: the right item, at the right store, at the right time and at…

Sources used in this document:
Bibliography

Author not available, "Wal-Mart Deploys Data Mining Software." Accessed on 4th March, 2003

http://216.239.37.100/search?q=cache:TfEMHrZYf5kC:www.stfx.ca/people/x99/x99dnh/419/Walmart%25201.doc+%22neovista+decision+series%22+walmart+&hl=en&ie=UTF-8

Phillip Greenspun, "Data Warehousing," Accessed on 4th March 2003, http://philip.greenspun.com/sql/data-warehousing.html

Tom Chester, "Database Sizes," Accessed on 4th March 2003. http://sd.znet.com/~schester/facts/database_sizes.html
Cite this Document:
Copy Bibliography Citation

Related Documents

Database Data Warehousing Design Data Warehousing Is
Words: 1314 Length: 4 Document Type: Essay

Database Data Warehousing Design Data warehousing is a powerful tool that business organizations use to enhance competitive advantages. Data warehousing supports business decision by collecting, organizing and consolidating data for analysis and reporting using tools such as OLAP (online analytical processing ) and data mining. Typically, the relational database technology is generally being used to design a data warehousing and a relational database is a database having collection of tables, and

Database Data Warehouse Design Our Company, Data
Words: 1488 Length: 5 Document Type: Essay

Database Data Warehouse Design Our company, Data Analytic Limited, specializes in collecting and analyzing data for various organizations. Over the years, we have assisted various companies to turn raw data into valuable information that assists the companies in making effective decision profitable in the short and long run. Our research and data analytics are geared towards giving extra edge to various companies. Our services include processing and analyzing terabytes of data

Database Differentiation
Words: 1805 Length: 5 Document Type: Term Paper

Database Differentiation Description of the data models A detailed description of all the tables that a database consists of is referred to as a data dictionary. A data dictionary will contain all the attribute characteristics and names for every table found within a database system. A data dictionary can also be referred to as a metadata repository. This is because it contains information like relationships with other data, meaning, usage, format, and

Database Presentation
Words: 1460 Length: 5 Document Type: Term Paper

Database Presentation The objective of this study is to present a new database to be implemented in the clinical setting to increase quality and safety of patient care. The database at focus in this work in writing is that of the Targeted Therapy Database (TTD) in a Cancer unit in a hospital. The work of Mocellin, et al. (2010) relates that the "efficacy of current anticancer treatments is far from satisfactory and

Database Administrator for Department Store
Words: 3901 Length: 13 Document Type: Research Paper

Database Administrator for Department Store Scenario The department store has expanded in the local region by opening five more bookstores, and the bookstore has launched a series of marketing campaign to increase sales and attract new customers. The objective of this technical report is to develop a plan to create and maintain an enterprise-wide database system that will assist the bookstore to hold the inventory and sales data. The database design will

Database Design for SPA Hotel Booking System
Words: 3480 Length: 12 Document Type: Term Paper

Database Design for Spa/Hotel Booking System The WR (Woodlands Retreat) is a medium sized organization currently intending to build a database system to integrate modern IT (information systems) in its business operation to enhance its dynamic and innovative business operations. Although, the Woodlands Retreat has an IT system, however, the current systems are not capable of keeping book records as well as not capable of managing all data for the company

Sign Up for Unlimited Study Help

Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.

Get Started Now