Semantic Data Integration and Querying: A Survey and Challenges Article Swipe

PDF

Maroua Masmoudi , Sana Ben Abdallah Ben Lamine , Mohamed Hedi Karray , Bernard Archimède , Hajer Baazaoui Zghal ·

YOU? · · 2024 · Open Access · · DOI: https://doi.org/10.1145/3653317

Digital revolution produces massive, heterogeneous and isolated data. These latter remain underutilized, unsuitable for integrated querying and knowledge discovering. Hence the importance of this survey on data integration which identifies challenging issues and trends. First, an overview of the different generations and basics of data integration is given. Then, semantic data integration is focused, since it semantically links data allowing wider insights and decision-making. More than thirty works are reviewed. The goal is to help analysts to identify relevant criteria to compare then choose among semantic data integration approaches, focusing on the category (materialized, virtual or hybrid) and querying techniques.

Related Topics

Concepts

Computer science Data integration Semantic integration Data science Semantic heterogeneity Ontology-based data integration Information retrieval Semantic technology Information integration Linked data Semantic Web Semantic computing Data mining

Metadata

Type: review
Language: en
Landing Page: https://doi.org/10.1145/3653317
PDF: https://dl.acm.org/doi/pdf/10.1145/3653317
OA Status: hybrid
Cited By: 8
References: 74
Related Works: 10
OpenAlex ID: https://openalex.org/W4393119041

All OpenAlex metadata

Raw OpenAlex JSON

OpenAlex ID: https://openalex.org/W4393119041

Canonical identifier for this work in OpenAlex
DOI: https://doi.org/10.1145/3653317

Digital Object Identifier
Title: Semantic Data Integration and Querying: A Survey and Challenges

Work title
Type: review

OpenAlex work type
Language: en

Primary language
Publication year: 2024

Year of publication
Publication date: 2024-03-23

Full publication date if available
Authors: Maroua Masmoudi, Sana Ben Abdallah Ben Lamine, Mohamed Hedi Karray, Bernard Archimède, Hajer Baazaoui Zghal

List of authors in order
Landing page: https://doi.org/10.1145/3653317

Publisher landing page
PDF URL: https://dl.acm.org/doi/pdf/10.1145/3653317

Direct link to full text PDF
Open access: Yes

Whether a free full text is available
OA status: hybrid

Open access status per OpenAlex
OA URL: https://dl.acm.org/doi/pdf/10.1145/3653317

Direct OA link when available
Concepts: Computer science, Data integration, Semantic integration, Data science, Semantic heterogeneity, Ontology-based data integration, Information retrieval, Semantic technology, Information integration, Linked data, Semantic Web, Semantic computing, Data mining

Top concepts (fields/topics) attached by OpenAlex
Cited by: 8

Total citation count in OpenAlex
Citations by year (recent): 2025: 7, 2024: 1

Per-year citation counts (last 5 years)
References (count): 74

Number of works referenced by this work
Related works (count): 10

Other works algorithmically related by OpenAlex

Full payload

id	https://openalex.org/W4393119041
doi	https://doi.org/10.1145/3653317
ids.doi	https://doi.org/10.1145/3653317
ids.openalex	https://openalex.org/W4393119041
fwci	5.11022839
type	review
title	Semantic Data Integration and Querying: A Survey and Challenges
biblio.issue	8
biblio.volume	56
biblio.last_page	35
biblio.first_page	1
topics[0].id	https://openalex.org/T10215
topics[0].field.id	https://openalex.org/fields/17
topics[0].field.display_name	Computer Science
topics[0].score	0.9998000264167786
topics[0].domain.id	https://openalex.org/domains/3
topics[0].domain.display_name	Physical Sciences
topics[0].subfield.id	https://openalex.org/subfields/1702
topics[0].subfield.display_name	Artificial Intelligence
topics[0].display_name	Semantic Web and Ontologies
topics[1].id	https://openalex.org/T10317
topics[1].field.id	https://openalex.org/fields/17
topics[1].field.display_name	Computer Science
topics[1].score	0.9965000152587891
topics[1].domain.id	https://openalex.org/domains/3
topics[1].domain.display_name	Physical Sciences
topics[1].subfield.id	https://openalex.org/subfields/1705
topics[1].subfield.display_name	Computer Networks and Communications
topics[1].display_name	Advanced Database Systems and Queries
topics[2].id	https://openalex.org/T11719
topics[2].field.id	https://openalex.org/fields/18
topics[2].field.display_name	Decision Sciences
topics[2].score	0.9944999814033508
topics[2].domain.id	https://openalex.org/domains/2
topics[2].domain.display_name	Social Sciences
topics[2].subfield.id	https://openalex.org/subfields/1803
topics[2].subfield.display_name	Management Science and Operations Research
topics[2].display_name	Data Quality and Management
is_xpac	False
apc_list
apc_paid
concepts[0].id	https://openalex.org/C41008148
concepts[0].level	0
concepts[0].score	0.877744734287262
concepts[0].wikidata	https://www.wikidata.org/wiki/Q21198
concepts[0].display_name	Computer science
concepts[1].id	https://openalex.org/C72634772
concepts[1].level	2
concepts[1].score	0.7382321357727051
concepts[1].wikidata	https://www.wikidata.org/wiki/Q386824
concepts[1].display_name	Data integration
concepts[2].id	https://openalex.org/C110903229
concepts[2].level	4
concepts[2].score	0.6439682245254517
concepts[2].wikidata	https://www.wikidata.org/wiki/Q7449064
concepts[2].display_name	Semantic integration
concepts[3].id	https://openalex.org/C2522767166
concepts[3].level	1
concepts[3].score	0.575568675994873
concepts[3].wikidata	https://www.wikidata.org/wiki/Q2374463
concepts[3].display_name	Data science
concepts[4].id	https://openalex.org/C2778180026
concepts[4].level	4
concepts[4].score	0.49483054876327515
concepts[4].wikidata	https://www.wikidata.org/wiki/Q18378163
concepts[4].display_name	Semantic heterogeneity
concepts[5].id	https://openalex.org/C22550185
concepts[5].level	3
concepts[5].score	0.4601915180683136
concepts[5].wikidata	https://www.wikidata.org/wiki/Q7095047
concepts[5].display_name	Ontology-based data integration
concepts[6].id	https://openalex.org/C23123220
concepts[6].level	1
concepts[6].score	0.45329421758651733
concepts[6].wikidata	https://www.wikidata.org/wiki/Q816826
concepts[6].display_name	Information retrieval
concepts[7].id	https://openalex.org/C6881194
concepts[7].level	4
concepts[7].score	0.439275860786438
concepts[7].wikidata	https://www.wikidata.org/wiki/Q7449091
concepts[7].display_name	Semantic technology
concepts[8].id	https://openalex.org/C33326189
concepts[8].level	2
concepts[8].score	0.4289833605289459
concepts[8].wikidata	https://www.wikidata.org/wiki/Q17092450
concepts[8].display_name	Information integration
concepts[9].id	https://openalex.org/C69075417
concepts[9].level	3
concepts[9].score	0.41700413823127747
concepts[9].wikidata	https://www.wikidata.org/wiki/Q515701
concepts[9].display_name	Linked data
concepts[10].id	https://openalex.org/C2129575
concepts[10].level	2
concepts[10].score	0.3513234853744507
concepts[10].wikidata	https://www.wikidata.org/wiki/Q54837
concepts[10].display_name	Semantic Web
concepts[11].id	https://openalex.org/C511149849
concepts[11].level	3
concepts[11].score	0.27931737899780273
concepts[11].wikidata	https://www.wikidata.org/wiki/Q7449051
concepts[11].display_name	Semantic computing
concepts[12].id	https://openalex.org/C124101348
concepts[12].level	1
concepts[12].score	0.26231908798217773
concepts[12].wikidata	https://www.wikidata.org/wiki/Q172491
concepts[12].display_name	Data mining
keywords[0].id	https://openalex.org/keywords/computer-science
keywords[0].score	0.877744734287262
keywords[0].display_name	Computer science
keywords[1].id	https://openalex.org/keywords/data-integration
keywords[1].score	0.7382321357727051
keywords[1].display_name	Data integration
keywords[2].id	https://openalex.org/keywords/semantic-integration
keywords[2].score	0.6439682245254517
keywords[2].display_name	Semantic integration
keywords[3].id	https://openalex.org/keywords/data-science
keywords[3].score	0.575568675994873
keywords[3].display_name	Data science
keywords[4].id	https://openalex.org/keywords/semantic-heterogeneity
keywords[4].score	0.49483054876327515
keywords[4].display_name	Semantic heterogeneity
keywords[5].id	https://openalex.org/keywords/ontology-based-data-integration
keywords[5].score	0.4601915180683136
keywords[5].display_name	Ontology-based data integration
keywords[6].id	https://openalex.org/keywords/information-retrieval
keywords[6].score	0.45329421758651733
keywords[6].display_name	Information retrieval
keywords[7].id	https://openalex.org/keywords/semantic-technology
keywords[7].score	0.439275860786438
keywords[7].display_name	Semantic technology
keywords[8].id	https://openalex.org/keywords/information-integration
keywords[8].score	0.4289833605289459
keywords[8].display_name	Information integration
keywords[9].id	https://openalex.org/keywords/linked-data
keywords[9].score	0.41700413823127747
keywords[9].display_name	Linked data
keywords[10].id	https://openalex.org/keywords/semantic-web
keywords[10].score	0.3513234853744507
keywords[10].display_name	Semantic Web
keywords[11].id	https://openalex.org/keywords/semantic-computing
keywords[11].score	0.27931737899780273
keywords[11].display_name	Semantic computing
keywords[12].id	https://openalex.org/keywords/data-mining
keywords[12].score	0.26231908798217773
keywords[12].display_name	Data mining
language	en
locations[0].id	doi:10.1145/3653317
locations[0].is_oa	True
locations[0].source.id	https://openalex.org/S157921468
locations[0].source.issn	0360-0300, 1557-7341
locations[0].source.type	journal
locations[0].source.is_oa	False
locations[0].source.issn_l	0360-0300
locations[0].source.is_core	True
locations[0].source.is_in_doaj	False
locations[0].source.display_name	ACM Computing Surveys
locations[0].source.host_organization	https://openalex.org/P4310319798
locations[0].source.host_organization_name	Association for Computing Machinery
locations[0].source.host_organization_lineage	https://openalex.org/P4310319798
locations[0].source.host_organization_lineage_names	Association for Computing Machinery
locations[0].license	other-oa
locations[0].pdf_url	https://dl.acm.org/doi/pdf/10.1145/3653317
locations[0].version	publishedVersion
locations[0].raw_type	journal-article
locations[0].license_id	https://openalex.org/licenses/other-oa
locations[0].is_accepted	True
locations[0].is_published	True
locations[0].raw_source_name	ACM Computing Surveys
locations[0].landing_page_url	https://doi.org/10.1145/3653317
indexed_in	crossref
authorships[0].author.id	https://openalex.org/A5008191965
authorships[0].author.orcid	https://orcid.org/0000-0002-3612-5417
authorships[0].author.display_name	Maroua Masmoudi
authorships[0].countries	FR
authorships[0].affiliations[0].institution_ids	https://openalex.org/I4210142324
authorships[0].affiliations[0].raw_affiliation_string	CY Cergy Paris University, Pau, France
authorships[0].institutions[0].id	https://openalex.org/I4210142324
authorships[0].institutions[0].ror	https://ror.org/043htjv09
authorships[0].institutions[0].type	education
authorships[0].institutions[0].lineage	https://openalex.org/I4210142324
authorships[0].institutions[0].country_code	FR
authorships[0].institutions[0].display_name	CY Cergy Paris Université
authorships[0].author_position	first
authorships[0].raw_author_name	Maroua Masmoudi
authorships[0].is_corresponding	False
authorships[0].raw_affiliation_strings	CY Cergy Paris University, Pau, France
authorships[1].author.id	https://openalex.org/A5082630479
authorships[1].author.orcid	https://orcid.org/0000-0002-6018-2518
authorships[1].author.display_name	Sana Ben Abdallah Ben Lamine
authorships[1].countries	TN
authorships[1].affiliations[0].institution_ids	https://openalex.org/I83259278
authorships[1].affiliations[0].raw_affiliation_string	University of Manouba, Manouba, Tunisie
authorships[1].institutions[0].id	https://openalex.org/I83259278
authorships[1].institutions[0].ror	https://ror.org/0503ejf32
authorships[1].institutions[0].type	education
authorships[1].institutions[0].lineage	https://openalex.org/I83259278
authorships[1].institutions[0].country_code	TN
authorships[1].institutions[0].display_name	Manouba University
authorships[1].author_position	middle
authorships[1].raw_author_name	Sana Ben Abdallah Ben Lamine
authorships[1].is_corresponding	False
authorships[1].raw_affiliation_strings	University of Manouba, Manouba, Tunisie
authorships[2].author.id	https://openalex.org/A5072065891
authorships[2].author.orcid	https://orcid.org/0000-0002-9652-5164
authorships[2].author.display_name	Mohamed Hedi Karray
authorships[2].affiliations[0].raw_affiliation_string	University of Toulouse, Tarbes, France
authorships[2].author_position	middle
authorships[2].raw_author_name	Mohamed Hedi Karray
authorships[2].is_corresponding	False
authorships[2].raw_affiliation_strings	University of Toulouse, Tarbes, France
authorships[3].author.id	https://openalex.org/A5002940570
authorships[3].author.orcid	https://orcid.org/0000-0001-8491-4915
authorships[3].author.display_name	Bernard Archimède
authorships[3].affiliations[0].raw_affiliation_string	University of Toulouse, Tarbes, France
authorships[3].author_position	middle
authorships[3].raw_author_name	Bernard Archimede
authorships[3].is_corresponding	False
authorships[3].raw_affiliation_strings	University of Toulouse, Tarbes, France
authorships[4].author.id	https://openalex.org/A5052284903
authorships[4].author.orcid	https://orcid.org/0000-0002-2151-7397
authorships[4].author.display_name	Hajer Baazaoui Zghal
authorships[4].countries	FR
authorships[4].affiliations[0].institution_ids	https://openalex.org/I4210142324
authorships[4].affiliations[0].raw_affiliation_string	CY Cergy Paris University, Pontoise, France
authorships[4].institutions[0].id	https://openalex.org/I4210142324
authorships[4].institutions[0].ror	https://ror.org/043htjv09
authorships[4].institutions[0].type	education
authorships[4].institutions[0].lineage	https://openalex.org/I4210142324
authorships[4].institutions[0].country_code	FR
authorships[4].institutions[0].display_name	CY Cergy Paris Université
authorships[4].author_position	last
authorships[4].raw_author_name	Hajer Baazaoui Zghal
authorships[4].is_corresponding	False
authorships[4].raw_affiliation_strings	CY Cergy Paris University, Pontoise, France
has_content.pdf	True
has_content.grobid_xml	True
is_paratext	False
open_access.is_oa	True
open_access.oa_url	https://dl.acm.org/doi/pdf/10.1145/3653317
open_access.oa_status	hybrid
open_access.any_repository_has_fulltext	False
created_date	2025-10-10T00:00:00
display_name	Semantic Data Integration and Querying: A Survey and Challenges
has_fulltext	True
is_retracted	False
updated_date	2025-11-06T03:46:38.306776
primary_topic.id	https://openalex.org/T10215
primary_topic.field.id	https://openalex.org/fields/17
primary_topic.field.display_name	Computer Science
primary_topic.score	0.9998000264167786
primary_topic.domain.id	https://openalex.org/domains/3
primary_topic.domain.display_name	Physical Sciences
primary_topic.subfield.id	https://openalex.org/subfields/1702
primary_topic.subfield.display_name	Artificial Intelligence
primary_topic.display_name	Semantic Web and Ontologies
related_works	https://openalex.org/W1997451603, https://openalex.org/W2165366845, https://openalex.org/W2095535085, https://openalex.org/W2343630457, https://openalex.org/W2779831736, https://openalex.org/W2368731870, https://openalex.org/W2373133917, https://openalex.org/W2036469985, https://openalex.org/W2315308740, https://openalex.org/W2378243565
cited_by_count	8
counts_by_year[0].year	2025
counts_by_year[0].cited_by_count	7
counts_by_year[1].year	2024
counts_by_year[1].cited_by_count	1
locations_count	1
best_oa_location.id	doi:10.1145/3653317
best_oa_location.is_oa	True
best_oa_location.source.id	https://openalex.org/S157921468
best_oa_location.source.issn	0360-0300, 1557-7341
best_oa_location.source.type	journal
best_oa_location.source.is_oa	False
best_oa_location.source.issn_l	0360-0300
best_oa_location.source.is_core	True
best_oa_location.source.is_in_doaj	False
best_oa_location.source.display_name	ACM Computing Surveys
best_oa_location.source.host_organization	https://openalex.org/P4310319798
best_oa_location.source.host_organization_name	Association for Computing Machinery
best_oa_location.source.host_organization_lineage	https://openalex.org/P4310319798
best_oa_location.source.host_organization_lineage_names	Association for Computing Machinery
best_oa_location.license	other-oa
best_oa_location.pdf_url	https://dl.acm.org/doi/pdf/10.1145/3653317
best_oa_location.version	publishedVersion
best_oa_location.raw_type	journal-article
best_oa_location.license_id	https://openalex.org/licenses/other-oa
best_oa_location.is_accepted	True
best_oa_location.is_published	True
best_oa_location.raw_source_name	ACM Computing Surveys
best_oa_location.landing_page_url	https://doi.org/10.1145/3653317
primary_location.id	doi:10.1145/3653317
primary_location.is_oa	True
primary_location.source.id	https://openalex.org/S157921468
primary_location.source.issn	0360-0300, 1557-7341
primary_location.source.type	journal
primary_location.source.is_oa	False
primary_location.source.issn_l	0360-0300
primary_location.source.is_core	True
primary_location.source.is_in_doaj	False
primary_location.source.display_name	ACM Computing Surveys
primary_location.source.host_organization	https://openalex.org/P4310319798
primary_location.source.host_organization_name	Association for Computing Machinery
primary_location.source.host_organization_lineage	https://openalex.org/P4310319798
primary_location.source.host_organization_lineage_names	Association for Computing Machinery
primary_location.license	other-oa
primary_location.pdf_url	https://dl.acm.org/doi/pdf/10.1145/3653317
primary_location.version	publishedVersion
primary_location.raw_type	journal-article
primary_location.license_id	https://openalex.org/licenses/other-oa
primary_location.is_accepted	True
primary_location.is_published	True
primary_location.raw_source_name	ACM Computing Surveys
primary_location.landing_page_url	https://doi.org/10.1145/3653317
publication_date	2024-03-23
publication_year	2024
referenced_works	https://openalex.org/W2544143889, https://openalex.org/W2766286125, https://openalex.org/W2963657797, https://openalex.org/W1033418451, https://openalex.org/W2003041138, https://openalex.org/W6747887090, https://openalex.org/W4380590538, https://openalex.org/W3026969847, https://openalex.org/W2901091672, https://openalex.org/W2299775049, https://openalex.org/W2137862151, https://openalex.org/W4251503246, https://openalex.org/W3205824011, https://openalex.org/W2006519067, https://openalex.org/W2590491911, https://openalex.org/W1994642127, https://openalex.org/W2998205755, https://openalex.org/W2005649826, https://openalex.org/W2927427229, https://openalex.org/W2093480367, https://openalex.org/W1527456126, https://openalex.org/W2763907401, https://openalex.org/W2740663788, https://openalex.org/W1971323001, https://openalex.org/W2088667649, https://openalex.org/W2164637360, https://openalex.org/W6737635997, https://openalex.org/W2600074498, https://openalex.org/W2105904924, https://openalex.org/W7071146050, https://openalex.org/W3016734568, https://openalex.org/W1997694088, https://openalex.org/W1565421110, https://openalex.org/W3184242493, https://openalex.org/W4309678981, https://openalex.org/W2592818077, https://openalex.org/W2275216626, https://openalex.org/W2888841046, https://openalex.org/W1516511413, https://openalex.org/W1992673035, https://openalex.org/W2787617693, https://openalex.org/W2989239875, https://openalex.org/W3092348013, https://openalex.org/W1624976387, https://openalex.org/W2027083550, https://openalex.org/W2972855163, https://openalex.org/W3126868161, https://openalex.org/W3134782560, https://openalex.org/W2293246268, https://openalex.org/W1920706659, https://openalex.org/W2967825558, https://openalex.org/W2888428995, https://openalex.org/W1555486317, https://openalex.org/W2095590518, https://openalex.org/W2749590813, https://openalex.org/W2510862072, https://openalex.org/W2793801019, https://openalex.org/W2274744161, https://openalex.org/W153622350, https://openalex.org/W1729697543, https://openalex.org/W1484056211, https://openalex.org/W2037214271, https://openalex.org/W2620247453, https://openalex.org/W4381485785, https://openalex.org/W2740179215, https://openalex.org/W4303188261, https://openalex.org/W2141824507, https://openalex.org/W2945688618, https://openalex.org/W2811295734, https://openalex.org/W1502629466, https://openalex.org/W4256361765, https://openalex.org/W2620183058, https://openalex.org/W4297737180, https://openalex.org/W2134531511
referenced_works_count	74
abstract_inverted_index.an	35
abstract_inverted_index.is	46, 52, 72
abstract_inverted_index.it	55
abstract_inverted_index.of	22, 37, 43
abstract_inverted_index.on	25, 90
abstract_inverted_index.or	95
abstract_inverted_index.to	73, 76, 80
abstract_inverted_index.The	70
abstract_inverted_index.and	5, 16, 32, 41, 62, 97
abstract_inverted_index.are	68
abstract_inverted_index.for	13
abstract_inverted_index.the	20, 38, 91
abstract_inverted_index.More	64
abstract_inverted_index.data	26, 44, 50, 58, 86
abstract_inverted_index.goal	71
abstract_inverted_index.help	74
abstract_inverted_index.than	65
abstract_inverted_index.then	82
abstract_inverted_index.this	23
abstract_inverted_index.Hence	19
abstract_inverted_index.Then,	48
abstract_inverted_index.These	8
abstract_inverted_index.among	84
abstract_inverted_index.data.	7
abstract_inverted_index.links	57
abstract_inverted_index.since	54
abstract_inverted_index.which	28
abstract_inverted_index.wider	60
abstract_inverted_index.works	67
abstract_inverted_index.First,	34
abstract_inverted_index.basics	42
abstract_inverted_index.choose	83
abstract_inverted_index.given.	47
abstract_inverted_index.issues	31
abstract_inverted_index.latter	9
abstract_inverted_index.remain	10
abstract_inverted_index.survey	24
abstract_inverted_index.thirty	66
abstract_inverted_index.Digital	0
abstract_inverted_index.compare	81
abstract_inverted_index.hybrid)	96
abstract_inverted_index.trends.	33
abstract_inverted_index.virtual	94
abstract_inverted_index.allowing	59
abstract_inverted_index.analysts	75
abstract_inverted_index.category	92
abstract_inverted_index.criteria	79
abstract_inverted_index.focused,	53
abstract_inverted_index.focusing	89
abstract_inverted_index.identify	77
abstract_inverted_index.insights	61
abstract_inverted_index.isolated	6
abstract_inverted_index.massive,	3
abstract_inverted_index.overview	36
abstract_inverted_index.produces	2
abstract_inverted_index.querying	15, 98
abstract_inverted_index.relevant	78
abstract_inverted_index.semantic	49, 85
abstract_inverted_index.different	39
abstract_inverted_index.knowledge	17
abstract_inverted_index.reviewed.	69
abstract_inverted_index.identifies	29
abstract_inverted_index.importance	21
abstract_inverted_index.integrated	14
abstract_inverted_index.revolution	1
abstract_inverted_index.unsuitable	12
abstract_inverted_index.approaches,	88
abstract_inverted_index.challenging	30
abstract_inverted_index.generations	40
abstract_inverted_index.integration	27, 45, 51, 87
abstract_inverted_index.techniques.	99
abstract_inverted_index.discovering.	18
abstract_inverted_index.semantically	56
abstract_inverted_index.heterogeneous	4
abstract_inverted_index.(materialized,	93
abstract_inverted_index.underutilized,	11
abstract_inverted_index.decision-making.	63
cited_by_percentile_year.max	99
cited_by_percentile_year.min	90
countries_distinct_count	2
institutions_distinct_count	5
sustainable_development_goals[0].id	https://metadata.un.org/sdg/16
sustainable_development_goals[0].score	0.800000011920929
sustainable_development_goals[0].display_name	Peace, Justice and strong institutions
citation_normalized_percentile.value	0.93678723
citation_normalized_percentile.is_in_top_1_percent	False
citation_normalized_percentile.is_in_top_10_percent	True