Monthly Archives: April 2014

Several Methods for Structured Big Data Computation

All data can only have the existence value by getting involved in the computation to create value. The big data makes no exception. The computational capability on structural big data determines the range of practical applications of big data. In … Continue reading

Posted in Big Data, Data Analytics | Tagged , , , , | Leave a comment

Top 3 Salespersons Ranking by Monthly Sales Amount R language VS esProc

Both R language and esProc have the outstanding ability to perform the stepwise computations. However, in the particulars they differ from each other. A comparison between them will be done by the following example: A company’s Sales department wants to … Continue reading

Posted in Data Analytics | Tagged , , , | Leave a comment

Solving Complex Computations in the Report

Reporting tool is good at chart & form design, style of landscaping, query interface, entry & report, and export & print. It is one of the tools that are applied most extensively. However, there are quite often complex computations in the … Continue reading

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

How to Facilitate Relational Reference: Generic, Sequence, and Table Sequence

Based on the generic data type, esProc provides the sequence and the Table Sequence for implementing the complete set-lizing and the much more convenient relational queries. The relation between the department and the employee is one-to-many and that between the … Continue reading

Posted in Program Language | Tagged , , , | Leave a comment

Is there a solution to make database real-time

The Big Data Real-time Application is a scenario to return the computation and analysis results in real time even if there are huge amount of data. This is an emerging demand on database applications in recent years. In the past, … Continue reading

Posted in Big Data | Tagged , , , | Leave a comment

Inter Row Computation to Showcase the Difference Between R Language and esProc

The inter row computation is quite common, such as the aggregate, comparison with same period of any previous year, and link relative ratio. Both R language and esProc provides the pretty good inter-row computation ability with slight difference to each other. In … Continue reading

Posted in Data Analytics | Tagged , , | Leave a comment

Data Computing Within Oracle, MSSQL and Mysql in Report Developing

Recently a development team met some difficulties in data source computation when developing iReport reports. After the use of esProc for cross database computation, the problem is resolved. This is a project payment progress report, as part of a project management system. … Continue reading

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