Efficiently registering a relational schema

Patent metadata

Field	Value
Publication number	US-9330124-B2
Application number	US-201314044982-A
Country	US
Kind code	B2
Filing date	Oct 3, 2013
Priority date	Nov 30, 2010
Publication date	May 3, 2016
Grant date	May 3, 2016

Abstract

A method, device, and non-transitory computer-readable storage medium are provided for efficiently registering a relational schema. In co-compilation and data guide approaches, a subset of entities from schema descriptions are selected for physical registration, and other entities from the schema descriptions are not physically registered. In the co-compilation approach, a first schema description references a second schema description, and the subset includes a set of entities from the second schema description that are used by the first schema description. In the data guide approach, the subset includes entities that are used by a set of structured documents. In a pay-as-you-go approach, schema registration includes logically registering entities without creating relational database structures corresponding to the entities. A database server may execute database commands that reference the logically registered entities. A request to store data for the entities may be executed by creating relational database structures to store the data.

First claim

What is claimed is:

1. A method comprising:
receiving a request to create unspecified relational database structures for storing, in a relational database, structured documents described by at least a first schema description that references a second schema description;
in response to receiving the request:
determining that the first schema description uses a first set of entities of the second schema description, wherein the second schema description includes the first set of entities and a second set of entities that are not used by the first schema description; and
creating first relational database structures corresponding to the first set of entities of the second schema description without creating second relational database structures corresponding to the second set of entities of the second schema description;

wherein the method is performed by one or more special-purpose computing devices.

2. The method of claim 1 , wherein the structured documents comprise XML documents, wherein the first schema description comprises a first XML schema, and wherein the second schema description comprises a second XML schema.

3. The method of claim 1 , wherein the first relational database structures comprise relational database tables and types.

4. The method of claim 1 , comprising creating a structured index that indexes the first set of entities of the second schema description but not the second set of entities of the second schema description.

5. A method comprising:
receiving a request to create an unspecified relational schema for storing, in a relational database, structured documents described by one or more schema descriptions;
in response to receiving the request, storing particular information that defines a set of entities included in the one or more schema descriptions without creating relational database structures for the set of entities;
using the particular information to execute a database command that references one or more entities of the set of entities even though one or more relational database structures for the one or more entities have not been created;
wherein the method is performed by one or more special-purpose computing devices.

6. The method of claim 5 , wherein the structured documents comprise XML documents, wherein the one or more schema descriptions comprises one or more XML schemas.

7. The method of claim 5 , wherein the storing of the particular information comprises storing the particular information without creating relational database tables and types that represent entities of the set of entities.

8. The method of claim 5 , further including;
receiving from a client a second request to execute the one or more database commands,
executing the one or more database commands without any indication to the client that the one or more relational database structures did not exist when the second request was received.

9. The method of claim 5 , comprising:
receiving a second request to store data for at least one entity of the set of entities; and
in response to receiving the second request:
using the particular information to create at least one new relational database structure for the at least one entity; and
storing the data in the at least one new relational database structure.

10. The method of claim 9 , wherein the storing of the particular information comprises storing the particular information without creating relational database tables and types that represent entities of the set of entities, and wherein the using of the particular information to create at least one new relational database structure for the at least one entity comprises using the particular information to create at least one new relational database table and type that represents the at least one entity.

11. The method of claim 9 , wherein receiving a second request includes receiving the second request from a client, the method further including executing the second request without any indication to the client that the one or more relational database structures did not exist when the second request was received.

12. One or more non-transitory storage media comprising stored instructions which, when executed by one or more computing devices, cause:
receiving a request to create unspecified relational database structures for storing, in a relational database, structured documents described by at least a first schema description that references a second schema description;
in response to receiving the request:
determining that the first schema description uses a first set of entities of the second schema description, wherein the second schema description includes the first set of entities and a second set of entities that are not used by the first schema description; and
creating first relational database structures corresponding to the first set of entities of the second schema description without creating second relational database structures corresponding to the second set of entities of the second schema description.

13. The one or more non-transitory storage media of claim 12 , wherein the structured documents comprise XML documents, wherein the first schema description comprises a first XML schema, and wherein the second schema description comprises a second XML schema.

14. The one or more non-transitory storage media of claim 12 , wherein the first relational database structures comprise relational database tables and types.

15. The one or more non-transitory storage media of claim 12 , wherein the instructions include instructions that, when executed by said one or more computing devices, cause creating a structured index that indexes the first set of entities of the second schema description but not the second set of entities of the second schema description.

16. One or more non-transitory storage media comprising stored instructions which, when executed by one or more computing devices, cause:
receiving a request to create an unspecified relational schema for storing, in a relational database, structured documents described by one or more schema descriptions;
in response to receiving the request, storing particular information that defines a set of entities included in the one or more schema descriptions without creating relational database structures for the set of entities;
using the particular information to execute a database command that references one or more entities of the set of entities even though one or more relational database structures for the one or more entities have not been created.

17. The one or more non-transitory storage media of claim 16 , wherein the structured documents comprise XML documents, wherein the one or more schema descriptions comprises one or more XML schemas.

18. The one or more non-transitory storage media of claim 16 , wherein the instructions include instructions that, when executed by said one or more computing devices, cause the storing of the particular information at least in part by storing the particular information without creating relational database tables and types that represent entities of the set of entities.

19. The one or more non-transitory storage media of claim 16 , wherein the instructions include instructions that, when executed by said one or more computing devices, cause:
receiving from a client a second request to execute the one or more database commands;
executing the one or more database commands without any indication to the client that the one or more relational database structures did not exist when the second request was received.

Assignees

• Oracle Int Corp

Inventors

• Hammerschmidt Beda
• Liu Zhen Hua
• Baby Thomas
• Zhou Kongyi

Classifications

• G06F17/30312 Primary

  Physics · mapped topic

• G06F17/30595

  Physics · mapped topic

• G06F16/22 Primary

  Indexing; Data structures therefor; Storage structures · CPC title

• G06F16/284 Primary

  Relational databases · CPC title