Raqsoft - Expert of data computing and spreadsheet tools development

17/10/2014

R language, Python,SQL and esProc can all do such structured data computing, what’s the difference between them?
Compute the link relative ratio and year-on-year comparison of each business branch’s monthly sales during a specified period of time;Select stocks whose closing price has been increasing uninterruptedly for over 10 days;Relate the data of different sources, like contract and payment information, to project payments schedule and find out the overdue projects;
http://blog.raqsoft.com/?p=1137

16/10/2014

Related tables queries with SQL and esProc: Join and union cases

Join multiple tables with “join” The SQL statements used in A3 and A4 are inner join, but they have different syntax. When the data of two tables are being…

15/10/2014

To compute the moving average of sales data in three days:
Python:pandas.stats.moments.rolling_mean(sales["Amount"], 3)
R language: filter(sales$Amount/3, rep(1, 3));
esProc: sales.(Amount{-1,1}.avg())

A moving average is used to smooth out a time series. Computing moving average is a typical case of ordered data computing. Its basic computing method is to cr…

14/10/2014

JSON data processing case in Java

Java’s JSON open source package can only parse JSON data and hasn’t the computational function. It is troublesome for programmers to develop a general ...

09/10/2014

Grouping and Summarizing cases in R Language and Python(Pandas)

30/09/2014

Left join, right join, full join and inner join for text file alignment join in Java

The join statements of the database can be used conveniently to perform the operation of alignment join. But sometimes the data is stored in the text files, an…

24/09/2014

How to sort the employee data in a big text file by STATE in ascending order, and the file is over memory capacity?

It is simple for Java to sort data in text files of small size. But when big files are involved, you need to import data segmentally, write out the sorting result of each segment in temporary files and at last, merge these temporary files. The programming will be rather complicated. Even if the f...

23/09/2014

Code examples for the calculation of Link Relative Ratio and Year-on-year Comparison in R language and Python

Cross-row and group computation often involves computing link relative ratio and year-on-year comparison. Link relative ratio refers to comparison between the…

17/09/2014

In last article we mentioned that IT engineers from the Web Company used esProc to code program which could handle large data volume and complex requirements. Not only could it meet the demands for online time computation, but also is relatively easy to be extended to with new conditions. Howev...

10/09/2014

How to join sales data of two tables from different database in Java?
Here is an example to illustrate how Java handles cross-database relational queries in data process involved program development. sales table is in db2 database, employee table is in mysql database. The task is to join sales with employee through sellerid of sales table and eid of employee table, and filter out the data insales and employeethat satisfystate=“California”. Hope for your suggestions on this solution.

http://www.analyticbridge.com/profiles/blogs/code-examples-of-cross-database-relational-computing-in-java

Program development for data process often involves cross-database relational operations. The following example will illustrate Java’s method of handling these…

28/08/2014

How to join related tables in database construction and data analysis?
Related computing can be: Inner join or outer join. The outer join can be further divided into left join, right join, and full join. How do you implement such kinds of related computing? Here are some join operation cases done with esProc, hope for your comments as well as suggestions.
http://www.oraclecommunity.net/profiles/blogs/join-cases-between-related-tables-in-data-computing-and-analytics

Related computing can be: Inner join or outer join. The outer join can be further divided into left join, right join, and full join. With esProc, such kinds of…

27/08/2014

How to calculate the time difference between logon and logout at web applications(II)?

In last part we mentioned that the Operation Department of the Web Company brought about a new demand: adding new conditions to the way the online time are computed. As IT department was using esProc as the tool for computation, it’s easy to handle such changes in requirements. On the other hand, th…