Patent ID: 7797276

Claim:
An integrated relational database data editing system providing a visual environment, graphic user interfaces and tools in a client computer to remotely access a server computer that contains a relational database and to manage and edit said database data contents through either intranet or Internet, and said system includes the following mechanisms and characters: (i) said client computer retrieves the database data from the remote server computer database, modifies, updates, input, output the data and then sends the data back to the original database; (ii) said client computer directly edits and modifies the database data without writing detail computer language codes in an efficient and easy-to-use manner; (iii) said client computer directly edits and modifies the large text data type and large binary data type by using a plurality of commercial text and multimedia data editors installed on the client computer; (iv) said database data editing system uses TCP/IP (Transfer Control Protocol/Internet Protocol) based connection-oriented network protocols to communicate between the client and server computers; and (v) said database data editing system implements user authentication and access control mechanisms which assigns different user groups with different privileges, wherein the database data editing system contains the well-defined graphic user interfaces and tools that display a database table or a subset data of a table and have the following characters: (i) said database data on each table cell is defaulted as read only; (ii) said database small text data on each table cell is directly edited when single-clicked by the mouse; (iii) said table cell contains a small icon as a place-holder for the large text data type or large binary data type; (iv) said commercial data editor is popped up from the local client computer when double-clicked the small icon of a table cell by the mouse and the database data is downloaded into the data editor from the remote server database and the edited data is then sent back to the original database when data editing is completed; and (v) said data editor is either a text editor or a multimedia editor depending on the database data type inside the table cell; Wherein a client/server version of the integrated database data editing system implemented by using Java technologies and deployed to the intranet; and Wherein a web version of the database data editing system implemented by using web and Java technologies and deployed to Internet and other network systems, and further has more advantages to implement the security features by using the PKI (public Key Infrastructure), SSL (Secure Socket Layer) and firewall.