esProc provides a grid user interface similar to excel which enables users to perform codes in a grid from left to right, top to bottom. Each cell has unique and naturally named coordinates with column and row number, so users can reference the calculation results of other cells conveniently through the coordinates for further processing.
The cell-style interface makes codes presented with natural formatting, natural alignment, naturally indent and thus makes typesetting unnecessary. The grid style codes not only makes the code neat and clean, but also offers users a intuitive way to organize and arrange the relationship between the computation steps, and thus easier to pierce the heart of a problem and solve complicated problems.
- Cells can hold the result and is stepwise by nature.
- The intermediate result can be referenced by row and column numbers. This is much simpler than the traditional scripts.
- Stepwise computation is not supported in SQL, and thus the computation complexity is increased.
|1||=db.query(“select * from Employee”)|
|Employees born in and after 1970|
|Male employees born in and after 1970|
- Complete flow control, including the branch judgment and loop statement, nested multiple branches, and multiple recursions.
- The logic control is implemented with a language similar to BASIC. Compared with JAVA/C++ and other high level languages, the language of esProc requires a far lower knowledge level to start learning.
|Bubble sort algorithm|
|Switch out of the loop|
|4||for B2>0||=A1(B2)||Swap the menber during inner loop|
- esProc cells are of the natural delimiters and indentions
- With the cell as natural delimiter, the alignment of constants is effortless
- With the cell as natural indention, the loop/branch statements have got the natural and clear scope
- The cell-style code enables a more clear and easy-to-read multi-nest, you will never get caught up in an awkward situation of messy levels of nesting (such as the typical bracket pitfalls of }}}} in Java)
|The loop body is marked with red rectangle|
if A7.Gender==”Male” && A7.Age>25
|The statements marked with green rectangle is executed when the condition of the if statement is true|
|9||>A6=A6+A7.Salary||Total salary of male employees above 25 years old|
|The statements marked with blue rectangle are executed when the condition of the if statement is not true|
|11||>B6=B6+1||Total salary of other employees|
With esProc, you can code, run, and return the result instantly. Therefore, the interactive analysis can be implemented easily.
|1||Jonney Deep||Robert Denim|