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

Data access component and data access method

A data access and component technology, applied in the direction of electronic digital data processing, special data processing applications, digital data information retrieval, etc., can solve the problems of accessing data, cumbersome, difficult to unify models, etc., to ensure multiple storage of data, guarantee The effect of access performance

Pending Publication Date: 2021-04-06
NARI INFORMATION & COMM TECH
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] 1) In a traditional data system, the same data is often stored in the same medium, and the IO operations are aimed at the same storage medium, which may easily cause IO performance bottlenecks and deadlocks; in addition, some systems use the method of data replication and distributed storage. However, there is often a lack of means to maintain data consistency or unreliable data replication procedures;
[0004] 2) Traditional data access components need to use different data access methods for different storage media. Even some data frameworks that use ORM technology are difficult to use a unified model to access data in different storage media. Especially for the "relationship" in the logical model, there has been no unified description;
[0005] 3) On the issue of improving query performance, a layer of memory database is usually added as a cache between the application and the database, which is relatively cumbersome; when developing, it is necessary to take into account the addition, deletion, modification, and data consistency of the cache library and database data. relatively heavy workload

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
  • Data access component and data access method
  • Data access component and data access method
  • Data access component and data access method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0032]The inventive concept of the present invention is: first support multi-diversity storage, namely, access to multiple relational databases, NOSQL databases; then query the content, automatic route to the highest efficiency, and improve query performance. This can not only meet the demand for diverse query, but also guarantee high query efficiency.

[0033]Based on the above technical solution, the present invention is based on the data access component design method of data multi-divers storage and automatic query routing, including the following steps:

[0034]The first step, support multi-store, meet data diversification storage

[0035]The present invention adopts a plurality of database combinations to store data, implementing data multi-element storage, and the databases employed in this embodiment are: Oracle, MySQL, MongoDB, HBase, Elastic Search, and GemFire ​​databases one or more combinations. These different databases can store suitable data according to their different featu...

Embodiment 2

[0040](1) Support for the specific implementation of multi-storage

[0041]Divided specific implementation architecturefigure 1 As shown, a unified data access interface is provided, and the data access interface is connected to the model adapter corresponding to each database through the model mapping component. By using model mapping, adapter mode, unified data access interface (ie, unified query language), access to multiple data is supported: Oracle, MySQL, MongoDB, HBase, Elastic Search, Gemfire.

[0042]For different business scenarios, one or more data storage methods can be selected for the software system. For example, the memory database is selected for hotspot data, which uses a column library for massive data, and uses a full-text index for the data that requires fuzzy query. By querying the component, you can implement the data automatic query arranging optimization, IO threshold control, a multi-write, read and write separation, such asfigure 2 Indicated.

[0043](2) Detailed i...

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 data access component. The data access component comprises a data access interface, a model mapping component, model adapters and a query and command arrangement component, the model mapping component is used for connecting the data access interface and each model adapter; the model adapters are used for directly operating the databases connected with the model adapters, and the model adapters are in one-to-one correspondence with the various databases; and the query and command arrangement component is used for analyzing the query statements and automatically routing the query statements to the database with the highest efficiency for query operation. According to the data access component, multi-element storage and multi-element access of data can be guaranteed, and certain access performance can be guaranteed through automatic routing.

Description

Technical field[0001]The present invention belongs to the DAO data access technology, and in particular to a data access component, further involves a data access method of a data access component.Background technique[0002]In the software system, there may be a variety of data query requirements, such as the pursuit of high-performance queries, structural data queries, non-structured data queries, fuzzy queries, etc., and ensure certain query performance. But the current industry has data access components, there is the following questions:[0003]1) In the traditional data system, the same data is often stored in the same medium, and the IO operation is for the same storage medium, which is easy to cause IO performance bottlenecks and deadlocks; some other systems use data copy distribution storage means, actual operation There are often means of maintaining data consistency or unreliable data replication;[0004]2) Traditional data access components require different data access metho...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/242G06F16/2453G06F16/2455
CPCG06F16/24553G06F16/2453G06F16/2445
Inventor 卢飒汪明贵陈高峰
Owner NARI INFORMATION & COMM TECH
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