Home
user manual ncsu concrete materials database program
Contents
1. Ag 91 WU OF WH 1320 01 l TUSIS INTHd t may Land wid masy 7 anora 71 NOISTIONOS T 2 U AND TABLE R 1 Execute Query Statemeat and Send to File 2 Execute Query Statement and Sead to Lotus 3 Execute Complex Query SQL 1 Query Involves Table A only 2 Query Involves Table B only 3 Query Invioves Base Table and Table A 4 Query Invloves Base Table and Table B 5 Query Involves Table A and Table B 6 Query Involves Base Table Table A and Table B 1 Query Involves Tabie A only 2 Query Involves Table B only 3 Query Invioves Base Table and Table A 4 Query Invioves Base Table and Table 5 Query Involves Table A and Tabie B 6 Query Involves Base Tabie Table and Table 55 Appendix Sample Database 56 Base table Art ID Year Author Title A2012 1983 BROOKS J J PROPERTIES OF ULTRA HIGH STRENGTH CONCRETE CONTAINING SUPERPLASTICIZER A2009 1981 CARRASQUILLO R L PROPERTIES OF HIGH STRENGTH CONCRETE SUBJECT TO SHORT TERM LOAD Conclusion table Art ID Concl Conclusion A2012 1 Concretes with and without superplasticizers were tested under short term and long term one year to quantify the effects Eighteen 4 in cubes were tested for compressive strength Eighteen 6x12 in cylinders were tested for indirect tensile strength Eigh
2. Another help message box and a different prompt SAVE TO A FILE NAME default ext LST appears on the screen At this prompt you are asked to provide a filename to save the query result Enter QRYDATA and press lt Enter saving the resultant data to QRYDATA LST under your working directory Another help message box and a different prompt Enter values to the columns appears on the screen At this prompt you are asked to name the columns that you want to save Be aware that the columns you specified in Step 3 have not been saved because those columns are used only for formulating the query statement Enter BART ID W C RATIO CUR AGE TST CHEMI ULT_STRS1 then press lt Enter The screen will display the requested data as in Figure 3 2 b and at same time the program saves the data to a file You can save more columns to the file At the end of displayed data enter and press Enter to regenerate the prompt Enter values for columns Then you can enter seven more columns In fact you can save as many columns as you want by repeating this step But for this exercise let s stop and enter EXIT to exit and return to the menu QRYDATA LST is a text file saved under your working directory You can access and edit it by logging off the NCSU Database program and bringing the file up in any word processor program Summary You have worked an example on how to query Table and Table B In summary the procedures a
3. gt SHRP C UWP 91 502 User Manual NCSU Concrete Materials Database Program William K Chi North Carolina State University Strategic Highway Research Program National Research Council Washington D C 1991 SHRP C UWP 91 502 Contract C 205 Product Code 2014 2023 2024 Program Manager Don M Harriott Project Manager Jawed Program Area Secretary Ann Saccomano January 1991 Reprinted November 1993 key words computer concrete database fiber reinforced concrete manual materials mechanical properties reinforced concrete relational database user manual Strategic Highway Research Program National Research Council 2101 Constitution Avenue N W Washington DC 20418 202 334 3774 This manual represents the views of the author only and is not necessarily reflective of the views of the National Research Council the views of SHRP or SHRP s sponsor The results reported here are not necessarily in agreement with the results of other SHRP research activities They are reported to stimulate review and discussion within the research community 50 NAP 1193 Acknowledgments The research described herein was supported by the Strategic Highway Research Program SHRP SHRP is a unit of the National Research Council that was authorized by section 128 of the Surface Transportation and Uniform Relocation Assistance Act of 1987 SHRP Contract C 205 is concerned with an investigation of the mechan
4. 48 49 50 61 52 60 62 66 Article Specimen ID Specimen Specimen Ageat Strength Ult ID Type Size Testing Test Stress 1 A2012 1 500P CUBE 4 1 FC 5293 A2012 1 500P PRISM 4 x4 x20 1 A2012 1 500P PRISM 4 4 20 1 2012 1 500P 6 12 1 421 2012 2 500 4 28 11310 2012 2 500P PRISM 4 x4 x20 28 A2012 2 500 PRISM 4 x4 x20 28 48 49 50 78 79 81 82 83 Article Specimen Mix Modulus Modulus Creep Sp Creep Age at ID ID Type Value Stress Loading A2012 1 500 2012 1 500 SEC E 4 34 2012 1 500P DYN E 5 7 A2012 1 500 2012 2 500P 2012 2 500 5 52 2012 2 500 DYN E 6 86 A2012 2 500 Table table rmula Graph database Art ID F GID Dep Var Ind Varl Ind Var2 Ind Var3 A2009 G4 fc Cornell fc Pauw Present Study Ind Var4 Ind Var5 Relation Note Fig 5 Static modulus of elasticity versus sqrt f c 59 FKW table keyword table for Formula Graph database Art ID F G ID Keyword A2009 1 HIGH STRENGTH A2009 1 MODULUS ELASTICITY 60 Appendix Field Names and Definitions 61 TABLE NAME BASE TABLEA 62 FIELD NAMES AND EXPLANATIONS TABLES AND B COL NO FIELD NAME 0 ART 0 AUTH 0 TITLE 0 YEAR 1 AART ID 2 ASPE ID 3 AMIX ID 4 CMT TP 5 CMT QTY 6 MIN ADM TP 7 MIN ADM QTY 8F AGG TP 9 F AGG QTY 10 AGG MOIST 11 C AGG TP 12 C AGG NMSA 13 C AGG QTY 14 C AGG MOIST 1
5. CONCL conclusion 1 6 keyword KWes CREEP You can exit at any time by enter ctri z J J Oh KL 33 34 CONCLUSION DATABASE DISPLAY SCREEN VO CREER STARA 1 ART AUTH YEAR TITLE CONCL articie 10 author s name year of publication title of an article conclusion keyword Enter columns names that you want 10 display while formulating the query Example ID ASPE 1D CMT TP CMT Keep the number of columns to maximum of 7 allows results to display across one screen ou can exit at any time by enter ctr 2 Enter values for columns Enter query statement here Example CMT TP AND MIN ADM TP FUME Enter order statement here Example ULT STRS1 CUR TM 35 36 Following procedures save above query into a lile Please note 1 Maximum of 7 columns can be selected at a time 2 Enter to regenerate more columns 3 Enter lt ctri gt z to exit EXIT Enter values for columns Enter columns names that to be displayed in Lotus article ID ART Z1000 figure graph 10 FG_IDe FT author s name AUTH LIKE 214 year of publication YEAR 1979 title of an articie keyword KWeCREEP article ID 4 figure graph ID author s name year of publication title of an article conclusion keyword 38 PRINT FIELD NAMES AND LIST OF VALUES FIE
6. Unless you log in with correct username and password you can not access the example data in the tables 5 Browse through the help message to get general idea how to perform queries 6 Press alt s to prompt the user defined commands 7 Select the command COLUMNS A table which lists out the field names and short explanations appears These fields belong to the Base Table and Table and Table B that you can access You can browse through remaining fields by using the down cursor key There should be a total of 114 entries 8 Change N to Y in the DISP column where the column numbers 48 25 42 60 16 and 66 Y indicates to the program that the field is to be displayed Make sure no other cells on the DISP column contain Y If they do change them to N 9 Press lt alt gt s again to bring up the user defined commands This time select the command CRITERION ORDER This command will bring up a blank area with a left parenthesis at top left corner You can enter the where clause and the order clause in this area The left parenthesis is a reminder to you that the where clause needs to be enclosed by parenthesis 10 Enter the where clause and the order clause as shown in Figure 3 3 Make sure the where clause is enclosed by parenthesis 11 gt Press alt s again and select the command EXECUTE This command will execute the where clause and the order clause that you entered If there is an inpu
7. working directory 2 Log in to SQL Plus then type ASSIGN to execute ASSIGN script ASSIGN script assigns 3 default users and their passwords they USERI USERI 23 USER2 USER2 USER3 USER3 addition a fourth user the creator of tables used in the program is designated as CHI CHI 2 Log off SQL Plus and retum to DOS prompt then type IMP to execute Oracle import utility A list of prompts will guide you through the steps Accept defaults on all the steps Afer all the tables are imported exit the import utility by pressing period Refer to Chapter 2 Oracle Utilites for detailed explanations 4 The three default users must be assigned by the DBA to access SQL Menu The steps are listed below Refer to Chapter 8 SQL Menu User s Guide for detailed explanations 4 1 SQLMENU and then press lt Enter to start SOL Memu 4 0 Select Option 1 SQL Menu Development of Dynamic Menus 4 3 Select Option 4 Creating of a new user of SQL Menu 4 4 On the Grantee field enter USERI and then press Enter The cursor jumps to the Grant option field Leave the field blank by pressing lt Enter 4 5 Repeat Step 4 4 two more times to assign USER2 and USER3 Assigning New Users The program comes with three default usernames and passwords USER1 USER1 is the default username and password for level 1 users Similarily USER2 USER2 is for level 2 users and USER3 USER3 for level 3 users A person wi
8. 1 ULTIMATE ID RATIO days days TYPE STRESS 8209012 500 28 00 28 000 10750 000 A2012 224 28 00 28 000 11920 000 A2012 360 28 00 28 000 11510 000 A2012 4270 28 90 28 000 SUPERPLASTICIZER 12905 000 2012 27 28 00 28 000 SUPERPLASTICIZER 15650 000 14 1 2 3 4 5 6 7 8 9 0 W_C_RATIO lt 0 4 AND _ 28 AND AGE TST 28 STRGTH TSTTPs FC ORDER BY ULT STRS1 FIGURE 3 3 CRITERION ORDER SCREEN ORACLE FOR 1221 pages Art ID F G ID Year Author Title Dep Ind Ind Ind Ind Ind Var Var is 23 Var 5s Var 41 Var 5 Relation Note 3 Art_ID F G ID Year Author Title 8 Ind Ind Ind Ind Ind Var Vari 23 Var 53 4 Var 5 Relation Note 2 records SHRP 20 FIGURE GRAPH DATABASE QUERY RESULT 2009 62 1981 CARRASQUILLO L PROPERTIES OF HIGH STRENGTH CONCRETE SUBJECT SHORT TERM LOADS Stress strain high strength strain strength strain normal strength Fig 2 Typical stress strain curves of normal medium and high strength concrete stroke rate 2 000 micro in min 4 x8 cylinder A2009 1981 FROPERTIES OF HIGH STRENGTH CONCRETE SUBJECT SHORT TERM LOADS stress strain high strength strain medium strength strain normal strength Fig 3 Typical stress strain curves of normal medium and high strength concrete stro
9. 3 Formula Graph Database 7 4 Print Reference Lists 7 5 Figures Input Mod 8 1 Table Input Form 8 2 Conclusion Input Form 8 3 Table A Input Form 8 4 Table B Input Form 8 5 Formula Graph Input Form 8 6 Figures Maintenance Mode 9 1 Reference Keyword Lists Input Forms 92 List of Values Input Form 93 Figures Oracle For 123 9 O oe o 0 oe 9 o y 6 G 9 9 o O 9 9 9 PART I USER MANUAL Login Login procedure for the NCSU Materials Database is simple First make sure you are in the working directory drive shrp is the default Then follow the steps below to access the program l Enter SHRP and then press Enter to start the program 2 You are prompted to enter your username and password Enter your username and press Enter Then enter your password and press Enter Alternately you can enter USERI as the username and USER1 again as the password to gain access to the program s query mode USER1 USER1 is the public username and passwor
10. Transportation Officials Lillian Wakeley USAE Waterways Experiment Station
11. asked to enter the columns that you want to display on the screen Enter W C RATIO CUR TM CHEMI TP STRGTH TSTTP ULT STRSI then press lt Enter 5 Another help message box and different prompt Where gt appears on screen At this prompt you are asked to provide the where clause Enter W C RATIO 0 4 AND CUR TM 28 AND TST 28 AND STRGTH_TSTTP FC Be sure you have entered all the information correctly Do not press lt Enter gt in middle of the where clause The program automatically wraps to the next line Different parts of a field name are connected with the underscore not the dash the character strings have to be enclosed with single quotations At this point the screen should resemble the Figure 3 2 a Press lt Enter gt to continue 10 Another help message box and a different prompt Order gt appears screen At this prompt you are asked to tell the program the order you want to display Enter ULT STRSI1 telling the program to sort data according to strength value in ascending order Press Enter to start displaying the result on the screen Five records should be selected If the result is not what you are looking for and you want to exit press ctrl z to go back to the menu screen Let s assume the queried result is acceptable and you want to save it into a file At the end of the displayed data a message Enter to continue appears on the screen Press Enter
12. list of values associated with that field appears on the screen Move the cursor to the LIST OF VALUES field and to the next available cell Enter the new value Press lt F10 gt to commit the change 9 3 Figures INPUT FORM CONCLUSION TABLE KEYWORD LIST 48 INPUT FORM FORMULA GRAPH KEYWORD LIST LIST OF VALUES INPUT FORM TABLES A AND B SE 49 10 Oracle For 123 In this chapter a set of macros in ORACLE FOR 123 is described Users can use this set of macros to query Table and Table B Database ORACLE FOR 123 is a Lotus add in tool Having Lotus spreadsheet attached to ORACLE RDBM enhances the data manipulation capability of ORACLE Since numeric data manipulation is the main task in Table A and in Table B ORACLE FOR 123 presents a better alternative in querying Table A and Table B Access Oracle For 123 Exit out to the DOS prompt then type ORA123 and press lt enter gt Bring Up ABQRY WKI1 The query procedures are stored as a set of macro in a Lotus file called ABQRY WK1 Use normal Lotus commands to bring up the ABQRY WK1 Query Steps The steps to query table and table B are stored as menu commands These are outlined below You can access the menu commands by pressing lt ctrl gt s at any time Columns Select this command to choose the fields you want to display The only enterable field is the DISP while other columns are protected Only or should be ent
13. s name of an article AUTH is a character string YEAR is the year of publication YEAR is a 4 digit number TITLE is the article title TITLE is a character string CONCL is the conclusion number for a particular article In articles where there are more than one conclusion conclusions are numerically sequenced starting at 1 KW is the keyword KW is a character string Execution Complete If syntactically correct following messages will appears on the screen records updated Enter 10 return indicates the number of conclusions selected Press lt Enter to return to the menu screen Input Error syntactically incorrect the program will display an error message Press Enter or lt ctrl gt z to return to the menu screen and select this option again Limitation A total of 128 characters can be entered Every nomenclature can only be used one time per where clause Menu Screen Query Conclusion Database Option 2 Display Query Result Select this option to view the conclusions that have satisfied the most recent query form like Figure 7 2 appears on the screen You can browse through those conclusions and opt not print certain conclusions Browse You can browse through the selected conclusions Up cursor key display the previous conclusion The Dn cursor key goes to next the conclusion display order is always by article ID number and within the article ID number by the conclusion number
14. to the printer or save it to a file Select Option 2 Print to Printer 8 After you select option 72 a new help message box and the ORDER prompt appears on the screen At this prompt you need to provide the order in which result should be displayed Enter YEAR AUTH to tell the program to display result by year in ascending order and within the year by author s name also in ascending order Press Enter to continue Then the message ready the printer appears Make sure your printer is turned on At this point your screen should be like Figure 3 1 c 9 Press lt Enter to start printing Once printing is completed the program automatically returns to the menu screen Summary You have learned now how to query the conclusion database In summary to query the conclusion database 1 Navigate through the Application Menus to the Query Conclusion Database screen 2 Select Execute Query Statement option and enter your where clause 3 Select Display Query Result option and browse through result to make sure is what you want 4 Select Print Query Result option and then select the option to print the query result to the screen the printer or a file 3 3 Example On Querying Table A And Table B Goal You want to see what experimental data are available on the compressive strength that have water cement ratio of 0 4 or less and are cured until testing at 28 days Preparation Except the simplest searc
15. 0 SQL MENU version 4 1 SQL FORMS version 2 3 ORACLE FOR 123 version 1 0 optional 21 their higher versions Although ORACLE FOR 123 is not required to run the program it is strongly recommended addition to run ORACLE FOR 123 you must also have Lotus version 2 1 installed 22 Installation and Assigning Users This section shows how to install the NCSU Materials Database Program The person who is to perform the installation and to add new users must have the DBA privilege Installation Before you attempt to install the NCSU Database program make sure your system has adequate hardwares and softwares Make sure the ORACLE RDBM SQL Plus SQL Menu and SQL Forms are properly installed And if you have ORACLE FOR 123 that should also be installed If you need to install any of the products refer to Oracle Application Tools for MS DOS Getting Started booklet The installation process involves four steps 1 copy program files to the working directory 2 assign default users to the system 3 install tables and example data and 4 assign default users to the SOL Menu Only the user with the DBA privilege can perform installation These four steps are described below l Create a working directory where all the program files will be stored For example on a PC you can create a directory named shrp under drive c c shrp then copy all the files from the NCSU Concrete Materials Database Program micro diskette into the
16. 5 AGG_GRADN 16 17 18 2 19 2 20 21 22 PLYMR TP 23 PLYMR QTY 24 WATER QTY 25 W C RATIO 26 BATCH LOC 27 QTY PRD 28 MIX TM 29 TM DRUM 30 PLAST TST 31 WRK_TSTMD 32 WRK_VAL 33 AIR_TSTMD 34 AIR TST VAL EXPLANATION author s name article title year of publication article id specimen id 7 mix id cement type cement quantity pcy mineral admixture type mineral admixture quantity pcy fine aggregate type fine aggregate quantity pcy fine aggregate moisture condition coarse aggregate type coarse aggregate NMSA in coarse aggregate quantity pcy coarse aggregate moisture condition aggregate gradation curve Lotus filename chemical admixture type 1 chemical admixture 1 quantity oz cwt chemical admixture type 2 chemical admixture 2 quantity oz cwt chemical admixture type 3 chemical admixture 3 quantity oz cwt polymer type polymer quantity oz cy water quantity pcy water cement ratio batch location quantity produced cy mixing time min time in drum min plastic test location workability test method work ty value in or sec based on work ty type air test method air test value 96 35 UWT PLAST 36 UWT AIRDRY 37 TEMP 38 MEMBER TP 39 PLACE MD 40 FNH MD plastic unit weight pcf air dry unit weight pcf concrete temperture deg F member type placement m
17. 7 58 59 60 61 LOAD AGE 5 STRESS DISPL MOIST TEST APPL STRAIN COND TEST METHOO 45 TABLE F INPUT FORM DEP VAR IND VAR1 IND VAR2 IND VAR3 INO VAR4 IND VARS RELATION NOTE PAGE 1 Maintenance Mode In this chapter each maintenance form will be described in detail 9 1 Reference Keyword Lists Input Form for Conclusion Database Reference Keyword List Input Form for Formula Graph Database Reference Keyword List You can add new keywords to the reference keyword lists These two forms are shown in Figure 9 1 and Figure 9 2 most updated version of the reference lists are reflected when you access either the Conclusion Input Form or the Formula Graph Input Form Each keyword can have up to 30 characters long Most Commonly Used Function Keys up move to previous keyword dn move to next keywword F10 commit change 47 9 2 List Of Values Input Form You can enter additional values into the LISTVAL table so Table A and Table B can reference them The form is shown in Figure 9 3 Enter New Value Entering new value into the LISTVAL table is a three step procedure First enter and execute a query to select those records corresponding to the field you want Second enter the new value or term Third commit the change Press F7 Move the cursor to FIELD NAME field and then enter the field name you want to add values Press lt F8 gt to execute the query and the
18. BART ID TAB2 BART ID AND TABI BMIX TAB2 BMIX AND ULT STRS1 5000 AND STRS gt 40 Such SQL statement extracts the correct information Notice that and 2 are synonyms of Table B and are joined together based on article ID numbers and mix ID numbers Notice also that the specimen ID numbers are not joined Table B is a big table and a join operation combining two big tables involves a lot of data and will require a lot more processing time Unless your system is fast be prepared to accept slower performance Above query command introduces the concept of joining table by itself Depending on your needs some variations of query commands may be required Recommendation Complex queries need time to formulate and refine Since SQL Plus provides the means to save query commands in batch files you can build a library of batch files So if similar queries are needed you do not need to start from scratch 71 Concrete and Structures Advisory Committee Chairman James J Murphy New York Department of Transportation retired Vice Chairman Howard H Newilon Jr Virginia Transportation Research Council retired Members Charles J Arnold Michigan Department of Transportation Donald E Beuerlein Koss Construction Co Bernard C Brown Iowa Department of Transportation Richard D Gaynor National Aggregates Association National Ready Mixed Concrete Association Robert J Girard Missouri Highway and Tr
19. Graph designation here For example F1 stands for formula no 1 an article 1 stands for graph no 1 for an article This field is alphanumeric DEP VAR Description of the dependent Variable in a graph A maximum of 80 charactors can be entered IND VAR Description of independent variables Up to five independent variables can be entered and each accept up to 80 charactors RELATION Description of the relation between independent variables and dependent variable For a formula the equation can be entered here A maximum of 240 charactors are allowed NOTE Any additional comments can be entered here A maximum of 240 charactors are allowed KEYWORD You can access the KEYWORD block by pressing lt ctrl gt lt PgDn gt Select the desired keyword from the REFERENCE KEYWORD LIST block You can do this by pressing the Enter key to jump to the REFERENCE KEYWORD LIST block Then move the cursor to the desired keyword and press Enter You can return to the main screen by pressing ctl PgUp 42 Most Used Function Keys F10 commit lt ctrl gt lt PgDn gt to next block lt ctrl gt lt PgUp gt to previous block enter next field F7 enter query F8 execute query 8 6 Figures 43 44 1 KEYWORD INPUT FORM CONCLUSION TABLE PAGE 2 2 FIGURE 8 3 PORTION OF TABLE INPUT FORM 51 52 53 54 55 58 SPE SPE MOLD CAP GRP PLATEN GCE 5
20. LD TABLE BREE 4 v 2 ht eee 9 2 M KM OR PRINT IN Ji D ANT D Input Mode In this chapter each input form will be described in detail 8 1 Base Table Input Form You can input general information about an article in the Base Table Input Form The form is depicted in Figure 8 1 ART ID Enter the article ID number in this field It must be a distinct five character string YEAR Enter the year of publication YEAR should be a 4 digit number DATA Enter Y or N to indicate whether numeric data is to be included in Table A and Table B 39 AUTHOR S Enter the first author s name last name first then the initials For example Ahmad S to 30 characters can be entered in this field TITLE Enter the title of the article Up to 240 characters can be entered in this field Most Commonly Used Keys F10 commit enter next field F7 enter query F8 execute query 8 2 Conclusion Input Form You can enter conclusions in this input form as well as assign keywords The form is depicted in Figure 8 2 ART ID Enter article ID number It must be a five character string CONCL NO Enter the conclusion number for an article starting with 1 CONCLUSION Enter up to 10 lines of text as shown on the screen KEYWORD You can access the KEYWORD block by pressing lt ctrl gt lt Pgdn gt Select the desi
21. Update Print Field The only field that can be updated in this form is the PRINT field You can enter to indicate that particular conclusion not to be printed Make sure you press F10 to commit the change 26 See Keyword List To see keyword list for a conclusion Press lt ctrl gt lt PgDn gt Press ctrl 5 lt PgUp gt to return Menu Screen Print Query Result Conclusion Database Option 1 Print Query Result to Screen Opyion 2 Print Query Result to Printer Option 3 Print Query Result to file The procedures for these three options are very similar thus will be discussed together Select one of the three options to print the selected conclusions to the screen to a printer or to a file Before printing the program asks for the display order A help message box and a prompt shown in Figure 7 3 appears on screen At The Prompt Enter the display order you want and then press lt Enter to start printing You can embed display orders you also can display records either in ascending or descending order The default order is ascending order For example ENTER ORDER YEAR DESC AUTH will display records by year in descending order and within the year by first author s name in ascending order Input Error Ifan syntax error is made an error message appears You can return to the menu screen by pressing lt ctrl gt z or enter You can select this option again because query result is not lost Print To P
22. aintenance Mode There are three operations you can perform in the maintenance mode You can enter new values 18 into the LIST VALUES table where Table and Table can access you also can enter new reference keywords for the Conclusion Database and the Formula Graph Database Since steps are fairly simple and are very similar with other input forms only an outline of the procedures is listed below List of Values Input Form 1 Navigate through Application Menus to Maintenance Mode screen and select List of Value Table Input Form A blank form with two columns appears on the screen 2 Press F7 Enter Query The form goes blank Move cursor to the Field Name column Enter the field name then press F8 Execute Query The screen will display the existing values 3 Move the cursor to the next blank cell and enter the new value Press lt 10 gt to commit the input You can exit by pressing lt Esc gt Reference Keyword Lists For both Conclusion Database and Formula Graph Database the procedure to input new keyword into the reference keyword lists is the same so it will be discussed together 1 Navigate through Application Menus to Maintenance Mode screen and select either Conclusion Reference Keyword List or Formula Graph Reference Keyword List 2 form with the existing keywords appears Move the cursor all the way to the next blank cell and enter the new keyword Press F10 t
23. an article 5 CONCL conclusion CONCL 6 KW keyword KWs CREEP You can exit at any time by enter lt gt 2 ENTER QUERY YEAR gt 1983 AND KWz CREEP S Records Updated Enter to return FIGURE 3 1 CONCLUSION DATABASE WHERE CLAUSE CONCLUSION DATABASE DISPLAY ART IDESESSCONCL4ESipR INTE L NC AS 1 ART article ID 2 2 AUTH author s name 3 YEAR year of publication 4 TITLE title of an article 5 2 conclusion 6 KW keyword ENTER ORDER YEAR AUTH Ready the printer Enter to start FIGURE 3 1 c CONCLUSION DATABASE ORDER SCREEN Enter columns names that you want to display while formulating the query Example 10 ASPE 10 CMT CMT QTY Keep the number of columns to maximum of 7 allows results to display across one screen You can exit at any time by enter lt ctri gt z Enter values for columns C RATIO CUR TM CHEM1 TP STRGTH TSTTP ULT TRS1 Enter query statement here Example AND MIN ADM TP FUME WHERE W_C_RATIO lt 0 4 AND CUR 28 AND AGE TST 28 AND STRGTH TSTTPsFC FIGURE 3 2 a TABLE AND TABLE EXAMPLE QUERY WATER CUR ING CHEMICAL ARTICLE CEMENT TIME AGE 9 TEST
24. and press lt Enter to execute Keep the number of fields to a maximum of 7 at a time so data can be saved across the width of a page You can save more fields by entering to regenerate the prompt If you make input error an error message will display on the screen Do not worry because your where clause and order clause are not lost just enter to regenerate the prompt and enter the correct field names again Finally you can exit at any time by pressing ctrl 2 or enter EXIT and press Enter If data destination is Lotus spreadsheet a help message box and a prompt as in Figure 7 8 appear on the screen At the prompt enter field names that are to be displayed in Lotus and press Enter to execute Since the data destination is not file you can enter more than 7 fields at the prompt but you can not add more fields by regenerating the prompt the other hand if you have made an input error you can try again by entering to regenerate the prompt To access data in the Lotus spreadsheet log off the Application Menus boot up the Lotus spreadsheet and select the file ABVIEW The data will automatically show starting at cell Al 29 Limitation At each prompt the five steps described above maximum of 128 characters accepted Therefore this method of querying Table A and Table B is viable only for a few columns and a simple where clause In addition until Step 4 there is no way to edit y
25. ansportation Department David L Gress University of New Hampshire Gary Lee Hoffman Pennsylvania Department of Transportation Brian B Hope Queens University Carl E Locke Jr University of Kansas Clellon L Loveall Tennessee Department of Transportation David G Manning Ontario Ministry of Transportation Robert G Packard Portland Cement Association James E Roberts California Department of Transportation John M Scanlon Jr Wiss Janney Elstner Associates Charles F Scholer Purdue University Lawrence L Smith Florida Department of Transportation John R Strada Washington Department of Transportation retired Liaisons Theodore R Ferragut Federal Highway Administration Crawford F Jencks Transportation Research Board Bryant Mather USAE Waterways Experiment Station Thomas J Pasko Jr Federal Highway Administration John L Rice Federal Aviation Administration Suneel Vanikar Federal Highway Administration Expert Task Group Amir Hanna Transportation Research Board Richard H Howe Pennsylvania Department of Transportation retired Stephen Forster Federal Highway Administration Rebecca 5 McDaniel Indiana Department of Transportation Howard H Newlon Jr Virginia Transportation Research Council retired Celik H Ozyildirim Virginia Transportation Research Council Jan P Skalny W R Grace and Company retired A Haleem Tahir American Association of State Highway and
26. can exit the Base Input Form by pressing lt Esc gt Select the second option Conclusion Input Form In this form you can enter the conclusion and its keywords Make sure you commit your input by pressing lt F10 gt To enter keywords for a conclusion press lt ctrl gt lt PgDn gt A reference keyword list is displayed on the right You can either type in the keywords or you can select keywords from the reference list To select a keyword press Enter cursor jumps to the reference keyword list block Then use the Up or Dn cursor keys to browse the list When the cursor rests on the reference keyword you want press Enter again to accept You can repeat this step to input all the keywords you need to enter Make sure you commit your input by pressing lt F10 gt Press lt ctrl gt lt PgUp gt to go back to the conclusion block If you have more conclusions for the article you would repeat Steps 4 6 4 3 Input Data Into Table A And Table B Input data into Table A and Table B involves the Table A Input Form and Table B Input Form In addition if no entry for an article is made in the Base Table you also need the Base Table Input Form 17 Steps l Navigate through the Application Menus to the Input Mode screen Select the third option Table Input Form 2 When you input data into the form keep in mind following items a Pressing lt Enter gt when the cursor is in the last field will bring up th
27. clause and then display result on screen 4 enter the filename if the result is to be saved to a file 5 enter the columns you want to save to the file or to Lotus Step 1 Select an option that matches the type of query you intend to perform You should select the option in which all the fields that you will use is included That includes field names in specifying columns field names the where clause and field names in the order clause After you press Enter key a help message box and a prompt as in Figure 7 4 will appear on the screen At the prompt enter up to seven field names separated by commas that you want to display the screen Then press lt Enter to proceed The field names must correspond to the list in Appendix C and are capitalized Be aware that the fields you entered at this prompt do not have to be contained in the where clause The purpose of displaying these fields is for you to examine the query result and decide whether the result is satisfactory They are not saved to a file or to Lotus Step 2 After you pressed lt Enter another help message box and a new prompt as in Figure 7 5 appears You are asked to enter the search criteria at this prompt At the prompt enter the where clause and press Enter to proceed The field names are used in the where clause Make sure names agree with the list in Appendix C and character strings are enclosed in single quotations Boolean operators are used in f
28. d that come with the program However your database administrator DBA may have deleted the public username and password for security reason If neither methods succeed consult your DBA or refer to Chapter 6 Application Menus In this chapter you will learn how to move around the Application Menus the NCSU Database program s menu system different levels of access that the program employs to ensure security will also be discussed Once you have logged in successfully you will be viewing the APPLICATION MENU screen Depending on your assigned user level you are accessing all or a sub set of the program There are three user levels l Level 1 users can only access query mode 2 Level 2 users can access query mode and input mode 3 Level 3 users can access the entire program which includes query mode input mode and maintenance mode There are several layers of menus that can guide you to the desired operation The complete Application Menus chart is shown in Appendix A Move Around the Menus You can navigate through the Application Menus with two interchangeable methods of selecting options number entry and cursor position entry To select an option you 1 enter the number that corresponds to that option and then press the Enter key 2 move the cursor to that option and then press the lt Enter key There are two function keys that you will use quite often in the Application Menus F2 key displays help messag
29. e second page b Instead entering values you can select a value at those fields that contain a list e g Cement Type Press F9 to display the list of values Browse the list and make your selection by pressing Enter From second page on cursor can not enter the first three fields ID AMIX ID and ASPE ID They are for display only d You can copy the previous value in the field by pressing F3 3 Commit your input by pressing lt 10 gt Then press lt Esc to exit back to the menu screen The procedure of inputting data into Table B is identical except one minor detail Since Table B s size is large Table B Input Form is divided to three parts Column 48 58 is contained in Part I column 59 89 in Part II and column 90 114 in Part III You can access each part by selecting the appropriate options Input data into Part I is identical to input data into Table A In part II and Part III in order to make sure no duplicate records are inputted the program does not allow you to access column 48 51 You can enter and execute a query to bring out the data for the same article then enter the data in Part II and Part III as usual 4 4 Input Data Into Formula Graph Database The steps for inputting data into the Formula Graph Database are the same as for inputting data into the Conclusion Database You can follow the steps outlined in Section 4 2 to input data into the Formula Graph Database 4 5 Input Data in M
30. eported in research articles In this chapter step by step procedures are used to show you how to query each type of the databases 3 1 Sample Database When the NCSU Database program was installed a set of data was input into the database for demonstration purpose A portion of the example database is shown in Appendix B These data which will be used in the examples in this chapter are composed of three parts A total of 30 conclusions from 16 research articles are input into the Conclusion Database Partial numeric data from 2 research articles are input into the Table A and Table B Database A total of 8 formula graph information sets from 2 articles are input 4 After you finish these examples you can remove these data by running file REMOVE This will erase all the data in the database 3 2 Example On Querying Conclusion Database Goal You want to retrieve conclusions that have been drawn from research papers concerning creep that have been published after 1983 You also want to send the queried result to a printer by year and within the year by author s name in ascending alphabetical order Steps l After you have logged in successfully navigate through the Application Menus to the QUERY CONCLUSION DATABASE menu screen 2 Move cursor to the first option then press lt F2 to view help message Return to menu screen by pressing any key 3 Select the first option Execute Query Statement
31. ered in the cells indicate field selected You can select up to 50 fields at a time Keep in mind that what you select do not necessarily have to be included in the where order statement Where Order Select this command to enter the where clause and order clause of the query statement You can enter up to 10 lines of codes Be sure you enclose the where clause to ensure 50 proper operation of SQL statement Execute Select this command to execute the query statement If there is an error a message will appears on the screen In that case select WHERE ORDER again and edit the statement Data Go to the data that the query has generated The data area starts at A200 cell Init Clear all the input Initialize the Column screen so no fields are selected and clear the WHERE ORDER screen UNFREEZ In order to protect macros from accidental erasing portions of the spreadsheet are protected at times UNFREEZ disable all protection In rare occasions that you want to use this option be careful not to erase program codes HELP to the help screen for quick instruction on how to run the program Advantages To query table A and table B this way have several advantages over the previous method They are listed below 1 You can edit query statement without starting afresh 2 You do not have to concern yourself on which tables are involved in a query statement That is taken cared for you by the macro 3 There is no 128 c
32. es for a option and lt gt key jumps program to previous menu screen Go ahead and try to move around the Application Menus to get a feel of the menu system If you select an option that starts an operation you can exit that operation and return to the menu screen by entering lt Esc gt or lt ctrl gt z Additional Information NCSU Database s Application Menus are constructed using Oracle s SOL Menu tool You can refer to SQL Menu User s Guide to get better acquainted with how to use the menus Summary In this section you have learned how to log in the program and how to move through the Application Menus In summary 1 Enter SHRP to start the program 2 Enter your username and your password 3 Move the cursor to the desired option and then press lt Enter 4 Press F2 to receive help message 5 Press Home to go to the previous menu Learning How Query Data In this chapter you will learn how to query the NCSU Database based on a sample database The NCSU Database is comprised of three sub databases Conclusion Database Table A and Table B Database and Formula Graph Database The Conclusion Database contains investigators conclusions from a research article The Table A and Table B Database contains numeric data on mixes and load responses reported in research articles these data are stored in Table A and Table B The Formula Graph Database contains information on graphs and formulas r
33. ethod finishing method 63 FIELD NAMES AND EXPLANATIONS TABLES AND COL 46 FIN SET 47 MIX NOTE 48 BART ID 49 BSPE ID 50 BMIX ID 51 SPE TP 52 SPE SZ 53 MOLD TP 54 CAPGRIP TP 55 PLATN TP 56 LENG 57 STRS_APPLN 58 LD DIS STRN 59 MOIST COND 60 AGE TST 61 STRGTH TSTM 62 STRGTH TSTTP 63 PK STR 64 STRS2 65 STRS3 66 ULT STRS1 67 ULT STRS2 68 ULT STRS3 69 PK STRNI 70 STRN2 71 PK STRN3 72 ULT 8 73 ULT STRN2 74 ULT STRN3 75 POISN 1 76 POISN MULT 77 PRMRY FAIL 78 MOD TP EXPLANATION UD ED Quis SUD AXIS UD ana QUE QUEE UD iD ub tho emi dus ub um ums ub Qu Quo dui uS ama OD sam wat mwa s sme curing method curing time min treatment method service condition initial set min final set min mix note article ID specimen ID mix ID Z specimen type specimen size mold type cap or grip type planten type gage length in stress application method load stress strain rate moisture condition at test concrete age at test days strength test method strength test type peak stress in principal dir psi peak stress in y dir in biaxial test psi peak stress in z dir in triaxial test psi ult stress in principal dir psi ult stress in y dir in b
34. h most queries on Table A and Table B are rather complex Therefore it is best to formulate the query statement on paper first To do that you need to know the correct field names and the corresponding list of values given in Appendix C Three kinds of information are needed For our example The columns we want to display W C RATIO CUR TM TP STRGTH TSTTP ULT STRSI The where clause W C RATIO 0 4 AND CUR 28 AND AGE TST 28 AND STRGTH TSTIP FC The order clause ULT STRSI Notice that the columns displayed do not have to be in the where clause or the order clause However it is advisable to display all relevent columns to make sure the queried result is as intended Steps 1 Navigate through the Application Menus to Query Table and B screen 2 Select Option 1 Execute Query and Send to a File By selecting this option you are about to enter and execute a query and send the result to a file 3 new menu screen appears on the screen On this menu screen you are asked to select one of the six options that matches your query statement The rule on which option to select is always as follows select the option that contains all the fields that are used either in the column clause the where clause or the order clause In our example select Option 5 Query involves Table A and Table 4 help message box and a prompt Enter values for columns gt appears on the screen At this prompt you are
35. haracter limit 4 Data obtained can be manipulated further by normal Lotus operations Other Comments Actually you virtually have all the database management capability that are used in other parts of the NCSU Database program by using ORACLE FOR 123 alone You can input data as well as do complex queries Refer the ORACLE FOR 123 User s Manual for detail instructions 51 Appendix Application Menus Chart see Part APPLICATION MENUS 1 NCSU DATABASE 2 EXIT A NPUL MODE 1 Base Table Input Form 2 Conclusion Input Form 3 Table A Input Form 4 Table B Input Form Part 5 Table B Input Form Part II 6 Table B Input Form Part IIT 7 Formula Graph Input Form 1 MAINTENANCE MODE 1 List of Values Input Form 2 Reference Keyword Input Form Conclusion Database 3 Reference Keyword Input Form Formnla Graph Database 53 reqqa 16 7 242224 Utd p esequi 1015112000 351 pJom 2 sanjeA JO Wr Md Z sanje Jo 117 PUT SAUEN 122195 71 SISTT JONT83JTH INTAI T ep OF A TZ 0222035 01 Mild 71 TASTE t Imey ynsay on nog 1 sr oseqvre Gon c d pus y 2191 Aon 7 asequieg uoisnpouo Aand 71
36. help message box and a WHERE gt prompt appears Read the help message to get a general idea on how to enter a search criteria 4 At the prompt enter the where clause YEAR gt 1983 AND KW CREEP to indicate that you want to search articles that were published after 1983 and are on creep Press Enter to execute the query The program should then indicate 5 records are updated which means 5 conclusions satisfied the search criteria The screen at this point should resemble Figure 3 1 a Press Enter to return to the menu screen If you have an input error the program will display an error message You can exit the operation by pressing lt ctrl gt z then select the option again and redo Step 4 5 Select option 2 Display Query Result A form like Figure 3 1 b appears on the screen This form displays those conclusions that have been selected Press lt Dn key five times to browse through these five conclusions Then go back to the first conclusion by pressing Up key five times 6 Each conclusion has a number of keywords Press lt ctrl gt lt PgDn gt The keywords associated with the displayed conclusion appears the screen Press lt ctrl gt lt PgUp gt to return to the displayed conclusion After finishing examining the conclusions and their keywords press lt Esc to exit the form 7 Select Option 3 and new menu screen appears with three options You can display the result to the screen send it
37. iaxial test psi ult stress in z dir in triaxial test psi peak strain in principal dir 10 6 peak strain in y dir in biaxial test 10 6 peak strain in z dir in triaxial test 10 6 ult strain in principal dir 10 6 ult strain in y dir in biaxial test 10 6 ult strain in z dir in triaxial test 10 6 uniaxial Possion s ratio multiaxial Possion s ratio primary failure mode modulus type 79 MOD VAL 80 THERM COEFF 81 CRP STRS modulus value 10 6 psi thermal coefficient millions deg F creep stress level 96 of f c 65 FIELD NAMES AND EXPLANATIONS TABLES AND TABLE COL NAME NO FIELD NAME TABLEB 82 5 83 AGE LOAD 84 TM 85 5 TSTMD 86 SHRK VAL 87 SHRK TM 88 CYCL FATG 89 MAX CYCL STRS 90 MIN CYCL STRS 91 LD CYCLNO 92 MOD N 93 STRGTH 94 PK STRN N 95 PERM TSTMD 96 PERM VAL 97 PORO TSTMD 98 PORO VAL 99 PORO DISTR 100 ABRSN TSTMD 101 ABRSN RSIST 102 FREZ TSTMD 103 FREZ RATE 104 AGE 1STFREZ 105 FACT 106 LD RESP NOTE 66 EXPLANATION specific creep ustrain psi concrete age at 1st creep load days creep time days shrinkage test method shrinkage strain 10 6 shrinkage time days cyclic frequency fatigue cycl sec maximum cyclic stress psi minimum cyclic stress psi number of load cycle N modulus at N cycles strength at N cycles peak strain at N cycles permeability test method permeability value cm sec porosity test method porosi
38. ical behavior of high performance concretes The research is being conducted by a team from three universities North Carolina State University the University of Arkansas and the University of Michigan This report is based on the author s independent study project which is a requirement for the Master of Civil Engineering degree The author has benefited greatly from the frequent discussions with his professors Mr Michael L Leming Dr Paul Zia and Dr Shuaib H Ahmad Their guidance is gratefully acknowledged Preface This guide explains how to use the NCSU Concrete Materials Database Program It shows how to query the database and describes how to input and update data HOW THIS GUIDE IS ORGANIZED This guide is divided into two parts Part I User Manual Part II Reference PART I USER MANUAL Exercises that help you understand how to query the database and descriptions that help you understand how to input and update data PART II REFERENCE Information concerning separate operations and fields HOW TO USE THIS MANUAL Two methods are used in this manual Examples are used in query operations while procedures are listed for input operations It is best to read it while sitting at your computer where you can enter the exercise examples and see the results on your screen CONVENTIONS USED IN THIS MANUAL The following conventions are observed in this manual Text must be entered exactly are shown in capital let
39. ke rate 2000 u in min 4 8 specimen cylinders selected ODR Y DALADA Learning How Input Data In this chapter you will learn how to input and update data into the Conclusion Database the Table A and Table B Database and the Formula Graph Database All input forms contain extensive help messages and error checking mechanisms that can help you during input operation To input correctly you need to understand the purpose of each table and how tables are joined You may want to refer to the report on the NCSU Concrete Materials Database Program Chapter 3 NCSU Concrete Materials Database Structure before you start this chapter 4 1 General Procedures All input forms in the program are developed using SQL Forms Oracle s form generation tool Since input procedures are fairly simple and straight forward no example will be used Instead a step by step procedure for each input operation is given to get you acquainted with the basic input steps That should be enough for most of your needs If you want to become more proficient refer to the SOL Forms Operator s Guide No matter which input form you use the procedures are generally the same In the following some definitions specific to input forms will be stated first and then a general outline on how to input update and save the data will be described 15 Some Definitions A field in a form is a cell where you can enter data You can go to the next field by
40. le values are listed You can access that table by pressing F9 Then move the cursor to the desired field and press Enter Most Commonly Used Function Keys r9 go to LIST OF VALUE block lt 10 gt commit change F7 enter query F8 execute query enter next field lt shft gt lt tab gt previous field Dn next record Up previous record F3 copy field from previous record 8 4 Table B Input Forms Table B input form is subdivided into three forms because of its large size However it is actually one table and should be treated so Portion of the forms are shown in Figure 8 4 The 41 procedures in entering data is identical to Table A input so they not repeated here There are two items needed be aware of First the field names for the three fields that comprise the primary key have different first letter designation than that of TABLE A e g BART ID vs AART ID Second to access primary key in Table B Input Forms Part II and Part III you need to perform enter query and execute query operations Press F7 Enter Query move cursor to BART ID enter the article ID number that you want and then press F8 gt Execute Query 8 5 Formula Graph Input Form You can enter information on formula graph in this input form as well as assign keywords The form is depicted in Figure 8 5 ART ID Enter article ID number It must be a five character string F G NO Enter the Formula
41. o commit the input 3 You can exit to the menu screen by pressing lt Esc gt Warning on Updating Information in Maintenance Mode Be extremely careful when you need to update any information in the maintenance mode Remember that if you change a keyword in the reference keyword lists or a value in the List of Values table queries based on the new keyword or value would not be able to select the correct records unless you update all the records For example if you change the keyword HIGH STRENGTH 5 a query using HIGH STRENGTH will not select those records 19 PART II REFERENCE Hardware And Software Requirements In order to operate the NCSU Materials Database program correctly your computer system must satisfy the following minimum requirements Hardware Requirement If your system is workstations that are certified by Oracle then you should not have any problem However if you are working on PCs then you have to have enough ram memory and disk memory to install and run ORACLE RDBM SQL PLUS SQL MENU and SQL FORM Generally speaking you need at least a 286 machine with about 3 megabytes of extended memory and 10 megabytes of hard disk storage space You can consult Appendix A of Oracle Application Tools for MS DOS User s Guide for details Software Requirement The following Oracle products are required to run the NCSU Database program ORACLE RDBM version 5 1 SQL PLUS version 2
42. orming an expression Most 28 common operators are gt gt lt lt AND OR and NOT Refer to SQL Language Reference Manual Chapter 1 Page 12 14 for definitions and examples Step 3 After you pressed Enter gt another help message box and a new prompt as in Figure 7 6 appears You are asked to enter the display order at this prompt At the prompt enter the order clause and press Enter to proceed You can embed display orders You also can display records either in ascending or descending order The default order is ascending order For example if you enter TM ULT STRS1 DESC the program will display data by curing time in ascending order and within the same curing time by ultimate stress in descending order Step 4 If the result is to be saved to a file another help message box and a new prompt as in Fig 7 7 appears However if the result is to be saved to Lotus this prompt will not appear and you should skip to Step 5 At this prompt you are asked to create a file to store the query result At the prompt enter the filename and press Enter The filename should follow MS DOS naming convention It is saved under the working directory If there is an existing file with the same file name the older version will be overwritten Step 5 Depending on data destination one of the two help message boxes and prompts appears on screen If data destination is a file at the prompt enter the field names
43. our input once Enter key is pressed Therefore if there is any input error you have to restart by exiting the prompts and returning to the menu screen There are two ways you can overcome these limitations First you can query using ORACLE FOR 123 See next paragraph Second you can construct complex query using the option described in the next section A Better Alternative If you can access ORACLE FOR 123 a better query method that eliminate the above limitations is available In this program a Lotus file containing a set of macros is available to assist you in querying Table A and Table B Refer to Chapter 10 for details Menu Screen Query Table and Table B Option 3 Execute complex query Select this option if you want to enter a complex query when the previous options are not adequate This option brings up the SQL PLUS In SQL PLUS you can formulate as complex and as long a query as you desire To formulate query in SQL PLUS you need to understand SQL syntax In addition you need to include the table joins yourself in the where clause You can refer to SQL PLUS User s Manual for SQL syntax And you can refer to Appendix D to see the SQL expressions on table joins You may also want to read the NCSU Database Program Report to get a conceptual understanding of the program s data structures You are not totally on you own when you select this option All the fields from Table A Table B and Base Table have been defined both
44. pressing Enter and go to the previous field by pressing shift Tab record is one row of data in a table In a form you can go to the next record by pressing lt PgDn or go to the previous record by pressing lt PgUp gt block in a form is generally indicated by a single line box A block usually contains one table Some blocks are single record blocks while others are multi record blocks You can go to next block in a form by pressing lt ctrl gt lt PgDn gt and go to the previous record by pressing lt ctrl gt lt PgUp gt A page in a form generally means one screen When screen changes a different page appears The current page number is always displayed at the bottom of the screen Operations You can enter data into a field when the cursor is in that field Then you can move to the next field by pressing lt Enter gt Pressing lt Enter gt at the last field will bring the cursor back to ine first field You can jump to the next record by pressing lt PgDn gt In some input forms more than one block exist Press lt ctrl gt lt PgDn gt to go to the next block and press lt ctrl gt lt PgUp gt to go to the previous block What you entered in the form would not be saved to the database until you commit the change Press lt F10 gt to commit the change It is good practice to commit your changes frequently If you want to update information you need to first query out the information from the da
45. r When this option is selected a screen resembling Figure 7 12 appears Select Fields To Print The only item you can update is the PRINT column Change to Y if you want to print that field name and its list of values You can preview the list of values for a field name by pressing F9 Press Enter to return Most Often Used Keys up move to next record down move to previous record r9 see list of values F10 commit Menu Screen Print Reference List Option 72 Print Field Names and List of Values Option 3 Print Reference Keyword List 32 Conclusion Database Option 4 Print Reference Keyword List Formula Graph Database Select option 2 to output the field names and their lists of values that were selected from the option 1 to the printer You can use this printout to assist you in querying Table A and Table B Select option 3 to output the reference keyword list for the Conclusion Database to the printer You can use this list to assist you in querying the Conclusion database Select option 4 to output the reference keyword list for the Formula Graph database to the printer You can use this list to assist you in querying the Formula Graph database Once the printing is completed the program automatically returns to the menu screen 7 5 Figures 1 ART article iD ART 21000 2 AUTH author s name AUTH LIKE 214 3 YEAR year publication YEAR 1979 4 TITLE title of an article 5
46. re as follows 1 2 Work precisely query statement you want to do on paper first Navigate through the Application Menus to Query Table A and Table B screen and select the options that correspond your needs Enter the query information as requested 4 If you made a mistake you can exit to the menu at any time by enter lt ctrl gt z and then press Enter One disadvantage of this method of querying Table A and Table B is that whenever a mistake is made you have to start over again However ORACLE FOR 123 provides a better alternative in querying table A and Table B ORACLE FOR 123 utilizes the power of a spreadsheet in combination with Oracle s RDBM If you can access ORACLE FOR 123 then you probably want to become familiar with it In the next section the same example will be used to demonstrate the use of ORACLE FOR 123 3 4 Example On Using Oracle For 123 To Query Table And Table B Goal The goal is the same as in the last section You want to see what experimental data are available on the compressive strength that have water cement ratio of 0 4 or less and are cured until testing at 28 days Steps L Exit from the Application Menus 2 Type ORA123 and press lt gt 3 Use normal Lotus procedures to bring up the file 1 The help screen appears and you are prompted to enter your username 4 Enter your username and press Enter Then enter your password and press Enter
47. red keyword from the REFERENCE KEYWORD LIST block You can do this by pressing the Enter key to jump to the REFERENCE KEYWORD LIST block Then move the cursor to the desired keyword and press Enter You can return to the main screen by pressing lt ctrl gt lt PgUp gt Most Used Function Keys lt 10 gt commit lt ctrl gt lt PgDn gt to next block lt ctrl gt lt PgUp gt to previous block enter next field F7 enter query F8 execute query 40 8 3 A Input Form You enter data into Table A using this input form primary key for Table 15 composed of three fields AART ID ASPE ID and AMIX ID Data for these three fields can only be entered on Page 1 In subsequent pages these three columns are only for display Portion of the form is depicted in Figure 8 3 AART ID AART ID is the article ID number AART ID should be the same with the ART ID in the base table ASPE ID ASPE ID is the specimen ID number ASPE ID is numeric and sequenced by ascending order starting at 1 AMIX ID AMIX ID is mix ID AMIX ID is a character string with a maximum of 30 characters long Other Fields Other fields are either numeric or alphanumeric Up to 30 characters can be entered in all alphanumeric fields except the note field at the end which can take up to 240 characters Refer to Appendix C for definition of each field List Of Values In certain alphanumeric fields a list of acceptab
48. rinter If you select OPTION 2 the program prompts you to ready the printer The prompt Ready the Printer enter to start appears on the screen Press lt Enter gt to start printing Print To File If you select OPTION 3 the program prompts you to specify a filename The prompt FILE NAME TO SAVE default extension gt appears on the screen Enter a filename following MS DOS naming convention and then press enter file will be saved under your working directory Please note that if you name a file that already exists the new file will overwrite the old file automatically 27 7 2 Table And Table B Database Menu Screen 1 Query Table A and Table B and Save to File Menu Screen 2 Query Table A and Table B and Save to Lotus Options all options under the two menu screens Before You Start This method of querying Table A and Table B is provided mainly for those systems that do not have ORACLE FOR 123 installed This method has some limitations If your system has ORACLE FOR 123 it is better to use ORACLE FOR 123 to perform the query Refer to Chapter 10 for details General Procedures Either you intend to save a result to a file or to Lotus in querying Table A and Table B the procedures are similar and thus will be discussed together The program guides you through the query operation in five steps The five steps are 1 enter the columns you want to see on screen 2 enter the where clause 3 enter the order
49. rrant Complex Query The numeric part of NCSU Database Program Table A and Table B Database is structured so that individual specimen s test results are stored as one row of data in a table Thus different specimens that are made of same mix but are tested for different mechanical properties would have the test results stored in different rows Consequently a query that involves different mechanical properties may leave out some essential information For example examine the following sample data BART ID BSPE ID BMIX ID ULT STRS STRS A2000 1 1 6000 A2000 2 I 40 Both specimen 1 and 2 are made of same mix Specimen 1 is tested for compressive strength 6000 psi and Specimen 2 is tested for creep stress 40 of compressive strength A user who wants to do a comparison of compressive strength and creep strength would be tempted to write the where clause such as ULT STRS12 5000 AND STRS 40 However this where clause would not select these two records because neither record satisfy the search criteria 70 Recommended Query Command It is possible to extract such information described above Since in SQL a table can be treated as two different tables consequently a table can be joined by itself In the example above all mechanical properties are stored in Table B then you can write a SOL commands in the following form SELECT TAB1 ULT_STRS1 2 STRS FROM TABLEB TABI TABLEB TAB2 WHERE TABI
50. ssigned in the Base table A corresponding Lotus file with the same article ID number as its filename should be included in the data files provided You can access the file through the normal Lotus spreadsheet commands FG ID The formula or graph ID number A designation with the F prefix stands for Formula and G prefix stands for Graph In the Lotus file each graph should be identified with the formula graph ID number PRINT print this record or not AUTHOR first author s name TITLE the article title DEP VAR description of the dependent variable on a graph 31 IND VAR descriptions of independent variables on graph Up to five independent variables can be listed RELATION for graph the description of the graph is displayed for formula the actual formula is displayed NOTE any additional information or comments Menu Screen Print Query Result Formula Graph Database Option 71 Print Query Result to Screen Option 72 Print Query Result to Printer Option 3 Print Query Result to file When you select one of the three options a help message box and a prompt as shown in Figure 7 11 appears The procedures here are identical to that of in Print Query Result screen for Conclusion Database Refer to that section for details 7 4 Print Reference Lists Menu Screen Print Reference List Option 1 Select Field Names and List of Values to Print You can select the field names and the their list of values to print to the printe
51. t 4x4x20 prisms were tested for dynamic modulus of elasticity Fourteen 3x10 in cylinders were tested for swelling and creep Concrete strengths based on cube tests were reported up to 13 620 psi Keyword table keyword table for Conclusion database Art ID Concl Keyword A2012 1 COPRESSIVE STRENGTH A2012 1 2012 1 MODULUS ELASTICITY A2012 1 SHRINKAGE A2012 1 SUPERPLASTICIZERS A2009 1 HIGH STRENGTH A2009 1 MODULUS OF ELASTICITY A2009 1 5 57 Table A table 1 2 3 4 5 9 13 Article Specimen Mix ID Cement Cement F Agg Agg ID ID Type Qty Qty Qty py poy pcy A2012 1 500 I 876 809 2083 A2012 2 500 I 876 809 2083 2012 3 500 1 876 809 2083 2012 4 500P 876 809 2083 2012 5 500 902 833 2142 2012 6 500 902 833 2142 1 2 3 16 17 25 31 Article Specimen Mix ID Chem 1 Chem 1 W C F Work ty ID ID Type Qty Test Mthd oz cwt A2012 1 500 0 36 SLUMP 2012 2 500 0 36 SLUMP 2012 3 500 0 36 SLUMP 2012 4 500P 0 36 SLUMP 2012 5 500 SUPERPLASTICIZER 8 0 27 SLUMP 2012 6 500A SUPERPLASTICIZER 8 0 27 SLUMP 1 2 3 32 41 42 Article Specimen Mix ID Work ty Curing Curing ID ID Value Mthd Time in days A2012 1 500 1 5 WATER 1 2012 2 500 1 5 WATER 28 2012 3 500 1 5 365 2012 4 500 1 5 28 2012 5 500 1 375 1 2012 6 500 1 375 WATER 28 58 Table table
52. t error a message will appear and you can edit your where order clauses and execute again 12 Press lt alt gt s again and select the command DATA The program will display the data you have queried Summary You have learned a different way of querying Table A and Table B using ORACLE FOR 123 In summary 1 Select the COLUMNS command and select the fields you want to display 2 Select CRITERION ORDER command and enter where order clauses Be sure to enclose the where clause by parenthesis to ensure correct query result 3 Select the EXECUTE command If there is an error edit the where order clauses 4 Select the DATA command and see the data 3 5 Example On Querying Formula Graph Database The procedure to query the Formula Graph Database is identical to that of the Conclusion Database Once you navigate through the Application Menus to the Query Formula Graph Database screen you can follow the same procedures as listed in Section 3 1 Therefore it will not be repeated here 10 For where clause enter YEAR 1975 AND KW STRESS STRAIN RELATIONSHIP and press lt gt And for the order clause enter ART and press lt Enter If you ask to send the result to print to the printer the output should be as shown in Figure 3 4 11 3 6 Figures 12 1 article ID ART 21000 2 AUTH author s name AUTH LIKE 71 3 YEAR year of publication YEAR gt 1979 4 TITLE title of
53. tabase Follow these steps 1 Press lt 7 gt Enter Query key The entire input form goes blank 2 Move cursor to field you want to enter search value For example in the Base table enter Z1000 to search out the article with article ID number equal to Z1000 You can press the Enter key to go to different fields and enter other search values In fact you can use Boolean operators in the fields Refer to the SQL FORM Operator User s Guide Chapter 3 for details 3 After you have entered all the search values you want press F8 the Execute Query key to execute the query 16 The form displays those records satisfies search criteria Then you edit those records by the procedure outlined above Do not forget to commit your change 4 2 Input Data Input data into the Conclusion Database involves two input forms 1 The Base Table Input Form where information such as the article ID number author s name and article title are contained and 2 the Conclusion Input Form where the conclusion and keywords are contained Refer to Figures 8 1 and 8 2 Steps l Navigate through the Application Menus to the Input Mode screen and select the first option Base Table Input Form A form that contains the Base Table appears on the screen You can enter information on an article in this form using the steps listed above Make sure you commit the input by pressing lt 10 gt You
54. ters and Courier font e g AUTH Text that are displayed on the screen such as prompts are shown in italics SUPPLEMENTARY MANUALS YOU MAY USE This program is constructed using several of Oracle s tools While this manual provides essential information at times it may be helpful to refer to the Oracle publications listed below SQL PLUS User Guide SQL FORMS Operator Guide SQL MENU User Guide ORACLE FOR 123 User Guide ii Contents Preface PART I USER MANUAL l 2 Pin 1 Application Menus 2 Learning How To Query Data 4 3 1 Sample Database 3 2 Example on Querying Conclusion Database 3 3 Example on Querying Table A and Table 3 4 Example on Using ORACLE FOR 123 To Query Table A and Table B 3 5 Example on Querying Formula Graph Database 3 6 Figures Learning How To Input 15 4 1 General Procedures 4 2 Input Data Into Conclusion Database 4 3 Input Data Into Table and Table B 4 4 Input Data Into Formula Graph Database 4 5 Input Data in Maintenance Mode lii PART II REFERENCE 10 Appendix Application Menus Chart Appendix B Sample Database Appendix C Field Names And Definitions Appendix D Table Joins Appendix E Complex Query Hardware And Software Requirement Installation and Assigning Users Query 7 1 Conclusion Database 7 2 A and Table B Database 7
55. th the DBA privilege has the authority to assign new users to the program and designate their user levels On the other hand he also has the authority to remove or change the default usernames and passwords for security reasons Refer to Chapter 8 SQL MENU User s Guide for procedures 24 QUERY MODE In this chapter each operation in the query mode will be described in detail 7 1 Conclusion Database Menu Screen Query Conclusion Database Option 1 Execute Query Statement Select this option to enter a search criteria in querying the Conclusion Database A help message box and a prompt appears on screen as shown in Figure 7 1 At The Prompt Enter the where clause using the nomenclatures in the help message box The syntax for the where clause follows the SQL query expressions Refer to SQL Language Reference Manual Chapter 1 Page 12 14 for definitions and examples on SQL operators In general the operators used in the where clause are Boolean operators Most common ones are gt gt lt lt AND OR NOT and LIKE Remember all character strings must be enclosed by single quotations Press lt enter gt to execute the query Six nomenclatures can be used in the search criteria ART is the article ID number ART is comprised of a 5 character string In general Z1000 Z1999 are articles reviewed by Dr Paul Zia A2000 A2999 are by Dr Shaub Ahmad 25 and L3000 L3999 by Prof Michael Leming AUTH is the first author
56. the display column width and the column title Thus if you keep the number of columns to a maximum of seven then the queried result can be displayed clearly across the width of the screen To tap the potential of the program some queries can only be generated this way Refer to Appendix E for details 30 7 3 Formula Graph Database Menu Screen Query Formula Graph Database Option 1 Execute Query Statement Select this option to enter search criteria in querying the Formula Graph Database help message box and a prompt appears on screen as shown in Figure 7 9 The procedure for this option is almost identical to optionZ1 in Query Conclusion Database menu screen Refer to that section for reference The only difference is that in this option you use FG ID instead of CONCLA FG stands for Figure or Graph ID designation and is comprised of character string In general G1 stands for graph 1 of an article and F1 stands for formula 1 of an article Menu Screen Query Formula Graph Database Option 72 Display Queried Result Select this option to view those conclusions that satisfy the most recent query A form like Figure 7 10 appears on the screen You can browse through these records and opt not to print certain records The operations used in this form is the same as in that of Query conclusion Database Refer to that section for details In this form following fields are displayed ART ID The article ID number that was a
57. ty value 96 porosity distribution Lotus file name abrasion test method abrasion resistance mass loss freezing test method freezing rate deg F hr age at first freeze days durability factor load response note Appendix D Table Joins 67 68 KW tabie CONCLUSION table art id keyword art id conci conclusion TABLEB table TABLEA table BASE table 2 ast_id spe_id mix_id art_id FKW table TABLEF table be art id fg id keyword BASE table art id fg id art id Appendix Complex Query 69 While NCSU Database Program provides extensive query capabilities to fully utilize its potential you may want to perform queries that are beyond what is provided NCSU Database Program provides a means to access Oracle RDBM directly where complex query commands can be executed In this appendix the situation that warrant complex queries will be described and corresponding query command will be suggested Warning To perform correct query operations you need to be familiar with SQL language as well as the Table A and Table B Database structure Otherwise it is easy to extract erroneous information It is assumed here that you understand the SQL language fairly well If you are not you definitely want to study SQL Plus User s Guide before you attempt to perform complex queries Chapter 6 and Chapter 7 of SQL Plus User s Guide are especially important Situation That Wa
Download Pdf Manuals
Related Search
Related Contents
Philips Humidification filter AC4148 P SL CLTIS D EA P X 3 b03 Craftsman 917.25801 Lawn Mower User Manual 取扱説明書 PDFダウンロード BRAVIA Parte 2 - Diseñador del Modelo de Datos ITALIANO OROLOGI MECCANICI 取扱説明書 Copyright © All rights reserved.
Failed to retrieve file