1.Foreign key referencing
The foreign key is a common concept for various relational databases. In a relational table, you can define one or multiple fields as the foreign key. The foreign key field values can be associated with the data in another table. For example, in the game scoring report, player scores are usual...
2014-07-10 1093 0
0
1.Accessing Members
Members in a set (sequence) of esProc are organized in order. Therefore, you can reference a member in a set with the serial number of the member. The more flexible use of serial number, the better esProc functions and the operation will be much simpler and more efficient.In fact, the serial number ...
2014-07-09 985 0
0
esProc
=[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 712 0
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 1026 0
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 758 0
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 834 0
0
7 Analysis
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 935 0
0
esProc
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 785 0
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 886 0
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 860 0
0
1.Testing purposes
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
Data volume:
Sma...
2014-06-25 956 0
0
esProc
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 786 0
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 821 0
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 728 0
0
esProc
=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 712 0
0
