Definition and maintenance of a telemetry database dictionary
A telemetry dictionary database includes a component for receiving spreadsheet workbooks of telemetry data over a web-based interface from other computer devices. Another component routes the spreadsheet workbooks to a specified directory on the host processing device. A process then checks the received spreadsheet workbooks for errors, and if no errors are detected the spreadsheet workbooks are routed to another directory to await initiation of a remote database loading process. The loading process first converts the spreadsheet workbooks to comma separated value (CSV) files. Next, a network connection with the computer system that hosts the telemetry dictionary database is established and the CSV files are ported to the computer system that hosts the telemetry dictionary database. This is followed by a remote initiation of a database loading program. Upon completion of loading a flatfile generation program is manually initiated to generate a flatfile to be used in a mission operations environment by the core ground system.
1. A computer readable medium whose contents assemble and manage a telemetry dictionary database on a host processing device having storage capabilities and a web-based interface, wherein the telemetry database dictionary is used by a core ground system, and the host processing device is communicable with other processing devices over a network via the web-based interface, the computer readable medium comprising:
a component for receiving spreadsheet workbooks via said web-based interface from other computer devices communicable with the network, the spreadsheet workbooks comprised of telemetry data definitions;
a component for routing said spreadsheet workbooks to a specified directory on the host processing device;
a component for checking the received spreadsheet workbooks for errors, and if no errors are detected the spreadsheet workbooks are routed to another directory to await initiation of a database loading process; and
a component for initiating a remote database loading process that results in the converting and loading of error free spreadsheet workbooks into the telemetry dictionary database,
wherein the remote database loading process comprises:
converting the spreadsheet workbooks to comma separated value (CSV) files;
establishing a network connection with the computer system that hosts the telemetry dictionary database;
porting the CSV files to the computer system that hosts the database: and
remotely initiating the execution of a database loading program.
further comprising a component for remotely initiating a flatfile generation program to generate a flatfile to be used in a mission operations environment.
wherein the remote database loading process further comprises:
invoking the core ground system to test the flatfile generated in a simulated environment.
wherein the remote database loading process further comprises:
a filter component that refines the telemetry data for consistency during the database loading process.
further comprising an administrative component that:
associates a flatfile with the spreadsheet workbook;
ports the accented workbooks to a specified directory;
updates a file relating to the status of accented workbooks; and
notifies appropriate users via e-mail of the updates to the telemetry dictionary database,
wherein command data is substituted for telemetry data.
2. A method of assembling and managing a telemetry dictionary database on a host processing device having storage capabilities and a web-based interface, wherein the telemetry database dictionary is used by a core ground system, and the host processing device is communicable with other processing devices over a network via the web-based interface, the method comprising:
receiving spreadsheet workbooks via said web-based interface from other computer devices communicable with the network, the spreadsheet workbooks comprised of telemetry data definitions;
routing said spreadsheet workbooks to a specified directory on the host processing device;
checking the received spreadsheet workbooks for errors, and if no errors are detected the spreadsheet workbooks are routed to another directory to await initiation of a database loading process; and
initiating a remote database loading process that results in the converting and loading of error free spreadsheet workbooks into the telemetry dictionary database,
wherein the remote database loading process comprises:
converting the spreadsheet workbooks to comma separated value (CSV) files;
establishing a network connection with the computer system that hosts the telemetry dictionary database;
porting the CSV files to the computer system that hosts the database; and
remotely initiating the execution of a database loading program,
further comprising a component for remotely initiating a flatfile generation program to generate a flatfile to be used in a mission operations environment,
wherein the remote database loading process further comprises:
invoking the core ground system to test the flatfile generated in a simulated environment,
wherein the remote database loading process further comprises:
a filter component that refines the telemetry data for consistency during the database loading process,
further comprising an administrative component that:
associates a flatfile with the spreadsheet workbook;
ports the accepted workbooks to a specified directory;
updates a file relating to the status of accepted workbooks; and
notifies appropriate users via e-mail of the updates to the telemetry dictionary database,
wherein command data is substituted for telemetry data.
3. A computer based system for assembling and managing a telemetry dictionary database comprising:
a host processing device communicable over a network with remote processing devices via a web-based interface and further communicable with a computer system upon which resides the telemetry dictionary database, the host processing device further comprising software capable of:
receiving spreadsheet workbooks via said web-based interface from the remote processing devices over the network, the spreadsheet workbooks comprised of telemetry data definitions;
routing said spreadsheet workbooks to a specified directory on the host processing device;
checking the received spreadsheet workbooks for errors, and if no errors are detected routing the spreadsheet workbooks to another directory to await initiation of a database loading process; and
initiating a remote database loading process on the computer system upon which resides the telemetry dictionary database that results in the converting and loading of error free spreadsheet workbooks into the telemetry dictionary database,
wherein the remote database loading process comprises:
converting the spreadsheet workbooks to comma separated value (CSV) files;
establishing a network connection with the computer system that hosts the telemetry dictionary database;
porting the CSV files to the computer system that hosts the database; and
remotely initiating the execution of a database loading program,
wherein the host processing device software is further capable of remotely initiating a flatfile generation program to generate a flatfile to be used in a mission operations environment,
wherein the remote database loading process further comprises:
a filter component that refines the telemetry data for consistency during the database loading process,
wherein the host processing device software further comprises an administrative component that:
associates a flatfile with the spreadsheet workbook;
ports the accepted workbooks to a specified directory;
updates a file relating to the status of accepted workbooks; and
notifies appropriate users via e-mail of the updates to the telemetry dictionary database,
wherein command data is substituted for telemetry data.