| 摘要 |
Systems, methods, and other embodiments associated with versioned persistent storage of multimedia content in a database object are described. One example method includes controlling a database management system (DBMS) to instantiate a database object that has a binary large object (BLOB) attribute, an XML edits attribute, and a set of metadata attributes. The method includes storing a binary stream associated with a multimedia content (e.g., medical image) in the BLOB attribute and storing an editing history of the set of metadata attributes as a set of edit entries in the XML edits attribute. The method also includes controlling the DBMS to store the database object in a column in a table in a relational database managed by the DBMS. |
| 主权项 |
1. A non-transitory computer-readable medium storing computer-executable instructions, the non-transitory computer-readable medium comprising instructions for:
controlling a database management system (DBMS) to generate a database object comprising a first binary large object (BLOB) attribute, an XML edits attribute, and a set of metadata attributes; storing a first set of binary data associated with a multimedia content in the first BLOB attribute; storing one or more values in the set of metadata attributes, where the one or more values are associated with one or more of, the multimedia content, and the database object; controlling the DBMS to store the database object in a column in a table in a relational database managed by the DBMS; and storing in the XML edits attribute an editing entry that describes a change to the database object, where the XML edits attribute includes a plurality of editing entries that describe a history of changes to values of the set of metadata attributes and the multimedia content; upon determining that the database object has changed, storing in the XML edits attribute an editing entry associated with the change, wherein the editing entry describes the change to the database object and includes content associated with the change, wherein the editing entry includes one or more of, an addition to the set of metadata attributes, and an update to the set of metadata attributes; storing in a second BLOB attribute one or more of, a set of binary data associated with an addition to the set of metadata attributes, and a set of binary data associated with an update to the set of metadata attributes; and providing a binary stream that represents a selected version of the database object by computing the selected version from a current version of the database object and the plurality of editing entries, wherein the selected version is generated by deleting a differential set of metadata attributes from the current version and adding a missing set of metadata attributes to form the selected version, wherein the missing set of metadata attributes are retrieved from the second BLOB attribute. |
