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

Planning table data analysis method

A parsing method and table data technology, applied in relational databases, database models, structured data retrieval, etc., to reduce possibilities, solve risks and deficiencies, and facilitate viewing and management.

Pending Publication Date: 2020-07-17
上海新致软件股份有限公司
View PDF10 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The present invention provides a planning table data analysis method, which solves the risks and deficiencies of manual operation in the operation and maintenance stage, and can realize the mutual compatibility of planning tables, and effectively organize and store data, which facilitates the viewing and management of relevant personnel. Greatly reduces the possibility of errors

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
  • Planning table data analysis method
  • Planning table data analysis method
  • Planning table data analysis method

Examples

Experimental program
Comparison scheme
Effect test

example B

[0080] Configuration item instance B: network card --eth0

[0081] Attribute name: network card name; attribute value: eth0

example C

[0082] Configuration item example C: network port--10GE1 / 0 / 1

[0083] Attribute name: network port; attribute value: 10GE1 / 0 / 1

example D

[0084] Configuration item instance D: network device --DC-P-118-D21-39U-NSW01

[0085] Attribute name: device name; attribute value: DC-P-118-D21-39U-NSW01

[0086] At the same time, resolve their associations:

[0087] Host DC-P-118-D-21-PCS01 and network card eth0-- combination relationship;

[0088] Network device DC-P-118-D21-39U-NSW01 and network port 10GE1 / 0 / 1-- combination relationship;

[0089] NIC eth0 and network port 10GE1 / 0 / 1--association relationship.

[0090] During the parsing process, the parent-child relationship is defined, forming a tree structure. It will be very convenient to search for data later, and more content can be expanded from this.

[0091] Such as Image 6 As shown, analyze the cell in the first row of the "logical name" column in the planning table above, the value of the cell is "Y20421001", and the "logical name" of the column where the cell is known is known, and the "logical name" is obtained The attributes of the configuration item te...

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 planning table data analysis method. The method comprises the following steps: analyzing a header line of a planning table to obtain a configuration item template, associating configuration item template attributes with the configuration item template, analyzing data lines of the planning table, circularly analyzing each cell in each data line line by line to obtain configuration item instances, and associating configuration item instance attributes with the configuration item instances. According to the method, risks and defects existing in manual operation in the operation and maintenance stage are overcome, mutual compatibility of the planning tables can be achieved, data are effectively sorted and stored, checking and management of related personnel are facilitated, and the possibility of errors is greatly reduced.

Description

technical field [0001] The invention relates to a planning table data analysis method. Background technique [0002] In IT service management, data management is often a crucial link. Traditional offline operation and maintenance relies mostly on manpower and verbal communication, commonly known as "human flesh operation and maintenance". The hardware assets and software assets of the enterprise are recorded in Excel tables. These tables are called "planning tables", and the operation and maintenance personnel perform operation and maintenance according to the planning tables. These planning tables often have a fixed format, are uniformly maintained by dedicated personnel, and are usually printed out. If new equipment or software is added, special maintenance of change records is required. The operation is complicated and almost all manual operations, and most of the communication is verbal. [0003] The traditional Excel form can neither guarantee the accuracy of the dat...

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
IPC IPC(8): G06F16/28G06F16/2455G06F40/18
CPCG06F16/284G06F16/2455
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