Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Metadata management method and system based on templates

A management method and metadata technology, applied in the field of template-based metadata management methods and systems, can solve problems such as low query efficiency, and achieve the effects of accurate and effective data table formatting, quick sorting, and improved flexibility

Active Publication Date: 2018-06-15
山东合天智汇信息技术有限公司
View PDF7 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In addition, when performing statistical work on data tables, sometimes it is necessary to extract all specific fields in multiple related data tables. "Information records, in order to query accurately, you can construct a query statement. For example, if we want to query the field of the person's name, we can code the name of the person, the name of the guardian, the name of the guardian, and the name of the spouse in the table one by one. Query statement, if you want to search data from the query conditions of names in multiple information tables, you need to write multiple sets of codes, and the query efficiency is low

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Metadata management method and system based on templates

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0059] This embodiment discloses a template-based metadata management method, including the following steps:

[0060] Step 1: Create a form template based on historical form data;

[0061] The form template includes the category of the template (related to specific fields, such as student information, financial information, household registration information, etc.), specific objects of the template (ie, specific field names), and the format of each specific object.

[0062] Step 2: establish a database dictionary, including the corresponding relationship between the abstract object and the concrete object;

[0063] The database dictionary includes abstract objects and concrete objects corresponding to these abstract objects, and the database dictionary supports manual expansion by users.

[0064] Step 3: Receive the form file and select a template according to the content of the form;

[0065] Specifically include:

[0066] Step 3.1: Receive the form file, analyze the content...

Embodiment 2

[0085] The purpose of this embodiment is to provide a template-based metadata management system.

[0086] A template-based metadata management system includes a memory and a processor, the memory stores form templates, database dictionaries, metadata management databases and computer programs that can run on the processor, and the processor executes the The following steps are implemented in the program:

[0087] Receive the form file and select a template according to the content of the form;

[0088] Read the specific objects of the table file, and match each specific object with the abstract object based on the database dictionary;

[0089] After the matching is successful, the form file is stored according to the format defined by the template.

[0090] Preferably, the form template includes the category of the template (related to specific fields, such as student information, financial information, household registration information, etc.), the specific objects of the t...

Embodiment 3

[0099] The purpose of this embodiment is to provide a computer-readable storage medium.

[0100] A computer-readable storage medium, on which a computer program is stored, and when the program is executed by a processor, the following steps are performed:

[0101] Receive the form file and select a template according to the content of the form;

[0102] Read the specific objects of the table file, and match each specific object with the abstract object based on the database dictionary;

[0103] After the matching is successful, the form file is stored according to the format defined by the template.

[0104] Preferably, the form template includes the category of the template (related to specific fields, such as student information, financial information, household registration information, etc.), the specific objects of the template (that is, specific field names) and the format of each specific object, etc. .

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a metadata management method and system based on templates. The method comprises the steps that table templates are created according to historical table data, wherein the table templates comprise concrete objects and formats thereof; a database dictionary is established, wherein the database dictionary comprises a corresponding relation between abstract objects and the concrete objects; a table file is received, and a template is selected according to table content; concrete objects in the table file are read, and matching is performed on each concrete object and the corresponding abstract object based on the database dictionary; and after matching succeeds, the table file is stored according to the format defined by the selected template. Through the metadata management method and system, association among the concrete objects, the templates and the abstract objects is established, and quick formatting of tables and cross-table condition query are realized.

Description

technical field [0001] The invention belongs to the field of data management and query statistics, in particular to a template-based metadata management method and system. Background technique [0002] With the development of informatization, more and more industries have entered the era of big data, and big data mining has become a new development point in the information field, accompanied by more and more table structures and increased storage capacity. In this process, we can find that some information elements express the same meaning, such as name, which expresses the same meaning in a person's basic information, passport information or driver's license information and is also named in the design The XM element, and another example of "motor vehicle owner", is named JDCSYR in motor vehicle registration information and traffic violation information, and so on. Moreover, different related data tables may also contain fields with similar meanings, such as a city populati...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/38
Inventor 傅珂段文良王可鑫
Owner 山东合天智汇信息技术有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com