Intuitive grid style enhances the usability. esProc is a tool to script in the grid. With esProc, the computing logics can be laid out in the 2D space conveniently, so that the business algorithm can be interpreted with the computer language more easily. The grid implements an intuitive view of the code indentation and the work scope, and streamlines the cell reference and reuse. Each cell represents one computing unit/step. With the natural cell name, a cell can reference another cell mutually, needless to define variables. By clicking cells, users can monitor the computed result intuitively, needless to search in a list of variables.
Step-by-step thoughts in solving the complex computing. esProc advocates the step-by-step computing – decomposing a complex goal into several simple steps in a grid, and accomplishing each of those simple steps to ultimately solve the goal. By comparison, SQL is not a champion for the “step-by-step” computing. SQL users must finish composing all computing procedures at once before they can view the result. The SQL statements are thus inevitable lengthy and error-prone in handling the complex computing. Therefore, esProc is superior to SQL in achieving the complex computing goal for its much greater development efficiency. esProc empowers users with insight to the current cell data to develop the smart algorithm for the next step; allows for scripting for the next step by referencing the previous computing; and enables them to achieve the final goal through the incremental processing gradually and progressively.
Specialized debugging function. Based on the “step-by-step” thinking, a real useful debugging function is developed for esProc, including various functions like the break point, stepping, run to cursor, start, and end. Unlike the fake debugging script of SQL/SP, esProc can perform the debugging straightforwardly, needless to build a specific intermediate table. The break point can be set in any position without altering the code. Before proceeding to the next one step of summarizing, users can even visually check the data to ensure they are allocated to the group as specified. 90% time is spent on debugging during development. The specially-built debugging function can reduce error and development cycle dramatically.
Agile syntax for flexible computing. esProc supports the true data type of set. The member of a set can be the data of simple data types, record, and/or other sets. The set can be used to simplify the structured data computing, so as to facilitate the flexible computing from the business prospective. esProc supports the ordered set, capable of accessing the set member and performing the serial-number-related computing, for example, ranking, sorting, year-over-year comparison, and link relative ratio comparison. With the ideal “set of set” mechanism to represent the grouping, esProc can be used to solve various grouping problems easily, including those problems involving the equal, align, and enum groupings. In addition, users can operate the individual records in the data set in the same way as operating the object. Such disassociated record will give users a much more flexible access experience than ever. For many complex computing problems for SQL, esProc can represent them easily owing to its agile syntax, for example, the computing on relative positions in multi-level groupings, and data grouping and summarizing by the specified set.
All-round and well-defined database computing setup. esProc supports the character string, number, and date computing, the unary and binary operations on set; sort, select, query, aggregate, group, and join operations on structured data; e flow control statements including the looping, branch, and subroutine calling; the data retrieval, computing, modification, and write-back to databases and files; both the in-memory and external storage computing; the standalone and parallel computing; both the JDBC data source and the Excel and Txt data source; access the data stored locally, on the LAN, or in the distributed file systems. In addition, esProc features the loop function to minimize the use of most looping statements, so that the programming difficulty is reduced, technical requirements lowered, and the development efficiency improved.
esProc can greatly improve the efficiency of developing database application, and is ideal for the complex database computing, consolidating data from multi-data-source in a single-data-source report, the complex computing for report data source, the database-like computing in Java, and Java data computing layer.