Dart Grid Browserbased mapping tool of SQL to

Dart. Grid Browser-based mapping tool of SQL to RDF Point Template Zhejiang University & Open. Link Software

Dart. Grid Contents 3 1 2 3 4 Why need semantic mapping? Identifies and records the SQL 2 RDF mapping issues Identify a set of mapping cases Browser-based mapping tool of SQL to RDF is developed.

Dart. Grid Why need semantic mapping tool? 1. Semantic mapping from Relational databases to RDF is the key problem in RDF-based databases integration. 2 Defining semantic mapping manually is a burdensome and errorprone work. 3 So far, there is none full-automatic mapping tool of SQL to RDF, most of which is defined manually. .

Dart. Grid 2. Mapping cases W 3 C Banff life scienece demo also has public available SQL versions. THALIA Testbed provides a collection of 40 relational database tables representing course information. More: http: //esw. w 3. org/topic/SQL 2 OWL

Dart. Grid 2. 1 Representation and notation 1 2 3 Graphical representation: each case is graphically represented for documentation purpose. Abstract level: a mapping is abstractly described as a rule that has rule head and rule body. Syntax level: for implementation purpose, the mappings are finally stored as virtuoso metaschema language MDL

Dart. Grid 2. 1 Representation and notation(2) R(? a, ? b, ? c, …)-: (uri<? a>, rdf: type, thalia: Course), (uri<? a>, foaf: name, ? b), (uri<? a>, thalia: has. Instructor, uri<? 2>), (uri<? 2>, rdf: type, thalia: Instructor) 1 Variables: a, b are original column names of the relational table. 2 3 uri<? . . . >: It is a Uri function: it function used to generate universal resource identifiers. may be implemented as either generating a blank node ID (internal id) or global URI.

Dart. Grid 2. 2 3 kinds of mapping cases 1 2 3 The simplest situation of mapping cases is a single table exactly maps to one single class in the ontology. More complex situation is mapping from one table to four ontological classes Most complex situation is self-join that is three or above tables are connected by foreign key, or one table has foreign key relationship with itself.

Dart. Grid 2. 3 THALIA Testbed 1 2 3 The tested relational databases are taken from the THALIA Testbed benchmark. It provides a collection of 40 relational database tables representing university course catalogs. The data in the testbed provide a rich source of syntactic and semantic heterogeneities.

Dart. Grid 2. 3. 1 Description as a rule § Case 1 Arizona State University § The asu table stores CS course information of the Arizona State University. § This mapping case is that a single table exactly maps to one single ontology class.

Dart. Grid 2. 3. 1 mapping mechanism Fig. 1 mapping case 1 of THALIA

Dart. Grid 2. 3. 1 Brown University case 1 The normal mapping systems often separately consider the schema-level mapping and instance-level mapping. 2 Thialia: has. Instructor should be considered as a property (schema) in RDF, but is stored in a relational tuple(instance). 3 This use case illustrates the mapping from one table to four ontological classes.

Dart. Grid 2. 3. 2 Description as a rule § The brown table stores CS course information of the Brown University. § This use case illustrates the mapping from one table to four ontological classes: Course, Instructor, Event, Point.

Dart. Grid 2. 3. 1 mapping mechanism Fig. 2 mapping mechanism of Brown case

Dart. Grid 3. Browser-based mapping tool 1 2 3 This mapping tool is developed This mapping tool provides a to help domain experts to define the semantic mapping lot of easy-to-use functionalities and has some special technical features. based on OAT (Open. Link Ajax Toolkit)

Dart. Grid 3. 1 Functional components Display databases and ontology schema structure Define instance-level mappings such as table-to-class or column-to-property Define schema-level mappings (for complex joins between tables) Mapping Tool

Dart. Grid 3. 1. 1 Instance-level mapping § Instance-level mapping is always simple and easy to understand. § Generally speaking, instance-level mapping has two types: § From tables to ontology classes § From one column to one ontology property § 3 situations of mapping tables to classes § From one table to one ontology class § From one table to many ontology classes § From many tables to one ontology class

Dart. Grid 3. 1. 2 Schema-level mapping § It is more complicated than instance-level mapping, which is based on foreign key relation and relativity defined in ontology schema.

Dart. Grid 3. 2 Technical Features Drag-and-drop mapping Web browser-based tool Browser-based Mapping tool Visualization mapping Data source annotation semi-auto mapping for complex joins

Dart. Grid 3. 3 mapping tool pictures Fig. 2 Db. View/Onto. View Fig. 3 drag-and-drop mapping

Dart. Grid 4. Future work Automate MDL Automate mapping process as far as possible by adding some heuristic rules to automate the semantic mapping task. Adopt Virtuoso's SPARQL based Meta schema Language as the syntax mapping rule.

Dart. Grid Click to edit subtitle style