Systems and methods of sharing a database across multiple deployments and services

Patent metadata

Field	Value
Publication number	US-11403306-B2
Application number	US-202016992584-A
Country	US
Kind code	B2
Filing date	Aug 13, 2020
Priority date	Jun 21, 2017
Publication date	Aug 2, 2022
Grant date	Aug 2, 2022

Abstract

Techniques for implementing a non-relational database that makes efficient use of collections within the database. For one or more collections, two or more sub-collections can be created for storing documents. Each collection can be configured as a single partition entity or a partitioned entity within the database. Each sub-collection is identified by a sub-collection identifier. If the collection is configured as a partitioned entity, then a partition key can be determined for documents to be accessed in the collection. The partition key can be extended with the sub-collection ID to form a compound property (sub-collection ID, partition key) that determines placements of the respective documents in the identified sub-collection across partitions of the collection. If the collection is configured as a single partition entity, then a field for the partition key is ignored and the respective documents are placed in the identified sub-collection within the single partition of the collection.

First claim

What is claimed is:

1. A method comprising:
generating a sub-collection of a group of documents within a non-relational database, the sub-collection including a document from the group, the sub-collection having a sub-collection identifier (ID) including a plurality of identifiers;
receiving a query to access the document, the query including a plurality of query fields containing the plurality of identifiers, respectively;
identifying the sub-collection using the plurality of identifiers contained in the plurality of query fields, respectively; and
providing access to the document of the group within the non-relational database in response to identification of the sub-collection.

2. The method of claim 1 wherein the document has a format that includes a plurality of document fields, and wherein the method further comprises:
inserting the plurality of identifiers into the plurality of document fields, respectively.

3. The method of claim 2 further comprising:
providing access to the plurality of identifiers from the plurality of document fields, respectively.

4. The method of claim 1 further comprising:
creating the group of documents as a single partition entity of the non-relational database.

5. The method of claim 4 further comprising:
creating the sub-collection of the group within the single partition entity of the non-relational database.

6. The method of claim 1 wherein the identifying of the sub-collection includes obtaining the plurality of identifiers from the plurality of query fields, respectively, the plurality of identifiers including two or more of a first identifier for a deployment of an application under development, a second identifier for a microservice of the deployment, and a third identifier for a database object type associated with the document.

7. A method comprising:
generating a sub-collection of a group of documents within a non-relational database by partition of the non-relational database, the sub-collection including a document of the group, the sub-collection having a sub-collection identifier (ID) including a plurality of identifiers;
receiving a query to access the document of the group, the query including a partition key and a plurality of query fields containing the plurality of identifiers, respectively;
identifying the sub-collection using the plurality of identifiers contained in the plurality of query fields, respectively; and providing access to the document from the identified sub-collection of the non-relational database using the partition key.

8. The method of claim 7 wherein the document has a format that includes at least a first document field, and wherein the method further comprises:
inserting the partition key into the first document field.

9. The method of claim 8 wherein the format of the document further includes at least one second document field, and wherein the method further comprises:
inserting the sub-collection ID into the at least one second document field.

10. The method of claim 9 further comprising:
obtaining the partition key from the first document field.

11. The method of claim 10 further comprising:
obtaining the sub-collection ID from the at least one second document field.

12. The method of claim 7 wherein the identifying of the sub-collection includes obtaining the plurality of identifiers from the plurality of query fields, respectively, the plurality of identifiers including two or more of a first identifier for a deployment of an application under development, a second identifier for a microservice of the deployment, and a third identifier for a database object type associated with the document.

13. A system comprising:
a database server including processing circuitry and a data storage resource, the data storage resource containing a non-relational database,
wherein the processing circuitry is configured to:
generate a sub-collection of a group of documents within the non-relational database, the sub-collection including a document from the group, the sub-collection having a sub-collection identifier (ID) including a plurality of identifiers;
receive a query to access the document, the query including a plurality of query fields containing the plurality of identifiers, respectively;
identify the sub-collection using the plurality of identifiers contained in the plurality of query fields, respectively; and
provide access to the document of the group within the non-relational database in response to identification of the sub-collection.

14. The system of claim 13 wherein the document has a format that includes a plurality of document fields, and wherein the processing circuitry is further configured to insert the plurality of identifiers into the plurality of document fields, respectively.

15. The system of claim 14 wherein the processing circuitry is further configured to provide access to the plurality of identifiers from the plurality of document fields, respectively.

16. The system of claim 13 wherein the processing circuitry is further configured to create the group of documents as a single partition entity of the non-relational database.

17. The system of claim 16 wherein the processing circuitry is further configured to create the sub-collection of the group within the single partition entity of the non-relational database.

Assignees

• Citrix Systems Inc

Inventors

• Kaliavaradhan Sathishkumar
• Shah Amit
• Keller Steven
• Huang Xiaodong
• Jain Ayush

Classifications

• G06F16/28 Primary

  Databases characterised by their database models, e.g. relational or object models · CPC title

• G06F16/278

  Data partitioning, e.g. horizontal or vertical partitioning · CPC title

• G06F16/2465 Primary

  Query processing support for facilitating data mining operations in structured databases · CPC title

• G06F16/33

  Querying · CPC title