Hydro Lynx Systems presents Nova Star 5 The

Hydro. Lynx Systems presents Nova. Star 5 The next generation of ALERT base station software

Nova. Star 5 Highlights l l l Linux based operating system • • Reliable, robust, fault tolerant. Well known by software engineers. SQL server database • • Open data access to simplify user access. Database queries return raw, scaled, discharge and interval data. Web page, client based user interface • • • Workstation independent. Familiar internet browser user interface design. Client based design.

Reasons for migrating from Nova. Star 4 X to Nova. Star 5 • • • Computer hardware that supports QNX 4 X-windows is difficult to find. QNX 4 operating system is unknown to most system administrators. X-Windows user interface uses too much band width on the network. Nova. Star 4 proprietary database design restricted access to data. Nova. Star 4 X web page interface did not support secure communication with the server.

Why Linux? l l Problems with other Operating Systems • • Slow release pattern. High cost. Tech Support? Lack of source code availability. Planned obsolescence of hardware. Monopolistic attitude. Crash-prone. • • • Linux is Network-friendly. Linux is Multi-user. Linux is Open. Linux is "Free“. Linux is Reliable. Linux is Backwards-Compatible. Technical merits of Linux

Nova. Star 5 Server Design • • • Server is dedicated to data collection and dissemination, alarm detection and notification. Hard disk software raid system provides local backup of system data. User interface is moved to client workstation so a GUI is not required on the server. Client based backup of data to removable CD or DVD disks does not require server drivers. Client based user interface eliminates the need for printer drivers on the server.

Nova. Star 5 Server Design Diagram SERVER SIDE CLIENT SIDE Radio Receiver Workstation Telephone modem Workstation CD Backup Nova. Star 5 Server Printer Network

Nova. Star 5 Data Collection Features • • • Automatic and manual data collection: ALERT, two-way radio, satellite, internet import. Alarm checking and notification: Visual and audible, email, pagers, voice auto-dialers, map display. Automatic and manual local and remote control. Automatic and manual data computations: Rating tables, power curves. Automatic and manual data reports and export. Data editing and calibration drift.

Nova. Star 5 Server Design Diagram SERVER SIDE Data Collection Data Storage Data Analysis CLIENT SIDE Data Display Database Setup Data Editing Remote Control Automatic Computation Alarm Message Alarm Checking Automatic Reports View Reports Alarm Display

Nova. Star 5 SQL Database • • Open system SQL server design using Postgre. SQL is a powerful, open source relational database system. Database tables include: stations, station types, device types, data reports, data calibration, rating assignment, rating tables, alarm triggers, alarm actions. Report, plot, and map tables will be used for display parameters.

Why Postgre. SQL ? • • • Postgre. SQL is an enterprise class database that runs on all major operating systems. It includes most SQL 92 and SQL 99 data types including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, . Net, Perl, Python, Ruby, Tcl, ODBC. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate. There active Postgre. SQL systems in production environments that manage in excess of 4 terabytes of data.

Nova. Star 5 SQL Access • • • Nova. Star 5 database will support standard SQL queries. It will also provide a front end process to deliver regular time interval data from a sparse data set. Support for standard Nova. Star data analyses • • • Interval rainfall Storm rainfall Rainfall intensity Report count Maximum, minimum, mean And more

SQL Database Access Direct query for table or data editing Workstation SQL Database Data analysis front end Data collection Workstation

Web Page User Interface • • Operating system independent. Intuitive well known user interface. Client based Java scripting manages data displays returned by database queries. Printing, data exporting done on client side – no server setup required. Guest access for data display. Administrator login for database setup and edit. Secure ssh based login.

Nova. Star 4 X Data Request

Nova. Star 5 Data Request

Server vs. Client Based User Interface l l Nova. Star 4 X was server based • • • Each key stroke or mouse event was sent to server. Server redraws screens based on server input. Lots of network band width is used to update screens. Nova. Star 5 will be client based • • • Key strokes and mouse events are handled by the local browser on the client workstations. Local Java scripts redraw screens without contacting server. Commands sent to server when Submit button is clicked. Screen is redrawn by server response to submission. Network band width use is minimized.

Server vs. Client Based Network Traffic Nova. Star 4 X Network traffic Workstation Nova. Star 4 X Server Workstation Nova. Star 5 Server Nova. Star 5 Network traffic

Nova. Star 4 X Data Display

Nova. Star 5 Data Display

Client Based Data Maps • • Data requested from Nova. Star 5 server. Data readouts overlaid on map backgrounds. Data background colored to indicate hydrologic significance. Client side selection of • • • Data interval displayed (1 hour, 6 hours, 1 day, …). Data type displayed (rain, level, battery, …). Map background. Data, ID, Site name, Site tag display. Tool tip on data readout expands information. Hot links on data display to display or plot data.

Server Based Map Display

Client Based Map Display

Nova. Star 5 Computer Platform • • • Intel ATX motherboard Intel Dual-Core processor, 2. 0+ GHz 1 GB RAM Dual 160 GB SATA Hard Drivers CDRW/DVD Network interface card (10/1000 ) USB for future expansion Internal modem for software support Serial ports for data collection

Nova. Star 5 Delivery Schedule • Customer Testing in December, 2006 • Delivery in April, 2007

Thank you • You can download this presentation from: www. hydrolynx. com/presentations/Nova. Star 5. pps Hydro. Lynx Systems, Inc. 950 Riverside Pkwy. , #10 West Sacramento, CA 95605 916 -374 -1800 hydro@hydrolynx. com www. hydrolynx. com