{"id":"https://openalex.org/W64788854","doi":"https://doi.org/10.1007/978-94-007-5860-5_111","title":"Improved View Selection Algorithm in Data Warehouse","display_name":"Improved View Selection Algorithm in Data Warehouse","alternate_titles":[],"publication_year":2012,"publication_date":"2012-12-11","ids":{"openalex":"https://openalex.org/W64788854","doi":"https://doi.org/10.1007/978-94-007-5860-5_111","mag":"64788854"},"language":"en","primary_location":{"id":"doi:10.1007/978-94-007-5860-5_111","doi":"https://doi.org/10.1007/978-94-007-5860-5_111","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-94-007-5860-5_111","pdf_url":null,"source":{"id":"https://openalex.org/S4210179954","display_name":"Lecture notes in electrical engineering","issn_l":"1876-1100","issn":["1876-1100","1876-1119"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","jufo-1","norway-1"],"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 Electrical Engineering","raw_type":"book-chapter"},"parent_works":[{"id":"https://openalex.org/W2915358638","display_name":"IT Convergence and Security 2012","relationship":"volume","link_type":"volume"}],"lineage":["https://openalex.org/W64788854","https://openalex.org/W2915358638"],"child_works_count":0,"type":"book-chapter","is_traditional":true,"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/A5112531559","display_name":"Jong-Soo Sohn","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I197347611","display_name":"Korea University","ror":"https://ror.org/047dqcg40","country_code":"KR","type":"education","lineage":["https://openalex.org/I197347611"]}],"countries":["KR"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Jong-Soo Sohn","raw_affiliation_strings":["Department of Computer and Information Science, Korea University, 208 Seochangri, Sejong City, South Korea"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer and Information Science, Korea University, 208 Seochangri, Sejong City, South Korea","institution_ids":["https://openalex.org/I197347611"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5081935928","display_name":"Jin-Hyuk Yang","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4210089271","display_name":"Korea Institute of Planning and Evaluation for Technology in Food, Agriculture, Forestry and Fisheries","ror":"https://ror.org/00c25dn03","country_code":"KR","type":"government","lineage":["https://openalex.org/I4210089271"]}],"countries":["KR"],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Jin-Hyuk Yang","raw_affiliation_strings":["Korea Institute of Planning and Evaluation for Technology in Food Republic of Korea, An-yang, South Korea"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Korea Institute of Planning and Evaluation for Technology in Food Republic of Korea, An-yang, South Korea","institution_ids":["https://openalex.org/I4210089271"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5113853003","display_name":"In-Jeong Chung","orcid":"https://orcid.org/0000-0002-5020-8921","observed_orcids":["https://orcid.org/0000-0002-5020-8921"]},"institutions":[{"id":"https://openalex.org/I197347611","display_name":"Korea University","ror":"https://ror.org/047dqcg40","country_code":"KR","type":"education","lineage":["https://openalex.org/I197347611"]}],"countries":["KR"],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"In-Jeong Chung","raw_affiliation_strings":["Department of Computer and Information Science, Korea University, 208 Seochangri, Sejong City, South Korea"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer and Information Science, Korea University, 208 Seochangri, Sejong City, South Korea","institution_ids":["https://openalex.org/I197347611"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5113853003"],"corresponding_institution_ids":["https://openalex.org/I197347611"],"apc_list":null,"apc_paid":null,"fwci":5.1578,"has_fulltext":false,"cited_by_count":6,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.9433747,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":87,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"921","last_page":"928"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.98580002784729,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.98580002784729,"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"}},{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.00930000003427267,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.0007999999797903001,"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/view-selection","display_name":"view selection","score":0.9399999976158142},{"id":"https://openalex.org/keywords/materialized-views","display_name":"materialized views","score":0.9729999899864197},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"data warehouse","score":0.9589999914169312},{"id":"https://openalex.org/keywords/clustering","display_name":"clustering","score":0.7889999747276306},{"id":"https://openalex.org/keywords/np-hardness","display_name":"NP-hardness","score":0.6119999885559082},{"id":"https://openalex.org/keywords/query-processing-time","display_name":"query processing time","score":0.8309999704360962},{"id":"https://openalex.org/keywords/aggregate-data","display_name":"aggregated data","score":0.675000011920929},{"id":"https://openalex.org/keywords/fact-tables","display_name":"fact tables","score":0.47200000286102295}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.9555709362030029},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.861664891242981},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7593073844909668},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.6965718269348145},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.6349331140518188},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.6288275122642517},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.5968620777130127},{"id":"https://openalex.org/C2780801425","wikidata":"https://www.wikidata.org/wiki/Q5164392","display_name":"Construct (python library)","level":2,"score":0.5952150225639343},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.5616816282272339},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.5253053307533264},{"id":"https://openalex.org/C73555534","wikidata":"https://www.wikidata.org/wiki/Q622825","display_name":"Cluster analysis","level":2,"score":0.5210787057876587},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4367139935493469},{"id":"https://openalex.org/C42058472","wikidata":"https://www.wikidata.org/wiki/Q810214","display_name":"Base (topology)","level":2,"score":0.430513471364975},{"id":"https://openalex.org/C2778572836","wikidata":"https://www.wikidata.org/wiki/Q380933","display_name":"Space (punctuation)","level":2,"score":0.4289016127586365},{"id":"https://openalex.org/C2775973920","wikidata":"https://www.wikidata.org/wiki/Q3252726","display_name":"Selection algorithm","level":3,"score":0.41525590419769287},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3941950500011444},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3910307288169861},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.23810145258903503},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.15341508388519287},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.1230384111404419},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.08326193690299988},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-94-007-5860-5_111","doi":"https://doi.org/10.1007/978-94-007-5860-5_111","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-94-007-5860-5_111","pdf_url":null,"source":{"id":"https://openalex.org/S4210179954","display_name":"Lecture notes in electrical engineering","issn_l":"1876-1100","issn":["1876-1100","1876-1119"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","jufo-1","norway-1"],"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 Electrical Engineering","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":15,"referenced_works":["https://openalex.org/W32696687","https://openalex.org/W1482520531","https://openalex.org/W1520432709","https://openalex.org/W1541435301","https://openalex.org/W2087869882","https://openalex.org/W2100406636","https://openalex.org/W2114712170","https://openalex.org/W2124751909","https://openalex.org/W2143401113","https://openalex.org/W2143515359","https://openalex.org/W2153028052","https://openalex.org/W2156554027","https://openalex.org/W2168580950","https://openalex.org/W4289258943","https://openalex.org/W6600648412"],"related_works":["https://openalex.org/W1523517289","https://openalex.org/W2399964450","https://openalex.org/W2301096354","https://openalex.org/W2088908211","https://openalex.org/W2395940163","https://openalex.org/W1974939151","https://openalex.org/W2114713465","https://openalex.org/W1908544460","https://openalex.org/W2348826713","https://openalex.org/W2087983779"],"abstract_inverted_index":null,"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W64788854","counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":1}],"updated_date":"2026-11-20T13:11:24.684918","created_date":"2016-06-24T00:00:00"}
