Data Analysis
It is quite common that the information implied in database cannot be acquired simply with one or two SQL statements. In addition, the application of pre-designed complex computing lacks of the flexibility.
esProc implements the interactive and powerful computation mechanism for structured data (RDB or xls/txt). The highly resilient computation capability makes OLAP become real.
Data Preparation
Although there is a constant need to process the data like filtering, sorting, summarizing and then submitting in a different format for various applications, It is relatively hard to achieve it with the stored procedures or other programs.
By comparison, the powerful computation ability of esProc will greatly reduce the difficulty, and make it quite easy to integrate it in main program.
esProc IDE is a desktop application. You can get the result instantly on typing the computation code into esProc cellset. Further computations can still be conducted on the existing results step by step to reach the final goal of a successful online analysis. In addition, esProc allows for the repeated execution, that is, the program can be developed once and reused for multiple times. Alternatively, you can choose to execute the program from the command line.
esProc JDBC packages the computation engine of esProc into a standard JDBC driver. For other programs to invoke and get the computational result accordingly, the esProc program is simulated as the stored procedure. The particularly impressive feature of esProc is to act as the datasource to the reporting tool.
esProc provides the next-generation model for structured data computation, which integrates the advantages of both SQL and high-level languages.
SQL has the complete computational ability as the commonest language in database computations, the level SQL supports is relatively too low. In particular, the non-stepped computation, unordered set, incomplete set-lization, lacking the object reference, which makes it cumbersome and difficult to comprehend when using SQL to complete the data computation.
esProc is superior to the SQL. Regarding the same issues, esProc accordingly establishes the stepped thinking, set thinking, serial number thinking, reference thinking, and other thinking modes, based on which, it is much simpler, clearer, and more efficient than SQL. Effort halved, result doubled.
Intuitive and clear coding style, stepped mechanism by nature, and complete controllogic –cell-style code will give you a brand new experience of scripting.
The ever present ordered set and dissociative record objects make every type of aggregate computation much more convenient, the order-related computation can be implemented easily.
Record and Set Reference can handle the references between tables well. It is not only clear in writing, but also efficient in computing. Moreover, the actual meanings of foreign keys can be embodied in practical operations as it should have.
Multiple Set-style Groupings are provided in esProc to handle various targets, so that the essence of group computation is reflected to the full and the group result is utilized to the utmost.