Browse Prior Art Database

Method and System for Allowing On-Demand Extension of a Database Schema in a Multi-Tenant System

IP.com Disclosure Number: IPCOM000235678D
Publication Date: 2014-Mar-19
Document File: 3 page(s) / 97K

Publishing Venue

The IP.com Prior Art Database

Abstract

A method and system is disclosed for allowing on-demand extension of a database schema in a multi-tenant system. The method and system utilizes existing database technologies that allow one or more tenants to dynamically add new columns to the existing as well as new objects without affecting the function of Software as a Service (SaaS) system that allows creation of a database schema on demand.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 51% of the total text.

Page 01 of 3

Method and System for Allowing On-Demand Extension of a Database Schema in a Multi-Tenant System

Disclosed is a method and system for allowing on-demand extension of schema in a multi-tenant system. The method and system utilizes existing database technologies that allow tenants to dynamically add new columns to the existing objects as well as new objects without affecting the function of Software as a Service (SaaS) system. The tenants share a set of predefined tables and hold the data for extension of a database schema that can be created on-demand.

In accordance with the method and system, an algorithm is run on a database to make sure that columns are allocated to the left-most side of an extension table so as to make the database more efficient. However, when new columns are needed

for certain tenants beyond available extension table, a new extension table is created. The new extension table can thus be small enough or separated by data type for more efficiency based on a particular enterprise application. The extension table's field composition can be decided by a system administrator based on tenants' requirement which is different from one table to the other table. Thereafter, a metadata that describes each tenant's object extension is obtained and separated out from a physical storage. Further, based on the metadata obtained, a database view is created for each logical table corresponding to each tenant.

The method and system thus allows the tenants to achieve extension dynamically over time without impacting other tenants and obtain database object that is represented as a complete object. The method and system also allows indexing of the database tables through a regular database that turns based on tenants query usage. Indexing of database tables allows database functionalities such as but not limited to, reporting functionality, preserving query, achieving scalability, controlling number of tables, etc. The smaller the generated extension table on-demand, the more the usage of storage space, which enables most efficient use of storage space

available. It also overcomes normal sparse table inefficiency. The system administrator controls creation of tables and allows customization of tables by the tenants in more efficient way.

The method and system allows separation of the metadata related to each tenant's object extension from the database. As soon as a tenant starts customizing tables

by adding additional fields or objects, the tenant's own copy of metadata is created that shadows a shared master copy of the metadata. The system administrat...