{"id":"https://openalex.org/W1505401439","doi":"https://doi.org/10.1007/978-3-540-30076-2_2","title":"Bringing Together Partitioning, Materialized Views and Indexes to Optimize Performance of Relational Data Warehouses","display_name":"Bringing Together Partitioning, Materialized Views and Indexes to Optimize Performance of Relational Data Warehouses","publication_year":2004,"publication_date":"2004-01-01","ids":{"openalex":"https://openalex.org/W1505401439","doi":"https://doi.org/10.1007/978-3-540-30076-2_2","mag":"1505401439"},"language":"en","primary_location":{"id":"doi:10.1007/978-3-540-30076-2_2","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-540-30076-2_2","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://hal.science/hal-03777794","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5006507514","display_name":"Ladjel Bellatreche","orcid":"https://orcid.org/0000-0001-9968-0066"},"institutions":[{"id":"https://openalex.org/I171246369","display_name":"\u00c9cole Nationale Sup\u00e9rieure de M\u00e9canique et d'A\u00e9rotechnique","ror":"https://ror.org/04jx68594","country_code":"FR","type":"facility","lineage":["https://openalex.org/I171246369"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Ladjel Bellatreche","raw_affiliation_strings":["LISI/ENSMA, Futuroscope, France","LISI/ENSMA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"LISI/ENSMA, Futuroscope, France","institution_ids":["https://openalex.org/I171246369"]},{"raw_affiliation_string":"LISI/ENSMA","institution_ids":["https://openalex.org/I171246369"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5038430255","display_name":"Michel Schneider","orcid":"https://orcid.org/0000-0002-2701-4731"},"institutions":[{"id":"https://openalex.org/I198244214","display_name":"Universit\u00e9 Clermont Auvergne","ror":"https://ror.org/01a8ajp46","country_code":"FR","type":"education","lineage":["https://openalex.org/I198244214"]},{"id":"https://openalex.org/I4210099416","display_name":"Laboratoire d'Informatique, de Mod\u00e9lisation et d'Optimisation des Syst\u00e8mes","ror":"https://ror.org/00t3fpp34","country_code":"FR","type":"facility","lineage":["https://openalex.org/I1294671590","https://openalex.org/I1294671590","https://openalex.org/I198244214","https://openalex.org/I198244214","https://openalex.org/I203339264","https://openalex.org/I205703379","https://openalex.org/I3019848993","https://openalex.org/I4210099416","https://openalex.org/I4210123221","https://openalex.org/I4210159245","https://openalex.org/I4387154249"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Michel Schneider","raw_affiliation_strings":["LIMOS, Blaise Pascal University, France","[Blaise Pascal University]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"LIMOS, Blaise Pascal University, France","institution_ids":["https://openalex.org/I198244214","https://openalex.org/I4210099416"]},{"raw_affiliation_string":"[Blaise Pascal University]","institution_ids":["https://openalex.org/I198244214"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5011133344","display_name":"Herv\u00e9 Lorinquer","orcid":null},"institutions":[{"id":"https://openalex.org/I198244214","display_name":"Universit\u00e9 Clermont Auvergne","ror":"https://ror.org/01a8ajp46","country_code":"FR","type":"education","lineage":["https://openalex.org/I198244214"]},{"id":"https://openalex.org/I4210099416","display_name":"Laboratoire d'Informatique, de Mod\u00e9lisation et d'Optimisation des Syst\u00e8mes","ror":"https://ror.org/00t3fpp34","country_code":"FR","type":"facility","lineage":["https://openalex.org/I1294671590","https://openalex.org/I1294671590","https://openalex.org/I198244214","https://openalex.org/I198244214","https://openalex.org/I203339264","https://openalex.org/I205703379","https://openalex.org/I3019848993","https://openalex.org/I4210099416","https://openalex.org/I4210123221","https://openalex.org/I4210159245","https://openalex.org/I4387154249"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Herv\u00e9 Lorinquer","raw_affiliation_strings":["LIMOS, Blaise Pascal University, France","[Blaise Pascal University]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"LIMOS, Blaise Pascal University, France","institution_ids":["https://openalex.org/I198244214","https://openalex.org/I4210099416"]},{"raw_affiliation_string":"[Blaise Pascal University]","institution_ids":["https://openalex.org/I198244214"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5047987914","display_name":"Mukesh Mohania","orcid":"https://orcid.org/0000-0003-4429-1412"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Mukesh Mohania","raw_affiliation_strings":["I.B.M. India Research Lab, India","I.B.M. India Research Lab"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"I.B.M. India Research Lab, India","institution_ids":[]},{"raw_affiliation_string":"I.B.M. India Research Lab","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":{"value":5000,"currency":"EUR","value_usd":5392},"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":30,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"15","last_page":"25"},"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/T11106","display_name":"Data Management and Algorithms","score":0.9993000030517578,"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.9976999759674072,"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/materialized-view","display_name":"Materialized view","score":0.9501931667327881},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7850589752197266},{"id":"https://openalex.org/keywords/bitmap","display_name":"Bitmap","score":0.7477952837944031},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.7153818607330322},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.6771965622901917},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5725358128547668},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5567935705184937},{"id":"https://openalex.org/keywords/index","display_name":"Index (typography)","score":0.48591890931129456},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.48578906059265137},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3281008303165436},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.3005404472351074},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.1365240514278412},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.094098299741745},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.06453928351402283},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.060827434062957764}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.9501931667327881},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7850589752197266},{"id":"https://openalex.org/C3115412","wikidata":"https://www.wikidata.org/wiki/Q1194708","display_name":"Bitmap","level":2,"score":0.7477952837944031},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7153818607330322},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.6771965622901917},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5725358128547668},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5567935705184937},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.48591890931129456},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.48578906059265137},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3281008303165436},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.3005404472351074},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.1365240514278412},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.094098299741745},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.06453928351402283},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.060827434062957764}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1007/978-3-540-30076-2_2","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-540-30076-2_2","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},{"id":"pmh:oai:HAL:hal-03777794v1","is_oa":true,"landing_page_url":"https://hal.science/hal-03777794","pdf_url":null,"source":{"id":"https://openalex.org/S4306402512","display_name":"HAL (Le Centre pour la Communication Scientifique Directe)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1294671590","host_organization_name":"Centre National de la Recherche Scientifique","host_organization_lineage":["https://openalex.org/I1294671590"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Proc. 6th International Conference on Data Warehousing and Knowledge Discovery (DWKD 2004), Sep 2004, Zaragoza, Spain. pp.15-25, ⟨10.1007/978-3-540-30076-2_2⟩","raw_type":"info:eu-repo/semantics/conferenceObject"}],"best_oa_location":{"id":"pmh:oai:HAL:hal-03777794v1","is_oa":true,"landing_page_url":"https://hal.science/hal-03777794","pdf_url":null,"source":{"id":"https://openalex.org/S4306402512","display_name":"HAL (Le Centre pour la Communication Scientifique Directe)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1294671590","host_organization_name":"Centre National de la Recherche Scientifique","host_organization_lineage":["https://openalex.org/I1294671590"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Proc. 6th International Conference on Data Warehousing and Knowledge Discovery (DWKD 2004), Sep 2004, Zaragoza, Spain. pp.15-25, ⟨10.1007/978-3-540-30076-2_2⟩","raw_type":"info:eu-repo/semantics/conferenceObject"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":12,"referenced_works":["https://openalex.org/W1520432709","https://openalex.org/W1538267625","https://openalex.org/W1542786062","https://openalex.org/W1547113406","https://openalex.org/W1851390469","https://openalex.org/W2111967617","https://openalex.org/W2113888164","https://openalex.org/W2122816893","https://openalex.org/W2167445883","https://openalex.org/W2751011414","https://openalex.org/W3002580249","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2162280381","https://openalex.org/W2185691065","https://openalex.org/W2363712075","https://openalex.org/W2383931363","https://openalex.org/W2348265434","https://openalex.org/W2108498730","https://openalex.org/W2142569422","https://openalex.org/W2087983779","https://openalex.org/W152305489","https://openalex.org/W1635132392"],"abstract_inverted_index":null,"counts_by_year":[{"year":2019,"cited_by_count":1},{"year":2017,"cited_by_count":3},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":3}],"updated_date":"2026-07-22T07:51:19.307946","created_date":"2025-10-10T00:00:00"}