Monthly Archives: August 2015

Comparison of esProc and R Language in Processing External Text Files

As languages for data computations, both esProc and R language have rich functions to process external text files. They have many similarities in basic usage, as well as obvious differences, such as in the aspect of processing files with fixed … Continue reading

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

Comparison between esProc Syntax and SQL Syntax for Common Computations

Structured Query Language, abbreviated as SQL, is usually used to query, store and retrieve data in databases. In esProc, users can return the query result using SQL commands directly, or process data step by step with more flexible and convenient … Continue reading

Posted in SQL-related Puzzle | Leave a comment

esPro Helps Process Structured Texts in Java – Data Import

Java provides only the most basic data import functions like specifying separators. But other common functions, such as importing specified columns by column names, specifying the order of columns and data types and that no separator should be used, need … Continue reading

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

esProc Helps Process Heterogeneous Data Sources in Java –Cross-Database Relating

JoinRowSet and FilteredRowSet provided by RowSet– Java’s class library for data computing – can perform cross-database related computing, but they have a lot of weaknesses. First, JoinRowSet only supports inner join, it doesn’t support outer join. Second, test shows that … Continue reading

Posted in Java Assistant | Leave a comment

esProc Helps Process Heterogeneous Data Sources in Java – Excel

Generally, Java programmers use poi or other open source packages to read and compute Excel data. These open source packages support low-level programming, which increases the overall learning cost and complicates the operation. But with the help of esProc, Java … Continue reading

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

esProc Helps Process Heterogeneous DataSources in Java – HDFS

It is not difficult for Java to access HDFS through API provided by Hadoop. But to realize computations, like grouping, filtering and sorting, on files in HDFS in Java is troublesome. esProc is a good helper in Java’s dealing with … Continue reading

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

esProc Helps Process Heterogeneous Data Sources in Java – JSON

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 program for performing computations, such as grouping, sorting, filtering and joining, by themselves. For example, during … Continue reading

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