WO2022134363A1 - Procédé et appareil d'intégration de rapport de service, dispositif et support d'enregistrement - Google Patents

Procédé et appareil d'intégration de rapport de service, dispositif et support d'enregistrement Download PDF

Info

Publication number
WO2022134363A1
WO2022134363A1 PCT/CN2021/084534 CN2021084534W WO2022134363A1 WO 2022134363 A1 WO2022134363 A1 WO 2022134363A1 CN 2021084534 W CN2021084534 W CN 2021084534W WO 2022134363 A1 WO2022134363 A1 WO 2022134363A1
Authority
WO
WIPO (PCT)
Prior art keywords
business
business reports
report
reports
coupling relationship
Prior art date
Application number
PCT/CN2021/084534
Other languages
English (en)
Chinese (zh)
Inventor
王雍富
贺春艳
孙燕
梁丽娜
Original Assignee
平安科技(深圳)有限公司
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 平安科技(深圳)有限公司 filed Critical 平安科技(深圳)有限公司
Publication of WO2022134363A1 publication Critical patent/WO2022134363A1/fr

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR 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/22Indexing; Data structures therefor; Storage structures
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR 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
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR 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
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/30Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
    • G06F16/36Creation of semantic tools, e.g. ontology or thesauri
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00Energy efficient computing, e.g. low power processors, power management or thermal management

Definitions

  • the present application relates to the field of data processing, and in particular, to a method, apparatus, device and storage medium for integrating business reports.
  • a database also known as a data management system, is a collection of data in which the processed data is stored together in a certain way, allowing multiple users to share and reducing redundancy as much as possible.
  • the inventor realized that when saving business data, due to the limitations of the database or when developers develop different functions, the same type of business data may be stored in multiple databases respectively, and each database needs to be traversed during retrieval. This makes the retrieval process very cumbersome. Even some business data will be saved repeatedly, wasting storage space, so a method of integrating business reports is urgently needed.
  • the main purpose of the present application is to provide a method, device, device and storage medium for integrating business reports, which aims to solve the problem that each database needs to be traversed during retrieval, which makes the retrieval process very cumbersome.
  • This application provides a method for integrating business reports, including:
  • the application also provides a device for integrating business reports, including:
  • the search module is used to search the source database that saves the business report
  • a reading module configured to read the library table information in each of the source databases, and generate a data dictionary according to each of the library table information, wherein the data dictionary records the location information of each of the business reports;
  • a generating module configured to generate respective acquisition scripts corresponding to each business report according to the data dictionary, and obtain a task script for operating each of the business reports according to each of the acquisition scripts;
  • an acquisition module used to recursively parse each of the task scripts to acquire the coupling relationship between each of the business reports
  • the storage module is used for acquiring the business reports in each source database, and storing the business reports and the coupling relationship between the business reports to obtain the target database.
  • the present application also provides a computer device, including a memory and a processor, wherein the memory stores computer-readable instructions, and when the computer-readable instructions are executed by the processor, the processor executes the integrated business report The steps of the method:
  • the present application also provides a storage medium storing computer-readable instructions.
  • the computer-readable instructions When the computer-readable instructions are executed by one or more processors, the one or more processors perform the steps of the computer device:
  • the corresponding task script is obtained by setting the obtaining script, and the coupling relationship between the business reports is parsed, and the business reports in each source database and the coupling relationship between the business reports are obtained and saved.
  • the target database contains all the business reports in each source database, and also retains the coupling relationship between each business report in the source database, so that when relevant personnel search in the target database, they do not need to traverse multiple source databases, and can get with traversing multiple source databases for retrieval results.
  • FIG. 1 is a schematic flowchart of a method for integrating business reports according to an embodiment of the present application
  • FIG. 2 is a schematic structural block diagram of an apparatus for integrating business reports according to an embodiment of the present application
  • FIG. 3 is a schematic structural block diagram of a computer device according to an embodiment of the present application.
  • the present application proposes a method for integrating business reports, including:
  • S2 Read the library table information in each of the source databases, and generate a data dictionary according to each of the library table information; wherein the data dictionary records the location information of each of the business reports;
  • S3 Generate respective acquisition scripts corresponding to each business report according to the data dictionary, and obtain a task script for operating each of the business reports according to each of the acquisition scripts;
  • S5 Acquire the business reports in each source database, and store the business reports and the coupling relationship between the business reports in the target database.
  • the source database storing the business report is searched.
  • the way to obtain it is to first obtain the header information of the required business report, and then set the corresponding automated script according to the header information to read the library table information in each initial database.
  • the header information generally refers to the business report.
  • the set automation script can be only the header information, or can include the synonymous information of the header information, so that the obtained business data report is more comprehensive.
  • the settings of the automation script can be set by themselves according to the header information, or can be set by the developer.
  • the library table information in each of the source databases is read, and a data dictionary is generated according to each of the library table information.
  • the reading method may be to read the library table information in the initial database according to the automated script, filter out the source database with business reports, and obtain the library table information in the source database, where the library table information is the directory of different data tables.
  • the database generally establishes the database table information to facilitate the query of the corresponding data. If there is no database table information, the database table information can be obtained by traversing, and then the corresponding data dictionary is generated according to the database table information.
  • a duplicate check can be performed, that is, it can be detected whether there is a business report with the same title. If so, you can obtain only one of the business reports to avoid the problem of data duplication.
  • an acquisition script corresponding to each business report is generated according to the data dictionary, and a task script for operating each of the business reports is acquired according to each of the acquisition scripts.
  • the task script can exist in the source database or in a third-party channel such as a third client, and can be obtained by obtaining the script at the set location.
  • a plurality of corresponding acquisition scripts are set according to the data dictionary, wherein, in addition to acquiring the corresponding business report, the acquisition script should also acquire a task script related to the business report.
  • each task script is a task script for operating the business report, that is, by obtaining the business report for operating the business report, the use of the business report can be known, and the situation of each business report being called in the source database can be known, that is, the same as that of the source database. Coupling relationship of other business reports.
  • each of the task scripts is recursively parsed to obtain the coupling relationship between each of the business reports. Since the execution process of the task script may be very complicated, it may be difficult to obtain the final result by direct analysis. Therefore, the execution steps of each task script can be obtained, and the final result can be obtained by reverse recursion, that is, the recursion of each task script. Parse.
  • the business reports in each source database are acquired, and the business reports and the coupling relationship between the business reports are stored to obtain the target database.
  • the business reports obtained from each source database and the coupling relationship between the parsed business reports are stored. Therefore, the obtained target database not only contains all the business reports in each source database, but also retains the coupling relationship between each business report in the source database, so that the relevant personnel do not need to traverse multiple source databases when searching in the target database. It is also possible to obtain and traverse the retrieval results in multiple source databases.
  • the step S4 of recursively analyzing each of the task scripts to obtain the coupling relationship between each of the business reports includes:
  • S403 Perform executable processing on the non-executable SQL statement to obtain an executable target task script
  • S404 Parse the target task script, and build a work stack based on the parsed content; wherein, the work stack includes each step executed by the target task script;
  • S405 Recursively analyze the calculation functions in each step of the work stack to obtain the coupling relationship between the business reports.
  • the task script includes at least one SQL (Structured Query Language, Structured Query Language) statement, and the corresponding task in the task script has been completed.
  • SQL Structured Query Language
  • the coupling relationship between various business reports is mainly obtained, that is, in this task script
  • the business report executed in the SQL statement is first detected (it should be noted that SQL does not contain business reports, but only includes processing, calling and other execution commands for each business report). Since the obtained SQL statement It often contains instructions, special functions, custom functions, dynamic parameter transfer, etc. to make SQL statements unexecutable.
  • Parse the target task script and establish a work stack wherein the way of establishing the work stack can be by establishing an abstract syntax tree, combining the conditional judgment in the target task script to set the nodes of the abstract syntax tree, and then according to the execution steps of the target task script,
  • the result of the reverse derivation of the abstract syntax tree that is, the order in which each business report is called, in which, through the above recursive calculation method, a large and complex problem can be transformed into a smaller problem similar to the original problem. Solve, simplify the operation difficulty.
  • the step S404 of parsing the target task script and establishing a work stack includes:
  • S4042 Traverse the depth of the ASTNode abstract syntax tree, and parse out the output input table and the condition judgment statement of the ASTNode abstract syntax tree;
  • the target task script is first converted into the ASTNode abstract syntax tree.
  • the ASTNode abstract syntax tree does not depend on the specific grammar and does not depend on the details of the language, which can solve the redundant components brought by the grammar analysis. The redundant components may be It will adversely affect the subsequent stages.
  • the target task script is a step that is judged by conditions and executed in sequence. If the equivalent exchange of grammars is performed before, it may affect the subsequent steps. Therefore, using the ASTNode abstract syntax tree can solve the technical problems brought by the grammar. Specifically, the target task script is first converted into an ASTNode abstract syntax tree.
  • the conversion method can be to set the nodes of the tree according to the conditional judgment in the target task script, and set the branches of the tree according to the relationship between the various steps, thereby Get the corresponding ASTNode abstract syntax tree.
  • set the corresponding execution plan that is, first calculate the result that can be calculated, and then return the calculated result to the previous node to continue the calculation, and use the above calculation method to obtain the corresponding execution plan, so as to obtain the work. stack.
  • the step S5 of storing the business reports and the coupling relationship between the business reports in the target database includes:
  • S502 Sort out hierarchical rules according to the table information
  • S504 Perform cluster analysis on the business reports of the same level, and give the same labels to the business reports of the same class according to the analysis results;
  • S505 Classify and store each of the business reports in the target database according to the labels of each of the business reports, and store the coupling relationship between the business reports.
  • the classified storage of the business report is realized. That is, first obtain the table information of the business report (generally only the header), and after obtaining the table information of each business report, you can sort out the corresponding hierarchical rules.
  • the way of sorting is to set the correspondence between the table information and the level in advance. relationship, and then obtain the hierarchical rules that adapt to all business tables according to the table information, that is, some business reports may be derived from the content of other business reports, but this is generally recorded in the header, so according to the header You can divide the levels of each business report, divide each business report into different levels, and then perform cluster analysis.
  • the clustering method can be text clustering algorithm (clustering algorithm based on division, clustering algorithm, density-based clustering algorithm, grid-based clustering algorithm, model-based clustering algorithm, and fuzzy-based clustering algorithm), and then assign the same label to the business report of the same type. Subsequently, each business report and the coupling relationship between the business reports are saved in the target database according to the corresponding tags.
  • the step S5 of storing the business reports and the coupling relationship between the business reports in the target database includes:
  • S511 Obtain script information of the task script; wherein, the script information at least includes a script path, an operation type, and an associated business report involved;
  • S513 Set a corresponding weight for each of the associated business reports according to the number of occurrences of each of the associated business reports;
  • S514 Set the vertex information as the primary key of the associated service report, set the weight as the vertex attribute of the associated service report to save, and save the coupling relationship between each of the service reports.
  • each business report is a vertex
  • the data content it contains is vertex attribute.
  • the relationship between vertices and vertices is the coupling relationship between business reports
  • the vertex attribute is the basis for the importance of the business report, that is, in the later retrieval process, if the vertex attribute is good, you can first
  • the vertex is traversed.
  • the script information of the task script is obtained, wherein the script information includes the corresponding script path, the operation type, the related business report involved, and even the data source in the script data. According to the script information, the corresponding association can be obtained.
  • the number of occurrences of business reports and related business reports, and the vertex information (that is, the information of the business report, including the content in the business report and the coupling relationship with other business reports, etc.), set the weight for the related business report according to the number of occurrences of the related business report , so as to facilitate subsequent retrieval, it should be understood that the more times the associated business report appears, the greater its weight, the less the number of times the associated business report appears, the smaller its weight, and then set the primary key for the associated business report, where the primary key For the representation of the associated business report, it can be data encrypted with script information, or directly use the script information as the primary key, and then set the weight as the vertex attribute to save, thus realizing the preservation of each business report.
  • the method further includes:
  • S601 Detect intermediate temporary tables in each of the business reports according to a set detection rule
  • S602 Obtain a first report that has a blood relationship with the intermediate temporary table, and a second report that has an associated relationship with the intermediate temporary table; the first report and the second report are both the business report;
  • S604 Delete the intermediate temporary table to establish a knowledge graph of the target database.
  • the optimization of the target database is realized. That is, the intermediate temporary tables in each of the business reports are detected according to the set detection rules.
  • the set detection rule can be set as the detection header, that is, according to the information in the header, you can know whether the business report is The intermediate temporary table, and then obtain the first report that has a blood relationship with the intermediate temporary table and the second report that has an associated relationship. The relationship of the table to other business reports.
  • the coupling relationship between the first report and the second report is directly established.
  • the label of the intermediate temporary table can be marked as False
  • the graph relationships in the target database include four types of False-True, False-False, True-False, and True-True.
  • the coupling relationship between True-True does not need to be processed. False-True, False-False, True-False, perform Pregel graph iterative calculation, every time True-n Talse-tures are encountered, the head-to-tail relationship is stored in the vertex attribute set. Delete the False vertices, and directly establish the relationship between True and True according to the attribute set. This simplifies the knowledge graph of the target database, enables users to extract valuable data more clearly and intuitively, and facilitates the maintenance of the target database.
  • the present application also provides a device for integrating business reports, including:
  • the search module 10 is used to search the source database that saves the business report
  • the reading module 20 is used to read the library table information in each of the source databases, and generate a data dictionary according to each of the library table information, wherein the data dictionary records the location information of each of the business reports;
  • the generating module 30 is configured to generate respectively corresponding acquisition scripts of each business report according to the data dictionary, and acquire a task script for operating each of the business reports according to each of the acquisition scripts;
  • an acquisition module 40 used for recursively analyzing each of the task scripts to acquire the coupling relationship between each of the business reports;
  • the storage module 50 is configured to acquire the business reports in each source database, and store the business reports and the coupling relationship between the business reports in the target database.
  • the obtaining module 40 includes:
  • a detection submodule for detecting the business report executed in each of the SQL statements, and whether the SQL statements are executable
  • a processing submodule for performing executable processing on the unexecutable SQL statement to obtain an executable processing target task script
  • the parsing submodule is used for recursively parsing the calculation functions in each step of the work stack to obtain the coupling relationship between the business reports.
  • a sub-module is established, including:
  • a traversing unit used to traverse the depth of the ASTNode abstract syntax tree, and parse out the output input table and the condition judgment statement of the ASTNode abstract syntax tree;
  • a setting unit configured to set the execution plan of the ASTNode abstract syntax tree according to the output and input table and the conditional judgment statement, so as to obtain the work stack.
  • the storage module 50 includes:
  • a form information acquisition sub-module used to acquire the form information of each of the business reports
  • a clustering submodule for performing cluster analysis on the business reports of the same level, and assigning the same labels to the business reports of the same class according to the analysis results;
  • the storage sub-module is configured to classify and store each of the business reports in the target database according to the labels of each of the business reports, and store the coupling relationship between the business reports.
  • the storage module 50 further includes:
  • a script information acquisition sub-module used for acquiring script information of the task script; wherein the script information at least includes a script path, an operation type and a related business report;
  • a script information analysis sub-module for analyzing the script information to obtain the occurrence times and vertex information of each of the associated business reports
  • a weight setting submodule configured to set a corresponding weight for each of the associated business reports according to the number of occurrences of each of the associated business reports;
  • the primary key setting submodule is used to set the vertex information as the primary key of the associated business report, and to set the weight as the vertex attribute of the associated business report to save, and to save the relationship between each of the business reports. coupling relationship.
  • the device for integrating business reports further includes:
  • an intermediate temporary table detection module used for detecting the intermediate temporary table in each of the business reports according to the set detection rules
  • the first report obtaining module is used to obtain a first report that has a blood relationship with the intermediate temporary table, and a second report that has an associated relationship with the intermediate temporary table; the first report and the second report are for said business statement;
  • a coupling relationship establishing module configured to directly establish a coupling relationship between the first statement and the second statement according to the coupling relationship between the intermediate temporary table and the second statement;
  • a deletion module is used to delete the intermediate temporary table to establish a knowledge graph of the target database.
  • the beneficial effects of the present application are as follows: the corresponding task script is acquired by setting the acquisition script, and the coupling relationship between the business reports is parsed, and the business reports in each source database and the coupling relationship between the business reports are acquired, saved and stored.
  • the target database contains all the business reports in each source database, and also retains the coupling relationship between each business report in the source database, so that when the relevant personnel search in the target database, they do not need to traverse multiple source databases, and can get with traversing multiple source databases for retrieval results.
  • an embodiment of the present application further provides a computer device.
  • the computer device may be a server, and its internal structure may be as shown in FIG. 3 .
  • the computer device includes a processor, memory, a network interface and a database connected by a system bus.
  • the processor of the computer design is used to provide computing and control capabilities.
  • the memory of the computer device includes a non-volatile storage medium, an internal memory.
  • the nonvolatile storage medium stores an operating system, a computer program, and a database.
  • the memory provides an environment for the execution of the operating system and computer programs in the non-volatile storage medium.
  • the database of the computer equipment is used to store various business reports and the like.
  • the network interface of the computer device is used to communicate with an external terminal through a network connection.

Landscapes

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

Abstract

La présente invention concerne un procédé et un appareil d'intégration de rapport de service, un dispositif et un support d'enregistrement, qui se rapportent au domaine de l'intelligence artificielle. Le procédé consiste à : réaliser une recherche dans des bases de données sources qui stockent des rapports de service (S1) ; lire des informations de table de base de données dans chaque base de données source et générer un dictionnaire de données selon chaque élément des informations de table de base de données (S2) ; selon le dictionnaire de données, générer un script d'acquisition correspondant respectivement à chaque rapport de service et, selon chaque script d'acquisition, acquérir un script de tâche pour faire fonctionner chaque rapport de service (S3) ; analyser de manière récursive les scripts de tâche de façon à acquérir des relations de couplage entre les rapports de service (S4) ; et acquérir les rapports de service dans chaque base de données source et stocker les rapports de service et les relations de couplage entre les rapports de service pour obtenir une base de données cible (S5). L'effet bénéfique est que la base de données cible n'a pas seulement tous les rapports de service dans chaque base de données source, mais conserve également les relations de couplage entre les rapports de service dans les bases de données sources.
PCT/CN2021/084534 2020-12-24 2021-03-31 Procédé et appareil d'intégration de rapport de service, dispositif et support d'enregistrement WO2022134363A1 (fr)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN202011549416.0A CN112667630B (zh) 2020-12-24 2020-12-24 整合业务报表的方法、装置、设备以及存储介质
CN202011549416.0 2020-12-24

Publications (1)

Publication Number Publication Date
WO2022134363A1 true WO2022134363A1 (fr) 2022-06-30

Family

ID=75409843

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2021/084534 WO2022134363A1 (fr) 2020-12-24 2021-03-31 Procédé et appareil d'intégration de rapport de service, dispositif et support d'enregistrement

Country Status (2)

Country Link
CN (1) CN112667630B (fr)
WO (1) WO2022134363A1 (fr)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114818645B (zh) * 2022-06-29 2022-10-28 深圳红途科技有限公司 基于数据主体的自动化报告生成方法、装置、设备及介质
CN115423595B (zh) * 2022-11-02 2023-03-28 深圳高灯计算机科技有限公司 文件信息处理方法、装置、计算机设备和存储介质
CN116303370B (zh) * 2023-05-17 2023-08-15 建信金融科技有限责任公司 一种脚本血缘解析方法、装置、存储介质、设备及产品

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20110202831A1 (en) * 2010-02-15 2011-08-18 Microsoft Coproration Dynamic cache rebinding of processed data
CN104036040A (zh) * 2014-06-30 2014-09-10 贝壳网际(北京)安全技术有限公司 报表生成方法及装置
CN104252443A (zh) * 2013-06-28 2014-12-31 腾讯科技(深圳)有限公司 报表生成方法及装置
CN105893488A (zh) * 2016-03-29 2016-08-24 国云科技股份有限公司 一种便捷灵活自制的数据统计报表制作方法
CN111666743A (zh) * 2020-04-28 2020-09-15 平安科技(深圳)有限公司 报表自动生成方法、装置、计算机设备及存储介质

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102541867A (zh) * 2010-12-15 2012-07-04 金蝶软件(中国)有限公司 数据字典生成方法及系统
CN105224536A (zh) * 2014-05-29 2016-01-06 国际商业机器公司 划分数据库的方法和装置
CN111125254A (zh) * 2019-12-23 2020-05-08 北京懿医云科技有限公司 数据库同步方法、装置、电子设备及计算机可读介质
CN111914066B (zh) * 2020-08-17 2024-02-02 山东合天智汇信息技术有限公司 多源数据库全局搜索方法及系统

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20110202831A1 (en) * 2010-02-15 2011-08-18 Microsoft Coproration Dynamic cache rebinding of processed data
CN104252443A (zh) * 2013-06-28 2014-12-31 腾讯科技(深圳)有限公司 报表生成方法及装置
CN104036040A (zh) * 2014-06-30 2014-09-10 贝壳网际(北京)安全技术有限公司 报表生成方法及装置
CN105893488A (zh) * 2016-03-29 2016-08-24 国云科技股份有限公司 一种便捷灵活自制的数据统计报表制作方法
CN111666743A (zh) * 2020-04-28 2020-09-15 平安科技(深圳)有限公司 报表自动生成方法、装置、计算机设备及存储介质

Also Published As

Publication number Publication date
CN112667630A (zh) 2021-04-16
CN112667630B (zh) 2023-06-02

Similar Documents

Publication Publication Date Title
Souibgui et al. Data quality in ETL process: A preliminary study
US10678669B2 (en) Field content based pattern generation for heterogeneous logs
WO2022134363A1 (fr) Procédé et appareil d'intégration de rapport de service, dispositif et support d'enregistrement
US11907216B2 (en) Multi-language fusion query method and multi-model database system
US20180349184A1 (en) Processing data sets in a big data repository
KR20210141640A (ko) 이기종 데이터 소스에 저장된 데이터의 자연어 기반 처리 방법
US8417690B2 (en) Automatically avoiding unconstrained cartesian product joins
CN114265945A (zh) 血缘关系提取方法、装置及电子设备
CN111627552A (zh) 一种医疗流式数据血缘关系分析、存储方法及装置
CN112579610A (zh) 多数据源结构分析方法、系统、终端设备及存储介质
CN113934750A (zh) 基于编译方式的数据血缘关系分析方法
CN114328759A (zh) 一种数据仓库的数据构建与管理方法及终端
US11354313B2 (en) Transforming a user-defined table function to a derived table in a database management system
CN115292350A (zh) Sql语句的处理方法及装置
CN113297057A (zh) 内存分析方法、装置及系统
CN114356964A (zh) 数据血缘构建方法、装置、存储介质及电子设备
US20070033178A1 (en) Quality of service feedback for technology-neutral data reporting
CN116483831B (zh) 一种分布式数据库推荐索引生成方法
US20180060404A1 (en) Schema abstraction in data ecosystems
CN115292347A (zh) 一种基于规则的主动式sql算法性能检查装置及方法
CN113221528B (zh) 基于openEHR模型的临床数据质量评估规则的自动生成与执行方法
CN114443699A (zh) 信息查询方法、装置、计算机设备及计算机可读存储介质
CN114547083A (zh) 数据处理方法、装置及电子设备
US20150286700A1 (en) Recording medium having stored thereon database access control program, method for controlling database access, and information processing apparatus
JP2012512455A (ja) 自動的なデータストアアーキテクチャの検出

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 21908375

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 21908375

Country of ref document: EP

Kind code of ref document: A1