THE LONG ISLAND RAIL ROAD DATA WAREHOUSE: AN INNOVATIVE MEANS TO COLLECT, STORE, RETRIEVE, AND ANALYZE DATA

Every day the Long Island Rail Road (LIRR) operates 730 daily revenue trains carrying 270,000 customers in 1100 cars. Each day all train performance is documented, delays are categorized, and incidents are recorded. Historical information is often required to compare data from different time period. The result - reams of data, difficult to maintain in hard copy form, obtainable slowly from traditional magnetic tape storage, but often required on short notice to solve the day's crisis. The LIRR Transportation and Information System Departments have developed a data warehouse that enables the company to collect daily train information and store it for easy accessibility. This paper explains how and why the data warehouse was developed at the LIRR, and discusses some specific applications - train performance, delay analysis, overtime, equipment data - that would be useful to any large transit property that needs to analyze information that crosses its internal functional lines.

• Corporate Authors:

  American Public Transportation Association

  1666 K Street, NW, Suite 1100
  Washington, DC  United States  20006
• Authors:
  • Smallwood-Brown, C
  • Sparberg, A J
• Conference:
  • Rail Transit Conference, 2000
  • Location: St. Louis Missouri
  • Date: 2000-6-10 to 2000-6-15
• Publication Date: 2000

Language

• English

Media Info

• Features: Figures; Tables;
• Pagination: p. 347-357
• Monograph Title: RAIL TRANSIT CONFERENCE PROCEEDINGS

Subject/Index Terms

• TRT Terms: Equipment maintenance; Information management; Information services; Information storage and retrieval systems; Performance evaluations; Schedule maintenance
• Identifier Terms: Long Island Rail Road
• Subject Areas: Data and Information Technology; Maintenance and Preservation; Public Transportation;

Filing Info

• Accession Number: 00796137
• Record Type: Publication
• Files: TRIS
• Created Date: Jul 5 2000 12:00AM