| 主权项 |
1. A method for processing a query in a multi-tenancy environment utilizing an electronic computing device, the method comprising:
causing the electronic computing device to receive the query to a database, wherein the query includes a plurality of objects, and wherein the database comprises,
a database instance of the database, wherein the database instance includes a set of instance database objects, and wherein the database instance is accessible by a plurality of instance users,at least one database tenant associated with the database instance, wherein the at least one database tenant includes a set of tenant database objects, wherein the at least one database tenant provides access to the database instance by a plurality of tenant users, such that the plurality of instance users and the plurality of tenant users may independently access the database instance without affecting one another, wherein each of the plurality of instance users and the plurality of tenant users are configured with independent accessibility, wherein the at least one database tenant is addressable by a namespace of the form, DATABASE.TENANT.SCHEMA.TABLENAME, wherein DATABASE identifies a database system instance, wherein TENANT identifies a database tenant, wherein SCHEMA identifies a table owner, and wherein TABLENAME identifies a table within the SCHEMA, and wherein the namespace is configured to allow the database to store multiple production tables in the same database instance while keeping the multiple production tables having a same name completely independent from one another,a plurality of instance production tables associated with the database instance for storing a portion of the set of instance database objects, the plurality of instance production tables accessible by the plurality of instance users and the plurality of tenant users wherein at least some of the set of tenant database objects correspond with a portion of the set of instance database objects, anda plurality of tenant production tables associated with the database instance for storing the set of tenant database objects, the plurality of tenant production tables accessible by the plurality of tenant users and not accessible by the plurality of instance users; causing the electronic computing device to determine whether any of the plurality of objects correspond with the set of tenant database objects; if any of the plurality of objects correspond with the set of tenant database objects, causing the electronic computing device to process the plurality of objects from the tenant production table; and if any of the plurality of objects correspond with the set of instance database objects, causing the electronic computing device to process the plurality of objects from the instance production table. |
