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.