Accessing schema-flexible data by applying a fixed schema
Disclosed herein are system, method, and computer program product embodiments for accessing a database collection. In some embodiments, an application generates a database collection. The database collection is configured to store documents (e.g., records). The application generates a database table definition. The database table definition is a proxy or adapter for the database collection. The application receives a request to be executed to be executed on the database collection from a client device. The request specifies the database table definition. The application accesses the database collection, via the database, to process the request using the database table definition.
1. A computer-implemented method, the computer-implemented method comprising:
receiving, from a first application, a request to access a collection, the collection comprising a plurality of documents, wherein the request includes a first schema for generating a first table definition for accessing the collection;
generating the first table definition for providing the first application access to the plurality of documents of the collection, the first table definition comprising a plurality of fields for accessing data in the plurality of documents of the collection;
receiving, from the first application, a request based on one or more of the plurality of fields of the first table definition to be executed on one or more documents of the plurality of documents of the collection, wherein the request comprises one of a insert or read command; and
accessing the one or more documents of the collection to process the request using the first table definition.
2. The computer-implemented method of claim 1 , wherein receiving the request based on one or more of the plurality of fields comprises inserting one or more values in a new document in the collection, wherein each of the one or more values corresponds with a respective field of a set of fields.
3. The computer-implemented method of claim 2 , wherein inserting the one or more values in the new document comprises populating a unique identification (ID) value of a user associated with the request in the new document.
4. The computer-implemented method of claim 1 , wherein the request based on one or more of the plurality of fields comprises a set of values to be inserted into a first document in the collection, and wherein the document comprises a set of fields from the plurality of fields.
5. The computer-implemented method of claim 4 , wherein the accessing comprises:
identifying the first document comprising a first value of the set of values, wherein the first value corresponds to a respective field of the set of fields;
inserting a second set of fields in the first document; and
populating the second set of fields with one or more of the set of values.
6. The computer-implemented method of claim 1 , wherein accessing comprises retrieving one or more values associated with a first document from the collection, wherein each of the one or more values corresponds with the first table definition.
7. The computer-implemented method of claim 1 , wherein the request based on one or more of the plurality of fields comprises an identifier of the first table definition.
8. The computer-implemented method of claim 1 , wherein the first application is configured to access the collection using the first table definition, and wherein a second application is configured to access the collection using a second table definition different from the first table definition.
9. A system for accessing a database collection, the system comprising:
a memory; and
a processor coupled to the memory, wherein the processor is configured to:
receive, from a first application, a request to access a collection, the collection comprising a plurality of documents, wherein the request includes a first schema for a first table definition for accessing the collection;
generate the first table definition for providing the first application access to the plurality of documents of the collection, the first table definition comprising a plurality of fields for accessing data in the plurality of documents of the collection;
receive, from the first application, a request based on one or more of the plurality of fields of the first table definition to be executed on one or more documents of the plurality of documents of the collection, wherein the request comprises one of a insert or read command; and
access the one or more documents of the collection to process the request using the first table definition.
10. The system of claim 9 , wherein receiving the request based on one or more of the plurality of fields comprises inserting one or more values in a new document in the collection, wherein each of the one or more values corresponds with a respective field of a set of fields.
11. The system of claim 10 , wherein inserting the one or more values in the new document comprises populating a unique identification (TD) value of a user associated with the request in the new document.
12. The system of claim 9 , wherein the request based on one or more of the plurality of fields comprises a set of values to be inserted into a first document in the collection, and wherein the document comprises a set of fields from the plurality of fields.
13. The system of claim 12 , wherein when the accessing the processor is configured to:
identify the first document comprising a first value of the set of values, wherein the first value corresponds to a respective field of the set of fields;
insert a second set of fields in the first document; and
populate the second set of fields with one or more of the set of values.
14. The system of claim 9 , wherein when wherein accessing comprises retrieving one or more values associated with a first document from the collection, wherein each of the one or more values corresponds with the first table definition.
15. The system of claim 9 , wherein the request based on one or more of the plurality of fields comprises an identifier of the first table definition.
16. A non-transitory computer-readable medium having instructions stored thereon that, when executed by at least one computing device, cause the at least one computing device to perform operations comprising:
receiving, from a first application, a request to access a collection, the collection comprising a plurality of documents, wherein the request includes a first schema for a first table definition for accessing the collection;
generating the first table definition for providing the first application access to the plurality of documents of the collection, the first table definition comprising a plurality of fields for accessing data in the plurality of documents of the collection;
receiving, from the first application, a request based on one or more of the plurality of fields of the first table definition to be executed on one or more documents of the plurality of documents of the collection, wherein the request comprises one of a insert or read command; and
accessing the one or more documents of the collection to process the request using the first table definition.
17. The non-transitory computer-readable medium of claim 16 , wherein receiving the request based on one or more of the plurality of fields comprises inserting one or more values in a new document in the collection, wherein each of the one or more values corresponds with a respective field of a set of fields.
18. The non-transitory computer-readable medium of claim 16 , wherein the request based on one or more of the plurality of fields comprises a set of values to be inserted into a first document in the collection, and wherein the document comprises a set of fields from the plurality of fields.
19. The non-transitory computer-readable medium of claim 18 , wherein the accessing comprises:
identifying the first document comprising a first value of the set of values, wherein the first value corresponds to a respective field of the set of fields;
inserting a second set of fields in the first document; and
populating the second set of fields with one or more of the set of values, wherein a field in the second set of fields has a foreign key relationship with the set of fields.
20. The non-transitory computer-readable medium of claim 16 , wherein accessing comprises retrieving one or more values associated with a first document from the collection, wherein each of the one or more values corresponds with the first table definition.