Scripting ability for High Programming Efficiency
Solving complex computations in a stepwise manner. esProc promotes the step-by-step computing – which divides a complex goal into several simple steps in a grid and accomplishing each of those simple steps to ultimately achieve the goal. By comparison, SQL attains a goal in a different way. Users must finish composing all computing procedures before they can view the result. The SQL statements are thus inevitably lengthy and error-prone. Therefore, esProc is superior to SQL in achieving the complex computing goal in both performance and efficiency. esProc empowers users with insight to the current cell data to develop a smart algorithm for the next step; allows for scripting the next step by referencing the result of the previous steps; and enables them to achieve the final goal through incremental processing.
Reliable debugging function. Based on the “step-by-step” model, a real useful set of debugging functions are developed, including break point, stepping, run to cursor, start, and end. Unlike the fake debugging script of SQL/SP, esProc can perform debugging straightforwardly, without the necessity to build a special intermediate table. The break point can be set in any position without altering the code. Before proceeding to the next step of summarizing, users can even visually check the data to ensure they are allocated to groups as specified. 90% of time is spent on debugging during development. The specially-built debugging function can reduce errors and dramatically shorten development time.
Agile syntax for flexible computing. esProc supports set-type data . A member of a set can be of a simple data type, a record, or a set. Using sets can simplify the structured data computing, so as to facilitate the flexible computing from the business prospective. esProc supports ordered sets, capable of conveniently accessing set members and performing serial-number-related computing, including ranking, sorting, year-over-year comparison, and link relative ratio calculation. With the “set of set” mechanism to represent groups, esProc can use equi-grouping, alignment grouping and enumeration grouping to solve various grouping problems easily. In addition, users can deal with individual records in a data set in the same way as handling an object. Such discrete records will give users a much more flexible access experience than ever. For many complex computing problems that are difficult to solve in SQL, esProc can represent them easily thanks to its agile syntax, for example, getting relative positions in multi-level groups, and data grouping and aggregation by the specified set.
All-around and well-defined database computing system. esProc is able to perform string manipulation, number crunching, and date handling, as well as unary and binary operations on sets; provides sort, select, query, aggregate, group, and join operations on structured data; offers flow control statements including loop, branch, and subroutine calling; facilitates data retrieval, computing, modification, and write-back of database data and file data; supports both the in-memory and external memory computing, and both standalone and parallel computing; supplies full support for JDBC data sources and Excel and Txt data sources; and makes access to the data stored locally, on the LAN, or in the distributed file systems available. In addition, esProc features loop functions to minimize the use of most looping statements, so that programming difficulty is reduced, technical requirements lowered and development efficiency improved.esProc can greatly increase the efficiency of developing database application, and is ideal for complex database computing, consolidating data from multi-data-source in a single-data-source report, complex computing for report data source, the database-like computing in Java, and Java data computing layer.