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.

Language

  • English

Media Info

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

Subject/Index Terms

Filing Info

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