Northix

Donated on 8/14/2012

Northix is designed to be a schema matching benchmark problem for data integration of two entity relationship databases.

Dataset Characteristics

Multivariate, Univariate, Text

Subject Area

Computer Science

Associated Tasks

Classification

Feature Type

Integer, Real

# Instances

115

# Features

200

Dataset Information

Additional 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 don’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 “/-,”. [1] Microsoft. Northwind. [Online] 2005. [Cited: 06 28, 2009.] http://www.microsoft.com/Downloads/details.aspx?FamilyID=06616212-0356-46a0-8da2-eebc53a68034&displaylang=en. [2] MySQL. Sakila. [Online] 2005. [Cited: 06 28, 2009.] http://dev.mysql.com/doc/sakila/en/sakila.html.

Has Missing Values?

No

Variable 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 don’t have another similar attribute.

Dataset Files

FileSize
Northix/Classes/D_LastUpdate/last_update@payment@1.dat360.5 KB
Northix/Classes/D_paymentDate/payment_date@payment@1.dat360.5 KB
Northix/InputData/payment_date@payment@1.dat360.5 KB
Northix/Classes/D_LastUpdate/last_update@rental@1.dat360.4 KB
Northix/Classes/D_paymentDate/rental_date@rental@1.dat360.4 KB

0 to 5 of 231

Reviews

There are no reviews for this dataset yet.

Login to Write a Review
Download (1.2 MB)
0 citations
729 views

Creators

Farid Bourennani

License

By using the UCI Machine Learning Repository, you acknowledge and accept the cookies and privacy practices used by the UCI Machine Learning Repository.

Read Policy