CN117216094A - Service query statement construction method, device, equipment and storage medium - Google Patents
Service query statement construction method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN117216094A CN117216094A CN202311302530.7A CN202311302530A CN117216094A CN 117216094 A CN117216094 A CN 117216094A CN 202311302530 A CN202311302530 A CN 202311302530A CN 117216094 A CN117216094 A CN 117216094A
- Authority
- CN
- China
- Prior art keywords
- service
- query statement
- logic
- operator
- target
- 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
- 238000010276 construction Methods 0.000 title claims description 54
- 238000000034 method Methods 0.000 claims abstract description 22
- 230000015654 memory Effects 0.000 claims description 17
- 238000004364 calculation method Methods 0.000 abstract description 7
- 238000004891 communication Methods 0.000 description 8
- 238000010586 diagram Methods 0.000 description 7
- 238000005516 engineering process Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 4
- 238000003058 natural language processing Methods 0.000 description 3
- 238000004590 computer program Methods 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 240000000530 Alcea rosea Species 0.000 description 1
- 235000017334 Alcea rosea Nutrition 0.000 description 1
- 235000017303 Althaea rosea Nutrition 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000014509 gene expression Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
Landscapes
- Stored Programmes (AREA)
Abstract
The application discloses a method, a device, equipment and a storage medium for constructing a service query statement, which belong to the technical field of service query, and the method comprises the following steps: acquiring at least one target service type and a service field corresponding to each target service type; determining a target logical operator set corresponding to each target service type from the logic operator set to be selected; determining a first logical operator from the set of target logical operator classes; obtaining a query statement of the target service type based on the first logical operator and the service field; and connecting all the query sentences through a second logic operator to obtain service query sentences. The application realizes the combination of different condition rules and calculation logic through different types of first logic operators, so that a user can customize the business query statement according to actual requirements, thereby meeting the personalized requirements of the user.
Description
Technical Field
The present application relates to the field of service query technologies, and in particular, to a method, an apparatus, a device, and a storage medium for constructing a service query statement.
Background
Currently, along with the increasingly developed and popular worldwide information technology and internet, saaS (Software as a Service ) is widely applied to business scenes such as document approval flows, differential standard policies, document field display and implicit control.
However, when the SaaS product is used, the condition rules and the calculation logic used by the business query statement are quite different under the business scenes such as document approval flow, differential standard policy, document field explicit and implicit control, so that the personalized requirements of all users cannot be met.
Disclosure of Invention
The application mainly aims to provide a business query statement construction method, a business query statement construction device, business query statement construction equipment and a storage medium, and aims to solve the technical problem that personalized requirements of all users cannot be met.
In order to achieve the above object, the present application provides a method for constructing a service query statement, including:
acquiring at least one target service type and a service field corresponding to each target service type;
determining a target logical operator set corresponding to each target service type from the logic operator set to be selected; any one of the sets of the logic operators to be selected comprises a plurality of logic operators with the same type, and the types of the logic operators among different sets of the logic operators to be selected are different;
determining a first logical operator from the set of target logical operator classes;
obtaining a query statement of the target service type based on the first logical operator and the service field;
and connecting all the query sentences through a second logic operator to obtain service query sentences.
Optionally, the connecting all the query sentences through the second logical operator to obtain business query sentences includes:
connecting all the query sentences through a third logic operator to obtain at least one query sentence group;
and connecting all the query statement groups through a second logic operator to obtain the service query statement.
Optionally, the third logical operator is a and logical operator.
Optionally, the set of candidate logical operators includes:
a first set of logical operators including ones that are included with the logical operators and ones that are not included with the logical operators;
a second set of logical operators including equal to, greater than, and less than logical operators;
a third set of logical operators including a null logical operator and a contain logical operator.
Optionally, the second logical operator is an or logical join operator.
Optionally, after the connecting all the query sentences through the second logic operator to obtain the business query sentences, the method further comprises:
determining a target service based on the service query statement;
and outputting the target service.
Optionally, the acquiring at least one target service type includes:
constructing a service type database; the service type database comprises preset service types and custom service types;
and determining at least one target service type from the service type database.
In a second aspect, the present application provides a service query statement construction apparatus, which is characterized in that the service query statement construction apparatus includes:
the acquisition module is used for acquiring at least one target service type and a service field corresponding to each target service type;
the first determining module is used for determining a target logic operator set corresponding to each target service type from the logic operator set to be selected; any one of the sets of the logic operators to be selected comprises a plurality of logic operators with the same type, and the types of the logic operators among different sets of the logic operators to be selected are different;
the second determining module is used for determining a first logic operator from the target logic operator class set;
the obtaining module is used for obtaining the query statement of the target service type based on the first logic operator and the service field;
and the connection module is used for connecting all the query sentences through a second logic operator to obtain service query sentences.
In a third aspect, the present application provides a service query statement construction apparatus, including: a processor, a memory and a business query statement construction program stored in the memory, which when executed by the processor, implements the steps of the business query statement construction method as described in any one of the above.
In a fourth aspect, the present application provides a computer-readable storage medium having stored thereon a service query statement construction program which, when executed by a processor, implements a service query statement construction method as defined in any one of the above.
The embodiment of the application provides a business query statement construction method, which comprises the following steps: acquiring at least one target service type and a service field corresponding to each target service type; determining a target logical operator set corresponding to each target service type from the logic operator set to be selected; any one of the sets of the logic operators to be selected comprises a plurality of logic operators with the same type, and the types of the logic operators among different sets of the logic operators to be selected are different; determining a first logical operator from the set of target logical operator classes; obtaining a query statement of the target service type based on the first logical operator and the service field; and connecting all the query sentences through a second logic operator to obtain service query sentences.
It is easy to see that different target service types correspond to different types of target logic operator sets in the application, so that different condition rules and combinations of calculation logic are realized through different types of first logic operators, and a user can customize service query sentences according to actual requirements, thereby meeting personalized requirements of the user.
Drawings
FIG. 1 is a schematic diagram of a hardware structure of an embodiment of a method for constructing a business query statement of the present application;
FIG. 2 is a flowchart of a first embodiment of a method for constructing a business query statement according to the present application;
FIG. 3 is a schematic diagram illustrating a service field and a first logical connector according to the present application;
FIG. 4 is a schematic diagram of a form file or attachment file upload according to the present application;
FIG. 5 is a schematic diagram of a business query statement construction and business query using the business query statement of the present application;
fig. 6 is a schematic diagram of functional modules of a structural framework of the service query statement construction device of the present application.
The achievement of the objects, functional features and advantages of the present application will be further described with reference to the accompanying drawings, in conjunction with the embodiments.
Detailed Description
It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the application.
With the development of information technology and the internet in the global area, many traditional industries are moving toward digital economy. Among them, saaS (Software as a Service ) is an emerging business model, and is widely used because of its advantages of high efficiency and easy realization of collaborative office.
However, when the enterprise uses SaaS for office work, the SaaS is difficult to adapt to functions and services required by all clients because of the difference of the condition rules and calculation logic used and the difference of different types/sizes and different positioning attributes in the business scenes such as document approval flows, differential standard policies, document field explicit and implicit control of different enterprises.
In order to overcome the above problems, some condition rule libraries and business process management tools exist in the market at present, such as Microsoft Flow, google App Maker, zoho Creator, etc., which have custom rule functions for different scenarios and support multiple logic operators to realize the combination of different expressions, but the condition rules and computation logic used by business query sentences are quite different in terms of document approval flows, differential standard policies, document field explicit and implicit control, etc., and still cannot meet the personalized needs of all users.
Compared with the prior art that a service query statement of a target service type is formulated by utilizing a related tool, the method and the device for constructing the service query statement, when the target service query statement is constructed, a plurality of query statements are obtained by utilizing different types of first logic operators in the logic operators to be selected to connect service fields corresponding to the target service type, and further the service query statements are obtained by connecting the plurality of query statements according to the second logic operators, and the fact that different target service types correspond to different types of target logic operator sets is not easy to see, so that different condition rules and combinations of calculation logic are realized through the different types of first logic operators, and a user can customize the service query statement according to actual requirements, thereby meeting individual requirements of the user.
Referring to fig. 1, fig. 1 is a schematic structural diagram of a service query statement construction device of a hardware running environment according to an embodiment of the present application.
As shown in fig. 1, the service query statement construction apparatus may include: a processor 1001, such as a central processing unit (Central Processing Unit, CPU), a communication bus 1002, a user interface 1003, a network interface 1004, a memory 1005. Wherein the communication bus 1002 is used to enable connected communication between these components. The user interface 1003 may include a Display, an input unit such as a Keyboard (Keyboard), and the optional user interface 1003 may further include a standard wired interface, a wireless interface. The network interface 1004 may optionally include a standard wired interface, a WIreless interface (e.g., a WIreless-FIdelity (WI-FI) interface). The Memory 1005 may be a high-speed random access Memory (Random Access Memory, RAM) Memory or a stable nonvolatile Memory (NVM), such as a disk Memory. The memory 1005 may also optionally be a storage device separate from the processor 1001 described above.
Those skilled in the art will appreciate that the structure shown in fig. 1 does not constitute a limitation of the business query statement construction apparatus, and may include more or fewer components than shown, or may combine certain components, or may be a different arrangement of components.
As shown in fig. 1, an operating system, a data storage module, a network communication module, a user interface module, and a business query statement construction program may be included in the memory 1005 as one type of storage medium.
In the service query statement construction device shown in fig. 1, the network interface 1004 is mainly used for data communication with a network server; the user interface 1003 is mainly used for data interaction with a user; the processor 1001 and the memory 1005 in the service query statement construction device of the present application may be disposed in the service query statement construction device, and the service query statement construction device invokes the service query statement construction program stored in the memory 1005 through the processor 1001 and executes the service query statement construction method provided by the embodiment of the present application.
Based on the hardware structure of the service query statement construction device, but not limited to the hardware structure, the present application provides a first embodiment of a service query statement construction method. Referring to fig. 2, fig. 2 is a flowchart illustrating a first embodiment of the business query statement construction method of the present application.
It should be noted that although a logical order is depicted in the flowchart, in some cases the steps depicted or described may be performed in a different order than presented herein.
In this embodiment, the method for constructing a service query statement includes:
step S10, at least one target service type and a service field corresponding to each target service type are obtained.
The execution body of the service query statement construction method is service query statement construction equipment, a service query statement construction program is stored on the service query statement construction equipment, and when the service query statement construction equipment executes the service query statement construction program, the service query statement construction method is executed.
In this embodiment, as shown in fig. 3, the target service type may be a single entity object or a combination of entity objects specifically queried for a bill company, a bill division, a bill of lading level, or an amount. The traffic field may be a single data element for storing and representing specific data for describing and distinguishing between different types of data. Specifically, as shown in fig. 3, when the target service type is bill company, the corresponding service fields may be a empire (62171), an alignment country (71060), qin Guo (71116), when the target service type is bill department, the corresponding service field may be a empire/hollyhock (00000004), when the target service type is bill person job level, the corresponding service field may be a manager or a director, and when the target service type is an amount, the corresponding service field may be 3000.
It can be appreciated that there may be a plurality of specific service types in practical applications, and in order to facilitate the user to quickly determine the target service type, further, as an optional embodiment, step S10 specifically includes:
and step S101, constructing a service type database.
The service type database comprises preset service types and custom service types.
In this embodiment, the preset service type may be a service scenario type with a larger application range preset in the service query statement construction device. When the preset service type does not have the target service type required by the user, the user can set a specific service scene, namely the custom service type, through the service query statement construction equipment.
Further, when the service query statement construction device detects the user-defined service type set by the user, the user-defined service type set by the user can be stored in the service type database, and the service type database is updated based on the user-defined service type, so that the subsequent user can directly select the corresponding service type from the service type database without repeated setting.
Step S102, determining at least one target service type from the service type database.
Specifically, the user may input the target keyword of the target service type by interacting with the virtual button and/or the virtual keyboard in the service query statement construction device. The service query statement construction apparatus may determine the target service type corresponding to the keyword from the service type database using NLP (Natural Language Processing ) technique based on the received target keyword.
Or after receiving the target keywords, the service query statement construction device can determine a plurality of service types from the service type database by using an NLP technology, and according to the matching threshold and the matching degree of each service type and the target keywords, the service type with the matching degree not smaller than the matching threshold is used as a recommended service type, and the recommended service type is displayed to the user, and the user can determine the target service type from the recommended service type by interacting with a virtual button and/or a virtual keyboard in the service query statement construction device.
Alternatively, as shown in fig. 4, the user may upload a table file or other attachment through the service query statement construction device, and the service query statement construction device identifies a service type according to the received table file or other attachment, and uses the service type identified from the table file or other file as the target service type.
Step S20, determining a target logic operator set corresponding to each target service type from the logic operator set to be selected.
Any one of the sets of the logic operators to be selected comprises a plurality of logic operators with the same type, and the types of the logic operators among different sets of the logic operators to be selected are different.
In this embodiment, the set of candidate logical operators may include a first set of logical operators, a second set of logical operators, and a third set of logical operators. Specifically, the first logic operator set includes logic operators and is not included in the logic operators, the second logic operator set includes equal logic operators, greater than logic operators and less than logic operators, and the third logic operator set includes null logic operators and includes logic operators.
Step S30, determining a first logic operator from the target logic operator set.
Step S40, based on the first logical operator and the service field, obtaining the query statement of the target service type.
Specifically, after determining the first logical operator from the target logical operator set, the first logical operator may be used to connect the service field to generate a query statement of the target service type.
As shown in fig. 3, when the target service type is bill company, bill department, bill person level and amount, the service fields corresponding to the bill company can be set to be Han imperial (62171), zizane (71060) and Qin Guo (71116); the business fields corresponding to the bill department are the empire/Sichuan (00000004), the business fields corresponding to the bill person level are the business fields corresponding to the manager, the general supervision and the general employee amount are 3000.
Further, after determining the service field, the user may determine, according to the actual requirement, a first logical operator applicable to the service field from the set of target logical operators. As shown in fig. 3, the first logical operators of the business with the target business type of bill company and the business with the bill department are both set to be included in the logical operators, or may be set to be the first logical operators of other types according to actual requirements, the first logical operators of the business with the target business type of bill person level are set to be not included in the logical operators, and the first logical operators of the business with the target business type of amount are set to be greater than. The query statement obtained at this time is:wherein Fe represents a query statement, itemb represents a target service classType, itemc represents a service field, +.>Representing a first logical operator.
It should be noted that one target service type may correspond to a plurality of service fields, or may correspond to one service field. When one target service type corresponds to a plurality of service fields, the target service type and each service field are respectively connected by using a first logic operator at the moment, so as to obtain a plurality of query sentences. For example, based on the above example, when the target service type is a bill company, the corresponding service field includes a Chinese empire (62171), an oleance (71060), and a Qin Guo (71116), and a query sentence obtained by connecting the target service type and the service field by using the first logic operator is: document companyHan imperial (62171), document company +.>Qili (71060), document company->Qin Guo (71116); for example, when the target service type is a job level, the corresponding service fields include a manager and a director, and a query statement obtained by connecting the target service type and each service field by using a first logic operator is: job level->Manager, job level->And (5) a general supervision. When the target service type is only one corresponding service field, the first logic operator is used for connecting the target service type and each service field. For example, based on the above example, when the target service type is the amount, the corresponding service field is 3000, and the query statement is obtained as the amount +.>3000。
And S50, connecting all the query sentences through a second logic operator to obtain service query sentences.
It is to be appreciated that query statements can be at the same business level or at different business levels. As shown in fig. 3, the business level may be divided into a company architecture information level, a company internal staff level, a company financial level, the company architecture information level may include a company name, a company internal department, etc., the company internal staff level may include a staff level, a staff age, etc., and the company financial level includes an upper limit value and a lower limit value, etc.
Thus, when the query sentences are on the same business level, further, as an optional implementation manner, step S50 specifically includes:
step S501, connecting all the query sentences through a third logic operator to obtain at least one query sentence group.
In this embodiment, the third logical operator is a and logical operator. When the query sentences are at the same business level, the query sentences at the same business level are connected by using the logic operators to obtain a query sentence group F g ＝F e1 &F e2 &…F en Wherein F g A set of query terms is represented,&represents and logically operates on.
Step S502, connecting all the query statement groups through a second logic operator to obtain the service query statement.
In this embodiment, the second logical operator is an or logical operator. It can be understood that, based on the business level of the query statement, all query statements in the same level are connected by using a third logical operator to obtain a query statement group, and the query statement groups are all in different business levels at this time, in order to make the queried business more comprehensive, all query statement groups are connected by using a second logical operator to obtain a business query statement, i.e. f=f g1 ||F g2 ||…F gn Wherein F is used to represent the business query statement and i is used to represent or logical operators.
Further, after all the query statement groups are connected through the second logic operator to obtain the service query statement, as an optional implementation manner, after step S50, the service query statement construction method further includes:
and step S51, determining a target service based on the service query statement.
And step S52, outputting the target service.
Specifically, referring to fig. 5, a user determines a target service type from preset service types in a service type database through interaction with a service query statement construction device, when no target service type is required by the user in the preset service types, the user can set the target service type in a custom mode, and when the service query statement construction device receives the custom target service type input by the user, the custom target service type can be stored in the service type database to be used as the custom service type. Further, after determining the target service type, determining a service field corresponding to the target service type, determining a target operation logical symbol set from the to-be-selected operation logical symbol set, determining a first logical operator from the target operation logical symbol set, and connecting the target service type with each service field through the first logical operator to generate a query statement.
After generating the query statement, connecting all query statements of the same business layer by using a third logic operator to obtain at least one query statement group, and finally connecting all query statement groups by using a second logic operator to obtain the business query statement. After obtaining the service query statement, determining the service entity object with the highest matching degree with the service query statement from the service entity object set, taking the service entity object as a reference service entity object, correlating the reference service entity object with the service query statement to obtain a new service query statement, determining a plurality of to-be-selected services from the to-be-matched service data set by using the new service query statement, respectively calculating the matching degree between the new service query statement and each to-be-selected service, taking the to-be-selected service with the highest matching degree as a target service, and outputting the target service.
Or after the service to be selected with the highest matching degree is used as the target service and the target service is output, as an optional implementation manner, the rest of the service to be selected can be output and used as the reference service for the user to check.
As shown in FIG. 3, the query statement of the company architecture information layer can be obtained as The query statement of the employee architecture level inside the company is: />The inquiry statement of the company financial layer isFurther, the third logical operator, the set of query statements obtained is: f (F) g1 ＝F e1 &F e2 &F e3 &F e4 、F g2 ＝F e5 &F e6 、F g3 ＝F e7 . Further, based on the query statement, the query statement group is connected by using a second logical operator to obtain a service query statement: f=f g1 ||F g2 ||F g3 The service entity object set includes A, B, C … …, based on the service query statement, if the service entity object with the highest matching degree is obtained as C, at this time, the reference service entity object C is associated with the service query statement to obtain a new service query statement, i.e., F' =f g1 ||F g2 ||F g3 ||C. Further, determining from the service data set to be queried using the new service query statement FThe plurality of the selected services a, b, c, d, e are obtained, the matching degree of each selected service and the new service query statement is respectively 60%,75%,59%,83% and 77%, and the selected service d is taken as the target service and is output. Further, the service a, b, c, e to be selected may be used as a reference service, and the service a, b, c, e to be selected may be output.
In this embodiment, at least one target service type and a service field corresponding to each target service type are obtained; determining a target logical operator set corresponding to each target service type from the logic operator set to be selected; any one of the sets of the logic operators to be selected comprises a plurality of logic operators with the same type, and the types of the logic operators among different sets of the logic operators to be selected are different; determining a first logical operator from the set of target logical operator classes; obtaining a query statement of the target service type based on the first logical operator and the service field; and connecting all the query sentences through a second logic operator to obtain service query sentences. The application realizes the combination of different condition rules and calculation logics through different types of first logic operators, so that a user can customize service query sentences according to actual demands, and can meet the customized contents required by enterprise users in different industries under various service scenes such as document approval flows, differential standard policies, document field display and recessive control and the like, thereby meeting the individual demands of the user and improving the corresponding timeliness and scene coverage rate. Furthermore, the embodiment supports the self-defined target service and the first logic operator, does not need to improve the code of the platform, and improves the expansibility and reusability of the code.
Based on the same application conception, the application provides a service query statement construction device, and reference is made to fig. 6, and fig. 6 is a schematic block diagram of a first embodiment of the service query statement construction device of the application.
An obtaining module 10, configured to obtain at least one target service type and a service field corresponding to each target service type;
a first determining module 20, configured to determine, from a set of logic operators to be selected, a set of target logic operators corresponding to each of the target service types; any one of the sets of the logic operators to be selected comprises a plurality of logic operators with the same type, and the types of the logic operators among different sets of the logic operators to be selected are different;
a second determining module 30, configured to determine a first logical operator from the set of target logical operator classes;
an obtaining module 40, configured to obtain a query statement of the target service type based on the first logical operator and the service field;
the connection module 50 is configured to connect all the query sentences through a second logic operator to obtain a service query sentence.
It should be noted that, in this embodiment, the technical effects achieved by the embodiments of the service query statement construction device may refer to various implementations of the service query statement construction method in the foregoing embodiments, which are not described herein again.
According to the technical scheme of the embodiment, through mutual coordination among the functional modules, at least one target service type and a service field corresponding to each target service type are obtained; determining a target logical operator set corresponding to each target service type from the logic operator set to be selected; any one of the sets of the logic operators to be selected comprises a plurality of logic operators with the same type, and the types of the logic operators among different sets of the logic operators to be selected are different; determining a first logical operator from the set of target logical operator classes; obtaining a query statement of the target service type based on the first logical operator and the service field; and connecting all the query sentences through a second logic operator to obtain service query sentences. The application realizes the combination of different condition rules and calculation logic through different types of first logic operators, so that a user can customize the business query statement according to actual requirements, thereby meeting the personalized requirements of the user.
In addition, the embodiment of the application also provides a computer storage medium, and the storage medium stores a service query statement construction program which realizes the steps of the service query statement construction method when being executed by a processor. Therefore, a detailed description will not be given here. In addition, the description of the beneficial effects of the same method is omitted. For technical details not disclosed in the embodiments of the computer-readable storage medium according to the present application, please refer to the description of the method embodiments of the present application. As an example, the program instructions may be deployed to be executed on one computing device or on multiple computing devices at one site or distributed across multiple sites and interconnected by a communication network.
Those skilled in the art will appreciate that implementing all or part of the above-described methods may be accomplished by way of computer programs, which may be stored on a computer-readable storage medium, and which, when executed, may comprise the steps of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a Read-Only Memory (ROM), a Random access Memory (Random AccessMemory, RAM), or the like.
It should be further noted that the above-described apparatus embodiments are merely illustrative, where elements described as separate elements may or may not be physically separate, and elements shown as elements may or may not be physical elements, may be located in one place, or may be distributed over a plurality of network elements. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment. In addition, in the drawings of the embodiment of the device provided by the application, the connection relation between the modules represents that the modules have communication connection, and can be specifically implemented as one or more communication buses or signal lines. Those of ordinary skill in the art will understand and implement the present application without undue burden.
From the above description of the embodiments, it will be apparent to those skilled in the art that the present application may be implemented by means of software plus necessary general purpose hardware, or of course by means of special purpose hardware including application specific integrated circuits, special purpose CPUs, special purpose memories, special purpose components, etc. Generally, functions performed by computer programs can be easily implemented by corresponding hardware, and specific hardware structures for implementing the same functions can be varied, such as analog circuits, digital circuits, or dedicated circuits. However, a software program implementation is a preferred embodiment for many more of the cases of the present application. Based on such understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art in the form of a software product stored in a readable storage medium, such as a floppy disk, a usb disk, a removable hard disk, a Read-only memory (ROM), a random-access memory (RAM, randomAccessMemory), a magnetic disk or an optical disk of a computer, etc., including several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the method of the embodiments of the present application.
The foregoing description is only of the preferred embodiments of the present application, and is not intended to limit the scope of the application, but rather is intended to cover any equivalents of the structures or equivalent processes disclosed herein or in the alternative, which may be employed directly or indirectly in other related arts.
Claims (10)
1. The method for constructing the business query statement is characterized by comprising the following steps:
acquiring at least one target service type and a service field corresponding to each target service type;
determining a target logical operator set corresponding to each target service type from the logic operator set to be selected; any one of the sets of the logic operators to be selected comprises a plurality of logic operators with the same type, and the types of the logic operators among different sets of the logic operators to be selected are different;
determining a first logical operator from the set of target logical operator classes;
obtaining a query statement of the target service type based on the first logical operator and the service field;
and connecting all the query sentences through a second logic operator to obtain service query sentences.
2. The method for constructing a service query statement according to claim 1, wherein said connecting all the query statements by the second logical operator to obtain the service query statement comprises:
connecting all the query sentences through a third logic operator to obtain at least one query sentence group;
and connecting all the query statement groups through a second logic operator to obtain the service query statement.
3. The business query statement construction method of claim 2, wherein the third logical operator is a and logical operator.
4. The business query statement construction method of claim 1, wherein the set of candidate logical operators comprises:
a first set of logical operators including ones that are included with the logical operators and ones that are not included with the logical operators;
a second set of logical operators including equal to, greater than, and less than logical operators;
a third set of logical operators including a null logical operator and a contain logical operator.
5. The business query statement construction method of claim 1, wherein the second logical operator is an or logical join operator.
6. The method for constructing a service query statement according to claim 1, wherein after the service query statement is obtained by connecting all the query statements by the second logical operator, the method further comprises:
determining a target service based on the service query statement;
and outputting the target service.
7. The method for constructing a service query statement according to claim 1, wherein the obtaining at least one target service type comprises:
constructing a service type database; the service type database comprises preset service types and custom service types;
and determining at least one target service type from the service type database.
8. A business query statement construction device, characterized in that the business query statement construction device comprises:
the acquisition module is used for acquiring at least one target service type and a service field corresponding to each target service type;
the first determining module is used for determining a target logic operator set corresponding to each target service type from the logic operator set to be selected; any one of the sets of the logic operators to be selected comprises a plurality of logic operators with the same type, and the types of the logic operators among different sets of the logic operators to be selected are different;
the second determining module is used for determining a first logic operator from the target logic operator class set;
the obtaining module is used for obtaining the query statement of the target service type based on the first logic operator and the service field;
and the connection module is used for connecting all the query sentences through a second logic operator to obtain service query sentences.
9. A service query statement construction apparatus, characterized by comprising: a processor, a memory and a service query statement construction program stored in the memory, which when executed by the processor, implements the steps of the service query statement construction method of any one of claims 1 to 7.
10. A computer-readable storage medium, wherein a service query statement construction program is stored on the computer-readable storage medium, which when executed by a processor implements the service query statement construction method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311302530.7A CN117216094A (en) | 2023-10-09 | 2023-10-09 | Service query statement construction method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311302530.7A CN117216094A (en) | 2023-10-09 | 2023-10-09 | Service query statement construction method, device, equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117216094A true CN117216094A (en) | 2023-12-12 |
Family
ID=89044336
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311302530.7A Pending CN117216094A (en) | 2023-10-09 | 2023-10-09 | Service query statement construction method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117216094A (en) |
-
2023
- 2023-10-09 CN CN202311302530.7A patent/CN117216094A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11537606B2 (en) | Solution for implementing computing service based on structured query language statement | |
| CN110750649A (en) | Knowledge graph construction and intelligent response method, device, equipment and storage medium | |
| US20090292711A1 (en) | Constraints With Hidden Rows in a Database | |
| CN111177231A (en) | Report generation method and report generation device | |
| CN109902117A (en) | Operation system analysis method and device | |
| US11537448B1 (en) | Adapting application programming interfaces with schema mappings | |
| US20150269234A1 (en) | User Defined Functions Including Requests for Analytics by External Analytic Engines | |
| WO2020081587A1 (en) | System and method for auto-completion of ics flow using artificial intelligence/machine learning | |
| US9043328B2 (en) | Configurable catalog builder system | |
| CN110737425B (en) | Method and device for establishing application program of charging platform system | |
| CN110888672B (en) | Expression engine implementation method and system based on metadata architecture | |
| US20230185639A1 (en) | Mapping application programming interface schemas with semantic representations | |
| CN114296737A (en) | Service code generation method, device, equipment and storage medium | |
| CN111522840B (en) | Label configuration method, device, equipment and computer readable storage medium | |
| CN111488531B (en) | Information recommendation method, device and medium based on collaborative filtering algorithm | |
| WO2023103815A1 (en) | Contextual dialogue framework over dynamic tables | |
| WO2020024824A1 (en) | Method and device for determining user status identifier | |
| WO2016131295A1 (en) | Northbound data conversion method and device | |
| CN117216094A (en) | Service query statement construction method, device, equipment and storage medium | |
| US11562126B2 (en) | Coaching system and coaching method | |
| US11810022B2 (en) | Contact center call volume prediction | |
| US20210357681A1 (en) | Scalable Attributed Graph Embedding for Large-Scale Graph Analytics | |
| CN109783134B (en) | Front-end page configuration method and device and electronic equipment | |
| CN112182350A (en) | Interaction method, device, server and storage medium based on content library | |
| US20200341964A1 (en) | Natural language interface databases |
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 |