Third article from Excel spreadsheet to database

One by EXCEL What is the difference between a company that handles business data for various departments and a company that uses a unified database to store business data used by various departments and provides a large number of different user interfaces to the users?

EXCEL spreadsheets are the functions of data and manipulating data within the same horizon. The sales department uses the data in its own Excel table to store the data in its own Excel table, purchasing it with its own Excel the data in the table, finances the data in your own EXCEL table. These data are stored geographically in the EXCEL tables used by each department , and are not closely related. Perhaps, different departments for the same objective entity coding (Coding) with different rules, so that the rule is similar to the reunification of the Qin Dynasty six countries before the era, each country has its own language, there will be obstacles in communication, communication costs inevitably increase.

the data in the database is similar to the magic, to the various departments of the EXCEL the data in the table is absorbed into the database, then encapsulated, combing the internal logical connection of the data of each department, unified centralized storage in the database, unified coding rules, like the Qin Dynasty unified six countries after unified text, communication with the same type of text ( Coding ), will make communication more smooth, save the cost of communication, different departments of users in different PC you will see a different interface ( WINDOW by manipulating these interfaces, you can add data to the database, query the data in the database, modify the data in the database, and generate reports on the data in the database. Today's ERP basically adopt b/S architecture, database server and application server are used to manage the data in the database and provide the user interface and business processing logic of the program code, And the end user often as long as his PC can be networked, equipped with a certain browser can access the system. This makes the maintenance of the data and application code maintenance more centralized, and the desktop side of the maintenance workload drastically reduced, so that the Enterprise Information Department personnel work has been optimized, but also make the ERP can be applied to a broader geographical scope. the advantages of the b/S architecture are enhanced by concurrent processing mechanism, shared file system mechanism, and secure network protocol HTTPS .

but only on the user level, EXCEL provides a rich and useful user interface for the data processing function is any one ERP The user interface of the software cannot be compared. But from the development trend of information processing system, the emergence and development of database technology makes it possible to develop large-scale enterprise application. This represents the development trend of an information industry.

Third article from Excel spreadsheet to database