METADATA MANAGER FOR ANALYTICS SYSTEM

• US 20140229511A1
• Filed: 02/11/2013
• Published: 08/14/2014
• Est. Priority Date: 02/11/2013
• Status: Active Grant

• Current Assignee: Dell Products LP (Dell Technologies Inc.)
• Original Assignee: Dell Products LP (Dell Technologies Inc.)
• Inventors: Tung, David, Chan, Hon Yuk, Bengali, Ketan, Patra, Sasmita, Chang, Ming
• Granted Patent: US 9,442,993 B2
• Time in Patent Office: Days
• US Class Current: 707/803
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/2379 Updates performed during online database operations; commit processing
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

A metadata management system receives metadata changes and automatically updates a metadata architecture which maps the data. The metadata changes may be received through a simple user interface by a user or administrator. Once received, the system may automatically update schemas and data transformation code to process data according to the new data mapping preference. The system may handle metadata updates in a multi-tenant system having one or more applications per tenant, and may update data for a single tenant and 1 or more tenant applications in a multitenancy.

Claims

1. A method for managing metadata, comprising:

receiving a metadata update by a server for a first tenant of a plurality of tenants;

automatically updating metadata schema for the first tenant by the server; and

mapping schema for the first tenant based on the updated metadata schema.

2. The method of claim 1, wherein receiving the metadata update includes receiving an update to star schema for the first tenant.

3. The method of claim 2, wherein the star schema is associated with a first application of a plurality of applications for which data is mapped for the first tenant.

4. The method of claim 1, wherein receiving the metadata update includes receiving column mapping data.

5. The method of claim 1, wherein receiving the metadata update includes receiving star schema name data.

6. The method of claim 1, wherein automatically updating includes automatically updating staging schema by an application server.

7. The method of claim 1, wherein automatically updating includes automatically updating star schema by an application server.

8. The method of claim 1, wherein automatically updating includes automatically generating a script to transform staging schema data into star schema data.

9. A computer readable non-transitory storage medium having embodied thereon a program, the program being executable by a processor to perform a method for managing metadata, the method comprising:

receiving a metadata update for a first tenant of a plurality of tenants;

automatically updating metadata mapping schema for the first tenant; and

mapping schema for the first tenant based on the updated metadata schema.

10. The computer readable non-transitory storage medium of claim 9, wherein receiving the metadata update includes receiving an update to star schema for the first tenant.

11. The computer readable non-transitory storage medium of claim 10, wherein the star schema is associated with a first application of a plurality of applications for which data is mapped for the first tenant.

12. The computer readable non-transitory storage medium of claim 9, wherein receiving the metadata update includes receiving column mapping data.

13. The computer readable non-transitory storage medium of claim 9, wherein receiving the metadata update includes receiving star schema name data.

14. The computer readable non-transitory storage medium of claim 9, wherein automatically updating includes automatically updating staging schema by an application server.

15. The computer readable non-transitory storage medium of claim 9, wherein automatically updating includes automatically updating star schema by an application server.

16. The computer readable non-transitory storage medium of claim 9, wherein automatically updating includes automatically generating a script to transform staging schema data into star schema data.

18. A system for managing metadata, comprising:

a memory;

a processor; and

one or more modules stored in memory and executable by the processor to;

receive a metadata update for a first tenant of a plurality of tenants;

automatically update metadata schema for the first tenant; and

mapping schema for the first tenant based on the updated metadata schema.