Supercharge Your Innovation With Domain-Expert AI Agents!

Data model updating method and system for database

A data model and update method technology, applied in the database field, can solve problems such as reducing database usage efficiency, failing to record database differences and change records, etc., and achieve the effect of improving usage efficiency

Active Publication Date: 2017-05-10
GCI SCI & TECH
View PDF5 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Therefore, during the update process of database migration, downgrade, etc., if the user cannot back up in time, the difference and change records of the database cannot be recorded when the data model of the system changes, which reduces the use efficiency of the database.

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 model updating method and system for database
  • Data model updating method and system for database
  • Data model updating method and system for database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] Embodiments of the database data model update method and system of the present invention will be described below in conjunction with the accompanying drawings.

[0021] refer to figure 1 as shown, figure 1 It is a flowchart of a data model updating method of a database according to an embodiment of the present invention, including:

[0022] S110, acquiring form data of the current database, and reversely generating an object model;

[0023] In this step, when updating the data model of the database, the form data of the current database is first obtained, and the data model is reversely generated according to the original object model, so as to facilitate code comparison between the models.

[0024] In one embodiment, before the object model is reversely generated, the ORM object relational model can be used to establish a database form; according to the connection address, user name and password of the database, a connection with the database is established;

[0025...

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 relates to a data model updating method and system for a database. The method comprises the following steps: obtaining a form data of a current database and reversely generating an object model; reading a data model of a new-version database, comparing the difference between the object model with the new-version data model and generating a difference script with a version number; recording the version number into a pre-created data table; and updating the data model of the database based on the version number and the differential script recorded in the data table. The technical scheme of the invention can record the difference and change record of the data model when the data model is changed, and can provide a convenient difference script for the updating, and improve the use efficiency of the database.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a database data model updating method and system. Background technique [0002] The ORM (Object-Relation-Mapping, object-relational mapping) framework uses metadata to describe the details of object-relational mapping. Metadata generally adopts XML format and is stored in a special object-relational mapping file. [0003] In the existing ORM framework, such as Hibernate, it can detect the modification of the data model, and automatically modify the database structure synchronously; but due to the lack of means of rolling back and recording changes, users must manually back up the database form to prevent upgrade errors. [0004] Therefore, during the update process of database migration, downgrade, etc., if the user cannot back up in time, the difference and change records of the database cannot be recorded when the data model of the system changes, which reduces the use effici...

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
Inventor 温云龙
Owner GCI SCI & TECH
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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