{"title":"Reverse Engineering of Relational Database Schema based on Universal Metadata Queries","authors":"Stefan Reljic, D. Brdjanin, G. Banjac","doi":"10.1109/INFOTEH53737.2022.9751287","DOIUrl":null,"url":null,"abstract":"The paper presents an approach to reverse engineering of a relational database schema. The approach enables database schema extraction from the corresponding metadata stored in the data dictionary by executing a universal set of queries regardless of the source database management system. The concrete queries are generated by combining predefined templates with concrete metadata for the particular source system. Based on the proposed approach, we implemented a software tool and experimentally validated it. The implemented solution enables reverse engineering of relational databases managed by several contemporary database management systems.","PeriodicalId":6839,"journal":{"name":"2022 21st International Symposium INFOTEH-JAHORINA (INFOTEH)","volume":"41 1","pages":"1-6"},"PeriodicalIF":0.0000,"publicationDate":"2022-03-16","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"2022 21st International Symposium INFOTEH-JAHORINA (INFOTEH)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/INFOTEH53737.2022.9751287","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0
Abstract
The paper presents an approach to reverse engineering of a relational database schema. The approach enables database schema extraction from the corresponding metadata stored in the data dictionary by executing a universal set of queries regardless of the source database management system. The concrete queries are generated by combining predefined templates with concrete metadata for the particular source system. Based on the proposed approach, we implemented a software tool and experimentally validated it. The implemented solution enables reverse engineering of relational databases managed by several contemporary database management systems.
京公网安备 11010802042870号
京ICP备2023020795号-1
分享
求助内容：
应助结果提醒方式：
扫码关注我们
