CN109947788A - Data query method and apparatus - Google Patents

Data query method and apparatus Download PDF

Info

Publication number
CN109947788A
CN109947788A CN201711042305.9A CN201711042305A CN109947788A CN 109947788 A CN109947788 A CN 109947788A CN 201711042305 A CN201711042305 A CN 201711042305A CN 109947788 A CN109947788 A CN 109947788A
Authority
CN
China
Prior art keywords
attribute
splicing
data query
rule
module
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.)
Granted
Application number
CN201711042305.9A
Other languages
Chinese (zh)
Other versions
CN109947788B (en
Inventor
杨帅
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Jingdong Century Trading Co Ltd
Beijing Jingdong Shangke Information Technology Co Ltd
Original Assignee
Beijing Jingdong Century Trading Co Ltd
Beijing Jingdong Shangke Information Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Beijing Jingdong Century Trading Co Ltd, Beijing Jingdong Shangke Information Technology Co Ltd filed Critical Beijing Jingdong Century Trading Co Ltd
Priority to CN201711042305.9A priority Critical patent/CN109947788B/en
Publication of CN109947788A publication Critical patent/CN109947788A/en
Application granted granted Critical
Publication of CN109947788B publication Critical patent/CN109947788B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Abstract

The embodiment of the invention discloses a kind of data query method and apparatus, are related to field of computer technology.Wherein, this method comprises: receiving data query task;According to attribute configuration table and the assembled SQL statement corresponding with the data query task of preset splicing rule;The label list in database is inquired according to the SQL statement, to obtain query result.By above step, it can be dynamically generated SQL statement in server-side, not need to be embedded in fixed SQL code in front end, reduce the degree of coupling of data query system front and back ends.

Description

Data query method and apparatus
Technical field
The present invention relates to field of computer technology more particularly to a kind of data query method and apparatus.
Background technique
In internet, marketing gradually occupies the epoch of mainstream, specifies product orientation, optimization user experience, precisely launches extensively It accuses, and measurement user's value etc. is all closely related with the target audience of determining marketing.And can quick response choose demand, energy The no convenient model of choosing that extends is the key index for measuring system superiority and inferiority of choosing.
Existing system of choosing generally is made of front-end interface and rear end table.Front-end interface is usually for party in request's personalization The configuration interface for selecting attribute, to limit querying condition.Rear end table is the huge wide table with various attribute tags, tool There is the features such as data volume is big, attribute is various.In existing system of choosing, for generating query SQL (structured query language) Code be that front end is embedded in a manner of hard coded by developer.After demander submits attribute to choose list, front end can root The attribute and attribute value generation query SQL chosen according to demander, are then committed to rear end for query SQL.Before rear end receives When the query SQL at end, corresponding SQL statement is executed, and forward end returns to query result.
In realizing process of the present invention, at least there are the following problems in the prior art for inventor's discovery:
The first, close coupling.In existing system of choosing, the code for generating query SQL is prior fixedly embedded front end , the coupling of system front and back end is high, is not easy to the code that data mining personnel modify query SQL.
The second, high latency.The rear end table of existing system of choosing is a huge wide table, and data volume is very big.When user selects When the attribute selected is more, such one huge wide table is inquired by SQL statement, time-consuming very long, the pressure of database is also very big.Cause This, existing system response time of choosing is very slow, and user experience is poor.
Summary of the invention
In view of this, the embodiment of the present invention provides a kind of data query method and apparatus, with being capable of dynamic generation SQL language Sentence reduces the degree of coupling of data query system (such as system of choosing) front and back ends.Further, the data of the embodiment of the present invention are looked into Asking method and apparatus can be improved the response speed of data query system, improve user experience.
To achieve the above object, according to an aspect of the invention, there is provided a kind of data query method.
Data query method of the invention includes: to receive data query task;According to attribute configuration table and preset spelling Connect regular assembled SQL statement corresponding with the data query task;The label in database is inquired according to the SQL statement Table, to obtain query result.
Optionally, the data query task includes: the attribute and its attribute value of selection;The attribute configuration table includes: Label table name, attribute-name, attribute type, splicing logical word;The splicing rule includes: the first splicing rule and the second splicing rule Then;It is described according to attribute configuration table and the preset assembled SQL statement corresponding with the data query task of splicing rule Step includes: that attribute type corresponding with the attribute of the selection and splicing logical word are obtained from the attribute configuration table;Root The attribute of the selection is spliced with its attribute value according to the attribute type and the first splicing rule, to obtain condition;Root The all properties of same label table name will be corresponded in the data query task according to the splicing logical word and the second splicing rule The condition spliced, to obtain WHERE clause;SELECT clause, FROM clause and the WHERE clause are spelled Dress, to generate SQL statement.
Optionally, the first splicing rule includes: when attribute type is " selection ", and the splicing of attribute and attribute value is closed Keyword is " IN ";When attribute type is " range ", the splicing keyword of attribute and attribute value is " BETWEEN AND ".
Optionally, it is genuine condition and all splicing logics that the second splicing rule, which includes: preferentially by preset logic, Word is that the condition of the attribute of " AND " is stitched together, whole to constitute the condition spliced by splicing logical word " AND ";It will Preset logic is false condition and all splicing logical words are that the condition of attribute of " OR " is stitched together, with composition by The condition for splicing logical word " OR " splicing is whole;The condition by splicing logical word " OR " splicing is crucial entirely through splicing Word " AND " splicing is behind the condition entirety by splicing logical word " AND " splicing.
Optionally, it is described according to the SQL statement inquire database in label list the step of include: with the data When the corresponding SQL statement of query task is multiple, multiple label lists in database are concurrently inquired according to all SQL statements, Then the comprehensive inquiry result of each label list is determined according to the logical relation of all SQL statements.
Optionally, described according to attribute configuration table and the assembly of preset splicing rule and the data query task pair Before the step of SQL statement answered, the method also includes: the attribute pair of acquisition and the selection from the attribute configuration table The attribute type answered converts the attribute value in the data query task according to the attribute type and preset write-in rule The storage format required at SQL splicing is met.
Optionally, the preset write-in rule includes: and corresponds to the attribute when the attribute type of attribute is " selection " Attribute value write-in storage table " initial value " field;When the attribute type of attribute is " range ", by the left margin of the attribute " initial value " field of value write-in storage table, by " end value " field of the right boundary value write-in storage table of the attribute.
Optionally, before the reception data query task the step of, the method also includes: receiving front end When attribute retrieval request, reading attributes allocation list, in order to which front end includes multiple display modules according to result dynamic generation is read Front end query interface;Wherein, each display module includes at least one attribute that can be selected.
To achieve the above object, according to another aspect of the present invention, a kind of data query device is provided.
Data query device of the invention includes: receiving module, for receiving data query task;Assembling module is used for According to attribute configuration table and the assembled SQL statement corresponding with the data query task of preset splicing rule;Enquiry module, For inquiring the label list in database according to the SQL statement, to obtain query result.
Optionally, the data query task includes: the attribute and its attribute value of selection;The attribute configuration table includes: Label table name, attribute-name, attribute type, splicing logical word;The splicing rule includes: the first splicing rule and the second splicing rule Then;The assembling module is assembled corresponding with the data query task according to attribute configuration table and preset splicing rule SQL statement includes: that attribute type corresponding with the attribute of the selection and spelling are obtained in the assembling module dependence allocation list Connect logical word;The assembling module is according to the attribute type and the regular attribute and its attribute value by the selection of the first splicing Spliced, to obtain condition;The assembling module looks into the data according to the splicing logical word and the second splicing rule The condition that all properties of same label table name are corresponded in inquiry task is spliced, to obtain WHERE clause;The assembly SELECT clause, FROM clause and the WHERE clause are carried out assembly by module, to generate SQL statement.
Optionally, the enquiry module according to the SQL statement inquire database in label list include: with the number According to the corresponding SQL statement of query task be it is multiple when, the enquiry module is concurrently inquired in database according to all SQL statements Multiple label lists, the comprehensive inquiry result of each label list is then determined according to the logical relation of all SQL statements.
Optionally, described device further include: writing module, for being obtained from the attribute configuration table and the selection The corresponding attribute type of attribute, it is regular by the attribute in the data query task according to the attribute type and preset write-in Value is converted into meeting the storage format that SQL splicing requires.
Optionally, described device further include: read module, for reading in the attribute retrieval request for receiving front end Attribute configuration table, in order to front end according to read result dynamic generation include multiple display modules front end query interface;Wherein, Each display module includes the attribute that at least one can be selected.
To achieve the above object, another aspect according to an embodiment of the present invention provides a kind of server.
The server of the embodiment of the present invention, comprising: one or more processors;And storage device, for storing one Or multiple programs;When one or more of programs are executed by one or more of processors, so that one or more of The data query method of the processor realization embodiment of the present invention.
To achieve the above object, another aspect according to an embodiment of the present invention provides a kind of computer-readable medium.
The computer-readable medium of the embodiment of the present invention, is stored thereon with computer program, and described program is held by processor The data query method of the embodiment of the present invention is realized when row.
One embodiment in foregoing invention has the following advantages that or the utility model has the advantages that in embodiments of the present invention, by Rear end presets attribute configuration table and splicing rule, and after receiving data query task, according to attribute configuration table and The assembled SQL statement corresponding with the data query task of splicing rule, can be dynamically generated SQL statement, without The fixed SQL code of the front end insertion of data query system, reduces the coupling of system front and back ends.Further, pass through generation Multiple SQL statements concurrently inquire multiple label lists, can save query time, improve data query system response speed Degree improves user experience.
Further effect possessed by above-mentioned non-usual optional way adds hereinafter in conjunction with specific embodiment With explanation.
Detailed description of the invention
Attached drawing for a better understanding of the present invention, does not constitute an undue limitation on the present invention.Wherein:
Fig. 1 is the key step schematic diagram of data query method according to an embodiment of the invention;
Fig. 2 is the key step schematic diagram of data query method according to another embodiment of the present invention;
Fig. 3 is the main modular schematic diagram of data query device according to an embodiment of the invention;
Fig. 4 is the main modular schematic diagram of data query device according to another embodiment of the present invention;
Fig. 5 is that the embodiment of the present invention can be applied to exemplary system architecture figure therein;
Fig. 6 is adapted for the structural schematic diagram for the computer system for realizing the server of the embodiment of the present invention.
Specific embodiment
Below in conjunction with attached drawing, an exemplary embodiment of the present invention will be described, including the various of the embodiment of the present invention Details should think them only exemplary to help understanding.Therefore, those of ordinary skill in the art should recognize It arrives, it can be with various changes and modifications are made to the embodiments described herein, without departing from scope and spirit of the present invention.Together Sample, for clarity and conciseness, descriptions of well-known functions and structures are omitted from the following description.
It should be pointed out that in the absence of conflict, the feature in embodiment and embodiment in the present invention can be with It is combined with each other.
Fig. 1 is the key step schematic diagram of data query method according to an embodiment of the invention.The embodiment of the present invention Data query method can be executed by rear end (server-side).As shown in Figure 1, the data query method of the embodiment of the present invention includes:
Step S101, data query task is received.
When it is implemented, user can choose the category limited needed for inquiry operation by front end (terminal device) query interface It property and sets property.After user clicks " submission " button, data query task is sent to rear end by front end.Wherein, The data query task includes: the attribute and its attribute value of selection.For example, in the target audience to determine advertisement marketing, A certain user includes: in basic behavioral module based on the data query task that the front end query interface for the system of choosing is submitted Grd_lvl (abbreviation of grade_level, membership grade) attribute, age (age) attribute and sex (gender) attribute, and purchase The attribute of order_num (amount of placing an order) attribute and order_amt (order value) attribute and each attribute in behavioral module Value.
Step S102, assembled corresponding with the data query task according to attribute configuration table and preset splicing rule SQL statement.
Wherein, the attribute configuration table is used to store the configuration information for all properties that front end query interface can be shown, Can include: label table name, attribute-name, the corresponding attribute type of each attribute, the corresponding splicing logical word of each attribute.The spelling Connecing rule includes the strictly all rules that are followed of splicing SQL statement, it may include: for the attribute with different attribute type, it is specified that It carries out splicing splicing keyword used with attribute value;For with it is different splicing logical words attributes constitute condition, Define the rule that each condition is spliced.
Wherein, a kind of optional embodiment of step S102 includes: the attribute query according to included by data query task Attribute configuration table, to obtain corresponding attribute configuration information;Then, by the corresponding attribute configuration information and preset Splicing rule is associated, and attribute and attribute value is spliced into condition, then each condition is spliced into WHERE clause;Next, The WHERE clause and SELECT clause, FROM clause are spliced, to obtain the SQL language for inquiring a label list Sentence.When it is implemented, the corresponding SQL statement of the data query task (may only be inquired in a label list for one Data), it is also possible to be multiple (inquiring the data in multiple label lists).
Step S103, the label list in database is inquired according to the SQL statement, to obtain query result.
When it is implemented, multiple label lists can be stored in the database in order to improve data query speed.Also, with When the corresponding SQL statement of the data query task is multiple, multiple label lists can be concurrently inquired according to all SQL statements, Then the comprehensive inquiry of each label list is determined according to the logical relation of all SQL statements as a result, and by the comprehensive inquiry result It is back to the front end (terminal device) of data query system.
In embodiments of the present invention, by presetting attribute configuration table and splicing rule, and appoint receiving data query It, being capable of dynamic according to attribute configuration table and the assembled SQL statement corresponding with the data query task of splicing rule after business Ground generates SQL statement, without the SQL code fixed in front end insertion, reduces the coupling of data query system front and back ends Property.Further, when generating multiple SQL statements, by concurrently inquiring multiple label lists, query time can be saved, improved The response speed of data query system improves user experience.
Fig. 2 is the key step schematic diagram of data query method according to another embodiment of the present invention.The embodiment of the present invention Data query method can be executed by server-side.As shown in Fig. 2, the data query method of the embodiment of the present invention includes:
Step S201, data query task is received.
Wherein, the data query task includes: the attribute and its attribute value of selection.Further, before step S201, The data query method of the embodiment of the present invention further include: in the attribute retrieval request for receiving front end, reading attributes allocation list, In order to front end according to read result dynamic generation include multiple display modules front end query interface;Wherein, each displaying mould Block includes the attribute that at least one can be selected.
Wherein, the attribute configuration table includes: that all display module names of data query system, each display module are corresponding The all properties name that label table name, each display module include.In addition, the attribute configuration table further include: the Attribute class of each attribute The field informations such as the attribute meaning of splicing logical word and each attribute of type and each attribute.The attribute type includes: selection class Type, wide-style;The splicing logical word includes: AND, OR.When it is implemented, the corresponding relationship of display module and label list can Think one-to-one, or many-one.For example, the front end for system of choosing is looked into the target audience to determine advertisement marketing Asking interface includes: basic behavioral module, buying behavior module;Database includes: label list lab1, label list lab2.Also, base Plinth behavioral module is corresponding with label list lab1, and buying behavior module is corresponding with label list lab2.
In embodiments of the present invention, by the way that all properties of data query system to be stored in the attribute configuration table of rear end In, and the reading attributes allocation list when rear end receives the attribute retrieval request of front end, it is dynamically obtained convenient for front end to be presented Attribute, and then front end query interface is dynamically generated according to the attribute of acquisition, reduces the coupling of data query system front and back ends It is right.When developer needs to modify or delete some attribute, the attribute configuration table of rear end need to be only modified, it is not necessary to modify front ends Code, so that the iterative operation of system is more convenient, iteration efficiency is improved.
Step S202, attribute type corresponding with the attribute of the selection is obtained in dependence allocation list, according to the category Property type and preset write-in rule the attribute value in the data query task is converted into meeting the storage that SQL splicing requires Format.
Wherein, said write rule includes: when the attribute type of the attribute in data query task is " selection " type When, by " initial value " field of the corresponding attribute value write-in storage table of the attribute;When the attribute type of an attribute is " range " class When type, by " initial value " field of the left boundary value write-in storage table of the attribute, and the right boundary value of the attribute is written and is stored " end value " field of table.In addition, said write is regular further include: for the attribute for " range " type, if user does not limit " initial value " field in storage table is then written in left margin default value by the left boundary value of the attribute;If user does not limit the category Property right boundary value, then by right margin default value be written storage table in " end value " field.
It has been obtained by step S202 for storing the storage table for meeting the attribute value that SQL splicing requires.The storage table Can include: these field informations of task identification, module name, attribute-name, initial value, end value.So, SQL language is being carried out When sentence splicing, it can facilitate directly using the attribute value in the storage table and carry out SQL splicing.Illustratively, work as data query When system is target user's inquiry system in advertisement marketing, attribute configuration table can be as shown in table 1, is obtained according to step S202 Storage table can be as shown in table 2.
Table 1
Module name Label table name Attribute-name Attribute meaning Attribute type Splice logical word
Basic behavior lab1 grd_lvl Membership grade Selection AND
Basic behavior lab1 age Age Range OR
Basic behavior lab1 sex Gender Selection OR
Basic behavior lab1 log_date Log date Range AND
Buying behavior lab2 order_num The amount of placing an order Range AND
Buying behavior lab2 order_amt Order value Range AND
Table 2
Task identification Module name Attribute-name Initial value End value
149690 Basic behavior grd_lvl 1,2,3
149690 Basic behavior age 18 30
149690 Basic behavior sex ‘f’
149690 Basic behavior log_date date‘2017-01-01’ date‘2017-01-10’
It should be pointed out that table 1 is the exemplary illustration to attribute configuration table, table 2 is illustrated only is with task identification The corresponding attribute value of 149690 data query task stores information.In the specific implementation, those skilled in the art can be according to reality Border demand adjusts field contents included by attribute configuration table, storage table.
Step S203, label table name corresponding to the attribute with the selection is obtained in dependence allocation list, and is based on institute State label table name building FROM clause.
Illustratively, as shown in table 1, when data query task includes the attribute in basic behavioral module, with the module In the corresponding label list of attribute it is entitled " lab1 ", for the label list building FROM clause are as follows: FROM lab1.Work as data When query task includes the attribute in buying behavior module, label list corresponding with the attribute in the module is entitled " lab2 ", needle To the FROM clause of label list building are as follows: FROM lab2.
Step S204, attribute type corresponding with the attribute of the selection is obtained from the attribute configuration table and splicing is patrolled Collect word;The attribute of the selection is spliced with its attribute value according to the attribute type and the first splicing rule, to obtain Condition.
Wherein, the first splicing rule includes: and is carried out attribute-name and attribute value with " IN " when attribute type is " selection " Splicing, to be spliced into a condition;When attribute type is " range ", with " BETWEEN AND " by attribute-name and attribute value into Row splicing, is spliced into a condition.
Step S205, it will be corresponded in the data query task according to the splicing logical word and the second splicing rule same The condition of all properties of label table name is spliced, to obtain WHERE clause.
Wherein, it is genuine condition (for example, " 1=1 " this condition) that the second splicing rule, which includes: preferentially by preset logic, It is stitched together with the condition for the attribute that all splicing logical words are " AND ", is spliced with constituting by splicing logical word " AND " Condition it is whole;By preset logic be false condition (for example, " 1=2 " this condition) and all splicing logical words are " OR " The condition of attribute be stitched together, to constitute condition entirety splice by splicing logical word " OR ";By described by splicing Logical word " OR " splicing condition entirely through splicing keyword " AND " splicing it is described by splicing logical word " AND " splicing Behind condition entirety.
Step S206, SELECT clause, FROM clause and the WHERE clause are subjected to assembly, to generate SQL statement.
Wherein, the SELECT clause can determine according to the purpose of data query task.For example, when data query system is When target user's inquiry system in advertisement marketing, the purpose of data query task is inquiry target user, therefore, building SELECT clause are as follows: SELECTuser_id.Illustratively, when data query system is target user's inquiry in advertisement marketing When system, by step S203 to step S206 construct for inquiring the SQL statement of a certain label list are as follows:
Step S207, when SQL statement corresponding with the data query task is multiple, simultaneously according to all SQL statements Multiple label lists in database are inquired capablely, and the synthesis of each label list is then determined according to the logical relation of all SQL statements Query result.
In this step, the comprehensive inquiry result of each label list is determined according to the logical relation of all SQL statements can include: If the logical relation of each SQL statement is " AND ", intersection can be taken to the query result of each label list, and using the intersection as Final comprehensive inquiry result;If the logical relation of each SQL statement is " OR ", the query result of each label list can be taken simultaneously Collection, and using the union as final comprehensive inquiry result.
Step S208, comprehensive inquiry result is back to front end.
In embodiments of the present invention, SQL statement can be dynamically generated by above step, and according to each SQL of generation Sentence concurrently inquires multiple label lists, not only reduces the coupling of front and back ends, and can save query time, improve The response speed of data query system improves user experience.Further, it in the attribute retrieval request for receiving front end, reads Attribute configuration table, so that front end dynamic generation includes the front end query interface of multiple display modules, before further reduced system, The degree of coupling of rear end.
Fig. 3 is the main modular schematic diagram of data query device according to an embodiment of the invention.In general, data query System includes: front end (terminal device), rear end (server-side).The data query device of the embodiment of the present invention is arranged in server-side. As shown in figure 3, the data query device 300 of the embodiment of the present invention includes: receiving module 301, assembling module 302, enquiry module 303。
Receiving module 301, for receiving data query task.
When it is implemented, user can choose the category limited needed for inquiry operation by front end (terminal device) query interface It property and sets property.After user clicks " submission " button, data query task is sent to rear end by front end.Wherein, The received data query task of receiving module 301 includes: the attribute and its attribute value of selection.For example, for determine advertisement When the target audience of marketing, a certain user includes: based on the data query task that the front end query interface for the system of choosing is submitted The attribute value of grd_lvl (membership grade) attribute, age (age) attribute and sex (gender) attribute and each attribute.
Assembling module 302, for appointing according to attribute configuration table and preset splicing rule are assembled with the data query It is engaged in corresponding SQL statement.
Wherein, the attribute configuration table is used to store the configuration information for all properties that front end query interface can be shown, Can include: label table name, attribute-name, the corresponding attribute type of each attribute, the corresponding splicing logical word of each attribute.The spelling Connecing rule includes the strictly all rules that are followed of splicing SQL statement, it may include: for the attribute with different attribute type, it is specified that It carries out splicing splicing keyword used with attribute value;For with it is different splicing logical words attributes constitute condition, Define the rule that each condition is spliced.
Wherein, a kind of optional embodiment of the assembled SQL statement of assembling module 302 includes: assembling module 302 according to data Attribute query attribute configuration table included by query task, to obtain corresponding attribute configuration information;Then, assembling module 302 are associated the corresponding attribute configuration information and preset splicing rule, and attribute and attribute value are spliced into item Part, then each condition is spliced into WHERE clause;Next, assembling module 302 by the WHERE clause and SELECT clause, FROM clause is spliced, to obtain the SQL statement for inquiring a label list.When it is implemented, assembling module 302 generates SQL statement corresponding with the data query task may for one (i.e. only inquire a label list in data), can also Can be multiple (inquiring the data in multiple label lists).
Enquiry module 303, for inquiring the label list in database according to the SQL statement, to obtain query result.
When it is implemented, multiple label lists can be stored in the database in order to improve data query speed.Also, with When the corresponding SQL statement of the data query task is multiple, enquiry module 303 can concurrently be inquired according to all SQL statements Multiple label lists in database, then according to the logical relation of all SQL statements determine each label list comprehensive inquiry as a result, And the comprehensive inquiry result is back to front end.
In embodiments of the present invention, by receiving module receive data query task, by assembling module assembly with it is described The corresponding SQL statement of data query task, can be dynamically generated SQL statement, without the SQL generation fixed in front end insertion Code, reduces the coupling of data query system front and back ends.Further, multiple label lists are concurrently inquired by enquiry module, The response speed that query time can be saved, improve data query system improves user experience.
Fig. 4 is the main modular schematic diagram of data query device according to another embodiment of the present invention.The embodiment of the present invention Data query device may be provided at server-side.As shown in figure 4, the data query device 400 of the embodiment of the present invention includes: to receive Module 401, writing module 402, assembling module 403, enquiry module 404.
Receiving module 401, for receiving data query task.Wherein, the data query task includes: the attribute of selection And its attribute value.
Writing module 402, for obtaining attribute type corresponding with the attribute of the selection in dependence allocation list, according to Attribute value in the data query task is converted into meeting SQL splicing requirement by the attribute type and preset write-in rule Storage format.
Wherein, the attribute configuration table includes: that all display module names of data query system, each display module are corresponding All properties name included by label table name, each display module, the attribute type of each attribute and splicing logical word.The Attribute class Type includes: Selective type, wide-style;The splicing logical word includes: AND, OR.
Wherein, said write rule based on writing module 402 includes: the category when the attribute in data query task Property type when being " selection " type, the corresponding attribute value of the attribute is written to " initial value " field of storage table;When an attribute When attribute type is " range " type, by " initial value " field of the left boundary value of attribute write-in storage table, and by the attribute Right boundary value write-in storage table " end value " field.In addition, said write is regular further include: for for " range " type If user does not limit the left boundary value of the attribute " initial value " field in storage table is written in left margin default value by attribute; If user does not limit the right boundary value of the attribute, " end value " field in storage table is written into right margin default value.
In embodiments of the present invention, it by the way that writing module 402 is arranged, has obtained meeting what SQL splicing required for storing The storage table of attribute value.The storage table can include: these fields of task identification, module name, attribute-name, initial value, end value Information.So, when carrying out SQL statement splicing, progress can be facilitated directly using the attribute value in the storage table SQL splicing.
Assembling module 403, for appointing according to attribute configuration table and preset splicing rule are assembled with the data query It is engaged in corresponding SQL statement, specifically includes:
Assembling module 403, for obtaining label table name corresponding to the attribute with the selection in dependence allocation list, and FROM clause is constructed based on the label table name.
Illustratively, as shown in table 1, when data query task includes the attribute in basic behavioral module, with the module In the corresponding label list of attribute it is entitled " lab1 ", assembling module 403 be directed to the label list building FROM clause are as follows: FROM lab1.When data query task includes the attribute in buying behavior module, label table name corresponding with the attribute in the module For " lab2 ", assembling module 403 is directed to the FROM clause of label list building are as follows: FROM lab2.
Assembling module 403 is also used to obtain Attribute class corresponding with the attribute of the selection from the attribute configuration table Type and splicing logical word;And the attribute of the selection and its attribute value are carried out according to the attribute type and the first splicing rule Splicing, to obtain condition.
Wherein, first splicing rule includes: when attribute type is " selection ", with " IN " based on assembling module 403 Attribute-name and attribute value are spliced, to be spliced into a condition;When attribute type is " range ", with " BETWEEN AND " splices attribute-name and attribute value, is spliced into a condition.
Assembling module 403 is also used to regular by the data query task according to the splicing logical word and the second splicing The condition of all properties of the middle same label table name of correspondence is spliced, to obtain WHERE clause.
Wherein, it is genuine condition (for example, " 1=1 " this condition) that the second splicing rule, which includes: preferentially by preset logic, It is stitched together with the condition for the attribute that all splicing logical words are " AND ", is spliced with constituting by splicing logical word " AND " Condition it is whole;By preset logic be false condition (for example, " 1=2 " this condition) and all splicing logical words are " OR " The condition of attribute be stitched together, to constitute condition entirety splice by splicing logical word " OR ";By described by splicing Logical word " OR " splicing condition entirely through splicing keyword " AND " splicing it is described by splicing logical word " AND " splicing Behind condition entirety.
Assembling module 403 is also used to SELECT clause, FROM clause and the WHERE clause carrying out assembly, to generate SQL statement.
Wherein, the SELECT clause can be determined by assembling module 403 according to the purpose of data query task.For example, working as When data query system is target user's inquiry system in advertisement marketing, the purpose of data query task is that inquiry target is used Family, therefore, the SELECT clause that assembling module 403 constructs are as follows: SELECT user_id.
Illustratively, when data query system is target user's inquiry system in advertisement marketing, 403 structure of assembling module That builds is used to inquire the SQL statement of a certain label list are as follows:
Enquiry module 404 is used for when SQL statement corresponding with the data query task is multiple, according to all SQL Sentence concurrently inquires multiple label lists in database, then determines each label list according to the logical relation of all SQL statements Comprehensive inquiry result.
Wherein, enquiry module 404 determines that the comprehensive inquiry result of each label list can according to the logical relation of all SQL statements If the logical relation for including: each SQL statement is " AND ", enquiry module 404 can take intersection to the query result of each label list, And using the intersection as final comprehensive inquiry result;If the logical relation of each SQL statement is " OR ", enquiry module 404 Union can be taken to the query result of each label list, and using the union as final comprehensive inquiry result.
Further, the data query device 400 of the embodiment of the present invention can also include: read module.Read module is used for In the attribute retrieval request for receiving front end, reading attributes allocation list, in order to which front end is according to reading result dynamic generation packet Include the front end query interface of multiple display modules;Wherein, each display module includes at least one attribute that can be selected.Tool When body is implemented, the corresponding relationship of the label list in the display module and database of front end query interface can be it is one-to-one, can also Think many-one.For example, the front end query interface for system of choosing includes: basis in the target audience to determine advertisement marketing Behavioral module, buying behavior module;Database includes: label list lab1, label list lab2.Also, basic behavioral module and mark It is corresponding to sign table lab1, buying behavior module is corresponding with label list lab2.
In embodiments of the present invention, it by the way that read module is arranged, can be read in the attribute retrieval request for receiving front end Attribute configuration table is taken, front end query interface is dynamically generated in order to which front end is based on reading result, reduces the coupling of front and back ends Degree.When developer needs to modify or delete some attribute, attribute configuration table only need to be modified, it is not necessary to modify front-end codes, make The iterative operation for the system of obtaining is more convenient, and iteration efficiency is improved.
The data query device of the embodiment of the present invention can dynamically generate SQL statement, and parallel based on each SQL statement Multiple label lists in database are inquired on ground, not only reduce the coupling of data query system front and back ends, and can save Query time, the response speed for improving data query system improve user experience.Further, the data of the embodiment of the present invention are looked into Device is ask by reading attributes allocation list, is convenient for front end dynamic generation front end query interface, further reduced system front and back ends The degree of coupling.
Fig. 5 is shown can be using the data query method of the embodiment of the present invention or the exemplary system of data query device Framework 500.
As shown in figure 5, system architecture 500 may include terminal device 501,502,503, network 504 and server 505. Network 504 between terminal device 501,502,503 and server 505 to provide the medium of communication link.Network 504 can be with Including various connection types, such as wired, wireless communication link or fiber optic cables etc..
User can be used terminal device 501,502,503 and be interacted by network 504 with server 505, to receive or send out Send message etc..Various telecommunication customer end applications, such as the application of shopping class, net can be installed on terminal device 501,502,503 The application of page browsing device, searching class application, instant messaging tools, mailbox client, social platform software etc..
Terminal device 501,502,503 can be the various electronic equipments with display screen and supported web page browsing, packet Include but be not limited to smart phone, tablet computer, pocket computer on knee and desktop computer etc..
Server 505 can be to provide the server of various services, such as utilize terminal device 501,502,503 to user The system of choosing browsed provides the back-stage management server supported.Back-stage management server can be to the inquiry request received Etc. data carry out the processing such as analyzing, and processing result (such as user information of selection) is fed back into terminal device.
It should be noted that data query method provided by the embodiment of the present invention is generally executed by server 505, accordingly Ground, data query device are generally positioned in server 505.
It should be understood that the number of terminal device, network and server in Fig. 5 is only schematical.According to realization need It wants, can have any number of terminal device, network and server.
Fig. 6 shows the structural schematic diagram for being suitable for the computer system 600 for the server for being used to realize the embodiment of the present invention. Computer system shown in Fig. 6 is only an example, should not function to the embodiment of the present invention and use scope bring it is any Limitation.
As shown in fig. 6, computer system 600 includes central processing unit (CPU) 601, it can be read-only according to being stored in Program in memory (ROM) 602 or be loaded into the program in random access storage device (RAM) 603 from storage section 608 and Execute various movements appropriate and processing.In RAM 603, also it is stored with system 600 and operates required various programs and data. CPU 601, ROM 602 and RAM 603 are connected with each other by bus 604.Input/output (I/O) interface 605 is also connected to always Line 604.
I/O interface 605 is connected to lower component: the importation 606 including keyboard, mouse etc.;It is penetrated including such as cathode The output par, c 607 of spool (CRT), liquid crystal display (LCD) etc. and loudspeaker etc.;Storage section 608 including hard disk etc.; And the communications portion 609 of the network interface card including LAN card, modem etc..Communications portion 609 via such as because The network of spy's net executes communication process.Driver 610 is also connected to I/O interface 605 as needed.Detachable media 611, such as Disk, CD, magneto-optic disk, semiconductor memory etc. are mounted on as needed on driver 610, in order to read from thereon Computer program be mounted into storage section 608 as needed.
Particularly, disclosed embodiment, the process described above with reference to flow chart may be implemented as counting according to the present invention Calculation machine software program.For example, embodiment disclosed by the invention includes a kind of computer program product comprising be carried on computer Computer program on readable medium, the computer program include the program code for method shown in execution flow chart.? In such embodiment, which can be downloaded and installed from network by communications portion 609, and/or from can Medium 611 is dismantled to be mounted.When the computer program is executed by central processing unit (CPU) 601, system of the invention is executed The above-mentioned function of middle restriction.
It should be noted that computer-readable medium shown in the present invention can be computer-readable signal media or meter Calculation machine readable storage medium storing program for executing either the two any combination.Computer readable storage medium for example can be --- but not Be limited to --- electricity, magnetic, optical, electromagnetic, infrared ray or semiconductor system, device or device, or any above combination.Meter The more specific example of calculation machine readable storage medium storing program for executing can include but is not limited to: have the electrical connection, just of one or more conducting wires Taking formula computer disk, hard disk, random access storage device (RAM), read-only memory (ROM), erasable type may be programmed read-only storage Device (EPROM or flash memory), optical fiber, portable compact disc read-only memory (CD-ROM), light storage device, magnetic memory device, Or above-mentioned any appropriate combination.In the present invention, computer readable storage medium can be it is any include or storage journey The tangible medium of sequence, the program can be commanded execution system, device or device use or in connection.And at this In invention, computer-readable signal media may include in a base band or as carrier wave a part propagate data-signal, Wherein carry computer-readable program code.The data-signal of this propagation can take various forms, including but unlimited In electromagnetic signal, optical signal or above-mentioned any appropriate combination.Computer-readable signal media can also be that computer can Any computer-readable medium other than storage medium is read, which can send, propagates or transmit and be used for By the use of instruction execution system, device or device or program in connection.Include on computer-readable medium Program code can transmit with any suitable medium, including but not limited to: wireless, electric wire, optical cable, RF etc. are above-mentioned Any appropriate combination.
Flow chart and block diagram in attached drawing are illustrated according to the system of various embodiments of the invention, method and computer journey The architecture, function and operation in the cards of sequence product.In this regard, each box in flowchart or block diagram can generation A part of one module, program segment or code of table, a part of above-mentioned module, program segment or code include one or more Executable instruction for implementing the specified logical function.It should also be noted that in some implementations as replacements, institute in box The function of mark can also occur in a different order than that indicated in the drawings.For example, two boxes succeedingly indicated are practical On can be basically executed in parallel, they can also be executed in the opposite order sometimes, and this depends on the function involved.Also it wants It is noted that the combination of each box in block diagram or flow chart and the box in block diagram or flow chart, can use and execute rule The dedicated hardware based systems of fixed functions or operations is realized, or can use the group of specialized hardware and computer instruction It closes to realize.
Being described in module involved in the embodiment of the present invention can be realized by way of software, can also be by hard The mode of part is realized.Described module also can be set in the processor, for example, can be described as: a kind of processor packet Include receiving module, assembling module, enquiry module.Wherein, the title of these modules is not constituted under certain conditions to the module The restriction of itself, for example, receiving module is also described as " receiving the module of data query task ".
As on the other hand, the present invention also provides a kind of computer-readable medium, which be can be Included in equipment described in above-described embodiment;It is also possible to individualism, and without in the supplying equipment.Above-mentioned calculating Machine readable medium carries one or more program, when said one or multiple programs are executed by the equipment, makes It obtains the equipment and executes following below scheme: receiving data query task;According to attribute configuration table and preset splicing rule it is assembled with The corresponding SQL statement of the data query task;The label list in database is inquired according to the SQL statement, to obtain inquiry As a result.
Above-mentioned specific embodiment, does not constitute a limitation on the scope of protection of the present invention.Those skilled in the art should be bright It is white, design requirement and other factors are depended on, various modifications, combination, sub-portfolio and substitution can occur.It is any Made modifications, equivalent substitutions and improvements etc. within the spirit and principles in the present invention, should be included in the scope of the present invention Within.

Claims (15)

1. a kind of data query method, which is characterized in that the described method includes:
Receive data query task;
According to attribute configuration table and the assembled SQL statement corresponding with the data query task of preset splicing rule;
The label list in database is inquired according to the SQL statement, to obtain query result.
2. the method according to claim 1, wherein the data query task include: selection attribute and its Attribute value;The attribute configuration table includes: label table name, attribute-name, attribute type, splicing logical word;The splicing rule packet It includes: the first splicing rule and the second splicing rule;
It is described according to attribute configuration table and the preset assembled SQL statement corresponding with the data query task of splicing rule Step includes: that attribute type corresponding with the attribute of the selection and splicing logical word are obtained from the attribute configuration table;Root The attribute of the selection is spliced with its attribute value according to the attribute type and the first splicing rule, to obtain condition;Root The all properties of same label table name will be corresponded in the data query task according to the splicing logical word and the second splicing rule The condition spliced, to obtain WHERE clause;SELECT clause, FROM clause and the WHERE clause are spelled Dress, to generate SQL statement.
3. according to the method described in claim 2, it is characterized in that, the first splicing rule includes: when attribute type is " choosing Select " when, the splicing keyword of attribute and attribute value is " IN ";When attribute type is " range ", the splicing of attribute and attribute value Keyword is " BETWEENAND ".
4. according to the method described in claim 3, it is characterized in that, the second splicing rule includes: preferentially to patrol preset Collecting is that genuine condition and all conditions for splicing the attribute that logical words are " AND " are stitched together, and is patrolled with constituting by splicing The condition for collecting word " AND " splicing is whole;By preset logic be false condition and all splicing logical words are the attribute of " OR " The condition is stitched together, whole to constitute the condition spliced by splicing logical word " OR ";It will be described by splicing logical word The condition of " OR " splicing is whole in the condition by splicing logical word " AND " splicing entirely through splicing keyword " AND " splicing Behind body.
5. according to the method described in claim 2, it is characterized in that, the mark inquired according to the SQL statement in database The step of label table includes:
When SQL statement corresponding with the data query task is multiple, database is concurrently inquired according to all SQL statements In multiple label lists, the comprehensive inquiry result of each label list is then determined according to the logical relation of all SQL statements.
6. according to any method of claim 2 to 5, which is characterized in that described according to attribute configuration table and default Splicing rule assembled SQL statement corresponding with the data query task the step of before, the method also includes:
Attribute type corresponding with the attribute of the selection is obtained from the attribute configuration table, according to the attribute type and in advance If write-in rule the attribute value in the data query task is converted into meeting the storage format that SQL splicing requires.
7. according to the method described in claim 6, it is characterized in that, the preset write-in rule includes:
When the attribute type of attribute is " selection ", by " initial value " field of the corresponding attribute value write-in storage table of the attribute; When the attribute type of attribute is " range ", by " initial value " field of the left boundary value write-in storage table of the attribute, by the category Property right boundary value write-in storage table " end value " field.
8. the method according to claim 1, wherein before the reception data query task the step of, institute State method further include:
In the attribute retrieval request for receiving front end, reading attributes allocation list, in order to which front end is raw according to result dynamic is read At the front end query interface including multiple display modules;Wherein, each display module includes at least one category that can be selected Property.
9. a kind of data query device, which is characterized in that described device includes:
Receiving module, for receiving data query task;
Assembling module, for assembled corresponding with the data query task according to attribute configuration table and preset splicing rule SQL statement;
Enquiry module, for inquiring the label list in database according to the SQL statement, to obtain query result.
10. device according to claim 9, which is characterized in that the data query task include: selection attribute and its Attribute value;The attribute configuration table includes: label table name, attribute-name, attribute type, splicing logical word;The splicing rule packet It includes: the first splicing rule and the second splicing rule;
The assembling module is assembled corresponding with the data query task according to attribute configuration table and preset splicing rule SQL statement includes: that attribute type corresponding with the attribute of the selection and spelling are obtained in the assembling module dependence allocation list Connect logical word;The assembling module is according to the attribute type and the regular attribute and its attribute value by the selection of the first splicing Spliced, to obtain condition;The assembling module looks into the data according to the splicing logical word and the second splicing rule The condition that all properties of same label table name are corresponded in inquiry task is spliced, to obtain WHERE clause;The assembly SELECT clause, FROM clause and the WHERE clause are carried out assembly by module, to generate SQL statement.
11. device according to claim 10, which is characterized in that the enquiry module inquires number according to the SQL statement Include: according to the label list in library
When SQL statement corresponding with the data query task is multiple, the enquiry module is parallel according to all SQL statements Multiple label lists in database are inquired on ground, then determine that the synthesis of each label list is looked into according to the logical relation of all SQL statements Ask result.
12. device described in 0 or 11 according to claim 1, which is characterized in that described device further include:
Writing module, for obtaining attribute type corresponding with the attribute of the selection from the attribute configuration table, according to institute It states attribute type and the attribute value in the data query task is converted into meeting what SQL splicing required by preset write-in rule Storage format.
13. device according to claim 9, which is characterized in that described device further include:
Read module, in the attribute retrieval request for receiving front end, reading attributes allocation list, in order to which front end is according to reading Taking result dynamic generation includes the front end query interface of multiple display modules;Wherein, each display module includes at least one energy The attribute being enough selected.
14. a kind of server characterized by comprising
One or more processors;
Storage device, for storing one or more programs,
When one or more of programs are executed by one or more of processors, so that one or more of processors are real The now method as described in any in claim 1 to 8.
15. a kind of computer-readable medium, is stored thereon with computer program, which is characterized in that described program is held by processor The method as described in any in claim 1 to 8 is realized when row.
CN201711042305.9A 2017-10-30 2017-10-30 Data query method and device Active CN109947788B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201711042305.9A CN109947788B (en) 2017-10-30 2017-10-30 Data query method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201711042305.9A CN109947788B (en) 2017-10-30 2017-10-30 Data query method and device

Publications (2)

Publication Number Publication Date
CN109947788A true CN109947788A (en) 2019-06-28
CN109947788B CN109947788B (en) 2021-10-15

Family

ID=67004006

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201711042305.9A Active CN109947788B (en) 2017-10-30 2017-10-30 Data query method and device

Country Status (1)

Country Link
CN (1) CN109947788B (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112199577A (en) * 2020-12-09 2021-01-08 浙江口碑网络技术有限公司 Data query method and device and electronic equipment
WO2021189195A1 (en) * 2020-03-23 2021-09-30 深圳市欢太科技有限公司 Data querying method and apparatus, server, and storage medium

Citations (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20010013036A1 (en) * 2000-02-09 2001-08-09 International Business Machines Corporation Interaction with query data
US20060155689A1 (en) * 2004-07-23 2006-07-13 Oracle International Corporation Web-based user interface for searching metadata-driven relational databases
US20100082656A1 (en) * 2008-09-24 2010-04-01 Yi Jing Methods and apparatus for generating dynamic program files based on input queries that facilitate use of persistent query services
US20130006966A1 (en) * 2011-06-09 2013-01-03 International Business Machines Corporation Relational Query Planning for Non-Relational Data Sources
CN103093000A (en) * 2013-02-25 2013-05-08 用友软件股份有限公司 Database query modeling system and database query modeling method
CN105205104A (en) * 2015-08-26 2015-12-30 成都布林特信息技术有限公司 Cloud platform data acquisition method
CN105224544A (en) * 2014-05-30 2016-01-06 北大方正集团有限公司 A kind of data editing method of database and device
CN105975617A (en) * 2016-05-20 2016-09-28 北京京东尚科信息技术有限公司 Multi-partition-table inquiring and processing method and device
CN106775770A (en) * 2017-01-16 2017-05-31 兴唐通信科技有限公司 The lookup method of query statement is built based on category information
CN107169033A (en) * 2017-04-17 2017-09-15 东北大学 Relation data enquiring and optimizing method with parallel framework is changed based on data pattern
CN107273525A (en) * 2017-06-23 2017-10-20 上海携程商务有限公司 Functional expression querying method and system

Patent Citations (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20010013036A1 (en) * 2000-02-09 2001-08-09 International Business Machines Corporation Interaction with query data
US20060155689A1 (en) * 2004-07-23 2006-07-13 Oracle International Corporation Web-based user interface for searching metadata-driven relational databases
US20100082656A1 (en) * 2008-09-24 2010-04-01 Yi Jing Methods and apparatus for generating dynamic program files based on input queries that facilitate use of persistent query services
US20130006966A1 (en) * 2011-06-09 2013-01-03 International Business Machines Corporation Relational Query Planning for Non-Relational Data Sources
CN103093000A (en) * 2013-02-25 2013-05-08 用友软件股份有限公司 Database query modeling system and database query modeling method
CN105224544A (en) * 2014-05-30 2016-01-06 北大方正集团有限公司 A kind of data editing method of database and device
CN105205104A (en) * 2015-08-26 2015-12-30 成都布林特信息技术有限公司 Cloud platform data acquisition method
CN105975617A (en) * 2016-05-20 2016-09-28 北京京东尚科信息技术有限公司 Multi-partition-table inquiring and processing method and device
CN106775770A (en) * 2017-01-16 2017-05-31 兴唐通信科技有限公司 The lookup method of query statement is built based on category information
CN107169033A (en) * 2017-04-17 2017-09-15 东北大学 Relation data enquiring and optimizing method with parallel framework is changed based on data pattern
CN107273525A (en) * 2017-06-23 2017-10-20 上海携程商务有限公司 Functional expression querying method and system

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
MATTHIAS NICOLA: "《Generating SQL/XML query and update statements》", 《ACM》 *
俞晓: "《基于SQL Server的动态多条件查询方案》", 《电脑编程技巧与维护》 *
周千明等: "《通用动态多条件查询方法的研究与实现》", 《电脑知识与技术》 *

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2021189195A1 (en) * 2020-03-23 2021-09-30 深圳市欢太科技有限公司 Data querying method and apparatus, server, and storage medium
CN112199577A (en) * 2020-12-09 2021-01-08 浙江口碑网络技术有限公司 Data query method and device and electronic equipment
CN112199577B (en) * 2020-12-09 2021-04-02 浙江口碑网络技术有限公司 Data query method and device and electronic equipment

Also Published As

Publication number Publication date
CN109947788B (en) 2021-10-15

Similar Documents

Publication Publication Date Title
JP6736173B2 (en) Method, system, recording medium and computer program for natural language interface to a database
CN102053983B (en) Method, system and device for querying vertical search
CN106326243B (en) Data processing method and device
US7827164B2 (en) System for obtaining, managing and providing retrieved content and a system thereof
CN111177231A (en) Report generation method and report generation device
CN109726295A (en) Brand knowledge map display methods, device, figure server and storage medium
CN109947788A (en) Data query method and apparatus
CN107798622B (en) Method and device for identifying user intention
CN112347147A (en) Information pushing method and device based on user association relationship and electronic equipment
CN109683998A (en) Internationalize implementation method, device and system
CN106919711B (en) Method and device for labeling information based on artificial intelligence
CN111382279A (en) Order examination method and device
CN113157964A (en) Method and device for searching data set through voice and electronic equipment
CN108958959A (en) The method and apparatus for detecting hive tables of data
CN109191158B (en) Processing method and processing equipment for user portrait label data
CN111522927A (en) Entity query method and device based on knowledge graph
CN110472207A (en) List generation method and device
CN112016017A (en) Method and device for determining characteristic data
CN107291923B (en) Information processing method and device
CN108959294A (en) A kind of method and apparatus accessing search engine
CN110309142A (en) The method and apparatus of regulation management
CN110109947A (en) The method and apparatus for extracting data
CN110555070B (en) Method and apparatus for outputting information
CN109857838B (en) Method and apparatus for generating information
US20220164377A1 (en) Method and apparatus for distributing content across platforms, device 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