NASA Logo

NTRS

NTRS - NASA Technical Reports Server

Collections About News Help Login
Back to Results
FJET Database Project: Extract, Transform, and LoadThe Data Mining & Knowledge Management team at Kennedy Space Center is providing data management services to the Frangible Joint Empirical Test (FJET) project at Langley Research Center (LARC). FJET is a project under the NASA Engineering and Safety Center (NESC). The purpose of FJET is to conduct an assessment of mild detonating fuse (MDF) frangible joints (FJs) for human spacecraft separation tasks in support of the NASA Commercial Crew Program. The Data Mining & Knowledge Management team has been tasked with creating and managing a database for the efficient storage and retrieval of FJET test data. This paper details the Extract, Transform, and Load (ETL) process as it is related to gathering FJET test data into a Microsoft SQL relational database, and making that data available to the data users. Lessons learned, procedures implemented, and programming code samples are discussed to help detail the learning experienced as the Data Mining & Knowledge Management team adapted to changing requirements and new technology while maintaining flexibility of design in various aspects of the data management project.
Document ID
20150023603
Acquisition Source
Kennedy Space Center
Document Type
Other
Authors
Samms, Kevin O. (University of Central Florida Orlando, FL, United States)
Date Acquired
December 31, 2015
Publication Date
November 20, 2015
Subject Category
Mathematical And Computer Sciences (General)
Report/Patent Number
KSC-E-DAA-TN28363
Funding Number(s)
CONTRACT_GRANT: NNX13AJ45A
Distribution Limits
Public
Copyright
Public Use Permitted.
Keywords
excel vba
frangible joint
FJET
SSMS
SSMA
database management
ETL
MySQL
load
extract
SSRS
Microsoft SQL
transform

Related Records

There are no records associated with this record.
No Preview Available