category:Uncategorized

esProc File Computing: Parallel Query and Filter

Raqsoft esProc provides the ability of performing file-based computation. It supports multithreaded parallel processing to deal with problems involving relatively big data. The multiprocessing can make full use of the computational power of the machine’s multi-core CPU to achieve an almost equal or better performance t...

2015-04-30 1 0 0

esProc File Computing: Cascaded Foreign Key Relationships

There are some computational tasks of processing structured data that involves multi-table data sources joined through cascaded foreign key relationships. For example, you want to find particular orders from the order management system, where the following structure of cascaded foreign key relationships is involved. Co...

2015-04-29 1 0 0

A Code Example of External Memory Grouping in esProc

In data analysis, we often need to group data and then compute the aggregate value for each group, or perform other computations on each group. esProc allows using groups function to compute aggregate values for groups of data, as well as grouping records of a table with group function for use in subsequent computation...

2015-04-28 1 0 0

esProc Assists BIRT in Splitting Fields and Converting Them to Records

Problem source: http://developer.actuate.com/community/forum/index.php?/topic/36204-split-data-row/ . To split fields apart and recombine them into records, you can use the stored procedure or a report script. But as the code is complex, an alternative choice is using esProc to help the reporting tool with the job. Let...

2015-04-27 1 0 0

esProc Assists BIRT in Handling Irregular Month Grouping

Problem source: http://developer.actuate.com/community/forum/index.php?/topic/36323-months-and-quarters-group-issue/. Irregular month grouping: If the start date is 2014-01-10, group dates from this date to 2014-02-09 together and dates from 2014-02-10 to 2014-03-9 together. If the start date is 2014-01-31, put dates f...

2015-04-25 1 0 0

Grouping In-memory Data Using esProc: Code Examples

Using esProc, it is quite convenient to group data in memory. There are several main types of grouping based on how data is grouped. Here we’ll illustrate equal grouping, alignment grouping and enumeration grouping respectively with an example. Equal grouping That data is grouped by one or more certain fields (or one o...

2015-04-24 1 0 0

esProc Analyzes Upward Trend in Stock Prices

Here, we use esProc to analyze the upward trend in stock prices. There is a variety of algorithms, of which one will be illustrated in detail. Other cases can be handled using the similar codes. Specific requirements are:  Among the stocks which have kept going up for N days, what is the proportion of those that c...

2015-04-23 1 0 0

esProc Assists Jasper in Calculating Opening Balance

Problem source:http://community.jaspersoft.com/questions/850400/how-create-report-opening-balance-using-jasper-reports The calculation of opening balances according to deposit and withdraw amount involves inter-row operation. Jasper can do the calculation but the code is complicated. You can use esProc to assist the jo...

2015-04-22 1 0 0

esProc Assists Jasper in Calculating Loan Payments

Problem source: http://community.jaspersoft.com/questions/851148/loop-jasper .  The calculation of loan payments according to loan amount will involve loop operation and inter-row operation. It is difficult to write code for it using stored procedure or Scriptlets. Yet with the help of esProc, the Jasper calculati...

2015-04-21 2 0 0

esProc Assists BIRT in Handling Intragroup Inter-row Calculations

Problem source: http://developer.actuate.com/community/forum/index.php?/topic/36160-dealing-with-previous-rows-groups-sorts-and-subtotals/ .  Generally intragroup inter-row calculations are handled with window functions or report scripts. But the code is rather complicated. Instead, you can use esProc to assi...

2015-04-20 1 0 0

Calculate Growth Rate in Jasper Crosstabs

Problem source: http://community.jaspersoft.com/questions/847490/how-get-annual-growth-rate-crosstab .  As every column in a crosstab is generated dynamically, you also need to reference them dynamically when performing inter-row calculations. There is some difficulty in handling this dynamic reference using a Jas...

2015-04-17 1 0 0

Join MongoDB Collections with esProc

Problem source: http://stackoverflow.com/questions/29396985/is-there-a-where-like-relation-function-when-using-pymongo . It is difficult to join MongoDB collections through hardcoding as it doesn’t directly support joins. Yet you can use esProc to perform inner join, left join and full join between collections or join ...

2015-04-15 1 0 0

Aggregate Data by Specified Numbers of Rows with esProc

Problem source: http://bbs.csdn.net/topics/391014229. Below is data from SL field of table tb1: SL 5 7 7 8 8 5 7 8 2 3 4 2 You need to calculate the sum of values every five rows. The expected aggregate result is as follows: 1-5  35 6-10 25 11-12      6 That is, the first column is the int...

2015-04-14 1 0 0

A Code Example of External Memory Sorting in esProc

We often need to sort records in a table for data analysis and computing. esProc supports sort function to sort sequences or table sequences. External memory sorting is required when the data being sorted is too huge to be loaded into the memory all together and the ordinary sorting method cannot be used.  For exa...

2015-04-13 1 0 0