copyright© 2003 empress software, inc. all rights reserved....empress db engine win 2000 intel x86...
TRANSCRIPT
![Page 1: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/1.jpg)
1Copyright© 2003 Empress Software, Inc. All Rights Reserved.
![Page 2: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/2.jpg)
2
User-Friendly Presentation of BUFR data
Ninth Workshop On Meteorological Operational SystemsECMWF, Reading, United Kingdom November 11, 2003
![Page 3: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/3.jpg)
3
Presentation of BUFRObjectiveSpecificationsToolsMethodologyLive DemonstrationsQuestions and Answers
![Page 4: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/4.jpg)
4
BackgroundBUFR as a standard data exchange
Ultimate goal of WMOOmnipotentCompressed dataUnreadable by humans
BUFR DecodersDivergentRequire practical knowledge
![Page 5: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/5.jpg)
5
ObjectiveAbility to “read” data inside BUFR records over the Internet using a user-friendly browser based interface.
![Page 6: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/6.jpg)
6
SpecificationsData to be stored in BUFR
BUFR is not relationalData to be decodedData to be extracted according to user defined criteria specified interactivelyData to be presented in a readable formData to be presented a wide range of user interface environments
![Page 7: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/7.jpg)
7
ToolsSYSTEM
BUFR
INTERNETINTRANET USER
![Page 8: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/8.jpg)
8
ToolsDatabase system
High level application programming interfaces (API)
JDBC, HTML, XML, ODBC, PHP, PerlHigh level API’s are augmented with the BUFR decoder functionalityBUFR decoder becomes meta data in database
Internet ServerApache HTTP, Tomcat, MS IIS
![Page 9: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/9.jpg)
9
ToolsSYSTEM
Database SystemInternet Server
![Page 10: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/10.jpg)
10
End UserAPPLICATION
EMPRESS API’s
Database System
OPERATING SYSTEM
HARDWARE
![Page 11: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/11.jpg)
11
End UserAPPLICATION
EMPRESS API’s
EMPRESS DB ENGINE
OPERATING SYSTEM
HARDWARE
![Page 12: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/12.jpg)
12
End UserJAVA
JDBC
EMPRESS DB ENGINE
OPERATING SYSTEM
HARDWARE
![Page 13: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/13.jpg)
13
End UserMS-Excel
ODBC
EMPRESS DB ENGINE
OPERATING SYSTEM
HARDWARE
![Page 14: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/14.jpg)
14
End UserBrowser
HTML/XML
EMPRESS DB ENGINE
OPERATING SYSTEM
HARDWARE
![Page 15: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/15.jpg)
15
End UserBrowser
PERL or PHP
EMPRESS DB ENGINE
OPERATING SYSTEM
HARDWARE
![Page 16: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/16.jpg)
16
End UserAPPLICATION
EMPRESS API’s
EMPRESS DB ENGINE
OPERATING SYSTEM
HARDWARE
![Page 17: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/17.jpg)
17
End UserAPPLICATION
EMPRESS API’s
EMPRESS DB ENGINE
UNIX
HARDWARE
![Page 18: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/18.jpg)
18
End UserAPPLICATION
EMPRESS API’s
EMPRESS DB ENGINE
LINUX
HARDWARE
![Page 19: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/19.jpg)
19
End UserAPPLICATION
EMPRESS API’s
EMPRESS DB ENGINE
MS-WINDOWS
HARDWARE
![Page 20: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/20.jpg)
20
End UserAPPLICATION
EMPRESS API’s
EMPRESS DB ENGINE
Real Time OS
HARDWARE
![Page 21: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/21.jpg)
21
DATABASE
EMPRESS DB ENGINE
INTERNET SERVER
Tools
![Page 22: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/22.jpg)
22
DATABASE
EMPRESS DB ENGINE
INTERNET SERVER
Methodology
![Page 23: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/23.jpg)
23
DATABASE
EMPRESS DB ENGINE
Methodology
![Page 24: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/24.jpg)
24
MethodologyIngest BUFR Data into databaseAugment database system with decoding functions
![Page 25: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/25.jpg)
25
DATABASE
EMPRESS DB ENGINE
Methodology
BUFR DECODER
![Page 26: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/26.jpg)
26
Ingesting BUFR into databaseBUFR does not naturally translate into rows and columnsIngest is a batch processRange of ingest methods:
Minimum – store each BUFR record as BLObRecommended – store each BUFR record as BLOb alongside decoded product definition section (originating centre, date and time)Complete – decode all of BUFR records and store it in a relational format
![Page 27: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/27.jpg)
27
BUFR Decoder as meta dataPersistent Stored Modules
a.k.a. User-defined functionsDecode all or parts of BUFR records as SELECT queryExtend decoding functionality to all API’s (SQL, ODBC, JDBC, PHP, HTML, Perl, etc.)Range of functions, each tailored for specific requirementsDatabase tables are perfect for BUFR reference tablesUDF decoders, BUFR reference tables and BUFR data make up a single entity
![Page 28: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/28.jpg)
28
Live Demonstration45 650 BUFR messages3 145 145 subsets (observations)Each subset contains 156 elementsPreprocessing batch:
All BUFR messages stored in 45 650 records as BLOb data type
A few user-defined functions (PSM’s) containing decoding functionality stored in the same database
![Page 29: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/29.jpg)
29
End UserJAVA (JSP app)
JDBC
EMPRESS DB ENGINE
WIN 2000
INTEL X86 /256 MB RAM
![Page 30: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/30.jpg)
30
EMPRESS DB ENGINE
TOMCAT JSP Server
Internet Explorer Browser
![Page 31: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/31.jpg)
31
EMPRESS DB ENGINE
Empress Connectivity Server
MS-Excel
![Page 32: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/32.jpg)
32
Live Demonstration
![Page 33: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/33.jpg)
33
Benefits“Readable” BUFR dataSearch through BUFR dataDownload decoded BUFR dataImproved handling of BUFR messagesImproved management of BUFR reference tablesBUFR messages and its decoders united as a single logical entity - databaseSeamless BUFR exchange independent of user data presentation environment
![Page 34: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/34.jpg)
34
The Main Benefit
Facilitates the WMO objective to standardize on table driven codes
BUFR and CREX
![Page 35: Copyright© 2003 Empress Software, Inc. All Rights Reserved....EMPRESS DB ENGINE WIN 2000 INTEL X86 /256 MB RAM. 30 EMPRESS DB ENGINE TOMCAT JSP Server Internet Explorer Browser. 31](https://reader033.vdocuments.us/reader033/viewer/2022060912/60a685bb00f1ab7a471214dd/html5/thumbnails/35.jpg)
35
US inquiries:Telephone: 301-220-1919Fax: 301-220-1997
11785 Beltsville DriveBeltsville, MD 20705USA
WEB SITE: www.empress.comE-mail: [email protected]
International inquiries:Telephone: 905-513-8888Fax: 905-513-1668
3100 Steeles Avenue EastMarkham, Ontario L3R 8T3Canada
Serge SavchenkoSerge SavchenkoEmpress Software Inc.Empress Software Inc.
[email protected]@empress.com