category:Uncategorized

esProc Assists Report Development – Dynamic Datasources

Reporting tools, such as Jasper Report and BIRT, don’t have enough support for multi-datasources, leading to complicated Java program for realizing dynamic datasources. But by using esProc to assist the reporting tool, this won’t be a problem anymore. The following example will teach you how esProc works to realize the...

2015-01-21 1152 0 0

esProc Assists Report Development – JOINs across MongoDB and MySQL

It is difficult to handle operations involving heterogeneous or multiple datasources, such as joins across MongoDB and MySQL, using the reporting tool, like Jasper Report, alone. Indeed Jasper Report and BIRT have the virtual data source or the table join and other functions to deal with them, but the functions are onl...

2015-01-19 778 0 0

esProc Assists Report Development – JOIN Operation in MongoDB

Heterogeneous datasources are frequently needed in report development, but they are difficult to realize using the reporting tool, like JasperReport, alone. To present the result of joining two MongoDB collections together, for instance. Though JasperReport has the functions of virtual data source or table join, but th...

2015-01-16 1299 0 0

esProc Assists Report Development – Realization of group_concat

Quite a few unconventional statistical computations are difficult to handle with the reporting tools, like Jasper or BIRT, alone or in SQL. For example, to achieve an effect in a report similar to that of the group_concat function based on MS SQL/Oracle. Having a powerful, integration-friendly computational engine for ...

2015-01-14 1289 0 0

esCalc Solves Spreadsheet Problems –Explicit Set Operations

Users often need to perform set operations in Excel, which, however, doesn’t directly support data of set types and thus cannot deal with set operations like intersection and union. The operations can only be realized using lookup functions like VLOOKUP or through special techniques, with great difficulty though. esCal...

2015-01-08 763 0 0

esProc Improves Text Processing – Parse Logs with Arbitrary Number of Lines

When parsing logs into structured data, we often find that the records consist of a variable number of lines. This makes the conversion, as well as the corresponding operation, quite complicated. Equipped with various flexible functions for structured data processing, such as regular expressions, string splitting, fetc...

2014-12-31 815 0 0

esCalc Solves Spreadsheet Problems – Inter-row computation of Continuous Summary

It is difficult to perform inter-row computation of continuous summary value in Excel. Usually we have to enter all formulas by hand, which is a taxing job and easy to get wrong. This is because Excel can merely copy formulas mechanically based on relative position and cannot process the formulas of inter-row computati...

2014-12-24 774 0 0

esProc Improves Text Processing –Batch String Replacement

During text processing, sometimes we need to replace multiple strings in the source file according to a criteria file. The command line can be used to replace a single string, but it cannot realize the batch string replacement. High-level languages can only handle this task through complicated multilayer loops. If the ...

2014-12-19 841 0 0

esCalc Solves Spreadsheet Problems – Inter-row Computation of Summary

Excel has difficulty in performing the inter-row computation of summary value, because it lacks a smart adjustment mechanism and can only copy the formulas based on their relative positions. Therefore it requires entering the formulas by hand, which is not only a laborious job but easy to get wrong. But in esCalc, you ...

2014-12-17 844 0 0

esProc Helps Process Structured Texts in Java – Alignment Join

The join statements of the database can be used conveniently to perform the operation of alignment join. But sometimes the data is stored in the text files, and to compute it in Java alone we need to write a large number of loop statements. This makes thecode cumbersome. Using esProc to help with programming in Java ca...

2014-12-16 804 0 0

esProc Improves Text Processing – Characters Matching

Sometimes during text processing you need to find out words containing certain characters. The logic of this computation is simple, but the code is difficult to write using the regular expression because the order of the characters is flexible. Moreover, the method is inefficient. You may do better to write the program...

2014-12-15 768 0 0

esProc Helps with Computation in MongoDB – Cross Summarizing

It is difficult for MongoDB to realize the operation of cross summarizing. It is also quite complicated to realize it using high-level languages, like Java, after the desired data is retrieved out. In this case, you can consider using esProc to help MongoDB realize the operation. The following example will teach you ho...

2014-12-12 846 0 0

esProc Helps with Computation in MongoDB – Relationships between Tables

MongoDB doesn’t support join. The unity JDBC recommended by its official website can perform join operation after retrieving data out, but charges a fee for the service. Other free JDBC drivers can only support the basic SQL statements, without join included. If you use programming languages, like Java, to retrieve dat...

2014-12-11 791 0 0

esProc Helps Process Structured Text in Java – Import data into the database

While importing the structured text files into the database using Java alone, we need to combine the SQL statements together manually, and to deal with various troublesome situations as well, like if the data in a table has been existed, whether we should update it or insert data into it, if some fields are included in...

2014-12-10 711 0 0