Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method and device for data interaction between non-relation type database and relation type database

A non-relational, database technology, applied in the Internet field, can solve problems such as difficulties, achieve strong novelty and originality, improve practicability and versatility

Active Publication Date: 2014-05-21
TSINGHUA UNIV
View PDF2 Cites 33 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

When data is imported from a non-relational database to a relational database, due to the unstructured characteristics of the non-relational database, the corresponding table structure will be established in the relational database, and the data will be mapped from the non-relational database to the relational database. The table structure is very difficult problem

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for data interaction between non-relation type database and relation type database
  • Method and device for data interaction between non-relation type database and relation type database
  • Method and device for data interaction between non-relation type database and relation type database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] Embodiments of the present invention are described in detail below, examples of which are shown in the drawings, wherein the same or similar reference numerals designate the same or similar elements or elements having the same or similar functions throughout. The embodiments described below by referring to the figures are exemplary and are intended to explain the present invention and should not be construed as limiting the present invention.

[0021] At present, in the existing theoretical achievements, the relational model (Relational model) as a logical model and the entity-relationship model ((Entity-relationship model) as a conceptual model can be used to describe the relational database completely. Usually, An entity-relationship diagram can be used to describe the model of a relational database. The row-column-based table structure and the relationship between tables of a relational database can be represented by a table-relationship diagram. Among them, in the da...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a method and device for data interaction and data structure interaction between a non-relation type database and a relation type database. The method comprises the steps of obtaining a first physical model of a source database, defining data characteristics and query characteristics of the database corresponding to the first physical model, generating an intermediate model according to the first physical model, the data characteristics and the query characteristics, converting the intermediate model into a second physical model of a target database according to preset strategies, the data structure of the intermediate model and the data characteristics and the query characteristics included by the intermediate model, establishing a mapping relation of the first physical model, the intermediate model and the second physical model, and exporting data in the source database into the target database according to the mapping relation. According to the method of the embodiment, the intermediate model is established between the data model of the relation type database and the storage structure of the non-relation type database, and therefore model supporting is provided for carrying out conversion on the storage structure and data between the relation type database and the non-relation type database.

Description

technical field [0001] The invention relates to the technical field of the Internet, in particular to a method and a device for data and data structure interaction between non-relational and relational databases. Background technique [0002] With the rapid development of the Internet, the types and scale of data in the Internet are growing at an alarming rate, and the advent of the era of "big data" has become a reality. At present, due to the performance and scale bottlenecks of traditional relational databases when dealing with the storage, query and analysis of big data, various non-relational databases (NoSQL databases) have emerged as the times require and become data storage and A new force in analytics. [0003] NoSQL is a broad definition of non-relational data storage. It breaks the relationship between relational databases and ACID (an acronym for the four basic elements of the correct execution of database transactions. The four basic elements are: atomicity (At...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30
CPCG06F16/258
Inventor 丁贵广林运祯
Owner TSINGHUA UNIV
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com