{"id":"https://openalex.org/W2118130633","doi":"https://doi.org/10.1109/icdew.2007.4401024","title":"SQL Anywhere: A Holistic Approach to Database Self-management","display_name":"SQL Anywhere: A Holistic Approach to Database Self-management","publication_year":2007,"publication_date":"2007-04-01","ids":{"openalex":"https://openalex.org/W2118130633","doi":"https://doi.org/10.1109/icdew.2007.4401024","mag":"2118130633"},"language":"en","primary_location":{"id":"doi:10.1109/icdew.2007.4401024","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icdew.2007.4401024","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2007 IEEE 23rd International Conference on Data Engineering Workshop","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/A5045682192","display_name":"Ivan T. Bowman","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Ivan T. Bowman","raw_affiliation_strings":["Sybase iAnywhere, Waterloo, ONT, Canada","Sybase iAnywhere, Waterloo"],"affiliations":[{"raw_affiliation_string":"Sybase iAnywhere, Waterloo, ONT, Canada","institution_ids":[]},{"raw_affiliation_string":"Sybase iAnywhere, Waterloo","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5054465387","display_name":"Peter Bumbulis","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Peter Bumbulis","raw_affiliation_strings":["Sybase iAnywhere, Waterloo, ONT, Canada","Sybase iAnywhere, Waterloo"],"affiliations":[{"raw_affiliation_string":"Sybase iAnywhere, Waterloo, ONT, Canada","institution_ids":[]},{"raw_affiliation_string":"Sybase iAnywhere, Waterloo","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5036322632","display_name":"D. A. T. Farrar","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Dan Farrar","raw_affiliation_strings":["Sybase iAnywhere, Waterloo, ONT, Canada","Sybase iAnywhere, Waterloo"],"affiliations":[{"raw_affiliation_string":"Sybase iAnywhere, Waterloo, ONT, Canada","institution_ids":[]},{"raw_affiliation_string":"Sybase iAnywhere, Waterloo","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103358763","display_name":"Anil K. Goel","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Anil K. Goel","raw_affiliation_strings":["Sybase iAnywhere, Waterloo, ONT, Canada","Sybase iAnywhere, Waterloo"],"affiliations":[{"raw_affiliation_string":"Sybase iAnywhere, Waterloo, ONT, Canada","institution_ids":[]},{"raw_affiliation_string":"Sybase iAnywhere, Waterloo","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5082964830","display_name":"Brendan Lucier","orcid":"https://orcid.org/0009-0006-3497-0875"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Brendan Lucier","raw_affiliation_strings":["Sybase iAnywhere, Waterloo, ONT, Canada","Sybase iAnywhere, Waterloo"],"affiliations":[{"raw_affiliation_string":"Sybase iAnywhere, Waterloo, ONT, Canada","institution_ids":[]},{"raw_affiliation_string":"Sybase iAnywhere, Waterloo","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5109865053","display_name":"Anisoara Nica","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Anisoara Nica","raw_affiliation_strings":["Sybase iAnywhere, Waterloo, ONT, Canada","Sybase iAnywhere, Waterloo"],"affiliations":[{"raw_affiliation_string":"Sybase iAnywhere, Waterloo, ONT, Canada","institution_ids":[]},{"raw_affiliation_string":"Sybase iAnywhere, Waterloo","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035798879","display_name":"G. N. Paulley","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"G. N. Paulley","raw_affiliation_strings":["Sybase iAnywhere, Waterloo, ONT, Canada","Sybase iAnywhere, Waterloo"],"affiliations":[{"raw_affiliation_string":"Sybase iAnywhere, Waterloo, ONT, Canada","institution_ids":[]},{"raw_affiliation_string":"Sybase iAnywhere, Waterloo","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5090743856","display_name":"John Smirnios","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"John Smirnios","raw_affiliation_strings":["Sybase iAnywhere, Waterloo, ONT, Canada","Sybase iAnywhere, Waterloo"],"affiliations":[{"raw_affiliation_string":"Sybase iAnywhere, Waterloo, ONT, Canada","institution_ids":[]},{"raw_affiliation_string":"Sybase iAnywhere, Waterloo","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5096840328","display_name":"Matthew Young-Lai","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Matthew Young-Lai","raw_affiliation_strings":["Sybase iAnywhere, Waterloo, ONT, Canada","Sybase iAnywhere, Waterloo"],"affiliations":[{"raw_affiliation_string":"Sybase iAnywhere, Waterloo, ONT, Canada","institution_ids":[]},{"raw_affiliation_string":"Sybase iAnywhere, Waterloo","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":9,"corresponding_author_ids":["https://openalex.org/A5045682192"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.567,"has_fulltext":false,"cited_by_count":18,"citation_normalized_percentile":{"value":0.90452989,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"414","last_page":"423"},"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.9994000196456909,"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.9994000196456909,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9959999918937683,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9952999949455261,"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.814181387424469},{"id":"https://openalex.org/keywords/workgroup","display_name":"Workgroup","score":0.7818102836608887},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.677751898765564},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6720292568206787},{"id":"https://openalex.org/keywords/intranet","display_name":"Intranet","score":0.5745628476142883},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5069596767425537},{"id":"https://openalex.org/keywords/database-server","display_name":"Database server","score":0.4715694785118103},{"id":"https://openalex.org/keywords/data-administration","display_name":"Data administration","score":0.4594508111476898},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.4375265836715698},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.4150567650794983},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.4109261929988861},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.404223769903183},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.2873014807701111},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.22918105125427246},{"id":"https://openalex.org/keywords/the-internet","display_name":"The Internet","score":0.09508955478668213}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.814181387424469},{"id":"https://openalex.org/C95423123","wikidata":"https://www.wikidata.org/wiki/Q622178","display_name":"Workgroup","level":2,"score":0.7818102836608887},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.677751898765564},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6720292568206787},{"id":"https://openalex.org/C2778059363","wikidata":"https://www.wikidata.org/wiki/Q483426","display_name":"Intranet","level":3,"score":0.5745628476142883},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5069596767425537},{"id":"https://openalex.org/C205295232","wikidata":"https://www.wikidata.org/wiki/Q76320","display_name":"Database server","level":2,"score":0.4715694785118103},{"id":"https://openalex.org/C115842085","wikidata":"https://www.wikidata.org/wiki/Q4057846","display_name":"Data administration","level":4,"score":0.4594508111476898},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.4375265836715698},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.4150567650794983},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.4109261929988861},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.404223769903183},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.2873014807701111},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.22918105125427246},{"id":"https://openalex.org/C110875604","wikidata":"https://www.wikidata.org/wiki/Q75","display_name":"The Internet","level":2,"score":0.09508955478668213},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icdew.2007.4401024","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icdew.2007.4401024","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2007 IEEE 23rd International Conference on Data Engineering Workshop","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5799999833106995,"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":28,"referenced_works":["https://openalex.org/W175221152","https://openalex.org/W1501284171","https://openalex.org/W1540926161","https://openalex.org/W1595791361","https://openalex.org/W1602750627","https://openalex.org/W1608665031","https://openalex.org/W1941835599","https://openalex.org/W1952401158","https://openalex.org/W1966080685","https://openalex.org/W1991807219","https://openalex.org/W1996676736","https://openalex.org/W2040892657","https://openalex.org/W2043213682","https://openalex.org/W2062756891","https://openalex.org/W2090804476","https://openalex.org/W2092029745","https://openalex.org/W2143012954","https://openalex.org/W2151310484","https://openalex.org/W2156865988","https://openalex.org/W2169432417","https://openalex.org/W2212047990","https://openalex.org/W2280041935","https://openalex.org/W2287201503","https://openalex.org/W2912450034","https://openalex.org/W4214851671","https://openalex.org/W4252770925","https://openalex.org/W4255671299","https://openalex.org/W6632546856"],"related_works":["https://openalex.org/W1533695319","https://openalex.org/W1945121096","https://openalex.org/W2241065776","https://openalex.org/W3150227232","https://openalex.org/W2913707658","https://openalex.org/W2743447767","https://openalex.org/W1546344245","https://openalex.org/W4387352177","https://openalex.org/W2367006431","https://openalex.org/W2181324746"],"abstract_inverted_index":{"In":[0],"this":[1],"paper":[2],"we":[3],"present":[4],"an":[5,36,44],"overview":[6],"of":[7,11],"the":[8,67,72,78],"self-management":[9,80],"features":[10,81],"SQL":[12,27],"anywhere,":[13],"a":[14,32,48,53,87],"full-function":[15],"relational":[16],"database":[17,38,50,59],"system":[18],"designed":[19],"for":[20],"frontline":[21],"business":[22],"environments":[23],"with":[24,43],"minimal":[25],"administration.":[26],"Anywhere":[28],"can":[29],"serve":[30],"as":[31,47],"high-performance":[33],"workgroup":[34],"server,":[35],"embedded":[37],"that":[39,56],"is":[40,69],"installed":[41,51],"along":[42],"application,":[45],"or":[46],"mobile":[49],"on":[52],"handheld":[54],"device":[55,68],"provides":[57],"full":[58],"services,":[60],"including":[61],"two-way":[62],"synchronization,":[63],"to":[64,85],"applications":[65],"when":[66],"disconnected":[70],"from":[71],"corporate":[73],"intranet.":[74],"We":[75],"illustrate":[76],"how":[77],"various":[79],"work":[82],"in":[83,92],"concert":[84],"provide":[86],"robust":[88],"data":[89],"management":[90],"solution":[91],"zero-administration":[93],"environments.":[94]},"counts_by_year":[{"year":2020,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":3}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}