category:Deep Subject

Application of Index Sequences in esProc

In databases, creating appropriate indexes for tables can greatly increase query efficiency. Similarly, index sequences can be created for record sequences or table sequences in esProc to increase efficiency in querying data repeatedly.  For example, we need to access the food order Order_Foods.txt repeatedly. ...

2015-05-13 32 0 0

Using Cursor in esProc

With esProc, you can handle the structured big data easily, and perform data computing and analysis without difficulty. Because the big data table cannot be loaded into the memory all at once, the basic solution is using cursor to handle it. 1. Basic principle of cursor The esProc cursor is like the database cursor in ...

2015-05-12 30 0 0

Referencing Thinking in esProc

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 usua...

2015-05-11 61 0 0

esProc Set Thinking

1. Sequences and sets in esProc Unlike traditional programming languages, esProc employs sets 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 esProc data type; it c...

2015-05-07 33 0 0

Using Sequence Numbers and Locating Data in esProc

1. Accessing members Members in a set of esProc (sequence) are organized in order. Therefore, you can reference a member in a set with its sequence number. The more flexible use of sequence numbers, the better esProc functions to make operations simpler and more efficient. Thus sequence numbers or an integer sequence (...

2015-04-02 60 0 0