category:Set-Oriented Structured Data

Reference-based Thinking in esProc

1.Foreign key reference The foreign key is a common concept for various relational databases. For a relational table, you can define one or multiple fields as the foreign key, through which an association with the data in another table can be created. For example, in a game scoring report, often players are recorded wi...

2016-05-17 2326 0 1

Index Sequences in esProc

With databases, creating appropriate indexes for tables can greatly increase query efficiency. Similarly, you can create index sequences for record sequences or table sequences in esProc to enhance the efficiency of querying data repeatedly. For example, you need to query the food order file Order_Foods.txt repeatedly....

2016-05-09 2177 0 0

Using Sequence Numbers and Locating Data in esProc

An esProc set is an ordered set. Therefore, its members can be referenced by sequence numbers. A flexible exploitation of sequence numbers will give full play to esProc’s capability, handling a computation in a simpler and more efficient way. 1. Accessing members Therefore it is recommended that certain esProc function...

2016-04-15 1799 0 0

Set-based Thinking in esProc

esProc applies set theory in a uniquely deep, common way, compared with traditional programming languages. The sequence in esProc is in essence a type of set. It’s important to learn to think in sets all the time when working with esProc. 1.Sequences and sets in esProc The sequence, as well as integer and string, is on...

2016-04-11 1843 0 0