頁籤選單縮合
題名 | 定義既存關聯資料庫表格之主鍵與外來鍵=Identifying Primary Keys and Foreign Keys from a Legacy Relational Database System |
---|---|
作者 | 黃其彥; 李宜珍; | 書刊名 | 北商學報 |
卷期 | 12 2007.07[民96.07] |
頁次 | 頁65-79 |
分類號 | 312.49 |
關鍵詞 | 主鍵; 外來鍵; 關聯資料庫; 資料庫反向工程; Primary key; Foreign key; Relational database; Database reverse engineering; |
語文 | 中文(Chinese) |
中文摘要 | 關聯資料庫在組織運行系統多年下來,經常原始的文件已經遺失或與現有的資料結構不一致,因此,為維護和更新資料庫,資料庫反向工程變成一項重要的工作。進行資料庫反向工程時,主鍵與外來鍵的確立是重要的工作之一,當主鍵與外來鍵確立,關聯表間的關係才可以界定。目前,已有學者針對資料庫反向工程中擷取主鍵與外來鍵提出一套明確的方法,但其方法主要以屬性排列組合的方式判定其是否符合主鍵、外來鍵的特質,所以需大量的時間。本文提出一改善的方法,此方法在於只針對單一鍵值作判斷,利用它的包含關係,便可快速的澄清出主鍵與外來鍵,本方法的提出,在資料庫反向工程中可大量減低判定主鍵、外來鍵的時間,使資料庫反向工程執行效率加快。 |
英文摘要 | The document of the legacy relational database system in an organization sometimes may be different from its structure or lost after years of tuning and maintenance. Hence, for further operation, the database reverse engineering becomes important. It is an important step for identifying primary keys and foreign keys in the database reverse engineering process. After the primary keys and foreign keys were established, the relationships of the tables thus can be obtained. The state-of-the-art method for solving the problem is the powerset methods. It needs a lot of time. The paper presents a novel method for solving the problem with better performance. In the methods, the primary keys and foreign keys are found by comparing the distinct sets of different single attributes without that of the compound attributes. It was found that the computation overhead becomes relatively low. The method can be adapted for the proposed database reverse engineering methods for improving their performance. |
本系統之摘要資訊系依該期刊論文摘要之資訊為主。