CN106777025A - A kind of analysis method and system of database physical model - Google Patents
A kind of analysis method and system of database physical model Download PDFInfo
- Publication number
- CN106777025A CN106777025A CN201611123126.3A CN201611123126A CN106777025A CN 106777025 A CN106777025 A CN 106777025A CN 201611123126 A CN201611123126 A CN 201611123126A CN 106777025 A CN106777025 A CN 106777025A
- Authority
- CN
- China
- Prior art keywords
- similar
- physical model
- xml file
- database
- similarity
- 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
Links
- 238000004458 analytical method Methods 0.000 title claims abstract description 32
- 238000006243 chemical reaction Methods 0.000 claims description 3
- 238000013461 design Methods 0.000 abstract description 8
- 230000002159 abnormal effect Effects 0.000 abstract description 3
- 230000007547 defect Effects 0.000 abstract description 2
- 230000000694 effects Effects 0.000 abstract description 2
- 238000000034 method Methods 0.000 description 3
- 238000012552 review Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 230000018109 developmental process Effects 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000012795 verification Methods 0.000 description 2
- 230000008878 coupling Effects 0.000 description 1
- 238000010168 coupling process Methods 0.000 description 1
- 238000005859 coupling reaction Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 230000033772 system development Effects 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/83—Querying
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
- G06F16/212—Schema design and management with details for data modelling support
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
本发明公开了一种数据库物理模型的分析方法，包括：获取待分析的数据库物理模型文件；将所述数据库物理模型文件转化为XML文件；解析所述XML文件，统计所述XML文件中的相似表，以及所述相似表内的相似字段长度差异信息；可见，在本实施例中，可通过对数据库物理模型的分析统计出物理模型中相似表和相似表的字段长度异常，以使在项目初期对整个数据库有一个明确清楚的了解，避免由于数据库设计缺陷，导致后期整改所带来的一系列的不可估量的代价；本发明还公开了一种数据库物理模型的分析系统，同样能实现上述技术效果。
The invention discloses an analysis method of a physical model of a database, comprising: obtaining a physical model file of a database to be analyzed; converting the physical model file of the database into an XML file; parsing the XML file, and counting similarities in the XML file table, and the similar field length difference information in the similar table; it can be seen that in this embodiment, the analysis of the physical model of the database can be used to calculate the abnormal length of the similar table and the field length of the similar table in the physical model, so that in the project Have a clear and clear understanding of the entire database at the initial stage, avoiding a series of immeasurable costs caused by subsequent rectification due to database design defects; the invention also discloses an analysis system for the physical model of the database, which can also achieve the above technical effect.
Description
技术领域technical field
本发明涉及数据库物理模型分析技术领域，更具体地说，涉及一种数据库物理模型的分析方法及系统。The present invention relates to the technical field of database physical model analysis, and more specifically, relates to an analysis method and system for a database physical model.
背景技术Background technique
当今环境，是一个要求快速开发的时代，项目初期规划数据库设计文档的时间并不充足，我们要在仅有的时间内作出适合系统开发的数据库设计文件难度很大，即使短时间内完成数据库的设计，后期可能也会在开发过程中发现不足，那时修改设计文档又会浪费大量的时间，因此，如何检验与分析数据库物理模型的耦合性及一致性，定位数据库设计的纰漏，是本领域技术人员需要解决的问题。Today's environment is an era that requires rapid development. There is not enough time to plan database design documents at the initial stage of the project. It is very difficult for us to make database design documents suitable for system development in the limited time. In the later stage of design, deficiencies may also be found in the development process. At that time, it will waste a lot of time to modify the design documents. Therefore, how to test and analyze the coupling and consistency of the database physical model, and locate the flaws in the database design is an issue in this field. Problems that technicians need to solve.
发明内容Contents of the invention
本发明的目的在于提供一种数据库物理模型的分析方法及系统，以实现对数据库物理模型的校验及分析。The object of the present invention is to provide a database physical model analysis method and system to realize the verification and analysis of the database physical model.
为实现上述目的，本发明实施例提供了如下技术方案：In order to achieve the above object, the embodiment of the present invention provides the following technical solutions:
一种数据库物理模型的分析方法，包括：An analysis method for a physical model of a database, comprising:
获取待分析的数据库物理模型文件；Obtain the database physical model file to be analyzed;
将所述数据库物理模型文件转化为XML文件；Converting the database physical model file into an XML file;
解析所述XML文件，统计所述XML文件中的相似表，以及所述相似表内的相似字段长度差异信息。The XML file is parsed, the similarity table in the XML file is counted, and the similarity field length difference information in the similarity table is counted.
其中，所述XML文件包括：文档根节点、根节点表格元素、列集合元素、列集合属性元素。Wherein, the XML file includes: a document root node, a table element of the root node, a column set element, and a column set attribute element.
其中，所述解析所述XML文件，统计所述XML文件中的相似表，以及所述相似表内的相似字段长度差异信息，包括：Wherein, the parsing of the XML file, statistics of the similarity table in the XML file, and similar field length difference information in the similarity table include:
分析所述文档根节点和所述列集合元素，统计所述列元素中表名相同的列元素，并将表名相同的列元素作为相似表；Analyzing the document root node and the column set elements, counting the column elements with the same table name among the column elements, and using the column elements with the same table name as similar tables;
若检测相似表之间的字段长度不同，则生成与所述相似表对应的相似字段长度差异信息。If it is detected that the field lengths between similar tables are different, generating similar field length difference information corresponding to the similar tables.
其中，所述统计所述XML文件中的相似表，以及所述相似表内的相似字段长度差异信息之后，还包括：Wherein, after the statistics of the similarity table in the XML file and the similar field length difference information in the similarity table, it also includes:
将所述相似表，以及所述相似表内的相似字段长度差异信息以列表形式进行显示。The similarity table and the similar field length difference information in the similarity table are displayed in a list form.
一种数据库物理模型的分析系统，包括：An analysis system for a physical model of a database, comprising:
获取模块，用于获取待分析的数据库物理模型文件；An acquisition module, configured to acquire the database physical model file to be analyzed;
物理模型文件转化模块，用于将所述数据库物理模型文件转化为XML文件；A physical model file conversion module, configured to convert the physical model file of the database into an XML file;
统计模块，用于解析所述XML文件，统计所述XML文件中的相似表，以及所述相似表内的相似字段长度差异信息。A statistical module, configured to parse the XML file, count the similarity table in the XML file, and the similarity field length difference information in the similarity table.
其中，所述XML文件包括：文档根节点、根节点表格元素、列集合元素、列集合属性元素。Wherein, the XML file includes: a document root node, a table element of the root node, a column set element, and a column set attribute element.
其中，所述统计模块，包括：Wherein, the statistical module includes:
分析单元，用于分析所述文档根节点和所述列集合元素；an analysis unit, configured to analyze the document root node and the column set element;
统计单元，用于统计所述列元素中表名相同的列元素，并将表名相同的列元素作为相似表；A statistical unit, configured to count column elements with the same table name among the column elements, and use the column elements with the same table name as similar tables;
相似表字段差异信息生成模块，用于检测相似表之间的字段长度不同时，生成与所述相似表对应的相似字段长度差异信息。The similar table field difference information generating module is configured to generate similar field length difference information corresponding to the similar table when detecting that the field lengths between the similar tables are different.
其中，本方案还包括：Among them, this program also includes:
显示模块，用于将所述相似表，以及所述相似表内的相似字段长度差异信息以列表形式进行显示。A display module, configured to display the similarity table and similar field length difference information in the similarity table in a list form.
通过以上方案可知，本发明实施例提供的一种数据库物理模型的分析方法，包括：获取待分析的数据库物理模型文件；将所述数据库物理模型文件转化为XML文件；解析所述XML文件，统计所述XML文件中的相似表，以及所述相似表内的相似字段长度差异信息；可见，在本实施例中，可通过对数据库物理模型的分析统计出物理模型中相似表和相似表的字段长度异常，以使在项目初期对整个数据库有一个明确清楚的了解，避免由于数据库设计缺陷，导致后期整改所带来的一系列的不可估量的代价；本发明还公开了一种数据库物理模型的分析系统，同样能实现上述技术效果。It can be seen from the above scheme that the analysis method of a database physical model provided by the embodiment of the present invention includes: obtaining the database physical model file to be analyzed; converting the database physical model file into an XML file; parsing the XML file, and counting The similar table in the XML file, and the similar field length difference information in the similar table; it can be seen that in this embodiment, the similar table and the fields of the similar table in the physical model can be calculated by analyzing the physical model of the database The length is abnormal, so as to have a clear and clear understanding of the entire database at the beginning of the project, and avoid a series of immeasurable costs caused by subsequent rectification due to database design defects; the invention also discloses a physical model of the database The analysis system can also achieve the above-mentioned technical effects.
附图说明Description of drawings
为了更清楚地说明本发明实施例或现有技术中的技术方案，下面将对实施例或现有技术描述中所需要使用的附图作简单地介绍，显而易见地，下面描述中的附图仅仅是本发明的一些实施例，对于本领域普通技术人员来讲，在不付出创造性劳动的前提下，还可以根据这些附图获得其他的附图。In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the following will briefly introduce the drawings that need to be used in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description are only These are some embodiments of the present invention. Those skilled in the art can also obtain other drawings based on these drawings without creative work.
图1为本发明实施例公开的一种数据库物理模型的分析方法流程示意图；Fig. 1 is a schematic flowchart of an analysis method of a database physical model disclosed in an embodiment of the present invention;
图2为本发明实施例公开的XML文件组成结构示意图；Fig. 2 is a schematic diagram of the structure of the XML file disclosed in the embodiment of the present invention;
图3为本发明实施例公开的一种数据库物理模型的分析系统结构示意图。FIG. 3 is a schematic structural diagram of an analysis system for a database physical model disclosed in an embodiment of the present invention.
具体实施方式detailed description
下面将结合本发明实施例中的附图，对本发明实施例中的技术方案进行清楚、完整地描述，显然，所描述的实施例仅仅是本发明一部分实施例，而不是全部的实施例。基于本发明中的实施例，本领域普通技术人员在没有作出创造性劳动前提下所获得的所有其他实施例，都属于本发明保护的范围。The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.
本发明实施例公开了一种数据库物理模型的分析方法及系统，以实现对数据库物理模型的校验及分析。The embodiment of the invention discloses a database physical model analysis method and system, so as to realize the verification and analysis of the database physical model.
参见图1，本发明实施例提供的一种数据库物理模型的分析方法，包括：Referring to Fig. 1, an analysis method of a database physical model provided by an embodiment of the present invention includes:
S101、获取待分析的数据库物理模型文件；S101. Obtain a database physical model file to be analyzed;
具体的，在本实施例中，待分析的数据库物理模型文件为已有的数据库物理模型文件，支持从目录中获取多个物理模型文件或从单个数据来源中获取单个物理模型文件，在此并不限定。Specifically, in this embodiment, the database physical model file to be analyzed is an existing database physical model file, which supports obtaining multiple physical model files from a directory or obtaining a single physical model file from a single data source. Not limited.
S102、将所述数据库物理模型文件转化为XML文件；S102. Convert the database physical model file into an XML file;
其中，所述XML文件包括：文档根节点、根节点表格元素、列集合元素、列集合属性元素。需要说明的是，将数据库物理模型文件转化为XML文件后，还可提取该物理模型文件中的两个或者多个有关联的关系表，或者在模型中没有与任何表有关联的单表。Wherein, the XML file includes: a document root node, a table element of the root node, a column set element, and a column set attribute element. It should be noted that after converting the database physical model file into an XML file, two or more associated relational tables in the physical model file, or a single table not associated with any table in the model can also be extracted.
具体的，在本实施例中，可将数据库物理模型文件解析成对应的XML文件，参见图2，转化的XML文档的主要构成元素有：文档根节点、若干个根节点表格元素、表格元素下的列集合元素、列集合下的属性元素、属性中的文本元素等，自上而下呈树形包含关系，层次结构清晰分明。Specifically, in this embodiment, the database physical model file can be parsed into a corresponding XML file. Referring to FIG. The column set elements, the attribute elements under the column set, the text elements in the attributes, etc., have a tree-like containment relationship from top to bottom, and the hierarchical structure is clear and distinct.
S103、解析所述XML文件，统计所述XML文件中的相似表，以及所述相似表内的相似字段长度差异信息。S103. Parse the XML file, and collect similarity tables in the XML file, and similar field length difference information in the similarity table.
其中，所述解析所述XML文件，统计所述XML文件中的相似表，以及所述相似表内的相似字段长度差异信息，包括：Wherein, the parsing of the XML file, statistics of the similarity table in the XML file, and similar field length difference information in the similarity table include:
分析所述文档根节点和所述列集合元素，统计所述列元素中表名相同的列元素，并将表名相同的列元素作为相似表；Analyzing the document root node and the column set elements, counting the column elements with the same table name among the column elements, and using the column elements with the same table name as similar tables;
若检测相似表之间的字段长度不同，则生成与所述相似表对应的相似字段长度差异信息。If it is detected that the field lengths between similar tables are different, generating similar field length difference information corresponding to the similar tables.
具体的，在本实施例中，以图2为例，XML文件中的文档根节点中存储了若干个根节点表元素o:Table，用于标识不同表；在每个表元素o:Table下都有多个列元素o:Column，用于标识数据表中有多少列；在列元素下的多个元素用于对该列的说明：Specifically, in this embodiment, taking Fig. 2 as an example, several root node table elements o:Table are stored in the document root node in the XML file, which are used to identify different tables; under each table element o:Table There are multiple column elements o:Column, which are used to identify how many columns there are in the data table; multiple elements under the column element are used to describe the column:
a:Name用于标记字段中文名称；a:Name is used to mark the Chinese name of the field;
a:Code用于标记字段英文名称，即字段名；a:Code is used to mark the English name of the field, that is, the field name;
a:DataType用于标记字段类型；a:DataType is used to mark the field type;
a:Comment用于标记字段的注视；a:Comment is used to mark the attention of the field;
a:Creator用于标记字段的创建人，即是谁建立的字段；a: Creator is used to mark the creator of the field, that is, who created the field;
相应的，本实施例中，通过分析文档根节点和列集合元素，统计列元素中表名相同的列元素，并将表名相同的列元素作为相似表具体为：Correspondingly, in this embodiment, by analyzing the document root node and the column set element, the column elements with the same table name among the column elements are counted, and the column elements with the same table name are regarded as similar tables, specifically:
通过列集合元素中的不同属性进行比较，例如：比较a:Code(字段英文名称)，a:DataType(字段类型)这两个属性，若均相同则为相似表，相应的，为了提高对相似表的准确性，可以增加a:Name等其他需要比较的属性。Compare the different attributes in the column set elements, for example: compare the two attributes a:Code (English name of the field) and a:DataType (field type), if they are the same, it is a similar table. Correspondingly, in order to improve the similarity The accuracy of the table can add a:Name and other attributes that need to be compared.
需要说明的是，在本实施例中也可以通过其他方式确定相似表，例如：通过相似度百分比统计相似表：如果表之间字段(列)的a:Code(字段英文名称)和a:DataType(字段类型)完全相同，则表的相似度为100％；如果表之间字段(列)的a:Code(字段英文名称)，a:DataType(字段类型)的相似度为80％，则表的相似度为80％；如果表之间字段(列)的a:Code(字段英文名称)，a:DataType(字段类型)没有重复列，则表的相似度为0，从而确定表之间的相似度，并且可以预定相似度判定阈值，若表之间的相似度大于预定阈值，则判定为相似表。It should be noted that, in this embodiment, similar tables can also be determined in other ways, for example: similar tables are counted by similarity percentage: if a:Code (field English name) and a:DataType of fields (columns) between tables (field type) is exactly the same, the similarity of the table is 100%; if the similarity of a:Code (field English name) and a:DataType (field type) of the fields (columns) between tables is 80%, then the table The similarity of the table is 80%; if the a:Code (English name of the field) and a:DataType (field type) of the fields (columns) between the tables have no repeated columns, the similarity of the tables is 0, so as to determine the relationship between the tables similarity, and a similarity judgment threshold can be predetermined, and if the similarity between tables is greater than the predetermined threshold, it will be judged as a similar table.
可以理解的是，本方案中的相似表内的相似字段长度差异信息，可通过对不同表之间关联字段的a:Length(字段长度)来确定，若两个相似表之间的关联字段的a:Length(字段长度)不同，则说明两个相似表之间存在相似字段长度差异，从而生成对应的差异信息。It can be understood that the length difference information of similar fields in similar tables in this scheme can be determined by a:Length (field length) of associated fields between different tables, if the associated fields between two similar tables If a:Length (field length) is different, it means that there is a similar field length difference between the two similar tables, thereby generating corresponding difference information.
基于上述实施例，在本实施例中，所述统计所述XML文件中的相似表，以及所述相似表内的相似字段长度差异信息之后，还包括：Based on the above-mentioned embodiment, in this embodiment, after the statistics of the similarity table in the XML file and the similar field length difference information in the similarity table, it also includes:
将所述相似表，以及所述相似表内的相似字段长度差异信息以列表形式进行显示。The similarity table and the similar field length difference information in the similarity table are displayed in a list form.
具体的，统计出XML文件中的相似表及相似表中的字段长度差异后，可以通过列表的形式进行显示，从而使用户清楚数据库物理模型中存在的问题。可见，本实施例中所提供的数据库物理模型的分析方法，能够快速定位相似表中重复字段以及快速提取设计文档中的异常字段信息的优点。相对于现有的人工审查来说，减少了审查成本，避免人工检查出现错误。Specifically, after counting the similar tables in the XML file and the field length differences in the similar tables, they can be displayed in the form of a list, so that the user can clearly understand the problems existing in the physical model of the database. It can be seen that the method for analyzing the physical model of the database provided in this embodiment can quickly locate repeated fields in similar tables and quickly extract information about abnormal fields in design documents. Compared with the existing manual review, the review cost is reduced and errors in manual review are avoided.
下面对本发明实施例提供的分析系统进行介绍，下文描述的分析系统与上文描述的分析方法可以相互参照。The analysis system provided by the embodiment of the present invention is introduced below, and the analysis system described below and the analysis method described above may refer to each other.
参见图3，本发明实施例提供的一种数据库物理模型的分析系统，包括：Referring to Fig. 3, an analysis system of a database physical model provided by an embodiment of the present invention includes:
获取模块100，用于获取待分析的数据库物理模型文件；An acquisition module 100, configured to acquire a database physical model file to be analyzed;
物理模型文件转化模块200，用于将所述数据库物理模型文件转化为XML文件；A physical model file conversion module 200, configured to convert the physical model file of the database into an XML file;
统计模块300，用于解析所述XML文件，统计所述XML文件中的相似表，以及所述相似表内的相似字段长度差异信息。The statistical module 300 is configured to parse the XML file, count the similarity table in the XML file, and the similarity field length difference information in the similarity table.
其中，所述XML文件包括：文档根节点、根节点表格元素、列集合元素、列集合属性元素。Wherein, the XML file includes: a document root node, a table element of the root node, a column set element, and a column set attribute element.
基于上述实施例，所述统计模块，包括：Based on the foregoing embodiments, the statistical module includes:
分析单元，用于分析所述文档根节点和所述列集合元素；an analysis unit, configured to analyze the document root node and the column set element;
统计单元，用于统计所述列元素中表名相同的列元素，并将表名相同的列元素作为相似表；A statistical unit, configured to count column elements with the same table name among the column elements, and use the column elements with the same table name as similar tables;
相似表字段差异信息生成模块，用于检测相似表之间的字段长度不同时，生成与所述相似表对应的相似字段长度差异信息。The similar table field difference information generating module is configured to generate similar field length difference information corresponding to the similar table when detecting that the field lengths between the similar tables are different.
基于上述任意实施例，本实施例中还包括：Based on any of the above embodiments, this embodiment also includes:
显示模块，用于将所述相似表，以及所述相似表内的相似字段长度差异信息以列表形式进行显示。A display module, configured to display the similarity table and similar field length difference information in the similarity table in a list form.
本说明书中各个实施例采用递进的方式描述，每个实施例重点说明的都是与其他实施例的不同之处，各个实施例之间相同相似部分互相参见即可。Each embodiment in this specification is described in a progressive manner, each embodiment focuses on the difference from other embodiments, and the same and similar parts of each embodiment can be referred to each other.
对所公开的实施例的上述说明，使本领域专业技术人员能够实现或使用本发明。对这些实施例的多种修改对本领域的专业技术人员来说将是显而易见的，本文中所定义的一般原理可以在不脱离本发明的精神或范围的情况下，在其它实施例中实现。因此，本发明将不会被限制于本文所示的这些实施例，而是要符合与本文所公开的原理和新颖特点相一致的最宽的范围。The above description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the invention. Therefore, the present invention will not be limited to the embodiments shown herein, but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (8)
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611123126.3A CN106777025B (en) | 2016-12-08 | 2016-12-08 | A method and system for analyzing physical model of database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611123126.3A CN106777025B (en) | 2016-12-08 | 2016-12-08 | A method and system for analyzing physical model of database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106777025A true CN106777025A (en) | 2017-05-31 |
| CN106777025B CN106777025B (en) | 2020-10-27 |
Family
ID=58877391
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611123126.3A Active CN106777025B (en) | 2016-12-08 | 2016-12-08 | A method and system for analyzing physical model of database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106777025B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109165669A (en) * | 2018-07-09 | 2019-01-08 | 浙江大学 | Three-dimensional dough sheet model file similarity detection method based on model identification code |
| CN109325035A (en) * | 2018-11-29 | 2019-02-12 | 阿里巴巴集团控股有限公司 | The recognition methods of similar table and device |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040236758A1 (en) * | 2003-05-22 | 2004-11-25 | Medicke John A. | Methods, systems and computer program products for web services access of analytical models |
| CN101183361A (en) * | 2006-11-13 | 2008-05-21 | 中兴通讯股份有限公司 | Method of relation data base applications automatic upgrade |
| CN102065413A (en) * | 2010-11-17 | 2011-05-18 | 北京北方烽火科技有限公司 | Database updating method and system, and base station self-starting method and system |
| CN102411588A (en) * | 2010-09-26 | 2012-04-11 | 金蝶软件（中国）有限公司 | Comparison and inspection method and system for data table |
| CN102609777A (en) * | 2012-02-17 | 2012-07-25 | 中国科学院合肥物质科学研究院 | Method for controlling emergency decision knowledge base system for disaster reduction |
| CN102890720A (en) * | 2012-10-16 | 2013-01-23 | 南京通达海信息技术有限公司 | Database inspection and maintenance method |
| CN102982168A (en) * | 2012-12-12 | 2013-03-20 | 江苏省电力公司信息通信分公司 | Metadata schema matching method based on XML (extensive markup language) document |
| US8762428B2 (en) * | 2011-06-06 | 2014-06-24 | International Business Machines Corporation | Rapidly deploying virtual database applications using data model analysis |
| CN104216948A (en) * | 2014-08-12 | 2014-12-17 | 上海新炬网络技术有限公司 | Difference control method of data model |
| CN104598610A (en) * | 2015-01-29 | 2015-05-06 | 无锡江南计算技术研究所 | Step-by-step database data distribution uploading and synchronizing method |
| CN105786998A (en) * | 2016-02-19 | 2016-07-20 | 创元网络技术股份有限公司 | Database middleware system and method for processing data through database middleware system |
-
2016
- 2016-12-08 CN CN201611123126.3A patent/CN106777025B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040236758A1 (en) * | 2003-05-22 | 2004-11-25 | Medicke John A. | Methods, systems and computer program products for web services access of analytical models |
| CN101183361A (en) * | 2006-11-13 | 2008-05-21 | 中兴通讯股份有限公司 | Method of relation data base applications automatic upgrade |
| CN102411588A (en) * | 2010-09-26 | 2012-04-11 | 金蝶软件（中国）有限公司 | Comparison and inspection method and system for data table |
| CN102065413A (en) * | 2010-11-17 | 2011-05-18 | 北京北方烽火科技有限公司 | Database updating method and system, and base station self-starting method and system |
| US8762428B2 (en) * | 2011-06-06 | 2014-06-24 | International Business Machines Corporation | Rapidly deploying virtual database applications using data model analysis |
| CN102609777A (en) * | 2012-02-17 | 2012-07-25 | 中国科学院合肥物质科学研究院 | Method for controlling emergency decision knowledge base system for disaster reduction |
| CN102890720A (en) * | 2012-10-16 | 2013-01-23 | 南京通达海信息技术有限公司 | Database inspection and maintenance method |
| CN102982168A (en) * | 2012-12-12 | 2013-03-20 | 江苏省电力公司信息通信分公司 | Metadata schema matching method based on XML (extensive markup language) document |
| CN104216948A (en) * | 2014-08-12 | 2014-12-17 | 上海新炬网络技术有限公司 | Difference control method of data model |
| CN104598610A (en) * | 2015-01-29 | 2015-05-06 | 无锡江南计算技术研究所 | Step-by-step database data distribution uploading and synchronizing method |
| CN105786998A (en) * | 2016-02-19 | 2016-07-20 | 创元网络技术股份有限公司 | Database middleware system and method for processing data through database middleware system |
Non-Patent Citations (3)
| Title |
|---|
| WARAPORN等: "A System for Detecting XML Similarity in Content and Structure Using Relational Database", 《PROCEEDINGS OF THE 18TH ACM CONFERENCE ON INFORMATION AND KNOWLEDGE MANAGEMENT》 * |
| 叶鸥: "XML与模式匹配技术及其应用研究", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
| 战颖: "多数据库系统数据仓库集成技术应用研究", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109165669A (en) * | 2018-07-09 | 2019-01-08 | 浙江大学 | Three-dimensional dough sheet model file similarity detection method based on model identification code |
| CN109325035A (en) * | 2018-11-29 | 2019-02-12 | 阿里巴巴集团控股有限公司 | The recognition methods of similar table and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106777025B (en) | 2020-10-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111694858B (en) | Data lineage analysis method, device, equipment and computer-readable storage medium | |
| CN103886098B (en) | Word document format checking method | |
| CN106919612B (en) | A method and device for processing an online structured query language script | |
| CN102289407B (en) | Method for automatically testing document format conversion | |
| CN105930523A (en) | Dynamic configurable rule-based data cleaning framework under big data background | |
| CN107341209B (en) | BIM model specification detection device and detection method based on semantic retrieval | |
| CN110737689B (en) | Data standard compliance detection method, device, system and storage medium | |
| US10002142B2 (en) | Method and apparatus for generating schema of non-relational database | |
| CN101872350A (en) | Web page text extraction method and device | |
| CN105868171A (en) | Checking method and device of Excel file | |
| CN101859303A (en) | Metadata management method and management system | |
| CN107783780B (en) | Code review method and system | |
| CN106980619B (en) | Data query method and device | |
| CN103477321B (en) | Creating benchmark graph data | |
| CN104391852A (en) | Method and device for establishing keyword word bank | |
| CN106777025B (en) | A method and system for analyzing physical model of database | |
| US10402484B2 (en) | Aligning annotation of fields of documents | |
| CN109408502A (en) | A kind of data standard processing method, device and its storage medium | |
| CN103440197B (en) | A kind of method automatically generating difference test report based on contrast test | |
| CN107203525B (en) | Database processing method and device | |
| CN108519963A (en) | A Method for Automatically Converting Process Models into Multilingual Texts | |
| CN103678327B (en) | Method and device for information association | |
| CN113360603A (en) | Contract similarity and compliance detection method and device | |
| CN104361121B (en) | A kind of batch analytic method of WEB reporting systems formula | |
| CN103761312B (en) | Information extraction system and method for multi-recording webpage |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 100192 Beijing city Haidian District Qinghe small Camp Road No. 15 building 710 room research Applicant after: BEIJING CHINA POWER INFORMATION TECHNOLOGY Co.,Ltd. Applicant after: STATE GRID INFORMATION & TELECOMMUNICATION GROUP Co.,Ltd. Applicant after: STATE GRID CORPORATION OF CHINA Address before: 100192 Beijing city Haidian District Qinghe small Camp Road No. 15 building 710 room research Applicant before: BEIJING CHINA POWER INFORMATION TECHNOLOGY Co.,Ltd. Applicant before: STATE GRID INFORMATION & TELECOMMUNICATION GROUP Co.,Ltd. Applicant before: State Grid Corporation of China |
|
| CB02 | Change of applicant information | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20190725 Address after: 100085 Building 32-3-4108-4109, Pioneer Road, Haidian District, Beijing Applicant after: BEIJING GUODIANTONG NETWORK TECHNOLOGY Co.,Ltd. Applicant after: STATE GRID CORPORATION OF CHINA Applicant after: STATE GRID INFORMATION & TELECOMMUNICATION GROUP Co.,Ltd. Address before: 100192 Beijing city Haidian District Qinghe small Camp Road No. 15 building 710 room research Applicant before: BEIJING CHINA POWER INFORMATION TECHNOLOGY Co.,Ltd. Applicant before: STATE GRID INFORMATION & TELECOMMUNICATION GROUP Co.,Ltd. Applicant before: STATE GRID CORPORATION OF CHINA |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |