公开(公告)号：MY166591A

公开(公告)日：2018-07-17

申请号：MYPI2012005266

申请日：2012-12-05

Applicant: MIMOS BERHAD

Inventor： NURUL HASZELI AHMAD ,  FAZLI MAT NOR ,  VIGNESWAREN M KRISHNAMOORTY

IPC: G06F17/30

Abstract: THE SYSTEM AND METHOD OF THE PRESENT INVENTION PROVIDES FOR AUTOMATIC TRANSFORMATION OF NON-RELATIONAL DATABASE INTO RELATIONAL DATABASE THAT IS SELF-RELIANT. THE SYSTEM OF THE PRESENT INVENTION COMPRISING AT LEAST ONE DATA ANALYZER (102); AT LEAST ONE RELATIONSHIP BUILDER (104); AND AT LEAST ONE DATA TRANSFORMER (106) FOR AUTOMATICALLY TRANSFORMING NON-RELATIONAL DATABASE INTO RELATIONAL DATABASE. EXECUTION OF THE PRESENT INVENTION BEGINS WITH THE DATA ANALYZER (102) WHEREIN THE AT LEAST ONE DATA ANALYZER (102) IS CALLED TO PERFORM DATABASE ANALYSIS TO PRODUCE DRAFT OF DATABASE STRUCTURE. THEREAFTER, THE OTHER COMPONENT OF THE SYSTEM; THE RELATIONSHIP BUILDER (104) CONFINE THE DATABASE STRUCTURE AND CONVERT THE DRAFT DATABASE STRUCTURE TO A CONFIRM STRUCTURE. UPON CONFIRMATION OF THE DATABASE STRUCTURE, DATA TRANSFORMER (106) WILL AUTOMATICALLY TRANSFORM AND REALIZE THE STRUCTURES AND THEREAFTER EXPORT DATA FROM SOURCE TO TARGET. IN SHORT, THE METHODOLOGY OF THE PRESENT INVENTION COMPRISING STEPS OF INITIALIZING CONFIGURATION OF TRANSFORMATION PROCESS (202); ANALYZING NON-RELATIONAL DATABASE AND DATA STRUCTURE TO FORM DATABASE TREE (204); IDENTIFYING RELATIONSHIP AND KEY AND FURTHER ASSOCIATING IT WITH DATABASE TREE TO FORM DRAFT DATABASE STRUCTURE (206); EVALUATING RELATIONSHIP BINDING TO PRODUCE CONFINE DATABASE STRUCTURE (208); CREATING DATABASE BY CONSTRUCTING DATABASE, TABLES AND RELATIONSHIP INTO RELATIONAL DATABASE (210); AND PERFORMING DATA INSERTION WITH KEY IDENTIFICATION AND VALID DATA FORMAT FOR DATABASE TRANSFORMATION (212). THE MOST ILLUSTRATIVE DRAWING IS

公开(公告)号：WO2014088396A3

公开(公告)日：2014-07-24

申请号：PCT/MY2013000216

申请日：2013-11-29

Applicant: MIMOS BERHAD

Inventor： NURUL HASZELI BIN AHMAD ,  FAZLI MAT NOR ,  VIGNESWAREN M KRISHNAMOORTY

IPC: G06F17/30

CPC classification number: G06F17/30563 ,  G06F17/30569

Abstract: The system and method of the present invention provides for automatic transformation of non-relational database into relational database that is self-reliant. The system of the present invention comprising at least one data analyzer (102); at least one relationship builder (104); and at least one data transformer (106) for automatically transforming non-relational database into relational database. Execution of the present invention begins with the data analyzer (102) wherein the at least one data analyzer (102) is called to perform database analysis to produce draft of database structure. Thereafter, the other component of the system; the relationship builder (104) confine the database structure and convert the draft database structure to a confirm structure. Upon confirmation of the database structure, data transformer (106) will automatically transform and realize the structures and thereafter export data from source to target. In short, the methodology of the present invention comprising steps of initializing configuration of transformation process (202); analyzing non-relational database and data structure to form database tree (204); identifying relationship and key and further associating it with database tree to form draft database structure (206); evaluating relationship binding to produce confine database structure (208); creating database by constructing database, tables and relationship into relational database (210); and performing data insertion with key identification and valid data format for database transformation (212).

Abstract translation: 本发明的系统和方法提供了将非关系数据库自动转换为自力更生的关系数据库。 本发明的系统包括至少一个数据分析器（102）; 至少一个关系建立器（104）; 和至少一个用于自动将非关系数据库转换为关系数据库的数据转换器（106）。 本发明的执行始于数据分析器（102），其中调用至少一个数据分析器（102）来执行数据库分析以产生数据库结构的草案。 此后，系统的另一部分; 关系构建器（104）限制数据库结构并将草稿数据库结构转换为确认结构。 在确认数据库结构后，数据转换器（106）将自动转换并实现结构，然后将数据从源导出到目标。 简而言之，本发明的方法包括步骤：初始化转换过程（202）的配置; 分析非关系数据库和数据结构以形成数据库树（204）; 识别关系和密钥，并进一步将其与数据库树相关联以形成草案数据库结构（206）; 评估关系绑定以产生限制数据库结构（208）; 通过将数据库，表格和关系构建到关系数据库中来创建数据库（210）; 并用数据库变换的密钥标识和有效数据格式执行数据插入（212）。