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 designed for application programmers to handle computing strongly related to the typical and complex business facts. Without any inheriting, overload, and other complex concepts, it is a development language neither object-oriented, nor fit for developing the infrastructure or the whole tool software. ...
Reorganization of the report data source: esProc is especially fit for the computing involving the complex business algorithm of data sources or the cross-database computing involving multiple data sources....
esProc is the professional database computing script, featuring the intuitive grid-style code. Without difining the temporary variables, users can reference the intermediate computing result with the cell name. By taking this advantage, users can implement the step-by-step computing easily. ...
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. ...
Here are some screen shots for you to have a deeper insight on our product, include Cellset-style Script , SQL Execution and Data Structure Display, Program Debugging ,Computation Presentation etc...
1
According to the contract table in database, compute in a Java application: Monthly top N quality customers on sales amount in a specified year....
2
Take esProc as the computing layer for Java to find out: Customers who have bought the specified product. There are two tables in database. Part of the data is as below. The main train of thought is:...
3
The order data of customer is 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. And the optional reporting tool only supports...
4
Find out staffs with the highest sales amount in various promotional periods according to the original data in the database. There are two tables, SaleRecord and Promotion. From Promotion table we can...
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
  3. Progressive query
Serial Number Related Query
esProc is very good at order and position related computing with the record set originally ordered.
  1. Median
  2. Select subset according to the position
  3. Compare over the previous period for selected records
  4. Select rows from the group subset
Readability of Syntax
The grid-style script of esProc displays the data intuitively and neatly. Meanwhile, esProc provides various unique functions to easily deal with varied complex queries.
  1. Constant sets
  2. Find records with the maximum and the minimum
  3. Sort by specified order
  4. Group rows by the specified order
  5. Overlapped conditional groups
Complex Queries in Steps
With step by step computing and program logics, esProc allows users to get results according to users' understandable process.
  1. Filter accumulated value
  2. Compare over the previous period for consecutive intervals
  3. Compute cross rows in group subset
  4. Progressively complete the result set
Set-operation Related Queries
esProc supports complete set-lizing operation enabling users towrite codes following their natural thought pattern.
  1. Filter the groups
  2. Sort the groupings
  3. Select a group subset
  4. Sort and filter the group subset
Relational Query with Multiple Tables
esProc supports union of data sets with different data structure, bringing simpler coding and computing.
  1. Union tables with different structure
  2. Reference of the record associated by foreign key
  3. Query the subtable
  4. Group the subtables

Contact us   today to  discuss  your esProc solution or  Download esProc  
esProc is innovative desktop BI software and business computing script. With this new desktop BI software and business computing script, users could conduct complex computing and analysis easily. This desktop BI software or business computing script allows users to do data manipulation freely. Users can divide complicated problems into simple objects with the desktop BI software and business computing script. esProc is more capable desktop BI software as well as business computing script than SQL and R. The cell-style interface of this desktop BI software or business computing script makes computing more visual. With this desktop BI software and business computing script, users without high technical background can analyze complex data in a simple way. Users can free download this desktop BI software and business computing script at Raqsoft website. Step-by-step computing of the desktop BI software and business computing script can simplify complex problems. Business users can write script with this desktop BI software and business computing script. Various data sources access is available with this desktop BI software and business computing script. Differences between desktop BI software & business computing script and traditional BI tool are the ease of use and problem solving. Desktop BI software or business computing script is also powerful. Desktop BI software or business computing script features with high efficiency. Users can use desktop BI software and business computing script without Internet connection. Desktop BI software or business computing script is also cheaper. This doesnt mean that desktop BI software or business computing script has low quality. Desktop BI software means BI on the desktop. Desktop BI software and business computing script are ideal choice for users. Why do you need desktop BI software or business computing script? How do desktop BI software and business computing script help you? Why not choosing desktop BI software or business computing script for complex computing? Why desktop BI software or business computing script is superior to other BI tools? Which one is better: R, or desktop BI software or business computing script? You never know what your data can give you unless trying desktop BI software or business computing script. Desktop BI software or business computing script will become the king. Desktop BI software or business computing script will rule the world of BI.
esCalc keeps the basic functions and using style of spreadsheet, but is completely beyond traditional business spreadsheet software on complex tabular data calculation. Traditional business spreadsheet lacks the capacity of integral calculation on business data, for example, when pasting a formula, other spreadsheets only permit adjustment of relative position, resulting in a business rule violation, while adjustment with esCalc can be finished automatically and intelligently focusing...
esCalc enables abstract and complicated data computing to be more concrete and visible. The computing which needs script writing with SQL Statement, R language, esProc script, etc., now can be easily done through visual operation. First, users' operation objects are not abstract data structure but the specific business data; then users can select the operational actions from the menu, such as, query, group, sort, filter, rank, join, union, etc., corresponding...
The traditional reporting tools usually need higher technical requirements, such as retrieving script, complex report expressions, and abstract logic. While with esCalc, users can complete the entire report independently without technical background.
First, esCalc provides retrieving data UI to guide static data extraction from the database, Excel or text files. Second, its ease-of-use and traditional Excel-style user interface allows business users...
Business users can use esCalc to conduct a serial of business intelligence computing on their desktop.
esCalc is professional reporting tool with capability of creating various tables and graphs. This more powerful spreadsheet has a more intelligent table calculation engine. With visible operation, esCalc can realize the corresponding functions of SQL without writing scripts since it is visualized data computing tool. esCalc can be used as the calculator of...
Through the level settings, rows are associated to each other. The multi-level structure can describe the data in the real business more completely. Free and convenient grouping operation with outstanding performance and the usage is quite simple. It is the real grouping that you can sort, filter, and perform other operations on each group and the data ...
The data with the same business priority will be set in the homorow. The appearance property of homocell in the homorow will be processed concurrently. Through the formula migration of homocell, calculations of the same business logic will be completed all at once. Given the below table of the technical data of pitchers of some baseball teams ...
Utilize the settings of homorow and level, recognize the true objective of computation smartly. The formula in homocell will be auto-migrated, no need to copy and paste. In the below table, given the statistics of the most frequently used surnames in some countries, calculate the proportion taken by the total population of people with this surname in each region ...
Full support for sets, and capable to handle the sum, subtraction, intersection, union, and other operations on sets directly. The sets exist in the form of object, making the summarization more intuitive and easy to read and write. Given the score statistics for the last three games of a certain basketball team, make statistics on players whose scores are among ...
Stepwise operation to solve the complicated problem progressively. Instant presenting the result, intuitive, and easy-to-use. Given the payroll of a company below, select out the male employees of which the wage are higher than that of any female employee in their department. ...
Handle the multi-level join automatically according to the level and master cell settings. Operation style is similar to the copy & paste, convenient and intuitive. In the below table, there is the population data of some states and the abbreviations are set as the master cell ...
As a desktop BI tool, esCalc is specialized in various data process from database, text, and Excel files. It is user friendly, easy to install and use, and does not require high technical background. esCalc can operation functions like locate, filter, sort, group, align, join and union through menu to complete various complex data analysis between multiple tables. ...
Data analysis and report preparation are widely required practically in business for the management of inventory, sales, and human resources, etc.,like the statistics on the client and sales data. It's essencial for users to realize self-analyzing and self-reporting. Spreadsheet is the most widely used desktop data process software, but the traditional spreadsheet lacks the ability of computing the complex analysis...
esCalc has implemented the complete set-lization for you to conveniently perform the set operations, such as intersection, complement, and union.With the multi-level structure, the practical business can be described in a better way to implement the real grouping. Based on the multi-level structure, various data file can be associated to implement the join and union ...
Rich and perfect format setup and pagination features to support various charts.Excel-style interface for easier report design and more convenient operation.Rich data analysis features to complete various analysis operations like statistics, grouping, sorting, and filtering. System Requirements...
Here are some screen shots for you to have a deeper insight on our product, include Cellset-style Script , SQL Execution and Data Structure Display, Program Debugging ,Computation Presentation etc...
Find shares from the daily trading stocks which had risen on five consecutive days. The picture below is original data in Excel and final computing result...
Make a grouped report on link relative ratio and year-on-year basis according to the database of various cars' sales, and compare the car sales of each year with chart. There are car orders of the past 3 years in the original database...
Compute the real wages after joining the performance and attendance tables to StandardWages sheet by Employee ID. Original data is stored in 3 Excel sheets: standard, absence and performance as below....
Find the monthly top 5 outstanding salesmen according to the daily sales records in the database. Original daily sales records of each salesman in the year are shown below...

Contact us today to discuss your esCalc solution or Download esCalc
esCalc is easy to use business spreadsheet software, the self-service BI tool as well as an Excel alternative. This business spreadsheet software, Excel alternative as well as self-service BI tool is very smart. With this self-service BI tool, business spreadsheet software and Excel alternative, users dont need to seek help from IT department. This self-service BI tool, business spreadsheet software and Excel alternative has cell-style interface similar to Excel. Besides, this self-service BI tool, business spreadsheet software and Excel alternative is totally free. Any user who knows about Excel can learn this business spreadsheet software, the self-service BI tool as well as an Excel alternative easily. This business spreadsheet software, the self-service BI tool and Excel alternative is superior to Excel on complex computing. With multi-level structure, this business spreadsheet software, the self-service BI tool and Excel alternative is very intelligent. Users without VBA experience also can conduct complicated computing very easily with this the self-service BI tool, business spreadsheet software and Excel alternative. Compared with other business spreadsheet software, self-service BI tool or Excel alternative, esCalc has its own feature. Why Excel needs esCalc, the Excel alternative, business spreadsheet software, the self-service BI tool? How to choose good business spreadsheet software, the self-service BI tool as well as an Excel alternative? Do you know why do you need business spreadsheet software, the self-service BI tool as well as an Excel alternative? Where do you get business spreadsheet software, the self-service BI tool as well as an Excel alternative? esCalc, the business spreadsheet software, the self-service BI tool as well as an Excel alternative is very cheap. Besides, business spreadsheet software, the self-service BI tool as well as an Excel alternative has high quality. Business users can learn this business spreadsheet software, the self-service BI tool as well as an Excel alternative easily. This business spreadsheet software, the self-service BI tool as well as an Excel alternative is a data calculator. Also, this business spreadsheet software, the self-service BI tool as well as an Excel alternative can help reporting tools. For complex computing, this business spreadsheet software, the self-service BI tool as well as an Excel alternative is the best choice. How do you think of this business spreadsheet software, the self-service BI tool as well as an Excel alternative? You can try this business spreadsheet software, the self-service BI tool as well as an Excel alternative for free. Which one is better: business spreadsheet software, the self-service BI tool, Excel or Excel alternative? How do you use business spreadsheet software, the self-service BI tool or Excel alternative? Compared with other business spreadsheet software, this business spreadsheet software, the self-service BI tool as well as Excel alternative is smarter. If you want this business spreadsheet software, the self-service BI tool as well as Excel alternative, dont forget to contact us.