Techniques for extracting data from content databases

• US 8,635,188 B2
• Filed: 06/12/2008
• Issued: 01/21/2014
• Est. Priority Date: 06/12/2008
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Sawaya, Samer Fouad, Simek, Patrick J.
• Primary Examiner(s): Chen, Susan
• Application Number:
  US12/137,556
• Publication Number:
  US 20090313280A1
• Time in Patent Office: 2,049 Days
• Field of Search: 707/100, 707/103, 707/204, 709/225, 709/316, 379/88.25
• US Class Current: 707/649
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: G06F 16/958 Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking

Abstract

Various technologies and techniques are disclosed for extracting data from databases of content management applications. Input is received from a user to connect to a database of a content management application. A connection is established to the database. When the database is not part of a current live instance of the content management application, an emulation is performed so that the database is treated like it is actually attached to the current live instance of the content management application. The user is able to browse the database. Unattached databases of a content management application can be managed using one or more commands, such as using an object model or command line. Orphaned databases can be detected and deleted from the content management application.

Claims

1. A computer-implemented method for enabling browsing of data from a content management application comprising:

receiving a selection to connect to a database of a content management application;

performing database validation to ensure that the database is a valid version or database schema of the content management application;

establishing a connection to the database;

when the database is part of a current live instance of the content management application, determining whether one or more orphaned content management sites are contained in the database, the one or more orphaned content management sites comprising content management sites that have inaccessible uniform resource locator (URL) namespaces;

when the database is not part of the current live instance of the content management application, performing, by a processing unit, an emulation so that the database is treated like the database is actually attached to the current live instance of the content management application; and

enabling the database to be browsed.

2. The computer-implemented method of claim 1, wherein the database is contained in a database backup file.

3. The computer-implemented method of claim 1, wherein the database is contained in a database snapshot file.

4. The computer-implemented method of claim 1, wherein the database is contained in an active database instance on a separate computer that is not currently part of a live instance of the content management application.

5. The computer-implemented method of claim 1, wherein the establishing the connection comprises performing a security check to ensure authority to access the database.

6. The computer-implemented method of claim 1, wherein the enabling the database to be browsed includes allowing searching for data that is contained in the database to identify desired content.

7. The computer-implemented method of claim 6, wherein the enabling the database to be browsed further includes allowing extracting of the desired content.

8. The computer-implemented method of claim 6, wherein the enabling the database to be browsed further includes allowing backup of the desired content to a backup file.

9. The computer-implemented method of claim 1, further comprising the steps of:

deleting one or more portions of the orphaned content management sites.

10. The computer-implemented method of claim 9, wherein the deleting is performed after receiving user confirmation to proceed with the deleting.