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

Tag management method and system in database

A management method and management system technology, applied in database indexing, special data processing applications, structured data retrieval, etc., can solve problems such as limitations and complex label data management, and achieve the effect of reducing difficulty and simplifying management complexity.

Active Publication Date: 2021-11-26
SHANGHAI SIMCOM LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] The technical problem to be solved by the present invention is to provide a management method and system for labels in the database in order to overcome the defects of complex management and limitations in the maintenance of label data in the prior art

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
  • Tag management method and system in database
  • Tag management method and system in database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0046] A method for managing tags in a database, such as figure 1 As shown, the management method includes:

[0047] Step 101. Create a table, and the table name of the table includes at least one piece of information. The at least one piece of information includes number information and letter information. The digital information in this embodiment is a 1-digit number, which can be any one of 0 to 9, and each digital information corresponds to a length interval, such as digital information "1" corresponding to a length interval of 1- 3. The digital information "2w" corresponds to the length interval 4-6, the digital information "3" corresponds to the length interval 7-10, and the digital information "5" corresponds to the length interval above 10; the letter information in this embodiment is a letter , the letter can be any one of A~Z. The tables created in this step are distributed in the same or different databases.

[0048] A specific form of the table name of the tabl...

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 tag management method and system in a database, wherein the management method includes: creating a table, and the table name of the table includes at least one piece of information; acquiring at least one feature of the tag; from the created table, searching A first table matching the label, the information included in the table name of the first table matching the feature; storing the label in the first table. The present invention can manage a large number of tags in sub-databases and sub-tables, and tags in sub-databases and sub-tables are also convenient for rapid positioning and query in the later stage, which greatly simplifies management complexity and reduces the difficulty of aggregation query after sub-databases and sub-tables.

Description

technical field [0001] The invention belongs to the field of computers, and in particular relates to a label management method and system in a database. Background technique [0002] With the widespread popularity of Internet applications, the storage and access of massive data has become a bottleneck in system design. More and more Internet companies will use some specific tags to identify Internet users, so as to analyze the user's online behavior, and then push targeted information according to the user's behavior characteristics. For a large-scale Internet application, billions of PVs (page views) every day undoubtedly put a high load on the database, causing great problems to the stability and scalability of the system. It is particularly important to maintain a large amount of label data well. [0003] Existing technologies usually improve website performance through data segmentation, and horizontally expanding the data layer has become the preferred method for arch...

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/22
CPCG06F16/22
Inventor 陆卫东
Owner SHANGHAI SIMCOM LTD
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