category:Blog

Solving SQL Problems with Python\R\esProc

SQL is a sophisticated and all-around database programming language, making most instances of structured-data computing a painless experience. Yet there are still some instances that are difficult to handle in SQL in computer programming. Here’s an example. duty is a MySQL table of shift schedule, in which an employee ...

2016-03-16 116 0 0

The Three Stages in Building Reports with Heterogeneous Data Sources

There are many different types of report data sources, including relational databases, NoSQL databases, local files, HDFS files and JSON data stream. It’s easy to build a report with a single data source, but it’s difficult to build one that needs data from more than one type of data source, i.e. heterogeneous data sou...

2016-03-15 81 0 1

Examples of Handling JSON Data with esProc

JSON format multilevel semi-structured data is commonly seen in internet applications. Java provides just the class library for parsing JSON data, but to perform in-depth calculations, complex hardcoding is required. esProc supports set-operations, order-related calculations and dynamic script execution, so it can be u...

2016-03-11 118 0 0

The Three-layered Reporting Architecture

A reporting architecture consists of three layers from bottom to top – storage layer, computing layer and displaying layer. The storage layer contains raw data, which may be stored in a relational database (RDB), a NoSQL database, and a local or HDFS file, or may just be a JSON stream. The computing layer can access th...

2016-03-07 79 0 0

Performance Test of Processing Text Files with esProc

This article aims to test performance of esProc in processing text files, using an example of data query and filtering and through the comparison with Java and Perl doing the same processing. Test data is some order records stored in orders.txt file. The imported data is as follows: ORDERID CLIENT   &nbs...

2016-02-15 157 0 0

The Standard Method of Transposing Database Tables in JAVA

Sometimes you need to transpose a database table (or a text file) in JAVA before exporting it out. Different types of transposition require different SQL techniques, and at times you have to do low-level programming in JAVA. That is quite difficult. As esProc that serves as JAVA class library supports dynamic scripting...

2015-12-14 178 0 0

Performing Group Operations on Text-based Tabular Data in JAVA

The group operations performed on tabular data generated from text files include algorithms like grouping and aggregation, obtaining distinct values, group merging and so on, which can be realized using basic JAVA class libraries. But JAVA provides only limited support for the structured-data computing, generating comp...

2015-12-11 87 0 0

Performing File Comparisons in Java: Cases and Solutions

It’s hard to develop code for performing file comparisons – including finding common values or modified records, comparison of big files or multiple fields or files with different structures, and other scenarios, because generally they involve set operations, structured-data handling and multithreaded parallel pr...

2015-12-11 119 0 0

Examples on How esProc Converts Text Files to Structured Data

Having complex formats and unstandardized data, many of the text files are incomputable. They, when used as the data source, need preprocessing to be converted to the structured data or the database table for further query or statistics. Though we can perform this conversion using high-level languages like JAVA, or scr...

2015-11-09 121 0 0

Performing Group Operations on Text-based Tabular Data in esProc

The group operations performed on tabular data generated from text files include algorithms like group and aggregate, obtaining distinct values, group merging and so on, which can be realized through high-level languages like JAVA or scripting languages like Python. But these two types of languages provide only limited...

2015-11-07 79 0 0

esProc Assists SQL with the Non-Equi-Grouping

In SQL, usually we can only group a table automatically according to its own filed(s). When the grouping criterion comes from another table, or is an external parameter or a conditional list, SQL has to handle the grouping in a very roundabout way. Some cases even require the dynamic criteria, which need to be generate...

2015-09-29 85 0 0

esProc Assists SQL with Sorting in a Fixed Order

Usually SQL is merely able to sort data by one or more certain fields. When it comes to sorting by a list, the only choice is to use decode or union. But with a long list, the SQL statement will be lengthy. If the items of the list are parameters representing unfixed values, usually a temporary table needs to be create...

2015-09-25 106 0 0

Merge MongoDB Documents in esProc

Problem source:https://groups.google.com/forum/#!topic/mongodb-user/BpgEaRqrKsA Below is a selection of Collection C1: You need to group the collection by name. Each group contains the users field of the document corresponding to a same name and does not allow duplicate members. The expected result may like this: esP...

2015-09-16 132 0 0

Performance Test of esProc In-Memory Computing

In this article, we’ll test the performance of esProc in handling in-memory small data computing, and compare with that of Oracle when performing the same computation. The test involves two cases: normal simple computing and complicated related computing: The test data used in normal computing is order information, as ...

2015-09-14 82 0 0

Examples of esProc’s Assisting in Dynamic-Column-SQL Computations

The SQL implemented by database vendors can be used to write dynamic statements. But since it’s inconvenient to perform set operations and order-related computations in SQL, usually you must resort to the high-level languages to handle the dynamic-column computations, which leads to a cumbersome process of doing these ...

2015-08-31 84 0 0