Computer data system position-index mapping
Described are methods, systems and computer readable media for position-index mapping in a computer data system.
1. A system comprising:
one or more hardware processors;
a computer readable data storage device coupled to the one or more hardware processors, the computer readable data storage device having stored thereon software instructions that, when executed by the one or more hardware processors, cause the one or more hardware processors to perform operations including:
receiving an electronic message associated with a child table, the electronic message including one or more change notifications indicating a change in one or more corresponding parent tables of the child table;
updating an index of the child table based on the received one or more change notifications, where the index of the child table includes a mapping between one or more index values in the child table and corresponding positions in one or more data columns mapped by a columns source map of the child table, where the corresponding positions include positions for which data in the one or more data columns is valid for the child table;
when the child table has one or more dependent tables that depend on data of the child table, generating one or more other electronic messages associated with the one or more dependent tables, the other electronic messages containing change notifications representing updates made to the child table; and
when one or more other electronic messages are generated, providing the one or more other electronic messages to corresponding dependent tables.
2. The system of claim 1 , wherein updating the index includes maintaining strict ordering of the index.
3. The system of claim 1 , wherein the child table has a dependency on data of the one or more parent tables.
4. The system of claim 1 , further comprising another table having a same index as the child table and a column source map different from the column source map of the child table.
5. The system of claim 1 , wherein receiving the electronic message includes receiving an electronic message from a listener associated with the one or more parent tables.
6. The system of claim 1 , wherein providing the one or more other electronic messages to corresponding dependent tables includes causing a listener associated with the one or more dependent tables to be actuated.
7. The system of claim 1 , further comprising another table having a same column source map as the child table and an index different from the index of the child table.
8. A method comprising:
receiving an electronic message associated with a child table, the electronic message including one or more change notifications indicating a change in one or more corresponding parent tables of the child table;
updating an index of the child table based on the received one or more change notifications, where the index of the child table includes a mapping between one or more index values in the child table and corresponding positions in one or more data columns mapped by a columns source map of the child table, where the corresponding positions include positions for which data in the one or more data columns is valid for the child table;
when the child table has one or more dependent tables that depend on data of the child table, generating one or more other electronic messages associated with the one or more dependent tables, the other electronic messages containing change notifications representing updates made to the child table; and
when one or more other electronic messages are generated, providing the one or more other electronic messages to corresponding dependent tables.
9. The method of claim 8 , wherein the change notification includes one or more of an add, a modify, a delete or a reindex message associated with data in the child table that depends on data in one of the parent tables.
10. The method of claim 8 , wherein the child table has a dependency on data of the one or more parent tables.
11. The method of claim 8 , further comprising maintaining a redirection index mapping an outer index to an inner index.
12. The method of claim 8 , wherein receiving the electronic message includes receiving an electronic message from a listener associated with the one or more parent tables.
13. The method of claim 8 , wherein providing the one or more other electronic messages to corresponding dependent tables includes causing a listener associated with the one or more dependent tables to be actuated.
14. The method of claim 8 , further comprising another table having a same column source map as the child table and an index different from the index of the child table.
15. A nontransitory computer readable medium having stored thereon software instructions that, when executed by one or more processors, cause the one or more processors to perform operations including:
receiving an electronic message associated with a child table, the electronic message including one or more change notifications indicating a change in one or more corresponding parent tables of the child table;
updating an index of the child table based on the received one or more change notifications, where the index of the child table includes a mapping between one or more index values in the child table and corresponding positions in one or more data columns mapped by a columns source map of the child table, where the corresponding positions include positions for which data in the one or more data columns is valid for the child table;
when the child table has one or more dependent tables that depend on data of the child table, generating one or more other electronic messages associated with the one or more dependent tables, the other electronic messages containing change notifications representing updates made to the child table; and
when one or more other electronic messages are generated, providing the one or more other electronic messages to corresponding dependent tables.
16. The nontransitory computer readable medium of claim 15 , wherein the change notification includes one or more of an add, a modify, a delete or a reindex message associated with data in the child table that depends on data in one of the parent tables.
17. The nontransitory computer readable medium of claim 15 , wherein the child table has a dependency on data of the one or more parent tables.
18. The nontransitory computer readable medium of claim 15 , wherein the change notifications in the other electronic messages include one or more of an add, a modify, a delete or a reindex message associated with data in the child table that depends on data in one of the parent tables.
19. The nontransitory computer readable medium of claim 15 , wherein receiving the electronic message includes receiving an electronic message from a listener associated with the one or more parent tables.
20. The nontransitory computer readable medium of claim 15 , further comprising another table having a same column source map as the child table and an index different from the index of the child table.