CLIENT-SPECIFIC DATA CUSTOMIZATION FOR SHARED DATABASES
First Claim
1. A method, comprising:
- receiving, at a processor associated with a software as a service (SaaS) module, a client identifier (ID) and a client-specific data field identifier for each item of client-specific data associated with a first client of a plurality of clients;
creating, for the first client, an extensible markup language (XML) formatted document for storing the client-specific data comprising a plurality of client-specific data elements, each element referenced by one of the client-specific data field identifiers;
inserting the XML formatted document into an XML formatted column of a row in a database table, where the database table is shared among a plurality of clients and stored in a shared database; and
inserting the client ID into a structured query language (SQL) formatted data column of the row in the database table.
1 Assignment
0 Petitions
Accused Products
Abstract
A client identifier (ID) and a client-specific data field identifier for each item of client-specific data associated with a first client of a set of clients are received at a processor associated with a software as a service (SaaS) module. An extensible markup language (XML) formatted document for storing the client-specific data, including a set of client-specific data elements, each element referenced by one of the client-specific data field identifiers, is created for the first client. The XML formatted document is inserted into an XML formatted column of a row in a database table, where the database table is shared among a set of clients and stored in a shared database. The client ID is inserted into a structured query language (SQL) formatted data column of the row in the database table.
95 Citations
20 Claims
-
1. A method, comprising:
-
receiving, at a processor associated with a software as a service (SaaS) module, a client identifier (ID) and a client-specific data field identifier for each item of client-specific data associated with a first client of a plurality of clients; creating, for the first client, an extensible markup language (XML) formatted document for storing the client-specific data comprising a plurality of client-specific data elements, each element referenced by one of the client-specific data field identifiers; inserting the XML formatted document into an XML formatted column of a row in a database table, where the database table is shared among a plurality of clients and stored in a shared database; and inserting the client ID into a structured query language (SQL) formatted data column of the row in the database table. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A system, comprising:
-
a database shared among a plurality of clients; and a processor programmed to; receive a client identifier (ID) and a client-specific data field identifier for each item of client-specific data associated with a first client of the plurality of clients; create, for the first client, an extensible markup language (XML) formatted document for storing the client-specific data comprising a plurality of client-specific data elements, each element referenced by one of the client-specific data field identifiers; insert the XML formatted document into an XML formatted column of a row in a database table, where the database table is shared among a plurality of clients and stored in a shared database; and insert the client ID into a structured query language (SQL) formatted data column of the row in the database table. - View Dependent Claims (9, 10, 11, 12, 13)
-
-
14. A computer program product comprising a computer readable storage medium including a computer readable program, where the computer readable program when executed on a computer causes the computer to:
-
receive, at a processor associated with a software as a service (SaaS) module, a client identifier (ID) and a client-specific data field identifier for each item of client-specific data associated with a first client of a plurality of clients; create, for the first client, an extensible markup language (XML) formatted document for storing the client-specific data comprising a plurality of client-specific data elements, each element referenced by one of the client-specific data field identifiers; insert the XML formatted document into an XML formatted column of a row in a database table, where the database table is shared among a plurality of clients and stored in a shared database; and insert the client ID into a structured query language (SQL) formatted data column of the row in the database table. - View Dependent Claims (15, 16, 17, 18, 19, 20)
-
Specification