{"title":"基于通用元数据查询的关系数据库模式逆向工程","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":"{\"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}","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}
Reverse Engineering of Relational Database Schema based on Universal Metadata Queries
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号
