Click for next page ( 60

The National Academies of Sciences, Engineering, and Medicine
500 Fifth St. N.W. | Washington, D.C. 20001

Copyright © National Academy of Sciences. All rights reserved.
Terms of Use and Privacy Statement

Below are the first 10 and last 10 pages of uncorrected machine-read text (when available) of this chapter, followed by the top 30 algorithmically extracted key phrases from the chapter as a whole.
Intended to provide our own search engines and external engines with highly rich, chapter-representative searchable text on the opening pages of each chapter. Because it is UNCORRECTED material, please consider the following text as a useful but insufficient proxy for the authoritative book pages.

Do not use for reproduction, copying, pasting, or reading; exclusively for search engines.

OCR for page 59
59 element costs, and click Save. The operation is complete when create text versions of NBMD tables first from their own spread- the output file name is listed next to the Write Costs button. sheets and data systems, and then NBMD text tables are con- The saved file can be opened in a text editor, or in most office verted to XML documents if XML files are needed for porting applications. Spreadsheets are useful for review and analysis of to other database systems or other XML-based uses. unit costs reported in this output file. Note that the Write Costs The NBMD_XML application requires two inputs: a stan- operation reports all element-level costs. Filtering operations, dard NBMD tab-text table, and an XSD schema file. Schema provided by selection boxes, are not recognized. files are provided for all standard NBMD tables. New values of unit costs and median unit costs are com- To run the application, double-click the X shortcut in the puted using the Compute Costs button. Costs have been com- NBMD root directory (Figure 30). puted for all datasets submitted for project, so this function The NBMD_XML application has a single window, input isn't needed right now. The Compute Costs function is needed buttons for Schema and Data (the NBMD tab-text table), for new datasets, or to obtain median costs for merged datasets. and an output line for the completed XML document. The The computation is slow. NBMD_XML application creates two outputs; one is an XML document and the other is a re-creation of the input text table. NBMD_XML does not overwrite existing files. Instead, newly About Tab created files are identified by the string XmlBurp at the end of The About tab lists basic information about NCHRP Proj- the file name. ect 14-15--the project in which the NBMD framework was To create an XML document for California's production developed. There are no functions on this tab. table, first load the XSD file. Press the Schema button, and navigate to the xsd directory under the root NBMD directory. A list of XSD files appears in the dialog box. Select Production. NBMD_XML Application xsd and click Open (Figure 31). The NBMD_XML application creates XML documents from The NBMD_XML application now displays the path and tab-text NBMD data tables. The anticipated use is that DOTs name of the schema at the top, and the data fields that will Figure 30. NBMD XML application.

OCR for page 59
60 Figure 31. XML schema file. be included in the XML document in the left-side listbox Mapping Data Fields (Figure 32). There is also a default file name for the output XML document, as well as a default table name. The table In the left-side listbox notice the following construction: name appears internally in the XML document as the main Dataset::Dataset record name. The construction indicates Press the Data button, and navigate to the California 2006 dataset. Select the Production_Table.txt file and press Open XML_Data_Field::Text_Data_Field (Figure 33). The Dataset fields in the XML document will be obtained, Once the data file is open, notice three changes in the record by record, from the Dataset fields in the text file. The NBMD_XML window: NBMD_XML application takes field names from the XSD schema, compares these to column headings in the tab-text 1. The output file points to the directory that contains the file, identifies matching fields, and reports the mappings. input txt file. This is generally where the XML document Usually, this process is automatic. should go. To select a different directory, press Table Out, Mapping can be changed by users. In the left-side listbox, navigate to the directory of your choice and provide an select DOT_Activity_ID, and press reset. Note that its prior output filename. mapping is removed. Select Data_Activity_ID in the left-side 2. The data fields available in the txt file are listed in the right- listbox, and NBMD_Component in the right-side listbox side listbox of the application. (Figure 34). 3. The XML data fields have been mapped to corresponding Press Map. Now the XML field for DOT_Activity_ID will txt data fields. be filled with entries from the NBMD_Component field. Now

OCR for page 59
61 Figure 32. XML data fields. Figure 33. Tab-text table.