esProc boasts the outstanding computingcomputing capability and high performance in solving the complex problems for preparing the report data sources by supporting multiple data sources, and non-database computing esProc offers a user-friendly IDE, enabling reporting tools to reference the computed result conveniently through JDBC interface. It is really an ideal development tool tailored for the report developers. ...
esProc is ideal for the ETL of complex business logics. To date, there is not any other existing modules for such tasks yet, while scripting is always required to implement ETL.With the professional esProc IDE and grid-style scripts, users can develop more efficiently. esProc is good at achieving the complex computingcomputing goal, in particular the ETL hardcoding. ...
esProc is the specially designed database computing script, which boosts the development efficiency for JAVA, report, and Web applications. esProc boasts an intuitive grid style, step-by-step computing model, specialized debugging feature, agile syntax, and the all-round and well-defined computing setup. ...
esProc is the middleware specially designed to undertake the computing jobs between database and application. For the application layer, esProc has the easy-to-use JDBC interface; For the database layer, esProc is powerful in parallel computing. By implementing the computing outside the database and the computing in external storage, esProc alleviates the computingcomputing pressure on the database & storage and the pressure of concurrency. ...
esProc is the parallel computing solution designed and optimized for the medium and small clusters, supporting multi-thread computing on single node, and multi-node parallel computing without center. esProc is especially ideal for the huge data volume, great computingcomputing workload, high concurrency, and heterogeneous multi-data-sourcesn. ...
esProc is an easy-to-use desktop tool for business computation, in particular the complex computational goal. esProc is fit for the business personnel with the basic IT capability. esProc is characterized with a style of grid in which the complex business computational goal can be decomposed into several simple objectives. As a tool specially designed for business experts, esProc boasts an easy-to-grasp syntax and requires quite less IT background for users. ...
esProc enables users to write codes following natural thinking straightforwardly, not having to change their train of thoughts in converting the complex business logics into practical codes. To complete the same computing, esProc is several timesmore neat and concise than Java and SQL. ...
esProc is specialized incomputing from various different data sources, and the computing result can be written back to multiple or single data source. esProc ont only supports the rational database, MongoDB, Cassandra,and other NoSQL database, but also provides a great many functions to handle the structureddata and the semi-structureddata computing....
esProc supports the multi-thread computing on single node and parallel computing on multiple nodes without center. The big data can be divided into several small data blocks, then used in multiple node machine for parallel computing, and lastly merging andcomputing....
esProc optimizes the syntax for the structureddata, supports the in-memory computing and ordered set, and enables programmers to select the optimized path based on the characteristics of data and algorithms. The actual measured data indicates that the performance of esProc is close or even higher than that of database for the standalone machine. ...
esProc is the pure Java product, with the outstanding integration capablity by nature. esProc can be divided into four sections: JDBC, Command line, Server, and IDE. The JDBC is the specific calling interface for applications. The invoking method of esProc JDBC is similar to the stored procedure of normal database, i.e....
esProc is a data computing language with the powerful TSeq and cursor data object. It is especially optimized for the computing over (semi) structureddata, and capable of handling various complex computing problems easily. Because it is designed to serve the sole purpose of computing, esProc is simply structured and easy to grasp. ...
esProc is a programming language specializing in structured and semi-structured data analytics and processing, and is more efficient than SQL,Java,perl,python and R language.

It is designed for application developers and data analysts, especially to conduct complex business logic based multi-step computation. It realizes multithreaded parallel computing with simple and concise code.

detail...

esProc is fit for the following scenarios:

1. Reorganization of the report data source.

2. As the middleware for JAVA computing.

3. As class library of structured computing for JAVA.

4. Historical data analytics.

5. Regular summarizing and clearing.

detail...

Pure JAVA-based, esProc boasts complete computing system and agile syntax, and thus supports high performance parallel computing.

It can effectively improve computational power, increase development efficiency, reduce database traffic, and optimize data management.

detail...

esProc comprises four parts: IDE, JDBC, Command Line, and Server.

esProc can run in JDK1.6 and above environments across platforms independently, not relying on other servers or middle ware.

detail...

1
According to the contract table in database, compute in a Java application: Monthly top N quality customers by sales amount in a specified year....
2
Take esProc as the computing layer for Java to find out: Customers who have bought the same specified products. There are two tables in database. Part of the data is as below: ...
3
The customer order data is stored in ERP system and the customer information is stored in CRM system. Now we need to create a report to present the annual sales amount of each customer and the growth rate compared with the previous year....
4
Find out staffs with the highest sales amount in various promotional periods according to the original data in the database....
Continuous Relational Query
esProc supports using dissociative records as variables, thus enables users to make full use of the intermediate results.
  1. Dissociative record
  2. Record set storage