{"id":"https://openalex.org/W2135779119","doi":"https://doi.org/10.14778/1454159.1454169","title":"Relational support for flexible schema scenarios","display_name":"Relational support for flexible schema scenarios","publication_year":2008,"publication_date":"2008-08-01","ids":{"openalex":"https://openalex.org/W2135779119","doi":"https://doi.org/10.14778/1454159.1454169","mag":"2135779119"},"language":"en","primary_location":{"id":"doi:10.14778/1454159.1454169","is_oa":false,"landing_page_url":"https://doi.org/10.14778/1454159.1454169","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-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/A5109192271","display_name":"Srini Acharya","orcid":null},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Srini Acharya","raw_affiliation_strings":["Microsoft SQL Server, One Microsoft Way, Redmond, WA","Microsoft SQL Server, One Microsoft Way, Redmond, WA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft SQL Server, One Microsoft Way, Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"Microsoft SQL Server, One Microsoft Way, Redmond, WA#TAB#","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5045128722","display_name":"Peter Carlin","orcid":null},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Peter Carlin","raw_affiliation_strings":["Microsoft SQL Server, One Microsoft Way, Redmond, WA","Microsoft SQL Server, One Microsoft Way, Redmond, WA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft SQL Server, One Microsoft Way, Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"Microsoft SQL Server, One Microsoft Way, Redmond, WA#TAB#","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5016107143","display_name":"C\u00e9sar Galindo-Legaria","orcid":"https://orcid.org/0009-0006-5344-9495"},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Cesar Galindo-Legaria","raw_affiliation_strings":["Microsoft SQL Server, One Microsoft Way, Redmond, WA","Microsoft SQL Server, One Microsoft Way, Redmond, WA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft SQL Server, One Microsoft Way, Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"Microsoft SQL Server, One Microsoft Way, Redmond, WA#TAB#","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5051505928","display_name":"Krzysztof Kozielczyk","orcid":null},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Krzysztof Kozielczyk","raw_affiliation_strings":["Microsoft SQL Server, One Microsoft Way, Redmond, WA","Microsoft SQL Server, One Microsoft Way, Redmond, WA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft SQL Server, One Microsoft Way, Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"Microsoft SQL Server, One Microsoft Way, Redmond, WA#TAB#","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5062985495","display_name":"Pawe\u0142 Terlecki","orcid":null},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Pawel Terlecki","raw_affiliation_strings":["Microsoft SQL Server, One Microsoft Way, Redmond, WA","Microsoft SQL Server, One Microsoft Way, Redmond, WA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft SQL Server, One Microsoft Way, Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"Microsoft SQL Server, One Microsoft Way, Redmond, WA#TAB#","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5082617310","display_name":"Peter Zabback","orcid":null},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Peter Zabback","raw_affiliation_strings":["Microsoft SQL Server, One Microsoft Way, Redmond, WA","Microsoft SQL Server, One Microsoft Way, Redmond, WA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft SQL Server, One Microsoft Way, Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"Microsoft SQL Server, One Microsoft Way, Redmond, WA#TAB#","institution_ids":["https://openalex.org/I1290206253"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.1441,"has_fulltext":false,"cited_by_count":11,"citation_normalized_percentile":{"value":0.82449372,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":"1","issue":"2","first_page":"1289","last_page":"1300"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9997000098228455,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9997000098228455,"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"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9976999759674072,"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/T11106","display_name":"Data Management and Algorithms","score":0.9965000152587891,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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.8156742453575134},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6408534049987793},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.630752682685852},{"id":"https://openalex.org/keywords/metadata","display_name":"Metadata","score":0.5974083542823792},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5640004873275757},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.5563421249389648},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5530326962471008},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.5068677067756653},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.46245455741882324},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.43093132972717285},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.39950597286224365},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.39654776453971863},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3646593391895294},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.25866562128067017},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.2464609146118164},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.23530668020248413}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8156742453575134},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6408534049987793},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.630752682685852},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.5974083542823792},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5640004873275757},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.5563421249389648},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5530326962471008},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.5068677067756653},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.46245455741882324},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.43093132972717285},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.39950597286224365},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.39654776453971863},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3646593391895294},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.25866562128067017},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2464609146118164},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.23530668020248413}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.14778/1454159.1454169","is_oa":false,"landing_page_url":"https://doi.org/10.14778/1454159.1454169","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.140.8226","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.140.8226","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.vldb.org/pvldb/1/1454169.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":23,"referenced_works":["https://openalex.org/W22495568","https://openalex.org/W1561190664","https://openalex.org/W1567277549","https://openalex.org/W1569148339","https://openalex.org/W2024936222","https://openalex.org/W2028703162","https://openalex.org/W2041414515","https://openalex.org/W2060091058","https://openalex.org/W2079557302","https://openalex.org/W2090154982","https://openalex.org/W2095733021","https://openalex.org/W2097710895","https://openalex.org/W2099427938","https://openalex.org/W2109464129","https://openalex.org/W2111087864","https://openalex.org/W2130527449","https://openalex.org/W2134964460","https://openalex.org/W2138525793","https://openalex.org/W2145055832","https://openalex.org/W2156861573","https://openalex.org/W3188744783","https://openalex.org/W6674880182","https://openalex.org/W6679860924"],"related_works":["https://openalex.org/W2149728808","https://openalex.org/W1982455124","https://openalex.org/W16924853","https://openalex.org/W4385585331","https://openalex.org/W2505630977","https://openalex.org/W2383709723","https://openalex.org/W1575529579","https://openalex.org/W2545844851","https://openalex.org/W3022423983","https://openalex.org/W3187319958"],"abstract_inverted_index":{"Efficient":[0],"support":[1],"for":[2,17],"applications":[3],"that":[4],"deal":[5],"with":[6,65,110],"data":[7],"heterogeneity,":[8],"hierarchies":[9],"and":[10,62,88,99],"schema":[11],"evolution":[12],"is":[13,107],"an":[14,44],"important":[15],"challenge":[16],"relational":[18,48],"engines.":[19],"In":[20,68],"this":[21,26,36],"paper":[22],"we":[23],"show":[24],"how":[25],"flexibility":[27],"can":[28],"be":[29],"handled":[30],"in":[31,43,85],"Microsoft":[32],"SQL":[33],"Server.":[34],"For":[35],"purpose,":[37],"the":[38,81],"engine":[39],"has":[40],"been":[41],"equipped":[42],"integrated":[45],"package":[46,51],"of":[47,72,80,83,95],"extensions.":[49],"The":[50,93],"includes":[52],"sparse":[53],"storage,":[54],"column":[55],"set":[56],"operations,":[57],"filtered":[58,60],"indices,":[59],"statistics":[61],"hierarchy":[63],"querying":[64],"OrdPath":[66],"labeling.":[67],"addition,":[69],"economical":[70],"loading":[71],"metadata":[73],"allow":[74],"us":[75],"to":[76],"answer":[77],"queries":[78],"independently":[79],"number":[82],"columns":[84],"a":[86,96,104],"table":[87,106],"drastically":[89],"improve":[90],"scaling":[91],"capabilities.":[92],"design":[94],"prototypical":[97],"content":[98],"collaboration":[100],"application":[101],"based":[102],"on":[103],"wide":[105],"described,":[108],"along":[109],"experiments":[111],"validating":[112],"its":[113],"performance.":[114]},"counts_by_year":[{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":3}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}