[go: up one dir, main page]

CN109684329A - A kind of method for managing resource based on data center apparatus - Google Patents

A kind of method for managing resource based on data center apparatus Download PDF

Info

Publication number
CN109684329A
CN109684329A CN201811528151.9A CN201811528151A CN109684329A CN 109684329 A CN109684329 A CN 109684329A CN 201811528151 A CN201811528151 A CN 201811528151A CN 109684329 A CN109684329 A CN 109684329A
Authority
CN
China
Prior art keywords
resource
dynamic
design
field
definition
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
CN201811528151.9A
Other languages
Chinese (zh)
Other versions
CN109684329B (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.)
Gosuncn Technology Group Co Ltd
Original Assignee
Gosuncn Technology Group 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 Gosuncn Technology Group Co Ltd filed Critical Gosuncn Technology Group Co Ltd
Priority to CN201811528151.9A priority Critical patent/CN109684329B/en
Publication of CN109684329A publication Critical patent/CN109684329A/en
Application granted granted Critical
Publication of CN109684329B publication Critical patent/CN109684329B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Stored Programmes (AREA)

Abstract

The invention belongs to resource management techniques fields, more particularly to a kind of method for managing resource based on data center apparatus, according to MySQL dynamic list, dynamic list database table definition design, the design of dynamic list database table field definition and the extension contingency table definition design of dynamic list database are carried out, realizes the dynamic configuration of dynamic list attribute and relationship;Dynamic list visual configuration can be realized by integrating Spring+Freemarker by Java technology, support typing table, literary name section, table type in dynamic list, and dynamic creation table, product reuse is high, meets the needs of users variation.

Description

A kind of method for managing resource based on data center apparatus
Technical field
The invention belongs to resource management techniques fields, and in particular to a kind of resource management side based on data center apparatus Method.
Background technique
Existing resource administrative skill mainly includes MySQL database technology and Java object oriented language technology.MySQL number Be a Relational DBMS according to library, model object converted for real-world object based on scene demand, by data with The mode of particular structured is stored in different tables, supports the data warehouse of large database and 50,000,000 records, due to Open source is free, cross-platform and be in industry widely used using the advantages of stsndard SQL data language form.The technology uses MySQL is designed table structure, realizes complex relationship storage.The technology is mainly used in the business field of data center's operation management Scape needs to safeguard the data of data center's various kinds of equipment, and is sorted out by device space physical location, device type, different Equipment have different attributes, but the dynamic attribute of same type of equipment is common.According to these business characteristics, need Dynamic attribute storage, the showing problem that equipment is solved by the means of database technology, are now resource object by device definition, build Vertical E-R figure relation table is as shown in Figure 1.As can be known from Fig. 1: 1. with resource object table for main table T1, the general category of design resource Property field;2. designing external key of the Resource Architecture ID as Resource Architecture table T2 in T1 table, n is defined as to 1 corresponding relationship, n is Positive integer greater than 1;3. designing external key of the resource type ID as resource type table T3 in T1 table, n is defined as to 1 corresponding pass System, n are the positive integer greater than 1;4. establishing resource object expansion table T4, according to business demand, not for each type definition With attribute field, external key of the resource type ID as resource type table T3 is designed in T4 table, is defined as n to 1 corresponding relationship, N is the positive integer greater than 1.In summary, the key point of program design is bolded section in figure, presses on the basis of main table Resource type establishes corresponding expansion table and carries out data maintenance.
Java object oriented language technology is an Object-Oriented Programming Language, has simplicity, object-oriented, distribution Formula, robustness, safety, platform it is independent with portability, multithreading, dynamic the features such as, can write multipad, WEB application program, distributed system and embedded system application program etc..This technology uses Spring as basic frame, and Freemarker is integrated as the Page Template engine implementation dynamic list page.
Disadvantage is using prior art MySQL database designing technique, in the early stage of the project or device type data volume Lesser situation is applicable in, but as the type of device type increases, it is meant that each device type needs to increase corresponding expansion Table is opened up, and these Table Properties cannot go to be adapted to changes in demand, there are certain maintenance costs.
Summary of the invention
The purpose of the present invention is to propose to a kind of method for managing resource based on data center apparatus, to solve existing MySQL Table Properties cannot go to be adapted to changes in demand in database design technique, the higher technical problem of maintenance cost.
The invention is realized by the following technical scheme:
A kind of method for managing resource based on data center apparatus carries out dynamic list data according to MySQL dynamic list Library table definition design, the design of dynamic list database table field definition and the extension contingency table definition of dynamic list database are set Meter realizes the dynamic configuration of dynamic list attribute and relationship.
Further, the method specifically includes the following steps:
1) with resource object table for main table T1, the general attribute field of design resource;
2) external key of the Resource Architecture ID as Resource Architecture table T2 is designed in T1 table, is defined as n to 1 corresponding relationship, n is Positive integer greater than 1;
3) external key of the resource type ID as resource type table T3 is designed in T1 table, is defined as n to 1 corresponding relationship, n is Positive integer greater than 1.
Further, it is further comprised the steps of: after the step 3)
4) it establishes dynamic data base table and defines T4, storage table structure definition, table structure definition includes that database builds table knot The table name of structure;
5) it establishes dynamic data base literary name section and defines T5, the definition of storage table texture field, which includes Database builds the field name of table structure, and designs external key of the table name field as T4 table, is defined as n to 1 corresponding relationship;
6) the dynamic generation resource expansion table T6 based on step 4) and 5);
7) resource expansion contingency table T7 is designed, design resource type id field is associated with T3 table, and design data table id is associated with T4 Table forms 1 pair 1 of relationship;
8) resource table dynamic attribute maintenance: T1 table → T7 table → T4 table → T6 table is realized.
Further, dynamic generation resource expansion table T6 in the step 6), specifically: step 4) and 5) utilize Java phase Pass technology Spring+Freemarker frame can realize visualization list configuration, after list typing T4, T5 table data, pass through Table handling, dynamic generation resource expansion table T6 are built in backstage code execution data library.
Further, the maintenance of resource table dynamic attribute is realized in the step 8), is specifically comprised the following steps:
A) resource type id field is taken out from T1 table, the database table for searching T7 table defines ID;
B) database table is taken out from T7 table and define id field, search the table name of T4 table;
C) the expansion table T6 of practical dynamic generation is directly inquired by above-mentioned table name.
The invention also includes a kind of computer based system, which includes:
Processor;
Nonvolatile memory is configured for being communicated with the processor, and the nonvolatile memory has The instruction being stored thereon, described instruction make the processor execute following operation in response to being executed by the processor: MySQL dynamic list carries out dynamic list database table definition design, the design of dynamic list database table field definition and moves State form database extends contingency table definition design, realizes the dynamic configuration of dynamic list attribute and relationship.
Further, steps are as follows for the processing implement body execution:
1) with resource object table for main table T1, the general attribute field of design resource;
2) external key of the Resource Architecture ID as Resource Architecture table T2 is designed in T1 table, is defined as n to 1 corresponding relationship, n is Positive integer greater than 1;
3) external key of the resource type ID as resource type table T3 is designed in T1 table, is defined as n to 1 corresponding relationship, n is Positive integer greater than 1.
Further, it is further comprised the steps of: after executing the step 3)
4) it establishes dynamic data base table and defines T4, storage table structure definition, table structure definition includes that database builds table knot The table name of structure;
5) it establishes dynamic data base literary name section and defines T5, the definition of storage table texture field, which includes Database builds the field name of table structure, and designs external key of the table name field as T4 table, is defined as n to 1 corresponding relationship, n For the positive integer greater than 1;
6) the dynamic generation resource expansion table T6 based on step 4) and 5);
7) resource expansion contingency table T7 is designed, design resource type id field is associated with T3 table, and design data table id is associated with T4 Table forms 1 pair 1 of relationship;
8) resource table dynamic attribute maintenance: T1 table → T7 table → T4 table → T6 table is realized.
Further, dynamic generation resource expansion table T6 in the step 6), specifically: step 4) and 5) utilize Java phase Pass technology Spring+Freemarker frame can realize visualization list configuration, after list typing T4, T5 table data, pass through Table handling, dynamic generation resource expansion table T6 are built in backstage code execution data library.
Further, the maintenance of resource table dynamic attribute is realized in the step 8), is specifically comprised the following steps:
A) resource type id field is taken out from T1 table, the database table for searching T7 table defines ID;
B) database table is taken out from T7 table and define id field, search the table name of T4 table;
C) the expansion table T6 of practical dynamic generation is directly inquired by above-mentioned table name.
Compared with prior art, the method for managing resource provided by the invention based on data center apparatus at least has following Beneficial effect or advantage:
1. dynamic list visual configuration can be realized by integrating Spring+Freemarker by Java technology, support dynamic Typing table, literary name section, table type in state list, dynamic creation table, product reuse is high, meets the needs of users variation;
2. supporting a large amount of different types of plant maintenances, topological diagram, the realization of 3D configuration figure are extended to, to performance requirement shadow It rings little.
Detailed description of the invention
The present invention is described in further details below with reference to attached drawing;
Fig. 1 is the E-R figure of the prior art;
Fig. 2 is the present invention improved E-R figure on the basis of former MySQL database design scheme.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete Site preparation description, it is clear that described embodiments are some of the embodiments of the present invention, instead of all the embodiments.Based on this hair Embodiment in bright, every other implementation obtained by those of ordinary skill in the art without making creative efforts Example, shall fall within the protection scope of the present invention.
The present invention provides a kind of method for managing resource based on data center apparatus, according to MySQL dynamic list, in original The scheme of MySQL database design improves, and increases dynamic table definition and literary name section definition, realizes form attributes and relationship The E-R figure of dynamic configuration, design is as shown in Figure 2.It was found from above-mentioned Fig. 2:
1. with resource object table for main table T1, the general attribute field of design resource;
2. designing external key of the Resource Architecture ID as Resource Architecture table T2 in T1 table, n is defined as to 1 corresponding relationship, n is Positive integer greater than 1;
3. designing external key of the resource type ID as resource type table T3 in T1 table, n is defined as to 1 corresponding relationship, n is Positive integer greater than 1;
4. establishing dynamic data base table defines T4, storage table structure definition, as database builds the table name of table structure;
5. establishing dynamic data base literary name section defines T5, storage table texture field definition, as database builds the word of table structure Name section, and external key of the table name field as T4 table is designed, n is defined as to 1 corresponding relationship, and n is the positive integer greater than 1;
6. step 4 and 5 can realize that visualization list is matched using frames such as Java the relevant technologies Spring+Freemarker It sets, after list typing T4, T5 table data, table handling, dynamic generation resource expansion table is built by backstage code execution data library T6;
7. designing resource expansion contingency table T7, design resource type id field is associated with T3 table, and design data table id is associated with T4 Table forms 1 pair 1 of relationship;
8. the method for realizing the maintenance of resource table dynamic attribute: T1 table → T7 table → T4 table → T6 table
A) resource type id field is taken out from T1 table, the database table for searching T7 table defines ID;
B) database table is taken out from T7 table and define id field, search the table name of T4 table;
C) the expansion table T6 of practical dynamic generation is directly inquired by table name.
In summary, the key point of this programme design is the design of dynamic data base table and Database field, passes through generation Code generates actual extended attribute table, is associated with and is realized by resource type.
The present invention also provides a kind of computer based system, the system comprises:
Processor;
Nonvolatile memory is configured for being communicated with the processor, and the nonvolatile memory has The instruction being stored thereon, described instruction make the processor execute following operation: root in response to being executed by the processor According to MySQL dynamic list, carry out dynamic list database table definition design, the design of dynamic list database table field definition and Dynamic list database extends contingency table definition design, realizes the dynamic configuration of dynamic list attribute and relationship.
1. with resource object table for main table T1, the general attribute field of design resource;
2. designing external key of the Resource Architecture ID as Resource Architecture table T2 in T1 table, n is defined as to 1 corresponding relationship, n is Positive integer greater than 1;
3. designing external key of the resource type ID as resource type table T3 in T1 table, n is defined as to 1 corresponding relationship, n is Positive integer greater than 1;
4. establishing dynamic data base table defines T4, storage table structure definition, as database builds the table name of table structure;
5. establishing dynamic data base literary name section defines T5, storage table texture field definition, as database builds the word of table structure Name section, and external key of the table name field as T4 table is designed, n is defined as to 1 corresponding relationship;
6. step 4 and 5 can realize that visualization list is matched using frames such as Java the relevant technologies Spring+Freemarker It sets, after list typing T4, T5 table data, table handling, dynamic generation resource expansion table is built by backstage code execution data library T6;Spring indicates an Open Framework, and integrated frame can be provided for JavaEE application development.Freemarker is one A module engine write with Java language, it generates text output based on module.
7. designing resource expansion contingency table T7, design resource type id field is associated with T3 table, and design data table id is associated with T4 Table forms 1 pair 1 of relationship;
8. the method for realizing the maintenance of resource table dynamic attribute: T1 table → T7 table → T4 table → T6 table
A) resource type id field is taken out from T1 table, the database table for searching T7 table defines ID;
B) database table is taken out from T7 table and define id field, search the table name of T4 table;
C) the expansion table T6 of practical dynamic generation is directly inquired by table name.
The MySQL dynamic list designing technique phase mentioned using prior art MySQL database designing technique with this motion Than in the early stage of the project or the lesser situation of device type data volume is applicable in, but as the type of device type increases, it is meant that Each device type needs to increase corresponding expansion table, and these Table Properties cannot go to be adapted to changes in demand, exist Certain maintenance cost.
This motion proposes MySQL dynamic list designing technique, improves, increases in the scheme of former MySQL database design Add dynamic table definition and literary name section definition, realizes the dynamic configuration of form attributes and relationship.
Particular embodiments described above has carried out further in detail the purpose of the present invention, technical scheme and beneficial effects Describe in detail it is bright, it should be understood that the above is only a specific embodiment of the present invention, the guarantor being not intended to limit the present invention Protect range.Without departing from the spirit and scope of the invention, any modification, equivalent substitution, improvement and etc. done also belong to this Within the protection scope of invention.

Claims (10)

1. a kind of method for managing resource based on data center apparatus, which is characterized in that according to MySQL dynamic list, moved State form database table definition design, the design of dynamic list database table field definition and the extension association of dynamic list database Table definition design, realizes the dynamic configuration of dynamic list attribute and relationship.
2. the method for managing resource according to claim 1 based on data center apparatus, which is characterized in that the method tool Body the following steps are included:
1) with resource object table for main table T1, the general attribute field of design resource;
2) design external key of the Resource Architecture ID as Resource Architecture table T2 in T1 table, be defined as n to 1 corresponding relationship, n for greater than 1 positive integer;
3) design external key of the resource type ID as resource type table T3 in T1 table, be defined as n to 1 corresponding relationship, n for greater than 1 positive integer.
3. the method for managing resource according to claim 2 based on data center apparatus, which is characterized in that in the step 3) it is further comprised the steps of: after
4) it establishes dynamic data base table and defines T4, storage table structure definition, which, which defines, builds table structure including database Table name;
5) it establishes dynamic data base literary name section and defines T5, the definition of storage table texture field, which includes data The field name of table structure is built in library, and designs external key of the table name field as T4 table, is defined as n to 1 corresponding relationship, n is big In 1 positive integer;
6) the dynamic generation resource expansion table T6 based on step 4) and 5);
7) resource expansion contingency table T7 is designed, design resource type id field is associated with T3 table, and design data table id is associated with T4 table, shape At 1 pair 1 of relationship;
8) resource table dynamic attribute maintenance: T1 table → T7 table → T4 table → T6 table is realized.
4. the method for managing resource according to claim 3 based on data center apparatus, which is characterized in that the step 6) Middle dynamic generation resource expansion table T6, specifically: step 4) and 5) utilize Java the relevant technologies Spring+Freemarker frame Visualization list configuration can be achieved, after list typing T4, T5 table data, table handling is built by backstage code execution data library, Dynamic generation resource expansion table T6.
5. the method for managing resource according to claim 3 based on data center apparatus, which is characterized in that the step 8) Middle realization resource table dynamic attribute maintenance, specifically comprises the following steps:
A) resource type id field is taken out from T1 table, the database table for searching T7 table defines ID;
B) database table is taken out from T7 table and define id field, search the table name of T4 table;
C) the expansion table T6 of practical dynamic generation is directly inquired by above-mentioned table name.
6. a kind of computer based system, which is characterized in that the system comprises:
Processor;
Nonvolatile memory is configured for being communicated with the processor, and the nonvolatile memory has storage Instruction thereon, described instruction make the processor execute following operation in response to being executed by the processor: according to MySQL dynamic list carries out dynamic list database table definition design, the design of dynamic list database table field definition and moves State form database extends contingency table definition design, realizes the dynamic configuration of dynamic list attribute and relationship.
7. computer based system according to claim 6, which is characterized in that the processing implement body executes step such as Under:
1) with resource object table for main table T1, the general attribute field of design resource;
2) design external key of the Resource Architecture ID as Resource Architecture table T2 in T1 table, be defined as n to 1 corresponding relationship, n for greater than 1 positive integer;
3) design external key of the resource type ID as resource type table T3 in T1 table, be defined as n to 1 corresponding relationship, n for greater than 1 positive integer.
8. computer based system according to claim 7, which is characterized in that also wrapped after executing the step 3) Include step:
4) it establishes dynamic data base table and defines T4, storage table structure definition, which, which defines, builds table structure including database Table name;
5) it establishes dynamic data base literary name section and defines T5, the definition of storage table texture field, which includes data The field name of table structure is built in library, and designs external key of the table name field as T4 table, is defined as n to 1 corresponding relationship;
6) the dynamic generation resource expansion table T6 based on step 4) and 5);
7) resource expansion contingency table T7 is designed, design resource type id field is associated with T3 table, and design data table id is associated with T4 table, shape At 1 pair 1 of relationship;
8) resource table dynamic attribute maintenance: T1 table → T7 table → T4 table → T6 table is realized.
9. computer based system according to claim 8, which is characterized in that dynamic generation resource in the step 6) Expansion table T6, specifically: step 4) and visualization table 5) can be realized using Java the relevant technologies Spring+Freemarker frame Single configuration builds table handling by backstage code execution data library, dynamic generation resource expands after list typing T4, T5 table data Open up table T6.
10. computer based system according to claim 8, which is characterized in that realize resource table in the step 8) Dynamic attribute maintenance, specifically comprises the following steps:
A) resource type id field is taken out from T1 table, the database table for searching T7 table defines ID;
B) database table is taken out from T7 table and define id field, search the table name of T4 table;
C) the expansion table T6 of practical dynamic generation is directly inquired by above-mentioned table name.
CN201811528151.9A 2018-12-13 2018-12-13 Resource management method based on data center equipment Active CN109684329B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201811528151.9A CN109684329B (en) 2018-12-13 2018-12-13 Resource management method based on data center equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201811528151.9A CN109684329B (en) 2018-12-13 2018-12-13 Resource management method based on data center equipment

Publications (2)

Publication Number Publication Date
CN109684329A true CN109684329A (en) 2019-04-26
CN109684329B CN109684329B (en) 2021-04-23

Family

ID=66187664

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201811528151.9A Active CN109684329B (en) 2018-12-13 2018-12-13 Resource management method based on data center equipment

Country Status (1)

Country Link
CN (1) CN109684329B (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111752921A (en) * 2020-06-23 2020-10-09 广西壮族自治区农业科学院农业科技信息研究所 Seed resource information management system

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20070130505A1 (en) * 2005-08-21 2007-06-07 Woods Michael E Template filler, method, and computer program product
CN101067814A (en) * 2007-05-10 2007-11-07 浪潮集团山东通用软件有限公司 Mapping conversion method between data access level Xml format data and relational data
CN102254021A (en) * 2011-07-26 2011-11-23 北京市计算中心 Method for constructing database based on virtual machine management system
CN102622436A (en) * 2012-02-29 2012-08-01 浙江吉利汽车研究院有限公司 Data table establishing method of human resource management system
CN104834860A (en) * 2015-05-09 2015-08-12 福建六壬网安股份有限公司 Dynamic warehousing method for security events
CN106202524A (en) * 2016-07-22 2016-12-07 努比亚技术有限公司 Data base and point meter apparatus and method

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20070130505A1 (en) * 2005-08-21 2007-06-07 Woods Michael E Template filler, method, and computer program product
CN101067814A (en) * 2007-05-10 2007-11-07 浪潮集团山东通用软件有限公司 Mapping conversion method between data access level Xml format data and relational data
CN102254021A (en) * 2011-07-26 2011-11-23 北京市计算中心 Method for constructing database based on virtual machine management system
CN102622436A (en) * 2012-02-29 2012-08-01 浙江吉利汽车研究院有限公司 Data table establishing method of human resource management system
CN104834860A (en) * 2015-05-09 2015-08-12 福建六壬网安股份有限公司 Dynamic warehousing method for security events
CN106202524A (en) * 2016-07-22 2016-12-07 努比亚技术有限公司 Data base and point meter apparatus and method

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
H248980496: "动态表单的数据库结构设计", 《HTTPS://WWW.ITEYE.COM/PROBLEMS/91934》 *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111752921A (en) * 2020-06-23 2020-10-09 广西壮族自治区农业科学院农业科技信息研究所 Seed resource information management system

Also Published As

Publication number Publication date
CN109684329B (en) 2021-04-23

Similar Documents

Publication Publication Date Title
CN103714129B (en) Dynamic data structure based on conditional plan and the construction device of relation and construction method
CN102750406B (en) Multi-version management method for model set and difference model-based power grid model
CN108647330B (en) 3D lightweight conversion method based on BIM model file
CN105335412B (en) For data conversion, the method and apparatus of Data Migration
US20160055233A1 (en) Pre-join tags for entity-relationship modeling of databases
CN102184299B (en) Model conversion method and system from CAD (Computer Aided Design) system to three-dimensional checking system
CN107103064B (en) Data statistical method and device
CN103049251B (en) A kind of data base persistence layer device and database operation method
US20130166602A1 (en) Cloud-enabled business object modeling
CN106202207A (en) A kind of index based on HBase ORM and searching system
CN104573185B (en) The processing method and processing device of High-sped Trains index
CN107491476B (en) Data model conversion and query analysis method suitable for various big data management systems
CN106611037A (en) Method and device for distributed diagram calculation
CN102495832A (en) System for automatically generating document in software development process
CN108984155A (en) Flow chart of data processing setting method and device
CN108829884A (en) data mapping method and device
CN103235811A (en) Data storage method and device
CN104050161A (en) Dynamic bridging of application and data servers
JP2017536591A (en) Mapping rule creation method and apparatus
CN106021344B (en) A Multi-adaptive CIME Grid Model Sharing Method
Le et al. Domain-driven design using meta-attributes: A DSL-based approach
CN104699788A (en) Database query method and device
CN116795859A (en) Data analysis methods, devices, computer equipment and storage media
CN103902282B (en) Model transformation method from Web service combination to colored Petri network
CN104462095A (en) Extraction method and device of common pars of query statements

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