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

Automatic transformation of non-relational database into relational database

Info

Publication number
MY166591A
MY166591A MYPI2012005266A MYPI2012005266A MY166591A MY 166591 A MY166591 A MY 166591A MY PI2012005266 A MYPI2012005266 A MY PI2012005266A MY PI2012005266 A MYPI2012005266 A MY PI2012005266A MY 166591 A MY166591 A MY 166591A
Authority
MY
Malaysia
Prior art keywords
database
data
relational database
relationship
present
Prior art date
Application number
MYPI2012005266A
Inventor
Haszeli 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
Priority to MYPI2012005266A priority Critical patent/MY166591A/en
Priority to PCT/MY2013/000216 priority patent/WO2014088396A2/en
Publication of MY166591A publication Critical patent/MY166591A/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

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Automatic Analysis And Handling Materials Therefor (AREA)

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
MYPI2012005266A 2012-12-05 2012-12-05 Automatic transformation of non-relational database into relational database MY166591A (en)

Priority Applications (2)

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

Applications Claiming Priority (1)

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

Publications (1)

Publication Number Publication Date
MY166591A true MY166591A (en) 2018-07-17

Family

ID=50029181

Family Applications (1)

Application Number Title Priority Date Filing Date
MYPI2012005266A MY166591A (en) 2012-12-05 2012-12-05 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

Family Cites Families (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

Also Published As

Publication number Publication date
WO2014088396A3 (en) 2014-07-24
WO2014088396A2 (en) 2014-06-12

Similar Documents

Publication Publication Date Title
MY189945A (en) Statistical analytic method for the determination of the risk posed by file based content
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
WO2011035298A3 (en) Methods and apparatus to perform choice modeling with substitutability data
GB2472358A (en) Database system and methods
WO2010119261A8 (en) Method for quantifying modified peptides
WO2014088396A3 (en) Automatic transformation of non-relational database into relational database
EA201290473A1 (en) SYSTEM AND METHOD OF ANALYSIS OF LACUNARITY
GB201207374D0 (en) Method and apparatus for design of pipeline components
MX2014010645A (en) Communication simulating system, communication simulating method, and vehicle communication apparatus.
MX2019004540A (en) Validation of continuous viral clearance.
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
MX2016004547A (en) Disease-screening method, module and computer program, using samples taken from an individual.
WO2014124553A8 (en) Chinese character input method
WO2008100383A3 (en) Method and system for facilitating analysis audience ratings data for content
WO2014130790A8 (en) Supplier analysis and verification system and method
GB201022108D0 (en) Method for extracting database source code and metadata to files and importing source code and metadata from files into target databases
Di Martino et al. ICP-MS analysis for the characterization of the origins of wines
GB2503631A (en) Method for analysing sward
TW200636508A (en) Effectiveness inspection and defense system for patent infringement analysis
Bontempo et al. Stable isotope analysis of amino acids: a new tool for food authentication
Nimis Some remarks on the use of geochemical tracers for metal provenancing
조성구 et al. A Study on Introduction to Private Investigation System and Direction Through Predicting Demand
Klump et al. Synthetic geology-Exploring the" what if?" in geology