fme lightning talk - inline querier
TRANSCRIPT
![Page 1: FME Lightning Talk - Inline Querier](https://reader033.vdocuments.us/reader033/viewer/2022051212/55855bc1d8b42a970b8b4638/html5/thumbnails/1.jpg)
InlineQuerier: A Mid-Stream FME Database
April 2012
![Page 2: FME Lightning Talk - Inline Querier](https://reader033.vdocuments.us/reader033/viewer/2022051212/55855bc1d8b42a970b8b4638/html5/thumbnails/2.jpg)
InlineQuerier: Motivation
Cascading FeatureMergers = BAD
![Page 3: FME Lightning Talk - Inline Querier](https://reader033.vdocuments.us/reader033/viewer/2022051212/55855bc1d8b42a970b8b4638/html5/thumbnails/3.jpg)
InlineQuerier: Motivation
Cascading FeatureMergers = BAD Each FeatureMerger causes features to be
Blocked up Reindexed Re-cached to disk
Joins between features are limited to a single key No sophisticated ability to compute additional
values or configure the join FeatureMergers join only two streams at a time
![Page 4: FME Lightning Talk - Inline Querier](https://reader033.vdocuments.us/reader033/viewer/2022051212/55855bc1d8b42a970b8b4638/html5/thumbnails/4.jpg)
InlineQuerier: Introduction
Fully configurable multi-stream join Brings SQL power to all datasources
Cache and index once Query many times
Extract, Join, & Computeinformation via SQL Query
Tidier workspaces Improved performance
![Page 5: FME Lightning Talk - Inline Querier](https://reader033.vdocuments.us/reader033/viewer/2022051212/55855bc1d8b42a970b8b4638/html5/thumbnails/5.jpg)
InlineQuerier: Before And After
Task: Put each egg on the map, with its species
Egg Information (CAT)NEST_ID EGG_ID DATE_LAID DATE_HATCHED INCUBATION_DAYS NEST_X_OFFSET NEST_Y_OFFSET 20 0 20040819 20040826 7 -0.14 -0.15 20 1 20040823 20040829 6 -0.05 0.18 20 2 20040818 20040826 8 -0.23 -0.00…
Nest Locations (ArcGen)20,3144330,1008911721,3144481.5,10089238…
Species (CSV)NestId,Species100,Blue Jay101,American Goldfinch…
![Page 6: FME Lightning Talk - Inline Querier](https://reader033.vdocuments.us/reader033/viewer/2022051212/55855bc1d8b42a970b8b4638/html5/thumbnails/6.jpg)
InlineQuerier: Before And After
Cascading Feature Mergers
![Page 7: FME Lightning Talk - Inline Querier](https://reader033.vdocuments.us/reader033/viewer/2022051212/55855bc1d8b42a970b8b4638/html5/thumbnails/7.jpg)
InlineQuerier: Before And After
With Inline Querier
![Page 8: FME Lightning Talk - Inline Querier](https://reader033.vdocuments.us/reader033/viewer/2022051212/55855bc1d8b42a970b8b4638/html5/thumbnails/8.jpg)
InlineQuerier: 4 Way Joins
Heritage
Taxes
Neighborhood
Neighbourhood Code
PID
Address
![Page 9: FME Lightning Talk - Inline Querier](https://reader033.vdocuments.us/reader033/viewer/2022051212/55855bc1d8b42a970b8b4638/html5/thumbnails/9.jpg)
InlineQuerier: 4 Way Joins
Addresses
Heritage
Taxes
Neighborhood
![Page 10: FME Lightning Talk - Inline Querier](https://reader033.vdocuments.us/reader033/viewer/2022051212/55855bc1d8b42a970b8b4638/html5/thumbnails/10.jpg)
InlineQuerier: Summary
New for 2012 Brings power of SQL to FME data streams Extract, Join, & Compute information via SQL Query
Tidier workspaces Improved performance http://fmeevangelist.com/fmeevangelist97
![Page 11: FME Lightning Talk - Inline Querier](https://reader033.vdocuments.us/reader033/viewer/2022051212/55855bc1d8b42a970b8b4638/html5/thumbnails/11.jpg)
![Page 12: FME Lightning Talk - Inline Querier](https://reader033.vdocuments.us/reader033/viewer/2022051212/55855bc1d8b42a970b8b4638/html5/thumbnails/12.jpg)