=[1,2,3].sum() // Evaluate the sum for the Sequences
=tbl.sum(col1) // Evaluate the sum for col1 fields in Table sequence tbl
=tbl.select(col2>30).sum(col1) // Evaluate the sum for the record field col1 for wh...
2014-07-08 120 0
1.Sequence and Set in esProc
Unlike traditional programming languages, esProc employs set commonly. In fact, the sequence in esProc belongs to the field of set. So it’s quite important to deeply understand the concept of sets when using esProc. Like an integer and a string, the set is a basic data type; it could be a v...
2014-07-07 167 0
Here, we use esProcto analyze stock bullishtrend. There is a variety of specific algorithms, from which, onewill be illustrated the whole process in detail. Other cases can be solved in the similar codes. Specific requirements are:
Among the stocks which have kept going up for N days, what is the proportion of those th...
2014-07-04 142 0
Programming languages focus on various basic data types, subject to their different design goals. Languages such as Java and C# are designed to develop the common applications. Their basic data types are character strings, number, boolean, and other atomic data type, array and common object. SQL, PowerBuilder, R, esPro...
2014-07-03 163 0
From all use case test we could generally reach the following conclusion on the data characteristics:
1.Oracle normally performs better than esProc with small data volume concurrent computation; sometimes the performance advantage could be as high as several times. But there are exceptions. esProc performs b...
2014-07-02 165 0
tbl.derive(col1) // Add a column col1 to the Table sequence
esProc is unable to execute some operations such as deleting the column from the existing Table sequence or inserting the column into the existing Table sequence, however, it is very easy to create a new Table sequence. In fact, the acti...
2014-07-01 161 0
6 Test Use Case
6.1 Small Data Volume Concurrent Scan
This use case tests Oracle and esProc for scanning performance against small data volume tables (files).It’s done with a multi-task concurrent access mode.Each task is accessing different table (file). Among them, Oracle is running 16 parallel processes, while...
2014-06-30 114 0
5 Use Cases Description
For better understanding, all test logic will be described in SQL.
During the test Oracle will execute the SQL statement directly, whereas esProc will be running the equivalent code we write to complete the same computation.
5.1 Use Case for Large Data Volume Scan
This use case is large task sin...
2014-06-26 119 0
Testing esProc and Oracle on the same hardware for single machine performance, to compare the two for performance difference either in large data volume single task computation or small volume multiple tasks concurrent computation use cases.
2.Testing contents and methods
2014-06-25 161 0
tbl.modify(2,col1*5:col1,col2+3:col2) //field value col1 recorded in Row 2 of Table Sequence tbl is changed to col1*5, and field value col2 to col2+3
tbl.modify(2:5,col1*5:col1,col2+3:col2) //Subsequent 5 Rows are modified from Row 2 in a consecutive way
//Modify the two Table sequences in the sam...
2014-06-24 148 0
Testing data preparation is a critical work in software testing. High-quality testing data can better simulate the business case. It helps to meet the testing requirements by timely and effective evaluation of softwareperformance, or finding potential issues in the software builds. Most oftime, the amount of data used ...
2014-06-23 133 0
esProc is a data analysis language, featuring the easy-to-code, strong interactivity, dedicated debugging, and agile and arbitrary syntax. In particular, esProc is also capable of performing the parallel computation and fit for the big data analysis.
For example,a commercial Website generates several thousands of acces...
2014-06-20 111 0
=tbl.(colname) //Return the values of a column in the table, which can be accessed by Column name
=tbl.(#4) //The values of a column can be accessed by Column number
=tbl(4).colname //Return the values of Column colname of Row 4 in the table, which can be ac...
2014-06-19 121 0
esProc has existing table sequence object, innate column name and number as well as row number, and also provides a wealth of access methods, aggregate functions and loop functions.
The syntaxes are all identical, regardless of table sequence, record object itself or pointer reference. The system will perform au...
2014-06-18 176 0
One of the most attractive features of R language and esProc is that their codes are both of the agile style, only requiring few lines of codes to implement plentiful functions. For example, both of them allow for composing Vector Computing expression, simplify the judgment statements, extend the basic functions to the...
2014-06-16 134 0