CN107239536A - Business datum querying method, device, system, storage medium and electronic equipment - Google Patents
Business datum querying method, device, system, storage medium and electronic equipment Download PDFInfo
- Publication number
- CN107239536A CN107239536A CN201710401508.6A CN201710401508A CN107239536A CN 107239536 A CN107239536 A CN 107239536A CN 201710401508 A CN201710401508 A CN 201710401508A CN 107239536 A CN107239536 A CN 107239536A
- Authority
- CN
- China
- Prior art keywords
- service data
- business datum
- user basic
- information
- basic information
- 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.)
- Pending
Links
Classifications
-
- 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/24—Querying
- G06F16/245—Query processing
-
- 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/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
Abstract
The invention discloses a kind of business datum querying method, device, system, storage medium and electronic equipment, this method includes：Query statement is received, query statement includes user basic information, at least one service data information and querying condition；Inquired about respectively in the staqtistical data base for prestoring business datum according to user basic information and service data information, generation user basic information set and service data information set；According to querying condition, user basic information set and service data information set are subjected to set operation, business datum Query Information is generated；Return to business datum Query Information.Implement the present invention, the data message for needing to inquire about is divided into user basic information and service data information, then inquired about respectively in the staqtistical data base for prestoring business datum, generate user basic information set and service data information set, row set of going forward side by side computing, business datum Query Information is generated, various dimensions business datum query composition is realized.
Description
Technical field
The present invention relates to data statistics field, more particularly to a kind of business datum querying method, device, system, storage Jie
Matter and electronic equipment.
Background technology
During financial company's operation and management, in order to understand the investment situation of user, it usually needs all kinds of use of inquiry
The information at family carries out statistics screening.Current business datum querying method includes following several：
1) business datum inquiry is carried out using ElasticSearch search servers, but ElasticSearch search takes
Business device can only carry out single dimension inquiry, it is impossible to carry out multi-dimensional data query composition, it is impossible to meet the demand of statistics class screening；
2) business datum inquiry is carried out using Hadoop homebrews Hive, but uses Hive to carry out multi-dimensional data group
Need at least three servers to be transmitted instruction when closing inquiry, then collected, time-consuming, and speed is slow, it is impossible to meets high frequency
Rate is inquired about；
3) business datum inquiry is carried out using Spark, but Spark is too high to the configuration requirement of server, increases cost.
The content of the invention
It is an object of the invention to overcome prior art can not realize quickly, at low cost carry out various dimensions business datum group
There is provided a kind of business datum querying method, device, system, storage medium and electronic equipment for the deficiency of conjunction inquiry.
Technical scheme provides a kind of business datum querying method, including：
Receive query statement, the query statement include user basic information, at least one service data information and
Querying condition；
The statistical number of business datum is being prestored according to the user basic information and the service data information respectively
Inquired about according to storehouse, generation user basic information set and service data information set；
According to the querying condition, row set is entered into the user basic information set and the service data information set
Computing, generates business datum Query Information；
Return to the business datum Query Information.
Further, it is described according to the querying condition, the user basic information set and the business datum are believed
Breath set carries out set operation, generates business datum Query Information, specifically includes：
The user basic information set and the service data information set are calculated into common factor, intersection and/or difference set, it is raw
Into the business datum Query Information.
Further, described to receive query statement, the query statement includes user basic information, at least one business
Data message and querying condition, include before：
The string tag of the user basic information and the service data information is converted into corresponding digital label,
Generate the list of user basic information digital label and service data information digital label list；
The user basic information digital label list and the service data information digital label list are stored to institute
State staqtistical data base.
Further, it is described that business is being prestored according to the user basic information and the service data information respectively
The staqtistical data base of data is inquired about, generation user basic information set and service data information set, is specifically included：
Existed respectively according to the user basic information digital label list and the service data information digital label list
The staqtistical data base for prestoring business datum is inquired about, generation user basic information set and service data information set.
Technical scheme provides a kind of business datum inquiry unit, including：
Query statement receiving module, for receiving query statement, the query statement includes user basic information, at least
One service data information and querying condition；
Enquiry module, for prestoring business respectively according to the user basic information and the service data information
The staqtistical data base of data is inquired about, generation user basic information set and service data information set；
Statistical module, for according to the querying condition, the user basic information set and the business datum to be believed
Breath set carries out set operation, generates business datum Query Information；
Module is returned to, for returning to the business datum Query Information.
Further, the statistical module, specifically for：
The user basic information set and the service data information set are calculated into common factor, intersection and/or difference set, it is raw
Into the business datum Query Information.
Further, the business datum inquiry unit also includes：
Modular converter, for the string tag of the user basic information and the service data information to be converted into pair
The digital label answered, generation user basic information digital label list and service data information digital label list；
Memory module, for by the user basic information digital label list and the service data information digital label
List is stored to the staqtistical data base.
Further, the statistical module, specifically for：
Existed respectively according to the user basic information digital label list and the service data information digital label list
The staqtistical data base for prestoring business datum is inquired about, generation user basic information set and service data information set.
Technical scheme provides a kind of business datum inquiry system, including foregoing business datum inquiry dress
Put and page server, the business datum inquiry unit is communicated to connect with the page server, wherein：
Page server, sends to business datum inquiry dress for input inquiry instruction, and by the query statement
Put and show the business datum Query Information that the business datum inquiry unit is returned.
Further, the page server, is additionally operable to：
The user basic information and at least one described service data information are stored in advance in drop-down list list.
Technical scheme provides a kind of storage medium, and the storage medium stores computer instruction, works as computer
When performing the computer instruction, all steps for performing foregoing business datum querying method.
Technical scheme provides a kind of electronic equipment, including：
At least one processor；And,
The memory being connected with least one described processor communication；Wherein,
The memory storage has can be by the instruction of one computing device, and the instruction is by described at least one
Manage device to perform, so that at least one described processor can：
Receive query statement, the query statement include user basic information, at least one service data information and
Querying condition；
The statistical number of business datum is being prestored according to the user basic information and the service data information respectively
Inquired about according to storehouse, generation user basic information set and service data information set；
According to the querying condition, row set is entered into the user basic information set and the service data information set
Computing, generates business datum Query Information；
Return to the business datum Query Information.
Further, it is described according to the querying condition, the user basic information set and the business datum are believed
Breath set carries out set operation, generates business datum Query Information, specifically includes：
The user basic information set and the service data information set are calculated into common factor, intersection and/or difference set, it is raw
Into the business datum Query Information.
Further, described to receive query statement, the query statement includes user basic information, at least one business
Data message and querying condition, include before：
The string tag of the user basic information and the service data information is converted into corresponding digital label,
Generate the list of user basic information digital label and service data information digital label list；
The user basic information digital label list and the service data information digital label list are stored to institute
State staqtistical data base.
Further, it is described that business is being prestored according to the user basic information and the service data information respectively
The staqtistical data base of data is inquired about, generation user basic information set and service data information set, is specifically included：
Existed respectively according to the user basic information digital label list and the service data information digital label list
The staqtistical data base for prestoring business datum is inquired about, generation user basic information set and service data information set.
After adopting the above technical scheme, having the advantages that：By the way that the data message for needing to inquire about is divided into user
Essential information and service data information, are then prestoring business number respectively according to user basic information and service data information
According to staqtistical data base inquired about, generation user basic information set and service data information set, row set of going forward side by side computing,
Business datum Query Information is generated, inquiry velocity is improved, realizes that carrying out the combination of various dimensions business datum quickly, at low cost looks into
Ask, meet user's request.
Brief description of the drawings
Referring to accompanying drawing, the disclosure will be easier to understand.It should be understood that：These accompanying drawings are merely illustrative
Purpose, and be not intended to and protection scope of the present invention be construed as limiting.In figure：
Fig. 1 is a kind of schematic flow sheet for business datum querying method that one embodiment of the invention is provided；
Fig. 2 is a kind of schematic flow sheet for business datum querying method that alternative embodiment of the present invention is provided；
Fig. 3 is a kind of schematic flow sheet for business datum querying method that another embodiment of the present invention is provided；
Fig. 4 is a kind of structural representation for business datum inquiry unit that one embodiment of the invention is provided；
Fig. 5 is a kind of structural representation for business datum inquiry unit that alternative embodiment of the present invention is provided；
Fig. 6 is a kind of structural representation for business datum inquiry unit that another embodiment of the present invention is provided；
Fig. 7 is a kind of structural representation for business datum inquiry system that one embodiment of the invention is provided；
Fig. 8 is a kind of hardware knot of the electronic equipment for execution business datum querying method that ninth embodiment of the invention is provided
Structure schematic diagram.
Embodiment
Below in conjunction with the accompanying drawings come further illustrate the present invention embodiment.
It is readily appreciated that, technique according to the invention scheme, in the case where not changing true spirit, the general skill of this area
Various structures mode and implementation that art personnel can mutually replace.Therefore, detailed description below and accompanying drawing are only
To the exemplary illustration of technical scheme, and it is not to be construed as the whole of the present invention or is considered as to inventive technique scheme
Define or limit.
Mention in this manual or up, down, left, right, before and after, front, the back side, top, the bottom that may mention etc.
Orientation term is defined relative to the construction shown in each accompanying drawing, and they are relative concepts, and it is therefore possible to can root
Correspondingly changed according to its residing diverse location, different use states.So, also should not be by these or others side
Position term is construed to restricted term.
Embodiment one
Fig. 1 show a kind of schematic flow sheet of business datum querying method of one embodiment of the invention offer, including：
Step S101：Query statement is received, query statement, which includes user basic information, at least one business datum, to be believed
Breath and querying condition；
Step S102：The statistical number of business datum is being prestored according to user basic information and service data information respectively
Inquired about according to storehouse, generation user basic information set and service data information set；
Step S103：According to querying condition, row set fortune is entered into user basic information set and service data information set
Calculate, generate business datum Query Information；
Step S104：Return to business datum Query Information.
Specifically, user basic information includes the one-to-one letters such as ID, age, registration date, account balance, address
Breath, service data information includes a pair of multi informations such as account information, investment attribute, returned money rate.It regard user basic information as one
Individual dimension list, forms one group of group, and each service data information forms multigroup group, often respectively as a dimension list
Group group in include multiple screening fields, such as user basic information group include age field, be more than, be less than, equal to field,
Age numeric field etc..All kinds of statistical informations, the number that such as user's returned money is counted daily have been prestored in staqtistical data base
It is believed that breath etc., when business datum statistic device receives query statement, user basic information and industry in query statement
Business data message difference query statistic database, generation user basic information set and service data information set, and collected
Computing is closed, business datum Query Information is generated, and returns to business datum Query Information to page server, passes through page server
Business datum Query Information is shown, so as to realize various dimensions business datum query composition statistical function.
By implementing the embodiment of the present invention, by the way that the data message for needing to inquire about is divided into user basic information and business number
It is believed that breath, then enters in the staqtistical data base for prestoring business datum respectively according to user basic information and service data information
Row inquiry, generation user basic information set and service data information set, row set of going forward side by side computing, generation business datum inquiry
Information, improves inquiry velocity, and realization is quick, carry out various dimensions business datum query composition at low cost, meets user's request.
Embodiment two
Fig. 2 show a kind of schematic flow sheet for business datum querying method that alternative embodiment of the present invention is provided, including：
Step S201：Query statement is received, query statement, which includes user basic information, at least one business datum, to be believed
Breath and querying condition；
Step S202：The statistical number of business datum is being prestored according to user basic information and service data information respectively
Inquired about according to storehouse, generation user basic information set and service data information set；
Step S203：User basic information set and service data information set are calculated into common factor, intersection and/or difference set,
Generate business datum Query Information；
Step S204：Return to business datum Query Information.
Specifically, illustrating the workflow of the embodiment of the present invention below by way of example：
To inquire about the age at 22 years old, and the user for throwing more than 20000 yuan to March 31 on March 1st, 2017 is
Example, two SQL statements are split into by this querying condition：A, inquiry age are equal to the people of 22 years old, the use in page server
" age ", " being equal to ", " 22 " field are selected in the essential information group of family；B, inquiry were thrown on March 1st, 2017 on the 31st to March
More than 20000 yuan, selection " investment time ", " between ", " 2017-03- in the service data information group in page server
01 to 2017-03-31 ", " any one investment amount ", " being more than ", " 20000 " field.Then looked into according to the two SQL statements
Staqtistical data base is ask, user basic information set A and service data information set B is generated, " A and B ", " A or B " is used
And/or " the non-B " querying conditions of A calculate common factor, intersection and/or difference set, generate business datum Query Information, and be back to page clothes
Business device, business datum Query Information is shown by page server, so as to realize that various dimensions business datum query composition counts work(
Energy.
Implement the embodiment of the present invention, by the way that the data message for needing to inquire about is divided into user basic information and business datum letter
Breath, is then looked into the staqtistical data base for prestoring business datum respectively according to user basic information and service data information
Ask, generation user basic information set and service data information set, row set of going forward side by side computing, generation business datum inquiry letter
Breath, improves inquiry velocity, and realization is quick, carry out various dimensions business datum query composition at low cost, meets user's request.
Embodiment three
Fig. 3 show a kind of schematic flow sheet of business datum querying method of another embodiment of the present invention offer, including：
Step S301：The string tag of user basic information and service data information is converted into corresponding numeral mark
Label, generation user basic information digital label list and service data information digital label list；
Step S302：The list of user basic information digital label and service data information digital label list are stored to system
Count storehouse；
Step S303：Query statement is received, query statement, which includes user basic information, at least one business datum, to be believed
Breath and querying condition；
Step S304：Existed respectively according to the list of user basic information digital label and the list of service data information digital label
The staqtistical data base for prestoring business datum is inquired about, generation user basic information set and service data information set；
Step S305：User basic information set and service data information set are calculated into common factor, intersection and/or difference set,
Generate business datum Query Information；
Step S306：Return to business datum Query Information.
Specifically, the label for taking the larger character string type of database space is converted into number by business datum inquiry unit
Word label, the Chinese characters such as the user UserId of 36 character string types or string tag is converted into the tag ID of numeral, and is formed
" province ", is such as converted into by the one-to-one list of user basic information digital label and service data information digital label list
" 13 ", use " 13 " label to replace " province " when being inquired about.Using the Load orders in MySQL, by user basic information
Content in digital label list and service data information digital label list is quickly loaded into database table, for example, create
Table, title is user, a field username；Current have a db.xlsx files, content be with the separated user name in space,
For example：11 12 13.This document is loaded into tables of data user, order is used：
Load data local infile " db file paths " into table user；
Implement the embodiment of the present invention, pass through the user basic information and service data information larger by database space is taken
String tag be converted into digital label, reduce the memory space of database, and improve inquiry velocity, realize it is quick, low into
It is local to carry out various dimensions business datum query composition, meet user's request.
Example IV
Fig. 4 show a kind of structural representation of business datum inquiry unit of one embodiment of the invention offer, including：
Query statement receiving module 41, for receiving query statement, query statement includes user basic information, at least one
Individual service data information and querying condition；
Enquiry module 42, for prestoring business datum respectively according to user basic information and service data information
Staqtistical data base is inquired about, generation user basic information set and service data information set；
Statistical module 43, for according to querying condition, user basic information set and service data information set to be carried out
Set operation, generates business datum Query Information；
Module 44 is returned to, for returning to business datum Query Information.
Implement the embodiment of the present invention, by the way that the data message for needing to inquire about is divided into user basic information and business datum letter
Breath, is then looked into the staqtistical data base for prestoring business datum respectively according to user basic information and service data information
Ask, generation user basic information set and service data information set, row set of going forward side by side computing, generation business datum inquiry letter
Breath, improves inquiry velocity, and realization is quick, carry out various dimensions business datum query composition at low cost, meets user's request.
Embodiment five
Fig. 5 show a kind of structural representation for business datum inquiry unit that alternative embodiment of the present invention is provided, including：
Query statement receiving module 51, for receiving query statement, query statement includes user basic information, at least one
Individual service data information and querying condition；
Enquiry module 52, for prestoring business datum respectively according to user basic information and service data information
Staqtistical data base is inquired about, generation user basic information set and service data information set；
Statistical module 53, for essential information set and service data information set to be calculated into common factor, intersection and/or difference
Collection, generates business datum Query Information；
Module 54 is returned to, for returning to business datum Query Information.
Implement the embodiment of the present invention, by the way that the data message for needing to inquire about is divided into user basic information and business datum letter
Breath, is then looked into the staqtistical data base for prestoring business datum respectively according to user basic information and service data information
Ask, generation user basic information set and service data information set, row set of going forward side by side computing, generation business datum inquiry letter
Breath, improves inquiry velocity, and realization is quick, carry out various dimensions business datum query composition at low cost, meets user's request.
Embodiment six
Fig. 6 show a kind of structural representation of business datum inquiry unit of another embodiment of the present invention offer, including：
Modular converter 61, for user basic information and service data information to be converted into corresponding digital label, generation
The list of user basic information digital label and service data information digital label list；
Memory module 62, for the list of user basic information digital label and service data information digital label list to be deposited
Store up to staqtistical data base；
Query statement receiving module 63, for receiving query statement, query statement includes user basic information, at least one
Individual service data information and querying condition；
Enquiry module 64, for according to the list of user basic information digital label and service data information digital label list
Inquired about respectively in the staqtistical data base for prestoring business datum, generation user basic information set and service data information
Set；
Statistical module 65, for user basic information set and service data information set are calculated occur simultaneously, intersection and/or
Difference set, generates business datum Query Information；
Module 66 is returned to, for returning to business datum Query Information.
Implement the embodiment of the present invention, pass through the user basic information and service data information larger by database space is taken
String tag be converted into digital label, reduce the memory space of database, and improve inquiry velocity, realize it is quick, low into
It is local to carry out various dimensions business datum query composition, meet user's request.
Embodiment seven
Fig. 7 show a kind of business datum inquiry system of one embodiment of the invention offer, including foregoing business
Data query arrangement 71 and page server 72, business datum inquiry unit 71 are communicated to connect with page server 72, wherein：
Page server 72, for input inquiry instruction, and query statement is sent to the He of business datum inquiry unit 71
Show the business datum Query Information that business datum inquiry unit 71 is returned.
Preferably, page server 72, are additionally operable to：
User basic information and at least one service data information are stored in advance in drop-down list list.
Implement the embodiment of the present invention, by the way that the data message for needing to inquire about is divided into user basic information and business datum letter
Breath, is then looked into the staqtistical data base for prestoring business datum respectively according to user basic information and service data information
Ask, generation user basic information set and service data information set, row set of going forward side by side computing, generation business datum inquiry letter
Breath, improves inquiry velocity, and realization is quick, carry out various dimensions business datum query composition at low cost, meets user's request.
Embodiment eight
Eighth embodiment of the invention provides a kind of storage medium, storage medium storage computer instruction, when computer is held
During row computer instruction, all steps for performing foregoing business datum querying method.
Embodiment nine
Fig. 8 show a kind of the hard of the electronic equipment of execution business datum querying method of ninth embodiment of the invention offer
Part structural representation, it mainly includes：At least one processor 81；And, with depositing that at least one processor 81 is communicated to connect
Reservoir 82；Wherein, the memory 82 is stored with the instruction that can be performed by a processor 81, instructs by least one processor
81 perform, so that at least one processor 81 is able to carry out method flow as shown in Figure 1-Figure 3.
Performing the electronic equipment of business datum querying method can also include：Input unit 83 and output device 84.
Processor 81, memory 82, input unit 83 and output device 84 can be connected by bus or other modes,
In Fig. 8 exemplified by being connected by bus.
Memory 82 is as a kind of non-volatile computer readable storage medium storing program for executing, available for storage non-volatile software journey
Business datum querying method in sequence, non-volatile computer executable program and module, such as the embodiment of the present application is corresponding
Programmed instruction/module, for example, query statement receiving module, inquiry mould shown in method flow, Fig. 4-Fig. 6 shown in Fig. 1-Fig. 3
Block, statistical module, return module, modular converter and memory module.Processor 81 is stored in non-in memory 82 by operation
Volatibility software program, instruction and module, so as to perform various function application and data processing, that is, realize above-described embodiment
In business datum querying method.
Memory 82 can include storing program area and storage data field, wherein, storing program area can storage program area,
Application program required at least one function；Storage data field can storage service data query arrangement use created number
According to etc..In addition, memory 82 can include high-speed random access memory, nonvolatile memory can also be included, for example extremely
A few disk memory, flush memory device or other non-volatile solid state memory parts.In certain embodiments, memory
82 is optional including the memory remotely located relative to processor 81, and these remote memories can pass through network connection to execution
The device of business datum querying method.The example of above-mentioned network includes but is not limited to internet, intranet, LAN, shifting
Dynamic communication network and combinations thereof.
The user that input unit 83 can receive input clicks on, and produce with the user of business datum inquiry unit set with
And the relevant signal input of function control.Output device 84 may include the display devices such as display screen.
It is stored in memory 82, is run when by one or more processor 81 in one or more of modules
When, perform the business datum querying method in above-mentioned any means embodiment.
The said goods can perform the method that the embodiment of the present application is provided, and possesses the corresponding functional module of execution method and has
Beneficial effect.Not ins and outs of detailed description in the present embodiment, reference can be made to the method that the embodiment of the present application is provided.
The electronic equipment of the embodiment of the present invention exists in a variety of forms, includes but is not limited to：
(1) electronic control unit (Electronic Control Unit, ECU) is also known as " car running computer ", " vehicle-mounted computer "
Deng.It is main by microprocessor (CPU), memory (ROM, RAM), input/output interface (I/O), analog-digital converter (A/D) and
The large scale integrated circuits such as shaping, driving are constituted.
(2) mobile communication equipment:The characteristics of this kind equipment is that possess mobile communication function, and to provide speech, data
Communicate as main target.This Terminal Type includes：Smart mobile phone (such as iPhone), multimedia handset, feature mobile phone, and it is low
Hold mobile phone etc..
(3) super mobile personal computer equipment：This kind equipment belongs to the category of personal computer, there is calculating and processing work(
Can, typically also possess mobile Internet access characteristic.This Terminal Type includes：PDA, MID and UMPC equipment etc..
(4) portable entertainment device：This kind equipment can show and play content of multimedia.The kind equipment includes：Audio,
Video player (such as iPod), handheld device, e-book, and intelligent toy and portable car-mounted navigation equipment.
(5) server：The equipment for providing the service of calculating, the composition of server is total including processor, hard disk, internal memory, system
Line etc., server is similar with general computer architecture, but is due to need to provide highly reliable service, therefore in processing energy
Require higher in terms of power, stability, reliability, security, scalability, manageability.
(6) other electronic installations with data interaction function.
In addition, the logical order in above-mentioned memory 82 can be realized by the form of SFU software functional unit and is used as solely
Vertical production marketing in use, can be stored in a computer read/write memory medium.Understood based on such, this hair
The part or the part of the technical scheme that bright technical scheme substantially contributes to prior art in other words can be with soft
The form of part product is embodied, and the computer software product is stored in a storage medium, including some instructions are to make
Obtain a mobile terminal (can be personal computer, server, or network equipment etc.) and perform each embodiment institute of the invention
State all or part of step of method.And foregoing storage medium includes：USB flash disk, mobile hard disk, read-only storage (ROM, Read-
Only Memory), random access memory (RAM, Random Access Memory), magnetic disc or CD etc. are various can be with
The medium of store program codes.
Device embodiment described above is only schematical, wherein the unit illustrated as separating component can
To be or may not be physically separate, the part shown as unit can be or may not be physics list
Member, you can with positioned at a place, or can also be distributed on multiple NEs.It can be selected according to the actual needs
In some or all of module realize the purpose of scheme of the embodiment of the present invention.Those of ordinary skill in the art are not paying wound
In the case of the work for the property made, you can to understand and implement.
Through the above description of the embodiments, those skilled in the art can be understood that each embodiment can
Realized by the mode of software plus required common hardware server, naturally it is also possible to pass through hardware.Understood based on such,
The part that above-mentioned technical proposal substantially contributes to prior art in other words can be embodied in the form of software product,
The computer software product can be stored in a computer-readable storage medium, such as ROM/RAM, magnetic disc, CD, including some
Instruction is to cause a computer equipment (can be personal computer, server, or network equipment etc.) to perform each reality
Apply the method described in some parts of example or embodiment.
Finally it should be noted that：Above example is only limited to the technical scheme for illustrating the embodiment of the present invention, rather than to it
System；Although the embodiment of the present invention is described in detail with reference to the foregoing embodiments, one of ordinary skill in the art should
Understand：It can still modify to the technical scheme described in foregoing embodiments, or to which part technical characteristic
Carry out equivalent substitution；And these modifications or replacement, the essence of appropriate technical solution is departed from various embodiments of the present invention skill
The spirit and scope of art scheme.
Claims (15)
1. a kind of business datum querying method, it is characterised in that including：
Query statement is received, the query statement includes user basic information, at least one service data information and inquiry
Condition；
The staqtistical data base of business datum is being prestored according to the user basic information and the service data information respectively
Inquired about, generation user basic information set and service data information set；
According to the querying condition, row set fortune is entered into the user basic information set and the service data information set
Calculate, generate business datum Query Information；
Return to the business datum Query Information.
2. business datum querying method as claimed in claim 1, it is characterised in that described according to the querying condition, by institute
State user basic information set and the service data information set carries out set operation, generate business datum Query Information, tool
Body includes：
The user basic information set and the service data information set are calculated into common factor, intersection and/or difference set, institute is generated
State business datum Query Information.
It is described to look into 3. business datum querying method as claimed in claim 1, it is characterised in that described to receive query statement
Asking instruction includes user basic information, at least one service data information and querying condition, includes before：
The string tag of the user basic information and the service data information is converted into corresponding digital label, respectively
Generate the list of user basic information digital label and service data information digital label list；
The user basic information digital label list and the service data information digital label list are stored to the system
Count storehouse.
4. business datum querying method as claimed in claim 3, it is characterised in that it is described according to the user basic information and
The service data information is inquired about in the staqtistical data base for prestoring business datum respectively, generates user basic information collection
Close and service data information set, specifically include：
According to the user basic information digital label list and the service data information digital label list respectively advance
The staqtistical data base of storage service data is inquired about, generation user basic information set and service data information set.
5. a kind of business datum inquiry unit, it is characterised in that including：
Query statement receiving module, for receiving query statement, the query statement include user basic information, at least one
Service data information and querying condition；
Enquiry module, for prestoring business datum respectively according to the user basic information and the service data information
Staqtistical data base inquired about, generation user basic information set and service data information set；
Statistical module, for according to the querying condition, by the user basic information set and the service data information collection
Close and carry out set operation, generate business datum Query Information；
Module is returned to, for returning to the business datum Query Information.
6. business datum inquiry unit as claimed in claim 5, it is characterised in that the statistical module, specifically for：
The user basic information set and the service data information set are calculated into common factor, intersection and/or difference set, institute is generated
State business datum Query Information.
7. business datum inquiry unit as claimed in claim 5, it is characterised in that the business datum inquiry unit is also wrapped
Include：
Modular converter, it is corresponding for the string tag of the user basic information and the service data information to be converted into
Digital label, generation user basic information digital label list and service data information digital label list；
Memory module, for by the user basic information digital label list and the service data information digital label list
Store to the staqtistical data base.
8. business datum inquiry unit as claimed in claim 7, it is characterised in that the statistical module, specifically for：
According to the user basic information digital label list and the service data information digital label list respectively advance
The staqtistical data base of storage service data is inquired about, generation user basic information set and service data information set.
9. a kind of business datum inquiry system, it is characterised in that looked into including the business datum as described in claim any one of 5-8
Device and page server are ask, the business datum inquiry unit is communicated to connect with the page server, wherein：
Page server, for input inquiry instruction, and the query statement sent to the business datum inquiry unit and
Show the business datum Query Information that the business datum inquiry unit is returned.
10. business datum inquiry system as claimed in claim 9, it is characterised in that the page server, is additionally operable to：
The user basic information and at least one described service data information are stored in advance in drop-down list list.
11. a kind of storage medium, it is characterised in that the storage medium stores computer instruction, when computer performs the meter
When calculation machine is instructed, all steps for performing the business datum querying method as described in any one of Claims 1 to 4.
12. a kind of electronic equipment, it is characterised in that including：
At least one processor；And,
The memory being connected with least one described processor communication；Wherein,
The memory storage has can be by the instruction of one computing device, and the instruction is by least one described processor
Perform, so that at least one described processor can：
Query statement is received, the query statement includes user basic information, at least one service data information and inquiry
Condition；
The staqtistical data base of business datum is being prestored according to the user basic information and the service data information respectively
Inquired about, generation user basic information set and service data information set；
The user basic information set and the service data information set are subjected to set operation, generation business datum inquiry
Information；
Return to the business datum Query Information.
13. electronic equipment as claimed in claim 12, it is characterised in that described according to the querying condition, by the user
Essential information set and the service data information set carry out set operation, generate business datum Query Information, specifically include：
The user basic information set and the service data information set are calculated into common factor, intersection and/or difference set, institute is generated
State business datum Query Information.
14. electronic equipment as claimed in claim 12, it is characterised in that described to receive query statement, the query statement
Including user basic information, at least one service data information and querying condition, include before：
The string tag of the user basic information and the service data information is converted into corresponding digital label, generated
The list of user basic information digital label and service data information digital label list；
The user basic information digital label list and the service data information digital label list are stored to the system
Count storehouse.
15. electronic equipment as claimed in claim 14, it is characterised in that described according to the user basic information and the industry
Business data message is inquired about in the staqtistical data base for prestoring business datum respectively, generation user basic information set and industry
Business data message set, is specifically included：
According to the user basic information digital label list and the service data information digital label list respectively advance
The staqtistical data base of storage service data is inquired about, generation user basic information set and service data information set.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710401508.6A CN107239536A (en) | 2017-05-31 | 2017-05-31 | Business datum querying method, device, system, storage medium and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710401508.6A CN107239536A (en) | 2017-05-31 | 2017-05-31 | Business datum querying method, device, system, storage medium and electronic equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107239536A true CN107239536A (en) | 2017-10-10 |
Family
ID=59984783
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710401508.6A Pending CN107239536A (en) | 2017-05-31 | 2017-05-31 | Business datum querying method, device, system, storage medium and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107239536A (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107992605A (en) * | 2017-12-14 | 2018-05-04 | 泰康保险集团股份有限公司 | Information processing method and system, and information requesting method and system |
| CN109189790A (en) * | 2018-08-23 | 2019-01-11 | 平安科技（深圳）有限公司 | Data managing method, device, computer equipment and storage medium |
| CN110222709A (en) * | 2019-04-29 | 2019-09-10 | 上海暖哇科技有限公司 | A kind of multi-tag intelligence marking method and system |
| CN110245137A (en) * | 2019-05-07 | 2019-09-17 | 阿里巴巴集团控股有限公司 | A kind of processing method of index, device and equipment |
| CN110647551A (en) * | 2018-06-25 | 2020-01-03 | 北京正和岛信息科技有限公司 | Label information processing method, device, equipment and medium |
| CN110716951A (en) * | 2019-09-23 | 2020-01-21 | 北京明略软件系统有限公司 | Label configuration method, device and equipment convenient to configure and storage medium |
| CN110827072A (en) * | 2019-10-31 | 2020-02-21 | 支付宝(杭州)信息技术有限公司 | Data query and storage method and system |
| CN111506594A (en) * | 2020-04-17 | 2020-08-07 | 瑞纳智能设备股份有限公司 | Big data query platform, management method thereof and data query method |
| CN112559522A (en) * | 2020-12-07 | 2021-03-26 | 百度在线网络技术（北京）有限公司 | Data storage method and device, query method, electronic device and readable medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102201007A (en) * | 2011-06-14 | 2011-09-28 | 悠易互通（北京）广告有限公司 | Large-scale data retrieving system |
| CN102779183A (en) * | 2012-07-02 | 2012-11-14 | 华为技术有限公司 | Data inquiry method, equipment and system |
| CN102982147A (en) * | 2012-11-26 | 2013-03-20 | 深圳市华为技术软件有限公司 | Method and device for increasing integration efficiency of data information |
-
2017
- 2017-05-31 CN CN201710401508.6A patent/CN107239536A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102201007A (en) * | 2011-06-14 | 2011-09-28 | 悠易互通（北京）广告有限公司 | Large-scale data retrieving system |
| CN102779183A (en) * | 2012-07-02 | 2012-11-14 | 华为技术有限公司 | Data inquiry method, equipment and system |
| CN102982147A (en) * | 2012-11-26 | 2013-03-20 | 深圳市华为技术软件有限公司 | Method and device for increasing integration efficiency of data information |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107992605B (en) * | 2017-12-14 | 2022-06-03 | 泰康保险集团股份有限公司 | Information processing method and system, and information request method and system |
| CN107992605A (en) * | 2017-12-14 | 2018-05-04 | 泰康保险集团股份有限公司 | Information processing method and system, and information requesting method and system |
| CN110647551A (en) * | 2018-06-25 | 2020-01-03 | 北京正和岛信息科技有限公司 | Label information processing method, device, equipment and medium |
| CN110647551B (en) * | 2018-06-25 | 2023-04-07 | 北京正和岛信息科技有限公司 | Label information processing method, device, equipment and medium |
| CN109189790A (en) * | 2018-08-23 | 2019-01-11 | 平安科技（深圳）有限公司 | Data managing method, device, computer equipment and storage medium |
| CN110222709A (en) * | 2019-04-29 | 2019-09-10 | 上海暖哇科技有限公司 | A kind of multi-tag intelligence marking method and system |
| CN110245137A (en) * | 2019-05-07 | 2019-09-17 | 阿里巴巴集团控股有限公司 | A kind of processing method of index, device and equipment |
| CN110245137B (en) * | 2019-05-07 | 2023-06-27 | 创新先进技术有限公司 | Index processing method, device and equipment |
| CN110716951B (en) * | 2019-09-23 | 2022-10-25 | 北京明略软件系统有限公司 | Label configuration method, device and equipment convenient to configure and storage medium |
| CN110716951A (en) * | 2019-09-23 | 2020-01-21 | 北京明略软件系统有限公司 | Label configuration method, device and equipment convenient to configure and storage medium |
| CN110827072A (en) * | 2019-10-31 | 2020-02-21 | 支付宝(杭州)信息技术有限公司 | Data query and storage method and system |
| CN111506594A (en) * | 2020-04-17 | 2020-08-07 | 瑞纳智能设备股份有限公司 | Big data query platform, management method thereof and data query method |
| CN111506594B (en) * | 2020-04-17 | 2023-03-24 | 瑞纳智能设备股份有限公司 | Big data query platform, management method thereof and data query method |
| CN112559522A (en) * | 2020-12-07 | 2021-03-26 | 百度在线网络技术（北京）有限公司 | Data storage method and device, query method, electronic device and readable medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107239536A (en) | Business datum querying method, device, system, storage medium and electronic equipment | |
| Breheny et al. | The development of high technology industries: an international survey | |
| Liu et al. | The evolution of information and communication technology in public administration | |
| O'Connor et al. | A new modernity? The arrival of ‘creative industries’ in China | |
| CN107247763A (en) | Business datum statistical method, device, system, storage medium and electronic equipment | |
| CN108304484A (en) | Key word matching method and device, electronic equipment and readable storage medium storing program for executing | |
| Peters | National systems of innovation: Creating high technology industries | |
| CN109472568A (en) | A kind of block chain method of commerce, device, management system, equipment and storage medium | |
| CN103324487A (en) | Method for achieving SaaS for workflow engine | |
| CN108805722A (en) | A kind of car insurance Intelligent Decision-making Method, device and relevant device | |
| CN106503008A (en) | File memory method and device and file polling method and apparatus | |
| Hemmert et al. | Is there an East Asian model of MNC internationalization? A comparative analysis of Japanese and Korean firms | |
| Lee et al. | China’s durable inequality: Legacies of revolution and pitfalls of reform | |
| Ray | Housing and asset based stratification in the enrichment economy | |
| Haley | Assessing and controlling business risks in China | |
| CN106227597A (en) | Task priority treating method and apparatus | |
| Ray et al. | The digital Indo-Pacific: Regional connectivity and resilience | |
| Galbraith | The quasi-inflation of 2021–2022: a case of bad analysis and worse response | |
| CN110262775A (en) | Business rule generation method and device | |
| CN108875032A (en) | Area type determines method and device | |
| Mukherji | The political economy of India's economic reforms | |
| Hamilton-Hart | Monetary politics in Southeast Asia: external imbalances in regional context | |
| Wilkinson et al. | Federalism and urban primacy: political dimensions that influence the city–country divide in Australia | |
| CN106528162A (en) | Target object display method and device, and electronic equipment | |
| Heng et al. | The intelligent city: Singapore achieving the next lap: Practitoners forum |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20171010 |
|
| WD01 | Invention patent application deemed withdrawn after publication |