Patent attributes
An integrated database data editing system for editing and managing the relational database data contents remotely through intranet or Internet in an efficient and easy-to-use manner. The editing system is used to input, output, modify and update the database data and is extremely useful for editing the large database objects such as large text files and audio, image, animation and video binary data files from a remote database. The editing system contains a visual database data manager in the client computer, which includes a list of databases and database tables from the remote server computer, and a database designer, an entity relationship designer, a table designer, a database schema, a data filter and an SQL console. The data table cells displayed on the client computer are default as read only. It is directly modified and edited when single-clicked by the mouse. A small icon is used as a place holder in the table cell for large text or binary data type. When double-clicked by the mouse, a commercial text or multimedia editor is popped up and the large text or binary data is retrieved from the remote database into the data editor for editing. The client/server version of the system is deployed and run on intranet. The web version is deployed and run on Internet and also on intranet. The web version has more advantage to implement the security features by using the Public Key Infrastructure (PKI) and the Secure Socket Layer (SSL). The mechanisms for user authentication and access control to the remote database are well implemented.
