{"id":"https://openalex.org/W2125768096","doi":"https://doi.org/10.1016/s0167-9236(03)00048-4","title":"Database design in the modern organization\u2014identifying robust structures under changing query patterns and arrival rate conditions","display_name":"Database design in the modern organization\u2014identifying robust structures under changing query patterns and arrival rate conditions","publication_year":2003,"publication_date":"2003-04-23","ids":{"openalex":"https://openalex.org/W2125768096","doi":"https://doi.org/10.1016/s0167-9236(03)00048-4","mag":"2125768096"},"language":"en","primary_location":{"id":"doi:10.1016/s0167-9236(03)00048-4","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s0167-9236(03)00048-4","pdf_url":null,"source":{"id":"https://openalex.org/S11479521","display_name":"Decision Support Systems","issn_l":"0167-9236","issn":["0167-9236","1873-5797"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Decision Support Systems","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/A5042054706","display_name":"Andrew N. K. Chen","orcid":null},"institutions":[{"id":"https://openalex.org/I55732556","display_name":"Arizona State University","ror":"https://ror.org/03efmqc40","country_code":"US","type":"education","lineage":["https://openalex.org/I55732556"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Andrew N.K. Chen","raw_affiliation_strings":["Arizona State University, USA","Arizona State University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Arizona State University, USA","institution_ids":["https://openalex.org/I55732556"]},{"raw_affiliation_string":"Arizona State University","institution_ids":["https://openalex.org/I55732556"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5109000592","display_name":"Paulo G\u00f3es","orcid":null},"institutions":[{"id":"https://openalex.org/I140172145","display_name":"University of Connecticut","ror":"https://ror.org/02der9h97","country_code":"US","type":"education","lineage":["https://openalex.org/I140172145"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Paulo B. Goes","raw_affiliation_strings":["Department of Operations and Information Management, School of Business Administration, University of Connecticut, 2100 Hillside Road, Storrs, CT 06269, USA","Department of Operations and Information Management, School of Business Administration, University of Connecticut, 2100 Hillside Road, Storrs, CT#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Operations and Information Management, School of Business Administration, University of Connecticut, 2100 Hillside Road, Storrs, CT 06269, USA","institution_ids":["https://openalex.org/I140172145"]},{"raw_affiliation_string":"Department of Operations and Information Management, School of Business Administration, University of Connecticut, 2100 Hillside Road, Storrs, CT#TAB#","institution_ids":["https://openalex.org/I140172145"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5022969857","display_name":"Alok Gupta","orcid":"https://orcid.org/0000-0002-2097-1643"},"institutions":[{"id":"https://openalex.org/I130238516","display_name":"University of Minnesota","ror":"https://ror.org/017zqws13","country_code":"US","type":"education","lineage":["https://openalex.org/I130238516"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Alok Gupta","raw_affiliation_strings":["University of Minnesota, USA","University of\u00a0Minnesota"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Minnesota, USA","institution_ids":["https://openalex.org/I130238516"]},{"raw_affiliation_string":"University of\u00a0Minnesota","institution_ids":["https://openalex.org/I130238516"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5023705779","display_name":"James R. Marsden","orcid":"https://orcid.org/0000-0001-6695-9896"},"institutions":[{"id":"https://openalex.org/I140172145","display_name":"University of Connecticut","ror":"https://ror.org/02der9h97","country_code":"US","type":"education","lineage":["https://openalex.org/I140172145"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"James R. Marsden","raw_affiliation_strings":["Department of Operations and Information Management, School of Business Administration, University of Connecticut, 2100 Hillside Road, Storrs, CT 06269, USA","Department of Operations and Information Management, School of Business Administration, University of Connecticut, 2100 Hillside Road, Storrs, CT#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Operations and Information Management, School of Business Administration, University of Connecticut, 2100 Hillside Road, Storrs, CT 06269, USA","institution_ids":["https://openalex.org/I140172145"]},{"raw_affiliation_string":"Department of Operations and Information Management, School of Business Administration, University of Connecticut, 2100 Hillside Road, Storrs, CT#TAB#","institution_ids":["https://openalex.org/I140172145"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5023705779"],"corresponding_institution_ids":["https://openalex.org/I140172145"],"apc_list":{"value":3280,"currency":"USD","value_usd":3280},"apc_paid":null,"fwci":0.7386,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.78503602,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":"37","issue":"3","first_page":"435","last_page":"447"},"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.9998000264167786,"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/T12016","display_name":"Web Data Mining and Analysis","score":0.9937999844551086,"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.7561866641044617},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6720051169395447},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.6680139303207397},{"id":"https://openalex.org/keywords/online-aggregation","display_name":"Online aggregation","score":0.589099645614624},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5733739733695984},{"id":"https://openalex.org/keywords/database-theory","display_name":"Database theory","score":0.5025546550750732},{"id":"https://openalex.org/keywords/identification","display_name":"Identification (biology)","score":0.47313252091407776},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.465787798166275},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3892207145690918},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.3737725019454956},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.28282368183135986},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.213152676820755},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.18603456020355225}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7561866641044617},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6720051169395447},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.6680139303207397},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.589099645614624},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5733739733695984},{"id":"https://openalex.org/C12439846","wikidata":"https://www.wikidata.org/wiki/Q4809258","display_name":"Database theory","level":3,"score":0.5025546550750732},{"id":"https://openalex.org/C116834253","wikidata":"https://www.wikidata.org/wiki/Q2039217","display_name":"Identification (biology)","level":2,"score":0.47313252091407776},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.465787798166275},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3892207145690918},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.3737725019454956},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.28282368183135986},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.213152676820755},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.18603456020355225},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C59822182","wikidata":"https://www.wikidata.org/wiki/Q441","display_name":"Botany","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1016/s0167-9236(03)00048-4","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s0167-9236(03)00048-4","pdf_url":null,"source":{"id":"https://openalex.org/S11479521","display_name":"Decision Support Systems","issn_l":"0167-9236","issn":["0167-9236","1873-5797"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Decision Support Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":25,"referenced_works":["https://openalex.org/W114148695","https://openalex.org/W151906112","https://openalex.org/W205243208","https://openalex.org/W1482520531","https://openalex.org/W1487130678","https://openalex.org/W1496940124","https://openalex.org/W1515534126","https://openalex.org/W1528281972","https://openalex.org/W1534392094","https://openalex.org/W1562680794","https://openalex.org/W1598358745","https://openalex.org/W1603897339","https://openalex.org/W1799154104","https://openalex.org/W2072764742","https://openalex.org/W2112709014","https://openalex.org/W2143401113","https://openalex.org/W2144192824","https://openalex.org/W2160770337","https://openalex.org/W2167357284","https://openalex.org/W2312784726","https://openalex.org/W2511894128","https://openalex.org/W2942827234","https://openalex.org/W6628941440","https://openalex.org/W6630873793","https://openalex.org/W6631862332"],"related_works":["https://openalex.org/W2554271401","https://openalex.org/W2889903446","https://openalex.org/W2992414350","https://openalex.org/W3125756434","https://openalex.org/W2150741898","https://openalex.org/W4281289408","https://openalex.org/W2371929047","https://openalex.org/W1502610062","https://openalex.org/W2249768123","https://openalex.org/W185198413"],"abstract_inverted_index":null,"counts_by_year":[{"year":2016,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}