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 1307 0
0
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 939 0
0
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 1425 0
0
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 1459 0
0
Excel is the favorite of business staff because of its simplicity and easy use, but actually many of the common operations are not so easy to perform with it. The computations of link relative ratio and year-on-year comparison fall into this category. This is because, during the copying of formulas, Excel can only comp...
2015-01-13 968 0
0
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 923 0
0
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 960 0
0
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 909 0
0
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 1013 0
0
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 975 0
0
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 947 0
0
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 915 0
0
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 995 0
0
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 928 0
0
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 843 0
0
