[go: up one dir, main page]

CN115203229A - Process query system and method - Google Patents

Process query system and method Download PDF

Info

Publication number
CN115203229A
CN115203229A CN202210528411.2A CN202210528411A CN115203229A CN 115203229 A CN115203229 A CN 115203229A CN 202210528411 A CN202210528411 A CN 202210528411A CN 115203229 A CN115203229 A CN 115203229A
Authority
CN
China
Prior art keywords
query
language
process query
time
further configured
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN202210528411.2A
Other languages
Chinese (zh)
Other versions
CN115203229B (en
Inventor
郑瑶海
陈小格
徐志
张博华
白青梅
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Xuanxing Technology Co ltd
Original Assignee
Beijing Xuanxing Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Beijing Xuanxing Technology Co ltd filed Critical Beijing Xuanxing Technology Co ltd
Priority to CN202210528411.2A priority Critical patent/CN115203229B/en
Publication of CN115203229A publication Critical patent/CN115203229A/en
Application granted granted Critical
Publication of CN115203229B publication Critical patent/CN115203229B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2433Query languages
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2453Query optimisation
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

本发明公开了一种流程查询系统及方法,属于流程查询技术领域。本发明通过在流程查询系统中设置查询接口模块、语言转换模块以及查询优化模块;所述查询接口模块,用于接收用户输入的流程查询条件,并根据所述流程查询条件进行语言分类,生成不同种类的流程查询语言;所述语言转换模块,用于对不同种类的流程查询语言进行解析,根据解析结果对每种流程查询语言进行相应的语言转换,得到多种转换后的流程查询语言;所述查询优化模块,用于将所述转换后的流程查询语言和所述流程查询条件进行优化,可根据优化后的流程进行查询,提高流程查询的效率。

Figure 202210528411

The invention discloses a process query system and method, belonging to the technical field of process query. In the present invention, a query interface module, a language conversion module and a query optimization module are set in the process query system; the query interface module is used for receiving the process query conditions input by the user, and performs language classification according to the process query conditions to generate different query conditions. Types of process query languages; the language conversion module is used to parse different types of process query languages, and perform corresponding language conversion for each process query language according to the parsing results to obtain multiple converted process query languages; The query optimization module is used to optimize the converted process query language and the process query conditions, and can perform query according to the optimized process to improve the efficiency of process query.

Figure 202210528411

Description

流程查询系统及方法Process query system and method

技术领域technical field

本发明涉及流程查询技术领域,尤其涉及一种流程查询系统及方法。The invention relates to the technical field of process query, in particular to a process query system and method.

背景技术Background technique

现有的流程查询系统是以通用的SQL数据库(Structured Query Languageserver database,结构化查询语言数据库)和其衍生为主进行操作,不适合用于流程上的查询使用或优化,用编程实现的流程查询方案,操作繁琐且利用性不高,在进行流程查询时效率低。The existing process query system mainly operates on the general SQL database (Structured Query Language server database, Structured Query Language database) and its derivatives, which is not suitable for the use or optimization of process query, and the process query implemented by programming. The scheme is cumbersome to operate and has low utilization, and is inefficient when performing process query.

发明内容SUMMARY OF THE INVENTION

本发明的主要目的在于提供一种流程查询系统及方法,旨在解决现有技术流程查询效率低的技术问题。The main purpose of the present invention is to provide a process query system and method, aiming at solving the technical problem of low process query efficiency in the prior art.

为实现上述目的,本发明提供了一种流程查询系统,所述流程查询系统包括:查询接口模块、语言转换模块以及查询优化模块;In order to achieve the above object, the present invention provides a process query system, the process query system includes: a query interface module, a language conversion module and a query optimization module;

所述查询接口模块,用于接收用户输入的流程查询条件,并根据所述流程查询条件进行语言分类,生成不同种类的流程查询语言;The query interface module is configured to receive the process query conditions input by the user, and perform language classification according to the process query conditions to generate different types of process query languages;

所述语言转换模块,用于对不同种类的流程查询语言进行解析,根据解析结果对每种流程查询语言进行相应的语言转换,得到多种转换后的流程查询语言;The language conversion module is used to parse different types of process query languages, and perform corresponding language conversion for each process query language according to the analysis results, so as to obtain multiple converted process query languages;

所述查询优化模块,用于将所述转换后的流程查询语言和所述流程查询条件进行优化。The query optimization module is configured to optimize the converted process query language and the process query conditions.

可选地,所述语言转换模块包括:语言解释器;Optionally, the language conversion module includes: a language interpreter;

所述语言解释器,用于接收不同种类的流程查询语言,并对不同种类的流程查询语言进行相应的语言转换;The language interpreter is used for receiving different kinds of process query languages, and performing corresponding language conversion on different kinds of process query languages;

所述语言解释器,还用于在所述流程查询语言为时间流程查询语言时,将时间流程查询语言逻辑转换为时间维度的语言截取逻辑,以完成时间流程查询的语言转换。The language interpreter is further configured to convert the time flow query language logic into a time dimension language interception logic when the flow query language is a time flow query language, so as to complete the language conversion of the time flow query.

可选地,所述语言解释器,还用于在所述流程查询语言为案例流程查询时,获取案例标识和案例时间信息,并根据所述案例标识和所述案例时间信息生成以时间排序的步骤序列和时间戳序列,以完成案例流程查询的语言转换。Optionally, the language interpreter is further configured to obtain a case identifier and case time information when the process query language is a case process query, and generate a chronological order according to the case identifier and the case time information. Sequence of steps and sequence of timestamps to complete language translation of case flow queries.

可选地,所述语言解释器,还用于根据所述流程查询条件生成对应的算法逻辑;Optionally, the language interpreter is further configured to generate corresponding algorithm logic according to the process query condition;

所述语言解释器,还用于在所述流程查询条件为节点查询时,判断所述步骤序列是否匹配对应的节点,并在所述步骤序列匹配所述节点时,获取与所述节点匹配的步骤序列,以完成节点查询的语言转换。The language interpreter is further configured to, when the process query condition is a node query, determine whether the sequence of steps matches the corresponding node, and when the sequence of steps matches the node, obtain a query matching the node. Sequence of steps to complete language translation of node queries.

可选地,所述语言解释器,还用于在所述流程查询条件为片段节点查询时,查找所述步骤序列是否存在关联的片段节点,并在所述步骤序列存在关联的片段节点时,截取与所述片段节点关联的步骤序列,以完成片段节点查询的语言转换。Optionally, the language interpreter is further configured to find out whether there is an associated segment node in the step sequence when the process query condition is a segment node query, and when there is an associated segment node in the step sequence, Intercept the sequence of steps associated with the segment node to complete the language conversion of the segment node query.

可选地,所述语言解释器,还用于在所述流程查询条件为耗时查询时,生成所述步骤序列与时间关联的查询代码,以根据所述查询代码进行耗时查询,以完成耗时查询的语言转换;Optionally, the language interpreter is also used to generate a query code associated with the time sequence of the step sequence when the process query condition is a time-consuming query, so as to perform a time-consuming query according to the query code to complete the query code. Language conversion for time-consuming queries;

所述语言解释器,还用于在所述流程查询条件为路径查询时,将所述步骤序列与路径进行匹配,以完成路径查询的语言转换。The language interpreter is further configured to match the sequence of steps with a path when the process query condition is a path query, so as to complete the language conversion of the path query.

可选地,所述语言解释器,还用于在所述流程查询条件为边查询时,确定边查询种类,根据所述边查询种类和所述步骤序列对边查询进行语言转换。Optionally, the language interpreter is further configured to determine the type of the edge query when the process query condition is an edge query, and perform language conversion on the edge query according to the type of the edge query and the sequence of steps.

可选地,所述查询优化模块,还用于在所述流程查询条件为时间流程查询时,获取时间范围,并将所述时间范围的查询提前;Optionally, the query optimization module is further configured to obtain a time range when the process query condition is a time process query, and advance the query of the time range;

所述查询优化模块,还用于在所述流程查询条件为日志查询时,将关联日志的查询条件提前,并对日志数据进行处理;The query optimization module is further configured to advance the query condition of the associated log and process the log data when the process query condition is a log query;

所述查询优化模块,还用于在所述流程查询条件为多个案例查询时,将所述多个案例查询进行合并;The query optimization module is further configured to combine the multiple case queries when the process query conditions are multiple case queries;

所述查询优化模块,还用于在所述流程查询条件为片段节点查询或耗时查询时,将所述片段节点查询对应的查询语言或所述耗时查询对应的查询语言提前。The query optimization module is further configured to advance the query language corresponding to the fragment node query or the query language corresponding to the time-consuming query when the process query condition is a fragment node query or a time-consuming query.

可选地,所述查询接口模块,还用于接收用户输入的流程查询字段,并通过逻辑运算符对所述流程查询字段进行组合,得到流程查询条件。Optionally, the query interface module is further configured to receive a process query field input by a user, and combine the process query fields through a logical operator to obtain a process query condition.

此外,为实现上述目的,本发明还提出一种流程查询方法,所述流程查询方法应用于上文所述的流程查询系统,所述流程查询系统包括:查询接口模块、语言转换模块以及查询优化模块,所述方法包括:In addition, in order to achieve the above object, the present invention also proposes a process query method. The process query method is applied to the process query system described above. The process query system includes: a query interface module, a language conversion module, and a query optimization module. module, the method includes:

所述查询接口模块接收用户输入的流程查询条件,并根据所述流程查询条件进行语言分类,生成不同种类的流程查询语言;The query interface module receives the process query conditions input by the user, and performs language classification according to the process query conditions to generate different types of process query languages;

所述语言转换模块对不同种类的流程查询语言进行解析,根据解析结果对每种流程查询语言进行相应的语言转换,得到多种转换后的流程查询语言;The language conversion module parses different types of process query languages, and performs corresponding language conversion for each process query language according to the analysis results, so as to obtain multiple converted process query languages;

所述查询优化模块将所述转换后的流程查询语言和所述流程查询条件进行优化。The query optimization module optimizes the converted process query language and the process query conditions.

本发明通过在流程查询系统中设置查询接口模块、语言转换模块以及查询优化模块;所述查询接口模块,用于接收用户输入的流程查询条件,并根据所述流程查询条件进行语言分类,生成不同种类的流程查询语言;所述语言转换模块,用于对不同种类的流程查询语言进行解析,根据解析结果对每种流程查询语言进行相应的语言转换,得到多种转换后的流程查询语言;所述查询优化模块,用于将所述转换后的流程查询语言和所述流程查询条件进行优化,可根据优化后的流程进行查询,提高流程查询的效率。In the present invention, a query interface module, a language conversion module and a query optimization module are set in the process query system; the query interface module is used for receiving the process query conditions input by the user, and performs language classification according to the process query conditions to generate different query conditions. Types of process query languages; the language conversion module is used to parse different types of process query languages, and perform corresponding language conversion for each process query language according to the parsing results to obtain multiple converted process query languages; The query optimization module is used to optimize the converted process query language and the process query conditions, and can perform query according to the optimized process to improve the efficiency of process query.

附图说明Description of drawings

图1是本发明流程查询系统第一实施例的结构框图;Fig. 1 is the structural block diagram of the first embodiment of the process query system of the present invention;

图2为本发明流程查询系统第二实施例的结构框图;Fig. 2 is the structural block diagram of the second embodiment of the process query system of the present invention;

图3为本发明流程查询方法第一实施例的流程示意图。FIG. 3 is a schematic flowchart of a first embodiment of a process query method according to the present invention.

本发明目的的实现、功能特点及优点将结合实施例,参照附图做进一步说明。The realization, functional characteristics and advantages of the present invention will be further described with reference to the accompanying drawings in conjunction with the embodiments.

附图标号说明:Description of reference numbers:

标号label 名称name 标号label 名称name 11 查询接口模块Query interface module 2020 语言解释器language interpreter 22 语言转换模块language conversion module 33 查询优化模块query optimization module

具体实施方式Detailed ways

应当理解,此处所描述的具体实施例仅用以解释本发明,并不用于限定本发明。It should be understood that the specific embodiments described herein are only used to explain the present invention, but not to limit the present invention.

参照图1,图1为本发明流程查询系统第一实施例的结构框图。Referring to FIG. 1, FIG. 1 is a structural block diagram of a first embodiment of a process query system of the present invention.

在本实施例中,所述流程查询系统包括:查询接口模块1、语言转换模块2以及查询优化模块3;所述查询接口模块1,用于接收用户输入的流程查询条件,并根据所述流程查询条件进行语言分类,生成不同种类的流程查询语言;所述语言转换模块2,用于对不同种类的流程查询语言进行解析,根据解析结果对每种流程查询语言进行相应的语言转换,得到多种转换后的流程查询语言;所述查询优化模块3,用于将所述转换后的流程查询语言和所述流程查询条件进行优化。In this embodiment, the process query system includes: a query interface module 1, a language conversion module 2 and a query optimization module 3; the query interface module 1 is used to receive the process query conditions input by the user, and according to the process The query conditions are classified into languages, and different types of process query languages are generated; the language conversion module 2 is used to parse different types of process query languages, and perform corresponding language conversion for each process query language according to the parsing results, so as to obtain multiple query languages. A converted process query language; the query optimization module 3 is configured to optimize the converted process query language and the process query conditions.

应理解的是,查询接口模块1用于接收用户输入的流程查询条件,流程查询条件为用户根据逻辑运算符进行组合得到的流程查询条件,逻辑运算符包括AND、OR、NOT等,本实施例对此不作限制。It should be understood that the query interface module 1 is used to receive the process query conditions input by the user, and the process query conditions are the process query conditions obtained by the user according to the combination of logical operators. The logical operators include AND, OR, NOT, etc. This embodiment There is no restriction on this.

在具体实施中,查询接口模块1还用于接收用户输入的流程查询字段,并通过逻辑运算符对流程查询字段进行组合,得到流程查询条件。用户通过定义好的查询接口模块1输入查询的字段,通过逻辑运算符组合各种查询,得到对应的流程查询条件。查询接口模块1得到流程查询条件后,根据流程查询条件进行语言分类,生成不同种类的流程查询语言。In a specific implementation, the query interface module 1 is further configured to receive the process query fields input by the user, and combine the process query fields through logical operators to obtain the process query conditions. The user inputs query fields through the defined query interface module 1, and combines various queries through logical operators to obtain corresponding process query conditions. After obtaining the process query conditions, the query interface module 1 performs language classification according to the process query conditions to generate different types of process query languages.

需要说明的是,语言转换模块2用于对不同种类的流程查询语言进行解析,并根据解析结果对每种流程查询语言进行相应的语言转换,得到多种转换后的流程查询语言,语言转换模块2包括语言解释器,通过得到不同种类的查询语言,输入至对应的查询语言解释器进行语言解析和转换,得到多种转换后的流程查询语言。It should be noted that the language conversion module 2 is used to parse different types of process query languages, and perform corresponding language conversion for each process query language according to the analysis results, and obtain multiple converted process query languages. The language conversion module 2 Including language interpreters, by obtaining different kinds of query languages, inputting them to the corresponding query language interpreters for language parsing and conversion, and obtaining a variety of converted process query languages.

可以理解的是,查询优化模块3用于将转换后的流程查询语言和流程查询条件进行优化,得到优化后的流程查询语言和优化后的流程查询条件,可将流程查询语言中的时间范围的查询提前,或者将基于日志级别的查询条件放在前面,可快速过滤掉不必要的日志数据,达到流程查询的优化结果,提高流程查询的效率。It can be understood that the query optimization module 3 is used to optimize the converted process query language and process query conditions, and obtain the optimized process query language and optimized process query conditions, which can convert the time range in the process query language. Querying in advance, or putting the query conditions based on the log level in the front, can quickly filter out unnecessary log data, achieve the optimized results of process query, and improve the efficiency of process query.

具体地,所述查询优化模块3,还用于在流程查询条件为时间流程查询时,获取对应的时间范围,并将时间范围的查询条件提前,由于流程查询系统的流程挖掘底层是基于时间设计,因此可将时间范围的查询提前。所述查询优化模块3,还用于在所述流程查询条件为日志查询时,将关联日志的查询条件提前,并对日志数据进行处理,把相关基于日志级别的查询条件放前面,可快速的过滤掉不必要的日志数据。Specifically, the query optimization module 3 is further configured to obtain the corresponding time range when the process query condition is a time process query, and advance the query condition of the time range, because the bottom layer of the process mining system of the process query system is designed based on time , so the query of the time range can be advanced. The query optimization module 3 is further configured to advance the query condition of the associated log when the process query condition is a log query, process the log data, and put the relevant query condition based on the log level in the front, which can quickly Filter out unnecessary log data.

所述查询优化模块3,还用于在所述流程查询条件为多个案例查询时,将所述多个案例查询进行合并;所述查询优化模块3,还用于在所述流程查询条件为片段节点查询或耗时查询时,将所述片段节点查询对应的查询语言或所述耗时查询对应的查询语言提前。The query optimization module 3 is further configured to combine the multiple case queries when the process query conditions are multiple case queries; the query optimization module 3 is further configured to use the process query conditions as: When querying a segment node or a time-consuming query, the query language corresponding to the segment node query or the query language corresponding to the time-consuming query is advanced.

应理解的是,查询优化模块3,还用于在流程查询条件为多个案例查询时,可将多个案例查询进行合并,例如需要查询案例A和查询案例B这两个查询条件,则可将此案例A和案例B进行合并,合并成一个案例查询,提高案例查询的效率。查询优化模块3还用于在流程查询条件为片段节点或者耗时查询时,可将片段节点查询对应的查询语言或者耗时查询对应的查询语言筛选提前,保证筛选的正确性。It should be understood that the query optimization module 3 is also used to combine multiple case queries when the process query conditions are multiple case queries. This case A and case B are combined into one case query, which improves the efficiency of case query. The query optimization module 3 is also used to filter the query language corresponding to the fragment node query or the query language corresponding to the time-consuming query in advance when the process query condition is a fragment node or a time-consuming query, so as to ensure the correctness of the screening.

本发明通过在流程查询系统中设置查询接口模块、语言转换模块以及查询优化模块;所述查询接口模块,用于接收用户输入的流程查询条件,并根据所述流程查询条件进行语言分类,生成不同种类的流程查询语言;所述语言转换模块,用于对不同种类的流程查询语言进行解析,根据解析结果对每种流程查询语言进行相应的语言转换,得到多种转换后的流程查询语言;所述查询优化模块,用于将所述转换后的流程查询语言和所述流程查询条件进行优化,可根据优化后的流程进行查询,提高流程查询的效率。In the present invention, a query interface module, a language conversion module and a query optimization module are set in the process query system; the query interface module is used for receiving the process query conditions input by the user, and performs language classification according to the process query conditions to generate different query conditions. Types of process query languages; the language conversion module is used to parse different types of process query languages, and perform corresponding language conversion for each process query language according to the parsing results to obtain multiple converted process query languages; The query optimization module is used to optimize the converted process query language and the process query conditions, and can perform query according to the optimized process to improve the efficiency of process query.

参照图2,图2为本发明流程查询系统第二实施例的结构框图。Referring to FIG. 2, FIG. 2 is a structural block diagram of the second embodiment of the process query system of the present invention.

在本实施例中,所述语言转换模块2包括:语言解释器20;所述语言解释器20,用于接收不同种类的流程查询语言,并对不同种类的流程查询语言进行相应的语言转换;所述语言解释器20,还用于在所述流程查询语言为时间流程查询语言时,将时间流程查询语言逻辑转换为时间维度的语言截取逻辑,以完成时间流程查询的语言转换。In this embodiment, the language conversion module 2 includes: a language interpreter 20; the language interpreter 20 is configured to receive different types of process query languages, and perform corresponding language conversions on different types of process query languages; The language interpreter 20 is further configured to convert the time flow query language logic into a time dimension language interception logic when the process query language is a time flow query language, so as to complete the language conversion of the time flow query.

应理解的是,查询语言解释器20用于接收查询接口模块1分类后的不同种类的流程查询语言,并对不同种类的流程查询语言进行相应的语言转换。对相关的查询种类,根据底层的流程挖掘系统提供的接口进行转换,语言解释器20,还用于在流程查询语言为时间流程查询语言时,将时间流程查询语言逻辑转换为时间维度的语言截取逻辑,以完成时间流程查询的语言转换。It should be understood that the query language interpreter 20 is configured to receive different types of process query languages classified by the query interface module 1, and perform corresponding language conversion on the different types of process query languages. The relevant query types are converted according to the interface provided by the underlying process mining system, and the language interpreter 20 is also used to convert the logic of the time process query language into the language interception of the time dimension when the process query language is the time process query language Logic to complete the language conversion of time flow queries.

所述语言解释器20,还用于在所述流程查询语言为案例流程查询时,获取案例标识和案例时间信息,并根据所述案例标识和所述案例时间信息生成以时间排序的步骤序列和时间戳序列,以完成案例流程查询的语言转换。所述语言解释器20,还用于根据所述流程查询条件生成对应的算法逻辑;所述语言解释器20,还用于在所述流程查询条件为节点查询时,判断所述步骤序列是否匹配对应的节点,并在所述步骤序列匹配所述节点时,获取与所述节点匹配的步骤序列,以完成节点查询的语言转换。The language interpreter 20 is further configured to obtain a case identifier and case time information when the process query language is a case process query, and generate a time-ordered step sequence and Timestamp sequence to complete language translation of case flow queries. The language interpreter 20 is further configured to generate corresponding algorithm logic according to the process query condition; the language interpreter 20 is further configured to judge whether the step sequence matches when the process query condition is a node query corresponding node, and when the step sequence matches the node, obtain the step sequence matching the node, so as to complete the language conversion of the node query.

需要说明的是,当流程查询语言为案例流程查询时,可获取案例标识ID和案例时间信息,并根据案例标识和案例时间信息生成以时间排序的步骤序列和时间戳序列。然后再根据流程查询条件生成对应的算法逻辑。It should be noted that when the process query language is case process query, the case ID and case time information can be obtained, and a time-ordered step sequence and timestamp sequence can be generated according to the case ID and case time information. Then, the corresponding algorithm logic is generated according to the process query conditions.

语言解释器20,还用于在流程查询条件为节点查询时,判断以时间排序的步骤序列中是否有相匹配的节点,节点查询包括开始节点查询或结束节点查询,相匹配的节点包括开始节点和结束节点,当以时间排序的步骤序列中存在相匹配的节点时,获取与开始节点或结束节点匹配的步骤序列,并根据此步骤序列完成节点查询的语言转换。The language interpreter 20 is further configured to judge whether there is a matching node in the sequence of steps sorted by time when the process query condition is a node query, the node query includes a start node query or an end node query, and the matching node includes a start node and end node, when there is a matching node in the step sequence sorted by time, obtain the step sequence matching the start node or end node, and complete the language conversion of the node query according to this step sequence.

所述语言解释器20,还用于在所述流程查询条件为片段节点查询时,查找所述步骤序列是否存在关联的片段节点,并在所述步骤序列存在关联的片段节点时,截取与所述片段节点关联的步骤序列,以完成片段节点查询的语言转换。The language interpreter 20 is further configured to find out whether there is an associated segment node in the step sequence when the process query condition is a segment node query, and when there is an associated segment node in the step sequence, intercept and intercept the segment node associated with the step sequence. Describe the sequence of steps associated with fragment nodes to complete the language conversion of fragment node queries.

应理解的是,当流程查询条件为片段节点查询时,可查找当前步骤序列是否存在相关联的片段节点,片段节点包括开始节点和结束节点,当步骤序列存在相关联的开始节点或结束节点时,截取与片段节点相关联的步骤序列,并通过截取后的相关联的步骤序列完成片段节点查询的语言转换。It should be understood that when the process query condition is a segment node query, it can be searched whether there is an associated segment node in the current step sequence, and the segment node includes a start node and an end node. When the step sequence has an associated start node or end node. , intercept the step sequence associated with the segment node, and complete the language conversion of the segment node query through the intercepted associated step sequence.

所述语言解释器20,还用于在所述流程查询条件为耗时查询时,生成所述步骤序列与时间关联的查询代码,以根据所述查询代码进行耗时查询,以完成耗时查询的语言转换;所述语言解释器20,还用于在所述流程查询条件为路径查询时,将所述步骤序列与路径进行匹配,以完成路径查询的语言转换。The language interpreter 20 is further configured to generate a query code associated with the step sequence and time when the process query condition is a time-consuming query, so as to perform a time-consuming query according to the query code to complete the time-consuming query The language interpreter 20 is further configured to match the sequence of steps with the path when the process query condition is a path query, so as to complete the language conversion of the path query.

在具体实施中,当流程查询条件为耗时查询时,语言解释器20生成步骤序列与时间相关联的查询代码,并根据生成的查询代码进行耗时查询,以完成耗时查询的语言转换,当流程查询为路径查询时,语言解释器20用于将步骤序列与路径进行匹配,并在步骤序列与路径相匹配时,获取与路径相匹配的步骤序列,以完成路径查询的语言转换。In a specific implementation, when the process query condition is a time-consuming query, the language interpreter 20 generates a query code associated with the step sequence and time, and performs a time-consuming query according to the generated query code, so as to complete the language conversion of the time-consuming query, When the process query is a path query, the language interpreter 20 is used to match the step sequence with the path, and when the step sequence matches the path, obtain the step sequence matching the path to complete the language conversion of the path query.

进一步地,所述语言解释器20,还用于在所述流程查询条件为边查询时,确定边查询种类,根据所述边查询种类和所述步骤序列对边查询进行语言转换。边查询种类包括直连边查询、非连边查询、任意边查询以及不在任意边查询。语言解释器20可确定边查询种类,并根据边查询种类和步骤序列对边查询进行语言转换,当边查询种类为直连边时,可判断步骤序列是否出现两个相邻步骤,当步骤序列出现两个相邻步骤时,根据步骤序列中的两个相邻步骤对边查询进行语言转换。当边查询种类为非连边时,可判断步骤序列是否出现两个步骤并且不相邻,当步骤序列中出现两个步骤并且不相邻时,根据不相邻的两个步骤对边查询进行语言转换。当边查询种类为任意边查询时,判断步骤序列是否出现两个步骤,当步骤序列出现两个步骤时,通过两个步骤对边查询进行语言转换。当边查询种类为不在任意边查询时,判断步骤序列是否未出现两个步骤,当步骤序列未出现两个步骤时,对边查询进行语言转换。可快速根据不同的查询分类进入不同种类查询语言解释器20,实现语言转换。Further, the language interpreter 20 is further configured to determine the type of the edge query when the process query condition is an edge query, and perform language conversion on the edge query according to the type of the edge query and the sequence of steps. The types of edge queries include direct edge query, non-connect edge query, arbitrary edge query, and no edge query. The language interpreter 20 can determine the type of edge query, and perform language conversion on the edge query according to the type of edge query and the sequence of steps. When the type of the edge query is a directly connected edge, it can determine whether there are two adjacent steps in the sequence of steps. When two adjacent steps occur, the edge query is linguistically transformed according to the two adjacent steps in the sequence of steps. When the edge query type is non-connected edge, it can be judged whether there are two steps in the step sequence and they are not adjacent. Language conversion. When the type of the edge query is any edge query, it is judged whether there are two steps in the step sequence, and when there are two steps in the step sequence, the language conversion is performed on the edge query through the two steps. When the edge query type is not in any edge query, it is judged whether there are no two steps in the step sequence, and when there are no two steps in the step sequence, language conversion is performed on the edge query. It can quickly enter different types of query language interpreters 20 according to different query classifications to realize language conversion.

本实施例通过在语言转换模块中设置:语言解释器;所述语言解释器,用于接收不同种类的流程查询语言,并对不同种类的流程查询语言进行相应的语言转换;所述语言解释器,还用于在所述流程查询语言为时间流程查询语言时,将时间流程查询语言逻辑转换为时间维度的语言截取逻辑,以完成时间流程查询的语言转换,可快速根据流程查询语言的种类进行相应的语言转换,提高流程查询的效率。In this embodiment, the language conversion module is provided with: a language interpreter; the language interpreter is used to receive different kinds of process query languages, and perform corresponding language conversion for different kinds of process query languages; the language interpreter , and is also used to convert the time flow query language logic into the language interception logic of the time dimension when the process query language is the time flow query language, so as to complete the language conversion of the time flow query, which can be quickly performed according to the type of the process query language. Corresponding language conversion improves the efficiency of process query.

本发明实施例提供了一种流程查询方法,参照图3,图3为本发明流程查询方法第一实施例的流程示意图。An embodiment of the present invention provides a process query method. Referring to FIG. 3 , FIG. 3 is a schematic flowchart of the first embodiment of the process query method of the present invention.

本实施例中,所述流程查询方法包括以下步骤:In this embodiment, the process query method includes the following steps:

步骤S10:所述查询接口模块接收用户输入的流程查询条件,并根据所述流程查询条件进行语言分类,生成不同种类的流程查询语言。Step S10: The query interface module receives the process query conditions input by the user, and performs language classification according to the process query conditions to generate different types of process query languages.

应理解的是,查询接口模块用于接收用户输入的流程查询条件,流程查询条件为用户根据逻辑运算符进行组合得到的流程查询条件,逻辑运算符包括AND OR NOT等,本实施例对此不作限制。It should be understood that the query interface module is used to receive the process query conditions input by the user, and the process query conditions are the process query conditions obtained by the user according to the combination of logical operators. The logical operators include AND OR NOT, etc., which are not made in this embodiment. limit.

在具体实施中,查询接口模块还用于接收用户输入的流程查询字段,并通过逻辑运算符对流程查询字段进行组合,得到流程查询条件。用户通过定义好的查询接口模块输入查询的字段,通过逻辑运算符组合各种查询,得到对应的流程查询条件。查询接口模块得到流程查询条件后,根据流程查询条件进行语言分类,生成不同种类的流程查询语言。In a specific implementation, the query interface module is further configured to receive the process query fields input by the user, and combine the process query fields through logical operators to obtain the process query conditions. The user enters the query field through the defined query interface module, and combines various queries through logical operators to obtain the corresponding process query conditions. After obtaining the process query conditions, the query interface module performs language classification according to the process query conditions to generate different types of process query languages.

步骤S20:所述语言转换模块对不同种类的流程查询语言进行解析,根据解析结果对每种流程查询语言进行相应的语言转换,得到多种转换后的流程查询语言。Step S20: The language conversion module parses different types of process query languages, and performs corresponding language conversion for each process query language according to the parsing results to obtain multiple converted process query languages.

需要说明的是,语言转换模块用于对不同种类的流程查询语言进行解析,并根据解析结果对每种流程查询语言进行相应的语言转换,得到多种转换后的流程查询语言,语言转换模块包括语言解释器,通过得到不同种类的查询语言,输入至对应的查询语言解释器进行语言解析和转换,得到多种转换后的流程查询语言。It should be noted that the language conversion module is used to parse different types of process query languages, and perform corresponding language conversion for each process query language according to the analysis results to obtain multiple converted process query languages. The language conversion module includes: The language interpreter obtains different kinds of query languages and inputs them to the corresponding query language interpreter for language analysis and conversion, and obtains a variety of converted process query languages.

步骤S30:所述查询优化模块将所述转换后的流程查询语言和所述流程查询条件进行优化。Step S30: The query optimization module optimizes the converted process query language and the process query conditions.

可以理解的是,查询优化模块用于将转换后的流程查询语言和流程查询条件进行优化,得到优化后的流程查询语言和优化后的流程查询条件,可将流程查询语言中的时间范围的查询提前,或者将基于日志级别的查询条件放在前面,可快速过滤掉不必要的日志数据,达到流程查询的优化结果,提高流程查询的效率。It can be understood that the query optimization module is used to optimize the converted process query language and process query conditions to obtain the optimized process query language and optimized process query conditions, which can query the time range in the process query language. In advance, or put the query conditions based on the log level in the front, you can quickly filter out unnecessary log data, achieve the optimized results of the process query, and improve the efficiency of the process query.

具体地,所述查询优化模块,还用于在流程查询条件为时间流程查询时,获取对应的时间范围,并将时间范围的查询条件提前,由于流程查询系统的流程挖掘底层是基于时间设计,因此可将时间范围的查询提前。所述查询优化模块,还用于在所述流程查询条件为日志查询时,将关联日志的查询条件提前,并对日志数据进行处理,把相关基于日志级别的查询条件放前面,可快速的过滤掉不必要的日志数据。Specifically, the query optimization module is further configured to obtain a corresponding time range when the process query condition is a time process query, and advance the query condition of the time range. Since the bottom layer of the process mining of the process query system is designed based on time, Therefore, the query of the time range can be advanced. The query optimization module is also used to advance the query conditions of the associated logs when the process query conditions are log queries, process the log data, and put the relevant query conditions based on the log level in the front, which can quickly filter Delete unnecessary log data.

所述查询优化模块,还用于在所述流程查询条件为多个案例查询时,将所述多个案例查询进行合并;所述查询优化模块,还用于在所述流程查询条件为片段节点查询或耗时查询时,将所述片段节点查询对应的查询语言或所述耗时查询对应的查询语言提前。The query optimization module is further configured to combine the multiple case queries when the process query conditions are multiple case queries; the query optimization module is further configured to combine the process query conditions as fragment nodes When querying or time-consuming query, the query language corresponding to the fragment node query or the query language corresponding to the time-consuming query is advanced.

应理解的是,查询优化模块,还用于在流程查询条件为多个案例查询时,可将多个案例查询进行合并,例如需要查询案例A和查询案例B这两个查询条件,则可将此案例A和案例B进行合并,合并成一个案例查询,提高案例查询的效率。查询优化模块还用于在流程查询条件为片段节点或者耗时查询时,可将片段节点查询对应的查询语言或者耗时查询对应的查询语言筛选提前,保证筛选的正确性。It should be understood that the query optimization module is also used to combine multiple case queries when the process query conditions are multiple case queries. For example, if two query conditions of query case A and query case B are required, then This case A and case B are merged into one case query, which improves the efficiency of case query. The query optimization module is also used to filter the query language corresponding to the fragment node query or the query language corresponding to the time-consuming query in advance when the process query condition is a fragment node or a time-consuming query, so as to ensure the correctness of the screening.

本实施例通过在流程查询系统中设置查询接口模块、语言转换模块以及查询优化模块;所述查询接口模块,用于接收用户输入的流程查询条件,并根据所述流程查询条件进行语言分类,生成不同种类的流程查询语言;所述语言转换模块,用于对不同种类的流程查询语言进行解析,根据解析结果对每种流程查询语言进行相应的语言转换,得到多种转换后的流程查询语言;所述查询优化模块,用于将所述转换后的流程查询语言和所述流程查询条件进行优化,可根据优化后的流程进行查询,提高流程查询的效率。In this embodiment, a query interface module, a language conversion module and a query optimization module are set in the process query system; the query interface module is used to receive the process query conditions input by the user, and perform language classification according to the process query conditions, and generate Different types of process query languages; the language conversion module is used to parse different types of process query languages, and perform corresponding language conversion for each process query language according to the parsing results to obtain multiple converted process query languages; The query optimization module is configured to optimize the converted process query language and the process query conditions, and can perform query according to the optimized process to improve the efficiency of process query.

应当理解的是,以上仅为举例说明,对本发明的技术方案并不构成任何限定,在具体应用中,本领域的技术人员可以根据需要进行设置,本发明对此不做限制。It should be understood that the above are only examples, and do not constitute any limitation to the technical solutions of the present invention. In specific applications, those skilled in the art can make settings as required, which is not limited by the present invention.

需要说明的是,以上所描述的工作流程仅仅是示意性的,并不对本发明的保护范围构成限定,在实际应用中,本领域的技术人员可以根据实际的需要选择其中的部分或者全部来实现本实施例方案的目的,此处不做限制。It should be noted that the above-described workflow is only illustrative, and does not limit the protection scope of the present invention. In practical applications, those skilled in the art can select some or all of them to implement according to actual needs. The purpose of the solution in this embodiment is not limited here.

另外,未在本实施例中详尽描述的技术细节,可参见本发明任意实施例所提供的流程查询方法,此处不再赘述。In addition, for technical details not described in detail in this embodiment, reference may be made to the process query method provided by any embodiment of the present invention, and details are not described herein again.

此外,需要说明的是,在本文中,术语“包括”、“包含”或者其任何其他变体意在涵盖非排他性的包含,从而使得包括一系列要素的过程、方法、物品或者系统不仅包括那些要素,而且还包括没有明确列出的其他要素,或者是还包括为这种过程、方法、物品或者系统所固有的要素。在没有更多限制的情况下,由语句“包括一个……”限定的要素,并不排除在包括该要素的过程、方法、物品或者系统中还存在另外的相同要素。Furthermore, it should be noted that, herein, the terms "comprising", "comprising" or any other variation thereof are intended to encompass non-exclusive inclusion, such that a process, method, article or system comprising a series of elements includes not only those elements, but also other elements not expressly listed or inherent to such a process, method, article or system. Without further limitation, an element qualified by the phrase "comprising a..." does not preclude the presence of additional identical elements in the process, method, article or system that includes the element.

上述本发明实施例序号仅仅为了描述,不代表实施例的优劣。The above-mentioned serial numbers of the embodiments of the present invention are only for description, and do not represent the advantages or disadvantages of the embodiments.

通过以上的实施方式的描述,本领域的技术人员可以清楚地了解到上述实施例方法可借助软件加必需的通用硬件平台的方式来实现,当然也可以通过硬件,但很多情况下前者是更佳的实施方式。基于这样的理解,本发明的技术方案本质上或者说对现有技术做出贡献的部分可以以软件产品的形式体现出来,该计算机软件产品存储在一个存储介质(如只读存储器(Read Only Memory,ROM)/RAM、磁碟、光盘)中,包括若干指令用以使得一台终端设备(可以是手机,计算机,服务器,或者网络设备等)执行本发明各个实施例所述的方法。From the description of the above embodiments, those skilled in the art can clearly understand that the methods of the above embodiments can be implemented by means of software plus a necessary general hardware platform, and of course hardware can also be used, but in many cases the former is better implementation. Based on such understanding, the technical solutions of the present invention can be embodied in the form of software products in essence or the parts that make contributions to the prior art, and the computer software products are stored in a storage medium (such as a read-only memory). , ROM)/RAM, magnetic disk, optical disk), including several instructions to make a terminal device (which may be a mobile phone, a computer, a server, or a network device, etc.) execute the methods described in the various embodiments of the present invention.

以上仅为本发明的优选实施例,并非因此限制本发明的专利范围,凡是利用本发明说明书及附图内容所作的等效结构或等效流程变换,或直接或间接运用在其他相关的技术领域,均同理包括在本发明的专利保护范围内。The above are only preferred embodiments of the present invention, and are not intended to limit the scope of the present invention. Any equivalent structure or equivalent process transformation made by using the contents of the description and drawings of the present invention, or directly or indirectly applied in other related technical fields , are similarly included in the scope of patent protection of the present invention.

Claims (10)

1. A process query system, comprising: the query interface module, the language conversion module and the query optimization module;
the query interface module is used for receiving process query conditions input by a user, performing language classification according to the process query conditions and generating different types of process query languages;
the language conversion module is used for analyzing different types of process query languages, and performing corresponding language conversion on each process query language according to an analysis result to obtain multiple converted process query languages;
and the query optimization module is used for optimizing the converted process query language and the process query condition.
2. The process query system of claim 1, wherein said language translation module comprises: a language interpreter;
the language interpreter is used for receiving different types of process query languages and performing corresponding language conversion on the different types of process query languages;
the language interpreter is further configured to convert the time flow query language logic into a time dimension language interception logic when the flow query language is a time flow query language, so as to complete language conversion of the time flow query.
3. The process query system of claim 2, wherein the language interpreter is further configured to obtain case identifications and case time information when the process query language is a case process query, and generate a time-ordered sequence of steps and a time stamp sequence according to the case identifications and the case time information to complete language conversion of the case process query.
4. The process query system of claim 3, wherein said language interpreter is further configured to generate corresponding algorithmic logic based on said process query criteria;
and the language interpreter is also used for judging whether the step sequence is matched with the corresponding node or not when the process query condition is node query, and acquiring the step sequence matched with the node when the step sequence is matched with the node so as to complete the language conversion of the node query.
5. The process query system of claim 4, wherein the language interpreter is further configured to, when the process query condition is a segment node query, find whether there is an associated segment node in the step sequence, and, when there is an associated segment node in the step sequence, intercept the step sequence associated with the segment node to complete the language conversion of the segment node query.
6. The process query system of claim 4, wherein the language interpreter is further configured to generate a query code associated with the step sequence and time when the process query condition is a time-consuming query, so as to perform the time-consuming query according to the query code to complete language conversion of the time-consuming query;
and the language interpreter is also used for matching the step sequence with the path when the process query condition is path query so as to complete the language conversion of the path query.
7. The process query system of claim 4, wherein the language interpreter is further configured to determine an edge query type when the process query condition is an edge query, and perform language conversion on the edge query according to the edge query type and the step sequence.
8. The process query system of claim 1, wherein the query optimization module is further configured to obtain a time range and advance the query of the time range when the process query condition is a time process query;
the query optimization module is further configured to advance query conditions of the associated logs and process log data when the process query conditions are log queries;
the query optimization module is further configured to merge the multiple case queries when the process query condition is multiple case queries;
the query optimization module is further configured to advance a query language corresponding to the segment node query or a query language corresponding to the time-consuming query when the process query condition is the segment node query or the time-consuming query.
9. The process query system of any one of claims 1-8, wherein the query interface module is further configured to receive process query fields input by a user, and combine the process query fields through logical operators to obtain process query conditions.
10. A process query method applied to the process query system of any one of claims 1 to 9, the process query system comprising: the method comprises a query interface module, a language conversion module and a query optimization module, and comprises the following steps:
the query interface module receives a process query condition input by a user, and performs language classification according to the process query condition to generate different types of process query languages;
the language conversion module analyzes different types of process query languages, and performs corresponding language conversion on each process query language according to an analysis result to obtain multiple converted process query languages;
and the query optimization module optimizes the converted process query language and the process query condition.
CN202210528411.2A 2022-05-16 2022-05-16 Flow query system and method Active CN115203229B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210528411.2A CN115203229B (en) 2022-05-16 2022-05-16 Flow query system and method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210528411.2A CN115203229B (en) 2022-05-16 2022-05-16 Flow query system and method

Publications (2)

Publication Number Publication Date
CN115203229A true CN115203229A (en) 2022-10-18
CN115203229B CN115203229B (en) 2025-09-19

Family

ID=83574437

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210528411.2A Active CN115203229B (en) 2022-05-16 2022-05-16 Flow query system and method

Country Status (1)

Country Link
CN (1) CN115203229B (en)

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20090319501A1 (en) * 2008-06-24 2009-12-24 Microsoft Corporation Translation of streaming queries into sql queries
CN104346383A (en) * 2013-07-31 2015-02-11 上海云端广告有限公司 Data access control method and system
CN107071190A (en) * 2016-12-31 2017-08-18 国家电网公司客户服务中心 The method for finding telephone traffic system problem in time using traffic platform data
CN113553340A (en) * 2021-07-23 2021-10-26 咪咕文化科技有限公司 User query method, apparatus, electronic device, and computer-readable storage medium
CN114357276A (en) * 2021-12-23 2022-04-15 北京百度网讯科技有限公司 Data query method, device, electronic device and storage medium

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20090319501A1 (en) * 2008-06-24 2009-12-24 Microsoft Corporation Translation of streaming queries into sql queries
CN104346383A (en) * 2013-07-31 2015-02-11 上海云端广告有限公司 Data access control method and system
CN107071190A (en) * 2016-12-31 2017-08-18 国家电网公司客户服务中心 The method for finding telephone traffic system problem in time using traffic platform data
CN113553340A (en) * 2021-07-23 2021-10-26 咪咕文化科技有限公司 User query method, apparatus, electronic device, and computer-readable storage medium
CN114357276A (en) * 2021-12-23 2022-04-15 北京百度网讯科技有限公司 Data query method, device, electronic device and storage medium

Also Published As

Publication number Publication date
CN115203229B (en) 2025-09-19

Similar Documents

Publication Publication Date Title
CN106951430B (en) Account table query method and device
CN110515973B (en) Data query optimization method, device, equipment and storage medium
US7676453B2 (en) Partial query caching
CN108563734B (en) System information query method, device, computer equipment and storage medium
US20090049021A1 (en) System and method for storing text annotations with associated type information in a structured data store
CN110188568B (en) Confidential information identification method, apparatus, device and computer readable storage medium
CN110427188B (en) Configuration method, device, equipment and storage medium of single-test assertion program
CN118568123A (en) SQL sentence generation method, device, computer equipment and storage medium
CN109977175B (en) Data configuration query method and device
CN117112408A (en) Method, device and medium for generating automatic test case script
CN110232028A (en) A kind of test exemple automation operation method and system
US9053207B2 (en) Adaptive query expression builder for an on-demand data service
CN107729428A (en) A kind of SQL query method based on Presto and Elasticsearch
CN110309214B (en) Instruction execution method and equipment, storage medium and server thereof
CN114722036A (en) Data processing method and device, electronic equipment and readable storage medium
CN111311329B (en) Tag data acquisition method, device, equipment and readable storage medium
EP4191438A1 (en) Software information organization method and device, and computer-readable medium
CN117453720A (en) Structured query statement analysis method, device, equipment and storage medium
Jian et al. SPARQL rewriting: Towards desired results
CN110781520A (en) Sensitive table group discovery method and system
CN115203229A (en) Process query system and method
CN119903056A (en) A method for constructing table-level blood relationship information based on task operation logs
CN115168399B (en) Data processing method, device, equipment and storage medium based on graphical interface
CN118886056A (en) A data security management method and device based on multiple databases
CN112182177B (en) User problem processing method and device, electronic equipment and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant