70 likes | 168 Views
TANGO – Table Analysis for Generating Ontologies. Sean Kelley Rensselaer Polytechnic Institute 2011 Electrical Engineering. Table Ontology. Concept diagrams will help us understand the function of tables and XY trees. Initial concept diagram for table. Table. 4:*. 1. Cell. 2:*. has.
E N D
TANGO – Table Analysis for Generating Ontologies Sean Kelley Rensselaer Polytechnic Institute 2011 Electrical Engineering
Table Ontology • Concept diagrams will help us understand the function of tables and XY trees
Initial concept diagram for table Table 4:* 1 Cell 2:* has Stub (1) Delta cell Data value 1 1:* has 1 Label Header Is defined by U+ Row header Column header 1:* 1:*
Initial XY Tree concept diagram XY Tree 6:* 7:* 1 1:* 2 Node Branch Connects to 1 has 1 Label Leaf Node Intermediate Node Cut Type (H or V) Root Node (1)
Using OpenOffice • There are several differences in the ways that Excel and OpenOffice Calc import tables from the web. • OpenOffice preserves formatting (boldface, justification, etc) while Excel does not • Excel imports the title of the table, while OpenOffice does not • Excel imports indentations, while OpenOffice does not
Table comparison Excel OpenOffice
For macros, OpenOffice uses a language called OpenOffice Basic, which is very similar to Microsoft VBA • This will make it simple to convert Ramana’s programs to run in OpenOffice. • OpenOffice also supports Python.