category:Uncategorized

esCalc Solves Spreadsheet Problems – Filter Detail Data by Sequence Numbers

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

esProc Improves Text Processing – String Matching with Big Files

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

esProc Simplifies SQL-style Computations – Multi-level Relationships

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

esProc Improves Text Processing – Conditional Query on Big Files

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

esProc Improves Text Processing – Set Operations on Big Files

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

esCalc Solves Spreadsheet Problems – Sort Summary Values

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

esProc Helps with Computation in MongoDB – Query Indexes in an Array

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

esProc Helps with Computation in MongoDB – Sorting in Local Language

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

esProc Helps Process Structured Texts in Java – Set Operations

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

esProc Simplifies SQL-style Computations–Inter-row Computation

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

esProc Simplifies SQL-style computations – Ungrouping

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

esProc Simplifies SQL-style Computations – Data Sorting by Specified Order

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

esProc Helps with Computation in MongoDB – Subquery

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