{"id":"https://openalex.org/W15490652","doi":null,"title":"The use of controlled redundancy in self-adaptive databases (temporaries, derived, packrat, r-tree, texture analysis)","display_name":"The use of controlled redundancy in self-adaptive databases (temporaries, derived, packrat, r-tree, texture analysis)","alternate_titles":[],"publication_year":1985,"publication_date":"1985-01-01","ids":{"openalex":"https://openalex.org/W15490652","mag":"15490652"},"language":"en","primary_location":{"id":"mag:15490652","doi":null,"is_oa":false,"landing_page_url":"https://dl.acm.org/citation.cfm?id=912304","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W15490652"],"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/A5032879661","display_name":"Nabil N. Kamel","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Nabil Kamel","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5032879661"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":3,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.0031679,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"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.9926999807357788,"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.9926999807357788,"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.004900000058114529,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.000699999975040555,"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/query-optimization","display_name":"query optimization","score":0.6209999918937683},{"id":"https://openalex.org/keywords/temporary-tables","display_name":"temporary tables","score":0.6349999904632568},{"id":"https://openalex.org/keywords/texture-analysis","display_name":"texture analysis","score":0.6819999814033508},{"id":"https://openalex.org/keywords/r-tree","display_name":"R-tree","score":0.5289999842643738},{"id":"https://openalex.org/keywords/nonparametric-models","display_name":"nonparametric models","score":0.824999988079071}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7976411581039429},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.6847172975540161},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6806485652923584},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.6432977914810181},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5836281776428223},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5195103883743286},{"id":"https://openalex.org/C152124472","wikidata":"https://www.wikidata.org/wiki/Q1204361","display_name":"Redundancy (engineering)","level":2,"score":0.47236448526382446},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.44001874327659607},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.42442435026168823},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3965194821357727},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.339627206325531},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.323861300945282},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.28996333479881287},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.15721797943115234},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.10051605105400085},{"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}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:15490652","doi":null,"is_oa":false,"landing_page_url":"https://dl.acm.org/citation.cfm?id=912304","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"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":0,"referenced_works":[],"related_works":["https://openalex.org/W2035825860","https://openalex.org/W2049598517","https://openalex.org/W3005908620","https://openalex.org/W7057079396","https://openalex.org/W2405257121","https://openalex.org/W167514490","https://openalex.org/W7096613348","https://openalex.org/W583918304","https://openalex.org/W2765887639","https://openalex.org/W180697668"],"abstract_inverted_index":{"This":[0,90],"thesis":[1,55],"investigates":[2],"a":[3,11,73,138,225,234,245,275,283,287],"new":[4],"approach":[5,91,107],"for":[6],"multiple":[7],"query":[8,39,95,185,194,227],"optimization":[9],"in":[10,37,42,72,97,104,150,164],"centralized":[12],"database.":[13],"Given":[14],"an":[15,217],"arbitrary":[16],"sequence":[17],"of":[18,45,60,81,128,140,219,222,248,257,277,285],"queries,":[19],"it":[20,271],"is":[21,70,112,143,228,238,242,272],"shown":[22],"that":[23,98,274],"significant":[24],"performance":[25],"improvements":[26],"can":[27],"be":[28,171,280],"obtained":[29,281],"by":[30,76],"considering":[31],"the":[32,38,43,57,64,79,82,86,99,115,126,129,147,151,165,167,183,187,193,202,207,210,214,220,249,255,266],"special":[33],"statistical":[34],"patterns":[35],"inherent":[36],"stream":[40],"and":[41,122,198,252],"distribution":[44,236],"data.":[46],"In":[47,136,173],"order":[48],"to":[49,84,109,113,120,123,145,254,265],"realize":[50],"these":[51],"potential":[52],"improvements,":[53],"this":[54,278],"addresses":[56],"optimal":[58],"management":[59],"redundant":[61],"temporaries,":[62,166],"called":[63],"Derived":[65],"Data":[66],"Base.":[67],"The":[68,106,240],"problem":[69],"approached":[71],"self-adaptive":[74],"fashion":[75],"periodically":[77],"reorganizing":[78],"contents":[80,127],"temporaries":[83,130],"suit":[85],"common":[87],"usage":[88],"patterns.":[89],"differs":[92],"from":[93,186,201,209],"batched":[94],"processing":[96],"queries":[100,157],"are":[101],"not":[102],"known":[103],"advance.":[105],"taken":[108],"handle":[110],"updates":[111],"keep":[114],"main":[116,168,188,203],"database":[117,169,189,204],"always":[118],"up":[119],"date":[121],"optimally":[124],"select":[125,213],"based":[131,243],"on":[132,244],"their":[133],"update":[134],"history.":[135],"addition,":[137],"system":[139],"differential":[141],"files":[142],"kept":[144],"retain":[146],"changes":[148],"made":[149],"temporaries.\r\nIn":[152],"cases":[153],"where":[154],"users":[155],"specify":[156],"whose":[158],"response":[159],"sets":[160],"exist":[161],"only":[162],"partially":[163],"must":[170],"referenced.":[172],"such":[174,232],"cases,":[175],"two":[176,196],"alternative":[177],"access":[178],"paths":[179],"exist:":[180],"(1)":[181],"evaluate":[182,199],"entire":[184],"or":[190],"(2)":[191],"split":[192],"into":[195],"parts":[197],"one":[200],"while":[205],"retrieving":[206],"other":[208],"temporaries.":[211],"To":[212,230],"best":[215],"alternative,":[216],"estimate":[218],"number":[221],"tuples":[223],"satisfying":[224],"given":[226],"needed.":[229],"obtain":[231],"estimates,":[233],"data":[235,250,269],"model":[237,241],"proposed.":[239],"discrete":[246,288],"approximation":[247],"space":[251,279],"belongs":[253],"class":[256],"nonparametric":[258],"models.":[259],"Using":[260],"texture":[261],"analysis":[262],"techniques":[263],"applied":[264],"multi":[267],"dimensional":[268],"space,":[270],"proposed":[273],"segmentation":[276],"as":[282],"means":[284],"obtaining":[286],"approximation.":[289]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W15490652","counts_by_year":[],"updated_date":"2026-09-22T06:50:58.402377","created_date":"2016-06-24T00:00:00"}
