Below is the uncorrected machine-read text of this chapter, intended to provide our own search engines and external engines with highly rich, chapter-representative searchable text of each book. Because it is UNCORRECTED material, please consider the following text as a useful but insufficient proxy for the authoritative book pages.
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis Appendix A Train Door Database Design Documents A1 Database Design Notes and Tools for in-Depth Analysis A database is a set of related tables in which the data is stored. For the traindoors.com database, the tables reflect the data collection forms used to survey the information on detailed door systems: types of door failures, failure causes, components, operating procedures, environmental conditions and so on, which were collected from the responding transit agencies and stored in these tables. The tables for the database were created in MySQL for PHP for reasons noted above. As also shown above, traindoors.com will provide two pre-formatted data output sets: ⢠Display selected or complete results for a single transit agency. ⢠Display selected results for equivalent items across all transit agencies. The Train Door team encourages in-depth analysis of data from the traindoors.com website. Accordingly, the website provides tools for users who want to explore more complex data relationships. This is important, because it is not practical to pre-select all useful combinations of selected variables from separate tables. Presently there are approximately 191 different data items embedded in 28 separate tables. For the user who wants to probe deeper into the available data, or to view it in a different form, the traindoors.com website permits the user to download selected tables from a drop-down list into an Excel file. This file or files can be used for manipulation as a spreadsheet or flat file for sorting, graphing etc., or in turn be exported to Access or other database applications for the conditional extraction of data. As shown above, traindoors.com makes two key design provisions: ⢠At www.traindoors.com/database.html, a user can find the complete structure of the MySQL database tables, as well as introductory material describing the database structure. For reference when selecting a table from the drop-down list, field and table names are listed and defined in this set of data dictionaries which is listed: 1. By survey response field, organized by survey headings, 2. By field name and table where it appears 3. By table name, and the fields (field name) within the table. ⢠At www.traindoors.com/export.html, a user can export the contents of some or all of the database tables to an Excel-compatible spreadsheet format. TCRP Web-Only Document 28 Page A-1 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis With these two resources, a user can take data sets, generate new queries and combinations of data, and create reports with many different analytic purposes. Because the Train Door team wanted to give the user the option to make use of the tables directly by downloading a selected table or a set of specific tables the data into Excel (or Access or other file management application), a. The tables are not normalized. Normalized data tables are organized to eliminate or minimize redundancy in stored data. This makes for more dependable data maintenance, but it makes individual tables hard to read. For example, the information about transit agency and car class appears in many data tables in the Train Door database, making it easier to see what the table is describing. b. Data in the tables is already formatted for display, and c. Embedded foreign keys are not used. With normalized data tables, a foreign key links from one table to data in another. In the Train Door database, each table holds all the entries needed to respond to a question. Thus, the technical user who downloads a table or a set of tables can manipulate or extract the data as it appears in the file as is, when exported to Excel. A2 Database Design Documents The documents in this section are the design documents for the Train Door database. Table A2-1 is an overview of the Train Door database structure, which lists the principal design documents and database tables. Following documents are as cited in Table A2-1. TCRP Web-Only Document 28 Page A-2 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis Table A2-1 Train Door Database Design Documents and Database Tables Table Contents Tables Index List of tables in Traindoors database, showing function, table name, reference to survey, and category (transit agency or car class). Data Dictionary I. Listed by survey response fields II. Listed by field and table name in database. III. Listed by database table name Transit Agency tables transitprop Field Questionnaire tpcontact Field Questionnaire fleet Fleet Survey (repeated under fleet tables below) Failure Tables (for the Seven Door Failures Questionnaire) fcause Door Questionnaire Read-Only ftype Door Questionnaire Read-Only idfcause Door Questionnaire Read-Only convertseq Door Questionnaire Read-Only failures Door Questionnaire Fleet (Transit Agency) Tables fleet I Fleet Survey Q1 tpoperating I Fleet Survey Q3, Q4, Q5 tpdelays III Operations Q1, Q2, Q3, Q5 tpseasons III Operations Q6 Car Class Tables ccdelays III Operations Q4, Q5 ccincidents III Operations Q7, Q8 ccops III Operations Q9 ccdrops II Equipment Q1 cclinks II Equipment Q2 ccpanels II Equipment Q3 cchangers II Equipment Q4 ccrelays II Equipment Q5 ccmpdoor II Equipment Q6 ccmpcar II Equipment Q7 ccwire II Equipment Q8 ccedges II Equipment Q9 ccelectric II Equipment Q10 ccplates II Equipment Q11 ccbotts II Equipment Q12 ccdoors read-only look-up table Read-Only Appendix Populated Read-Only tables. Fcause Ftype idcause convertseq ccdoors TCRP Web-Only Document 28 Page A-3 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-4 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-5 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-6 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-7 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-8 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-9 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-10 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-11 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-12 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-13 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-14 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-15 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-16 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-17 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-18 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-19 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-20 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-21 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-22 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-23 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-24 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-25 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-26 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-27 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-28 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-29 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-30 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-31 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-32 November 4, 2005
Appendixes to TCRP Research Results Digest 74: Train Door Systems Analysis TCRP Web-Only Document 28 Page A-33 November 4, 2005