DB Viewer User manual
Contents
1. PT When mouse cursor moves over the chart it PT10 a PT1 shows current data and time in the status bar only 1f pa 12 08 99 1 PT3 a cursor intersects the chart line Bottom axis shows PTA E TE Se TCTEER TT i only date in weekly and monthly mode Chart can be easily printed Fig 3 Gas System chart preview OF x Paper Orientation C Portrait i Landscape Reset Marame e View Margins Proportional Tims Fig 3 Print preview dialog Page 5 of 8 DB Viewer Manual Datasheet window Fig 4 is designed to get the raw data and the statistics information from the database User should select start and stop date 1f they are equal one day period will be used There 1s a possibility to select multiple process variables from Channels listbox Data grid is filled by Query button Before reading j Your quer contains 1791 records 2 It may take some minutes the data program calculates records count and Do you want to continue acquires user acknowledge for data reading because it may take some minutes to get huge amount of data DB Yiewer D December 1999 mdb 12706799 14 39 44 12719799 10 41 50 Chat Datasheet Change database Start a DE Statistics O TXT EE CSI CN 0 CN 39 4 2020 0 1604 0 3876 2 1222 1017 560 press 0 01 20 311343 0 1550 0 9910 2 1197 1017 8670 12709799 0 02 08 9 1945 0 1604 0 9928 2 1166 10172. daily weekly and monthly and one of the gas system process variables from the Channel listbox The Query button gets specified data from database and shows it on the chart Two small buttons below the date picker shift the date by one day independently on specified period DB Viewer D December 1999_mdb 12 06 99 14 39 44 _ _ 12 19 99 10 41 50 Chart Datasheet E ma TH a h co CEJ OF 131 E p e Berl Al E IE i Weekly 0211 chart starting at 12 08 89 A A A FUTUTA ArT in AT a IATA E E a E y o eae ee ee eee ell A A a a a a a A a a a A AAA AAA AO e RAE AA A A IA RS CA a A A lA e AO AS TARO Su O A A A E A A A E elle a a ee oe eee elle A A A a A A A a ee ere a a al ae ee a Es Mes ce eh ee la El A AA A a A A ASAS AAA in Oy wa ances Bdes eSB LOR SR OBa ad Lee seR Sos Resa EE SER Laat ae eae vase a IS ISA ee a A A A a bop oie ered aga Som Boe Sap E aera ew SA toma YG Eas Saga E trite te aia fa tal fh Ginter alg stata titted ee ee ee ee ee ee ed ee ee 1208 99 1209 99 1210 99 1211 99 1212 89 1283189 1214 99 Time 28 3953 at 12 73 99 2 00 00 Data have been read from database Fig 1 Chart window Page 3 of 8 DB Viewer Manual User may copy chart picture to clipboard with Copy button export it to a windows metafile WMF button which can be inserted into any document or export to tab delimited text format for further analysis Note that the data are got from database with averaging The idea i
3. 8670 1270957 993 0 02 56 9 1805 0 1633 0 9953 2 1204 1017 8670 1270957 993 0 03 45 9 2164 0 1615 0 9962 2 1254 1017 8670 12709799 0 04 33 9 2092 0 1612 0 9975 2 1263 1017 560 12709799 0 05 21 9 2307 0 1612 0 9976 2 1247 1017 8670 12 09 99 0 06 09 9 2164 0 1612 0 9975 2 1316 1017 8670 12 09799 0 06 56 9 2379 0 1597 0 9992 2 1300 1017 2350 12 09 99 0 07 46 9 2307 0 1615 0 9982 2 1262 1017 7330 1270957 993 0 08 34 9 2523 0 1561 0 9976 2 1218 1017 7330 12709799 0 09 22 9 2953 0 1615 0 3307 2 120 1017 2330 12709799 0 10 11 3 2451 0 1597 0 9845 2 1209 1017 2330 12709799 0 10 59 92882 0 1604 0 9881 2 1238 1017 8670 12709793 0 11 47 9 2353 0 1597 0 9916 2 1243 1017 7330 1270957 993 001235 9 3312 0 1582 0 9330 2 1236 1017 5670 12709799 0 13 23 9 3240 0 1550 0 3353 2 1219 1017 7330 Channel xl 12 09 99 014712 943254 01597 NASA 2112 1017 AAN El Data have been read from database Fig 4 Data grid with multiple channels Page 6 of 8 DB Viewer Manual z7 Data grid can be exported to a tab delimited text file by TXT button or MS Excel file 1t may take some time Note that 2 Sel data is read from the database without any averaging and exactly corresponds to the database records User may sort data grid by any 12 09 99 F column ascending or descending just by clicking column head Small y blue arrow shows sort direction This operation can take minutes with c44 314 9337 027 huge amount of
4. DB Viewer User manual By Peter Kravtsov E mail pkravt gmail com This document location http lkst pnpi nw ru pdf DB Viewer pdf December 1999 updated November 2007 DB Viewer Manual Latest improvements 02 04 2000 Time format fixed for chart axis thanks Blair 02 03 2000 Different database types support STAR PHENIX DC PHENIX PC 12 23 1999 Zero time mistake 1s corrected in text file export thanks Howard 12 19 1999 Database statistics deleting records compact database 12 18 1999 Raw datasheet query added 12 11 1998 First version released 12 05 1998 Idea was born Page 2 of 8 DB Viewer Manual Software manual The objective behind the Database Viewer was to create user friendly software for analyzing STAR TPC Gas System data All data are kept in MS Access database giving one a possibility to use native MS Access tools for converting and analyzing these data Besides this simplifies dramatically access to the certain data in a huge database for example 3 5 month database has approximately 200 thousands of records Sometimes 1t is useful to get fast results and charts from the database during the gas system operation The solution for these requirements is DB Viewer Program allows user to change the database to get data from Fig 1 The database name is stored in the system registry and will be restored on next run User may select start date on the chart toolbar with one of three periods
5. data Page 7 of 8 DB Viewer Manual Database statistics Fig 5 shows 12 17 99 1791 a 13 18 90 m records count for each day in the 12 79 99 q Ga database There 1s no need to select any JL process variable for this operation One can delete any particular day from le Ve L database This allows removing extra 12 18 99 547 E 5 Se all He cise 12719799 a TEN 7 garbage data Records wi e delete only 1f correct password 1s entered Password can be obtained by E mail The database size does not reduce even if some records were deleted User may compact database and remove redundant space from database by Compact DB button Note that new compacted database should be written with the different name Database statistics can also be exported to a text file or an Excel format DE Viewer D December 1333 mdb 12706799 14 33 44 12 1 31 33 10 41 a0 i Delete Checked e Compact DB 1240799 12708799 12709799 12710799 12711759 12712799 12713799 12714799 12715799 12716799 12717799 12 16 99 1219 99 E 28 3953 at 12 13 99 2 00 00 Data have been read from database i Fig 5 Database statistics IT IS STRONGLY RECOMMENDED TO CHANGE THE DATABASE NAME IN GAS SOFTWARE FOR EACH RUN EACH WORKING MONTH TAKES ABOUT 15 MEGABYTES AND OVER 50000 RECORDS IN THE DATABASE Page 8 of 8
6. s as follows The gas system software takes about 50 seconds for each record When DB Viewer gets data for the day period it averages process variables by one minute and takes the first time field as time value For example 1f database has two records with time fields 11 03 05 and 11 03 53 minutes and hours are equal 1t will average process variables and get 11 03 05 as time field For the week and month period program will average data by hours and get again the first time field as time value That s why in the exported data file time between two records may vary Chart can be printed directly from this program Printer button shows the preview dialog where some parameters like margins details printer setup can be adjusted Note that by default it prints in low detailed mode The chart itself can be shifted or zoomed There are three zoom buttons on chart toolbar No Zoom Zoom In and Zoom Out Besides user may move the chart picture by dragging it with the right mouse button Weekly 021 chart starting at 12 06 99 12 08 99 1 2109 99 1248099 12815839 12 2199 1283 99 125 4199 Time Fig 2 Chart zoom Page 4 of 8 DB Viewer Manual Part of the chart can be zoomed by pulling frame with left button Fig 2 When frame is pulled from left to right and from top to bottom it will be zoomed if it is pulled vise versa chart restores no zoom position This position is restored also when Query button is pressed
Download Pdf Manuals
Related Search