Systems and methods for managing offline database access

A computer system for improving accessibility of data objects stored in an online database between computing devices by providing uninterrupted access of the data objects when the online database is undergoing maintenance operations when the data objects would otherwise be inaccessible, the computer system comprising at least one processor communicatively coupled to a memory and in communication with the online database, the online database comprising a view function and a plurality of data objects, the at least one processor configured to:

• storing, in the online database, a current switch parameter and the data object, the switch parameter including a first unique identifier of the plurality of unique identifiers of the plurality of instances, the first unique identifier corresponding to a first instance of the data object, the first instance of the data object being the active instance and the other instances of the plurality of instances being the inactive instances;
• receive, by the view function associated with a switch parameter, a client query from a requestor, wherein the client query is directed to a data object of the plurality of data objects stored in the online database, the data object comprising a plurality of instances of the data object, each of the plurality of instances (i) identified by a corresponding one of a plurality of unique identifiers and (ii) represented by a database table, wherein the switch parameter is a unique identifier indicative of a status of an instance of a data object of the plurality of data objects stored in the online database, wherein the status includes an active status or an inactive status when the data object of the online database is undergoing a maintenance operation;
• modify the received client query, by the view function, based on the switch parameter to create a resultant query defining a plurality of sub-queries each (i) including the switch parameter and (ii) directed to a corresponding one of the plurality of instances, each respective sub-query configured to return results only if the switch parameter matches one of the plurality of unique identifiers associated with the corresponding instance of the data object;
• generate resultant data from the online database by executing the resultant query, the resultant data including output from the active instance of the data object and excluding output from the other instances of the plurality of instances of the data object, wherein the other instances are designated as inactive instances, wherein executing the resultant query comprises comparing, by each sub-query, each unique identifier of each corresponding instance of the data object to the switch parameter, and wherein one or more operations are performed on at least one inactive instance of the other instances of the data object while the active instance of the data object provides access to data from the online database storing the plurality of data objects;
• and
• provide the resultant data to the requestor in response to the client query.

At least one non-transitory computer-readable storage medium for improving accessibility of data objects stored in an online database between computing devices by providing uninterrupted access to the data objects when the online database is undergoing maintenance operations when the data objects would otherwise be inaccessible, the at least one non-transitory computer-readable storage medium having computer-executable instructions embodied thereon, the online database including a view function and a plurality of data objects, wherein, when executed by at least one processor coupled to an online database, the computer-executable instructions cause the at least one processor to:

• store, in the online database, the switch parameter and the data object, the switch parameter including a first unique identifier of the plurality of unique identifiers of the plurality of instances, the first unique identifier corresponding to a first instance of the data object, the first instance of the data object being the active instance and the other instances of the plurality of instances being the inactive instances;
• receive, by the view function associated with the switch parameter, a client query from a requestor, wherein the client query is directed to a data object of the plurality of data objects stored in the online database, the data object having a plurality of instances stored in the online database storing the data object, each of the plurality of instances of the data object (i) identified by a corresponding one of a plurality of unique identifiers and (ii) represented by a database table, wherein the switch parameter is a unique identifier indicative of a status of an instance of a data object of the plurality of data objects stored in the online database, wherein the status includes an active status or an inactive status when the data object of the online database is undergoing a maintenance operation;
• modify the received client query, by the view function, based on the switch parameter to create a resultant query defining a plurality of sub-queries each (i) including the switch parameter and (ii) directed to a corresponding one of the plurality of instances, each respective sub-query configured to return results only if the switch parameter matches one of the plurality of unique identifiers associated with the corresponding instance of the data object;
• generate resultant data from the online database by executing the resultant query, the resultant data including output from the active instance of the data object and excluding output from the other instances of the plurality of instances of the data object, wherein the other instances are designated as inactive instances, wherein executing the resultant query includes comparing, by each sub-query, each unique identifier of each corresponding instance of the data object to the switch parameter, and wherein one or more operations are performed on at least one inactive instance of the other instances of the data object while the active instance of the data object provides access to data from the online database storing the plurality of data objects;
• and
• provide the resultant data to the requestor in response to the client query.