CN109582697A - Multilist dynamically associates querying method, device, server and storage medium - Google Patents
Multilist dynamically associates querying method, device, server and storage medium Download PDFInfo
- Publication number
- CN109582697A CN109582697A CN201811581062.0A CN201811581062A CN109582697A CN 109582697 A CN109582697 A CN 109582697A CN 201811581062 A CN201811581062 A CN 201811581062A CN 109582697 A CN109582697 A CN 109582697A
- Authority
- CN
- China
- Prior art keywords
- query statement
- relevance
- condition
- inquiry
- configuration file
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a kind of multilists to dynamically associate querying method, device, server and storage medium.This method comprises: determine the intended display item and the corresponding relevance query statement of condition, the dummy suffix notation in the relevance query statement comprising intended display item condition and corresponding table；According to the relevance query statement, the correlation inquiry of table is carried out in the correlation inquiry configuration file of at least two tables.By determining the corresponding relevance query statement of intended display item, and the abbreviation in relevance query statement comprising intended display item condition and corresponding table, it can make directly to clearly require associated table in query process, improve search efficiency, and due to clear incidence relation, only need to realize that multilist dynamically associates inquiry by an interface.
Description
Technical field
The present embodiments relate to data query technique fields more particularly to a kind of multilist to dynamically associate querying method, dress
It sets, server and storage medium.
Background technique
With business tine continuous variation and form of service it is abundant, requirement of the user to data query is also increasingly
It is high.Many times other than needing to show the essential information of storage client, it is also necessary to incidentally show other business information of client,
And the querying condition in conjunction with user is needed to carry out comprehensive display to customer data, it is therefore desirable to be associated and look into each table of storage
It askes, query process is complicated.
Current multilist dynamically associates querying method and is mainly directly asked according to querying condition or item condition to be presented generation
Sentence is sought, is inquired according to request sentence by each storing data library, due to not knowing the association of table that needs are inquired in advance
Property, it is therefore desirable to the mutual incidence relation of multiple tables is established, then is chosen by querying condition with corresponding incidence relation
Table, need repeatedly to inquire, query process low efficiency, and due to needing to establish the mutual incidence relation of multilist,
Multiple interfaces are needed to be inquired.
Summary of the invention
The embodiment of the present invention provides a kind of multilist and dynamically associates querying method, device, server and storage medium, to improve
The search efficiency of multilist correlation inquiry reduces query interface quantity.
In a first aspect, the embodiment of the invention provides a kind of multilists to dynamically associate querying method, this method comprises:
It determines the intended display item and the corresponding relevance query statement of condition, includes in the relevance query statement
The dummy suffix notation of intended display item condition and corresponding table；
According to the relevance query statement, the association of carry out table is looked into the correlation inquiry configuration file of at least two tables
It askes.
Data will be rewritten and do not rewrite data combination, stored to memory.
Second aspect, the embodiment of the invention also provides a kind of multilist correlation inquiry device, which includes:
Determining module, for determining the intended display item and the corresponding relevance query statement of condition, the relevance
Dummy suffix notation in query statement comprising intended display item condition and corresponding table；
Enquiry module is used for according to the relevance query statement, in the correlation inquiry configuration file of at least two tables
Carry out the correlation inquiry of table.
The third aspect, the embodiment of the invention also provides a kind of server, which includes:
One or more processors；
Memory, for storing one or more programs, when one or more of programs are by one or more of places
It manages device to execute, so that one or more of processors realize that any multilist in the embodiment of the present invention dynamically associates issuer
Method.
Fourth aspect, the embodiment of the invention also provides a kind of computer readable storage mediums, are stored thereon with computer
Program realizes that any multilist in the embodiment of the present invention dynamically associates querying method when the program is executed by processor.
The embodiment of the present invention, which passes through, determines the corresponding relevance query statement of intended display item, and relevance query statement
In the abbreviation comprising intended display item condition and corresponding table, can make directly to clearly require associated table in query process, improve
Search efficiency, and since hard objectives show the incidence relation of the corresponding table of item condition and table, it only needs to pass through
One interface can realize multilist correlation inquiry, reduce the quantity of query interface, and can realize by an interface
The association of any multilist, and it is not limited to a kind of incidence relation.
Detailed description of the invention
Fig. 1 a is the flow chart that one of the embodiment of the present invention one multilist dynamically associates querying method；
Fig. 1 b is the schematic diagram that a kind of multilist that the embodiment of the present invention one provides dynamically associates querying method；
Fig. 2 is the flow chart that one of the embodiment of the present invention two multilist dynamically associates querying method；
Fig. 3 is the structural schematic diagram that one of the embodiment of the present invention three multilist dynamically associates inquiry unit；
Fig. 4 is the structural schematic diagram of one of the embodiment of the present invention four server.
Specific embodiment
The present invention is described in further detail with reference to the accompanying drawings and examples.It is understood that this place is retouched
The specific embodiment stated is used only for explaining the present invention rather than limiting the invention.It also should be noted that in order to just
Only the parts related to the present invention are shown in description, attached drawing rather than entire infrastructure.
Embodiment one
Fig. 1 a is the flow chart that one of the embodiment of the present invention one multilist dynamically associates querying method.The present embodiment provides
Multilist dynamically associate querying method and be applicable to carry out multinomial the case where dynamically associating inquiry the table data of storage, it is optional
, multilist correlation inquiry is carried out using SQL statement.This method can be dynamically associated inquiry unit by multilist to execute, the device
It can be realized by the mode of software and/or hardware, which can integrate in the server.Further, server include but
It is not limited to: network server, system background server and cloud server.
Fig. 1 b is the schematic diagram that a kind of multilist that the embodiment of the present invention one provides dynamically associates querying method.Referring to Fig. 1 b,
User inputs the corresponding condition of intended display item by terminal, and server parses it after obtaining the input condition, raw
At relevance query statement and corresponding operation is executed, inquiry is associated to the table in database, finally returns that query result,
And it is shown by terminal to user.
Referring to Fig. 1 a, the method for this implementation specifically comprises the following steps:
S110, the intended display item and the corresponding relevance query statement of condition, the relevance query statement are determined
In the dummy suffix notation comprising intended display item condition and corresponding table.
It can be web page display specifically, can be arranged when needing to inquire the table data of storage and show interface,
Or Microsoft Excel shows that display form can be identical as former storage table form, can also carry out form to former storage table
It is shown after transformation.Wherein, intended display item is that user wishes in the content for showing showing interface, such as storage table
Field or combinations thereof at least one table, and/or filtered out according to the condition that field at least one table is arranged
Field, intended display item inputs or is arranged by user.
Optionally, the condition of the intended display item or intended display item that input or be arranged according to user, determines corresponding
Correlation inquiry sentence, the dummy suffix notation in the relevance query statement comprising intended display item condition and corresponding table.It is exemplary
, when user inputs or intended display item is arranged, the condition of response can be also set sometimes, to sieve to intended display item
Choosing, obtains qualified intended display item.If directly being inquired according to the intended display item of input or its condition setting relevance
Sentence not can determine that then and need associated each table.Optionally, relevance corresponding to determining intended display item and its condition
Query statement, the dummy suffix notation in relevance query statement comprising intended display item condition and corresponding table.Since relevance is inquired
The dummy suffix notation of table is corresponded in sentence comprising intended display item, therefore server can have with automatic identification to that specific two tables
Incidence relation can directly transfer corresponding two tables with incidence relation and be associated, improve search efficiency.
Illustratively, it is opened for table dynamically associates with table CustEmpRel, CustBusiInfo, HrsEmployee tri-,
CustEmpRel table include cusId, empId, empType field, CustBusiInfo table include cusId, nickName,
SysStatus, HrsEmployee table include empId, empNo, empName, CustEmpRel, CustBusiInfo,
The dummy suffix notation that HrsEmployee tri- opens table is respectively cber, cbinfo, hrsEmp.When user inputs or be arranged intended display
And condition are as follows: empType=1 and nickName are " Xiao Wang ", it is determined that relevance query statement is " cber.emptype
=1&cbinfo.nickName=Xiao Wang ".
S120, according to the relevance query statement, table is carried out in the correlation inquiry configuration file of at least two tables
Correlation inquiry.
Optionally, the intended display item and the corresponding relevance query statement of condition are determined, the relevance inquires language
Before dummy suffix notation comprising intended display item condition and corresponding table in sentence, the method also includes: respectively at least two tables
Configuration file is established, and defines the corresponding relationship of the dummy suffix notation and table in the configuration file of each table；According to it is described at least
The configuration file of two tables establishes correlation inquiry configuration file, includes according to the request in the correlation inquiry configuration file
Dummy suffix notation in sentence calls the call relation of corresponding table.Illustratively, the configuration file for establishing at least two tables respectively,
The SQL code section of table corresponding namespace, condition are defined in configuration file, and are defined table in configuration file and corresponded to
The code segment of dummy suffix notation can establish the corresponding relationship of table Yu its dummy suffix notation by defining the corresponding dummy suffix notation of table,
To realize the calling for carrying out corresponding table by dummy suffix notation, for example, passing through sentence " include refid=
' cber.table ' " may be implemented in the configuration file to table CustEmpRel " ' namespace ' be ' cber ' ' sql id
The code segment of=table ' is called.In addition, the corresponding configuration file of each table, increases intended display carrying out corresponding table
When the condition of item, it is only necessary to a configuration file is modified, it is easy to operate, it is easy maintenance.
Illustratively, according to the configuration file of at least two tables, correlation inquiry configuration file is established, the correlation inquiry is matched
Set the call relation in file comprising calling corresponding table according to the dummy suffix notation in the request sentence.Correlation inquiry configuration file
Middle definition is by relevance query statement and condition, the call relation for calling corresponding table to be associated.
Specifically, carrying out table in the correlation inquiry configuration file of at least two tables according to the relevance query statement
Correlation inquiry.Illustratively, according to relevance query statement: " cber.emptype=1&cbinfo.nickName=is small
King ", it can be determined that go out, the attribute value of cber and cbinfo are not sky, and the attribute value of hrsEmp is empty, therefore basis
" cber.emptype=1&cbinfo.nickName=Xiao Wang ", which can determine, to be needed table CustEmpRel and table
CustEmpRel is associated, and the correlation inquiry of table is carried out in the correlation inquiry configuration file of at least two tables, and inquiry obtains
In table CustEmpRel in emptype=1 and table CustBusiInfo nickName=Xiao Wang field, be associated displaying.
When needing to show the content of " cber.emptype=1&hrsEmp.empId=6 ", do not need to carry out using another interface
Correlation inquiry, it is only necessary to apply an interface, can be obtained by according to the dummy suffix notation of the correspondence table in relevance query statement
It needs which table to be associated, then corresponding table is called to be associated, realize dynamic queries.Side provided in an embodiment of the present invention
Case, which table can be clearly required according to the target dummy suffix notation in relevance query statement associated is specifically, when
When needing multiple tables to be associated to establish multiple incidence relations, does not need each incidence relation and apply an interface, be associated with
During only need an interface to complete, improve treatment effeciency, realize mobilism correlation inquiry.
The technical solution of the present embodiment determines the intended display item and the corresponding relevance query statement of condition, described
Dummy suffix notation in relevance query statement comprising intended display item condition and corresponding table；According to the relevance query statement,
The correlation inquiry of table is carried out in the correlation inquiry configuration file of at least two tables.By determining the corresponding association of intended display item
Property query statement, and the abbreviation in relevance query statement comprising intended display item condition and corresponding table can make to inquire
Associated table is directly clearly required in journey, improves search efficiency, and due to clear incidence relation, is only needed by one
A interface can realize multilist correlation inquiry, and can be realized the correlation inquiry of any number of tables, and can establish more
Multiple incidence relations of a table realize dynamic queries.
Embodiment two
Fig. 2 is the flow chart that one of the embodiment of the present invention two multilist dynamically associates querying method；The present embodiment is upper
It states and is optimized on the basis of embodiment, the details not being described in detail in the present embodiment is detailed in above-described embodiment.Referring to figure
2, multilist provided in this embodiment dynamically associates querying method and includes:
S210, the default displaying item of configuration, and determine default the first relevance query statement for showing item, first association
Property query statement include the default displaying item condition of table and the dummy suffix notation of corresponding table.
Specifically, user can be, configured in advance is default to show item, can be configured in data or in code, setting shows and returns
Return the content in selectlist, i.e. content between SQL statement select and from.Illustratively, setting is default shows item
For { cber.custId, cber.empId, cbinfo.nickName, hrsEmp.empName }, then " select is returned
In cber.custId, cber.empId, cbinfo.nickName, hrsEmp.empName from " between select and from
Displaying content.The first relevance query statement be " cber.custId, cber.empId, cbinfo.nickName,
HrsEmp.empName ", the dummy suffix notation of default displaying item condition and corresponding table including table.
S220, according to the first relevance query statement, inquired in the correlation inquiry configuration file of at least two tables
Each table that inquiry obtains is associated, obtains by table corresponding with the dummy suffix notation in the first relevance query statement
First contingency table.
Associated table is needed specifically, may directly learn that according to the first relevance query statement.For example, according to sentence
" cber.custId, cber.empId, cbinfo.nickName, hrsEmp.empName " it is known that table CustEmpRel,
CustBusiInfo, HrsEmployee need to be associated with, and can learn the field and condition for needing associated table.By upper
Content is stated, inquires in the correlation inquiry configuration file of at least two tables and is accorded with the abbreviation in the first relevance query statement
Each table that inquiry obtains is associated, obtains the first contingency table by number corresponding table.
S230, querying condition is obtained, and determines the second relevance query statement of querying condition, second relevance is looked into
Ask the dummy suffix notation that sentence includes querying condition and table corresponding with querying condition.
Optionally, querying condition is being obtained, and is determining the second relevance query statement of querying condition, second association
Property query statement include querying condition and table corresponding with querying condition dummy suffix notation before, to server background receive
Required parameter carry out class definition, to be used to determine the second correlation inquiry sentence according to the querying condition that user inputs, described the
Two relevance query statements include the dummy suffix notation of querying condition and table corresponding with querying condition.It is used specifically, obtaining
The querying condition of family input, and determine the second correlation inquiry sentence of querying condition, illustratively, user input query condition is
" empType=1 and empId < 5 ", it is determined that the second correlation inquiry sentence is " empType=1&empId < 5 ".
S240, according to the second relevance query statement, inquired in the correlation inquiry configuration file of at least two tables
Each table that inquiry obtains is associated, obtains by table corresponding with the dummy suffix notation in the second relevance query statement
Second contingency table.
It can determine that table CustEmpRel needs to be associated with table HrsEmployee according to the second correlation inquiry sentence, Yu Yu
It is inquired in the correlation inquiry configuration file of at least two tables corresponding with the dummy suffix notation in the second relevance query statement
Table, the obtained each table of inquiry is associated, obtains the second contingency table, i.e., by table table CustEmpRel and table
HrsEmployee is associated, and is obtained the corresponding field of table according to specific querying condition and be associated.
S250, first contingency table and second contingency table are combined, obtain combination table and is shown.
The first contingency table is obtained according to the default displaying item of user setting, the first contingency table is that user wishes to show basic
It shows item, the second contingency table is obtained according to querying condition, the second contingency table is the subsequent data for needing to inquire of user, will be inquired
To the first contingency table and the second contingency table be combined, obtain combination table, combination table be shown, can more fully open up
Show the data content that user needs.In the present embodiment, the default displaying item configured in advance for user, needs to establish default exhibition
The association that table is corresponded in aspect needs to establish the association that table is corresponded in querying condition, often for the querying condition of user's input
The default incidence relation for showing item and the correspondence table in querying condition is different, by establishing the of preset configuration item in the present embodiment
One correlation inquiry sentence and the corresponding second correlation inquiry sentence of querying condition, and the first correlation inquiry sentence and second closes
Join the dummy suffix notation comprising corresponding table in query statement, therefore can only be called by an interface and associated table is needed to carry out
Correlation inquiry realizes the mobilism inquiry of multilist, can be realized the association of any table, and may be implemented to establish multiple associations passes
System.
The technical solution of the present embodiment configures default displaying item, and determines that default the first relevance for showing item inquires language
Sentence, the first relevance query statement include the default displaying item condition of table and the dummy suffix notation of corresponding table；According to described
One relevance query statement, inquiry and the first relevance query statement in the correlation inquiry configuration file of at least two tables
In the corresponding table of dummy suffix notation, the obtained each table of inquiry is associated, the first contingency table is obtained；Querying condition is obtained,
And determining the second relevance query statement of querying condition, the second relevance query statement includes querying condition and and looks into
The dummy suffix notation of the corresponding table of inquiry condition；According to the second relevance query statement, in the correlation inquiry of at least two tables
Table corresponding with the dummy suffix notation in the second relevance query statement is inquired in configuration file, each table that inquiry is obtained
It is associated, obtains the second contingency table；First contingency table and second contingency table are combined, obtain combination table simultaneously
It is shown.It by determining the corresponding relevance query statement of intended display item, and include target in relevance query statement
The abbreviation for showing item condition and corresponding table, can make directly to clearly require associated table in query process, improve search efficiency,
And due to clear incidence relation, only need to realize multilist correlation inquiry by an interface, and realizes dynamic
Stateization inquiry, may be implemented the association of any table and establishes multiple incidence relations.By showing item and inquiry language according to default
Sentence is inquired, and the content of the table of user's needs can be more fully obtained.
Embodiment three
Fig. 3 is the structural schematic diagram of one of embodiment of the present invention three multilist correlation inquiry device.The present embodiment provides
A kind of multilist correlation inquiry device, referring to Fig. 3, which is specifically included:
Determining module 310, for determining the intended display item and the corresponding relevance query statement of condition, the association
Property query statement in the dummy suffix notation comprising intended display item condition and corresponding table；
Enquiry module 320 is used for according to the relevance query statement, in the correlation inquiry configuration file of at least two tables
The middle correlation inquiry for carrying out table.
Optionally, further includes:
First configuration file establishes module, for establishing configuration file at least two tables respectively, and in the configuration of each table
The corresponding relationship of the dummy suffix notation and table is defined in file；
Second configuration file establishes module, for the configuration file according at least two table, establishes correlation inquiry and matches
File is set, corresponds to the calling of table in the correlation inquiry configuration file comprising calling according to the dummy suffix notation in the request sentence
Relationship.
Optionally, the determining module 310, is specifically used for:
Configuration is default to show item, and determines default the first relevance query statement for showing item, and first relevance is looked into
Ask the dummy suffix notation of default displaying item condition and corresponding table that sentence includes table.
Optionally, the enquiry module 320 is specifically used for according to the first relevance query statement, at least two
Table corresponding with the dummy suffix notation in the first relevance query statement is inquired in the correlation inquiry configuration file of table, will be looked into
It askes obtained each table to be associated, obtains the first contingency table.
Optionally, the determining module 310, also particularly useful for:
Querying condition is obtained, and determines the second relevance query statement of querying condition, second relevance inquires language
Sentence includes the dummy suffix notation of querying condition and table corresponding with querying condition.
Optionally, the enquiry module 320, also particularly useful for:
According to the second relevance query statement, in the correlation inquiry configuration file of at least two tables inquiry with it is described
Each table that inquiry obtains is associated, obtains the second pass by the corresponding table of dummy suffix notation in the second relevance query statement
Join table.
Optionally, further includes:
Composite module obtains combination table and goes forward side by side for first contingency table and second contingency table to be combined
Row is shown.
The technical solution of the present embodiment, determining module determine the intended display item and the corresponding relevance inquiry language of condition
, the dummy suffix notation in the relevance query statement comprising intended display item condition and corresponding table；Enquiry module is according to
Relevance query statement carries out the correlation inquiry of table in the correlation inquiry configuration file of at least two tables.By determining target
Show the corresponding relevance query statement of item, and the contracting in relevance query statement comprising intended display item condition and corresponding table
It writes, can make directly to clearly require associated table in query process, improve search efficiency, and due to clear incidence relation,
Therefore only need to realize multilist correlation inquiry by an interface, and can be realized any number of tables association and
Establish multiple incidence relations.
Example IV
Fig. 4 is a kind of server architecture schematic diagram that the embodiment of the present invention four provides.Fig. 4, which is shown, to be suitable for being used to realizing this
The block diagram of the exemplary servers 412 of invention embodiment.The server 412 that Fig. 4 is shown is only an example, should not be to this
The function and use scope of inventive embodiments bring any restrictions.
As shown in figure 4, server 412 is showed in the form of universal computing device.The component of server 412 may include but
Be not limited to: one or more processor or processing unit 416, system storage 428, connect different system components (including
System storage 428 and processing unit 416) bus 418.
Bus 418 indicates one of a few class bus structures or a variety of, including memory bus or Memory Controller,
Peripheral bus, graphics acceleration port, processor or the local bus using any bus structures in a variety of bus structures.It lifts
For example, these architectures include but is not limited to industry standard architecture (ISA) bus, microchannel architecture (MAC)
Bus, enhanced isa bus, Video Electronics Standards Association (VESA) local bus and peripheral component interconnection (PCI) bus.
Server 412 typically comprises a variety of computer system readable media.These media can be it is any being capable of bedding and clothing
The usable medium that business device 412 accesses, including volatile and non-volatile media, moveable and immovable medium.
System storage 428 may include the computer system readable media of form of volatile memory, such as deposit at random
Access to memory (RAM) 430 and/or cache memory 432.Server 412 may further include it is other it is removable/can not
Mobile, volatile/non-volatile computer system storage medium.Only as an example, storage system 434 can be used for reading and writing not
Movably, non-volatile magnetic media (Fig. 4 do not show, commonly referred to as " hard disk drive ").It although not shown in fig 4, can be with
The disc driver for reading and writing to removable non-volatile magnetic disk (such as " floppy disk ") is provided, and non-volatile to moving
The CD drive of CD (such as CD-ROM, DVD-ROM or other optical mediums) read-write.In these cases, each driving
Device can be connected by one or more data media interfaces with bus 418.Memory 428 may include at least one program
Product, the program product have one group of (for example, at least one) program module, these program modules are configured to perform the present invention
The function of each embodiment.
Program/utility 440 with one group of (at least one) program module 442, can store in such as memory
In 428, such program module 442 includes but is not limited to operating system, one or more application program, other program modules
And program data, it may include the realization of network environment in each of these examples or certain combination.Program module 442
Usually execute the function and/or method in embodiment described in the invention.
Server 412 can also be with one or more external equipments 414 (such as keyboard, sensing equipment, display 424 etc.)
Communication, can also be enabled a user to one or more equipment interact with the server 412 communicate, and/or with make the clothes
Any equipment (such as network interface card, modem etc.) that business device 412 can be communicated with one or more of the other calculating equipment
Communication.This communication can be carried out by input/output (I/O) interface 422.Also, server 412 can also be suitable by network
Orchestration 420 and one or more network (such as local area network (LAN), wide area network (WAN) and/or public network, such as because of spy
Net) communication.As shown in figure 4, network adapter 420 is communicated by bus 418 with other modules of server 412.It should be understood that
Although not shown in fig 4, other hardware and/or software module can be used in conjunction with server 412, including but not limited to: micro- generation
Code, device driver, redundant processing unit, external disk drive array, RAID system, tape drive and data backup are deposited
Storage system etc..
Processing unit 416 is by running at least one of other programs in the multiple programs being stored in system storage 428
It is a, thereby executing various function application and data processing, such as realize a kind of multilist dynamic provided by the embodiment of the present invention
Relation query method, comprising:
It determines the intended display item and the corresponding relevance query statement of condition, includes in the relevance query statement
The dummy suffix notation of intended display item condition and corresponding table；
According to the relevance query statement, the association of carry out table is looked into the correlation inquiry configuration file of at least two tables
It askes.
Embodiment five
The embodiment of the present invention five additionally provides a kind of storage medium comprising computer executable instructions, and the computer can
It executes instruction and dynamically associates querying method for executing a kind of multilist when being executed by computer processor, comprising:
It determines the intended display item and the corresponding relevance query statement of condition, includes in the relevance query statement
The dummy suffix notation of intended display item condition and corresponding table；
According to the relevance query statement, the association of carry out table is looked into the correlation inquiry configuration file of at least two tables
It askes.
The computer storage medium of the embodiment of the present invention, can be using any of one or more computer-readable media
Combination.Computer-readable medium can be computer-readable signal media or computer readable storage medium.It is computer-readable
Storage medium for example may be-but not limited to-the system of electricity, magnetic, optical, electromagnetic, infrared ray or semiconductor, device or
Device, or any above combination.The more specific example (non exhaustive list) of computer readable storage medium includes: tool
There are electrical connection, the portable computer diskette, hard disk, random access memory (RAM), read-only memory of one or more conducting wires
(ROM), erasable programmable read only memory (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 this document, computer-readable storage
Medium can be any tangible medium for including or store program, which can be commanded execution system, device or device
Using or it is in connection.
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.
The program code for including on computer-readable medium can transmit with any suitable medium, including --- but it is unlimited
In wireless, electric wire, optical cable, RF etc. or above-mentioned any appropriate combination.
The computer for executing operation of the present invention can be write with one or more programming languages or combinations thereof
Program code, described program design language include object oriented program language-such as Java, Smalltalk, C++,
It further include conventional procedural programming language-such as " C " language or similar programming language.Program code can be with
It fully executes, partly execute on the user computer on the user computer, being executed as an independent software package, portion
Divide and partially executes or executed on a remote computer or server completely on the remote computer on the user computer.?
Be related in the situation of remote computer, remote computer can pass through the network of any kind --- including local area network (LAN) or
Wide area network (WAN)-be connected to subscriber computer, or, it may be connected to outer computer (such as mentioned using Internet service
It is connected for quotient by internet).
Note that the above is only a better embodiment of the present invention and the applied technical principle.It will be appreciated by those skilled in the art that
The invention is not limited to the specific embodiments described herein, be able to carry out for a person skilled in the art it is various it is apparent variation,
It readjusts and substitutes without departing from protection scope of the present invention.Therefore, although being carried out by above embodiments to the present invention
It is described in further detail, but the present invention is not limited to the above embodiments only, without departing from the inventive concept, also
It may include more other equivalent embodiments, and the scope of the invention is determined by the scope of the appended claims.
Claims (10)
1. a kind of multilist dynamically associates querying method, which is characterized in that the described method includes:
It determines the intended display item and the corresponding relevance query statement of condition, includes target in the relevance query statement
Show the dummy suffix notation of item condition and corresponding table；
According to the relevance query statement, the correlation inquiry of table is carried out in the correlation inquiry configuration file of at least two tables.
2. the method according to claim 1, wherein determining the intended display item and the corresponding relevance of condition
Query statement, before the dummy suffix notation comprising intended display item condition and corresponding table in the relevance query statement, the side
Method further include:
Configuration file is established at least two tables respectively, and defines pair of the dummy suffix notation and table in the configuration file of each table
It should be related to；
According to the configuration file of at least two table, correlation inquiry configuration file is established, in the correlation inquiry configuration file
Call relation comprising calling corresponding table according to the dummy suffix notation in the request sentence.
3. the method according to claim 1, wherein determining the intended display item and the corresponding relevance of condition
Query statement, the dummy suffix notation in the relevance query statement comprising intended display item condition and corresponding table, comprising:
Configuration is default to show item, and determines default the first relevance query statement for showing item, and first relevance inquires language
Sentence includes the default displaying item condition of table and the dummy suffix notation of corresponding table.
4. according to the method described in claim 3, it is characterized in that, according to the relevance query statement, at least two tables
Correlation inquiry configuration file in carry out table correlation inquiry, comprising:
According to the first relevance query statement, the inquiry and described first in the correlation inquiry configuration file of at least two tables
Each table that inquiry obtains is associated, obtains the first contingency table by the corresponding table of dummy suffix notation in relevance query statement.
5. according to the method described in claim 4, it is characterized in that, determining the intended display item and the corresponding relevance of condition
Query statement, the dummy suffix notation in the relevance query statement comprising intended display item condition and corresponding table, comprising:
Querying condition is obtained, and determines the second relevance query statement of querying condition, the second relevance query statement packet
Include the dummy suffix notation of querying condition and table corresponding with querying condition.
6. according to the method described in claim 5, it is characterized in that, according to the relevance query statement, at least two tables
Correlation inquiry configuration file in carry out table correlation inquiry, comprising:
According to the second relevance query statement, the inquiry and described second in the correlation inquiry configuration file of at least two tables
Each table that inquiry obtains is associated, obtains the second contingency table by the corresponding table of dummy suffix notation in relevance query statement.
7. according to the method described in claim 6, it is characterized by further comprising:
First contingency table and second contingency table are combined, combination table is obtained and is shown.
8. a kind of multilist correlation inquiry device characterized by comprising
Determining module, for determining the intended display item and the corresponding relevance query statement of condition, the relevance inquiry
Dummy suffix notation in sentence comprising intended display item condition and corresponding table；
Enquiry module, for being carried out in the correlation inquiry configuration file of at least two tables according to the relevance query statement
The correlation inquiry of table.
9. a kind of server, which is characterized in that the server includes:
One or more processors；
Memory, 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
Now a kind of multilist as described in any in claim 1-7 dynamically associates querying method.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the program is by processor
Realize that a kind of multilist as described in any in claim 1-7 dynamically associates querying method when execution.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811581062.0A CN109582697A (en) | 2018-12-24 | 2018-12-24 | Multilist dynamically associates querying method, device, server and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811581062.0A CN109582697A (en) | 2018-12-24 | 2018-12-24 | Multilist dynamically associates querying method, device, server and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109582697A true CN109582697A (en) | 2019-04-05 |
Family
ID=65930770
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811581062.0A Pending CN109582697A (en) | 2018-12-24 | 2018-12-24 | Multilist dynamically associates querying method, device, server and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109582697A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112069206A (en) * | 2020-03-31 | 2020-12-11 | 北京来也网络科技有限公司 | Data query method, device, medium and computing device based on RPA and AI |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101739453A (en) * | 2009-12-17 | 2010-06-16 | 中国电力科学研究院 | Method and device for carrying out condition query on database table |
| US8560563B2 (en) * | 2008-07-09 | 2013-10-15 | International Business Machines Corporation | Apparatus and method of semantic service correlation system |
| CN103853803A (en) * | 2013-06-26 | 2014-06-11 | 携程计算机技术（上海）有限公司 | Database configuration file encapsulation method and operation method as well as operation device thereof |
| CN106933893A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The querying method and device of multi-dimensional data |
| US9734229B1 (en) * | 2013-09-10 | 2017-08-15 | Symantec Corporation | Systems and methods for mining data in a data warehouse |
| CN107273506A (en) * | 2017-06-19 | 2017-10-20 | 西安电子科技大学 | A kind of method of database multi-list conjunctive query |
| CN108509637A (en) * | 2018-04-10 | 2018-09-07 | 口碑(上海)信息技术有限公司 | Tables of data relation query method and device |
-
2018
- 2018-12-24 CN CN201811581062.0A patent/CN109582697A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8560563B2 (en) * | 2008-07-09 | 2013-10-15 | International Business Machines Corporation | Apparatus and method of semantic service correlation system |
| CN101739453A (en) * | 2009-12-17 | 2010-06-16 | 中国电力科学研究院 | Method and device for carrying out condition query on database table |
| CN103853803A (en) * | 2013-06-26 | 2014-06-11 | 携程计算机技术（上海）有限公司 | Database configuration file encapsulation method and operation method as well as operation device thereof |
| US9734229B1 (en) * | 2013-09-10 | 2017-08-15 | Symantec Corporation | Systems and methods for mining data in a data warehouse |
| CN106933893A (en) * | 2015-12-31 | 2017-07-07 | 北京国双科技有限公司 | The querying method and device of multi-dimensional data |
| CN107273506A (en) * | 2017-06-19 | 2017-10-20 | 西安电子科技大学 | A kind of method of database multi-list conjunctive query |
| CN108509637A (en) * | 2018-04-10 | 2018-09-07 | 口碑(上海)信息技术有限公司 | Tables of data relation query method and device |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112069206A (en) * | 2020-03-31 | 2020-12-11 | 北京来也网络科技有限公司 | Data query method, device, medium and computing device based on RPA and AI |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109086409B (en) | Microservice data processing method and device, electronic equipment and computer readable medium | |
| CN108846753B (en) | Method and apparatus for processing data | |
| CN108519967A (en) | Chart method for visualizing, device, terminal and storage medium | |
| CN110489440B (en) | Data query method and device | |
| WO2014143791A1 (en) | Efficiently performing operations on distinct data values | |
| CN108897874B (en) | Method and apparatus for processing data | |
| WO2021047323A1 (en) | Data operation method and apparatus, and system | |
| KR101643436B1 (en) | Extensibility for web based diagram visualization | |
| CN110619002A (en) | Data processing method, device and storage medium | |
| JP2017535842A (en) | Simplify calling the import procedure to transfer data from the data source to the data target | |
| CN110704476A (en) | Data processing method, device, equipment and storage medium | |
| CN109947804A (en) | Optimization method, device, server and the storage medium of data acquisition system inquiry | |
| CN108427728A (en) | Management method, equipment and the computer-readable medium of metadata | |
| US9916360B2 (en) | Joining operations in document oriented databases | |
| CN110232106A (en) | A kind of mass data storage and method for quickly retrieving based on MongoDB and Solr | |
| CN111984745B (en) | Database field dynamic expansion method, device, equipment and storage medium | |
| CN108829753A (en) | A kind of information processing method and device | |
| CN107506494B (en) | Document handling method, mobile terminal and computer readable storage medium | |
| US9449036B2 (en) | Handling an increase in transactional data without requiring relocation of preexisting data between shards | |
| CN109726295A (en) | Brand knowledge map display methods, device, figure server and storage medium | |
| CN109460409A (en) | Data access method and device | |
| CN109033456B (en) | Condition query method and device, electronic equipment and storage medium | |
| US9741060B2 (en) | Recursive navigation in mobile CRM | |
| US20220269552A1 (en) | Resolving data location for queries in a multi-system instance landscape | |
| CN109582697A (en) | Multilist dynamically associates querying method, device, server 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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190405 |
|
| RJ01 | Rejection of invention patent application after publication |