{"id":"https://openalex.org/W2167145555","doi":null,"title":"Amdb: A Design Tool for Access Methods","display_name":"Amdb: A Design Tool for Access Methods","publication_year":2003,"publication_date":"2003-01-01","ids":{"openalex":"https://openalex.org/W2167145555","mag":"2167145555"},"language":"en","primary_location":{"id":"pmh:oai:CiteSeerX.psu:10.1.1.17.3800","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.17.3800","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://db.cs.berkeley.edu/~marcel/papers/amdb.ps.gz","raw_type":"text"},"volume":null,"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/A5038422812","display_name":"Marcel Kornacker","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Marcel Kornacker","raw_affiliation_strings":["University of California\u2013Berkeley"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California\u2013Berkeley","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063179800","display_name":"Mehul A. Shah","orcid":"https://orcid.org/0000-0002-0312-0388","observed_orcids":["https://orcid.org/0000-0002-0312-0388"]},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mehul A. Shah","raw_affiliation_strings":["University of California\u2013Berkeley"],"raw_orcid":"https://orcid.org/0000-0002-0312-0388","affiliations":[{"raw_affiliation_string":"University of California\u2013Berkeley","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5043626252","display_name":"Joseph M. Hellerstein","orcid":"https://orcid.org/0000-0002-7712-4306","observed_orcids":["https://orcid.org/0000-0002-7712-4306"]},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Joseph M. Hellerstein","raw_affiliation_strings":["University of California\u2013Berkeley"],"raw_orcid":"https://orcid.org/0000-0002-7712-4306","affiliations":[{"raw_affiliation_string":"University of California\u2013Berkeley","institution_ids":["https://openalex.org/I95457486"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I95457486"],"apc_list":null,"apc_paid":null,"fwci":0.541,"has_fulltext":false,"cited_by_count":12,"citation_normalized_percentile":{"value":0.77667168,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":97},"biblio":{"volume":"26","issue":null,"first_page":"3","last_page":"11"},"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.861299991607666,"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.861299991607666,"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/T11106","display_name":"Data Management and Algorithms","score":0.060100000351667404,"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/T11269","display_name":"Algorithms and Data Compression","score":0.0544000007212162,"subfield":{"id":"https://openalex.org/subfields/2614","display_name":"Theoretical Computer Science"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/access-methods","display_name":"access methods","score":0.8429999947547913},{"id":"https://openalex.org/keywords/performance-indicators","display_name":"performance indicators","score":0.9480000138282776},{"id":"https://openalex.org/keywords/performance-evaluation","display_name":"performance evaluation","score":0.5609999895095825},{"id":"https://openalex.org/keywords/visualization","display_name":"visualization","score":0.8930000066757202},{"id":"https://openalex.org/keywords/debugging","display_name":"debugging","score":0.9430000185966492},{"id":"https://openalex.org/keywords/database-indexing","display_name":"database indexing","score":0.40299999713897705}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8806840181350708},{"id":"https://openalex.org/C168065819","wikidata":"https://www.wikidata.org/wiki/Q845566","display_name":"Debugging","level":2,"score":0.814158022403717},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.7045914530754089},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.5637331008911133},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.48198336362838745},{"id":"https://openalex.org/C124304363","wikidata":"https://www.wikidata.org/wiki/Q673661","display_name":"Abstraction","level":2,"score":0.4788815379142761},{"id":"https://openalex.org/C2777466363","wikidata":"https://www.wikidata.org/wiki/Q17008971","display_name":"Design tool","level":2,"score":0.4742628335952759},{"id":"https://openalex.org/C113174947","wikidata":"https://www.wikidata.org/wiki/Q2859736","display_name":"Tree (set theory)","level":2,"score":0.4620468020439148},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.45555150508880615},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.31961995363235474},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2435867190361023},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.11674803495407104},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"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/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":4,"locations":[{"id":"pmh:oai:CiteSeerX.psu:10.1.1.17.3800","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.17.3800","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://db.cs.berkeley.edu/~marcel/papers/amdb.ps.gz","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.228.8521","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.228.8521","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://db.cs.berkeley.edu/papers/amdb.pdf","raw_type":"text"},{"id":"pmh:oai:berkeley.edu:13030-hb4d5nb4mw","doi":null,"is_oa":false,"landing_page_url":"http://techreports.lib.berkeley.edu/accessPages/CSD-03-1243.html","pdf_url":null,"source":{"id":"https://openalex.org/S7407050879","display_name":"UC Berkeley","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I95457486","host_organization_name":"University of California, Berkeley","host_organization_lineage":["https://openalex.org/I95457486"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"technical reports"},{"id":"mag:2167145555","doi":null,"is_oa":false,"landing_page_url":"http://db.cs.berkeley.edu/papers/amdb.pdf","pdf_url":null,"source":{"id":"https://openalex.org/S62003192","display_name":"IEEE Data(base) Engineering Bulletin","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":"IEEE Data(base) Engineering Bulletin","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":25,"referenced_works":["https://openalex.org/W5005017","https://openalex.org/W125925666","https://openalex.org/W203207630","https://openalex.org/W1672197616","https://openalex.org/W2011039300","https://openalex.org/W2055353751","https://openalex.org/W2059797311","https://openalex.org/W2062161320","https://openalex.org/W2104353762","https://openalex.org/W2106642566","https://openalex.org/W2106788474","https://openalex.org/W2107779728","https://openalex.org/W2115084472","https://openalex.org/W2118269922","https://openalex.org/W2120970098","https://openalex.org/W2127255002","https://openalex.org/W2132353445","https://openalex.org/W2133542527","https://openalex.org/W2135961964","https://openalex.org/W2145725688","https://openalex.org/W2151135734","https://openalex.org/W2155776210","https://openalex.org/W2161694911","https://openalex.org/W2171096036","https://openalex.org/W2411487789"],"related_works":["https://openalex.org/W2411487789","https://openalex.org/W160825492","https://openalex.org/W2055353751","https://openalex.org/W2106788474","https://openalex.org/W2531628701","https://openalex.org/W2435355301","https://openalex.org/W7132218489","https://openalex.org/W7097384744","https://openalex.org/W2135279969","https://openalex.org/W7096087753"],"abstract_inverted_index":{"Designing":[0],"and":[1,76,84,98,140,159,166,230],"tuning":[2],"access":[3],"methods":[4],"(AMs)":[5],"has":[6],"always":[7],"been":[8],"more":[9,70],"of":[10,47,56,109,120,136,169,179,186,197,212,237,238],"a":[11,15,35,161,164,167,210],"black":[12],"art":[13],"than":[14,72],"rigorous":[16],"discipline,":[17],"with":[18,96,117,143],"performance":[19,66,122,154,178,219],"assessments":[20],"being":[21],"mostly":[22],"reduced":[23],"to":[24,82,105,115,191,225,234],"presenting":[25],"aggregate":[26],"runtime":[27],"or":[28,240],"I/O":[29],"numbers.":[30],"This":[31],"paper":[32],"presents":[33],"amdb,":[34],"comprehensive":[36],"graphical":[37],"design":[38,126],"tool":[39],"for":[40,62],"AMs":[41,63,229],"that":[42,64,68,112,151,185],"are":[43,69],"constructed":[44],"on":[45],"top":[46],"the":[48,54,79,93,102,107,118,121,134,137,153,174,177,187,192,195,198,216],"Generalized":[49],"Search":[50],"Tree":[51],"abstraction.":[52],"At":[53],"core":[55],"amdb":[57],"lies":[58],"an":[59,88],"analysis":[60,94,138,149],"framework":[61,95,139,193,223],"defines":[65],"metrics":[67,155,175],"useful":[71],"traditional":[73],"summary":[74],"numbers":[75],"thereby":[77],"allow":[78],"AM":[80,89,103,125],"designer":[81,104],"detect":[83],"isolate":[85],"deficiencies":[86,111],"in":[87,146],"design.":[90],"Amdb":[91],"complements":[92],"visualization":[97,144],"debugging":[99],"functionality,":[100],"allowing":[101],"investigate":[106],"source":[108],"those":[110],"were":[113],"brought":[114],"light":[116],"help":[119],"metrics.":[123],"Several":[124],"projects":[127],"undertaken":[128],"at":[129],"U.C.":[130],"Berkeley":[131],"have":[132],"confirmed":[133],"usefulness":[135],"its":[141],"integration":[142],"facilities":[145],"amdb.":[147],"The":[148,222],"process":[150],"produces":[152],"is":[156,194,220,231],"fully":[157],"automated":[158],"takes":[160],"workload":[162],"--":[163,171,201,208],"tree":[165,188],"set":[168],"queries":[170,241],"as":[172,182,184,209],"input;":[173],"characterize":[176],"each":[180],"query":[181],"well":[183],"structure.":[189],"Central":[190],"use":[196],"optimal":[199],"behavior":[200],"which":[202,215],"can":[203],"be":[204],"approximated":[205],"relatively":[206],"efficiently":[207],"point":[211],"reference":[213],"against":[214],"actual":[217],"observed":[218],"compared.":[221],"applies":[224],"most":[226],"balanced":[227],"tree-structured":[228],"not":[232],"restricted":[233],"particular":[235],"types":[236],"data":[239]},"counts_by_year":[{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":3},{"year":2016,"cited_by_count":1},{"year":2013,"cited_by_count":1}],"updated_date":"2026-11-11T12:16:26.678958","created_date":"2016-06-24T00:00:00"}