SYNCHRONIZING PRIMARY AND SECONDARY REPOSITORIES

• US 20120317075A1
• Filed: 06/13/2011
• Published: 12/13/2012
• Est. Priority Date: 06/13/2011
• Status: Active Grant

• Current Assignee: Business Objects Incorporated (SAP SE)
• Original Assignee: Business Objects Incorporated (SAP SE)
• Inventors: Pasumarthi, Suresh, Vaitheeswaran, Ganesh, Bhattacharjee, Arinadam, Nayak, Shiva Prasad
• Granted Patent: US 8,862,543 B2
• Time in Patent Office: Days
• US Class Current: 707/626
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

Abstract

Various embodiments of systems and methods for synchronizing a primary repository and a secondary repository in a business infrastructure are disclosed. Content of artifacts present in the primary repository and the secondary repository are indexed. Based upon a search criteria received on the secondary repository, an integrated search service provided on the secondary repository is invoked to perform a combinatorial query on the indexed content and retrieve an identifier of each artifact corresponding to the search criteria. Based upon relevancy parameters, the retrieved identifiers are ranked and rendered as a categorized table including a first column and a second column for identifiers present in the primary repository and the second repository respectively. Based upon a user action received on the ranked identifiers in the first column of the categorized table, the associated artifacts are determined and downloaded from the primary repository to the secondary repository.

Claims

1. A computer-implemented method to synchronize a primary repository and a secondary repository of data, the method comprising:

indexing content of one or more artifacts present in the primary repository and one or more artifacts present in the secondary repository;

based upon a search criteria received at the secondary repository, invoking an integrated search service associated with the secondary repository to perform a combinatorial query on the indexed content of the primary repository and the indexed content the secondary repository, and retrieve one or more identifiers of the one or more artifacts and associated metadata corresponding to the search criteria;

based upon one or more relevancy parameters, ranking the retrieved identifiers and rendering the ranked identifiers as a categorized table on the secondary repository; and

based upon a user action received on the ranked identifiers, determining the artifacts and the associated metadata present in the primary repository and downloading the determined artifacts and the associated metadata from the primary repository to the secondary repository.

2. The computer implemented method of claim 1, wherein indexing the content of the artifacts present in the primary repository and the artifacts present in the secondary repository comprises:

rendering a search service to continually crawl the primary repository and the secondary repository;

extracting one or more searchable content from the artifacts present in the primary repository and the artifacts present in the secondary repository;

creating a data structure to organize and store the searchable contents of the artifacts and enable an indexer to index the contents of the artifacts.

3. The computer implemented method of claim 1, wherein indexing the content of the artifacts comprises:

scheduling an index run to monitor the primary repository and the secondary repository; and

based upon a modification in the primary repository and the secondary repository, indexing the content of one or more modified artifacts or one or more new artifact, wherein the modification includes editing the artifacts or including one or more new artifacts.

4. The computer implemented method of claim 1, wherein the integrated search service provided on the secondary repository is configured to:

simultaneously query the primary repository, the secondary repository and a version manager, and

retrieve the artifacts and the associated metadata from primary repository, the secondary repository and the version manager,

wherein the version manager comprises information of one or more versions of the artifacts present in the primary repository and the secondary repository.

5. The computer implemented method of claim 1, wherein the categorized table includes

a first column to render the identifiers of the artifacts present in the primary repository, and

a second column to render the identifiers of the artifacts present in the secondary repository.

6. The computer implemented method of claim 5, wherein the user action is received on the first column of the categorized table.

7. The computer implemented method of claim 1, wherein the identifiers of the artifacts present in the secondary repository are rendered by:

creating one or more rows for the retrieved identifiers of the artifacts;

populating one or more fields of the rows using the associated metadata of the retrieved identifiers; and

ranking the identifiers based upon the relevancy parameters, wherein the relevancy parameters include a hit-score parameter.

8. The computer implemented method of claim 1, wherein the identifiers of the artifacts present in the primary repository are retrieved by:

determining a version number parameter for each identifier of the artifact present in the primary repository;

determining a version number parameter for each identifier of the artifact present in the secondary repository;

for each artifact of the primary repository, including a version number greater than a version number of a corresponding artifact of the secondary repository, retrieving the identifiers of the artifacts and assigning a rank higher than the rank of the corresponding artifact including a lower version number.

9. The computer implemented method of claim 1, wherein the relevancy parameters are selected from a group consisting:

a hit-score, a version number, a latest version number, a maximum possible quality rating, a weight for a version number, a weight for version label, a weight for proximity based upon a security principle, a weight for quality rating, a weight for hit-score, and one or more artifact containers containing the retrieved artifacts.

10. The computer implemented method of claim 1, wherein ranking the retrieved identifiers in the first column of the categorized table comprises sorting the retrieved identifiers in the first column based upon the fifth computed score associated with the relevancy parameters for each artifact associated with the identifier retrieved from the primary repository.

11. The computer implemented method of claim 1 further comprising:

based upon the relevancy parameters, computing a minimum allowable score for the identifiers in the first column of the categorized table, wherein the minimum allowable score determines the identifiers whose artifacts have to be downloaded from the primary repository;

computing an allowable score for each artifact in the first column of the categorized table;

determining one or more identifiers present in the first column of the categorized table with a computed score greater than the minimum allowable score and storing the determined identifiers in a job object;

determining one or more administrative rights for the artifacts corresponding to the determined identifiers;

executing a scheduled job run for the job object by signing in to the primary repository and determining the artifacts associated with the determined identifiers;

downloading the determined artifacts corresponding to the job object to create an archive file; and

uploading the archive file to the secondary repository and where the archive file is deployed, to synchronize the secondary repository with the primary repository.

12. A computer system to synchronize a primary repository and a secondary repository of data, comprising:

a processor configured to read and execute instructions stored in one or more memory elements; and

the one or more memory elements storing instructions to;

the processor to index content of one or more artifacts present in the primary repository and the secondary repository;

a user interface associated with the secondary repository to receive a search criteria;

an integrated service tool to

perform a combinatorial query on the indexed content of the primary repository and the secondary repository, and

retrieve an identifier of each artifact and associated metadata corresponding to the search criteria;

an integrated server in communication with the integrated service tool to rank the retrieved identifiers based upon one or more relevancy

parameters and

render the ranked identifiers as a categorized table on the

secondary repository; and

a secondary repository server to

determine the artifacts and the associated metadata present in the primary repository based upon a user action received on the ranked identifiers, and

download the determined artifacts and the associated metadata from the primary repository to the secondary repository.

13. An article of manufacture including a computer readable storage medium to tangibly store instructions, which when executed by a computer, cause the computer to:

indexing content of one or more artifacts present in the primary repository and one or more artifacts present in the secondary repository;

based upon a search criteria received at the secondary repository, invoking an integrated search service associated with the secondary repository to perform a combinatorial query on the indexed content of the primary repository and the indexed content the secondary repository, and retrieve one or more identifiers of the one or more artifacts and associated metadata corresponding to the search criteria;

based upon one or more relevancy parameters, ranking the retrieved identifiers and rendering the ranked identifiers as a categorized table on the secondary repository; and

based upon a user action received on the ranked identifiers, determining the artifacts and the associated metadata present in the primary repository and downloading the determined artifacts and the associated metadata from the primary repository to the secondary repository.

14. The article of manufacture of claim 13, wherein the relevancy parameters are selected from a group consisting:

a hit-score, a version number, a latest version number, a maximum possible quality rating, a weight for a version number, a weight for version label, a weight for proximity based upon a security principle, a weight for quality rating, a weight for hit-score, and one or more artifact containers containing the retrieved artifacts.

15. The article of manufacture of claim 14, wherein a first computed score associated with the relevancy parameters is calculated by

computing a product of a hit-score and a weight for the hit-score for each artifact associated with the identifier retrieved from the primary repository.

16. The article of manufacture of claim 14, wherein a second computed score associated with the relevancy parameters is calculated by

computing a ratio of the version number and the latest version number of each artifact associated with the identifier retrieved from the primary repository;

computing a product of the ratio and the weight for the version number; and

computing a sum of the product and the first computed score.

17. The article of manufacture of claim 14, wherein a third computed score associated with the relevancy parameters is calculated by

determining if each artifact associated with the identifier retrieved from the primary repository is labeled;

and

computing a sum of the weight for the labeled artifact and the second computed score.

18. The article of manufacture of claim 14, wherein a fourth computed score associated with the relevancy parameters is calculated by

computing a ratio of the quality rating and the maximum possible quality rating for each artifact associated with the identifier retrieved from the primary repository;

computing a product of the ratio and the weight for the quality rating for each artifact; and

computing a sum of the product and the third computed score.

19. The article of manufacture of claim 14, wherein a fifth computed score associated with the relevancy parameters is calculated by

computing a sum of the weight for proximity based upon one or more administrative rights for each artifact associated with the identifier retrieved from the primary repository and the fourth computed score.

20. The article of manufacture of claim 14, wherein the weight for proximity is calculated based upon a user'"'"'s access to each artifact associated with the identifier retrieved from the primary repository.

21. The article of manufacture of claim 20, wherein the weight for the proximity for a user with a direct access to the artifact is computed as a maximum weight for the proximity.

22. The article of manufacture of claim 20, wherein the weight for the proximity for a user with an indirect access to the artifact is computed as an intermediate weight for the proximity.

23. The article of manufacture of claim 20, wherein the weight for the proximity for a user with an access to the artifact existing in a hierarchy is computed as a product of the maximum weight of the proximity and a numeric value assigned to the access based upon a number of levels in the hierarchy.