Systems and methods of operation lock management and system catalog overrides in database systems

A system comprising:

• a database system to store records and execute one or more database operations;
• a storage catalog server that includes a storage catalog to record information about system catalog overrides for active workflows of the database system;
• a shared memory, communicatively coupled to the database system and the storage catalog server, to store current system catalog overrides and locks for at least one of a tenant and an index of a first workflow of the database system, wherein the current system catalog overrides include at least a portion of the system catalog overrides and locks that are retrieved by the shared memory from the storage catalog server at a predetermined point in time, and wherein the shared memory includes the current system catalog overrides for at least the first workflow,
• wherein the database system performs a check of at least one of index validity and tenant validity for a second workflow or other database operation by checking a state of the current system catalog overrides in the shared memory, and
• wherein the system catalog overrides suppress visibility of the respective system catalog changes when the database system determines that at least one of the index and the tenant is invalid based on the current system catalog overrides for the first workflow.