Alleviating computational pressure. The overload and intensive computation will occupy too much CPU and memory resources of database server. Such computations include massive data computing and great computational workload involving a little data but lots of computational steps. Users who are 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 computations of whatsoever difficulty for application. In addition, esProc supports the parallel computation across multiple nodes. By taking this advantage, the massive data computation 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.
Alleviating 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 large storage in the database, resulting in great storage pressure on database. esProc features the mechanism of computation 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 structural data operations like query, compute, and modify. esProc also supports 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.
Alleviating 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 computation requests from users because all connection 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 licenses. On the other hand, limiting the number of concurrent connections and reducing the responsivity 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 computation. The computation task,which organizations used to solve centrally, can now be equally decomposed and distributed to multiple average PCs. Each node only needs to undertake a few data computations.
Tree-structured data organization. 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 the 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 computation, managing the data and computation files with a organized file system, and implementing all managements easily in tree-style directories 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 computational script. The backup import, output, and recovery can be done with several simple actions of copy & paste. Thanks should go to esProc, the data management becomes simple and clear.
Cut the database cost. With esProc, users can store the core data in database. To maintain the computation 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 computation 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 application handled with ease. These applications include the real-time high performance application, non-real-time big data application, desktop BI, report application, and ETL.