




技术领域technical field
本发明实施例涉及数据库操作领域,尤其涉及一种基于XML的数据关联方法、装置、服务器及存储介质。Embodiments of the present invention relate to the field of database operations, and in particular, to an XML-based data association method, device, server, and storage medium.
背景技术Background technique
随着数据应用的广泛普及,数据来源日趋复杂,数据库产品的选型和异构数据问题给数据整合带来越来越多的困扰。With the widespread popularity of data applications, the data sources are becoming more and more complex, and the selection of database products and heterogeneous data problems have brought more and more troubles to data integration.
另一方面,数据应用的结果和数据分析操作面向的用户已不再是IT专业用户,向各类用户提供直观、简洁的数据服务成为迫切需求,因此数据可视化、面向对象的数据服务开发等需求日益增多,但这类应用带来了另一个问题:如何在结构化、非结构化数据关系与直观的数据操作之间建立高效的转化机制成为另一个课题。On the other hand, the users of data application results and data analysis operations are no longer IT professional users, and it has become an urgent need to provide intuitive and concise data services to various users. Therefore, data visualization and object-oriented data service development are required. Increasingly, but such applications bring another problem: how to establish an efficient conversion mechanism between structured and unstructured data relationships and intuitive data manipulation becomes another issue.
最后,随着数据应用的推广,非IT专业用户所提出的模糊的、非TI专业性质的需求表述如何能转化为对数据的明确算法也成为一个亟待解决的问题。Finally, with the promotion of data applications, how to transform the vague and non-TI professional demand expressions put forward by non-IT professional users into explicit algorithms for data has also become an urgent problem to be solved.
发明内容SUMMARY OF THE INVENTION
本发明提供一种基于XML的数据关联方法、装置、服务器及存储介质,以实现向用户提供直观、简洁的数据服务和提高建模复用率的效果。The invention provides an XML-based data association method, device, server and storage medium, so as to realize the effects of providing intuitive and concise data services to users and improving the modeling reuse rate.
第一方面,本发明实施例提供了一种基于XML的数据关联方法,包括:In a first aspect, an embodiment of the present invention provides an XML-based data association method, including:
获取基于页面配置的需求建模,所述需求建模包括多个可操作控件,所述多个可操作控件之间连线形成控件链,所述连线为数据之间的对应关系;Obtaining demand modeling based on page configuration, where the demand modeling includes multiple operable controls, and a control chain is formed by connecting lines between the multiple operable controls, and the connecting lines are corresponding relationships between data;
获取用户在所述可操作控件输入的第一数据;obtaining the first data input by the user in the operable control;
将所述第一数据处理成XML文档存储在关系数据库。The first data is processed into an XML document and stored in a relational database.
第二方面,本发明实施例还提供了一种基于XML的数据关联装置,包括:In a second aspect, an embodiment of the present invention also provides an XML-based data association device, including:
建模模块,用于获取基于页面配置的需求建模,所述需求建模包括多个可操作控件,所述多个可操作控件之间连线形成控件链,所述连线为数据之间的对应关系;The modeling module is used to obtain the requirement modeling based on page configuration, the requirement modeling includes multiple operable controls, and the connection between the multiple operable controls forms a control chain, and the connection is between data the corresponding relationship;
数据获取模块,用于获取用户在所述可操作控件输入的第一数据;a data acquisition module for acquiring the first data input by the user in the operable control;
处理模块,用于将所述第一数据处理成XML文档存储在关系数据库。A processing module, configured to process the first data into an XML document and store it in a relational database.
第三方面,本发明实施例还提供了一种服务器,包括存储器,处理器及存储在存储器上并可在处理器运行的计算机程序,所述处理器执行所述计算机程序时实现如上述的基于XML的数据关联方法。In a third aspect, an embodiment of the present invention further provides a server, including a memory, a processor, and a computer program stored in the memory and executed by the processor, when the processor executes the computer program, the above-mentioned based XML data association method.
第四方面,本发明实施例还提供了一种计算机可读存储介质,其上存储有计算机程序,该程序被处理器执行时实现如上述的基于XML的数据关联方法。In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium on which a computer program is stored, and when the program is executed by a processor, implements the above XML-based data association method.
本实施例的技术方案,通过获取基于页面配置的需求建模,所述需求建模包括多个可操作控件,所述多个可操作控件之间连线形成控件链,所述连线为数据之间的对应关系;获取用户在所述可操作控件输入的第一数据;将所述第一数据处理成XML文档存储在关系数据库,解决了非IT专业用户所提出的模糊的、非IT专业性质的需求表述如何能转化为对数据的明确算法的问题,达到了向用户提供直观、简洁的数据服务和提高建模复用率的效果。In the technical solution of this embodiment, the requirement modeling based on page configuration is obtained, and the requirement modeling includes multiple operable controls, and a control chain is formed by connecting lines between the multiple operable controls, and the connecting lines are data Corresponding relationship between; obtaining the first data input by the user in the operable control; processing the first data into an XML document and storing it in a relational database, which solves the problem of ambiguous, non-IT professional users proposed by non-IT professional users How can the demand expression of nature be transformed into a clear algorithm for data, which achieves the effect of providing users with intuitive and concise data services and improving the modeling reuse rate.
附图说明Description of drawings
图1是本发明实施例一中的基于XML的数据关联方法的流程图。FIG. 1 is a flowchart of an XML-based data association method in Embodiment 1 of the present invention.
图2是本发明实施例二中的基于XML的数据关联方法的流程图。FIG. 2 is a flowchart of an XML-based data association method in Embodiment 2 of the present invention.
图3是本发明实施例三中的基于XML的数据迁移解析的流程图。FIG. 3 is a flowchart of XML-based data migration analysis in Embodiment 3 of the present invention.
图4是本发明实施例三中的基于XML的数据关联装置的结构示意图。FIG. 4 is a schematic structural diagram of an XML-based data association apparatus in Embodiment 3 of the present invention.
图5是本发明实施例三中的服务器的结构示意图。FIG. 5 is a schematic structural diagram of a server in Embodiment 3 of the present invention.
具体实施方式Detailed ways
下面结合附图和实施例对本发明作进一步的详细说明。可以理解的是,此处所描述的具体实施例仅仅用于解释本发明,而非对本发明的限定。另外还需要说明的是,为了便于描述,附图中仅示出了与本发明相关的部分而非全部结构。The present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. 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. In addition, it should be noted that, for the convenience of description, the drawings only show some but not all structures related to the present invention.
在更加详细地讨论示例性实施例之前应当提到的是,一些示例性实施例被描述成作为流程图描绘的处理或方法。虽然流程图将各步骤描述成顺序的处理,但是其中的许多步骤可以被并行地、并发地或者同时实施。此外,各步骤的顺序可以被重新安排。当其操作完成时处理可以被终止,但是还可以具有未包括在附图中的附加步骤。处理可以对应于方法、函数、规程、子例程、子程序等等。Before discussing the exemplary embodiments in greater detail, it should be mentioned that some exemplary embodiments are described as processes or methods depicted as flowcharts. Although the flowchart depicts the steps as a sequential process, many of the steps may be performed in parallel, concurrently, or concurrently. Furthermore, the order of the steps can be rearranged. The process may be terminated when its operation is complete, but may also have additional steps not included in the figures. A process may correspond to a method, function, procedure, subroutine, subroutine, or the like.
此外,术语“第一”、“第二”等可在本文中用于描述各种方向、动作、步骤或元件等,但这些方向、动作、步骤或元件不受这些术语限制。这些术语仅用于将第一个方向、动作、步骤或元件与另一个方向、动作、步骤或元件区分。举例来说,在不脱离本申请的范围的情况下,可以将第一数据库为第二数据库,且类似地,可将第二数据库称为第一数据库。第一数据库和第二数据库两者都是数据库,但其不是同一数据库。术语“第一”、“第二”等而不能理解为指示或暗示相对重要性或者隐含指明所指示的技术特征的数量。由此,限定有“第一”、“第二”的特征可以明示或者隐含地包括一个或者更多个该特征。在本发明的描述中,“多个”的含义是至少两个,例如两个,三个等,除非另有明确具体的限定。Furthermore, the terms "first," "second," etc. may be used herein to describe various directions, acts, steps or elements, etc., but are not limited by these terms. These terms are only used to distinguish a first direction, act, step or element from another direction, act, step or element. For example, the first database may be referred to as the second database, and similarly, the second database may be referred to as the first database, without departing from the scope of this application. Both the first database and the second database are databases, but they are not the same database. The terms "first", "second" and the like should not be understood as indicating or implying relative importance or implying the number of technical features indicated. Thus, a feature defined as "first" or "second" may expressly or implicitly include one or more of that feature. In the description of the present invention, "plurality" means at least two, such as two, three, etc., unless otherwise expressly and specifically defined.
实施例一Example 1
图1为本发明实施例一提供的基于XML的数据关联方法的流程图,本实施例可适用于数据关系描述情况,该方法包括如下步骤:1 is a flowchart of an XML-based data association method provided by Embodiment 1 of the present invention. This embodiment is applicable to the description of data relationships, and the method includes the following steps:
S110、获取基于页面配置的需求建模,所述需求建模包括多个可操作控件,所述多个可操作控件之间连线形成控件链,所述连线为数据之间的对应关系;S110. Acquire demand modeling based on page configuration, where the demand modeling includes multiple operable controls, and a control chain is formed by connecting lines between the multiple operable controls, and the connecting lines are corresponding relationships between data;
本实施例中,用户可通过触发系统配置的操作选项选择页面创建指令,并将页面创建指令发送至页面配置系统,示例性的,系统配置有“页面创建”操作选项,当用户通过鼠标点击“页面创建”这一操作选项时,即触发生成所述页面创建指令,并将页面创建指令发送至页面配置系统。页面配置系统接收页面创建指令之后,响应于所述页面创建指令,获取至少一个页面配置模板的标识和预览信息,并对至少一个页面配置模板的标识和预览信息进行渲染生成模板选择页面。In this embodiment, the user can select the page creation instruction by triggering the operation option of the system configuration, and send the page creation instruction to the page configuration system. Exemplarily, the system is configured with the "page creation" operation option. When the operation option of "page creation" is selected, the generation of the page creation instruction is triggered, and the page creation instruction is sent to the page configuration system. After receiving the page creation instruction, the page configuration system obtains the identification and preview information of at least one page configuration template in response to the page creation instruction, and renders the identification and preview information of the at least one page configuration template to generate a template selection page.
页面配置模板的标识具体为该页面配置模板的名称;页面配置模板的预览信息具体包括页面配置模板的分区组成、可用组件类型、使用场景说明信息、关键字信息以及使用该模板创建的页面示例链接信息中的任意一项或多项。页面配置系统中配置的至少一个页面配置模板中,每个页面配置模板对应一个标识,不同的页面配置模板的标识不同,不同的页面配置模板的标识对应的预览信息不同。The identifier of the page configuration template is the name of the page configuration template; the preview information of the page configuration template specifically includes the partition composition of the page configuration template, available component types, usage scenario description information, keyword information, and links to page examples created using the template any one or more of the information. In at least one page configuration template configured in the page configuration system, each page configuration template corresponds to an identifier, different page configuration templates have different identifiers, and different page configuration templates have different identifiers corresponding to different preview information.
用户可以根据自身需求建立模型,例如银行模型、城市模型、地面模型、路网模型、学校模型、火车站模型、医院模型等,通过对模型的设计可以满足例如银行报表的需求或者学校人员统计的需求。需求建模过程中,可以对所要构建的页面类型进行选择,并挑选出构建页面时所要用到的可操作控件,可操作可以为基于页面的拖拽操作,此处不作限定。在该页中,能够对当前类型页面的可操作控件库进行检索操作,并允许对组件库中的所有组件进行查看和删除操作。可以通过拖拽的方式从页面左侧排列的控件库中,选择所需的控件放入页面。控件之间可以依据需求进行实时调整位置,并通过连接线形成控件链,也可以是树状图,此处不作限定,连接线可以表示各个控件间的数据关系。Users can build models according to their own needs, such as bank model, city model, ground model, road network model, school model, train station model, hospital model, etc. The design of the model can meet the needs of bank reports or school personnel statistics. need. In the process of requirement modeling, you can select the type of page to be built, and select the operable controls to be used when building the page. The operation can be a page-based drag and drop operation, which is not limited here. In this page, the operation control library of the current type of page can be retrieved, and all the components in the component library can be viewed and deleted. You can select the desired control from the control library arranged on the left side of the page by dragging and dropping it into the page. The positions of the controls can be adjusted in real time according to the requirements, and the control chain can be formed through the connecting line, or it can be a tree diagram, which is not limited here, and the connecting line can represent the data relationship between the various controls.
S120、获取用户在所述可操作控件输入的第一数据;S120, obtaining the first data input by the user in the operable control;
本实施例中,页面的整体骨架构建完成后,需要针对各个组件进行特定的参数配置。例如组件的外观样式、事件绑定、数据源选取、跳转链接等等。配置的方式是通过鼠标点击选择当前组件,在参数配置区会显示当前组件能够进行配置的参数列表,配置完成后点击确定按钮即可生效当前配置,点击重置按钮会清空当前配置的所有参数。用户根据业务需求进行数据输入,例如用户需要的是银行报表的统计,则需要建立基于银行报表样式的模型,再根据业务内容输入参数数据。本实施例的模型不限定于一家银行,在另一银行的报表统计也可以使用当前模型,提高模型的使用复用率。In this embodiment, after the construction of the overall skeleton of the page is completed, specific parameter configuration needs to be performed for each component. For example, the appearance style of the component, event binding, data source selection, jump links, etc. The configuration method is to select the current component by clicking with the mouse, and the parameter list that can be configured by the current component will be displayed in the parameter configuration area. After the configuration is completed, click the OK button to take effect of the current configuration, and click the reset button to clear all the parameters of the current configuration. Users input data according to business requirements. For example, if the user needs statistics of bank statements, a model based on the style of bank statements needs to be established, and then parameter data is input according to the business content. The model in this embodiment is not limited to one bank, and the current model can also be used in the report statistics of another bank to improve the reuse rate of the model.
S130、将所述第一数据处理成XML文档存储在关系数据库。S130. Process the first data into an XML document and store it in a relational database.
本实施例中,XML(Extensible Markup Language),中文为可扩展标记语言,标准通用标记语言的子集,是一种用于标记电子文件使其具有结构性的标记语言。XML可以用来标记数据、定义数据类型,可以允许用户对自己标记语言进行定义,是对人和机器都比较友好的数据承载方式。它提供统一的方法来描述和交换独立于应用程序或供应商的结构化数据,非常适合万维网传输,是Internet环境中跨平台、依赖于内容的技术,也是当今处理分布式结构信息的有效工具。In this embodiment, XML (Extensible Markup Language), Chinese is an extensible markup language, a subset of the standard general markup language, and is a markup language used to mark electronic files to make them structured. XML can be used to mark data, define data types, and allow users to define their own markup language. It is a data bearing method that is friendly to humans and machines. It provides a unified method to describe and exchange structured data independent of application or vendor, is well suited for World Wide Web transport, is a cross-platform, content-dependent technology in the Internet environment, and is an effective tool for processing distributed structured information today.
用户在需求建模后输入参数数据,通过数据翻译,将参数数据和模型翻译成服务器可以识别的数据,服务器验证剔除不符合协议要求的数据,再使用XML语言对参数数据进行分类建表,将数据之间的关系作为表与表之间的对应关系保存成XML文档,然后将XML文档存至关系数据库中,可以随时调用查询。The user enters the parameter data after the requirement modeling, and through data translation, the parameter data and model are translated into data that the server can recognize. The relationship between the data is saved as an XML document as the corresponding relationship between the tables, and then the XML document is stored in the relational database, and the query can be called at any time.
如果对页面建模的效果确认无误,可以点击页面的下载按钮,将页面所有的依赖资源文件封装打包,生成最终的XML文档,并下载到本地指定的文件目录下。If the effect of page modeling is confirmed to be correct, you can click the download button on the page to package all the dependent resource files of the page, generate the final XML document, and download it to the specified file directory locally.
本实施例的技术方案,通过获取基于页面配置的需求建模,所述需求建模包括多个可操作控件,所述多个可操作控件之间连线形成控件链,所述连线为数据之间的对应关系;获取用户在所述可操作控件输入的第一数据;将所述第一数据处理成XML文档存储在关系数据库,解决了非IT专业用户所提出的模糊的、非IT专业性质的需求表述如何能转化为对数据的明确算法的问题,达到了向用户提供直观、简洁的数据服务和提高建模复用率的效果。In the technical solution of this embodiment, the requirement modeling based on page configuration is obtained, and the requirement modeling includes multiple operable controls, and a control chain is formed by connecting lines between the multiple operable controls, and the connecting lines are data Corresponding relationship between; obtaining the first data input by the user in the operable control; processing the first data into an XML document and storing it in a relational database, which solves the problem of ambiguous, non-IT professional users proposed by non-IT professional users How can the demand expression of nature be transformed into a clear algorithm for data, which achieves the effect of providing users with intuitive and concise data services and improving the modeling reuse rate.
实施例二Embodiment 2
图2为本发明实施例二提供的基于XML的数据关联方法的流程图,本实施例在上述实施例的基础上进一步优化,该方法具体包括:FIG. 2 is a flowchart of an XML-based data association method provided in Embodiment 2 of the present invention. This embodiment is further optimized on the basis of the foregoing embodiment, and the method specifically includes:
S210、获取基于页面配置的需求建模,所述需求建模包括多个可操作控件,所述多个可操作控件之间连线形成控件链,所述连线为数据之间的对应关系;S210. Acquire demand modeling based on page configuration, where the demand modeling includes multiple operable controls, and a control chain is formed by connecting lines between the multiple operable controls, and the connecting lines are corresponding relationships between data;
本实施例中,需求建模过程中,可以对所要构建的页面类型进行选择,并挑选出构建页面时所要用到的可操作控件,可操作可以为基于页面的拖拽操作,此处不作限定。控件之间可以依据需求进行实时调整位置,并通过连接线形成控件链,也可以是树状图,此处不作限定,连接线可以表示各个控件间的数据关系。In this embodiment, during the requirement modeling process, the type of the page to be built can be selected, and the operable controls used in building the page can be selected, and the operation can be a page-based drag operation, which is not limited here. . The positions of the controls can be adjusted in real time according to the requirements, and the control chain can be formed through the connecting line, or it can be a tree diagram, which is not limited here, and the connecting line can represent the data relationship between the various controls.
S220、获取用户在所述可操作控件输入的第一数据;S220, obtaining the first data input by the user in the operable control;
本实施例中,用户根据业务需求进行数据输入,例如用户需要的是银行报表的统计,则需要建立基于银行报表样式的模型,再根据业务内容输入参数数据。本实施例的模型不限定于一家银行,在另一银行的报表统计也可以使用当前模型,提高模型的使用复用率。In this embodiment, the user inputs data according to business requirements. For example, if the user needs statistics of bank statements, a model based on the style of bank statements needs to be established, and then parameter data is input according to business content. The model in this embodiment is not limited to one bank, and the current model can also be used in the report statistics of another bank to improve the reuse rate of the model.
S230、对所述第一数据进行过滤;S230, filtering the first data;
本实施例中,过滤也可以是数据清洗,即发现并纠正数据文件中可识别的错误的最后一道程序,包括检查数据一致性,处理无效值和缺失值等。因为数据获取过程中存在不确定性,这样就避免不了有的数据是错误数据、有的数据相互之间有冲突,这些错误的或有冲突的数据显然是我们不想要的,称为“脏数据”,我们要按照一定的规则把“脏数据”“洗掉”。服务器接收用户输入的第一数据后,通过安全鉴权通过后才可以处理第一数据。服务器通过数据读写接口接收模型数据和参数数据,提取出参数数据及基于模型关系的数据关系,再通过数据清洗获取所需的数据。In this embodiment, filtering may also be data cleaning, that is, the last procedure of finding and correcting identifiable errors in data files, including checking data consistency, dealing with invalid values and missing values, and the like. Because there is uncertainty in the process of data acquisition, it is inevitable that some data are wrong data, and some data conflict with each other. These wrong or conflicting data are obviously not what we want, which is called "dirty data". ", we have to "wash out" the "dirty data" according to certain rules. After the server receives the first data input by the user, the first data can be processed only after passing the security authentication. The server receives the model data and parameter data through the data read and write interface, extracts the parameter data and the data relationship based on the model relationship, and then obtains the required data through data cleaning.
S240、将过滤后的所述第一数据存储在数据仓库,所述数据仓库用于存储中间数据。S240. Store the filtered first data in a data warehouse, where the data warehouse is used to store intermediate data.
本实施例中,中间数据为服务器多重处理数据过程中的数据,方便后续提取处理使用,本实施例可以将过滤后的第一数据存储在数据仓库,已供其他算法运算所需。服务器可以提取数据仓库中的模型数据和参数数据进行处理。In this embodiment, the intermediate data is data in the process of multi-processing data by the server, which is convenient for subsequent extraction and processing. In this embodiment, the filtered first data can be stored in a data warehouse, which is required for other algorithm operations. The server can extract model data and parameter data in the data warehouse for processing.
S250、根据预设算法将所述第一数据处理成XML文档存储在关系数据库,所述预设算法包括通过多个相互独立的子任务确定的集成逻辑。S250. Process the first data into an XML document and store it in a relational database according to a preset algorithm, where the preset algorithm includes integrated logic determined by a plurality of mutually independent subtasks.
本实施例中,预设算法为通过XML语言对参数数据进行标记,对数据定义分类成一个个表,通过模型数据对各个表之间的关系进行定义。预设算法包括对个相互独立的子任务,子任务包括多个表的数据信息,子任务与子任务的对应关系及表与表之间的关系形成集成逻辑。示例性的,以学校人员统计来说。可以通过班级表、班级编号表、班级名称表、学生表、学生编号表可以将学校所有学生的关系记录统计,方便后续查询。In this embodiment, the preset algorithm is to mark the parameter data by using XML language, classify the data definitions into tables, and define the relationship between the tables by using the model data. The preset algorithm includes subtasks that are independent of each other, the subtasks include data information of multiple tables, and the corresponding relationship between the subtasks and the subtasks and the relationship between the tables form an integrated logic. Exemplarily, in terms of school personnel statistics. Through the class table, class number table, class name table, student table, and student number table, the relationship records of all students in the school can be recorded and counted, which is convenient for subsequent inquiries.
进一步的,所述集成逻辑为所述多个相互独立的子任务间数据的关系描述。Further, the integration logic is a relationship description of data among the plurality of mutually independent subtasks.
进一步的,所述子任务包括数据表信息,所述数据表信息包括表模式,表名称,字段列表和对应数据类型的列表。Further, the subtask includes data table information, and the data table information includes table schema, table name, field list and list of corresponding data types.
本实施例中,将预设算法分解成若干相互独立的子任务,确定每个子任务的集成逻辑,将集成逻辑形式化为查询方案。查询方案可以用结构化查询语言来表示。应当注意的是:查询语句中的每一个表和属性列都要有一个其所属数据库的标识作为前缀。In this embodiment, the preset algorithm is decomposed into several mutually independent subtasks, the integration logic of each subtask is determined, and the integration logic is formalized into a query scheme. The query scheme can be expressed in Structured Query Language. It should be noted that each table and attribute column in the query statement must have an identifier of the database to which it belongs as a prefix.
进一步的,所述将所述第一数据处理成XML文档存储在关系数据库之后,还包括:根据用户的数据库管理操作对所述XML文档进行数据库管理,所述数据库管理包括对所述XML文档的维护操作。Further, after processing the first data into an XML document and storing it in a relational database, the method further includes: performing database management on the XML document according to a user's database management operation, and the database management includes performing database management on the XML document. maintenance operations.
本实施例中,对已经部署的数据库进行不断的增量更新,人工生成该次更新所需要的更新sql或者数据XML描述文件,带来非常大的工作量。针对这一情况,本专利所涉及方法通过在XML描述文件的各种类型数据的描述,添加数据更新操作类型(添加、删除、更新)及应用对应更新操作的需求页面操作。通过添加的数据更新操作类型及对应的需求页面操作,基于数据更新需求页面操作的单次更新XML数据文件自动生成。每次对数据库的增量更新,通过页面操作进行维护操作、例如增、删、改、导入或导出等,生成对应的数据库增量更新XML描述文件,通过该XML描述文件,即可实现对数据库的增量更新。In this embodiment, the deployed database is continuously updated incrementally, and the update sql or data XML description file required for the update is manually generated, which brings a very large workload. In view of this situation, the method involved in this patent adds data update operation types (add, delete, update) and apply the corresponding update operation demand page operations through the description of various types of data in the XML description file. Through the added data update operation type and the corresponding demand page operation, a single update XML data file based on the data update demand page operation is automatically generated. Each incremental update to the database, maintenance operations are performed through page operations, such as addition, deletion, modification, import or export, etc., to generate the corresponding database incremental update XML description file. Through the XML description file, the database can be updated. incremental update.
本实施例的技术方案,通过获取基于页面配置的需求建模,所述需求建模包括多个可操作控件,所述多个可操作控件之间连线形成控件链,所述连线为数据之间的对应关系;获取用户在所述可操作控件输入的第一数据;对所述第一数据进行过滤;将过滤后的所述第一数据存储在数据仓库,所述数据仓库用于存储中间数据;根据预设算法将所述第一数据处理成XML文档存储在关系数据库,所述预设算法包括通过多个相互独立的子任务确定的集成逻辑。本发明实施例的技术方案解决了现有XML描述性语言描述数据关系与业务耦合度较高的问题,达到了提高XML描述数据关系通用性的效果。In the technical solution of this embodiment, the requirement modeling based on page configuration is obtained, and the requirement modeling includes multiple operable controls, and a control chain is formed by connecting lines between the multiple operable controls, and the connecting lines are data Correspondence between; obtain the first data input by the user in the operable control; filter the first data; store the filtered first data in a data warehouse, and the data warehouse is used for storage Intermediate data; the first data is processed into an XML document and stored in a relational database according to a preset algorithm, and the preset algorithm includes integrated logic determined by a plurality of mutually independent subtasks. The technical solution of the embodiment of the present invention solves the problem of high coupling degree between data relationship and business description in the existing XML descriptive language, and achieves the effect of improving the universality of XML description data relationship.
实施例三Embodiment 3
图3所示为本发明实施例三提供的基于XML的数据迁移解析的流程图,本实施例可适用于数据迁移情况,具体结构如下:FIG. 3 shows a flowchart of XML-based data migration analysis provided in Embodiment 3 of the present invention. This embodiment is applicable to data migration situations, and the specific structure is as follows:
S310、接收终端传输的迁移数据,所述迁移数据属于第一数据库,所述第一数据库与所述XML文档对应的第二数据库不同;S310. Receive migration data transmitted by the terminal, where the migration data belongs to a first database, and the first database is different from the second database corresponding to the XML document;
S320、根据预设的解析规则将所述迁移数据解析成解析数据,所述预设解析规则包括所述第一数据库对应的解析规则;S320. Parse the migration data into parsing data according to a preset parsing rule, where the preset parsing rule includes parsing rules corresponding to the first database;
S330、将所述解析数据存储在所述关系数据库。S330. Store the parsed data in the relational database.
本实施例中,第一数据库可以为oracle、sqlserver、sybase、informix数据库等,此处不作限制。本实施例的第二数据库为基于XML的数据库。示例性的,从源数据库端获取一个Table对象,将其格式转换,根据源数据库与目标数据库之间字段的映射关系,将Table对象转换为XML数据库的表,再将转换后的信息传递给XML语句构建XML数据库,根据封装了目标数据库的信息的DesDatabase对象,来构建相应的XML语句并执行这些XML将数据导入到XML数据库中。In this embodiment, the first database may be oracle, sqlserver, sybase, informix database, etc., which is not limited here. The second database in this embodiment is an XML-based database. Exemplarily, obtain a Table object from the source database, convert its format, convert the Table object into a table of the XML database according to the field mapping relationship between the source database and the target database, and then transmit the converted information to the XML The statement constructs the XML database, constructs the corresponding XML statement according to the DesDatabase object that encapsulates the information of the target database, and executes the XML to import the data into the XML database.
也可以将本发明应用于其他数据库中,示例性的,将基于XML的数据转储文件导入目的数据库,首先使用已定义的目的数据库连接信息自动连接到目的数据库,然后解析从源数据库中导出的基于XML的数据转储文件,获得表结构信息及表中存储的数据,进一步在目的数据库中创建表,最后构造数据导入所需的sql并执行这些sql将数据导入到目的数据库中。The present invention can also be applied to other databases. Exemplarily, import the XML-based data dump file into the destination database, first use the defined destination database connection information to automatically connect to the destination database, and then parse the exported data from the source database. Based on the XML data dump file, the table structure information and the data stored in the table are obtained, and the table is further created in the destination database. Finally, the sql required for data import is constructed and the sql is executed to import the data into the destination database.
本发明实施例的技术方案,通过接收终端传输的迁移数据,所述迁移数据属于第一数据库,所述第一数据库与所述XML文档对应的第二数据库不同;根据预设的解析规则将所述迁移数据解析成解析数据,所述预设解析规则包括所述第一数据库对应的解析规则;将所述解析数据存储在所述关系数据库。本发明实施例的技术方案解决了多平台通用性的问题,达到了支持跨数据平台的数据整合、数据迁移的效果。The technical solution of the embodiment of the present invention is to receive the migration data transmitted by the terminal, where the migration data belongs to a first database, and the first database is different from the second database corresponding to the XML document; The migration data is parsed into parsed data, and the preset parsing rules include parsing rules corresponding to the first database; and the parsed data is stored in the relational database. The technical solutions of the embodiments of the present invention solve the problem of multi-platform versatility, and achieve the effect of supporting data integration and data migration across data platforms.
实施例四Embodiment 4
图4为本发明实施例四提供的基于XML的数据关联装置400的结构示意图,实施例可适用于数据关联情况,具体结构如下:FIG. 4 is a schematic structural diagram of an XML-based
建模模块410,用于获取基于页面配置的需求建模,所述需求建模包括多个可操作控件,所述多个可操作控件之间连线形成控件链,所述连线为数据之间的对应关系;The
数据获取模块420,用于获取用户在所述可操作控件输入的第一数据;a
处理模块430,用于将所述第一数据处理成XML文档存储在关系数据库。The
进一步的,处理模块430包括根据预设算法将所述第一数据处理成XML文档存储在关系数据库,所述预设算法包括通过多个相互独立的子任务确定的集成逻辑。Further, the
进一步的,所述集成逻辑为所述多个相互独立的子任务间数据的关系描述。Further, the integration logic is a relationship description of data among the plurality of mutually independent subtasks.
进一步的,所述子任务包括数据表信息,所述数据表信息包括表模式,表名称,字段列表和对应数据类型的列表。Further, the subtask includes data table information, and the data table information includes table schema, table name, field list and list of corresponding data types.
进一步的,装置400还包括过滤模块和中间存储模块,Further, the
过滤模块用于对所述第一数据进行过滤;The filtering module is used to filter the first data;
中间存储模块用于将过滤后的所述第一数据存储在数据仓库,所述数据仓库用于存储中间数据。The intermediate storage module is used for storing the filtered first data in a data warehouse, where the data warehouse is used for storing intermediate data.
进一步的,装置400还包括迁移数据接收模块、解析模块和解析数据存储模块,Further, the
迁移数据接收模块用于接收终端传输的迁移数据,所述迁移数据属于第一数据库,所述第一数据库与所述XML文档对应的第二数据库不同;The migration data receiving module is configured to receive the migration data transmitted by the terminal, where the migration data belongs to a first database, and the first database is different from the second database corresponding to the XML document;
解析模块用于根据预设的解析规则将所述迁移数据解析成解析数据,所述预设解析规则包括所述第一数据库对应的解析规则;The parsing module is configured to parse the migration data into parsing data according to a preset parsing rule, where the preset parsing rule includes parsing rules corresponding to the first database;
解析数据存储模块用于将所述解析数据存储在所述关系数据库。The analytical data storage module is used for storing the analytical data in the relational database.
进一步的,装置400还包括数据库管理模块,用于根据用户的数据库管理操作对所述XML文档进行数据库管理,所述数据库管理包括对所述XML文档的维护操作。Further, the
本发明实施例所提供的基于XML的数据关联装置400可执行前述实施例所提供的基于XML的数据关联方法,具备执行方法相应的功能模块和有益效果。The XML-based
实施例五Embodiment 5
图5是本发明实施例五提供的一种服务器的结构示意图。图5示出了适于用来实现本发明实施方式的示例性服务器512的框图。图5显示的服务器512仅仅是一个示例,不应对本发明实施例的功能和使用范围带来任何限制。FIG. 5 is a schematic structural diagram of a server according to Embodiment 5 of the present invention. Figure 5 shows a block diagram of an
如图5所示,服务器512以通用服务器的形式表现。服务器512的组件可以包括但不限于:一个或者多个处理器516,存储装置528,连接不同系统组件(包括存储装置528和处理器516)的总线518。As shown in FIG. 5,
总线518表示几类总线结构中的一种或多种,包括存储装置总线或者存储装置控制器,外围总线,图形加速端口,处理器或者使用多种总线结构中的任意总线结构的局域总线。举例来说,这些体系结构包括但不限于工业标准体系结构(Industry SubversiveAlliance,ISA)总线,微通道体系结构(Micro Channel Architecture,MAC)总线,增强型ISA总线、视频电子标准协会(Video Electronics Standards Association,VESA)局域总线以及外围组件互连(Peripheral Component Interconnect,PCI)总线。
服务器512典型地包括多种计算机系统可读介质。这些介质可以是任何能够被服务器512访问的可用介质,包括易失性和非易失性介质,可移动的和不可移动的介质。
存储装置528可以包括易失性存储器形式的计算机系统可读介质,例如随机存取存储器(Random Access Memory,RAM)530和/或高速缓存存储器532。终端512可以进一步包括其它可移动/不可移动的、易失性/非易失性计算机系统存储介质。仅作为举例,存储系统534可以用于读写不可移动的、非易失性磁介质(图5未显示,通常称为“硬盘驱动器”)。尽管图5中未示出,可以提供用于对可移动非易失性磁盘(例如“软盘”)读写的磁盘驱动器,以及对可移动非易失性光盘,例如只读光盘(Compact Disc Read-Only Memory,CD-ROM),数字视盘(Digital Video Disc-Read Only Memory,DVD-ROM)或者其它光介质)读写的光盘驱动器。在这些情况下,每个驱动器可以通过一个或者多个数据介质接口与总线518相连。存储装置528可以包括至少一个程序产品,该程序产品具有一组(例如至少一个)程序模块,这些程序模块被配置以执行本发明各实施例的功能。
具有一组(至少一个)程序模块542的程序/实用工具540,可以存储在例如存储装置528中,这样的程序模块542包括但不限于操作系统、一个或者多个应用程序、其它程序模块以及程序数据,这些示例中的每一个或某种组合中可能包括网络环境的实现。程序模块542通常执行本发明所描述的实施例中的功能和/或方法。A program/utility 540 having a set (at least one) of
服务器512也可以与一个或多个外部设备514(例如键盘、指向终端、显示器524等)通信,还可与一个或者多个使得用户能与该服务器512交互的终端通信,和/或与使得该服务器512能与一个或多个其它计算终端进行通信的任何终端(例如网卡,调制解调器等等)通信。这种通信可以通过输入/输出(I/O)接口522进行。并且,服务器512还可以通过网络适配器520与一个或者多个网络(例如局域网(Local Area Network,LAN),广域网(Wide AreaNetwork,WAN)和/或公共网络,例如因特网)通信。如图5所示,网络适配器520通过总线518与服务器512的其它模块通信。应当明白,尽管图中未示出,可以结合服务器512使用其它硬件和/或软件模块,包括但不限于:微代码、终端驱动器、冗余处理器、外部磁盘驱动阵列、磁盘阵列(Redundant Arrays of Independent Disks,RAID)系统、磁带驱动器以及数据备份存储系统等。The
处理器516通过运行存储在存储装置528中的程序,从而执行各种功能应用以及数据处理,例如实现本发明任意实施例所提供的一种基于XML的数据关联方法,该方法可以包括:The
获取基于页面配置的需求建模,所述需求建模包括多个可操作控件,所述多个可操作控件之间连线形成控件链,所述连线为数据之间的对应关系;Obtaining demand modeling based on page configuration, where the demand modeling includes multiple operable controls, and a control chain is formed by connecting lines between the multiple operable controls, and the connecting lines are corresponding relationships between data;
获取用户在所述可操作控件输入的第一数据;obtaining the first data input by the user in the operable control;
将所述第一数据处理成XML文档存储在关系数据库。The first data is processed into an XML document and stored in a relational database.
实施例六Embodiment 6
本发明实施例六还提供了一种计算机可读存储介质,其上存储有计算机程序,该程序被处理器执行时实现如本发明任意实施例所提供的一种基于XML的数据关联方法,该方法可以包括:Embodiment 6 of the present invention further provides a computer-readable storage medium, on which a computer program is stored, and when the program is executed by a processor, implements an XML-based data association method as provided in any embodiment of the present invention, the Methods can include:
获取基于页面配置的需求建模,所述需求建模包括多个可操作控件,所述多个可操作控件之间连线形成控件链,所述连线为数据之间的对应关系;Obtaining demand modeling based on page configuration, where the demand modeling includes multiple operable controls, and a control chain is formed by connecting lines between the multiple operable controls, and the connecting lines are corresponding relationships between data;
获取用户在所述可操作控件输入的第一数据;obtaining the first data input by the user in the operable control;
将所述第一数据处理成XML文档存储在关系数据库。The first data is processed into an XML document and stored in a relational database.
本发明实施例的计算机可读存储介质,可以采用一个或多个计算机可读的介质的任意组合。计算机可读介质可以是计算机可读信号介质或者计算机可读存储介质。计算机可读存储介质例如可以是——但不限于——电、磁、光、电磁、红外线、或半导体的系统、装置或器件,或者任意以上的组合。计算机可读存储介质的更具体的例子(非穷举的列表)包括:具有一个或多个导线的电连接、便携式计算机磁盘、硬盘、随机存取存储器(RAM)、只读存储器(ROM)、可擦式可编程只读存储器(EPROM或闪存)、光纤、便携式紧凑磁盘只读存储器(CD-ROM)、光存储器件、磁存储器件、或者上述的任意合适的组合。在本文件中,计算机可读存储介质可以是任何包含或存储程序的有形介质,该程序可以被指令执行系统、装置或者器件使用或者与其结合使用。The computer-readable storage medium of the embodiments of the present invention may adopt any combination of one or more computer-readable mediums. The computer-readable medium may be a computer-readable signal medium or a computer-readable storage medium. The computer-readable storage medium can be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus or device, or a combination of any of the above. More specific examples (a non-exhaustive list) of computer readable storage media include: electrical connections having one or more wires, portable computer disks, hard disks, random access memory (RAM), read only memory (ROM), Erasable programmable read only memory (EPROM or flash memory), optical fiber, portable compact disk read only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the above. In this document, a computer-readable storage medium can be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device.
计算机可读的信号介质可以包括在基带中或者作为载波一部分传播的数据信号,其中承载了计算机可读的程序代码。这种传播的数据信号可以采用多种形式,包括但不限于电磁信号、光信号或上述的任意合适的组合。计算机可读的信号介质还可以是计算机可读存储介质以外的任何计算机可读介质,该计算机可读介质可以发送、传播或者传输用于由指令执行系统、装置或者器件使用或者与其结合使用的程序。A computer-readable signal medium may include a propagated data signal in baseband or as part of a carrier wave, with computer-readable program code embodied thereon. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the foregoing. A computer-readable signal medium can also be any computer-readable medium other than a computer-readable storage medium that can transmit, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device .
存储介质上包含的程序代码可以用任何适当的介质传输,包括——但不限于无线、电线、光缆、RF等等,或者上述的任意合适的组合。Program code embodied on a storage medium may be transmitted using any suitable medium, including - but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
可以以一种或多种程序设计语言或其组合来编写用于执行本发明操作的计算机程序代码,所述程序设计语言包括面向对象的程序设计语言—诸如Java、Smalltalk、C++,还包括常规的过程式程序设计语言—诸如“C”语言或类似的程序设计语言。程序代码可以完全地在用户计算机上执行、部分地在用户计算机上执行、作为一个独立的软件包执行、部分在用户计算机上部分在远程计算机上执行、或者完全在远程计算机或终端上执行。在涉及远程计算机的情形中,远程计算机可以通过任意种类的网络——包括局域网(LAN)或广域网(WAN)—连接到用户计算机,或者,可以连接到外部计算机(例如利用因特网服务提供商来通过因特网连接)。Computer program code for carrying out operations of the present invention may be written in one or more programming languages, including object-oriented programming languages—such as Java, Smalltalk, C++, but also conventional Procedural programming language - such as the "C" language or similar programming language. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer, or entirely on the remote computer or terminal. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (eg, using an Internet service provider through Internet connection).
注意,上述仅为本发明的较佳实施例及所运用技术原理。本领域技术人员会理解,本发明不限于这里所述的特定实施例,对本领域技术人员来说能够进行各种明显的变化、重新调整和替代而不会脱离本发明的保护范围。因此,虽然通过以上实施例对本发明进行了较为详细的说明,但是本发明不仅仅限于以上实施例,在不脱离本发明构思的情况下,还可以包括更多其他等效实施例,而本发明的范围由所附的权利要求范围决定。Note that the above are only preferred embodiments of the present invention and applied technical principles. Those skilled in the art will understand that the present invention is not limited to the specific embodiments described herein, and various obvious changes, readjustments and substitutions can be made by those skilled in the art without departing from the protection scope of the present invention. Therefore, although the present invention has been described in detail through the above embodiments, the present invention is not limited to the above embodiments, and can also include more other equivalent embodiments without departing from the concept of the present invention. The scope is determined by the scope of the appended claims.
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911157379.6ACN110889013B (en) | 2019-11-22 | 2019-11-22 | Data association method, device, server and storage medium based on XML |
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911157379.6ACN110889013B (en) | 2019-11-22 | 2019-11-22 | Data association method, device, server and storage medium based on XML |
| Publication Number | Publication Date |
|---|---|
| CN110889013Atrue CN110889013A (en) | 2020-03-17 |
| CN110889013B CN110889013B (en) | 2023-04-07 |
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911157379.6AExpired - Fee RelatedCN110889013B (en) | 2019-11-22 | 2019-11-22 | Data association method, device, server and storage medium based on XML |
| Country | Link |
|---|---|
| CN (1) | CN110889013B (en) |
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112000330A (en)* | 2020-07-15 | 2020-11-27 | 北京百度网讯科技有限公司 | Configuration method, device and equipment of modeling parameters and computer storage medium |
| CN112559612A (en)* | 2020-12-15 | 2021-03-26 | 北京动力机械研究所 | Dynamic data extraction and sharing method and device |
| CN113377876A (en)* | 2021-06-29 | 2021-09-10 | 中国农业银行股份有限公司 | Domino platform-based data sub-database processing method, device and platform |
| CN114077607A (en)* | 2021-11-18 | 2022-02-22 | 京东科技信息技术有限公司 | Method and device for determining data association relationship, computer equipment and storage medium |
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070047819A1 (en)* | 2005-08-23 | 2007-03-01 | Hull Jonathan J | Data organization and access for mixed media document system |
| CN101110021A (en)* | 2002-03-25 | 2008-01-23 | 数据质量解决公司 | Method for visually programming instruction set for process |
| CN101393517A (en)* | 2007-09-20 | 2009-03-25 | 上海宝信软件股份有限公司 | Method and apparatus for implementing collocation based on XML and control |
| CN101571800A (en)* | 2008-04-29 | 2009-11-04 | 中兴通讯股份有限公司 | Method and device for processing activex relation in control interface |
| CN101984438A (en)* | 2010-11-27 | 2011-03-09 | 杭州万格网络科技有限公司 | Method of online self-help website establishment, creation of application service and development of online software |
| CN102103491A (en)* | 2009-12-18 | 2011-06-22 | Tcl集团股份有限公司 | System and method for generating interface |
| CN102981855A (en)* | 2012-11-23 | 2013-03-20 | 蓝盾信息安全技术股份有限公司 | Template-based interface autogeneration method and system |
| CN104267962A (en)* | 2014-10-09 | 2015-01-07 | 浪潮通用软件有限公司 | Description-based interface UI control configuration method |
| CN106445983A (en)* | 2009-07-06 | 2017-02-22 | 孟智平 | Method for constructing and generating webpage, and system |
| CN108038213A (en)* | 2017-12-21 | 2018-05-15 | 中国农业银行股份有限公司 | A kind of method of data processing, client, server and system |
| US20190087392A1 (en)* | 2013-09-12 | 2019-03-21 | Wix.Com Ltd | System and method for automated conversion of interactive sites and applications to support mobile and other display environments |
| CN109783555A (en)* | 2018-12-13 | 2019-05-21 | 东软集团股份有限公司 | Form templat storage method, device, storage medium and electronic equipment |
| CN110377429A (en)* | 2019-07-24 | 2019-10-25 | 深圳乐信软件技术有限公司 | A kind of control method, device, server and storage medium that real-time task calculates |
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101110021A (en)* | 2002-03-25 | 2008-01-23 | 数据质量解决公司 | Method for visually programming instruction set for process |
| US20070047819A1 (en)* | 2005-08-23 | 2007-03-01 | Hull Jonathan J | Data organization and access for mixed media document system |
| CN101393517A (en)* | 2007-09-20 | 2009-03-25 | 上海宝信软件股份有限公司 | Method and apparatus for implementing collocation based on XML and control |
| CN101571800A (en)* | 2008-04-29 | 2009-11-04 | 中兴通讯股份有限公司 | Method and device for processing activex relation in control interface |
| CN106445983A (en)* | 2009-07-06 | 2017-02-22 | 孟智平 | Method for constructing and generating webpage, and system |
| CN102103491A (en)* | 2009-12-18 | 2011-06-22 | Tcl集团股份有限公司 | System and method for generating interface |
| CN101984438A (en)* | 2010-11-27 | 2011-03-09 | 杭州万格网络科技有限公司 | Method of online self-help website establishment, creation of application service and development of online software |
| CN102981855A (en)* | 2012-11-23 | 2013-03-20 | 蓝盾信息安全技术股份有限公司 | Template-based interface autogeneration method and system |
| US20190087392A1 (en)* | 2013-09-12 | 2019-03-21 | Wix.Com Ltd | System and method for automated conversion of interactive sites and applications to support mobile and other display environments |
| CN104267962A (en)* | 2014-10-09 | 2015-01-07 | 浪潮通用软件有限公司 | Description-based interface UI control configuration method |
| CN108038213A (en)* | 2017-12-21 | 2018-05-15 | 中国农业银行股份有限公司 | A kind of method of data processing, client, server and system |
| CN109783555A (en)* | 2018-12-13 | 2019-05-21 | 东软集团股份有限公司 | Form templat storage method, device, storage medium and electronic equipment |
| CN110377429A (en)* | 2019-07-24 | 2019-10-25 | 深圳乐信软件技术有限公司 | A kind of control method, device, server and storage medium that real-time task calculates |
| Title |
|---|
| D. PICARD 等: "The importance of sibling clustering for efficient bulkload of XML document trees"* |
| P. KREUGER 等: "Zero Configuration Adaptive Paging"* |
| 张晓宁: "模型驱动的用户界面生成方法的研究"* |
| 林子雨 等: "基于关系数据库的关键词查询"* |
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112000330A (en)* | 2020-07-15 | 2020-11-27 | 北京百度网讯科技有限公司 | Configuration method, device and equipment of modeling parameters and computer storage medium |
| CN112000330B (en)* | 2020-07-15 | 2023-12-22 | 北京百度网讯科技有限公司 | Configuration method, device, equipment and computer storage medium of modeling parameters |
| CN112559612A (en)* | 2020-12-15 | 2021-03-26 | 北京动力机械研究所 | Dynamic data extraction and sharing method and device |
| CN112559612B (en)* | 2020-12-15 | 2024-05-10 | 北京动力机械研究所 | Dynamic data extraction and sharing method and device |
| CN113377876A (en)* | 2021-06-29 | 2021-09-10 | 中国农业银行股份有限公司 | Domino platform-based data sub-database processing method, device and platform |
| CN113377876B (en)* | 2021-06-29 | 2024-05-28 | 中国农业银行股份有限公司 | Data database processing method, device and platform based on Domino platform |
| CN114077607A (en)* | 2021-11-18 | 2022-02-22 | 京东科技信息技术有限公司 | Method and device for determining data association relationship, computer equipment and storage medium |
| Publication number | Publication date |
|---|---|
| CN110889013B (en) | 2023-04-07 |
| Publication | Publication Date | Title |
|---|---|---|
| US11620301B2 (en) | Extended computerized query language syntax for analyzing multiple tabular data arrangements in data-driven collaborative projects | |
| US11042556B2 (en) | Localized link formation to perform implicitly federated queries using extended computerized query language syntax | |
| US11042560B2 (en) | Extended computerized query language syntax for analyzing multiple tabular data arrangements in data-driven collaborative projects | |
| CN115017182B (en) | Visual data analysis method and device | |
| US10984913B2 (en) | Blockchain system for natural language processing | |
| CN105359141B (en) | Supporting a combination of flow-based ETL and entity relationship-based ETL | |
| Karnitis et al. | Migration of relational database to document-oriented database: Structure denormalization and data transformation | |
| CN105144080B (en) | System for metadata management | |
| CN110889013B (en) | Data association method, device, server and storage medium based on XML | |
| US10657324B2 (en) | Systems and methods for generating electronic document templates and electronic documents | |
| CN105677875A (en) | Visual modeling platform based on unified constraint of normal data elements | |
| CN114218218A (en) | Data processing method, device and equipment based on data warehouse and storage medium | |
| CN114356964A (en) | Data lineage construction method, device, storage medium and electronic device | |
| WO2023151239A1 (en) | Micro-service creation method and related device | |
| WO2023051125A1 (en) | Structured data version management method, apparatus, and related device | |
| CN113962597A (en) | A data analysis method, device, electronic device and storage medium | |
| US12039416B2 (en) | Facilitating machine learning using remote data | |
| CN106503457B (en) | Clinical data based on translational medicine analysis platform integrates technical data introduction method | |
| KR100581687B1 (en) | A computer-readable recording medium recording a method of integrating heterogeneous database management systems and a program for executing the method. | |
| CN114385733A (en) | Method and device for unified creation of data model in ETL process | |
| Anthapu | Graph Data Processing with Cypher | |
| CN117851375A (en) | Metadata model optimization method and computing device | |
| CN100552665C (en) | Information Reproduction Independent Persistence | |
| Sharma et al. | FLASc: a formal algebra for labeled property graph schema | |
| CN114428928A (en) | Design method, device and medium for autonomous station building system |
| 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 | ||
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee | Granted publication date:20230407 |