Unlock instant, AI-driven research and patent intelligence for your innovation.

Database processing method and device

A processing method and database technology, applied in the database field, can solve problems such as error-prone and cumbersome processes, and achieve the effect of accurate modification

Active Publication Date: 2020-06-16
BEIJING GRIDSUM TECH CO LTD
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The embodiment of the present invention provides a database processing method and device, to at least solve the technical problems in the prior art that the method of modifying the character set of the database one by one is cumbersome and error-prone

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
  • Database processing method and device
  • Database processing method and device
  • Database processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0031] In order to enable those skilled in the art to better understand the solutions of the present invention, the following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only It is an embodiment of a part of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts shall fall within the protection scope of the present invention.

[0032] It should be noted that the terms "first" and "second" in the description and claims of the present invention and the above drawings are used to distinguish similar objects, but not necessarily used to describe a specific sequence or sequence. It is to be understood that the data so used are interchangeable under appropriate ...

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 database processing method and device. The method comprises the steps that a first database list is acquired, wherein the first database list comprises at least one first database, and the first databases are databases where character sets have errors but stored data is correct; at least one second database is created, wherein the second databases are databases where character sets are correct and no content is stored, and the second databases are in one-to-one correspondence with the first databases; and the data stored in each first database is synchronized to the corresponding second database. Through the database processing method and device, the technical problems that in the prior art, by the adoption of the method of modifying the character sets of the databases one by one, the process is complicated and prone to generate errors are solved.

Description

technical field [0001] The present invention relates to the technical field of databases, in particular to a database processing method and device. Background technique [0002] In the SQL Server (SQL Server is a relational database management system launched by Microsoft) database operation and maintenance process, the template library is usually used to generate a special database for Profile (user configuration file). If the template library with the wrong character set is used to generate the Profile It is a dedicated database, and it is not discovered in time. When a large amount of production data is accumulated in the database, it is quite labor-intensive and error-prone to modify the character set of the database (including tables) one by one. [0003] In the prior art, it is possible to modify the database one by one through SSMS (SQL Server Management Studio, SQL Server management platform), including the method of each table that references the character set, but ...

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): G06F16/27G06F16/28
CPCG06F16/27G06F16/284
Inventor 赵春猛
Owner BEIJING GRIDSUM TECH CO LTD