IP Library Granted Patent US 7,685,184
Granted Patent B2
US 7,685,184 · App. 11/068,056 · Granted Mar 23, 2010

View maintenance on multiple tables located in different software components with the same primary keys

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 7,685,184
App. No.
11/068,056
Granted
Mar 23, 2010
Kind
B2
Abstract

A method performed by a processor allows an individual to update or maintain a database including a core and an extension. The core contains core tables including general data and the extension contains extension tables including specific data. The core tables and the extension tables have the same primary keys and the specific data are an extension of the general data. The method includes receiving an input from the individual for modifying the database, modifying the core using the received input, and automatically modifying the extension to reflect the modifying of the core.

Claims (48)

1. A method performed by a processor for an individual to maintain a database including a core and an extension, wherein the core contains core tables including general data and the extension contains extension tables including specific data, the core tables and the extension tables having the same primary keys and the specific data being an extension of the general data, the method comprising:

displaying a maintenance view of the extension table on a display prior to modifying the database;

receiving an input from the individual for modifying the database;

modifying the core or the extension using the received input;

automatically modifying the other of the core or the extension to reflect the modifying of the core or the extension by:

synchronizing data in the core with data in the extension by comparing data in the core tables with entries in the extension tables,

wherein when an entry in the core table does not correspond to any entry in the extension table, a new entry is automatically added into the extension table using the same primary keys as the entry in the core table and when the entry in the extension table does not find a corresponding entry in the core table the entry in the extension table is deleted; and

displaying a maintenance view of the extension table on a display after the modifying of the database.

2. The method of claim 1 , wherein the maintenance view is presented through a web interface that allows the input from the individual for updating the database.

3. The method of claim 1 , further comprising receiving an input for determining whether the maintenance of the database should be terminated.

4. The method of claim 3 , further comprising repeating the receiving of the input for updating the database, the updating of the core, and the automatic updating of the extension, when the input for determining indicates that the maintenance of the database should not be terminated.

5. The method of claim 1 , wherein the modifying of the core comprises the addition of a new entry in the core, and the modifying of the extension comprises adding a new entry in the extension corresponding to the new entry added in the core.

6. The method of claim 1 , wherein the modifying of the core comprises the deletion of an entry from the core, and the modifying of the extension comprises deleting a corresponding entry from the extension.

7. The method of claim 1 , wherein the modifying of the core comprises the delimitation of an entry in the core, and the modifying of the extension comprises delimiting a corresponding entry in the extension.

8. A method performed by a processor for an individual to maintain a database including a core and an extension, wherein the core contains core tables including general data and the extension contains extension tables including specific data, the core tables and the extension tables having the same primary keys and the specific data being an extension of the general data, the method comprising:

allowing the individual to maintain the core and the extension, including

displaying a maintenance view of the extension table on a display prior to modifying the database;

receiving an input from the individual for modifying the database,

modifying the core or the extension using the received input, and

automatically modifying the other of the core or the extension to reflect the modifying of the core or the extension by

synchronizing data between the core and the extension by comparing data in the core tables with entries in the extension tables, wherein when an entry in the core table does not correspond to any entry in the extension table, a new entry is automatically added into the extension table using the same primary keys as the entry in the core table and when the entry in the extension table does not find a corresponding entry in the core table the entry in the extension table is deleted, and maintaining the extension; and

displaying a maintenance view of the extension table on a display after the modifying of the database.

9. The method of claim 8 , wherein the modifying of the core comprises adding, deleting, or delimiting an entry in the core, and the modifying of the extension comprises adding, deleting, or delimiting a corresponding entry in the extension.

10. The method of claim 8 , wherein the synchronizing comprises deleting an entry in the extension if the entry in the extension does not correspond to any entry in the core, and, when an entry in the core does not correspond to any entry in the extension, adding an entry in the extension corresponding to the entry in the core.

11. A computer-readable storage medium containing a program for causing a processor to perform a method for an individual to maintain a database including a core and an extension, wherein the core contains core tables including general data and the extension contains extension tables including specific data, the core tables and the extension tables having the same primary keys and the specific data being an extension of the general data, the method comprising:

allowing the individual to maintain the core and the extension, including

displaying a maintenance view of the extension table on a display prior to modifying the database;

receiving an input from the individual for modifying the database,

modifying the core or the extension using the received input, and

automatically modifying the other of the core or the extension to reflect the modifying of the core or the extension by

synchronizing data between the core and the extension by comparing data in the core tables with entries in the extension tables, wherein when an entry in the core table does not correspond to any entry in the extension table, a new entry is automatically added into the extension table using the same primary keys as the entry in the core table and when the entry in the extension table does not find a corresponding entry in the core table the entry in the extension table is deleted, and maintaining the extension; and

displaying a maintenance view of the extension table on a display after the modifying of the database.

12. The storage medium of claim 11 , wherein the modifying of the core comprises adding, deleting, or delimiting an entry in the core, and the modifying of the extension comprises adding, deleting, or delimiting a corresponding entry in the extension.

13. The storage medium of claim 11 , wherein the synchronizing comprises deleting an entry in the extension if the entry in the extension does not correspond to any entry in the core, and, when an entry in the core does not correspond to any entry in the extension, adding an entry in the extension corresponding to the entry in the core.

14. The storage medium of claim 11 , wherein the medium is a hard disk, a floppy disk, or a compact disk.

15. A computer system, comprising:

a processor; and

means for accessing a computer-readable medium containing a program for causing the processor to perform a method for an individual to update or maintain a database including a core and an extension, wherein the core contains core tables including general data and the extension contains extension tables including specific data, the core tables and the extension tables having the same primary keys and the specific data being an extension of the general data, the method comprising:

allowing the individual to maintain the core and the extension, including

displaying a maintenance view of the extension table on a display prior to modifying the database;

receiving an input from the individual for modifying the database,

modifying the core or the extension using the received input, and

automatically modifying the other of the core or the extension to reflect the modifying of the core or the extension by;

synchronizing data between the core and the extension by comparing data in the core tables with entries in the extension tables, wherein when an entry in the core table does not correspond to any entry in the extension table, a new entry is automatically added into the extension table using the same primary keys as the entry in the core table and when the entry in the extension table does not find a corresponding entry in the core table the entry in the extension table is deleted, and maintaining the extension; and

displaying a maintenance view of the extension table on a display after the modifying of the database.

16. The system of claim 15 , wherein the modifying of the core comprises adding, deleting, or delimiting an entry in the core, and the modifying of the extension comprises adding, deleting, or delimiting a corresponding entry in the extension.

17. The system of claim 15 , wherein the synchronizing comprises deleting an entry in the extension if the entry in the extension does not correspond to any entry in the core, and, when an entry in the core does not correspond to any entry in the extension, adding an entry in the extension corresponding to the entry in the core.

18. The system of claim 15 , wherein the medium is a hard disk, a floppy disk, or a compact disk.

Assignments (3)
CHANGE OF NAME Recorded Aug 26, 2014
From: SAP AG
To: SAP SE
Reel/Frame 033625/0334 →
CHANGE OF NAME Recorded Dec 20, 2005
From: SAP AKTIENGESELLSCHAFT
To: SAP AG
Reel/Frame 017377/0343 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jul 5, 2005
From: CHOI, RICHARD F.; WANG, XIN; WANG, SHOUXIN
To: SAP AKTIENGESELLSCHAFT
Reel/Frame 016742/0875 →