Application tier data dictionary

Patent metadata

Field	Value
Publication number	US-9424323-B2
Application number	US-2379808-A
Country	US
Kind code	B2
Filing date	Jan 31, 2008
Priority date	Jan 31, 2008
Publication date	Aug 23, 2016
Grant date	Aug 23, 2016

Abstract

A method of tracking dependencies in an application file, including analyzing the application file to identify at least one dependency in the application file, extracting information from the application file related to the dependency to allow identification of an entity to which the application file has a dependency from the information, and storing the dependency for the application file in the application tier data dictionary. A system has a memory, at a first tier, to store an application tier data dictionary and at least one application file, and a processor at the first tier to determine dependencies in the application file, store the dependencies in the application tier data dictionary, communicate with a second tier, separate from the first tier, as needed to access information with regard to the dependencies, and store the information in the application tier data dictionary.

First claim

What is claimed is:

1. A method of tracking dependencies in an application file, comprising:
in a three-tier system having a client tier, an application tier and a database tier, populating an application tier data dictionary with information from a database tier data dictionary;
analyzing the application file to identify at least one dependency in the application file wherein each dependency of the at least one dependency is a connection between the application file and at least one entity, wherein the at least one entity is one of a data source, data object, other application file, or a supplemental file, associated file, and the application file resides on the application tier;
extracting information from the application file related to the at least one dependency to allow identification of the at least one dependency from the extracted information;
determining, based on the extracted information, whether the at least one dependency exists in the application tier data dictionary;
in response to determining, updating the application tier data dictionary with the at least one entity if the at least one dependency exists, or storing the at least one dependency for the application file in the application tier data dictionary if the at least one dependency does not exist, wherein the application tier data dictionary is a repository located on the application tier, wherein the at least one dependency is stored in a table organized by the application file's name.

2. The method of claim 1 , wherein analyzing the application file further comprises identifying strings within the application file.

3. The method of claim 2 , wherein extracting information comprises:
extracting the strings and converting each term in the string to a token; and
accessing the application tier data dictionary comprises using the token to determine if the token represents one of either a database object or database synonym dependency.

4. The method of claim 3 , wherein accessing an application tier data dictionary further comprises:
determining that at least one hashmap collection in the application tier data dictionary has not been populated;
accessing the database tier data dictionary using the token; and
retrieving a portion of the database tier data dictionary associated with the token.

5. The method of claim 3 , wherein accessing the application tier data dictionary using the token comprises using the token as an index into at least one hashmap collection.

6. The method of claim 1 , wherein analyzing the application file comprises parsing the application file to locate at least one of an import statement or a subroutine call.

7. The method of claim 6 , wherein extracting information comprises extracting at least one of a file, class or package name as the at least one entity to which the application file has a dependency.

8. The method of claim 7 , wherein storing the at least one dependency further comprising storing at least one of the name of the file, class or package name associated with the application file in the application tier data dictionary.

9. The method of claim 1 , wherein analyzing the application file comprises identifying a name of an associated file.

10. The method of claim 9 , wherein extracting the information comprises extracting at least name of at least one of a data source, a file, a class, and another associated file from the associated file.

11. The method of claim 10 , wherein storing the at least one dependency further comprises storing the name and associating the name with the application file in the application tier data dictionary.

12. A non-transitory computer-readable medium having stored thereon computer-readable instructions that, when executed, cause the computer to:
in a three-tier system having a client tier, an application tier and a database tier, populating an application tier data dictionary with information from a database tier data dictionary;
analyze the application file to identify at least one dependency in the application file, wherein each dependency of the at least one dependency is a connection between an application and at least one entity, wherein the at least one entity is one of a data source, data object, other application file, or a supplemental file, associated file, and the application file resides on the application tier;
extract information from the application file related to the at least one dependency to allow identification of the at least one dependency from the extracted information;
determine, based on the extracted information, whether the at least one dependency exists in the application tier data dictionary;
in response to determining, update the application tier data dictionary with the at least one entity if the at least one dependency exists, or store the at least one dependency for the application file in the application tier data dictionary if the at least one dependency does not exist, wherein the application tier data dictionary is a repository located on the application tier, wherein the at least one dependency is stored in a table organized by the application file's name.

13. The computer-readable medium of claim 12 , the instructions that cause the computer to analyze the application file further cause the computer to execute a lexical analyzer to locate strings in the application file.

14. The computer-readable medium of claim 13 , the instructions that cause the computer to extract information further cause the computer to:
extract each term from the strings in the application file; and
use each term from the strings as a token.

15. The computer-readable medium of claim 12 , the instructions that cause the computer analyze the application file cause the computer to parse the application file to locate file names used in one of either an import statement or a subroutine call.

16. The computer-readable medium of claim 12 , the instructions that cause the computer to analyze the application file further cause the computer to identify a text file associated with the application file.

17. A system, comprising:
a memory, at a first tier, to store an application tier data dictionary and at least one application file, wherein the application tier data dictionary is a repository located on the application tier in a system having a client tier, an application tier and a database tier; and
a processor at the first tier to:
populate the application tier data dictionary on the application tier with information from the system data dictionary on the database tier;
analyze the at least one application file to identify at least one dependency in the at least one application file, wherein each dependency of the at least one dependency is a connection between an application and at least one entity, wherein the at least one entity is one of a data source, data object, other application file, or a supplemental file, associated file, and the application file resides on the application tier;
extract information from the at least one application file related to the at least one dependency to allow identification of the at least one dependency from the extracted information;
determine, based on the extracted information, whether the at least one dependency exists in the application tier data dictionary;
in response to determining, update the application tier data dictionary with the at least one entity if the at least one dependency exists, or store the at least one dependency for the at least one application file in the application tier data dictionary if the at least one dependency does not exist, wherein the applicatio

Assignees

• Mishra Amulya
• Rajasekaran Vinoth Kumar
• Fothergill Alan
• Steinmeier Oliver
• Mizuta Kenichi
• Oracle Int Corp

Inventors

• Mishra Amulya
• Rajasekaran Vinoth Kumar
• Fothergill Alan
• Steinmeier Oliver
• Mizuta Kenichi

Classifications

• G06F16/258 Primary

  Data format conversion from or to a database · CPC title

• G06F8/71

  Version control (security arrangements therefor G06F21/57); Configuration management · CPC title

• G06F17/30569 Primary

  Physics · mapped topic