WO2014088396A3 - Automatic transformation of non-relational database into relational database - Google Patents

Automatic transformation of non-relational database into relational database Download PDF

Info

Publication number
WO2014088396A3
WO2014088396A3 PCT/MY2013/000216 MY2013000216W WO2014088396A3 WO 2014088396 A3 WO2014088396 A3 WO 2014088396A3 MY 2013000216 W MY2013000216 W MY 2013000216W WO 2014088396 A3 WO2014088396 A3 WO 2014088396A3
Authority
WO
WIPO (PCT)
Prior art keywords
database
data
relational database
relationship
present
Prior art date
Application number
PCT/MY2013/000216
Other languages
French (fr)
Other versions
WO2014088396A2 (en
Inventor
Haszeli Bin Ahmad Nurul
Mat Nor FAZLI
M. Krishnamoorty VIGNESWAREN
Original Assignee
Mimos Berhad
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Mimos Berhad filed Critical Mimos Berhad
Publication of WO2014088396A2 publication Critical patent/WO2014088396A2/en
Publication of WO2014088396A3 publication Critical patent/WO2014088396A3/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25—Integrating or interfacing systems involving database management systems
    • G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25—Integrating or interfacing systems involving database management systems
    • G06F16/258—Data format conversion from or to a database

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).
PCT/MY2013/000216 2012-12-05 2013-11-29 Automatic transformation of non-relational database into relational database WO2014088396A2 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
MYPI2012005266 2012-12-05
MYPI2012005266A MY166591A (en) 2012-12-05 2012-12-05 Automatic transformation of non-relational database into relational database

Publications (2)

Publication Number Publication Date
WO2014088396A2 WO2014088396A2 (en) 2014-06-12
WO2014088396A3 true WO2014088396A3 (en) 2014-07-24

Family

ID=50029181

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/MY2013/000216 WO2014088396A2 (en) 2012-12-05 2013-11-29 Automatic transformation of non-relational database into relational database

Country Status (2)

Country Link
MY (1) MY166591A (en)
WO (1) WO2014088396A2 (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105938479B (en) * 2016-03-31 2019-10-22 华南师范大学 A kind of structure conversion method of relation table and non-relation table
CN108664505B (en) * 2017-03-30 2021-08-13 腾讯科技（深圳）有限公司 Method and device for exporting database table structure
CN111506642A (en) * 2020-06-12 2020-08-07 夸克云智科技(深圳)有限公司 Data conversion method based on basic data type

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6631382B1 (en) * 1996-01-02 2003-10-07 Timeline, Inc. Data retrieval method and apparatus with multiple source capability

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6631382B1 (en) * 1996-01-02 2003-10-07 Timeline, Inc. Data retrieval method and apparatus with multiple source capability

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
J-L HAINAUT ET AL: "Transformation-based database reverse engineering", 15 December 1993, PROCEEDINGS OF INTERNATIONAL CONFERENCE ON THE ENTITY-RELATIONSHIP APPROACH, SPRINGER BERLIN HEIDELBERG, BERLIN, HEIDELBERG, PAGE(S) 364 - 375, ISBN: 978-3-540-58217-5, XP047003001 *
WANG J ET AL: "Data Extraction and Label Assignment for Web Databases", INTERNET CITATION, 20 May 2003 (2003-05-20), XP002380361, Retrieved from the Internet <URL:http://www2003.org/cdrom/papers/refereed/p470/p470-wang.htm> [retrieved on 20060503] *

Also Published As

Publication number Publication date
WO2014088396A2 (en) 2014-06-12
MY166591A (en) 2018-07-17

Similar Documents

Publication Publication Date Title
SG11201900470SA (en) Modeling method and device for evaluation model
WO2013180979A3 (en) System and method to generate molecular formula distributions beyond a predetermined threshold for a petroleum stream
WO2013102192A3 (en) Real-time dynamic data validation apparatus, system, program code, computer readable medium, and methods for intelligent fields
WO2008080403A8 (en) Feature-based registration of sectional images
WO2011035298A3 (en) Methods and apparatus to perform choice modeling with substitutability data
MY189945A (en) Statistical analytic method for the determination of the risk posed by file based content
WO2009132263A3 (en) Database systems and methods
WO2010119261A8 (en) Method for quantifying modified peptides
WO2009075554A3 (en) Patent information providing method and system
WO2014088396A3 (en) Automatic transformation of non-relational database into relational database
WO2011145116A3 (en) System and method for sql performance assurance services
WO2009076600A3 (en) System, method and computer-accessible medium for normalizing databases through mixing
WO2014207644A3 (en) Method and system for grading a computer program
WO2014171898A3 (en) Method for generating extended sequence reads
MX343133B (en) Communication simulating system, communication simulating method, and vehicle communication apparatus.
WO2012142467A3 (en) Method and apparatus for reducing chemical reaction mechanisms
WO2009044398A3 (en) A method and computer program for evaluating database queries involving relational and hierarchical data
CN109670192A (en) A kind of component ID batch extracting method based on BIM
WO2012103423A3 (en) Computer-implemented platform for automated fluorescence imaging and kinetic analysis
WO2014130790A8 (en) Supplier analysis and verification system and method
AR125730A1 (en) METHOD FOR THE PRODUCTION OF BLUE AMMONIA
GB201022108D0 (en) Method for extracting database source code and metadata to files and importing source code and metadata from files into target databases
GB201319178D0 (en) Method for analysing sward
ATE518198T1 (en) METHOD, SERVER EXTENSION AND DATABASE MANAGEMENT SYSTEM FOR STORING NON-XML DOCUMENTS IN AN XML DATABASE
Di Martino et al. ICP-MS analysis for the characterization of the origins of wines

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 13824672

Country of ref document: EP

Kind code of ref document: A2

122 Ep: pct application non-entry in european phase

Ref document number: 13824672

Country of ref document: EP

Kind code of ref document: A2