{"id":"https://openalex.org/W1601629924","doi":null,"title":"Automatic Database Configuration for DB2 Universal Database: Compressing Years of Performance Expertise into Seconds of Execution.","display_name":"Automatic Database Configuration for DB2 Universal Database: Compressing Years of Performance Expertise into Seconds of Execution.","alternate_titles":[],"publication_year":2003,"publication_date":"2003-01-01","ids":{"openalex":"https://openalex.org/W1601629924","mag":"1601629924"},"language":"en","primary_location":{"id":"mag:1601629924","doi":null,"is_oa":false,"landing_page_url":"http://doesen0.informatik.uni-leipzig.de/proceedings/paper/IP7.pdf","pdf_url":null,"source":{"id":"https://openalex.org/S4306504987","display_name":"BTW","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core"],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"BTW","raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W1601629924"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":[],"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/A5031130562","display_name":"Eva Kwan","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Eva Kwan","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5030480168","display_name":"Sam S. Lightstone","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Sam Lightstone","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037950446","display_name":"K. Bernhard Schiefer","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"K. Bernhard Schiefer","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5109054273","display_name":"Adam J. Storm","orcid":"https://orcid.org/0009-0007-8844-4835","observed_orcids":["https://orcid.org/0009-0007-8844-4835"]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Adam Storm","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5038832241","display_name":"Leanne Wu","orcid":"https://orcid.org/0000-0001-5018-2226","observed_orcids":["https://orcid.org/0000-0001-5018-2226"]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Leanne Wu","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.287,"has_fulltext":false,"cited_by_count":40,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.8977419,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":86,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"620","last_page":"629"},"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.9976000189781189,"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.9976000189781189,"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/T12127","display_name":"Software System Performance and Reliability","score":0.0007999999797903001,"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/T10639","display_name":"Advanced Software Engineering Methodologies","score":0.00039999998989515007,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/db2-universal-database","display_name":"DB2 Universal Database","score":0.9279999732971191},{"id":"https://openalex.org/keywords/database-configuration","display_name":"database configuration","score":0.8550000190734863},{"id":"https://openalex.org/keywords/expert-systems","display_name":"expert systems","score":0.6129999756813049},{"id":"https://openalex.org/keywords/database-tuning","display_name":"database performance tuning","score":0.675000011920929},{"id":"https://openalex.org/keywords/autonomic-computing","display_name":"autonomic computing","score":0.949999988079071},{"id":"https://openalex.org/keywords/relational-database-management-systems","display_name":"relational database management systems","score":0.8529999852180481},{"id":"https://openalex.org/keywords/unix","display_name":"UNIX","score":0.5400000214576721},{"id":"https://openalex.org/keywords/windows","display_name":"windows","score":0.9980000257492065}],"concepts":[{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.7820649147033691},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7727986574172974},{"id":"https://openalex.org/C112968700","wikidata":"https://www.wikidata.org/wiki/Q11368","display_name":"Unix","level":3,"score":0.6687450408935547},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6562089323997498},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.6027424931526184},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.5636904239654541},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.5491240620613098},{"id":"https://openalex.org/C205295232","wikidata":"https://www.wikidata.org/wiki/Q76320","display_name":"Database server","level":2,"score":0.5303134322166443},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.5120535492897034},{"id":"https://openalex.org/C2776401178","wikidata":"https://www.wikidata.org/wiki/Q12050496","display_name":"Feature (linguistics)","level":2,"score":0.4628846347332001},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.404715359210968},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.17468935251235962},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"mag:1601629924","doi":null,"is_oa":false,"landing_page_url":"http://doesen0.informatik.uni-leipzig.de/proceedings/paper/IP7.pdf","pdf_url":null,"source":{"id":"https://openalex.org/S4306504987","display_name":"BTW","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core"],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"BTW","raw_type":null},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.394.639","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.394.639","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://subs.emis.de/LNI/Proceedings/Proceedings26/GI-Proceedings.26-44.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.5.1454","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.5.1454","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.btw2003.de/proceedings/paper/IP7.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":5,"referenced_works":["https://openalex.org/W320896","https://openalex.org/W73246605","https://openalex.org/W1491456149","https://openalex.org/W2047085757","https://openalex.org/W2055958975"],"related_works":["https://openalex.org/W7099871987","https://openalex.org/W73246605","https://openalex.org/W7098624672","https://openalex.org/W74024549","https://openalex.org/W7099373927","https://openalex.org/W2343938317","https://openalex.org/W3165341913","https://openalex.org/W1553825122","https://openalex.org/W2042064890","https://openalex.org/W2889252017"],"abstract_inverted_index":{"This":[0,16,71],"paper":[1,72],"describes":[2],"the":[3,11,36,74,90],"DB2":[4,14,26,57],"Configuration":[5,58],"Advisor,":[6],"an":[7],"expert":[8,80],"tool":[9],"for":[10,22,39],"configuration":[12],"of":[13,35,78,89],"databases.":[15],"advisor":[17],"has":[18,44],"shown":[19],"dramatic":[20],"results":[21,83],"tuning":[23],"and":[24,30,41,76],"configuring":[25],"servers":[27],"on":[28],"UNIX":[29],"Windows":[31],"platforms.":[32],"The":[33,56],"recognition":[34],"essential":[37],"need":[38],"administration":[40],"design":[42],"tools":[43],"spurred":[45],"renewed":[46],"interest":[47],"among":[48],"leading":[49],"relational":[50],"database":[51],"management":[52],"system":[53],"(RDBMS)":[54],"vendors.":[55],"Advisor":[59],"is":[60],"a":[61,87],"key":[62],"feature":[63],"in":[64],"DB2's":[65],"Autonomic":[66],"Computing":[67],"self-managing":[68],"technology":[69],"portfolio.":[70],"discusses":[73],"purpose":[75],"features":[77],"this":[79],"advisor.":[81],"Experimental":[82],"are":[84],"presented":[85],"with":[86],"description":[88],"advisor's":[91],"interfaces.":[92]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W1601629924","counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":2}],"updated_date":"2026-11-21T10:27:49.728292","created_date":"2016-06-24T00:00:00"}
