Farid Bourennani, University of ontario Institute of Technology, farid.bourennani '@' uoit.ca

Data Set Information:

Northix is designed to be a schema matching benchmark problem for data integration of two entity relationship databases. Northix is the resulting schema matching of two demonstration databases namely Northwind and Sakila. Some unnecessary database entities (columns) such as multimedia were deleted. It was desired to have at least around 200 tuples per database entity; therefore, tuples were randomly injected, respecting the existing pattern, if the number of tuples was low. The schema matching was done manually. The ideal entities matching are grouped into classes. In total, there are 115 input database entities stored respectively as '.dat' from the first database and as '.txt' if from the second database. The file naming pattern is attributeName@ColumnName@Database. After schema matching, the files are grouped into 34 classes (folders). 33 classes are ideal matchings whereas the class 'UNCLASSED' groups all the attributes that are unique and dona€?t have another similar attribute. The attributes are of different data types such as texts, integers, real numbers, dates, and alphanumeric data types. In total, there are 21805 tokens. A token is separated by spaces and other non alphanumeric characters such as a€?/-,a€?.

[1] Microsoft. Northwind. [Online] 2005. [Cited: 06 28, 2009.] [Web link].
[2] MySQL. Sakila. [Online] 2005. [Cited: 06 28, 2009.] [Web link].

Attribute Information:

In total, there are 115 input database entities stored respectively as '.dat' from the first database and as '.txt' if from the second database. The file naming pattern is attributeName@ColumnName@Database. After schema matching, the files are grouped into 34 classes (folders). 33 classes are ideal matchings whereas the class 'UNCLASSED' groups all the attributes that are unique and dona€?t have another similar attribute.

Relevant Papers:

Provide references to papers that have cited this data set in the past (if any).

Citation Request:

If you have no special citation requests, please leave this field blank.