esProc Advanced

esProc Advanced is a business computing software, which is professional in Big Data computation with high performance and simplifying complex data computation, reducing cost of software and hardware as well as management expenses and enhancing 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. Computational Middleware esProc has a complete computational system with support of multi-node parallel computation and also can be used as Big Data computation middleware to bear the computing pressure from database, HDFS or Local File and return the result to applications. esProc is excellent with complex logic computation and external storage 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 storage 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. Development Tool As a database computation script, esProc is particularly doing well solving complex task in database 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 professional IDE and grid-style editor, enabling more visual code indentation and work scope. Programmers can refer the previous computation results by the 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 as JDBC, making it an ideal tool for complex computation or calculation 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 database script, enabling agile and easy-to-use statement for the interactive analysis of structured data, and is especially professional 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 calculation results and realize multi-step complicated analysis, capable for real-time computing and analysis.