User portrait data query system and method
A technology for querying systems and data, applied in the field of data processing, can solve the problems of large storage data, long query time, and low query efficiency in the system, and achieve the effect of ensuring cache hit rate, reducing data volume, and reducing data storage costs.
Active Publication Date: 2022-03-01
北京华品博睿网络技术有限公司
View PDF3 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
When implementing online random query of user portrait data, the query time is long due to the large amount of data stored in the system, especially when massive data is accessed concurrently, the query efficiency is lower
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0037] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.
[0038] It should be noted that if there is a directional indication (such as up, down, left, right, front, back...) in the embodiment of the present invention, the directional indication is only used to explain the position in a certain posture (as shown in the accompanying drawing). If the specific posture changes, the directional indication will also change accordingly.
[0039] In addition, in describing the present invention, the terms used are for the purpose ...
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
Login to View More Abstract
The embodiment of the invention discloses a user portrait data query system, which comprises a first-level cache database for caching active user data of the previous day stored in a dm data warehouse; the second-level cache database caches all user data stored in the dm data warehouse; the data query module is used for receiving a query request of a client so as to query required user data from the first-level cache database, the second-level cache database and the Metadata database; a preset data storage structure is adopted for storage and comprises data description information and actual data, the data description information is an array and comprises a plurality of label objects, each label object comprises a field name and a field type, all fields in the actual data are separated by separators, and the splicing sequence of the fields is consistent with the sequence of the label objects. The embodiment of the invention discloses a user portrait data query method. According to the method, the cache hit rate and the query efficiency are improved, and the data storage cost is reduced while high concurrent access is supported.
Description
technical field [0001] The present invention relates to the technical field of data processing, in particular to a query system and method for user portrait data. Background technique [0002] User portrait is the labeling of user information. By analyzing the data of various dimensions such as the user's basic information, feature preferences, and social attributes, it portrays the overall picture of the user's information and digs out valuable information from it. When realizing the online random query of user profile data, the query time is longer due to the large amount of data stored in the system, especially when massive data is accessed concurrently, the query efficiency is lower. Contents of the invention [0003] In order to solve the above problems, the object of the present invention is to provide a user portrait data query system and method, which improves the cache hit rate and query efficiency, and reduces data storage costs while supporting high concurrent a...
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
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/2457G06F16/2455G06F16/22
CPCG06F16/2457G06F16/24552G06F16/2282
Inventor 张建闯朱辉张涛薛延波赵鹏
Owner 北京华品博睿网络技术有限公司