category:Blog

esProc Implements Dynamic Data Sources for Reporting Tools

Sometimes you need to reference data sources dynamically through a parameter, merge data sources into one, or dynamically pass data source name to a subreport/Table control. Often reporting tools – especially those with support for single data source, such as BIRT and Jasper – have to use a high-level language to...

2015-06-18 87 0 0

How esProc Assists Java to Retrieve Text Files

Java provides functions for handling the basic file processing, which refers to the retrieval of small text files, in a simple, unstructured way. But in handling files requiring structured format, holding data of various formats and having particular requirements, or big files that cannot be entirely loaded into memory...

2015-06-17 18 0 0

esProc Arranges Data for Reports with Unconventional Layouts

It’s hard to create reports with unconventional layouts directly with functions provided by a reporting tool. However, if the data for building such a report can be beautifully prepared, the difficulty could be considerably reduced. esProc(free edition is available) is an expert at handling this data preparation. It pr...

2015-06-15 37 0 0

How esProc Assists Java to Query Big Text Files

Sometimes you need to query a big text file, instead of the database. In those cases, you need to retrieve the file in a stream style to perform the query algorithm, in which parallel processing is needed to improve the computing performance. As Java lacks the class library for doing these, you have to use hardcoding t...

2015-06-12 17 0 0

Performance Test of File Retrieval in esProc

This article aims to test esProc performance of retrieving files and compares it with the result got by using Oracle JDBC. The test data is some order records saved in the orders.b file. Import the file with esProc and its content would be like this: ORDERID CLIENT     SELLERID AMOUNT ORDERDATE NOTE...

2015-06-11 13 0 0

Performance Test of Concurrent File Processing with esProc

This article aims to test esProc performance in processing files concurrently, based on filter, group and aggregate operations and comparison with Oracle. Test data includes tables of ordering information of different years. With esProc, files (Orders2009.b, Orders2010.b, Orders2011.b and Orders2012.b) of binary format...

2015-06-10 15 0 0

esProc Helps to Compose Dynamic SQL

It is not uncommon in actual business to tackle complex computational problems by composing dynamic SQL. The skill has generated a lot of discussion across online IT forums. Here are links to some of the questions around it: http://bbs.csdn.net/topics/390876591 http://bbs.csdn.net/topics/390981627 https://www.linkedin....

2015-06-09 17 0 0

Performance Test of esProc File Traversal Algorithm

This article focuses on testing performance of esProc’s handling of file traversal, using commonly used group and aggregate operations as well as query and filter operations. The performance test will include evaluation of the influence of using multithreads, and comparison between esProc approach and Oracle counterpar...

2015-06-05 19 0 0

How to Use esProc as the Class Library of Structured File Computing for Java

In some cases, data must be stored in the file system, rather than in a database. That requires handling file-based data computing manually. Since Java lacks the related class library, you have to hardcode the structured file computing, which produces complicated and unreadable code. Yet, you can make up for this defic...

2015-06-04 19 0 0

24-Point Game Programming in esProc

24-point game is a common intellectual game, which can be played with cards without jokers. The rule is to draw four random cards and manipulate the four numbers to get the result 24 using four arithmetic operations: addition, subtraction, multiplication and division. In card playing, J, Q, K correspond numbers 11, 12 ...

2015-06-03 19 0 0

esProc Solves Multivariable Linear Equations

For a given system of linear equations in n unknowns, there must be n equations to form the system. e.g.: 3x+4y+5z=26 5x+6y+10z=47 4x+8y+7z=41 Well, how do you solve this system of linear equations with n variables with esProc? First, the system of equations should be written in a standard form, and parameters are fill...

2015-06-02 21 0 0

esProc Solves Eight Queens Problem

Among lots of chess puzzles, the problem of the eight queens is the most well-known example. Eight queens must be placed on a 8×8 chessboard so that no queen attacks any others. Well, how many solutions are there?  A queen attacks any other queen that sits on the same row, column or diagonal. Thus a solution requi...

2015-05-29 16 0 0

Code Examples of esProc Foreign Key Function

If k (a single field or a combination of fields) is table M’s primary key, and k, at the same time, exists in table B, then k is regarded as B’s foreign key. The foreign key defines a relationship between two tables and is one of the most important concepts for structured data computing. Through object references, esPr...

2015-05-27 15 0 0

esProc Assists Report Development – Transpose Operation for Crosstab Creation

It’s difficult to handle unconventional statistical tasks using simply the reporting tool, like Jasper or BIRT, or SQL. One of the cases is that the source data don’t meet the crosstab’s requirements and thus need to be transposed for display. Having powerful computing engine to process structured data and being integr...

2015-02-09 38 0 0