Chapter 236: Database

Since the database entered commercial use, it has evolved into the third generation. After 1990, open-source databases MySQL and PostSQL appeared.

This has led many enterprises to enter the database field. Especially with the development of the Internet and the upgrading of integrated circuits, which were originally only databases used by enterprises, began to gradually become miniaturized and segmented.

There are more and more scenarios that can be used. The backgammon database was first started by Hu Shengcong's Mi Guo Branch, and the research direction given to them by Chu Qing at that time was distributed databases.

Distributed has been around since the mid-70s. However, the main function of the database at that time was to save data and meet the needs of users for data calculation.

The formal application of distributed databases began in the era of big data. The read and write performance of traditional stand-alone databases has seriously declined, which can no longer meet the needs of big data scenarios, and distributed databases with higher performance and high reliability have become the direction of development.

After the completion of the laboratory with Huawei, Chu Qing incorporated this part of the technology into the research of the laboratory.

The reason why Chu Qing launched the cash register at this time is because this part of the technology has achieved phased results.

Combined with the database, the system can automatically process some of the day-to-day data. This is a dispensable function for some small stores, but a large enterprise like Wal-Mart can allow each store to achieve accurate control, purchase, sales and inventory, and expiration date inquiry, which can be seen at a glance on the front-end cash register and terminal data.

The management efficiency shown by the efficient and accurate data is definitely not what ordinary people can imagine.

"This is a dedicated database we have built for our flagship stores across the country. Although it is currently only connected to 10 stores, it has been able to accurately summarize the daily data. "In the BBK Industrial Park, Tan Jiaodi took people from Walmart and Hills to visit the BBK data center together.

On the terminal computer of the database, after calculation, the income and expenditure of the ten stores yesterday have been summarized, and the top ten products sold in each store have been counted.

Products that are in stock rush will appear directly on the cash register at the front end. The store manager only needs to place an order with one click, and the required goods and quantities can be sent to the factory's client.

Not only does it save time, but it also allows managers to see the situation of each store at a glance.

"Of course, with our current technology, the branch database can only support up to 50 devices at a time. However, we will provide upgrade services, and when the technology is reached, we can help you upgrade and repair it for free. Saying this, Brother Tan Jiaodi glanced at it carefully, and did not find any special reaction, which made her feel a little suspicious.

The boss swore before he left that they would be interested. From the moment they came into the data center, they didn't say a word or say anything.

This made her wonder if these people were really interested in the data. However, under the silent appearance of the two gangs, there is an excited heart.

Walmart and the people of the hills, though neither spoke. But with such intuitive data processing, they all know what it represents.

Walmart has been building its own database since it entered the era of Robertson Walton.

In three years, Wal-Mart has spent nearly 10 billion yuan on this, but it can still only reach the level of distribution centers, and the reason why it cannot get through this last link and directly connect to more than 3,000 stores across the United States is that the most critical factor is the problem of small databases and cash register equipment.

Since Robertson Walton became chairman, the key to Walmart's ability to surpass Hills in the past three years is that the construction of a database distribution center can greatly improve work efficiency.

At Walmart, a distribution center, it can currently cover 50-80 sales outlets within a radius of 200 kilometers.

Typically, from any of the centers, the car can reach any of the stores it serves within a day to guarantee timely delivery.

However, if you have a branch database and open up the connection between the branch and the data center, then the most direct manifestation is that the coverage area of the distribution center can be directly expanded by half.

The most intuitive reflection of the efficiency improvement is that with more time, more can be done. At that time, a distribution center only needs to be equipped with more distribution vehicles, and the coverage radius can be increased from 200 kilometers to more than 350 kilometers, and the sales outlets that can be served can at least exceed 100.

Each of Walmart's distribution centers is huge, with an average area of more than 110,000 cubic meters, the size of 24 football fields.

There are an average of 100,000 types of products imaginable, from toothpaste to televisions, sanitary napkins to toys, needles and threads to furniture and department stores.

You must know that every time Wal-Mart builds an additional distribution center, it needs to invest hundreds of millions more. If this equipment is really used in supermarkets, the cost savings from the construction of distribution centers alone will be as many as billions of dollars.

Historically, in order to open up the branch link, Wal-Mart invested 160 billion yuan in 1999 to rebuild the logistics link, of which 50 billion yuan was spent on database construction.

It was also at that time that Wal-Mart developed a set of smart systems for branch use, and a PC was used to connect to the host system used by the headquarters.

In order to achieve this function, Walmart bought countless servers and PCs at that time, and it was barely able to do it.

With this system, everything that happens every day in all Wal-Mart's stores and distribution centers around the world, as well as detailed information such as purchase, sale and storage related to operations, can be transmitted to the data center through the backbone network and communication satellites.

As early as the early eighties, in order to grasp the real-time information of commodity distribution, they launched a logistics communication satellite under the strong advocacy of several directors and technical directors of the company, so as to monitor the distribution progress of each commodity at any time.

In terms of the use of technology, it has to be said that Walmart is ahead of the hills. On the contrary, the reason why Hills Department Store finally went bankrupt was that in addition to its debt problems, the biggest reason was that it could not keep up with the times.

In the early 90s, Wal-Mart had begun to use the distribution center + database model to build a large-scale distribution center, and Hills was still using the means of commodity storage and transportation in the 50s.

The cost of product storage and transportation alone accounted for 8 percent of total sales, while Wal-Mart's product storage and transportation cost was only 3 percent at that time.

[The problem of slow update of new chapters has finally been solved on the app that can change the source, here download huanyuanapp to change the source app, and view the latest chapters of this book on multiple sites at the same time.

The issue of reform, in fact, is more urgent than Wal-Mart. Such a set of equipment with a complete solution has improved them more than Walmart.

So when they saw such a set of equipment, although the people of Hills didn't say it, they were already happy in their hearts.