esProc is a high performance business computing software specialized in Big Data computing. It can simplify complex data computation, reduce cost of both software & hardware and management expenses, and enhance the computation development efficiency of Java programs and reports. According to different situations, esProc has three major applications: computational middleware, development tool and desktop BI tool.
esProc has a complete computational system with support of multi-node parallel computation and also can be used as Big Data computation middleware to alleviate computing workload from database, HDFS or Local File and return the result to applications. esProc is excellent with complex logic computation and external-memory computation, but it cannot replace Database. It also can store temporary data tables which occupy expensive database hardware resources in cheap PC and implement external-memory computation, and those files will be managed in an intuitive tree-structured directory. esProc can summarize data after simple queries. It has higher performance than MapReduce, and this advantage is more obvious when fewer nodes are employed. Appointing HDFS, esProc could achieve distributed data storage and computation.
As a data computation script, esProc is particularly doing well in solving complex task in data computation, featuring with step-by-step computation, explicit set, ordered set, object reference, etc. esProc can be used as development tool for JAVA computation and provides specialized IDE and grid-style editor, enabling more visual code indentation and work scope. Programmers can reference the previous computation results by cell name, observe and debug every step, and obtain higher development efficiency. As computational tool on data sources of reports, esProc can retrieve data from multiple data sources within a single script, compute and output via JDBC, making it an ideal tool for complex computation or computation among different data sources in report development. In addition, esProc can be used as hard-coded ETL development tool.
Desktop BI tool
esProc is a data-computing script, enabling agile and easy-to-use statement for the interactive analysis of structured data, and is especially specialized in dealing with complex, flexible or occasional data. esProc is a plug-in-play desktop software, no deployment, extra server and technical team required. esProc does not require data modeling in advance, allowing users to freely conduct data analysis. It can conveniently reference and process the prior computation results and realize multi-step complicated analysis, capable for real-time computing and analysis.
A Desktop Application of Plug and use Design
Prepare Test Data for Sales Management System
Statistics on Sales Values of the Top 3 Salespersons Distributed in Respective Product Categories