摘要:
A system and method are presented for providing system code to a variety of databases by using a resource database. The resource database contains pre-created system objects, which have been parsed and organized into a format suitable for execution. These pre-created system objects are capable of logically appearing in the variety of databases, while physically persisting in the resource database. Employing the resource database allows for quick upgrades and rollbacks since the pre-created system objects can be copied and installed on computer systems in a single file-copy operation. Additionally, the resource database limits accessibility to its pre-created system objects, thereby ensuring the integrity of the resource database. Lastly, the resource database contains its own metadata that is distinct from the metadata of the variety of databases.
摘要:
Translation architecture that facilitates translation between schema data and relational structures. The architecture includes a translation component that consumes schema data (e.g., an XML schema) that includes a schema structure, validates the schema structure, and persists in memory a representation of the schema as a relational format. Since schemas are shredded into tables, instance validation loads only the necessary components to perform validation. During validation, only parts of the schema that are used are loaded and cached. A schema cache stores the in-memory representation of schema optimized for instance validation. Schema components are loaded from metadata into main memory as read-only objects such that multiple users can use the in-memory objects for validation, query processing, query optimization and storage optimization of XML instance data
摘要:
Provided are systems and methods that facilitate providing permission to entities of a database. A system includes a component that authorizes a principal of a containing entity to grant a permission to that entity, and a component that grants the permission to the containing entity, the grantee of the permission inherits a set of permissions to one or more entities contained by the containing entity. When a permission is granted to a parent in a hierarchy of a relational database, the permission is inherited by the child nodes. Also provided is a method for transferring ownership of entities in a relational database. The method includes a two-part handshake that can be audited to avoid repudiation issues.