How to choose the database platform of knowledge management system

Knowledge management System (KMS) provides knowledge management services for enterprises through it technology, realizes the acquisition, sedimentation, sharing, learning, application and innovation of explicit and tacit knowledge, internal knowledge and external knowledge, and realizes the value of knowledge creation. Knowledge management system is mainly composed of two kinds of data structure, one is to describe the structure of the knowledge attribute and ontology, and the other is the unstructured data in the construction of documents, mails and multimedia. How to choose the appropriate database platform to realize the effective processing of two kinds of data will become one of the key factors of the KMS system success or failure.

First, the mainstream technology analysis of data processing

relational database (RDB) technology in the field of data processing is in the dominant position, it is based on the relational mathematics, the simple relational model, takes the SQL as the processing tool, obtains the widespread application, its technical characteristic decides to be good at the structured data processing application, in recent years each manufacturer develops the function on the basis of the relational database, began to have content management, multimedia and other data processing capabilities. Typical products include Oracle, DB2, SQL Server, MySQL, and so on. For massive structured data processing, it is also like Essbase, Cognos and other multidimensional database systems.

In the document and other unstructured data processing, the document database as the leading, with a large number of features, not limited by the size of the byte, any graphics, sound information, regardless of their sizes, length, height, are only one of the elements of the database, IBM Lotus Domino is a product representative with an industry-recognized advantage in storing such unstructured data.

The following is a simple comparison between a relational and a document database:

relational database (ORACLE/DB2, etc.)	Document database (Domino etc)
Based on transaction processing model	Based on document type
Using structured data	Use semi-structured data
Provides real-time access to data	Use replication to increase or decrease the document (by modification)
Locating data using a special query	Using views to locate data
Using SQL to access	Use Full-text Search to access

For special applications, there are some special database technologies, such as spatial database technology.

Application and analysis of the main database of KMS system

Today's KMS systems are dominated by IBM Domino, SUN JAVA, Microsoft. NET three systems, domino in e-mail, collaboration, unstructured document processing, security mechanisms, JAVA with open standards are leading the technology direction,. NET to Simple, Flexibility, ease of use, and low cost are also popular.

In the data processing of KMS there are two camps, one is Oracle/db2/sql server and other relational database, the other is Domino and other document-type database.

Domino has efficient document processing capabilities, a security control mechanism with up to 7 layers (managers, designers, editors, authors, readers, repositories, and no accessors) to control the permissions of a server, a database, a view, a form, an operation, a document, or a field. Can track and record all users of the database and document operations, such as the outstanding advantages of the KMS system is very suitable for the management of document-oriented knowledge. But in the face of a large number of forms such as structured data processing requirements, computing, statistical ability of Domino is difficult to deal with.