AutonomousDB: A Tool for Autonomic Propagation of Schema Updates in Heterogeneous Multi-database Environments

Arlei Calazans Moraes, A. Salgado, Patrícia C. A. R. Tedesco
{"title":"AutonomousDB: A Tool for Autonomic Propagation of Schema Updates in Heterogeneous Multi-database Environments","authors":"Arlei Calazans Moraes, A. Salgado, Patrícia C. A. R. Tedesco","doi":"10.1109/ICAS.2009.14","DOIUrl":null,"url":null,"abstract":"One of the biggest challenges of building and maintaining applications with long life cycles, is dealing with the inevitable changes in requirements that occur over time. Many of these applications depend on DBMS that most often suffer direct consequences in their schemas due to changes in the reality that they model. In this work, we propose a new alternative to the issue of schema evolution in multi-database environments, which uses concepts of Autonomic Computing in DBMS to propagate updates in schemas replicated within the same environment, thus ensuring their consistency. Our prototype counts with a Multi-Agent System, which executes events for updating schemas in the target DBMS, which may be of different platforms. Repetitive tasks which are performed in different databases to ensure the evolution of replicated schemas are thus eliminated, freeing the DBA to do other tasks that are more important, such as analysis, database design and strategic management of data.","PeriodicalId":258907,"journal":{"name":"2009 Fifth International Conference on Autonomic and Autonomous Systems","volume":"41 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2009-04-20","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"6","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"2009 Fifth International Conference on Autonomic and Autonomous Systems","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICAS.2009.14","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 6

Abstract

One of the biggest challenges of building and maintaining applications with long life cycles, is dealing with the inevitable changes in requirements that occur over time. Many of these applications depend on DBMS that most often suffer direct consequences in their schemas due to changes in the reality that they model. In this work, we propose a new alternative to the issue of schema evolution in multi-database environments, which uses concepts of Autonomic Computing in DBMS to propagate updates in schemas replicated within the same environment, thus ensuring their consistency. Our prototype counts with a Multi-Agent System, which executes events for updating schemas in the target DBMS, which may be of different platforms. Repetitive tasks which are performed in different databases to ensure the evolution of replicated schemas are thus eliminated, freeing the DBA to do other tasks that are more important, such as analysis, database design and strategic management of data.
AutonomousDB:异构多数据库环境中模式更新的自主传播工具
构建和维护具有长生命周期的应用程序的最大挑战之一是处理随着时间的推移而发生的不可避免的需求变化。这些应用程序中的许多都依赖于DBMS,由于它们所建模的现实发生了变化,它们的模式往往会受到直接影响。在这项工作中,我们提出了一种新的替代方案来解决多数据库环境中的模式演变问题,它使用DBMS中的自主计算概念来传播在同一环境中复制的模式中的更新,从而确保它们的一致性。我们的原型是一个多代理系统(Multi-Agent System),它执行事件来更新目标DBMS中的模式,目标DBMS可能是不同的平台。因此,消除了在不同数据库中执行的重复性任务,从而使DBA能够执行其他更重要的任务,例如分析、数据库设计和数据的战略管理。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
求助全文
约1分钟内获得全文 求助全文
来源期刊
自引率
0.00%
发文量
0
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
确定
请完成安全验证×
copy
已复制链接
快去分享给好友吧!
我知道了
右上角分享
点击右上角分享
0
联系我们:info@booksci.cn Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。 Copyright © 2023 布克学术 All rights reserved.
京ICP备2023020795号-1
ghs 京公网安备 11010802042870号
Book学术文献互助
Book学术文献互助群
群 号:604180095
Book学术官方微信