Serialized Child Associations in Parent Record

摘要

A parent record is created, and the parent record includes a cache for children. Child records are created, and each child record belongs to a parent. Responsive to the creation or update of a child record, the parent record's cache is invalidated. To rebuild the parent record's cache, the child records are serialized and written into the parent record's cache. During a read operation, the parent record is read, including the parent record's cache of children, in a single database access. This results in a substantial savings of time as compared to retrieving the parent and the children from the database separately. Where the number of reads of the parent record greatly exceeds the number of changes to child records, serialized child associations in parent records enhances the efficiency of database access.

主权项

1. A method for improving data access efficiency in an object-relational mapping environment by using a parent record's cache of children belonging to the parent, the method comprising:
changing a child record in a database, the child record belonging to a parent record and being one of a plurality of children belonging to the parent record; responsive to the changed child record, invalidating the parent record's cache; rebuilding the parent record's cache, comprising:
serializing the parent's child records; andwriting the serialized child records into the parent record's cache; and reading the parent record, including the parent record's cache of children, in a single database access.