CN108959439B - Data template generation method and system - Google Patents
Data template generation method and system Download PDFInfo
- Publication number
- CN108959439B CN108959439B CN201810606393.9A CN201810606393A CN108959439B CN 108959439 B CN108959439 B CN 108959439B CN 201810606393 A CN201810606393 A CN 201810606393A CN 108959439 B CN108959439 B CN 108959439B
- Authority
- CN
- China
- Prior art keywords
- data
- attribute
- common
- attributes
- attribute table
- 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.)
- Expired - Fee Related
Links
- 238000000034 method Methods 0.000 title claims abstract description 32
- 238000010586 diagram Methods 0.000 description 4
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000004883 computer application Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method and a system for generating a data template, wherein the method comprises the following steps: acquiring a common attribute table from a database; determining attributes corresponding to all engineering projects; selecting data attributes corresponding to the engineering projects from a data attribute table of the database according to the attributes corresponding to the engineering projects; constructing a data template attribute table according to the data attributes corresponding to the engineering projects; grouping attributes corresponding to the engineering projects to obtain a first data attribute grouping table; adding a release channel field in the first data attribute grouping table to obtain a second data attribute grouping table; and determining the data template of each engineering project according to the common attribute table, the data template attribute table and the second data attribute grouping table. The invention determines the data template of each engineering project according to the requirements of the engineering projects, not only improves the use flexibility, but also realizes one-time editing and multi-channel release based on channel field design.
Description
Technical Field
The invention relates to the technical field of databases, in particular to a data template generation method and a data template generation system.
Background
In the field of computer application, different types of data are stored in different data templates, and then different data templates are stored in a database, so that the database is used for storing a large amount of business data. However, the conventionally defined data templates have the following disadvantages: 1. the existing data template cannot select corresponding attributes according to engineering project requirements, lacks flexibility, cannot include all data, and causes the collecting and editing personnel to be involved in the process of selecting the type A or the type B during the input, thereby undoubtedly increasing the burden of the collecting and editing personnel, and simultaneously, the data presentation is not scientific and reasonable enough. 2. The granularity of data attribute parameters in the existing data template is relatively coarse and is mostly shown in a rich text form, and the method can cause that the data can not tightly meet the requirements of users when being searched and shown in the foreground, so that the search result can not achieve the expected purpose. As for the former consultation and transfer specifications, the data is submitted in a rich text form or a form during uploading, and the data uploading mode is not beneficial to searching and classifying the data and is also not beneficial to the use of internal customer service personnel; 3. the existing data template has two different visual angles for internet users and internal users (namely customer service personnel), and data is recorded twice, so that the workload of data acquisition and compilation is greatly increased; furthermore, the collecting and editing personnel can be responsible for various channels such as a network hall, a short message business hall and the like in the future. If the data is re-recorded in every new channel in the future, the workload of the editing personnel is increased by geometric times and is repeated.
Disclosure of Invention
The invention aims to provide a data template generation method and a data template generation system, so as to generate a corresponding data template according to engineering project requirements and improve the use flexibility.
In order to achieve the above object, the present invention provides a data template generating method, where the database generating method includes:
acquiring a common attribute table from a database;
determining attributes corresponding to all engineering projects;
selecting data attributes corresponding to the engineering projects from a data attribute table of the database according to the attributes corresponding to the engineering projects;
constructing a data template attribute table according to the data attributes corresponding to the engineering projects;
grouping attributes corresponding to the engineering projects to obtain a first data attribute grouping table;
adding a release channel field in the first data attribute grouping table to obtain a second data attribute grouping table;
and determining the data template of each engineering project according to the common attribute table, the data template attribute table and the second data attribute grouping table.
Optionally, after the step of determining the data template of each engineering project according to the common attribute table, the data template attribute table, and the second data attribute grouping table, the method further includes:
and importing the data template of each engineering project into the database, and simultaneously displaying the data template of each engineering project on a plurality of clients.
Optionally, before the step of selecting the data attribute corresponding to each engineering project from the data attribute table of the database according to the attribute corresponding to each engineering project, the method further includes:
and adding a version number field into the common attribute table.
Optionally, before the step of obtaining the common attribute table from the database, the method further includes:
determining a common attribute table of the data; the common attribute table is used for storing tables of common attributes;
determining a data attribute table corresponding to the data; the data attribute table is used for storing a table of data attributes, and the data attributes are non-common attributes;
and storing the common attribute table and the data attribute table in a database.
Optionally, the data attribute includes a numerical value attribute, a text attribute, a date attribute, a plurality of relationship attributes, a short message attribute, an attachment attribute, and a region attribute.
The present invention also provides a database generation system, which includes:
the acquisition module is used for acquiring a common attribute table from a database;
the engineering project attribute determining module is used for determining attributes corresponding to all engineering projects;
the selection module is used for selecting the data attribute corresponding to each project from the data attribute table of the database according to the attribute corresponding to each project;
the data template attribute table building module is used for building a data template attribute table according to the data attributes corresponding to the engineering projects;
the grouping module is used for grouping the attributes corresponding to the engineering projects to obtain a first data attribute grouping table;
the first joining module is used for joining the field of the distribution channel in the first data attribute grouping table to obtain a second data attribute grouping table;
and the data template generating module is used for determining the data templates of the engineering projects according to the common attribute table, the data template attribute table and the second data attribute grouping table.
Optionally, the database generation system further includes:
and the importing and displaying module is used for importing the data template of each engineering project into the database and displaying the data template of each engineering project on a plurality of clients simultaneously.
Optionally, the database generation system further includes:
and the second adding module is used for adding the version number field into the common attribute table.
Optionally, the database generation system further includes: the method specifically comprises the following steps:
the common attribute table determining module is used for determining a common attribute table of the data; the common attribute table is used for storing tables of common attributes;
the data attribute table determining module is used for determining a data attribute table corresponding to the data; the data attribute table is used for storing a table of data attributes, and the data attributes are non-common attributes;
and the database storage module is used for storing the common attribute table and the data attribute table into a database.
Optionally, the client includes a web page end, a micro web page end, and a wechat robot.
According to the specific embodiment provided by the invention, the invention discloses the following technical effects:
the invention determines the corresponding common attribute list, the data template attribute list and the second data attribute grouping list according to the engineering project requirements, and finally determines the data template of each engineering project according to the common attribute list, the data template attribute list and the second data attribute grouping list, thereby not only improving the use flexibility, but also realizing one-time editing and multi-channel distribution based on channel field design.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings needed to be used in the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings without inventive exercise.
FIG. 1 is a flow chart of a data template generation method according to an embodiment of the present invention;
FIG. 2 is a diagram illustrating a data attribute composition structure according to an embodiment of the present invention;
fig. 3 is a diagram of a data template generating system according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The invention aims to provide a data template generation method and a data template generation system, so as to generate a corresponding data template according to engineering project requirements and improve the use flexibility.
In order to make the aforementioned objects, features and advantages of the present invention comprehensible, embodiments accompanied with figures are described in further detail below.
FIG. 1 is a flow chart of a data template generation method according to an embodiment of the present invention; as shown in fig. 1, the present invention provides a data template generating method, where the database generating method includes:
step S1: acquiring a common attribute table from a database;
step S2: determining attributes corresponding to all engineering projects;
step S3: selecting data attributes corresponding to the engineering projects from a data attribute table of the database according to the attributes corresponding to the engineering projects;
step S4: constructing a data template attribute table according to the data attributes corresponding to the engineering projects;
step S5: grouping attributes corresponding to the engineering projects to obtain a first data attribute grouping table;
step S6: adding a release channel field in the first data attribute grouping table to obtain a second data attribute grouping table;
step S7: and determining the data template of each engineering project according to the common attribute table, the data template attribute table and the second data attribute grouping table.
The following is explained in detail:
before step S1, the present invention further includes:
step S8: determining a common attribute table of the data; the common attribute table is used for storing a table of common attributes.
The common attributes of the invention include common attributes of any knowledge, such as knowledge title, knowledge validity period, creator, etc., and can be understood as lean-version knowledge. Relatively speaking, subsequent data attributes refer to variable, customizable attributes.
Step S9: determining a data attribute table corresponding to the data; the data attribute table is used for storing a table of data attributes, and the data attributes are non-common attributes;
FIG. 2 is a diagram illustrating a data attribute composition structure according to an embodiment of the present invention; as shown in fig. 2, the data attribute includes a numerical attribute, a text attribute, a date attribute, a plurality of relationship attributes, a short message attribute, an attachment attribute, and a region attribute.
The relationship attribute is as follows: the stored data ID and the ID of the associated data are associated; short message attribute: the method is a special case of text type, and short message text contents aiming at the telecommunication industry are stored in the special case; the accessory attribute: indicating that the attribute is stored within the URL of the data attachment (the page appears as a hyperlink); region attribute: indicating that the data has different attribute values in different markets.
Step S10: and storing the common attribute table and the data attribute table in a database.
Before step S3, the present invention further includes:
step S11: and adding a version number field into the common attribute table.
After step S7, the present invention further includes:
step S12: and importing the data template of each engineering project into the database, and simultaneously displaying the data template of each engineering project on a plurality of clients.
FIG. 3 is a block diagram of a data template generation system according to an embodiment of the present invention; as shown in fig. 3, the present invention further provides a database generation system, which includes:
the acquisition module 1 is used for acquiring a common attribute table from a database;
the project attribute determining module 2 is used for determining attributes corresponding to all project;
the selection module 3 is used for selecting the data attribute corresponding to each project from the data attribute table of the database according to the attribute corresponding to each project;
the data template attribute table building module 4 is used for building a data template attribute table according to the data attributes corresponding to the engineering projects;
the grouping module 5 is used for grouping the attributes corresponding to the engineering projects to obtain a first data attribute grouping table;
the first joining module 6 is used for joining the publishing channel field in the first data attribute grouping table to obtain a second data attribute grouping table;
and the data template generating module 7 is used for determining the data templates of the engineering projects according to the common attribute table, the data template attribute table and the second data attribute grouping table.
The database generation system of the present invention further comprises: the method specifically comprises the following steps:
a common attribute table determining module 8, configured to determine a common attribute table of data; the common attribute table is used for storing tables of common attributes;
a data attribute table determining module 9, configured to determine a data attribute table corresponding to the data; the data attribute table is used for storing a table of data attributes, and the data attributes are non-common attributes;
and a database storage module 10, configured to store the common attribute table and the data attribute table in a database.
The database generation system of the present invention further comprises:
and a second adding module 11, configured to add a version number field in the common attribute table.
The database generation system of the present invention further comprises:
an importing and displaying module 12, configured to import the data template of each engineering project into the database, and display the data template of each engineering project on multiple clients at the same time; the client comprises a webpage end, a micro webpage end and a micro communication robot.
The invention creates the region attribute in the data attribute table, so that the user can fill different values aiming at the same attribute of different regions suitable for the engineering project, and the other common attribute values are not required to be filled repeatedly. That is to say, when the user logs in with the local city identity, the data attribute that the user needs to modify is the local attribute, and the efficiency of knowledge compilation is further improved.
The invention can store a plurality of versions of the same knowledge in the database by adding the version number field to the common attribute table, accurately realize the difference comparison function of different versions of the knowledge and support the realization of the version management function of the knowledge base system.
According to the invention, the corresponding common attribute table, the data template attribute table and the second data attribute grouping table are determined according to the engineering project requirements, and the data template of each engineering project is determined according to the common attribute table, the data template attribute table and the second data attribute grouping table, so that the use flexibility is improved, and the data templates of each engineering project are also determined based on channel field design, so that one-time editing and multi-channel publishing of a webpage end, a micro-grid page end, a micro-communication robot and the like are realized, the common work of newly building knowledge in each channel is avoided, and the work intensity of knowledge collecting and editing personnel is effectively reduced.
For the system disclosed by the embodiment, the description is relatively simple because the system corresponds to the method disclosed by the embodiment, and the relevant points can be referred to the method part for description.
The principles and embodiments of the present invention have been described herein using specific examples, which are provided only to help understand the method and the core concept of the present invention; meanwhile, for a person skilled in the art, according to the idea of the present invention, the specific embodiments and the application range may be changed. In view of the above, the present disclosure should not be construed as limiting the invention.
Claims (9)
1. A data template generation method, characterized in that the data template generation method comprises:
acquiring a common attribute table from a database;
determining attributes corresponding to all engineering projects;
selecting data attributes corresponding to the engineering projects from a data attribute table of the database according to the attributes corresponding to the engineering projects; the data attribute comprises a numerical value attribute, a text attribute, a date attribute, a plurality of relation attributes, a short message attribute, an attachment attribute and a region attribute;
constructing a data template attribute table according to the data attributes corresponding to the engineering projects;
grouping attributes corresponding to the engineering projects to obtain a first data attribute grouping table;
adding a release channel field in the first data attribute grouping table to obtain a second data attribute grouping table;
and determining the data template of each engineering project according to the common attribute table, the data template attribute table and the second data attribute grouping table.
2. The method of claim 1, wherein after the step of determining the data templates for each project according to the common attribute table, the data template attribute table, and the second data attribute group table, the method further comprises:
and importing the data template of each engineering project into the database, and simultaneously displaying the data template of each engineering project on a plurality of clients.
3. The data template generating method according to claim 1, wherein before the step of selecting the data attribute corresponding to each project item from the data attribute table of the database according to the attribute corresponding to each project item, the method further comprises:
and adding a version number field into the common attribute table.
4. The method of generating a data template according to claim 1, further comprising, before the step of obtaining a common attribute table from a database:
determining a common attribute table of the data; the common attribute table is used for storing tables of common attributes;
determining a data attribute table corresponding to the data; the data attribute table is used for storing a table of data attributes, and the data attributes are non-common attributes;
and storing the common attribute table and the data attribute table in a database.
5. A data template generation system, characterized in that the data template generation system comprises:
the acquisition module is used for acquiring a common attribute table from a database;
the engineering project attribute determining module is used for determining attributes corresponding to all engineering projects;
the selection module is used for selecting the data attribute corresponding to each project from the data attribute table of the database according to the attribute corresponding to each project; the data attribute comprises a numerical value attribute, a text attribute, a date attribute, a plurality of relation attributes, a short message attribute, an attachment attribute and a region attribute;
the data template attribute table building module is used for building a data template attribute table according to the data attributes corresponding to the engineering projects;
the grouping module is used for grouping the attributes corresponding to the engineering projects to obtain a first data attribute grouping table;
the first joining module is used for joining the field of the distribution channel in the first data attribute grouping table to obtain a second data attribute grouping table;
and the data template generating module is used for determining the data templates of the engineering projects according to the common attribute table, the data template attribute table and the second data attribute grouping table.
6. The data template generation system of claim 5, wherein the database generation system further comprises:
and the importing and displaying module is used for importing the data template of each engineering project into the database and displaying the data template of each engineering project on a plurality of clients simultaneously.
7. The data template generation system of claim 5, wherein the database generation system further comprises:
and the second adding module is used for adding the version number field into the common attribute table.
8. The data template generation system of claim 5, wherein the database generation system further comprises: the method specifically comprises the following steps:
the common attribute table determining module is used for determining a common attribute table of the data; the common attribute table is used for storing tables of common attributes;
the data attribute table determining module is used for determining a data attribute table corresponding to the data; the data attribute table is used for storing a table of data attributes, and the data attributes are non-common attributes;
and the database storage module is used for storing the common attribute table and the data attribute table into a database.
9. The data template generation system of claim 6, wherein the client comprises a web page client, a WeChat robot.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810606393.9A CN108959439B (en) | 2018-06-13 | 2018-06-13 | Data template generation method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810606393.9A CN108959439B (en) | 2018-06-13 | 2018-06-13 | Data template generation method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108959439A CN108959439A (en) | 2018-12-07 |
| CN108959439B true CN108959439B (en) | 2020-08-25 |
Family
ID=64488836
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810606393.9A Expired - Fee Related CN108959439B (en) | 2018-06-13 | 2018-06-13 | Data template generation method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108959439B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110555201B (en) * | 2019-09-11 | 2023-04-28 | 中国联合网络通信集团有限公司 | Knowledge document generation method, device, electronic equipment and storage medium |
| CN110990581B (en) * | 2019-11-20 | 2023-03-14 | 神思电子技术股份有限公司 | Dynamic data acquisition and editing method for knowledge base construction |
| CN112511493B (en) * | 2020-10-30 | 2022-10-11 | 深圳市金蝶天燕云计算股份有限公司 | Service data message processing method and device, computer equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101702219A (en) * | 2009-12-08 | 2010-05-05 | 金蝶软件（中国）有限公司 | Method for generating material information and device thereof |
| CN103414753A (en) * | 2013-07-17 | 2013-11-27 | 广州从兴电子开发有限公司 | Unified publish method of information of a plurality of channels |
| CN106126221A (en) * | 2016-06-21 | 2016-11-16 | 浪潮电子信息产业股份有限公司 | A kind of list generates methods, devices and systems |
| US9779150B1 (en) * | 2014-08-15 | 2017-10-03 | Tableau Software, Inc. | Systems and methods for filtering data used in data visualizations that use relationships |
| CN107886439A (en) * | 2017-12-21 | 2018-04-06 | 中国平安财产保险股份有限公司 | Insurance products development approach, device, equipment and computer-readable recording medium |
-
2018
- 2018-06-13 CN CN201810606393.9A patent/CN108959439B/en not_active Expired - Fee Related
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101702219A (en) * | 2009-12-08 | 2010-05-05 | 金蝶软件（中国）有限公司 | Method for generating material information and device thereof |
| CN103414753A (en) * | 2013-07-17 | 2013-11-27 | 广州从兴电子开发有限公司 | Unified publish method of information of a plurality of channels |
| US9779150B1 (en) * | 2014-08-15 | 2017-10-03 | Tableau Software, Inc. | Systems and methods for filtering data used in data visualizations that use relationships |
| CN106126221A (en) * | 2016-06-21 | 2016-11-16 | 浪潮电子信息产业股份有限公司 | A kind of list generates methods, devices and systems |
| CN107886439A (en) * | 2017-12-21 | 2018-04-06 | 中国平安财产保险股份有限公司 | Insurance products development approach, device, equipment and computer-readable recording medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108959439A (en) | 2018-12-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109582909B (en) | Webpage automatic generation method and device, electronic equipment and storage medium | |
| CN108959439B (en) | Data template generation method and system | |
| TW201741906A (en) | Page resource delivery method and apparatus | |
| CN103020158A (en) | Report form creation method, device and system | |
| CN104035754A (en) | XML (Extensible Markup Language)-based custom code generation method and generator | |
| CN106407371A (en) | User comment data displaying method and system, server and client | |
| WO2021032146A1 (en) | Metadata management method and apparatus, device, and storage medium | |
| CN107748752B (en) | Data processing method and device | |
| CN104899186A (en) | Form generating and obtaining method and device | |
| CN104270654B (en) | Internet video plays monitoring method and device | |
| CN105447723A (en) | Promotion system and promotion method | |
| CN110705231A (en) | Webpage editing method and device | |
| CN112396462B (en) | Crowd circling method and device based on click house | |
| CN109359141A (en) | A kind of Visual Report Forms method for exhibiting data and device | |
| CN111414410A (en) | Data processing method, device, equipment and storage medium | |
| CN113742325A (en) | Data warehouse construction method, device and system, electronic equipment and storage medium | |
| CN107436785B (en) | Revit software information interaction system and interaction method based on information system | |
| CN108572817B (en) | Method, apparatus and medium for dynamic resource configuration based on business modeling | |
| US20200073925A1 (en) | Method and system for generating a website from collected content | |
| CN111046640A (en) | Dynamic generation method and device of certification document | |
| CN105912723A (en) | Storage method of custom field | |
| CN111401023B (en) | Report generation method, report generation device, server and storage medium | |
| CN109739504B (en) | Method for automatically generating H5 service handling page according to background configuration | |
| CN114860851A (en) | Data processing method, device, equipment and storage medium | |
| CN113128184A (en) | Document content screening method and device for multi-person collaborative editing document |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20200825 |