Store RDF in relational database

The classification of this paper should be under the XML, but the 9CBS is short, only in the website production technology and the .NET, XML classification. RDF has no relationship with M $, so it is placed under the website production technology - XML.

Hax translated from http://www-db.stanford.edu/~melnik/rdf/db.html copyright open, welcome to copyleft 2003, hax ​​. ======== ================ Terminology: RDF Model RDF Model RDF Statement RDF Statement Literal Text Constant Namespace Name Space Table Table Field Field ============= =========== This page outlines several ways to store RDF in relational database, * this is a request for comments *, please submit your idea to (WWW-RDF-Interest @ w3.org)! Motiviation ------------------ we need to permanently store and operate (large number) RDF data. An optional approach is to use relational database technology. The main advantage of this method is that it provides an upgraded general solution. Criteria -------------- This incomplete list points out the guidelines that need to be considered by the database mode design (no order): * Scalability: We can store and query More than 10 billion (1B ) Triples? * Query: Which type of query is supported? Can they be easy to express and process? * Efficiency: How much is the query consumption? How to deliver the results of the query? * Optimization: How can we handle Refication? * Organization: How to establish associations on the storage data? Can we make an easy-to-resolution of RDF Models and still determine where Triples comes from? The following proposals meet the above guidelines from different aspects. The maintainer of this page is particularly interesting to scalable problems.

Please reflect the guidelines for your needs to me! Publications ---------------------- The following paper discusses the relationship table with vertical mode storage and query sparse, this is the spirit of some proposed programs Very similar: R. Agrawal, A. Somani, And Y. XU: Storage and Querying of E-Commerce Data, Proc. VLDB 2001, Roma, Italy, Available As http://www.vldb.org/conf/2001/ P149.pdf Stores RDF database mode ------------------- (Recent Submission in front) Clear model (Explicit Models) --------- ---------------------- Contributor: Brian Macbride Date: 2000/5/11 Abstract: This indicator Clear performance model and use view database mode (Oracle) and author's description: SQL = "CREATE TABLE RDFRESOURES" "(" "ID Integer Not Null Primary Key," "NS Integer Not NULL," "Roname VARCHAR (255) "") "; resource table holds all resources, ID is the internal identifier field, NS is a pointer, pointing to the entry of the NameSpace table to give the resource namespace. Roname should be called 'localname', which is a partial named section of QNAME. SQL = "CREATE TABLE RDFNAMESPACE" " " ID Integer Not Null Primary Key, " " NSName Varchar (255) ")" "") "; Name Space Table. SQL = "CREATE TABLE RDFLITERAL" "(" "ID Integer Not Null Primary Key," "Val Var Var VARCHAR (4000)") "; LITERALS [HAX Note: It can be translated as a text constant] table. 4000 characters limitations are sufficient for current goals.

[HAX Note: The upper limit of Oralce's variable string is 4000 bytes] SQL = "CREATE TABLE RDFSTATEMENT" "(" "ID Integer Not Null Primary Key," "Subject Integer Not Null," "Predicate Integer NOT NULL, " " ObjResource Integer Not Null, " " Objliteral Integer Not NULL, " " RES Char (1) Not NULL " ") "; statement [HAX Note: can be translated as a statement or statement] table. Originally a single object field, there can be an object or text constant ID. Use a complex Join expression to list, but not as expected. It may be that I have insufficient SQL experience. And this work and feel more "correct". RES is a flag to illustrate the object is the resource or the text constant. SQL = "CREATE TABLE RDFMODEL" "( " Modelid Integer Not Null, " " Statement Integer Not Null, " " Asserted Char (1) Not Null, " " Reified Char (1) Not null, " "Primary Key (Modelid, Statement)") ")" "") ")"; database can handle multiple models [HAX Note: can be translated into model]. This table holds a list of statements for each model. Initially, the table is combined by the statement table, but it cannot be worked when performing a collection operation. Asserted flag Description This statement is used to make a model for a model. The REIFIED flag indicates that the model is used to make the model. The latter is a hook (HOOK) that is left to future implementation. The specificization is not implemented, so this method is not tested. Each model is a resource and has a record in the resource table. The ModelID field is the identifier of the resource. This way, you can write a statement about a model. There is a class of a model here, which can list the modes that need to be loaded when confirming the model validity.