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
File | Size |
---|---|
Northix/Classes/D_LastUpdate/last_update@payment@1.dat | 360.5 KB |
Northix/Classes/D_paymentDate/payment_date@payment@1.dat | 360.5 KB |
Northix/InputData/payment_date@payment@1.dat | 360.5 KB |
Northix/Classes/D_LastUpdate/last_update@rental@1.dat | 360.4 KB |
Northix/Classes/D_paymentDate/rental_date@rental@1.dat | 360.4 KB |
0 to 5 of 231
Reviews
There are no reviews for this dataset yet.
pip install ucimlrepo
from ucimlrepo import fetch_ucirepo # fetch dataset northix = fetch_ucirepo(id=237) # data (as pandas dataframes) X = northix.data.features y = northix.data.targets # metadata print(northix.metadata) # variable information print(northix.variables)
Bourennani, F. (2012). Northix [Dataset]. UCI Machine Learning Repository. https://doi.org/10.24432/C5M60J.
Creators
Farid Bourennani
DOI
License
This dataset is licensed under a Creative Commons Attribution 4.0 International (CC BY 4.0) license.
This allows for the sharing and adaptation of the datasets for any purpose, provided that the appropriate credit is given.