{"id":"https://openalex.org/W2315516717","doi":"https://doi.org/10.1109/icdse.2014.6974620","title":"Semantic integration of heterogeneous relational schemas using multiple L1 linear regression and SVD","display_name":"Semantic integration of heterogeneous relational schemas using multiple L1 linear regression and SVD","publication_year":2014,"publication_date":"2014-08-01","ids":{"openalex":"https://openalex.org/W2315516717","doi":"https://doi.org/10.1109/icdse.2014.6974620","mag":"2315516717"},"language":"en","primary_location":{"id":"doi:10.1109/icdse.2014.6974620","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icdse.2014.6974620","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2014 International Conference on Data Science & Engineering (ICDSE)","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5042124464","display_name":"Sandhya Harikumar","orcid":"https://orcid.org/0000-0003-0236-5532"},"institutions":[{"id":"https://openalex.org/I81556334","display_name":"Amrita Vishwa Vidyapeetham","ror":"https://ror.org/03am10p12","country_code":"IN","type":"education","lineage":["https://openalex.org/I81556334"]}],"countries":["IN"],"is_corresponding":true,"raw_author_name":"Sandhya Harikumar","raw_affiliation_strings":["Department of Computer Science and Engineering, Amrita Vishwa Vidyapeetham, Amritapuri, Kollam, Kerala, India"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Engineering, Amrita Vishwa Vidyapeetham, Amritapuri, Kollam, Kerala, India","institution_ids":["https://openalex.org/I81556334"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5089907829","display_name":"R. Reethima","orcid":null},"institutions":[{"id":"https://openalex.org/I81556334","display_name":"Amrita Vishwa Vidyapeetham","ror":"https://ror.org/03am10p12","country_code":"IN","type":"education","lineage":["https://openalex.org/I81556334"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"R. Reethima","raw_affiliation_strings":["Department of Computer Science and Engineering, Amrita Vishwa Vidyapeetham, Amritapuri, Kollam, Kerala, India"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Engineering, Amrita Vishwa Vidyapeetham, Amritapuri, Kollam, Kerala, India","institution_ids":["https://openalex.org/I81556334"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5109148528","display_name":"M. R. Kaimal","orcid":null},"institutions":[{"id":"https://openalex.org/I81556334","display_name":"Amrita Vishwa Vidyapeetham","ror":"https://ror.org/03am10p12","country_code":"IN","type":"education","lineage":["https://openalex.org/I81556334"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"M. R. Kaimal","raw_affiliation_strings":["Department of Computer Science and Engineering, Amrita Vishwa Vidyapeetham, Amritapuri, Kollam, Kerala, India"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Engineering, Amrita Vishwa Vidyapeetham, Amritapuri, Kollam, Kerala, India","institution_ids":["https://openalex.org/I81556334"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5042124464"],"corresponding_institution_ids":["https://openalex.org/I81556334"],"apc_list":null,"apc_paid":null,"fwci":0.818,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.82286177,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"23","issue":null,"first_page":"105","last_page":"111"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9975000023841858,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9975000023841858,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9921000003814697,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9908999800682068,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7119756937026978},{"id":"https://openalex.org/keywords/schema-migration","display_name":"Schema migration","score":0.6911634206771851},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.6842392683029175},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.644915759563446},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.6338481307029724},{"id":"https://openalex.org/keywords/data-integration","display_name":"Data integration","score":0.6142884492874146},{"id":"https://openalex.org/keywords/information-schema","display_name":"Information schema","score":0.6042064428329468},{"id":"https://openalex.org/keywords/semi-structured-model","display_name":"Semi-structured model","score":0.5366982817649841},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.4765753746032715},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4650498628616333},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.4435542821884155},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.41860082745552063},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3462781012058258},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.33608460426330566},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.1593897044658661},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.09822219610214233},{"id":"https://openalex.org/keywords/gender-schema-theory","display_name":"Gender schema theory","score":0.07400619983673096}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7119756937026978},{"id":"https://openalex.org/C153440673","wikidata":"https://www.wikidata.org/wiki/Q7431119","display_name":"Schema migration","level":5,"score":0.6911634206771851},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6842392683029175},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.644915759563446},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.6338481307029724},{"id":"https://openalex.org/C72634772","wikidata":"https://www.wikidata.org/wiki/Q386824","display_name":"Data integration","level":2,"score":0.6142884492874146},{"id":"https://openalex.org/C150012506","wikidata":"https://www.wikidata.org/wiki/Q6031185","display_name":"Information schema","level":5,"score":0.6042064428329468},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.5366982817649841},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.4765753746032715},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4650498628616333},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.4435542821884155},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.41860082745552063},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3462781012058258},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.33608460426330566},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.1593897044658661},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.09822219610214233},{"id":"https://openalex.org/C165611974","wikidata":"https://www.wikidata.org/wiki/Q5531015","display_name":"Gender schema theory","level":2,"score":0.07400619983673096},{"id":"https://openalex.org/C138496976","wikidata":"https://www.wikidata.org/wiki/Q175002","display_name":"Developmental psychology","level":1,"score":0.0},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icdse.2014.6974620","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icdse.2014.6974620","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2014 International Conference on Data Science & Engineering (ICDSE)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5400000214576721,"id":"https://metadata.un.org/sdg/10","display_name":"Reduced inequalities"}],"awards":[],"funders":[{"id":"https://openalex.org/F4320311327","display_name":"Amrita Vishwa Vidyapeetham University","ror":"https://ror.org/03am10p12"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":20,"referenced_works":["https://openalex.org/W83066537","https://openalex.org/W1599003247","https://openalex.org/W1818506960","https://openalex.org/W1993918834","https://openalex.org/W2008896880","https://openalex.org/W2047003964","https://openalex.org/W2068722138","https://openalex.org/W2081972960","https://openalex.org/W2095478387","https://openalex.org/W2125822162","https://openalex.org/W2130541987","https://openalex.org/W2914271914","https://openalex.org/W3120740533","https://openalex.org/W3165241807","https://openalex.org/W6603413639","https://openalex.org/W6635757637","https://openalex.org/W6678767931","https://openalex.org/W6679345457","https://openalex.org/W6796017329","https://openalex.org/W7075683076"],"related_works":["https://openalex.org/W166845585","https://openalex.org/W945629821","https://openalex.org/W2092058806","https://openalex.org/W1513459549","https://openalex.org/W2103472145","https://openalex.org/W2153512431","https://openalex.org/W1992271858","https://openalex.org/W4238907651","https://openalex.org/W2105315220","https://openalex.org/W2582962420"],"abstract_inverted_index":{"The":[0,33,164],"challenge":[1],"of":[2,5,10,14,19,37,50,108,111,115,119,151,160,179,205],"semantic":[3],"integration":[4,55,110],"heterogeneous":[6,90],"databases":[7],"is":[8,40,72,79,95,105,141,148,154,171,198],"one":[9],"the":[11,22,26,30,38,41,66,70,76,99,109,127,144,175,187,202],"critical":[12],"areas":[13],"interest":[15],"due":[16],"to":[17,24,64,88,125,209],"scalability":[18],"data":[20,28,71,145,182],"and":[21,54,75,137,157,184],"need":[23],"share":[25],"existing":[27],"as":[29],"technology":[31],"advances.":[32],"schema":[34,51,77,92,100,104,118,197,208],"level":[35,169],"heterogeneity":[36],"relations":[39],"major":[42],"issue":[43],"for":[44],"such":[45],"integration.":[46],"Though":[47],"various":[48],"approaches":[49],"analysis,":[52],"transformation":[53],"have":[56],"been":[57],"explored,":[58],"sometimes":[59],"those":[60,190],"become":[61],"too":[62],"general":[63],"solve":[65],"problem":[67],"especially":[68],"when":[69],"very":[73],"high-dimensional":[74],"information":[78],"unavailable":[80],"or":[81],"inadequate.":[82],"In":[83,123],"this":[84],"paper,":[85],"a":[86,120,149,210],"method":[87,159],"integrate":[89],"relational":[91,117,181],"at":[93],"instance-level":[94],"proposed,":[96],"rather":[97],"than":[98],"level.":[101],"A":[102],"global":[103,211],"designed":[106],"consisting":[107],"most":[112,165,176],"relevant":[113,203],"attributes":[114,178,191,204],"different":[116],"particular":[121],"domain.":[122],"order":[124],"find":[126],"significant":[128,177],"attributes,":[129],"multiple":[130],"linear":[131,161],"regressions":[132],"based":[133],"on":[134,143],"LI":[135],"norm":[136],"Singular":[138],"Value":[139],"Decomposition(SVD)":[140],"applied":[142],"iteratively.":[146],"This":[147],"variant":[150],"L1-PCA,":[152],"which":[153],"efficient,":[155],"effective":[156],"meaningful":[158],"subspace":[162],"estimation.":[163],"prominent":[166],"instance":[167],"-":[168],"similarity":[170,188],"found":[172],"by":[173],"finding":[174,186],"each":[180,206],"source":[183],"then":[185],"among":[189],"using":[192],"L1-norm.":[193],"Thus":[194],"an":[195],"integrated":[196],"created":[199],"that":[200],"maps":[201],"local":[207],"schema.":[212]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2015,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}