Dissociative record objects
- The dissociative record refers to the records free from the physical table in form. The analyst can take the individual record as an object to fetch value, compute, and modify, just similar to the access to an object.
- The dissociative record enables the analyst to focus on the concerned data and save them from the interference, so that the faster and more convenient data computation can be achieved.
- The dissociative record is the embodiment of stepwise computation. For SQL, the feature of dissociative record is unavailable.
| A | ||
| 1 | =db.query(“select * from Employee”) | |
| 2 |
 =A1.sort(EntryDate)
|
|
| 3 |
=A2(1)
|
The first on-boarding employee |
| 4 | =A3.Birthday | Birthday of the first on-boarding employee |
| 5 |
=A2(2).Name
|
The second on-boarding employee |
| 6 |
=A1.minp(Birthday)
|
The eldest employee |
| 7 | =A6.EntryDate | On-boarding date of the eldest employee |
| 8 |
=A2(to(3))|A6
|
The first 3 on-boarding employees and the eldest employee |
| 9 | =A8.avg(Salary) | The average salary of the employees in the above set |
