Service table processing method and device

A technology in business tables and sequence tables, applied in the field of databases, can solve problems such as application limitations, and achieve the effect of solving the problems of application limitations

Inactive Publication Date: 2016-03-30
PEKING UNIV FOUNDER GRP CO LTD +1
View PDF2 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The present invention provides a processing method and device for business tables, which can be applied to any database, and can solve the problem of application limitations existing in the digital sequence generation method provided by the existing 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
  • Service table processing method and device
  • Service table processing method and device
  • Service table processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] figure 1 It is a schematic flowchart of a method for processing a business table provided by an embodiment of the present invention. The method in this embodiment can be applied to any database. Such as figure 1 As shown, the method provided in this embodiment includes:

[0020] 101. When a row of data content is added or decreased in the data content column of any business table in the database, acquire the name of the business table to be processed whose data content column changes;

[0021] The database of this embodiment includes a plurality of business tables, and a corresponding name and a sequence table corresponding to each business table name are defined for each business table. In this embodiment, an initial A sequence value and a step size, wherein the step size is a preset value representing the change rule of the sequence value in the sequence table. Wherein, the initial sequence value may be 0 or 1, for example.

[0022] Assume that a plurality of stu...

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 provides a service table processing method and device; the method comprises the following steps: obtaining the name of a service table with changing data content columns when data-in-line content is added or reduced in the data content columns of a random service table in a database; searching a sequence table corresponding to the name of the service table according to the service table name, obtaining a present sequence value and increment contained in the sequence table, wherein the increment is a preset value representing sequence value changing rule in the sequence table; adding or subtracting the obtained present sequence value and the increment, plugging the added or subtracted sequence value into an identification attribute column of the service table, wherein the added or subtracted sequence value is matched with an identification attribute item of the added or reduced data-in-line content. The method and device suit for all databases, and can solve the application restricted problems existing in a digit sequence generation method provided by an existing database.

Description

technical field [0001] The invention relates to database technology, in particular to a method and device for processing business tables. Background technique [0002] In the prior art, the database provides two methods for generating digital sequences, one of which is to define a column with an Identity attribute, referred to as an Identity column, when the Identity column is used to define a business table, and in each business table When a row is inserted in the business table, a value will be automatically generated for the Identity column of the business table; another method is to create a sequence object, which can be referenced by a sequence expression (sequence expression), which can be used for a row in the business table Automatically generate a serial number, which is a set of equally spaced values ​​(sequence of numbers). [0003] However, the biggest difference between Identity and sequence is: Identity is only specified on a certain column in the business tab...

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): G06F17/30
Inventor 陈红安
Owner PEKING UNIV FOUNDER GRP CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap