Systems and methods for storing computer infrastructure inventory data

摘要

A computer for storing computer infrastructure inventory data includes a processor and a memory device coupled to the processor. The computer also includes a database system stored on the memory device. The database system includes computer-executable instructions allowing the computer to manage stored records. The computer is configured to receive an inventory file associated with a scan of a host device. The computer is also configured to receive a mapping schema associated with the inventory file. The mapping schema comprises a structured relationship description between the inventory file and an inventory record. The computer is further configured to translate the inventory file to the inventory record using the mapping schema and to update the database system with the inventory record.

主权项

1. A computer-implemented method for storing computer infrastructure inventory data using a computing device coupled to a memory device and a homogeneous database system stored on the memory device, the homogeneous database system including computer-executable instructions allowing the computing device to manage stored records, the method comprising:
deploying a first tool set to a first host device, wherein the first tool set includes a scan program configured to execute on the first host device to generate a first inventory file associated with a first scan of the first host device, the first inventory file having a first heterogeneous inventory file format specific to the first host device; deploying a second tool set to a second host device, wherein the second tool set includes a scan program configured to execute on the second host device to generate a second inventory file associated with a second scan of the second host device, the second inventory file having a second heterogeneous inventory file format specific to the second host device the second inventory file having a second heterogeneous inventory file format distinct from the first heterogeneous inventory file format and specific to the second host device; receiving, at the computing device, the first inventory file associated with the first scan of the first host device and the second inventory file associated with the second scan of the second host device; receiving, at the computing device, a first mapping schema specifying relationships associated with the first heterogeneous inventory file format and a second mapping schema specifying relationships associated with the second heterogeneous inventory file format, the first mapping schema associated with the first inventory file wherein the first mapping schema comprises a first structured relationship description between the first inventory file and a first inventory record and the second mapping schema associated with the second inventory file wherein the second mapping schema comprises a second structured relationship description between the second inventory file and a second inventory record; translating, at the computing device, the first inventory file to the first inventory record using the first mapping schema, and the second inventory file to the second inventory record using the second mapping schema, by converting the first inventory file from the first heterogeneous inventory file format to a homogeneous data format not specific to the first host device, and by converting the second inventory file from the second heterogeneous inventory file format to the homogeneous data format not specific to the second host device; and updating the homogenous database system with the first and second inventory records such that the homogeneous database system includes heterogeneous data represented by data of the first and second inventory records in the homogeneous data format.