Alleviate computing pressure. The overload and intensive computing will occupy too many CPU and memory resources of the database server. Such computings include the massive data computing and the great computing workload involving a few data but lots of computing steps. Users who are kept waiting for response will surely complain about the unsatisfactory experience. Moreover, the overload operation will definitely shorten the life of server. esProc has an all-round and well-defined computing setup, which is fully capable of sharing the workload on databases, and undertaking various computing of whatsoever difficulty for applications. In addition, esProc supports the parallel computing across multiple nodes. By taking this advantage, the massive data computing and the great workload can be equally allocated to multiple average servers or inexpensive PCs. In this way, organizations can achieve an overall outstanding performance much superior to database servers while still meeting the node hardware provision requirements far lower than that of the database servers.
Alleviate pressure on storage. For the sake of safety, performance, and usability, all kinds of application systems will not manipulate the core business data directly. Instead, the core business data will be processed in the form of temporary table/intermediate table for the direct use by application. Such redundant data and the associated SP would occupy a great many of storage spaces in the database, resulting in great storage pressure on database. esProc features the mechanism of computing in external storage, so as to store the intermediate database data into files on inexpensive HDDs, and remove the need for database storage spaces. Through esProc JDBC, applications can access to these data stored in external storages and perform the standard structured data operations like query, compute, and modify. esProc also supports the external storage file retrieval and write-back to HDFS, resulting in a much greater overall storage space on HDFS than that of any high capacity database.
Alleviate the pressure on concurrency. The enterprise level report applications or Web applications generally involve a great number of concurrent accesses and ultimately incur great pressure on database. The database would reject the computing requests from users because all connection quotas have been used up. On the one hand, it is an effective and expensive means to solve the problem by upgrading the database hardware and buying more user licenses. On the other hand, limiting the number of concurrent connections and reducing the response will cut down the database cost while compromising the user experience and productivity. esProc solves the dilemma that the database cost can be lowered while alleviating the pressure of concurrency on database. esProc supports the parallel computing. The computing task, which organizations used to solve centrally, can now be equally decomposed and allocated to multiple average PCs. Each node only needs to undertake a few data computing jobs.
Data Administration Tree. The database is the flat directory. All data sheets are placed together with no means to administrate by level. Such situation is also true for SP. What’s worse, the intermediate table and its corresponding SP can only be stored separately. In other words, they cannot be placed under a same directory. The flat directory is the root of disorderly management of data, permission, and application. The public and private SPs become entangled, the intermediate tables for the sales or the production application get messed up. By comparison, esProc features the trouble-free storage computing, managing the data and computing files with an organized file system, and implementing all managements easily in a directory tree. The data can be placed according to the category and hierarchy. Various sub-directory can be arranged for various modules. The name of directory clearly indicates and differentiates the corresponding data from the new and the legacy systems. The data can be stored in the same place of the corresponding computing script. The backup import, output, and recovery can be done with several simple actions of copy & paste. With esProc, the data management becomes simple and clear.
Cut the database cost. With esProc, users can store the core data in the database. To maintain the computing and the security for important data, relatively less overhead, hardware provision, and user licenses are required. The intermediate tables and script files derived from the core data are all stored outside the database. By doing so, the parallel computing of the big data and high degree of concurrency can be implemented on the inexpensive PCs. The data expansion can be solved easily with the HDFS and inexpensive HDDs. By reasonably leverage resources, the workload pressure on database can be effectively alliterated, and database cost kept under control, management problems solved effectively, and various database applications handled with ease. These applications include the real-time high performance application, non-real-time big data application, desktop BI, report application, and ETL.