Movatterモバイル変換


[0]ホーム

URL:


CN110889013A - XML-based data association method, device, server and storage medium - Google Patents

XML-based data association method, device, server and storage medium
Download PDF

Info

Publication number
CN110889013A
CN110889013ACN201911157379.6ACN201911157379ACN110889013ACN 110889013 ACN110889013 ACN 110889013ACN 201911157379 ACN201911157379 ACN 201911157379ACN 110889013 ACN110889013 ACN 110889013A
Authority
CN
China
Prior art keywords
data
xml
database
association method
stored
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
CN201911157379.6A
Other languages
Chinese (zh)
Other versions
CN110889013B (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 Ruian Technology Co Ltd
Original Assignee
Beijing Ruian 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 Ruian Technology Co LtdfiledCriticalBeijing Ruian Technology Co Ltd
Priority to CN201911157379.6ApriorityCriticalpatent/CN110889013B/en
Publication of CN110889013ApublicationCriticalpatent/CN110889013A/en
Application grantedgrantedCritical
Publication of CN110889013BpublicationCriticalpatent/CN110889013B/en
Expired - Fee Relatedlegal-statusCriticalCurrent
Anticipated expirationlegal-statusCritical

Links

Images

Classifications

Landscapes

Abstract

Translated fromChinese

本发明公开了一种基于XML的数据关联方法、装置、服务器及存储介质,该方法包括:获取基于页面配置的需求建模,所述需求建模包括多个可操作控件,所述多个可操作控件之间连线形成控件链,所述连线为数据之间的对应关系;获取用户在所述可操作控件输入的第一数据;将所述第一数据处理成XML文档存储在关系数据库。本发明的技术方案实现了向用户提供直观、简洁的数据服务和提高建模复用率的效果。

Figure 201911157379

The invention discloses an XML-based data association method, device, server and storage medium. The method includes: acquiring a requirement modeling based on page configuration, wherein the requirement modeling includes a plurality of operable controls, the plurality of operable controls Connecting lines between operating controls forms a control chain, and the connecting lines are the corresponding relationships between data; obtaining the first data input by the user in the operable controls; processing the first data into XML documents and storing them in a relational database . The technical scheme of the present invention achieves the effects of providing intuitive and concise data services to users and improving the modeling reuse rate.

Figure 201911157379

Description

Translated fromChinese
一种基于XML的数据关联方法、装置、服务器及存储介质XML-based data association method, device, server and storage medium

技术领域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-baseddata association apparatus 400 provided in Embodiment 4 of the present invention. The embodiment is applicable to data association situations, and the specific structure is as follows:

建模模块410,用于获取基于页面配置的需求建模,所述需求建模包括多个可操作控件,所述多个可操作控件之间连线形成控件链,所述连线为数据之间的对应关系;Themodeling module 410 is used to obtain the requirement modeling based on page configuration, the requirement modeling includes a plurality of operable controls, and the connection between the plurality of operable controls forms a control chain, and the connection is the connection between the data. Correspondence between;

数据获取模块420,用于获取用户在所述可操作控件输入的第一数据;adata acquisition module 420, configured to acquire the first data input by the user in the operable control;

处理模块430,用于将所述第一数据处理成XML文档存储在关系数据库。Theprocessing module 430 is configured to process the first data into an XML document and store it in a relational database.

进一步的,处理模块430包括根据预设算法将所述第一数据处理成XML文档存储在关系数据库,所述预设算法包括通过多个相互独立的子任务确定的集成逻辑。Further, theprocessing module 430 includes processing the first data into an XML document and storing 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.

进一步的,所述集成逻辑为所述多个相互独立的子任务间数据的关系描述。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, theapparatus 400 also includes a filtering module and an intermediate storage module,

过滤模块用于对所述第一数据进行过滤;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, theapparatus 400 also includes a migration data receiving module, a parsing module and a parsing data storage module,

迁移数据接收模块用于接收终端传输的迁移数据,所述迁移数据属于第一数据库,所述第一数据库与所述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, theapparatus 400 further includes a database management module, configured to perform database management on the XML document according to the database management operation of the user, where the database management includes a maintenance operation on the XML document.

本发明实施例所提供的基于XML的数据关联装置400可执行前述实施例所提供的基于XML的数据关联方法,具备执行方法相应的功能模块和有益效果。The XML-baseddata association apparatus 400 provided by the embodiment of the present invention can execute the XML-based data association method provided by the foregoing embodiments, and has functional modules and beneficial effects corresponding to the execution method.

实施例五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 anexemplary server 512 suitable for use in implementing embodiments of the present invention. Theserver 512 shown in FIG. 5 is only an example, and should not impose any limitations on the functions and scope of use of the embodiments of the present invention.

如图5所示,服务器512以通用服务器的形式表现。服务器512的组件可以包括但不限于:一个或者多个处理器516,存储装置528,连接不同系统组件(包括存储装置528和处理器516)的总线518。As shown in FIG. 5,server 512 takes the form of a general server. Components ofserver 512 may include, but are not limited to, one ormore processors 516,storage 528, andbus 518 that connects various systemcomponents including storage 528 andprocessor 516.

总线518表示几类总线结构中的一种或多种,包括存储装置总线或者存储装置控制器,外围总线,图形加速端口,处理器或者使用多种总线结构中的任意总线结构的局域总线。举例来说,这些体系结构包括但不限于工业标准体系结构(Industry SubversiveAlliance,ISA)总线,微通道体系结构(Micro Channel Architecture,MAC)总线,增强型ISA总线、视频电子标准协会(Video Electronics Standards Association,VESA)局域总线以及外围组件互连(Peripheral Component Interconnect,PCI)总线。Bus 518 represents one or more of several types of bus structures, including a storage device bus or storage device controller, a peripheral bus, a graphics acceleration port, a processor, or a local bus using any of a variety of bus structures. For example, these architectures include, but are not limited to, Industry Subversive Alliance (ISA) bus, Micro Channel Architecture (MAC) bus, enhanced ISA bus, Video Electronics Standards Association (Video Electronics Standards Association) , VESA) local bus and peripheral component interconnect (Peripheral Component Interconnect, PCI) bus.

服务器512典型地包括多种计算机系统可读介质。这些介质可以是任何能够被服务器512访问的可用介质,包括易失性和非易失性介质,可移动的和不可移动的介质。Server 512 typically includes a variety of computer system readable media. These media can be any available media that can be accessed byserver 512, including volatile and non-volatile media, removable and non-removable media.

存储装置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可以包括至少一个程序产品,该程序产品具有一组(例如至少一个)程序模块,这些程序模块被配置以执行本发明各实施例的功能。Storage 528 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 530 and/orcache memory 532 .Terminal 512 may further include other removable/non-removable, volatile/non-volatile computer system storage media. For example only,storage system 534 may be used to read and write to non-removable, non-volatile magnetic media (not shown in FIG. 5, commonly referred to as a "hard drive"). Although not shown in Figure 5, a magnetic disk drive may be provided for reading and writing to removable non-volatile magnetic disks (eg "floppy disks"), as well as removable non-volatile optical disks, such as Compact Disc Read -Only Memory, CD-ROM), digital video disc (Digital Video Disc-Read Only Memory, DVD-ROM) or other optical media) CD-ROM drive for reading and writing. In these cases, each drive may be connected tobus 518 through one or more data media interfaces.Storage 528 may include at least one program product having a set (eg, at least one) of program modules configured to perform the functions of various embodiments of the present invention.

具有一组(至少一个)程序模块542的程序/实用工具540,可以存储在例如存储装置528中,这样的程序模块542包括但不限于操作系统、一个或者多个应用程序、其它程序模块以及程序数据,这些示例中的每一个或某种组合中可能包括网络环境的实现。程序模块542通常执行本发明所描述的实施例中的功能和/或方法。A program/utility 540 having a set (at least one) ofprogram modules 542, which may be stored, for example, instorage device 528,such program modules 542 including, but not limited to, an operating system, one or more application programs, other program modules, and programs Data, each or some combination of these examples may include an implementation of a network environment.Program modules 542 generally perform the functions and/or methods of the described embodiments of the present invention.

服务器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)系统、磁带驱动器以及数据备份存储系统等。Theserver 512 may also communicate with one or more external devices 514 (eg, keyboards, pointing terminals, displays 524, etc.), with one or more terminals that enable a user to interact with theserver 512, and/or with theServer 512 can communicate with any terminal (eg, network card, modem, etc.) that communicates with one or more other computing terminals. Such communication may occur through input/output (I/O)interface 522 . Also, theserver 512 may communicate with one or more networks (eg, Local Area Network (LAN), Wide Area Network (WAN), and/or public networks such as the Internet) through anetwork adapter 520 . As shown in FIG. 5 ,network adapter 520 communicates with other modules ofserver 512 viabus 518 . It should be understood that, although not shown, other hardware and/or software modules may be used in conjunction withserver 512, including but not limited to: microcode, terminal drivers, redundant processors, external disk drive arrays, Redundant Arrays of disks Independent Disks, RAID) systems, tape drives and data backup storage systems.

处理器516通过运行存储在存储装置528中的程序,从而执行各种功能应用以及数据处理,例如实现本发明任意实施例所提供的一种基于XML的数据关联方法,该方法可以包括:Theprocessor 516 executes various functional applications and data processing by running the programs stored in thestorage device 528, for example, implementing an XML-based data association method provided by any embodiment of the present invention, and the method may 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.

实施例六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.

Claims (10)

Translated fromChinese
1.一种基于XML的数据关联方法,其特征在于,包括:1. a data association method based on XML, is characterized in that, comprises:获取基于页面配置的需求建模,所述需求建模包括多个可操作控件,所述多个可操作控件之间连线形成控件链,所述连线为数据之间的对应关系;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.2.根据权利要求1所述的基于XML的数据关联方法,其特征在于,所述将所述第一数据处理成XML文档存储在关系数据库包括:2. The XML-based data association method according to claim 1, wherein the described first data is processed into an XML document and stored in a relational database, comprising:根据预设算法将所述第一数据处理成XML文档存储在关系数据库,所述预设算法包括通过多个相互独立的子任务确定的集成逻辑。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.3.根据权利要求2所述的基于XML的数据关联方法,其特征在于,所述集成逻辑为所述多个相互独立的子任务间数据的关系描述。3 . The XML-based data association method according to claim 2 , wherein the integration logic is a relationship description of data among the plurality of mutually independent subtasks. 4 .4.根据权利要求2所述的基于XML的数据关联方法,其特征在于,所述子任务包括数据表信息,所述数据表信息包括表模式,表名称,字段列表和对应数据类型的列表。4. The XML-based data association method according to claim 2, wherein the subtask comprises data table information, and the data table information comprises table schema, table name, field list and list of corresponding data types.5.根据权利要求1所述的基于XML的数据关联方法,其特征在于,所述获取用户在所述可操作控件输入的第一数据之后,还包括:5. The XML-based data association method according to claim 1, wherein after acquiring the first data input by the user in the operable control, the method further comprises:对所述第一数据进行过滤;filtering the first data;将过滤后的所述第一数据存储在数据仓库,所述数据仓库用于存储中间数据。The filtered first data is stored in a data warehouse, where the data warehouse is used to store intermediate data.6.根据权利要求1所述的基于XML的数据关联方法,其特征在于,进一步还包括:6. XML-based data association method according to claim 1, is characterized in that, further comprises:接收终端传输的迁移数据,所述迁移数据属于第一数据库,所述第一数据库与所述XML文档对应的第二数据库不同;receiving 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;根据预设的解析规则将所述迁移数据解析成解析数据,所述预设解析规则包括所述第一数据库对应的解析规则;Parsing 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 parsed data is stored in the relational database.7.根据权利要求1所述的基于XML的数据关联方法,其特征在于,所述将所述第一数据处理成XML文档存储在关系数据库之后,还包括:7. The XML-based data association method according to claim 1, wherein after the described first data is processed into an XML document and stored in a relational database, the method further comprises:根据用户的数据库管理操作对所述XML文档进行数据库管理,所述数据库管理包括对所述XML文档的维护操作。Database management is performed on the XML document according to a user's database management operation, and the database management includes a maintenance operation on the XML document.8.一种基于XML的数据关联装置,其特征在于,包括:8. A data association device based on XML, characterized in that, comprising:建模模块,用于获取基于页面配置的需求建模,所述需求建模包括多个可操作控件,所述多个可操作控件之间连线形成控件链,所述连线为数据之间的对应关系;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.9.一种服务器,其特征在于,包括存储器,处理器及存储在存储器上并可在处理器运行的计算机程序,所述处理器执行所述计算机程序时实现如权利要求1-7中任一所述的基于XML的数据关联方法。9. A server, characterized in that it comprises a memory, a processor and a computer program stored on the memory and run on the processor, and when the processor executes the computer program, any one of claims 1-7 is implemented. The described XML-based data association method.10.一种计算机可读存储介质,其上存储有计算机程序,其特征在于,该程序被处理器执行时实现如权利要求1-7中任一所述的基于XML的数据关联方法。10. A computer-readable storage medium on which a computer program is stored, characterized in that, when the program is executed by a processor, the XML-based data association method according to any one of claims 1-7 is implemented.
CN201911157379.6A2019-11-222019-11-22Data association method, device, server and storage medium based on XMLExpired - Fee RelatedCN110889013B (en)

Priority Applications (1)

Application NumberPriority DateFiling DateTitle
CN201911157379.6ACN110889013B (en)2019-11-222019-11-22Data association method, device, server and storage medium based on XML

Applications Claiming Priority (1)

Application NumberPriority DateFiling DateTitle
CN201911157379.6ACN110889013B (en)2019-11-222019-11-22Data association method, device, server and storage medium based on XML

Publications (2)

Publication NumberPublication Date
CN110889013Atrue CN110889013A (en)2020-03-17
CN110889013B CN110889013B (en)2023-04-07

Family

ID=69748451

Family Applications (1)

Application NumberTitlePriority DateFiling Date
CN201911157379.6AExpired - Fee RelatedCN110889013B (en)2019-11-222019-11-22Data association method, device, server and storage medium based on XML

Country Status (1)

CountryLink
CN (1)CN110889013B (en)

Cited By (4)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN112000330A (en)*2020-07-152020-11-27北京百度网讯科技有限公司Configuration method, device and equipment of modeling parameters and computer storage medium
CN112559612A (en)*2020-12-152021-03-26北京动力机械研究所Dynamic data extraction and sharing method and device
CN113377876A (en)*2021-06-292021-09-10中国农业银行股份有限公司Domino platform-based data sub-database processing method, device and platform
CN114077607A (en)*2021-11-182022-02-22京东科技信息技术有限公司Method and device for determining data association relationship, computer equipment and storage medium

Citations (13)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
US20070047819A1 (en)*2005-08-232007-03-01Hull Jonathan JData organization and access for mixed media document system
CN101110021A (en)*2002-03-252008-01-23数据质量解决公司Method for visually programming instruction set for process
CN101393517A (en)*2007-09-202009-03-25上海宝信软件股份有限公司Method and apparatus for implementing collocation based on XML and control
CN101571800A (en)*2008-04-292009-11-04中兴通讯股份有限公司Method and device for processing activex relation in control interface
CN101984438A (en)*2010-11-272011-03-09杭州万格网络科技有限公司Method of online self-help website establishment, creation of application service and development of online software
CN102103491A (en)*2009-12-182011-06-22Tcl集团股份有限公司System and method for generating interface
CN102981855A (en)*2012-11-232013-03-20蓝盾信息安全技术股份有限公司Template-based interface autogeneration method and system
CN104267962A (en)*2014-10-092015-01-07浪潮通用软件有限公司Description-based interface UI control configuration method
CN106445983A (en)*2009-07-062017-02-22孟智平Method for constructing and generating webpage, and system
CN108038213A (en)*2017-12-212018-05-15中国农业银行股份有限公司A kind of method of data processing, client, server and system
US20190087392A1 (en)*2013-09-122019-03-21Wix.Com LtdSystem and method for automated conversion of interactive sites and applications to support mobile and other display environments
CN109783555A (en)*2018-12-132019-05-21东软集团股份有限公司Form templat storage method, device, storage medium and electronic equipment
CN110377429A (en)*2019-07-242019-10-25深圳乐信软件技术有限公司A kind of control method, device, server and storage medium that real-time task calculates

Patent Citations (13)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN101110021A (en)*2002-03-252008-01-23数据质量解决公司Method for visually programming instruction set for process
US20070047819A1 (en)*2005-08-232007-03-01Hull Jonathan JData organization and access for mixed media document system
CN101393517A (en)*2007-09-202009-03-25上海宝信软件股份有限公司Method and apparatus for implementing collocation based on XML and control
CN101571800A (en)*2008-04-292009-11-04中兴通讯股份有限公司Method and device for processing activex relation in control interface
CN106445983A (en)*2009-07-062017-02-22孟智平Method for constructing and generating webpage, and system
CN102103491A (en)*2009-12-182011-06-22Tcl集团股份有限公司System and method for generating interface
CN101984438A (en)*2010-11-272011-03-09杭州万格网络科技有限公司Method of online self-help website establishment, creation of application service and development of online software
CN102981855A (en)*2012-11-232013-03-20蓝盾信息安全技术股份有限公司Template-based interface autogeneration method and system
US20190087392A1 (en)*2013-09-122019-03-21Wix.Com LtdSystem and method for automated conversion of interactive sites and applications to support mobile and other display environments
CN104267962A (en)*2014-10-092015-01-07浪潮通用软件有限公司Description-based interface UI control configuration method
CN108038213A (en)*2017-12-212018-05-15中国农业银行股份有限公司A kind of method of data processing, client, server and system
CN109783555A (en)*2018-12-132019-05-21东软集团股份有限公司Form templat storage method, device, storage medium and electronic equipment
CN110377429A (en)*2019-07-242019-10-25深圳乐信软件技术有限公司A kind of control method, device, server and storage medium that real-time task calculates

Non-Patent Citations (4)

* Cited by examiner, † Cited by third party
Title
D. PICARD 等: "The importance of sibling clustering for efficient bulkload of XML document trees"*
P. KREUGER 等: "Zero Configuration Adaptive Paging"*
张晓宁: "模型驱动的用户界面生成方法的研究"*
林子雨 等: "基于关系数据库的关键词查询"*

Cited By (7)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN112000330A (en)*2020-07-152020-11-27北京百度网讯科技有限公司Configuration method, device and equipment of modeling parameters and computer storage medium
CN112000330B (en)*2020-07-152023-12-22北京百度网讯科技有限公司Configuration method, device, equipment and computer storage medium of modeling parameters
CN112559612A (en)*2020-12-152021-03-26北京动力机械研究所Dynamic data extraction and sharing method and device
CN112559612B (en)*2020-12-152024-05-10北京动力机械研究所Dynamic data extraction and sharing method and device
CN113377876A (en)*2021-06-292021-09-10中国农业银行股份有限公司Domino platform-based data sub-database processing method, device and platform
CN113377876B (en)*2021-06-292024-05-28中国农业银行股份有限公司Data database processing method, device and platform based on Domino platform
CN114077607A (en)*2021-11-182022-02-22京东科技信息技术有限公司Method and device for determining data association relationship, computer equipment and storage medium

Also Published As

Publication numberPublication date
CN110889013B (en)2023-04-07

Similar Documents

PublicationPublication DateTitle
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
AnthapuGraph 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

Legal Events

DateCodeTitleDescription
PB01Publication
PB01Publication
SE01Entry into force of request for substantive examination
SE01Entry into force of request for substantive examination
GR01Patent grant
GR01Patent grant
CF01Termination of patent right due to non-payment of annual fee
CF01Termination of patent right due to non-payment of annual fee

Granted publication date:20230407


[8]ページ先頭

©2009-2025 Movatter.jp