Visual database management system and method

• US 20050192973A1
• Filed: 02/12/2004
• Published: 09/01/2005
• Est. Priority Date: 02/12/2004
• Status: Abandoned Application

• Current Assignee: Smith Micro Software Incorporated
• Original Assignee: Smith Micro Software Incorporated
• Inventors: Dabrowski, George J., Sperling, David P., Ghulamali, Murtaza A.
• Application Number:
  US10/777,867
• Publication Number:
  US 20050192973A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/273 Asynchronous replication or reconciliation

Abstract

A system for reconciling data in a plurality of databases includes a user interface adapted to provide a graphical representation of at least a subset of the records from each of the plurality of databases and to allow for interactive manipulation of the database records through the graphical representation. The plurality of databases are stored on a portable device, or a personal computer. In some embodiments, at least two of the databases have different record structures. The graphical representation includes a visually distinctive graphical scheme for each of the plurality of databases, as well as a visually distinctive graphical scheme for each unique combination of the plurality of databases. Each record found in a single database is displayed using the single database'"'"'s corresponding graphical scheme and each record found in more than one database is displayed using the graphical scheme corresponding to the combination of databases.

Claims

1. A method of managing a plurality of databases, each database being stored on a separate device, the method comprising:

defining a plurality of visually distinctive graphical schemes, each graphical scheme corresponding to one or more of the devices;

retrieving from each device a record from the corresponding database; and

graphically displaying each of the retrieved records in one of the plurality of graphical schemes;

wherein the number of graphical schemes used in displaying the retrieved records is greater than the number of devices.

2. The method of claim 1 wherein the number of devices is two and wherein three distinctive graphical schemes are defined, a first graphical scheme corresponding to records retrieved only from a first device, a second graphical scheme corresponding to records retrieved only from a second device, and a third graphical scheme corresponding to records retrieved from both the first and second device.

3. The method of claim 1 further comprising:

providing a user interface for visually manipulating the graphically displayed records; and

performing a database operation on at least one of the plurality of databases in response to said visual manipulations.

4. The method of claim 3 wherein the user interface is adapted for interactively synchronizing the plurality of databases.

5. The method of claim 1 wherein each record includes a plurality of fields,

wherein a record retrieved from the first device, corresponds to a record retrieved from the second device when a subset of fields from the first record matches a subset of fields from the second record;

and

wherein corresponding records are displayed as a single graphical representation.

6. The method of claim 1 wherein each graphical scheme includes a visually distinctive color.

7. The method of claim 1 further comprising:

generating a third database having a record for each corresponding pair of records; and

displaying the contents of the third database using the third graphical scheme.

8. A system for reconciling data in a plurality of databases, comprising:

a user interface adapted to provide a unique graphical representation of a record from each of the plurality of databases and to allow for interactive manipulation of the database records through the graphical representation.

9. The system of claim 8 wherein the graphical representation includes a visually distinctive graphical scheme for each of the plurality of databases, and a visually distinctive graphical scheme for each unique combination of the plurality of databases;

wherein a record found in a single database is displayed using the single database'"'"'s corresponding graphical scheme; and

wherein a matching pair of records found in more than one database is displayed as a single record using the graphical scheme corresponding to the combination of databases.

10. The system of claim 8 further comprising a communications link to each of the plurality of databases and wherein the user interface is adapted to retrieve a record from each of the plurality of databases through its corresponding communications link.

11. The system of claim 8 wherein the interactive manipulations include copying a record from a first database to a second database.

12. The system of claim 8 wherein the interactive manipulations further include deleting a record from at least one database.

13. The system of claim 8 further comprising a temporary database table identifying a record found in more than one of the plurality of databases.

14. The system of claim 8 wherein at least one of the plurality of databases is stored on a portable device.

15. The system of claim 8 wherein at least two of the databases have different record structures.

16. The system of claim 8 wherein at least one of the plurality of databases is stored on a personal computer.

17. The system of claim 10 wherein at least one communications link includes an API.

18. The system of claim 10 wherein at least one communications link includes a wireless link.

19. The system of claim 10 wherein at least one communications link includes the Internet.

20. The system of claim 10 wherein at least one communications link includes a serial connection and device specific APIs.

21. A method of reconciling a first database stored on a computer and a second database stored on portable device, the method comprising:

displaying, a record from each database, wherein if a record from the first database corresponds to a record from the second database, the two records are displayed as a single record.

22. The method of claim 21 further comprising modifying at least one of the first and second databases in response to user manipulation of the displayed records.

23. The method of claim 21 wherein each database is a calendar database and wherein each displayed record falls within a displayed date range.

24. The method of claim 22 wherein the step of modifying includes copying the records selected by a user from the first database to the second database.

25. The method of claim 22 wherein the step of modifying includes deleting one or more records selected by a user from at least one of the first and second databases.

26. The method of claim 22 wherein the step of modifying includes synchronizing the first and second databases.

27. A computer-readable medium storing executable instructions for use in managing a plurality of calendar databases, the program comprising:

an interface to each of the plurality of databases adapted to obtain a subset of records from each of the plurality of databases, the subset of records spanning a date range; and

a user interface adapted to display a graphical representation of the obtained records, allow for interactive manipulation of the displayed graphical representations, and perform at least one database operation on at least one of the plurality of databases in response to the interactive manipulations.

28. The computer-readable medium of claim 27 wherein the user interface is adapted for synchronizing the plurality of calendar databases.

29. The computer-readable medium of claim 28 wherein the databases are reconciled without using an intermediate file.

30. A method comprising:

defining a plurality of graphical schemes;

selecting a record from a first database;

comparing the selected record to a record from a second database; and

assigning one the plurality of graphical schemes to the selected record based on the comparison.

31. The method of claim 30 further comprising graphically displaying each of the selected records in accordance with the assigned graphical scheme.

32. The method of claim 31 wherein the number of graphical schemes used in displaying the retrieved records is greater than the number of devices.

33. The method of claim 30 wherein the number of databases is two and wherein three distinctive graphical schemes are defined, a first graphical scheme corresponding to records retrieved only from the first database, a second graphical scheme corresponding to records retrieved only from a second database, and a third graphical scheme corresponding to records retrieved from both the first and second database.