Portable cross platform database accessing method and system

• US 20090013173A1
• Filed: 08/14/2008
• Published: 01/08/2009
• Est. Priority Date: 10/16/2002
• Status: Active Grant

• Current Assignee: Mozapps Limited
• Original Assignee: Mozapps Limited
• Inventors: Savage, Shaun
• Granted Patent: US 8,504,919 B2
• Time in Patent Office: Days
• US Class Current: 713/150
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

A user manages a database or other application through a remote graphical user interface on a server device through a client device. A cross platform database translation module resides on the client device. The client device may also store cross platform authentication, configuration, and report generating modules for validating a user id and presenting database results in a desirable format. The modules on the client device request applications from a server device, may request validation from an authorization server, may configure embedded devices, and may query a database. The database may reside on a server, on the client device, or on another device.

Claims

1. A computer-readable medium device that stores an executable program for accessing a database through a graphical user interface, comprising:

a first component object model module for validating a user; and

a second component object model module for handling an application from and loading an application from an external device and querying and processing results from querying a database;

wherein the first and second component object model modules reside on a client device.

2. The computer-readable medium of claim 1, wherein the external device is an applications server.

3. The computer-readable medium of claim 1, wherein the database is external to the client device.

4. The computer-readable medium of claim 3, wherein the component object module is binary and is cross platform.

5. The computer-readable medium of claim 4, wherein the first component object model module communicates with an authentication server.

6. The computer-readable medium of claim 5, wherein the client device constructs a page from widgets supplied by the applications server.

7. The computer-readable medium of claim 6, further comprising a third component object model module for accessing a native database.

8. The computer-readable medium of claim 6, the second component object model module including one or more sub modules for accessing native databases.

9. The computer-readable medium of claim 6, further comprising a third component object model module for handling a security protocol.

10. The computer-readable medium of claim 6, the first component object model module including sub modules, each of the sub modules handling a unique security protocol.

11. The computer-readable medium of claim 6, further comprising a fourth component object model module for viewing configuration and status information of an embedded device or remote device.

12. A method for remote graphical user interface processing of data, comprising the steps of:

receiving widget information by a client device from an external device;

receiving code to assemble a graphical user interface (GUI) by the client device from the external device;

constructing a GUI on the client device from widgets described by the widget information in which the code to assemble a GUI defines the actions between the widgets and a component object model module resident on the client device;

requesting an application from the external device by the client device through the constructed GUI; and

loading and displaying the application on the client device.

13. The method of claim 12, further comprising the step of processing data using the component object model module.

14. The method of claim 13, wherein the component object model module is a cross platform component object model module.

15. The method of claim 14, wherein the external device is an applications server.

16. The method of claim 15, wherein the step of processing data includes the steps of querying a database, receiving database results, and processing the database results.

17. The method of claim 16, wherein the step of querying a database is accomplished through a cross platform structured query language.

18. The method of claim 16, wherein the external device is a configurations server.

19. The method of claim 16, wherein the database is a relational database that is secured through an encrypted index.

20. The method of claim 16, wherein the database is a relational database and each entry of the database has at least one encrypted index.

21. The method of claim 20, wherein the at least one encrypted index is stored in a table.

22. The method of claim 12, wherein the code received to assemble a GUI is extensible mark up language (XML) code.

23. A method for configuring embedded devices on a network, comprising the steps of:

requesting a configurations application by a client device;

displaying the configurations application on the client device based on widget information;

requesting status and/or configuration information from an embedded device through the configurations application;

displaying the status and/or configuration information from the embedding device on the client device; and

updating the configuration information on the embedded device through the client device.

24. The method of claim 23, further comprising the step of displaying the updated configuration of the embedded device.

25. The method of claim 24, wherein requesting, displaying, and updating of the configuration information for the embedded device is performed through a component object model module on the client device.

26. A method for securing a relational database, comprising the steps of:

accessing a record from a relational database;

generating an unencrypted index for a first field of the record;

storing the unencrypted index in a table;

generating an encrypted index through an encryption algorithm for a second field of the record;

storing the encrypted index in the table; and

using a master key and one of the group consisting of the encrypted index and the unencrypted index to obtain the other of the group consisting of the encrypted index and the unencrypted index.

27. The method of claim 26, wherein the secured relational database is accessed by a remote GUI databasing method.

28. The method of claim 27, wherein the remote GUI databasing method uses a widget based GUI for databasing from a client device.

29. The method of claim 28, wherein databasing functions are performed through one or more cross platform component object model modules resident on the client device.

30. A method for providing a character based user interface to a character based, legacy device, comprising the steps of:

entering a keystroke on a client device;

transmitting the keystroke to a display server; and

equating the keystroke with a page update event or a new page event.

31. The method of claim 30, further comprising, for a page update event, updating the page on the display server and transmitting the page to the client device.

32. The method of claim 31, further comprising, for a new page event, forwarding the new page event information from the display server to a web server.

33. The method of claim 32, further comprising, for a new page event, generating an HTML page on the web server and transmitting the HTML page to the display server.

34. The method of claim 33, further comprising, for a new page event, translating the HTML page to a character based page and sending the character based page to the client device for display.