CN108228426A - A kind of method and apparatus for recording SDR information - Google Patents
A kind of method and apparatus for recording SDR information Download PDFInfo
- Publication number
- CN108228426A CN108228426A CN201810054144.3A CN201810054144A CN108228426A CN 108228426 A CN108228426 A CN 108228426A CN 201810054144 A CN201810054144 A CN 201810054144A CN 108228426 A CN108228426 A CN 108228426A
- Authority
- CN
- China
- Prior art keywords
- sdr
- sdr information
- information
- sqlite
- record
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3065—Monitoring arrangements determined by the means or processing involved in reporting the monitored data
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/23—Updating
Abstract
This application discloses it is a kind of record SDR information method and apparatus, including：Transplanting introduces SQLITE databases in baseboard management controller；SDR message structures are combed, build SDR information tables, and be written in the SQLITE databases；Corresponding update operation is directly carried out to the SDR information tables.The application gives up traditional record SDR information in the form of binary data stream, it is changed to record SDR information by the form of database, since SQLITE is a kind of Universal Database, the application passes through SQLITE data base administration SDR information using BMC, greatly facilitate developer and operation maintenance personnel management service BMC and server, and the application has very strong reproducibility and expansion, suitable for all kinds of servers.
Description
Technical field
The present invention relates to Sensor Data Record field, more particularly to a kind of method and apparatus for recording SDR information.
Background technology
With the development of internet, the expansion of server radix, for the operation conditions of server, the prison of health status
It surveys, it was also proposed that newer requirement.Administrator can utilize Intelligent Platform Management Interface (Intelligent Platform
Management Interface, IPMI) monitoring server physical health feature, such as temperature, voltage, fan operating state,
Power supply status etc..These physical health features are all by Sensor Data Record (the Sensor Data in IPMI standard
Record, SDR) acquisition of information.At present, the realization of most softwares be all by SDR information in the form of binary data stream
It is stored in flash memory (FLASH), records SDR information in this way, it is necessary to realize sensor using special tool
Additions and deletions, modification, and data readability is not high, it has not been convenient to and the management service in later stage and extension work limit server substrate
The exploitation of Management Controller (Baseboard Management Controller, BMC) and efficiency are safeguarded.Particularly now, respectively
Kind server is more and more, and a kind of efficient mode is more needed to manage SDR information.
Invention content
In view of this, it the purpose of the present invention is to provide a kind of method and apparatus for recording SDR information, greatly facilitates
Developer and operation maintenance personnel management service BMC and server have very strong reproducibility and expansion.Its concrete scheme
It is as follows：
A kind of method for recording SDR information, including：
Transplanting introduces SQLITE databases in baseboard management controller；
SDR message structures are combed, build SDR information tables, and be written in the SQLITE databases；
Corresponding update operation is directly carried out to the SDR information tables.
Preferably, in the method for above-mentioned record SDR information provided in an embodiment of the present invention, in baseboard management controller
Transplanting introduces SQLITE databases, specifically includes：
Cross compile SQLITE databases, it is arm-linux-gcc to specify compiler；
Using arm-linux-strip tools, the redundant information of executable file is removed, cuts the SQLITE databases
Executable file；
It will be in the SQLITE data-base transplantations to baseboard management controller after cutting.
Preferably, in the method for above-mentioned record SDR information provided in an embodiment of the present invention, the SDR information tables include
Owner ID, logical unit number, sensor number, entity ID, entity serial number, sensor type, simulation Value Types, event type,
Linear information.
Preferably, in the method for above-mentioned record SDR information provided in an embodiment of the present invention, directly to SDR information tables into
The corresponding update operation of row, specifically includes：
According to IPMI protocol, directly the SDR information progress additions and deletions in the SDR information tables are changed and are looked into.
The embodiment of the present invention additionally provides a kind of equipment for recording SDR information, including：
Data-base transplantation module, for the transplanting introducing SQLITE databases in baseboard management controller；
Information table writing module for combing SDR message structures, builds SDR information tables, and the SQLITE data are written
In library；
Information table update module, for directly carrying out corresponding update operation to the SDR information tables.
Preferably, in the equipment of above-mentioned record SDR information provided in an embodiment of the present invention, the data-base transplantation mould
Block, specifically for cross compile SQLITE databases, it is arm-linux-gcc to specify compiler；Utilize arm-linux-strip
Tool removes the redundant information of executable file, cuts the executable file of the SQLITE databases；Described in after cutting
SQLITE databases are placed into baseboard management controller.
Preferably, in the equipment of above-mentioned record SDR information provided in an embodiment of the present invention, the SDR information tables include
Owner ID, logical unit number, sensor number, entity ID, entity serial number, sensor type, simulation Value Types, event type,
Linear information.
Preferably, in the equipment of above-mentioned record SDR information provided in an embodiment of the present invention, described information table update mould
Block, specifically for according to IPMI protocol, directly changing to the SDR information progress additions and deletions in the SDR information tables and looking into.
A kind of method and apparatus for recording SDR information provided by the present invention, including：It is transplanted in baseboard management controller
Introduce SQLITE databases；SDR message structures are combed, build SDR information tables, and be written in the SQLITE databases；Directly
Corresponding update operation is carried out to the SDR information tables.The present invention gives up traditional record SDR in the form of binary data stream
Information is changed to record SDR information by the form of database, and since SQLITE is a kind of Universal Database, the present invention is led to using BMC
SQLITE data base administration SDR information is crossed, greatly facilitates developer and operation maintenance personnel management service BMC and service
Device, and the present invention has very strong reproducibility and expansion, suitable for all kinds of servers.
Description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, to embodiment or will show below
There is attached drawing needed in technology description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
The embodiment of invention, for those of ordinary skill in the art, without creative efforts, can also basis
The attached drawing of offer obtains other attached drawings.
Fig. 1 is the flow chart of the method for record SDR information provided in an embodiment of the present invention；
Fig. 2 is the particular flow sheet of the method for record SDR information provided in an embodiment of the present invention；
Fig. 3 is the structure diagram of the equipment of record SDR information provided in an embodiment of the present invention.
Specific embodiment
Below in conjunction with the attached drawing in the embodiment of the present invention, the technical solution in the embodiment of the present invention is carried out clear, complete
Site preparation describes, it is clear that described embodiment is only part of the embodiment of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, those of ordinary skill in the art are obtained every other without making creative work
Embodiment shall fall within the protection scope of the present invention.
The present invention provides a kind of method for recording SDR information, as shown in Figure 1, including the following steps：
S101, transplanting introduces SQLITE databases in baseboard management controller；
S102, SDR message structures are combed, builds SDR information tables, and be written in the SQLITE databases；
S103, corresponding update operation is directly carried out to the SDR information tables.
In the method for above-mentioned record SDR information provided in an embodiment of the present invention, give up traditional with binary data
The form record SDR information of stream, is changed to record SDR information by the form of database, since SQLITE is a kind of Universal Database,
Developer and operation maintenance personnel management dimension are specifically greatly facilitated by SQLITE data base administration SDR information using BMC
BMC and server are protected, and the application has very strong reproducibility and expansion, suitable for all kinds of servers.
In the specific implementation, in the method for above-mentioned record SDR information provided in an embodiment of the present invention, step S101 is in base
Transplanting introduces SQLITE databases in board management controller, as shown in Fig. 2, specifically may comprise steps of：
S201, cross compile SQLITE databases, it is arm-linux-gcc to specify compiler；
S202, using arm-linux-strip tools, remove the redundant information of executable file, cut the SQLITE
The executable file of database；
S203, will be in the SQLITE data-base transplantations to baseboard management controller after cutting.
In this way by cutting, transplanting SQLITE databases so that be possibly realized in BMC using database.
In the specific implementation, in the method for above-mentioned record SDR information provided in an embodiment of the present invention, the SDR information
Table can include following information：Owner ID (OwerID), logical unit number (LUN), sensor number (SENSOR_NUM), entity
ID (EntityID), entity serial number (EntityInst), sensor type (SensorType), simulation Value Types (Analog),
Event type (eventType), linear information (Linearization).
In the specific implementation, in the method for above-mentioned record SDR information provided in an embodiment of the present invention, in order to further carry
High efficiency, step S103 directly carries out SDR information tables corresponding update operation, as shown in Fig. 2, can specifically include following step
Suddenly：
S204, according to IPMI protocol, directly carry out additions and deletions to the SDR information in the SDR information tables and change to look into.
Based on same inventive concept, the embodiment of the present invention additionally provides a kind of equipment for recording SDR information, due to the equipment
The principle solved the problems, such as is similar to a kind of aforementioned method for recording SDR information, therefore the implementation of the equipment may refer to record SDR
The implementation of the method for information, overlaps will not be repeated.
In the specific implementation, the equipment of record SDR information provided in an embodiment of the present invention, as shown in figure 3, specifically including：
Data-base transplantation module 11, for the transplanting introducing SQLITE databases in baseboard management controller；
Information table writing module 12 for combing SDR message structures, builds SDR information tables, and the SQLITE numbers are written
According in library；
Information table update module 13, for directly carrying out corresponding update operation to the SDR information tables.
In the equipment of above-mentioned record SDR information provided in an embodiment of the present invention, SQLITE data can be passed through using BMC
Library management SDR information greatly facilitates developer and operation maintenance personnel management service BMC and server, and with very
Strong reproducibility and expansion, suitable for all kinds of servers.
In the specific implementation, in the equipment of above-mentioned record SDR information provided in an embodiment of the present invention, the database moves
Module 11 is planted, specifically can be used for cross compile SQLITE databases, it is arm-linux-gcc to specify compiler；Utilize arm-
Linux-strip tools remove the redundant information of executable file, cut the executable file of the SQLITE databases；It will
The SQLITE databases after cutting are placed into baseboard management controller.
In the specific implementation, in the equipment of above-mentioned record SDR information provided in an embodiment of the present invention, the SDR information
Table can include following information：Owner ID (OwerID), logical unit number (LUN), sensor number (SENSOR_NUM), entity
ID (EntityID), entity serial number (EntityInst), sensor type (SensorType), simulation Value Types (Analog),
Event type (eventType), linear information (Linearization).
In the specific implementation, in the equipment of above-mentioned record SDR information provided in an embodiment of the present invention, in order to further carry
High efficiency, described information table update module 13 specifically can be used for according to IPMI protocol, directly in the SDR information tables
The progress additions and deletions of SDR information, which change, looks into.
A kind of method and apparatus for recording SDR information provided in an embodiment of the present invention, including：In baseboard management controller
Transplanting introduces SQLITE databases；SDR message structures are combed, build SDR information tables, and be written in the SQLITE databases；
Corresponding update operation is directly carried out to the SDR information tables.The present invention gives up traditional note in the form of binary data stream
SDR information is recorded, is changed to record SDR information by the form of database, since SQLITE is a kind of Universal Database, the present invention utilizes
BMC by SQLITE data base administration SDR information, greatly facilitate developer and operation maintenance personnel management service BMC and
Server, and the present invention has very strong reproducibility and expansion, suitable for all kinds of servers.
Finally, it is to be noted that, herein, term " comprising ", "comprising" or its any other variant are intended to
Cover non-exclusive inclusion, so that process, method, article or equipment including a series of elements not only include those
Element, but also including other elements that are not explicitly listed or further include as this process, method, article or set
Standby intrinsic element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that
Also there are other identical elements in the process, method, article or apparatus that includes the element.
The method and apparatus of record SDR information provided by the present invention is described in detail above, it is used herein
Specific case is expounded the principle of the present invention and embodiment, to understand the explanation of above example is only intended to helping
The method and its core concept of the present invention；Meanwhile for those of ordinary skill in the art, thought according to the present invention is having
There will be changes in body embodiment and application range, in conclusion the content of the present specification should not be construed as to the present invention
Limitation.
Claims (8)
- A kind of 1. method for recording SDR information, which is characterized in that including：Transplanting introduces SQLITE databases in baseboard management controller；SDR message structures are combed, build SDR information tables, and be written in the SQLITE databases；Corresponding update operation is directly carried out to the SDR information tables.
- 2. the method for record SDR information according to claim 1, which is characterized in that transplanted in baseboard management controller SQLITE databases are introduced, are specifically included：Cross compile SQLITE databases, it is arm-linux-gcc to specify compiler；Using arm-linux-strip tools, the redundant information of executable file is removed, cut the SQLITE databases can Perform file；It will be in the SQLITE data-base transplantations to baseboard management controller after cutting.
- 3. the method for record SDR information according to claim 2, which is characterized in that the SDR information tables include owner ID, logical unit number, sensor number, entity ID, entity serial number, sensor type simulate Value Types, and event type is linear to believe Breath.
- 4. the method for record SDR information according to claim 3, which is characterized in that directly carried out to SDR information tables corresponding Update operation, specifically include：According to IPMI protocol, directly the SDR information progress additions and deletions in the SDR information tables are changed and are looked into.
- 5. a kind of equipment for recording SDR information, which is characterized in that including：Data-base transplantation module, for the transplanting introducing SQLITE databases in baseboard management controller；Information table writing module for combing SDR message structures, builds SDR information tables, and the SQLITE databases are written In；Information table update module, for directly carrying out corresponding update operation to the SDR information tables.
- 6. the equipment of record SDR information according to claim 5, which is characterized in that the data-base transplantation module, specifically For cross compile SQLITE databases, it is arm-linux-gcc to specify compiler；Utilize arm-linux-strip tools, stripping Redundant information from executable file cuts the executable file of the SQLITE databases；By the SQLITE after cutting Database is placed into baseboard management controller.
- 7. the equipment of record SDR information according to claim 6, which is characterized in that the SDR information tables include owner ID, logical unit number, sensor number, entity ID, entity serial number, sensor type simulate Value Types, and event type is linear to believe Breath.
- 8. the equipment of record SDR information according to claim 7, which is characterized in that described information table update module, specifically For according to IPMI protocol, directly changing to the SDR information progress additions and deletions in the SDR information tables and looking into.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810054144.3A CN108228426A (en) | 2018-01-19 | 2018-01-19 | A kind of method and apparatus for recording SDR information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810054144.3A CN108228426A (en) | 2018-01-19 | 2018-01-19 | A kind of method and apparatus for recording SDR information |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108228426A true CN108228426A (en) | 2018-06-29 |
Family
ID=62668044
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810054144.3A Pending CN108228426A (en) | 2018-01-19 | 2018-01-19 | A kind of method and apparatus for recording SDR information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108228426A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109254863A (en) * | 2018-08-30 | 2019-01-22 | 郑州云海信息技术有限公司 | A kind of method, apparatus and controlled terminal recording System Event Log |
| CN112988859A (en) * | 2019-12-17 | 2021-06-18 | 中国移动通信集团浙江有限公司 | Data processing method and device, computing equipment and computer storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102222073A (en) * | 2010-04-19 | 2011-10-19 | 英业达股份有限公司 | Sensor data analyzer for server |
| CN103235820A (en) * | 2013-04-27 | 2013-08-07 | 北京搜狐新媒体信息技术有限公司 | Data storage method and device in cluster system |
| CN103885865A (en) * | 2014-03-17 | 2014-06-25 | 华为技术有限公司 | Method and device for managing sensors |
-
2018
- 2018-01-19 CN CN201810054144.3A patent/CN108228426A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102222073A (en) * | 2010-04-19 | 2011-10-19 | 英业达股份有限公司 | Sensor data analyzer for server |
| CN103235820A (en) * | 2013-04-27 | 2013-08-07 | 北京搜狐新媒体信息技术有限公司 | Data storage method and device in cluster system |
| CN103885865A (en) * | 2014-03-17 | 2014-06-25 | 华为技术有限公司 | Method and device for managing sensors |
Non-Patent Citations (1)
| Title |
|---|
| 阿辉: "SQlite在PC和ARM上的编译移植", 《HTTPS://BLOG.CSDN.NET/LGHTJPU/ARTICLE/DETAILS/8103064》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109254863A (en) * | 2018-08-30 | 2019-01-22 | 郑州云海信息技术有限公司 | A kind of method, apparatus and controlled terminal recording System Event Log |
| CN112988859A (en) * | 2019-12-17 | 2021-06-18 | 中国移动通信集团浙江有限公司 | Data processing method and device, computing equipment and computer storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105706065A (en) | Storage cluster | |
| CN104199750B (en) | A kind of file access pattern method and device of Linux system | |
| CN108228426A (en) | A kind of method and apparatus for recording SDR information | |
| CN103942099B (en) | Executing tasks parallelly method and device based on Hive | |
| CN102289460A (en) | Method and system for performing report metadata synchronization on testing environments | |
| CN101872176A (en) | Method and system for generating measurement and control software | |
| CN103348329A (en) | Generating test data | |
| CN105912330A (en) | Hardware device control method and device | |
| CN109032577A (en) | A kind of data simulation method | |
| CN105787058A (en) | User label system and data pushing system based on same | |
| CN108182278A (en) | A kind of FRU information maintenance methods and relevant apparatus | |
| CN108647193A (en) | A kind of unique identifier generation method can be applied to distributed system and device | |
| CN115858488A (en) | Parallel migration method and device based on data governance and readable medium | |
| CN109165022A (en) | A kind of big data cluster dispositions method, system, medium and equipment | |
| CN105260266A (en) | Snapshot volume writing method and dependent snapshot system | |
| CN103809915B (en) | The reading/writing method of a kind of disk file and device | |
| CN109117431A (en) | System and method for the source data applied from source to be incorporated into the target data of target application | |
| CN205620854U (en) | Motherboard assembly and server | |
| CN116414909A (en) | Database synchronization method and device for battery replacement data, electronic equipment and storage medium | |
| CN110309594B (en) | Cable tray model processing method, system, equipment and storage medium | |
| CN108399258A (en) | Table expansion method is divided in an a kind of point library for database | |
| US20220222252A1 (en) | Methods and systems for storing and querying log messages using log message bifurcation | |
| CN108268342A (en) | The storage arithmetic system and method for extensive IT monitoring datas | |
| Johansson | Using a Meta-Database for Integration Planning and Documentation of Product Modeling Systems | |
| CN112764396B (en) | Configuration method and device |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180629 |