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

Method and device for adding new attribute data in database

A technology of attribute data and database, which is applied in electronic digital data processing, special data processing applications, semi-structured data query, etc. It can solve the problems of loss of production data and chaotic structure of database tables, so as to ensure security and avoid production data. Losing and avoiding the effect of database table structure confusion

Active Publication Date: 2018-03-23
CHINA CONSTRUCTION BANK
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] In view of this, the present invention provides a method and device for adding new attribute data in the database, in order to avoid the problem of confusing database table structure easily caused by adding new attribute data to the database in the prior art, thereby avoiding Problems that easily lead to loss of production data in existing technologies

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 adding new attribute data in database
  • Method and device for adding new attribute data in database
  • Method and device for adding new attribute data in database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0036] see figure 1 , figure 1 A flowchart of a method for adding new attribute data to a database provided by an embodiment of the present invention. like figure 1 As shown, the method includes:

[0037] Step S101, obtaining a message, where the message includes a request for adding new attribute data;

[0038] Specifically, the message is obtained from a message interface, where the message includes a request for adding new attribute data, and the request includes information about the new attribute data.

[0039] Step S102, parsing the message, parsing the new attribute data into an attribute of the MappedClob data type object;

[0040] Specifically, the MappedClob is a Java data type corresponding to a CLOB (Character Large Object, character large object) data type of the database. CLOB data type is a database data type used to store larger text.

[0041] Step S103, converting the MappedClob data type object into an XML (Extensible MarkupLanguage, Extensible Markup L...

Embodiment 2

[0051] see figure 2 , figure 2 A flowchart of another method for adding new attribute data to a database provided by an embodiment of the present invention. like figure 2 As shown, the method includes:

[0052] Step S201, adding reserved field descriptions in the data entities that have the requirement of adding new attribute data;

[0053] Specifically, the database includes a plurality of data entities, and the reserved field description is added to the data entities that have new business requirements (ie, have new attribute data requirements). The reserved field description, specifically, is a CLOB data type attribute. In the invention, the CLOB data type attribute "reserved field description" is added to the entities that are prone to have future data expansion requirements in database design to prepare reservations for future attribute information expansion.

[0054] Specifically, the step S201 includes:

[0055] Get a request to add the CLOB data type attribute...

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 a device of adding new attribute data in a database. The method comprises the following steps that a message is obtained, wherein the message comprises a request of adding the new attribute data; the message is analyzed, and the new attribute data is analyzed to attributes of an MappedClob data type object; the MappedClob data type object is converted to an extensible markup language XML format, an extensible markup language XML text is established, and the new attribute data is stored in the extensible markup language XML text; the extensible markup language XML text is stored in a position described by a reserved field in a corresponding data entity in the database. By adopting a technical scheme provided by the invention, the problem of easiness in causing disorder of a database list structure when the new attribute data is added in the database in the prior art can be avoided.

Description

technical field [0001] The invention relates to the technical field of software, in particular to a method and device for adding new attribute data in a database. Background technique [0002] The database is the core and foundation of the information system. An excellent database design can organically organize a large amount of data in the information system according to the principles of the data model, and provide the functions of storing, maintaining and retrieving data, so that the information system can be convenient, timely and accurate. obtain the required information from the database. The database design must meet unified data specifications, and have forward-looking scalability considerations to adapt to various changes brought about by future business development. Whether the database design is excellent or not is one of the most critical factors for the success of the entire information system. [0003] Traditional database design often adopts a top-down driv...

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 Patents(China)
IPC IPC(8): G06F17/30
CPCG06F16/83
Inventor 舒展李拓贾国琛曲麟智李超王宁张欣
Owner CHINA CONSTRUCTION BANK
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