{"id":"https://openalex.org/W2079557302","doi":"https://doi.org/10.1109/icde.2008.4497535","title":"Filtered Indices and Their Use in Flexible Schema Scenarios","display_name":"Filtered Indices and Their Use in Flexible Schema Scenarios","publication_year":2008,"publication_date":"2008-04-01","ids":{"openalex":"https://openalex.org/W2079557302","doi":"https://doi.org/10.1109/icde.2008.4497535","mag":"2079557302"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2008.4497535","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2008.4497535","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2008 IEEE 24th International Conference on Data Engineering","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/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, Microsoft Corporation, Redmond, WA, USA","SQL Server, Microsoft Corp., Redmond, WA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft SQL Server, Microsoft Corporation, Redmond, WA, USA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"SQL Server, Microsoft Corp., Redmond, WA","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, Microsoft Corporation, Redmond, WA, USA","SQL Server, Microsoft Corp., Redmond, WA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft SQL Server, Microsoft Corporation, Redmond, WA, USA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"SQL Server, Microsoft Corp., Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5022433632","display_name":"Milind Joshi","orcid":"https://orcid.org/0009-0001-0769-1700"},"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":"Milind Joshi","raw_affiliation_strings":["Microsoft SQL Server, Microsoft Corporation, Redmond, WA, USA","SQL Server, Microsoft Corp., Redmond, WA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft SQL Server, Microsoft Corporation, Redmond, WA, USA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"SQL Server, Microsoft Corp., Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5020753127","display_name":"Babu Krishnaswamy","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":"Babu Krishnaswamy","raw_affiliation_strings":["Microsoft SQL Server, Microsoft Corporation, Redmond, WA, USA","SQL Server, Microsoft Corp., Redmond, WA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft SQL Server, Microsoft Corporation, Redmond, WA, USA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"SQL Server, Microsoft Corp., Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5015057475","display_name":"Stefano Stefani","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":"Stefano Stefani","raw_affiliation_strings":["Microsoft SQL Server, Microsoft Corporation, Redmond, WA, USA","SQL Server, Microsoft Corp., Redmond, WA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft SQL Server, Microsoft Corporation, Redmond, WA, USA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"SQL Server, Microsoft Corp., Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"last","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, Microsoft Corporation, Redmond, WA, USA","SQL Server, Microsoft Corp., Redmond, WA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft SQL Server, Microsoft Corporation, Redmond, WA, USA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"SQL Server, Microsoft Corp., Redmond, WA","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":0.7628,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.76541314,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1259","last_page":"1266"},"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.9998999834060669,"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.9998999834060669,"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/T11106","display_name":"Data Management and Algorithms","score":0.9995999932289124,"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"}},{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9980999827384949,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.8310154676437378},{"id":"https://openalex.org/keywords/indexation","display_name":"Indexation","score":0.8307218551635742},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.6833627223968506},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.48743370175361633},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.47801196575164795},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.4751177430152893},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.46622350811958313},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.45722144842147827},{"id":"https://openalex.org/keywords/focus","display_name":"Focus (optics)","score":0.43350857496261597},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2727452516555786}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8310154676437378},{"id":"https://openalex.org/C186311912","wikidata":"https://www.wikidata.org/wiki/Q2038409","display_name":"Indexation","level":3,"score":0.8307218551635742},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6833627223968506},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.48743370175361633},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.47801196575164795},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.4751177430152893},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.46622350811958313},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.45722144842147827},{"id":"https://openalex.org/C192209626","wikidata":"https://www.wikidata.org/wiki/Q190909","display_name":"Focus (optics)","level":2,"score":0.43350857496261597},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2727452516555786},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C556758197","wikidata":"https://www.wikidata.org/wiki/Q580018","display_name":"Monetary economics","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C120665830","wikidata":"https://www.wikidata.org/wiki/Q14620","display_name":"Optics","level":1,"score":0.0},{"id":"https://openalex.org/C126285488","wikidata":"https://www.wikidata.org/wiki/Q178476","display_name":"Monetary policy","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde.2008.4497535","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2008.4497535","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2008 IEEE 24th International Conference on Data Engineering","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":15,"referenced_works":["https://openalex.org/W1506285740","https://openalex.org/W1561190664","https://openalex.org/W1994502095","https://openalex.org/W2028703162","https://openalex.org/W2041414515","https://openalex.org/W2109464129","https://openalex.org/W2111087864","https://openalex.org/W2130527449","https://openalex.org/W2138525793","https://openalex.org/W2140190241","https://openalex.org/W2145055832","https://openalex.org/W2156861573","https://openalex.org/W2747076629","https://openalex.org/W6630198464","https://openalex.org/W6633562499"],"related_works":["https://openalex.org/W2573939812","https://openalex.org/W2120098008","https://openalex.org/W1639806124","https://openalex.org/W4366145086","https://openalex.org/W2902831276","https://openalex.org/W2540682188","https://openalex.org/W4385834214","https://openalex.org/W3022423983","https://openalex.org/W12347151","https://openalex.org/W2957025774"],"abstract_inverted_index":{"Efficient":[0],"and":[1,27,51,58,87],"convenient":[2],"handling":[3],"of":[4,77,98],"heterogeneous":[5],"data":[6,12,56],"is":[7],"a":[8,30,34,40],"current":[9],"challenge":[10],"for":[11,29,54],"management":[13],"systems.":[14],"In":[15],"this":[16,44,78],"paper,":[17],"we":[18,46],"discuss":[19],"several":[20],"common":[21],"relational":[22],"approaches":[23],"to":[24,38],"represent":[25],"heterogeneity":[26],"argue":[28],"design":[31],"based":[32],"on":[33,48],"single":[35],"wide-table,":[36],"referred":[37],"as":[39],"flexible":[41],"schema.":[42],"For":[43],"scenario,":[45],"focus":[47],"partial":[49,63],"indexation":[50,64],"its":[52],"support":[53],"efficient":[55],"storage":[57],"processing.":[59],"Filtered":[60],"indices":[61],"provide":[62],"functionality":[65],"in":[66,83,101],"the":[67,75,95,99],"Microsoft":[68],"SQL":[69],"Server":[70],"product.":[71],"We":[72],"describe":[73],"here":[74],"implementation":[76],"feature,":[79],"including":[80],"index":[81,85],"utilization":[82],"queries,":[84],"maintenance":[86],"query":[88],"parameterization":[89],"issues.":[90],"Our":[91],"performance":[92],"experiments":[93],"validate":[94],"expected":[96],"benefits":[97],"approach":[100],"our":[102],"implementation.":[103]},"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}