Ontology based System for Converting Semi Structured Data into Relational Data

Abstract

Spreadsheets are contained critical information on various topics and are most broadly utilized in numerous fields. There are a huge amount of spreadsheets clients around the world as it considered the standard documentation format when dealing with data in a tabular format as a result of their convenience, support for diagrams, graphs and gives their users an enormous level of opportunity in encoding their data as it is simple to utilize. A spreadsheet is designed to work similarly to a database as it has a cell-like structure with a cell being a member of a horizontal row and vertical column. While compared to a database, spreadsheets lack many features that make them less appealing for use in data storage and processing. Spreadsheets suffer from low quality because of duplication or data redundancy may be found, where multiple copies of the same data exist in the same spreadsheet document. In addition, spreadsheets do not have the capacity to provide multiuser access like a database and it also has limited storage capabilities. Spreadsheet tables with semi-structured form are a type of nearly relational data that shares the important qualities of relational data but does not present itself in a relational format. It often conveys highly valuable information and is widely used in many different areas. If we can convert such data into the relational form, many existing tools can be leveraged for a variety of interesting applications, such as data analysis with relational query systems and data integration applications.