May 30, 2014

Features:Rich In-built Library Functions

esProc offers abundant library functions to support the group,loop, sort, filter operations on set, and ordered set. 
Group and loop: 

In the above figure, A4 is the loop statements, and B4-B10 is the internal part of the looping.

esProc supports the basic grouping, align grouping, and enum grouping operations. Unlike SQL, the grouped data in esProc is presented in the set. Each member of the set is of the generic type corresponding to a set of data. Grouping and summarizing can be conducted step by step. Thus, the grouping result can be reused.

Sorting and filtering is the typical syntax of structured data, and esProc provides the easy-to-use loop functions for it In addition, esProc loop function minimizes the use of most looping statements, so that the programming difficulty is reduced, and the development efficiency improved.

Operations on set:

esProc supports the concatenation, union, intersection, difference, multiplying, aligning, aligning comparison, comparing, and several other operations. In addition, it also provides algorithms for retrieving member forwardly or backwardly, subset operations, copying, arranging member reversely, and transposed matrix.

Ordered set:

The “ordered” indicates that the data is stored in a certain order. Each component of each piece of member has the absolute or relative number for users to retrieve data and perform other operations in order, such aslocating, ranking, and sorting.

esProc supports the ordered set. The serial number is a convenient device for users to retrieve the set member and perform the order-related computing easily. The ordered computing is the typical tough problems of SQL. 

For example, to retrieve the data in the relative position. It is referred to as the top or bottom ones (groups) of the current record (group). By taking the advantage of the ordered set mechanism of esProc, users can solve such problems easily.