Meteorage - LDB - Lightning Data Base Technical Datasheet

Date : ????????? ?? ? ?Product line : core serverROLEThe Lightning Data Base is a complete repository for all the data delivered by the detection network, it stores flashesand strokes as well as sensor data and offers a seamless access to this data through a standard interface.PRINCIPLEA custom data base manager has been developed to handle lightning data, this ensures both efficiency and ease ofuse. Data from the lightning detection network is obtained through the ATP and a dedicated process in charge offeeding the Lightning Data Base in real time. Separate tables are used for sensor data, flash data and stroke data.All access to the data is then made by issuing requests to the LDB, those request are written in an extendedStructured Query Language and can be submitted simultaneously by various applications, or interactively by the user.FUNCTIONSObtain and store real time data from ATP.Convert data between LDB and ASCII format, allows for data import, export and modificationHandles «replays» from the position analyzerImplements «lightning specific» extension to SQL allow to handle dates, geography, ...Built in functions for geometry, mathematics, statisticsEdit, store, retrieve, replay of user defined requestsData protection and integrity checksPRE-REQUISITEATP to obtain real time data from the networkCONTENTldbappendApplication Program Interface (API)Interactive user interfaceAdministration toolsARCHITECTUREapplication programsdemons, serversInteractive user’s requestfile storageATP ldbappendadministrationtoolsAPIusing LQLrequestSAMPLE REQUESTS• A request such as "SELECT COUNT (*) WHERE DATE = TODAY" will give the number of flashes detected during thecurrent day.• A request such as "SELECT * FROM STROKE WHERE DATE = TODAY AND AMPLITUDE > 10000 AND DISTANCE (7.365, 40.5) < 10000 . will give high intensity stokes within 10 kilometers of the given position (40.5° north latitude and7,365 east longitude).• The following request lists the raw data sent by sensors 2,7,8 and 9 during summer 93:SELECT * FROM DF WHERE DATE BETWEEN «1993/06/22» AND «1993/09/21» AND sensor IN (2,7,8,9).Such requests can be edited and run interactively, used in command scripts or included in C programs. They can be part of aroutine network monitoring program or participate in a sophisticated service such as "Observation".