An Excel sheet hasn’t sequence numbers to mark the relative positions of the data, so it is very inconvenient to filter detail data of each group automatically. Usually one can only handle the data manually and this requires a lot of work. With esCalc, however, one can handle them easily. Here is an example:
Compute in...
2014-12-10 946 0
0
There are many occasions during text processing which require performing string matching with big files. Coding with command line grep\cat is simple yet inefficient. Though higher efficiency can be achieved with high-level languages, coding will be rather difficult.
Yet this operation, as well as multithreaded parallel...
2014-12-09 1045 0
0
Multi-level relationships are one of the complicated SQL-style computations which we often need to deal with during database application development. The relatively abstract SQL JOIN statement is suitable for expressing simple relationships between tables, but once the multi-level relationships are involved, the code b...
2014-12-09 857 0
0
During text processing, you often have the tasks of querying data from a big file on one or more conditions. Command line grep\cat command can be used to handle some simple situations with simple command yet low efficiency. Or high-level languages can be used to get a much higher efficiency with complicated code. If th...
2014-12-08 1291 0
0
It is common to perform set operations on big files in text processing. For example, find different rows between two files. The code for handling the operations with command line grep or cat command is simple but inefficient. While the operational efficiency is high when high-level languages are used to handle the oper...
2014-12-05 896 0
0
During database application development, we are often faced with complicated SQL-style computations, to which the multi-layered data grouping with specified criteria belong. In SQL, the key method for realizing the operation is to group the source data according to specified criteria using left join statement. The prob...
2014-12-03 881 0
0
It is extremely difficult to sort summary values in Excel, as the groups in an Excel spreadsheet are isolated from each other. In Excel, users can select a batch of data and sort them, but they cannot sort data that are scattered over different groups. A great deal of manual work is needed to fully realize the operatio...
2014-12-03 909 0
0
MongoDB can find out elements of a built-in array according to their indexes, but cannot find the indexes through the values of the elements. For example, the elements of an array are names of people stored according to their rankings. In MongoDB, names can be found according to the rankings (indexes of the array), but...
2014-12-02 836 0
0
MongoDB uses unicode, instead of the coding for a certain local language, to sort data in this language (i.e. Chinese). Together with esProc, MongoDB can realize sorting in local language conveniently (i.e. sort Chinese according to Chinese phonetic alphabet). The following will teach you the method in detail by taking...
2014-12-01 929 0
0
Java doesn’t support set operations directly, so nested loops have to be used to realize the operations of intersection, union, complement and etc. between text files. If there are many text files, or the file to be computed is too big to be loaded into the memory, or it is required to perform set operations according ...
2014-11-28 901 0
0
Inter-row computation is one of those complicated SQL-style computations we often need to handle during database application development. For instance, to compute the link relative ratio by dividing each month’s sales amount by that of the last month, or to compute the year-on-year comparison by dividing each month’s s...
2014-11-27 951 0
0
It is difficult to perform inter-row computation of inconsecutive summaries in Excel due to the fact that usually all formulas should be entered by hand, which is not only troublesome but also easy to get wrong. This is because Excel lacks a smart adjustment mechanism and only supports copying formulas mechanically acc...
2014-11-26 941 0
0
During database application development, we often need to handle complicated SQL-style computations. One of them is the ungrouping, that is, the opposite process of grouping and summarizing which requires, for example, splitting each record into multiple records. We cannot realize the operation in SQL without taking gr...
2014-11-25 818 0
0
Data sorting by a specified order is one of the complicated SQL-style computations we often need to deal with during the database application development. The computation requires that data be sorted by a specified order rather than in ascending or descending order. For example, sort data according to the order of 2,3,...
2014-11-24 824 0
0
MongoDB doesn’t support the complex subquery which can only be realized by retrieving the data out first and then performing further computation. The operation is the same complex even if Java or other programming languages are used to write the program. In view of this, we can consider using esProc to help MongoDB wit...
2014-11-21 1436 0
0