Techniques and Architectures for Native Data Field Lifecycle Management

Patent metadata

Field	Value
Publication number	US-2018373684-A1
Application number	US-201715631250-A
Country	US
Kind code	A1
Filing date	Jun 23, 2017
Priority date	Jun 23, 2017
Publication date	Dec 27, 2018
Grant date	—

Abstract

Techniques for maintaining a data dictionary within a computing platform that provides a multitenant environment in which multiple tenants utilizing the multitenant environment share a single instance of a database. The data dictionary is maintained with referential integrity utilizing custom database objects to provide metadata corresponding to the data dictionary. The data dictionary tracks attributes for the custom database objects utilizing natively supported field attributes and the custom database objects maintain tenant-specific information. The custom database objects are automatically updated corresponding to the data dictionary. A notification to one or more users is generated for custom database objects that correspond to the data dictionary that cannot be updated automatically, if any.

First claim

What is claimed is:

1 . A non-transitory computer-readable medium having stored thereon instructions that when executed by one or more processors, are configurable to cause the one or more processors to maintain a data dictionary within a computing platform that provides a multitenant environment in which multiple tenants utilizing the multitenant environment share a single instance of a database, the one or more processors to:
maintain, in the data dictionary and with referential integrity, one or more custom database objects to provide metadata corresponding to the data dictionary, wherein the data dictionary tracks attributes for the custom database objects utilizing natively supported field attributes and the custom database objects maintain tenant-specific information; update, automatically, the one or more custom database objects corresponding to the data dictionary; and generate a notification to one or more users for one or more custom database objects that correspond to the data dictionary that cannot be updated automatically, if any.

2 . The non-transitory computer-readable medium of claim 1 wherein the custom database object comprises a fill rate indicates the percent of total records in which the field has been used.

3 . The non-transitory computer-readable medium of claim 1 wherein the custom database object comprises an indication of one or more people responsible for the field.

4 . The non-transitory computer-readable medium of claim 1 wherein the custom database object comprises an indication of a current status of the corresponding field.

5 . The non-transitory computer-readable medium of claim 1 wherein the custom database object is created based on information received via a graphical user interface.

6 . A method for maintaining a data dictionary within a computing platform that provides a multitenant environment in which multiple tenants utilizing the multitenant environment share a single instance of a database, the method comprising:
maintaining, in the data dictionary and with referential integrity, one or more custom database objects to provide metadata corresponding to the data dictionary, wherein the data dictionary tracks attributes for the custom database objects utilizing natively supported field attributes and the custom database objects maintain tenant-specific information; updating, automatically, the one or more custom database objects corresponding to the data dictionary; and generating a notification to one or more users for one or more custom database objects that correspond to the data dictionary that cannot be updated automatically, if any.

7 . The method of claim 6 wherein the custom database object comprises a fill rate indicates the percent of total records in which the field has been used.

8 . The method of claim 6 wherein the custom database object comprises an indication of one or more people responsible for the field.

9 . The method of claim 6 wherein the custom database object comprises an indication of a current status of the corresponding field.

10 . The method of claim 6 wherein the custom database object is created based on information received via a graphical user interface.

11 . A system comprising:
a memory device; one or more hardware processors coupled with the memory device one or more processors configurable to maintain a data dictionary within a computing platform that provides a multitenant environment in which multiple tenants utilizing the multitenant environment share a single instance of a database, the one or more processors to maintain, in the data dictionary and with referential integrity, one or more custom database objects to provide metadata corresponding to the data dictionary, wherein the data dictionary tracks attributes for the custom database objects utilizing natively supported field attributes and the custom database objects maintain tenant-specific information, to update, automatically, the one or more custom database objects corresponding to the data dictionary, and to generate a notification to one or more users for one or more custom database objects that correspond to the data dictionary that cannot be updated automatically, if any.

12 . The system of claim 11 wherein the custom database object comprises a fill rate indicates the percent of total records in which the field has been used.

13 . The system of claim 11 wherein the custom database object comprises an indication of one or more people responsible for the field.

14 . The system of claim 11 wherein the custom database object comprises an indication of a current status of the corresponding field.

15 . The system of claim 11 wherein the custom database object is created based on information received via a graphical user interface.

16 . An apparatus for maintaining a data dictionary within a computing platform that provides a multitenant environment in which multiple tenants utilizing the multitenant environment share a single instance of a database, the method comprising:
means for maintaining, in the data dictionary and with referential integrity, one or more custom database objects to provide metadata corresponding to the data dictionary, wherein the data dictionary tracks attributes for the custom database objects utilizing natively supported field attributes and the custom database objects maintain tenant-specific information; means for updating, automatically, the one or more custom database objects corresponding to the data dictionary; and means for generating a notification to one or more users for one or more custom database objects that correspond to the data dictionary that cannot be updated automatically, if any.

17 . The apparatus of claim 16 wherein the custom database object comprises a fill rate indicates the percent of total records in which the field has been used.

18 . The apparatus of claim 16 wherein the custom database object comprises an indication of one or more people responsible for the field.

19 . The apparatus of claim 16 wherein the custom database object comprises an indication of a current status of the corresponding field.

20 . The apparatus of claim 16 wherein the custom database object is created based on information received via a graphical user interface.

Assignees

• Salesforce Com Inc

Inventors

• Henvy Kelly

Classifications

• G06F40/157 Primary

  using dictionaries or tables · CPC title

• G06F16/907 Primary

  Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually · CPC title

• G06F16/2358

  Change logging, detection, and notification (replication G06F16/27) · CPC title

• G06F17/2276 Primary

  Physics · mapped topic

• G06F17/30368

  Physics · mapped topic