CN111311329B - Tag data acquisition method, device, equipment and readable storage medium - Google Patents
Tag data acquisition method, device, equipment and readable storage medium Download PDFInfo
- Publication number
- CN111311329B CN111311329B CN202010106082.3A CN202010106082A CN111311329B CN 111311329 B CN111311329 B CN 111311329B CN 202010106082 A CN202010106082 A CN 202010106082A CN 111311329 B CN111311329 B CN 111311329B
- Authority
- CN
- China
- Prior art keywords
- tag
- target
- tag data
- data
- logic table
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0201—Market modelling; Market analysis; Collecting market data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/288—Entity relationship models
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Development Economics (AREA)
- Databases & Information Systems (AREA)
- Finance (AREA)
- Theoretical Computer Science (AREA)
- Accounting & Taxation (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- Entrepreneurship & Innovation (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Game Theory and Decision Science (AREA)
- Economics (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a tag data acquisition method, a device, equipment and a readable storage medium, which relate to the technical field of Internet, and are used for acquiring target logic table codes to indicate a target logic table when a tag acquisition request is received, acquiring target tag data corresponding to the target tag codes in a physical sub-table maintained by the target logic table and returning the target tag data, so that the range for acquiring the tag data is limited based on the target logic table when the tag data is acquired, the acquired tag data amount is multiplied due to overlarge search range, the success of a tag acquisition task is ensured to the greatest extent, and a large amount of data resources are avoided. The method comprises the following steps: when a tag acquisition request is received, analyzing the circle selection requirement of the tag acquisition request to obtain a target logic table code and a target tag code; acquiring a target logic table indicated by the target logic table code; acquiring target tag data corresponding to target tag codes from a plurality of physical sub-tables; and returning the target tag data.
Description
Technical Field
The present invention relates to the field of internet technologies, and in particular, to a method, an apparatus, a device, and a readable storage medium for acquiring tag data.
Background
With the wide spread of internet technology, storage and access of mass data becomes a bottleneck problem for system design. More and more enterprises can mark online users through specific tag data, so that online behaviors of the users are analyzed, targeted information pushing is performed according to behavior characteristics of the users, new product strategies, popularization strategies and marketing strategies are guided to be generated, and finally the aim of accurate marketing is achieved. A label management system is generally set in an enterprise, and operations such as storage, acquisition and analysis of label data are realized based on the label management system. For a tag management system of a large enterprise, billions of pages are browsed daily, which definitely causes quite high load on a database, and causes quite great problems on stability and expansibility of the tag management system of the enterprise, so that how to obtain better tag data is important.
In the related art, when a tag obtaining service is provided, a tag management system generally receives a rule condition provided by a user, obtains corresponding tag data from all currently stored tag data according to a keyword, a data name and the like of the rule condition, and then outputs the tag data.
In carrying out the present invention, the inventors have found that the related art has at least the following problems:
many tag data with the same field names may exist in the tag management system, and when the tag data is acquired, the acquired tag data is likely to be multiplied due to excessive tag data with the same field names, so that the tag acquisition task fails, and a large amount of data resources are wasted.
Disclosure of Invention
In view of this, the present invention provides a method, apparatus, device and readable storage medium for acquiring tag data, which mainly aims to solve the problem that the tag data acquired at present is multiplied, resulting in failure of the tag acquisition task and waste of a large amount of data resources.
According to a first aspect of the present invention, there is provided a tag data acquisition method comprising:
when a tag acquisition request is received, analyzing a circle selection requirement of the tag acquisition request to obtain a target logic table code and a target tag code;
acquiring a target logic table indicated by the target logic table code, wherein the target logic table maintains the association relation among a plurality of physical sub-tables;
acquiring target tag data corresponding to the target tag codes from the plurality of physical sub-tables;
And returning the target tag data.
In another embodiment, when the tag obtaining request is received, the method further includes, before parsing the ring selection requirement of the tag obtaining request to obtain the logic table code and the tag code:
acquiring a full-scale table, and taking a main key of the full-scale table or a non-empty subset of the main key as a service entity, wherein the full-scale table comprises higher data amount than any other table;
determining a plurality of physical sub-tables with the consistent primary keys and the business entities, and associating the physical sub-tables based on the relation between the physical sub-tables and the business entities to generate the target logic table;
numbering the target logic table to generate the target logic table code;
numbering a plurality of tag data included in the plurality of physical sub-tables to generate a plurality of tag codes;
and marking the target logic table by adopting the service entity, the target logic code and the plurality of tag codes.
In another embodiment, when receiving the tag acquisition request, the parsing the ring selection requirement of the tag acquisition request to obtain the target logic table code and the target tag code includes:
Determining a description object which receives the tag acquisition request, and inquiring the target logic table code corresponding to the service entity consistent with the description object;
and extracting a tag name and a value range from the circle selection requirement, and combining the tag name and the value range to obtain the target tag code.
In another embodiment, the returning the target tag data includes:
determining a sender for sending the tag acquisition request, and returning the target tag data to the sender; or alternatively, the first and second heat exchangers may be,
and storing the target tag data into an external memory, generating a storage address of the target tag data on the external memory, and returning the storage address to the sender.
In another embodiment, the method further comprises:
when a range amplification request is received, extracting a specified amplification factor from the range amplification request;
generating a target feature vector of the target tag data according to the feature distribution of the target tag data;
calculating the similarity between all tag data included in the physical sub-tables and the target feature vector;
determining a similarity threshold corresponding to the designated magnification, and extracting designated tag data with similarity larger than the similarity threshold from all tag data;
And returning the specified tag data.
In another embodiment, the calculating the similarity between all tag data included in the plurality of physical sub-tables and the target feature vector includes:
extracting at least one tag feature of the tag data for each tag data in the total tag data;
counting the feature number of the tag features matched with the target feature vector in the at least one tag feature and the total number of the at least one tag feature;
and calculating the ratio of the feature number to the total number as the similarity of the tag data and the feature vector.
In another embodiment, the method further comprises:
if the tag acquisition request comprises a plurality of circle selection requirements, analyzing the circle selection requirements to acquire a plurality of candidate tag data;
extracting an operator from the tag acquisition request, the operator being used to filter the plurality of candidate fields;
when the operator is an intersecting symbol, acquiring a tag data intersection of the plurality of candidate tag data, and returning the tag data intersection;
returning all tag data included in the plurality of candidate tag data when the operator is a parallel symbol;
When the operator is a phase difference symbol, sequencing the plurality of candidate tag data according to the arrangement sequence of the plurality of circle selection requirements in the tag acquisition request, and acquiring a tag data difference set of the last candidate tag data from the sequenced plurality of candidate tag data after the previous candidate tag data is removed, and returning to the tag data difference set.
According to a second aspect of the present invention, there is provided a tag data acquiring apparatus comprising:
the analysis module is used for analyzing the circle selection requirement of the tag acquisition request when the tag acquisition request is received, so as to obtain a target logic table code and a target tag code;
the first acquisition module is used for acquiring a target logic table indicated by the target logic table code, and the target logic table maintains the association relation among a plurality of physical sub-tables;
the second acquisition module is used for acquiring target tag data corresponding to the target tag codes from the plurality of physical sub-tables;
and the return module is used for returning the target tag data.
In another embodiment, the apparatus further comprises:
the third acquisition module is used for acquiring a full-scale table, taking a main key of the full-scale table or a non-empty subset of the main key as a service entity, wherein the full-scale table comprises higher data quantity than any other table;
The association module is used for determining the plurality of physical sub-tables with the primary keys consistent with the service entity, associating the plurality of physical sub-tables based on the relation between the plurality of physical sub-tables and the service entity, and generating the target logic table;
the first generation module is used for numbering the target logic table and generating the target logic table code;
the second generation module is used for numbering a plurality of tag data included in the physical sub-tables and generating a plurality of tag codes;
and the labeling module is used for labeling the target logic table by adopting the service entity, the target logic code and the plurality of tag codes.
In another embodiment, the parsing module includes:
the analysis unit is used for determining a description object which receives the tag acquisition request, and inquiring the target logic table code corresponding to the service entity consistent with the description object;
and the combination unit is used for extracting a tag name and a value range from the circle selection requirement, and combining the tag name and the value range to obtain the target tag code.
In another embodiment, the return module is configured to determine a sender that sends the tag acquisition request, and return the target tag data to the sender; or storing the target tag data into an external memory, generating a storage address of the target tag data on the external memory, and returning the storage address to the sender.
In another embodiment, the apparatus further comprises:
a first extracting module, configured to extract a specified magnification factor from a range amplification request when the range amplification request is received;
the third generation module is used for generating a target feature vector of the target tag data according to the feature distribution of the target tag data;
the calculating module is used for calculating the similarity between all tag data included in the physical sub-tables and the target feature vector;
the second extraction module is used for determining a similarity threshold corresponding to the appointed magnification factor and extracting appointed label data with similarity larger than the similarity threshold from all label data;
the return module is further configured to return the specified tag data.
In another embodiment, the computing module includes:
an extracting unit configured to extract, for each tag data of the total tag data, at least one tag feature of the tag data;
a statistics unit, configured to count a feature number of a tag feature matched with the target feature vector in the at least one tag feature and a total number of the at least one tag feature;
And the calculating unit is used for calculating the ratio of the feature number to the total number as the similarity of the tag data and the feature vector.
In another embodiment, the parsing module is configured to parse the plurality of ring selection requirements if the tag acquisition request includes the plurality of ring selection requirements, and acquire a plurality of candidate tag data;
the apparatus further comprises:
a third extraction module, configured to extract an operator from the tag acquisition request, where the operator is used to filter the plurality of candidate fields;
the return module is further configured to obtain a tag data intersection of the plurality of candidate tag data when the operator is an intersecting symbol, and return the tag data intersection;
the return module is further configured to return all tag data included in the plurality of candidate tag data when the operator is a parallel symbol;
and the return module is further configured to sort the plurality of candidate tag data according to the arrangement order of the plurality of round selection requirements in the tag acquisition request when the operator is a phase difference symbol, obtain a tag data difference set of a previous candidate tag data reject a next candidate tag data in the sorted plurality of candidate tag data, and return the tag data difference set.
According to a third aspect of the present invention there is provided an apparatus comprising a memory storing a computer program and a processor implementing the steps of the method of the first aspect described above when the computer program is executed by the processor.
According to a fourth aspect of the present invention there is provided a readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of the method of the first aspect described above.
By means of the technical scheme, the tag data acquisition method, the tag data acquisition device, the tag data acquisition equipment and the readable storage medium are characterized in that when a tag acquisition request is received, the ring selection requirement of the tag acquisition request is analyzed to obtain the target logic table code and the target tag code, the target logic table which is indicated by the target logic table code and maintains the association relation among a plurality of physical sub-tables is acquired, the target tag data corresponding to the target tag code is acquired in the plurality of physical sub-tables and returned, so that when the tag data is acquired, the range for acquiring the tag data is limited based on the target logic table, the acquired tag data amount is prevented from being multiplied due to overlarge search range, success of a tag acquisition task is ensured to the greatest extent, and a large amount of data resources are prevented from being wasted.
The foregoing description is only an overview of the present invention, and is intended to be implemented in accordance with the teachings of the present invention in order that the same may be more clearly understood and to make the same and other objects, features and advantages of the present invention more readily apparent.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to designate like parts throughout the figures. In the drawings:
fig. 1 shows a schematic flow chart of a tag data acquisition method according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a label management system according to an embodiment of the present invention;
fig. 3A is a schematic flow chart of a tag data acquiring method according to an embodiment of the present invention;
fig. 3B is a schematic diagram illustrating a tag data acquiring method according to an embodiment of the present invention;
fig. 3C is a schematic flow chart of a tag data obtaining method according to an embodiment of the present invention;
Fig. 4A is a schematic structural diagram of a tag data acquiring apparatus according to an embodiment of the present invention;
fig. 4B is a schematic structural diagram of a tag data acquiring apparatus according to an embodiment of the present invention;
fig. 4C is a schematic structural diagram of a tag data acquiring apparatus according to an embodiment of the present invention;
fig. 4D is a schematic structural diagram of a tag data acquiring apparatus according to an embodiment of the present invention;
fig. 4E shows a schematic structural diagram of a tag data acquiring apparatus according to an embodiment of the present invention;
fig. 4F is a schematic structural diagram of a tag data acquiring apparatus according to an embodiment of the present invention;
fig. 5 shows a schematic diagram of a device structure of an apparatus according to an embodiment of the present invention.
Detailed Description
Exemplary embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present invention are shown in the drawings, it should be understood that the present invention may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the invention to those skilled in the art.
The embodiment of the invention provides a tag data acquisition method, as shown in fig. 1, which comprises the following steps:
101. when a tag acquisition request is received, analyzing the circle selection requirement of the tag acquisition request to obtain a target logic table code and a target tag code.
102. And acquiring a target logic table indicated by the target logic table code, wherein the target logic table maintains the association relation among a plurality of physical sub-tables.
103. And acquiring target tag data corresponding to the target tag codes from the plurality of physical sub-tables.
104. And returning the target tag data.
According to the method provided by the embodiment of the invention, when the tag acquisition request is received, the ring selection requirement of the tag acquisition request is analyzed to obtain the target logic table code and the target tag code, the target logic table which is indicated by the target logic table code and maintains the association relation among a plurality of physical sub-tables is acquired, and the target tag data corresponding to the target tag code is acquired in the plurality of physical sub-tables and returned, so that the range for acquiring the tag data is limited based on the target logic table when the tag data is acquired, the acquired tag data amount is multiplied due to overlarge search range, the success of the tag acquisition task is ensured to the greatest extent, and a large amount of data resources are avoided.
Before explaining the present invention in detail, a brief description will be given of the architecture of the tag management system according to the present invention.
Referring to fig. 2, the tag management system includes a service layer, a parsing layer, a background management layer, a monitoring layer, and a DB (Database) layer. The service layer is used for interfacing with an external system, receiving a tag acquisition request for calling a tag by the external system, and generally providing services to the outside based on an algorithm module, a scheduling module and an external service module. Data flow exists between the service layer, the analysis layer and the monitoring layer. The parsing layer is used for obtaining the tag obtaining request received by the service layer, and converting the tag obtaining request into executable SQL (Structured Query Language ) by parsing and splicing the tag obtaining request so as to obtain corresponding tag data according to the indication of the tag obtaining request. The analysis layer provides service based on the conversion module and the request analysis module, and data flow exists between the analysis layer, the business layer and the DB layer. The background management layer is used for managing the business in the whole tag management system and comprises a background management module, and data circulation exists among the background management module, the DB layer and the monitoring layer. The monitoring layer is used for monitoring the behaviors and operations occurring in the tag management system, and comprises a log module and a monitoring module, wherein the log module is used for generating a behavior log of the tag management system, and the monitoring module is used for monitoring the occurring operations. The DB layer is used for storing tag data in a tag management system, including ADS (Analytic Database Service, analytical database), ODPS (Open Data Processing Service, big data computing service) and MySQL (relational database management system). In the execution process of the invention, the DB layer can synchronize the label data from the ODPS to the ADS, and simultaneously synchronize the metadata of the physical sub-table on the ODPS to the MySQL, and acquire the metadata information of the physical sub-table in the background management page, thereby ensuring that label data acquisition service is successfully provided to the outside.
The embodiment of the invention provides a tag data acquisition method, as shown in fig. 3A, comprising the following steps:
301. and establishing a target logic table.
The inventor has realized that by statistics and mining, many enterprises form their own user tag libraries, including basic attributes of users, consumption behavior, preference habits, and the like. The label data of the part can be effectively managed and applied, the target crowd can be subjected to insight analysis, new product strategies, popularization strategies and marketing strategies are guided to be generated, and the purpose of accurate marketing is finally achieved. However, at present, when the user tag library is managed in an enterprise, only rough management is performed, and when tag data is acquired and called, the fuzzy query mode is generally used, so that the returned tag data is likely to be inaccurate, a large amount of query resources are wasted, and the task issued by a user is not completed well. Therefore, the invention provides a tag data acquisition method which is applied to a tag management system, so that the tag management system bears the capability of a general circle set and tag centralized management, establishes the management capability of a sound life cycle, and forms the capabilities of tag management, crowd self-definition, expansion, analysis, list output and the like by docking an algorithm platform.
The tag data acquisition method provided by the invention is mainly realized based on a logic table. The logic table is used for maintaining the association relation among a plurality of physical sub-tables, displaying a logically large wide table for inquiry, and automatically splicing the association condition among a plurality of tables when the inquiry SQL is generated, so that the inquiry accuracy is ensured. The logic table is used for providing the tag data acquisition service, so that the tag data returned to the user can be guaranteed to be just the tag data which the user wants to acquire to the greatest extent, and the situation that the data volume is multiplied due to the fact that the same field names exist in a plurality of physical sub-tables is avoided, and the tag data is failed in ring selection. Therefore, in the embodiment of the present invention, it is preferred to establish a target logic table, and provide a tag data obtaining service based on the target logic table.
When the target logic table is built, in order to ensure that the built target logic table can contain the most tag data, the related tag data quantity reaches the most, a full-quantity table can be obtained, and the target logic table is built on the basis of the full-quantity table. The full-size table includes a higher data amount than any other table, that is, a table with the most full data amount. The specific process of establishing the target logic table is as follows: firstly, a full scale is obtained, and a main key or a non-empty subset of the main key of the full scale is used as a service entity. In practice, the full table is taken as a main table of the target logic table to be generated, so that a plurality of physical sub-tables can be mounted based on the main table later. And then, after determining the main table and the business entity, determining a plurality of physical sub-tables with the main key consistent with the business entity, and associating the plurality of physical sub-tables based on the relation between the plurality of physical sub-tables and the business entity to generate a target logic table. It should be noted that the physical sub-table has a selection range, and the primary key is required to be consistent with the service entity to be one of the plurality of physical sub-tables. For example, assuming that the service entity is A, B two fields, the primary key of the mountable physical sub-table must be a or B, or a joint primary key of A, B, so as to ensure that there is an association relationship between the acquired multiple physical sub-tables.
In the practical application process, considering that the tag data included in the tag management system is massive, one target logic table may not cover all the tag data, so that a plurality of Quan Liangbiao can be obtained, and a plurality of different logic tables are generated based on a plurality of full-quantity tables, so that the query and the acquisition of massive tag data can be guaranteed. In this way, after the establishment of the target logical table is completed, in order to distinguish different logical tables and different tag data included in the logical tables, the target logical table needs to be numbered, a target logical table code is generated, and a plurality of tag fields included in a plurality of physical sub-tables are numbered, so that a plurality of tag codes are generated. And then, marking the target logic table by adopting a service entity, a target logic code and a plurality of tag codes, so that the accuracy of the acquired tag data can be ensured to the greatest extent by the tag data acquisition service provided subsequently. It should be noted that, the target logic table code of the target logic table and all the tag codes of the target logic table may be obtained by calling the external service interface of the tag management system, where the tag code uniquely corresponds to one field in one physical sub-table, so that the user may see the tag that he wants to obtain and the condition that he wants to filter in the tag management system.
302. When a tag acquisition request is received, analyzing the circle selection requirement of the tag acquisition request to obtain a target logic table code and a target tag code.
In the embodiment of the invention, after the target logic table is generated, the label acquisition service can be provided for the user based on the generated target logic table. Since the user designates which tag data or tag data to acquire in the tag acquisition request, the designated manner is usually a text type circle selection requirement, for example, the circle selection requirement is "crowd between 21 years old and 30 years old", and in the tag management system, the distinction of the tag data is realized based on the logic table coding and the tag coding, so in order to acquire the tag data according to the indication of the circle selection requirement in the tag acquisition request, the circle selection requirement in the tag data needs to be mapped into which field in a specific physical sub-table, thereby ensuring the accuracy of the acquired tag data.
When the mapping of the circle selection requirement is realized, firstly, determining the description object which receives the label acquisition request, and inquiring the target logic table code corresponding to the service entity consistent with the description object. For example, if the tag acquisition request carrying the circling request is received based on the data set describing that the object is "user", it is determined that the logical table code corresponding to the service entity "user" is the target logical table code. It should be noted that, the description object may be determined by extracting the entity noun in the tag obtaining request, and then the corresponding target logic table code is selected, so as to reduce the workload of the user and improve the efficiency of tag data obtaining. For example, for a tag acquisition request "crowd between 21 and 30 years old", the entity noun therein is only "crowd", so the "crowd" may be directly taken as the description object. Therefore, the target logic table codes corresponding to the business entity 'crowd' are used as basic elements of the follow-up requirement dependent query. The manner in which the description object is determined is not particularly limited in the present invention. And then extracting the tag name and the value range from the circle selection requirement, and combining the tag name and the value range to obtain the target tag code. For example, if the tag name extracted in the circle selection request is "age", and the extracted value range is "20 to 30", the tag name and the value range may be combined to be used as the target tag code, and the target tag code is "[ age ] + [ 20 to 30 ]. After the target logic table code and the target tag code are obtained by analyzing and mapping the circle selection requirement, the tag data acquisition process can be started.
In the practical application process, in order to facilitate the above process of resolving the circle selection requirement, the tag management system may provide a management page at the front end, and describe the logical table that has been built currently on the management page, and display the description content for the user to select. For example, the description content a is a user, the description content B is a store, and the like. Thus, when the user selects the description content desired by the user, namely, the target logic table is selected, the target logic table code can be obtained. Then, the tag management system may display the tag items included in the target logic table indicated by the target logic table code to the user, for example, assuming that the user selects the description content a, the tag items including age, height, occupation, etc. in the target logic table corresponding to the description content a are returned to the user. The user may issue the nominal signature and the range of values to the tag management system by checking the tag items and setting the range for the tag items. Finally, after confirming the management page by the user, the target logic table code and the target tag code can be confirmed through the information directly obtained in each step.
303. And acquiring a target logic table indicated by the target logic table code, and acquiring target circled tag data corresponding to the target tag code from a plurality of physical sub-tables.
In the embodiment of the invention, the target logic table code and the target tag code are obtained by analyzing and mapping the ring selection requirement, and the target logic table has the attribute of maintaining the association relation among a plurality of physical sub-tables, so that the row of which physical sub-table the target ring selection tag data to be acquired is specific to can be directly determined according to the association relation through the target logic table code and the target tag code, therefore, the target logic table indicated by the target logic table code can be directly acquired, and the target ring selection tag data corresponding to the target tag code can be acquired from the plurality of physical sub-tables.
In the practical application process, for example, if a certain logic table M maintains the association relationship among the physical sub-table a, the physical sub-table B and the physical sub-table C, the association relationship of the physical sub-tables is associated based on the user tag. Wherein, the physical sub-table A stores the height and age of the user; the physical sub-table B stores the work and address of the user; the physical sub-table C stores the user's preferences. In a certain tag acquisition task, if a user wants to select how the preference distribution of the user with the age between 20 and 30 years old, in the tag acquisition task, only the logical table M, the physical sub-table A and the physical sub-table C are actually involved, so that when the association relation between the physical sub-tables is restored, only the physical sub-table A and the physical sub-table C are required to be associated.
It should be noted that, the above process of acquiring the target circled tag data is a specific process of query. In the actual application process, the process of acquiring the target circled tag data can be realized by executing sentences. The specific process is as follows: the analysis module of the tag management system can analyze and obtain a specific physical sub-table and a specific tag field through metadata stored in MySQL, then the tag management system calls a conversion module of an analysis layer to splice the obtained target logic table code and the target tag code into an executable SQL sentence, and calls an ADS to execute the SQL sentence, so that tag detail data returned after the SQL sentence is executed can be directly obtained, and the tag detail data is the target ring selection tag data. The above process is only one way to obtain the target circled tag data, and may be implemented in other ways in the practical application process, which is not limited in detail in the present invention.
304. And returning the target circled label data.
In the embodiment of the invention, when the target circling tag data is obtained, the target circling tag data can be returned. Wherein, when the target circled tag data is returned, two modes can be adopted. One way is to determine the sender who sends the tag acquisition request, and directly return the acquired target circled tag data to the sender. In another way, in consideration of the situation that the direct return of the target circling tag data may cause excessive concurrency, in order to reduce the burden of the server, the target circling tag data may be stored in an external memory, a storage address of the target circling tag data on the external memory is generated, and the storage address is returned to the sender, so that the sender downloads and uses the target circling tag data based on the storage address.
The present invention can provide a timing acquisition service after the whole tag data acquisition process is completed, and a timer is set in the tag management system, and when it is determined that the tag data needs to be acquired based on the timer, the corresponding tag data can be acquired by executing the processes in steps 301 to 304. Because the offline data cleaned out by the data layer is different at different times, different tag data can be selected according to the same selecting requirement, so as to meet different daily requirements of users.
It should be noted that the above-mentioned processes in steps 301 to 304 only describe a case where one circle selection requirement is carried in the tag acquisition request. In the practical application process, the user who sends the tag acquisition request is likely to carry two or more circle selection requirements in the tag acquisition request. If the tag acquisition request includes a plurality of ring selection requirements, the ring selection requirements are sequentially parsed according to the processes in the steps 301 to 304, so as to acquire a plurality of candidate tag data. And then, screening the obtained plurality of candidate tag data according to the operators carried by the user in the tag acquisition request and used for screening the plurality of candidate fields, thereby returning the tag fields meeting the user requirements. In particular, the operator may be any one of an intersecting symbol, a phase-parallel symbol, and a phase-difference symbol. The intersection symbol, i.e., the "AND" symbol, is used to indicate the intersection of multiple sets. The phase-parallel symbol, i.e., the "OR" symbol, is used to indicate the union of multiple sets. The phase difference symbol, i.e., the "EXCLUD" symbol, is used to indicate the difference set between the previous set and the next set. The number of the circle selection requirements carried in the tag acquisition request is not particularly limited.
Specifically, when the operator is an intersecting symbol, acquiring a tag data intersection of candidate tag data of the tag data sets obtained by a plurality of circle selection requirements, and returning the tag data intersection, wherein the basis for judging whether the same data is the same as the service entity. And when the operator is a phase-merging symbol, returning a union set of candidate tag data obtained by a plurality of circle selection requirements. When the operator is a phase difference symbol, sequencing the plurality of candidate tag data according to the arrangement sequence of the plurality of circle selection requirements in the tag acquisition request, calculating a tag data difference set corresponding to the candidate tag data corresponding to the next circle selection requirement from the candidate tag data corresponding to the previous circle selection requirement, and returning the tag data difference set.
Referring to fig. 3B, assuming that the tag acquisition request includes 2 round-robin requirements, candidate tag data acquired according to the 2 round-robin requirements are a and B in the drawing, respectively, a representing a white area in the drawing, B representing a hatched area in the drawing, and C representing a black area in the drawing. Thus, when the operator is an intersecting symbol, i.e., the operator is "AND", the tag data of the C area is returned. When the operator is a union symbol, that is, the operator is "OR", the tag data of the a+b+c area is returned. When the operator is a phase difference symbol, that is, the operator is "EXCLUDE", the tag data of the A area is returned.
In the practical application process, the invention also provides a circle selection amplifying function. If the user is not satisfied with the quantity or quality of the currently acquired target circled tag data, the user can call the circling amplifying function to amplify the data set with the characteristics of the target circled tag data by a specified multiple, so that more tag data meeting the circling requirements of the user are acquired. The specific method is shown in fig. 3C, and includes steps 305 to 307 described below.
305. When a range enlargement request is received, a specified magnification is extracted in the range enlargement request.
In the embodiment of the invention, when the range amplification request is received, the user carries the designated amplification factor in the range amplification request, so that the designated amplification factor is extracted from the range amplification request, and more label data meeting the circle selection requirement are returned for the user according to the designated amplification factor.
306. And generating target feature vectors of the target circled tag data according to the feature distribution of the target circled tag data, and calculating the similarity between all tag data included in the plurality of physical sub-tables and the target feature vectors.
In the embodiment of the invention, because the actual significance of amplification is that more tag data meeting the requirement of circle selection is acquired for the user, the tag data strictly meeting the requirement of circle selection is the target circle selection tag data, other tag data can be similar to the target circle selection tag data only, and the amplification of the data volume can be realized only by acquiring the tag data most similar to the target circle selection tag data, so that the similarity between the other tag data and the target circle selection tag data needs to be calculated, and the tag data with the highest similarity is returned to the user as the content obtained after the amplification.
In order to calculate the similarity between other tag data and the target selected tag data, the feature distribution of the selected target selected tag data needs to be analyzed, a target feature vector of the target selected tag data is generated according to the feature distribution, and the similarity between all tag data included in the plurality of physical sub-tables and the target feature vector is calculated, so that the tag data with the highest similarity is selected as the amplified content. Specifically, the process of calculating the similarity is as follows: for each tag data in the total tag data, since the feature is extracted for the target circled tag data, and the tag data having more tag features matching the target feature vector of the target circled tag data is more similar to the target circled tag data, at least one tag feature of the tag data is extracted first. And then, counting the feature number of the tag features matched with the target feature vector in at least one tag feature and the total number of the at least one tag feature, and calculating the ratio of the feature number to the total number as the similarity of the tag data and the feature vector. For example, assuming that the obtained target feature vector includes "20-30 years old, man, white collar, a building", and the tag data M is characterized by "20-30 years old", "woman", "worker", and "a building", it is possible to determine that the feature number of the tag data M matching the target feature vector is 2, and calculate that the similarity between the tag data M and the target circled tag data is 2/5, that is, the similarity is 0.4. The foregoing is only one way to calculate the similarity, and other ways may be used to calculate the similarity in the practical application process, and the way to calculate the similarity is not specifically limited in the present invention.
307. And determining a similarity threshold corresponding to the designated magnification, extracting designated tag data with similarity larger than the similarity threshold from all tag data, and returning the designated tag data.
In the embodiment of the invention, the corresponding relation between the amplification factor and the similarity threshold can be preset in the tag management system, and the tag data with the similarity larger than the preset amplification factor of the user is inquired to determine the amplified content. For example, a corresponding similarity threshold value of 90% when the magnification is 1-fold, a corresponding similarity threshold value of 80% when the magnification is 2-fold, and the like may be set. The corresponding relation between the amplification factor and the similarity threshold can be adjusted based on the data volume in the tag management system, if the number of tag data related to the target feature vector included in the tag management system is small, the similarity threshold corresponding to the amplification factor can be properly adjusted up, otherwise, the similarity threshold is properly adjusted down, and therefore whether the data volume is more or less, other tag data can be acquired based on the amplification function.
Thus, the similarity threshold corresponding to the designated magnification can be determined, the designated tag data with the similarity larger than the similarity threshold is extracted from all the tag data, and the designated tag data is returned. The mode of returning the designated tag data is identical to the mode of returning the target circled tag data in the above step 304, and will not be described herein.
According to the method provided by the embodiment of the invention, when the tag acquisition request is received, the ring selection requirement of the tag acquisition request is analyzed to obtain the target logic table code and the target tag code, the target logic table which is indicated by the target logic table code and maintains the association relation among a plurality of physical sub-tables is acquired, the target ring selection tag data corresponding to the target tag code is acquired in the plurality of physical sub-tables and returned, so that the range for acquiring the tag data is limited based on the target logic table when the tag data is acquired, the acquired tag data amount is amplified in a multiplied way due to the overlarge search range, the success of the tag acquisition task is ensured to the greatest extent, and a large amount of data resources are avoided.
Further, as a specific implementation of the method shown in fig. 1, an embodiment of the present invention provides a tag data obtaining apparatus, as shown in fig. 4A, where the apparatus includes: a parsing module 401, a first obtaining module 402, a second obtaining module 403 and a returning module 404.
The parsing module 401 is configured to parse the ring selection requirement of the tag acquisition request when receiving the tag acquisition request, to obtain a target logic table code and a target tag code;
The first obtaining module 402 is configured to obtain a target logic table indicated by the target logic table code, where the target logic table maintains an association relationship between a plurality of physical sub-tables;
the second obtaining module 403 is configured to obtain target tag data corresponding to the target tag code in the plurality of physical sub-tables;
the return module 404 is configured to return the target tag data.
In a specific application scenario, as shown in fig. 4B, the apparatus further includes: a third obtaining module 405, an associating module 406, a first generating module 407, a second generating module 408 and an annotating module 409.
The third obtaining module 405 is configured to obtain a full table, and use a primary key of the full table or a non-empty subset of the primary key as a service entity, where the full table includes higher data amounts than any other table;
the association module 406 is configured to determine the plurality of physical sub-tables with primary keys consistent with the service entity, associate the plurality of physical sub-tables based on the relationship between the plurality of physical sub-tables and the service entity, and generate the target logical table;
the first generating module 407 is configured to number the target logic table and generate the target logic table code;
The second generating module 408 is configured to number the plurality of tag data included in the plurality of physical sub-tables to generate a plurality of tag codes;
the labeling module 409 is configured to label the target logic table by using the service entity, the target logic code, and the plurality of tag codes.
In a specific application scenario, as shown in fig. 4C, the parsing module 401 includes: an analysis unit 4011 and a combination unit 4012.
The parsing unit 4011 is configured to determine a description object that receives the tag acquisition request, and query the target logical table code corresponding to a service entity consistent with the description object;
the combining unit 4012 is configured to extract a tag name and a value range from the circling requirement, and combine the tag name and the value range to obtain the target tag code.
In a specific application scenario, the return module 404 is configured to determine a sender that sends the tag obtaining request, and return the target tag data to the sender; or storing the target tag data into an external memory, generating a storage address of the target tag data on the external memory, and returning the storage address to the sender.
In a specific application scenario, as shown in fig. 4D, the apparatus further includes: a first extraction module 410, a third generation module 411, a calculation module 412 and a second extraction module 413.
The first extracting module 410 is configured to extract a specified magnification factor from the range-enlarging request when the range-enlarging request is received;
the third generating module 411 is configured to generate a target feature vector of the target tag data according to a feature distribution of the target tag data;
the calculating module 412 is configured to calculate similarities between all tag data included in the plurality of physical sub-tables and the target feature vector;
the second extracting module 413 is configured to determine a similarity threshold corresponding to the specified magnification, and extract specified tag data with a similarity greater than the similarity threshold from the all tag data;
the return module 404 is further configured to return the specified tag data.
In a specific application scenario, as shown in fig. 4E, the computing module 412 includes: an extraction unit 4121, a statistics unit 4122 and a calculation unit 4123.
The extracting unit 4121 is configured to extract, for each of the entire tag data, at least one tag feature of the tag data;
The statistics unit 4122 is configured to count the feature number of the tag features matched with the target feature vector and the total number of the at least one tag feature in the at least one tag feature;
the calculating unit 4123 is configured to calculate a ratio of the feature number to the total number as a similarity between the tag data and the feature vector.
In a specific application scenario, as shown in fig. 4F, the apparatus further includes: a third extraction module 414.
The parsing module 401 is configured to parse the plurality of ring selection requirements if the tag acquisition request includes the plurality of ring selection requirements, and acquire a plurality of candidate tag data;
the third extracting module 414 is configured to extract an operator from the tag obtaining request, where the operator is used to filter the plurality of candidate fields;
the returning module 404 is further configured to obtain a tag data intersection of the plurality of candidate tag data when the operator is an intersecting symbol, and return the tag data intersection;
the returning module 404 is further configured to return all tag data included in the plurality of candidate tag data when the operator is a parallel symbol;
the returning module 404 is further configured to, when the operator is a phase difference symbol, sort the plurality of candidate tag data according to the arrangement order of the plurality of round selection requirements in the tag acquisition request, obtain a tag data difference set of a previous candidate tag data reject a next candidate tag data in the sorted plurality of candidate tag data, and return the tag data difference set.
According to the device provided by the embodiment of the invention, when the tag acquisition request is received, the ring selection requirement of the tag acquisition request is analyzed to obtain the target logic table code and the target tag code, the target logic table which is indicated by the target logic table code and maintains the association relation among a plurality of physical sub-tables is acquired, and the target tag data corresponding to the target tag code is acquired in the plurality of physical sub-tables and returned, so that the range for acquiring the tag data is limited based on the target logic table when the tag data is acquired, the acquired tag data amount is multiplied due to overlarge search range, the success of the tag acquisition task is ensured to the greatest extent, and a large amount of data resources are avoided.
It should be noted that, for other corresponding descriptions of each functional unit related to the tag data obtaining apparatus provided by the embodiment of the present invention, reference may be made to corresponding descriptions in fig. 1 and fig. 3A to fig. 3C, and details are not repeated here.
In an exemplary embodiment, referring to fig. 5, there is further provided a device 500 including a communication bus, a processor, a memory, and a communication interface, and may further include an input-output interface, and a display device, where the functional units may communicate with each other via the bus. The memory stores a computer program, and a processor executes the program stored in the memory to perform the tag data acquiring method of the above embodiment.
A computer readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of the tag data acquisition method.
From the above description of the embodiments, it will be apparent to those skilled in the art that the present application may be implemented in hardware, or may be implemented by means of software plus necessary general hardware platforms. Based on such understanding, the technical solution of the present application may be embodied in the form of a software product, which may be stored in a non-volatile storage medium (may be a CD-ROM, a U-disk, a mobile hard disk, etc.), and includes several instructions for causing a computer device (may be a personal computer, a server, or a network device, etc.) to perform the methods described in various implementation scenarios of the present application.
Those skilled in the art will appreciate that the drawings are merely schematic illustrations of one preferred implementation scenario, and that the modules or flows in the drawings are not necessarily required to practice the present application.
Those skilled in the art will appreciate that modules in an apparatus in an implementation scenario may be distributed in an apparatus in an implementation scenario according to an implementation scenario description, or that corresponding changes may be located in one or more apparatuses different from the implementation scenario. The modules of the implementation scenario may be combined into one module, or may be further split into a plurality of sub-modules.
The foregoing application serial numbers are merely for description, and do not represent advantages or disadvantages of the implementation scenario.
The foregoing disclosure is merely a few specific implementations of the present application, but the present application is not limited thereto and any variations that can be considered by a person skilled in the art shall fall within the protection scope of the present application.
Claims (16)
1. A tag data acquisition method, comprising:
when a tag acquisition request is received, resolving a circle selection requirement of the tag acquisition request to obtain a target logic table code and a target tag code, wherein the target logic table code is a logic table code corresponding to a service entity consistent with a description object of the tag acquisition request, and the target tag code is obtained by combining a tag name and a value range extracted from the circle selection requirement;
acquiring a target logic table indicated by the target logic table code, wherein the target logic table maintains an association relation among a plurality of physical sub-tables, the target logic table is established by taking a full-scale table comprising a plurality of tag data as a main table, and the main keys of the physical sub-tables are consistent with the main keys of the full-scale table or non-empty subsets of the main keys;
acquiring target tag data corresponding to the target tag codes from the plurality of physical sub-tables;
And returning the target tag data.
2. The method of claim 1, wherein when the tag acquisition request is received, parsing the round-robin requirement of the tag acquisition request to obtain the target logical table code and the target tag code, the method further comprises:
acquiring a full-scale table, and taking a main key of the full-scale table or a non-empty subset of the main key as a service entity, wherein the full-scale table comprises higher data amount than any other table;
determining a plurality of physical sub-tables with the consistent primary keys and the business entities, and associating the physical sub-tables based on the relation between the physical sub-tables and the business entities to generate the target logic table;
numbering the target logic table to generate the target logic table code;
numbering a plurality of tag data included in the plurality of physical sub-tables to generate a plurality of tag codes;
and marking the target logic table by adopting the service entity, the target logic table code and the plurality of tag codes.
3. The method according to claim 1, wherein when receiving the tag acquisition request, resolving the circling requirement of the tag acquisition request to obtain the target logic table code and the target tag code, including:
Determining a description object which receives the tag acquisition request, and inquiring the target logic table code corresponding to the service entity consistent with the description object;
and extracting a tag name and a value range from the circle selection requirement, and combining the tag name and the value range to obtain the target tag code.
4. The method of claim 1, wherein the returning the target tag data comprises:
determining a sender for sending the tag acquisition request, and returning the target tag data to the sender; or alternatively, the first and second heat exchangers may be,
and storing the target tag data into an external memory, generating a storage address of the target tag data on the external memory, and returning the storage address to the sender.
5. The method according to claim 1, wherein the method further comprises:
when a range amplification request is received, extracting a specified amplification factor from the range amplification request;
generating a target feature vector of the target tag data according to the feature distribution of the target tag data;
calculating the similarity between all tag data included in the physical sub-tables and the target feature vector;
Determining a similarity threshold corresponding to the designated magnification, and extracting designated tag data with similarity larger than the similarity threshold from all tag data;
and returning the specified tag data.
6. The method of claim 5, wherein said calculating the similarity of all tag data included in the plurality of physical sub-tables to the target feature vector comprises:
extracting at least one tag feature of the tag data for each tag data in the total tag data;
counting the feature number of the tag features matched with the target feature vector in the at least one tag feature and the total number of the at least one tag feature;
and calculating the ratio of the feature number to the total number as the similarity of the tag data and the feature vector.
7. The method according to claim 1, wherein the method further comprises:
if the tag acquisition request comprises a plurality of circle selection requirements, analyzing the circle selection requirements to acquire a plurality of candidate tag data;
extracting an operator from the tag acquisition request, the operator being used to screen the plurality of candidate tag data;
When the operator is an intersecting symbol, acquiring a tag data intersection of the plurality of candidate tag data, and returning the tag data intersection;
returning all tag data included in the plurality of candidate tag data when the operator is a parallel symbol;
when the operator is a phase difference symbol, sequencing the plurality of candidate tag data according to the arrangement sequence of the plurality of circle selection requirements in the tag acquisition request, and acquiring a tag data difference set of the last candidate tag data from the sequenced plurality of candidate tag data after the previous candidate tag data is removed, and returning to the tag data difference set.
8. A tag data acquiring apparatus, comprising:
the analysis module is used for analyzing the circle selection requirement of the tag acquisition request when the tag acquisition request is received to obtain a target logic table code and a target tag code, wherein the target logic table code is a logic table code corresponding to a service entity consistent with a description object of the tag acquisition request, and the target tag code is obtained by combining a tag name and a value range extracted from the circle selection requirement;
the first acquisition module is used for acquiring a target logic table indicated by the target logic table code, the target logic table maintains the association relation among a plurality of physical sub-tables, the target logic table is established by taking a full table comprising a plurality of tag data as a main table, and the main keys of the physical sub-tables are consistent with the main keys of the full table or non-empty subsets of the main keys;
The second acquisition module is used for acquiring target tag data corresponding to the target tag codes from the plurality of physical sub-tables;
and the return module is used for returning the target tag data.
9. The apparatus of claim 8, wherein the apparatus further comprises:
the third acquisition module is used for acquiring a full-scale table, taking a main key of the full-scale table or a non-empty subset of the main key as a service entity, wherein the full-scale table comprises higher data quantity than any other table;
the association module is used for determining the plurality of physical sub-tables with the primary keys consistent with the service entity, associating the plurality of physical sub-tables based on the relation between the plurality of physical sub-tables and the service entity, and generating the target logic table;
the first generation module is used for numbering the target logic table and generating the target logic table code;
the second generation module is used for numbering a plurality of tag data included in the physical sub-tables and generating a plurality of tag codes;
and the labeling module is used for labeling the target logic table by adopting the service entity, the target logic table code and the plurality of tag codes.
10. The apparatus of claim 8, wherein the parsing module comprises:
the analysis unit is used for determining a description object which receives the tag acquisition request, and inquiring the target logic table code corresponding to the service entity consistent with the description object;
and the combination unit is used for extracting a tag name and a value range from the circle selection requirement, and combining the tag name and the value range to obtain the target tag code.
11. The apparatus of claim 8, wherein the return module is configured to determine a sender that sent the tag acquisition request, and return the target tag data to the sender; or storing the target tag data into an external memory, generating a storage address of the target tag data on the external memory, and returning the storage address to the sender.
12. The apparatus of claim 8, wherein the apparatus further comprises:
a first extracting module, configured to extract a specified magnification factor from a range amplification request when the range amplification request is received;
the third generation module is used for generating a target feature vector of the target tag data according to the feature distribution of the target tag data;
The calculating module is used for calculating the similarity between all tag data included in the physical sub-tables and the target feature vector;
the second extraction module is used for determining a similarity threshold corresponding to the appointed magnification factor and extracting appointed label data with similarity larger than the similarity threshold from all label data;
the return module is further configured to return the specified tag data.
13. The apparatus of claim 12, wherein the computing module comprises:
an extracting unit configured to extract, for each tag data of the total tag data, at least one tag feature of the tag data;
a statistics unit, configured to count a feature number of a tag feature matched with the target feature vector in the at least one tag feature and a total number of the at least one tag feature;
and the calculating unit is used for calculating the ratio of the feature number to the total number as the similarity of the tag data and the feature vector.
14. The apparatus of claim 8, wherein the parsing module is configured to parse the plurality of round-robin requirements to obtain a plurality of candidate tag data if the tag acquisition request includes the plurality of round-robin requirements;
The apparatus further comprises:
a third extraction module, configured to extract an operator from the tag acquisition request, where the operator is used to screen the plurality of candidate tag data;
the return module is further configured to obtain a tag data intersection of the plurality of candidate tag data when the operator is an intersecting symbol, and return the tag data intersection;
the return module is further configured to return all tag data included in the plurality of candidate tag data when the operator is a parallel symbol;
and the return module is further configured to sort the plurality of candidate tag data according to the arrangement order of the plurality of round selection requirements in the tag acquisition request when the operator is a phase difference symbol, obtain a tag data difference set of a previous candidate tag data reject a next candidate tag data in the sorted plurality of candidate tag data, and return the tag data difference set.
15. An apparatus comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any one of claims 1 to 7 when the computer program is executed.
16. A readable storage medium having stored thereon a computer program, which when executed by a processor realizes the steps of the method according to any of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010106082.3A CN111311329B (en) | 2020-02-20 | 2020-02-20 | Tag data acquisition method, device, equipment and readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010106082.3A CN111311329B (en) | 2020-02-20 | 2020-02-20 | Tag data acquisition method, device, equipment and readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111311329A CN111311329A (en) | 2020-06-19 |
| CN111311329B true CN111311329B (en) | 2023-07-25 |
Family
ID=71149041
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010106082.3A Active CN111311329B (en) | 2020-02-20 | 2020-02-20 | Tag data acquisition method, device, equipment and readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111311329B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103577590A (en) * | 2013-11-12 | 2014-02-12 | 北京润乾信息系统技术有限公司 | Data query method and system |
| CN108664516A (en) * | 2017-03-31 | 2018-10-16 | 华为技术有限公司 | Enquiring and optimizing method and relevant apparatus |
| CN109446197A (en) * | 2018-09-26 | 2019-03-08 | 深圳壹账通智能科技有限公司 | User information processing method, device, computer equipment and storage medium |
| CN109902100A (en) * | 2019-01-31 | 2019-06-18 | 平安科技（深圳）有限公司 | Report form inquiring method, device and storage medium |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104731896B (en) * | 2015-03-18 | 2018-11-09 | 北京百度网讯科技有限公司 | A kind of data processing method and system |
| US9773029B2 (en) * | 2016-01-06 | 2017-09-26 | International Business Machines Corporation | Generation of a data model |
| CN110020086B (en) * | 2017-12-22 | 2021-10-26 | 中国移动通信集团浙江有限公司 | User portrait query method and device |
| CN110119292B (en) * | 2018-02-07 | 2023-02-07 | 中兴通讯股份有限公司 | System operation parameter query method, matching method, device and node equipment |
| CN109739873A (en) * | 2018-12-27 | 2019-05-10 | 广州市玄武无线科技股份有限公司 | A kind of business datum querying method, device, equipment and readable storage medium storing program for executing |
| CN110781184B (en) * | 2019-09-16 | 2023-06-16 | 平安科技（深圳）有限公司 | Data table construction method, device, equipment and storage medium |
| CN110674228B (en) * | 2019-09-23 | 2024-03-26 | 先进新星技术(新加坡)控股有限公司 | Data warehouse model construction and data query method, device and equipment |
-
2020
- 2020-02-20 CN CN202010106082.3A patent/CN111311329B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103577590A (en) * | 2013-11-12 | 2014-02-12 | 北京润乾信息系统技术有限公司 | Data query method and system |
| CN108664516A (en) * | 2017-03-31 | 2018-10-16 | 华为技术有限公司 | Enquiring and optimizing method and relevant apparatus |
| CN109446197A (en) * | 2018-09-26 | 2019-03-08 | 深圳壹账通智能科技有限公司 | User information processing method, device, computer equipment and storage medium |
| CN109902100A (en) * | 2019-01-31 | 2019-06-18 | 平安科技（深圳）有限公司 | Report form inquiring method, device and storage medium |
Non-Patent Citations (2)
| Title |
|---|
| Complex Queries Optimization and Evaluation over Relational and NoSQL Data Stores in Cloud Environments;Rami Sellami等;IEEE Transactions on Big Data;全文 * |
| 基于异构集成的元数据及其多表动态查询算法;李润洲;方明;;计算机工程(第17期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111311329A (en) | 2020-06-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111459985B (en) | Identification information processing method and device | |
| CN108563734B (en) | System information query method, device, computer equipment and storage medium | |
| US8751459B2 (en) | Method and system to analyze email addresses | |
| CN111553137B (en) | Report generation method and device, storage medium and computer equipment | |
| CN111752955A (en) | Data processing method, device, equipment and computer readable storage medium | |
| CN112307374A (en) | Jumping method, device and equipment based on backlog and storage medium | |
| CN110781183A (en) | Method and device for processing incremental data in Hive database and computer equipment | |
| CN111899821A (en) | Method for processing medical institution data, method and device for constructing database | |
| CN115687787A (en) | Industry policy target group portrait construction method, system and storage medium | |
| CN113268500A (en) | Service processing method and device and electronic equipment | |
| CN107871055B (en) | Data analysis method and device | |
| CN113221535B (en) | Information processing method, device, computer equipment and storage medium | |
| CN113157978B (en) | Data label establishing method and device | |
| CN112256517B (en) | Log analysis method and device of virtualization platform based on LSTM-DSSM | |
| CN111311329B (en) | Tag data acquisition method, device, equipment and readable storage medium | |
| CN115544050A (en) | Operation log recording method, device, equipment and storage medium | |
| JP6763967B2 (en) | Data conversion device and data conversion method | |
| CN114416848A (en) | Data blood relationship processing method and device based on data warehouse | |
| CN111752898B (en) | File processing method and device | |
| JP2018013819A (en) | Business matching support system, and business matching support method | |
| CN112612817A (en) | Data processing method and device, terminal equipment and computer readable storage medium | |
| CN108132940A (en) | A kind of application data extracting method and device | |
| CN111368055A (en) | Retrieval method and device for patent database combined enterprise information platform | |
| CN111045983A (en) | Nuclear power station electronic file management method and device, terminal equipment and medium | |
| CN112527813A (en) | Data processing method and device of business system, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |