{"id":"https://openalex.org/W3143529756","doi":"https://doi.org/10.1109/ideas.2007.4318117","title":"Examining the Performance of a Constraint-Based Database Cache","display_name":"Examining the Performance of a Constraint-Based Database Cache","publication_year":2007,"publication_date":"2007-09-01","ids":{"openalex":"https://openalex.org/W3143529756","doi":"https://doi.org/10.1109/ideas.2007.4318117","mag":"3143529756"},"language":"en","primary_location":{"id":"doi:10.1109/ideas.2007.4318117","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ideas.2007.4318117","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"11th International Database Engineering and Applications Symposium (IDEAS 2007)","raw_type":"proceedings-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/A5057767289","display_name":"Andreas B\u00fchmann","orcid":null},"institutions":[{"id":"https://openalex.org/I153267046","display_name":"University of Kaiserslautern","ror":"https://ror.org/04zrf7b53","country_code":"DE","type":"education","lineage":["https://openalex.org/I153267046"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Andreas Buhmann","raw_affiliation_strings":["Databases and Information Systems, Department of Computer Science, University of Kaiserslautern, Kaiserslautern, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Databases and Information Systems, Department of Computer Science, University of Kaiserslautern, Kaiserslautern, Germany","institution_ids":["https://openalex.org/I153267046"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5111539183","display_name":"Joachim Klein","orcid":null},"institutions":[{"id":"https://openalex.org/I153267046","display_name":"University of Kaiserslautern","ror":"https://ror.org/04zrf7b53","country_code":"DE","type":"education","lineage":["https://openalex.org/I153267046"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Joachim Klein","raw_affiliation_strings":["Databases and Information Systems, Department of Computer Science, University of Kaiserslautern, Kaiserslautern, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Databases and Information Systems, Department of Computer Science, University of Kaiserslautern, Kaiserslautern, Germany","institution_ids":["https://openalex.org/I153267046"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.44450456,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"290","last_page":"295"},"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.9832000136375427,"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.9832000136375427,"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.955299973487854,"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/T12761","display_name":"Data Stream Mining Techniques","score":0.9469000101089478,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.8856911659240723},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.8129332065582275},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6035966873168945},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6000567674636841},{"id":"https://openalex.org/keywords/constraint","display_name":"Constraint (computer-aided design)","score":0.5858230590820312},{"id":"https://openalex.org/keywords/cache-algorithms","display_name":"Cache algorithms","score":0.5662773847579956},{"id":"https://openalex.org/keywords/middleware","display_name":"Middleware (distributed applications)","score":0.5552656650543213},{"id":"https://openalex.org/keywords/cache-invalidation","display_name":"Cache invalidation","score":0.49942779541015625},{"id":"https://openalex.org/keywords/database-tuning","display_name":"Database tuning","score":0.4173470735549927},{"id":"https://openalex.org/keywords/cpu-cache","display_name":"CPU cache","score":0.3210066854953766},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.3178969621658325},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.29569724202156067},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.21183958649635315}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8856911659240723},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.8129332065582275},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6035966873168945},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6000567674636841},{"id":"https://openalex.org/C2776036281","wikidata":"https://www.wikidata.org/wiki/Q48769818","display_name":"Constraint (computer-aided design)","level":2,"score":0.5858230590820312},{"id":"https://openalex.org/C38556500","wikidata":"https://www.wikidata.org/wiki/Q13404475","display_name":"Cache algorithms","level":4,"score":0.5662773847579956},{"id":"https://openalex.org/C169468491","wikidata":"https://www.wikidata.org/wiki/Q146923","display_name":"Middleware (distributed applications)","level":2,"score":0.5552656650543213},{"id":"https://openalex.org/C25536678","wikidata":"https://www.wikidata.org/wiki/Q5015977","display_name":"Cache invalidation","level":5,"score":0.49942779541015625},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.4173470735549927},{"id":"https://openalex.org/C189783530","wikidata":"https://www.wikidata.org/wiki/Q352090","display_name":"CPU cache","level":3,"score":0.3210066854953766},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.3178969621658325},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.29569724202156067},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.21183958649635315},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/ideas.2007.4318117","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ideas.2007.4318117","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"11th International Database Engineering and Applications Symposium (IDEAS 2007)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":3,"referenced_works":["https://openalex.org/W1485782945","https://openalex.org/W1575318767","https://openalex.org/W1585730347"],"related_works":["https://openalex.org/W2350993697","https://openalex.org/W2363769136","https://openalex.org/W2098406302","https://openalex.org/W2734782074","https://openalex.org/W3085471909","https://openalex.org/W2046128376","https://openalex.org/W2109715593","https://openalex.org/W2086718556","https://openalex.org/W1860107648","https://openalex.org/W2088918039"],"abstract_inverted_index":{"Constraint-based":[0],"database":[1,14],"caching":[2],"aims":[3],"at":[4,45],"correctly":[5],"answering":[6],"SQL":[7],"query":[8,80],"predicates":[9],"from":[10,31],"a":[11,32,59,95,105],"local":[12],"cache":[13,53,83],"by":[15],"exploiting":[16],"constraints":[17],"that":[18],"have":[19,93],"previously":[20],"been":[21],"used":[22],"in":[23,43,58],"selecting":[24],"sets":[25],"of":[26,48,64,107],"records":[27],"to":[28],"be":[29],"cached":[30],"remote":[33],"database.":[34],"In":[35],"this":[36],"paper,":[37],"we":[38,92],"take":[39],"our":[40,49,68,108],"first":[41,109],"steps":[42],"looking":[44],"performance":[46],"aspects":[47],"prototype":[50],"adaptive":[51],"constraint-based":[52],"(ACCache),":[54],"which":[55],"is":[56,74],"realized":[57],"middleware":[60],"manner":[61],"on":[62,75,98],"top":[63],"regular":[65],"databases.":[66],"Within":[67],"measurement":[69,110],"setup,":[70],"the":[71,99],"initial":[72],"focus":[73],"two":[76],"central":[77],"ACCache":[78],"functions:":[79],"processing":[81],"and":[82,90],"loading.":[84],"To":[85],"demonstrate":[86],"their":[87],"time":[88],"behavior":[89],"interaction,":[91],"chosen":[94],"scenario":[96],"based":[97],"TPC-W":[100],"specification.":[101],"We":[102],"conclude":[103],"with":[104],"discussion":[106],"results.":[111]},"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}