Tag Archives: esProc

Report Building Challenges: In-depth Processing of JSON Data

For processing semi-structured JSON data, both Java and the reporting tools provide class libraries that are only capable of simple parsing jobs, giving you no choice but to write complicated code when trying to process the data in-depthly. However, using … Continue reading

Posted in Reporting tool | Tagged , , | Leave a comment

esProc Simplifies SQL-style Computations – Dynamically Transposing Rows and Columns

In real-world business, many computing tasks require transposing rows and columns dynamically. There are a lot of discussions around the operation in online IT groups and forums. Below lists some of them: http://www.dbforums.com/showthread.php?1628876-SQL-question-how-to-move-two-column-data-to-one-column-data https://www.linkedin.com/grp/post/137774-5981739289539526658?trk=groups-post-b-title http://stackoverflow.com/questions/29756836/mysql-pivot-table-and-numbered-columns http://www.linkedin.com/groups/need-help-86080.S.5796995228699222017?trk=groups_items_see_more-0-b-ttl SQL implements row-to-column transposition … Continue reading

Posted in SQL-related Puzzle | Tagged , , , , | Leave a comment

How esProc Assists Writing SQL Queries

esProc can simplify complex SQL-style queries using ordered sets, object-style access and stepwise computation. Usually there are two ways in which esProc is used: an independent one and one requiring integration with Java. Now let’s look at the first one … Continue reading

Posted in SQL-related Puzzle | Tagged , , | Leave a comment

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 … Continue reading

Posted in Java Assistant | Tagged , , | Leave a comment

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 … Continue reading

Posted in Java Assistant | Tagged , , | Leave a comment

Structured Data Computing: the Focus of Routine Data Analysis

Essentially, the main content of various data analyses in our routine business is the structured data computing. For example: Compute the link relative ratio and year-on-year comparison of each business branch’s monthly sales during a specified period of time. Implementation … Continue reading

Posted in Unique | Tagged , , , | Leave a comment

Comparison Between esProc’s Sequence Table Object and R’s Data Frame

Both esProc and R language are typical data processing and analysis languages with two-dimensional structured data objects. They are all good at multi-step complex computations. However their two-dimensional structured data objects are quite different from each other in the underlying … Continue reading

Posted in esProc/R/Python/Perl, FAQ | Tagged , , , , | Leave a comment