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

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

Example Embodiment

[0020] The embodiments of the present invention will be described in detail below. Examples of the embodiments are shown in the accompanying drawings, wherein the same or similar reference numerals indicate the same or similar elements or elements with the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary, and are intended to explain the present invention, but should not be construed as limiting the present invention.

[0021] At present, among the existing theoretical results, the existing relational model (Relational model) for relational databases as the logical model and the entity-relationship model (Entity-relationship model) as the conceptual model can be fully described. Generally, An entity-relationship diagram can be used to describe the model of a relational database. The row-column based table structure of a relational database and the relationship between tables can be represented by a table relationsh...

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 Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap