IFMA Network:   Credentials   Community   World Workplace   [Facility Fusion]   FMJ   Foundation     Learn: dates   map   Connect:         Advance:    

6.04 Database Synergy for Facility Assets

Wednesday, April 3, 2013
3:45 PM-4:45 PM
Track: Change Management
Format: General Presentation
Organization: IFMA
Knowledge Level: 300 level
Session Description: When you look at the Hartsfield–Jackson Atlanta International Airport Asset Management Data Mart today, one could not imagine what went into developing such a simple but powerful tool.

The project began with an Asset Manager and a Data Analyst driven to produce a database that would join and leverage all existing asset databases.  Database Synergy for Facility Assets, the title alone suggests that by grouping facility asset databases into one asset database, that the one database would outperform even the best of its members, and that has proven to be the case.  The one asset database is affectionately called the Data Mart because, as with Walmart a family can go to one location and find all their household needs, so it is with the Data Mart when it come to finding information on an airport asset.

Utilizing a homegrown GIS nomenclature that is representative of the airport and flexible allowed for the joining of each existing asset database.  This joining of databases allows one to view and analyze an asset’s data in one location at the click of a button. The data may include replacement and renewal costs, utility consumption and costs, maintenance labor and material costs, lease revenue and associated project costs for an asset.  With this data at your fingertips, one can now easily calculate Total Cost Ownership (TCO) for an asset, a new but conscientious approach of looking at assets.

Learning Objectives:
  • Learn about GIS nomenclatur.e
  • Discuss the development of Asset Numbering Schema.
  • Learn about the populating of databases.
  • Discuss linking databases.
  •     Conference Proceedings



    Sarah Peek
    Hartsfield-Jackson Atlanta International Airport
    Asset Manager, Sr.
    Asset Management and Sustainability

    Peek is a graduate of the University of Dayton with a B.S. in Electrical Engineering. She was the facility manager for Motorola for fifteen years and is currently the Asset Manager for Hartsfield-Jackson Atlanta International Airport.

    See more of: Change Management
    See more of: Session Proposals