AUTOMATING SUPPORT FOR REFACTORING SQL DATABASES

被引：0
|
作者：
Nummenmaa, Jyrki [1 ]
Seppi, Ari [1 ]
Thanisch, Peter [1 ]
机构：
[1] Univ Tampere, Dept Comp Sci, Tampere 33014, Finland
来源：
INFORMATION TECHNOLOGIES' 2010 | 2010年
关键词：
SQL databases; database maintenance; database refactoring; database evolution; SCHEMA EVOLUTION; MODEL;
D O I：
暂无
中图分类号：
TP [自动化技术、计算机技术];
学科分类号：
0812 ;
摘要：
We present a method to automate at least partly the operations needed to refactor an SQL database in the case where a new schema is designed for an existing SQL database that contains data. We base our database refactoring method on intuitive database design operations, such as normalize and denormalize.
引用
收藏
页码：343 / 349
页数：7
相关论文
共 50 条
  • [1] sql-schema-comparer: Support of Multi-Language Refactoring with Relational Databases
    Schink, Hagen
    2013 IEEE 13TH INTERNATIONAL WORKING CONFERENCE ON SOURCE CODE ANALYSIS AND MANIPULATION (SCAM), 2013, : 173 - 178
  • [2] Experimental Validation as Support in the Migration from SQL Databases to NoSQL Databases
    Gomez, Abraham
    Ouanouki, Rafik
    Ravanello, Anderson
    April, Alain
    Abran, Alain
    CLOUD COMPUTING 2015: THE SIXTH INTERNATIONAL CONFERENCE ON CLOUD COMPUTING, GRIDS, AND VIRTUALIZATION, 2015, : 147 - 153
  • [3] An extension of SQL to support ordered domains in relational databases
    Ng, W
    Levene, M
    IDEAS '97 - INTERNATIONAL DATABASE ENGINEERING AND APPLICATIONS SYMPOSIUM, PROCEEDINGS, 1997, : 358 - 367
  • [4] Automating Source Code Refactoring in the Classroom
    AlOmar, Eman Abdullah
    Mkaouer, Mohamed Wiem
    Ouni, Ali
    PROCEEDINGS OF THE 55TH ACM TECHNICAL SYMPOSIUM ON COMPUTER SCIENCE EDUCATION, SIGCSE 2024, VOL. 1, 2024, : 60 - 66
  • [5] Verification supported refactoring of embedded sql
    Mirko Spasić
    Milena Vujošević Janičić
    Software Quality Journal, 2021, 29 : 629 - 665
  • [6] Refactoring Rules for Graph Databases
    Fonseca, Adriane M.
    Camolesi, Luiz, Jr.
    NEW CONTRIBUTIONS IN INFORMATION SYSTEMS AND TECHNOLOGIES, VOL 1, PT 1, 2015, 353 : 33 - 42
  • [7] Automating object-oriented software refactoring
    Shankar, S
    Xu, XW
    SERP'03: PROCEEDINGS OF THE INTERNATIONAL CONFERENCE ON SOFTWARE ENGINEERING RESEARCH AND PRACTICE, VOLS 1 AND 2, 2003, : 561 - 567
  • [8] Databases, tuples, and SQL
    Kabachinski, Jeff
    Biomedical Instrumentation and Technology, 2008, 42 (05): : 385 - 387
  • [9] MULTIUSER DATABASES - THE SQL
    FINKELSTEIN, R
    BYTE, 1990, 15 (05): : 136 - &
  • [10] SQL Antipatterns Detection and Database Refactoring Process
    Khumnin, Poonyanuch
    Senivongse, Twittie
    2017 18TH IEEE/ACIS INTERNATIONAL CONFERENCE ON SOFTWARE ENGINEERING, ARTIFICIAL INTELLIGENCE, NETWORKING AND PARALLEL/DISTRIBUTED COMPUTING (SNDP 2017), 2017, : 199 - 205
12345