Method and System for Exploring Objects in a Data Dictionary

• US 20110282899A1
• Filed: 05/12/2011
• Published: 11/17/2011
• Est. Priority Date: 05/13/2010
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Mathew, Reena, Zheng, Zuye
• Granted Patent: US 8,972,439 B2
• Time in Patent Office: Days
• US Class Current: 707/769
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence

Abstract

Mechanisms and methods for exploring objects in a data dictionary may enable embodiments to provide a simple and efficient tool for understanding dependencies between entities. The ability to provide a visual format for representing dependency information of entities may enable database developers to efficiently explore objects in a data dictionary and better understand the dependencies of entities in the database. In an embodiment, methods for exploring objects in a database can be applied to multi-tenant database systems.

Claims

1. A method for exploring a data dictionary of a database in a multi-tenant database system, comprising:

sending from a host system, a page with a user interface having an input area that receives input data related to an identity of an entity object, the entity object being one of a collection of objects that perform database related activities, the entity objects in the collection facilitate writing code for performing the database related activities without being familiar with details of a database server of the database, the host system including one or more machines including a processor system having at least one or more processors and a memory system that stores the database, and metadata associated with the entity object;

receiving, by the host system, the page with the selection of the entity object;

retrieving, by the processor system, metadata of a set of one or more entity objects from the collection based on the input data related to the identity; and

sending, from the host system, a data description of at least one of the entity object associated with the entity object including at least the metadata of the entity object.

2. The method of claim 1, the metadata includes dependencies of the entity object and a direction of the dependencies.

3. The method of claim 2, the dependencies of at least the entity object and the direction of the dependencies include dependencies of objects that are specific to a particular tenant of the multitenant database.

4. The method of claim 1, the page with the data is customizable, having a header section that is collapsible, the header section including a pull down menu for entering a layer in which the entity object is available.

5. The method of claim 1, the page with the data is interactive, and includes a field for entering an organization identifier that the entity object is associated with.

6. The method of claim 1, the data description sent includes a graphical format with entity object as a node and dependent objects as child nodes.

7. The method of claim 6, the sending of the data description includes sending information that causes the nodes to have a visual coding, such that nodes of standard entity objects that are provided to all tenants have a first type of visual appearance, nodes of custom entity objects that are created for a specific tenant have a second type of visual appearance.

8. The method of claim 6, the sending of the data description includes sending information that causes the nodes to have a color coding, such that nodes of standard entity objects that are provided to all tenants are colored with first color, and nodes of custom entity objects that are created for a specific tenant colored with a second color.

9. The method of claim 6, the sending of the data description includes sending a value representing how many child nodes are dependent on a given node, and sending information causing the value to be displayed next to the given node.

10. The method of claim 1, the retrieving of the metadata includes retrieving data that is updated in real time.

11. The method of claim 6, further comprising sending information that causes a question mark to be displayed, instead of a value representing how many nodes, next to a node in the graph for which metadata was not retrieved that is adequate for determining how many nodes depend from the object entity represented by the node in the graph.

12. The method of claim 1, further comprising presenting to the user a choice of direction of relationships of nodes for the user to choose.

13. The method of claim 1,

the metadata includes at least

a representation of a standard entity object that is provided to multiple tenants,

a representation of a custom entity object that is specific to a tenant, and

dependency information related to the entity object and a representation of a direction of the dependencies;

the page with the data is customizable having a tool to change a direction of the dependencies displayed,

includes a field for entering an organization identification number displays data of the organization; and

the page with the data is presented in a graphical format includes nodes representing entity objects and arrows representing relationships between entity objects,

nodes contain the metadata and relationship of the metadata and the nodes are color coded with different colors representing at least standard metadata, custom metadata, standard relationship and custom relationship,

the metadata being retrieved from a location at which the metadata is updated in real time, and

next to each node number is displayed representing how many child nodes are associated with the node if information has been retrieved allows the number of child nodes to be determined and next to nodes for which information has not been retrieved allowing the number of child nodes to be determined a question mark is displayed.

14. A machine comprising:

machine readable media, storing thereon one or more instructions for implementing a web application that includes one or more instructions that cause the processor system to perform a method including at least;

sending from a host system, a page with a user interface having an input area that receives input data related to an identity of an entity object, the entity object being one of a collection of objects that perform database related activities, the entity objects in the collection facilitate writing code for performing the database related activities without being familiar with details of a database server of the database, the host system including one or more machines including a processor system having at least one or more processors and a memory system that stores the database, and metadata associated with the entity object;

receiving, by the host system, the page with the selection of the entity object;

retrieving, by the processor system, metadata of a set of one or more entity objects from the collection based on the input data related to the identity; and

sending, from the host system, a data description of at least one of the entity object associated with the entity object including at least the metadata of the entity object.

15. A machine-readable medium carrying one or more sequences of instructions for implementing a method for providing an interface for object relationships, the method comprising:

sending from a host system, a page with a user interface having an input area that receives input data related to an identity of an entity object, the entity object being one of a collection of objects that perform database related activities, the entity objects in the collection facilitate writing code for performing the database related activities without being familiar with details of a database server of the database, the host system including one or more machines including a processor system having at least one or more processors and a memory system that stores the database, and metadata associated with the entity object;

receiving, by the host system, the page with the selection of the entity object;

retrieving, by the processor system, metadata of a set of one or more entity objects from the collection based on the input data related to the identity; and

sending, from the host system, a data description of at least one of the entity object associated with the entity object including at least the metadata of the entity object.