Persisting Objects in a Single Data Table

摘要

Disclosed is a system and method for persisting software objects. An object may be scanned to identify the members of the object. The members are transformed into an intermediate data structure. The intermediate data structure may be persisted in a single data table. Subsequent objects may be similarly scanned into respective intermediate data structure, and then persisted in the same single data table.

主权项

1. A method for persisting objects comprising operating a computer system to perform steps of:
scanning an object to identify members of the object; generating an intermediate data structure that represents the object, the intermediate data structure comprising a member record for each constituent member of the object, the member record comprising at least a member name that represents a name of said each constituent member, a member value of said each constituent member, and a member type indicative of a data type of the member value of said each constituent member; and persisting the intermediate data structure including storing the member records comprising the intermediate data structure in a single data table file, the single data table file comprising:
a plurality of rows, each row containing data comprising one of the member records; anda plurality of columns including a first column to store data representative of member names of the member records, a second column to store data representative of member types of the member records, and a plurality of value columns, each value column defined to store data of a given data type.