Invention Grant
- Patent Title: Conversion of relational databases into triplestores
- Patent Title (中): 将关系数据库转换为三元组
-
Application No.: US12507746Application Date: 2009-07-22
-
Publication No.: US08037108B1Publication Date: 2011-10-11
- Inventor: Walter Chang
- Applicant: Walter Chang
- Applicant Address: US CA San Jose
- Assignee: Adobe Systems Incorporated
- Current Assignee: Adobe Systems Incorporated
- Current Assignee Address: US CA San Jose
- Agency: Fish & Richardson P.C.
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for converting a relational database into a triplestore. In one aspect, a method includes retrieving meta schema information for a relational database, including checking a data dictionary associated therewith, and saving the information (including column, primary key constraint and foreign key constraint definitions) in a canonical format; processing the saved information to identify triples to be created in a triplestore; and generating triples in the triplestore in accordance with results of the processing, the generating including: creating first triples (corresponding to data specified within relational database tables) using the column definitions, creating second triples (corresponding to data links between the relational database tables) using the primary key and foreign key constraint definitions, and creating third triples using a primary key constraint definition, a foreign key constraint definition, and an associative mapping table corresponding to the relational database.
Information query