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

Relational database unified data access middleware method and system

A data access and database technology, applied in the field of computer applications, can solve problems such as large workloads

Active Publication Date: 2021-01-05
HOHAI UNIV
View PDF3 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At present, there are many frameworks for relational database data access and persistence. Commonly used are SpringHibernate, Mybatis, JPA, EJB, etc. These frameworks require users to develop a lot of code and require a lot of work.

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
  • Relational database unified data access middleware method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0075] Embodiment 1: as figure 1 As shown, the relational database unified data access middleware method includes:

[0076] Step SS1: The JavaBean object expresses the relevant metadata through the java annotation provided by the unified data access middleware UnifyDataAccess;

[0077] Step SS2: a data object acquisition step;

[0078] Step SS3: batch object persistence step;

[0079] Step SS4: a SQL statement execution step.

[0080] Optionally, the metadata in step SS1 specifically includes:

[0081] Object level metadata @UnifyAccessDataset and attribute metadata @Persistent, @Prompt,

[0082] @Referrence, @RefCondition;

[0083] @UnifyAccessDataset annotation: describes the relationship between the entire java object and the relational database dataset. This annotation expresses the data source, the corresponding main database table, the basic SQL statement of the dataset, whether there is a where condition in SQL, and the object description; the specific format is as...

Embodiment 2

[0110] Embodiment 2: the present invention also proposes a relational database unified data access middleware system, including:

[0111] The metadata expression module is used for execution: the JavaBean object expresses the relevant metadata through the java annotation provided by the unified data access middleware UnifyDataAccess;

[0112] A data object acquisition module, configured to: acquire a data object;

[0113] A batch object persistence module, configured to: add the data objects in batches to the database;

[0114] The SQL statement execution module is used to execute: execute the SQL statement.

[0115] Optionally, the metadata expression module specifically includes: object-level metadata @UnifyAccessDataset and attribute metadata @Persistent, @Prompt, @Referrence, @RefCondition;

[0116] The @UnifyAccessDataset annotation: describes the relationship between the entire java object and the relational database dataset. This annotation expresses the data source, ...

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 relational database unified data access middleware method and system, and the method comprises the steps: SS1, enabling a JavaBean object to express related metadata througha java annotation provided by unified data access middleware Uniform; SS2, a data object acquisition step; SS3, a batch object persistence step; and SS4, executing the SQL statement. According to theinvention, conversion from a simple object to a complex object and conversion from a relationship to an object can be realized by the main detail object, and batch acquisition can be realized when thedata volume is relatively large; when the data volume is small, all the data can be obtained at a time; and relation conversion from a simple object to a complex object and from a main detail objectto a database can be completed, and data persistence of various objects is achieved. By configuring a support object in a Redis memory database cache, the consistency of the cache and a relationship library is automatically maintained when the object is persistent.

Description

technical field [0001] The invention relates to a middleware method and system for unified data access of a relational database, belonging to the technical field of computer applications. Background technique [0002] The access and persistence of relational database data is the core content of application system software development, an important part of application program development, and an important layer in hierarchical application software. In the development of large-scale application software, a dedicated team needs to be organized. At present, there are many frameworks for relational database data access and persistence. Commonly used are SpringHibernate, Mybatis, JPA, EJB, etc. These frameworks require users to develop a large amount of code and require a lot of work. The existing unified data access middleware (UnifyDataAccess) is a middleware that completes relational database data access and persistence, and supports Redis memory database cache. Complete the O...

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/23G06F16/242G06F16/2455G06F16/28
CPCG06F16/2365G06F16/2433G06F16/24552G06F16/284
Inventor 梁正和赵旭杰
Owner HOHAI 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