architecture and business model of floral hall by solterbeck.net: do-it-yourself parser for...
TRANSCRIPT
![Page 1: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/1.jpg)
Architecture & Costs
![Page 2: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/2.jpg)
Floral Hall Do-it-yourself parser for Type-B-Messagesby solterbeck.net
of
![Page 3: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/3.jpg)
Service Offer
Turn-key deliveryof Floral Hall
Know-howtransfered
Developers are trained
Requirements:- XML/ASP.Net MVC- Visual Studio- MS SQL Server (Min. Express)- Windows .Net Framework 4.0
![Page 4: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/4.jpg)
XML MessageStructure Repository
Message ParserWeb Service
MicrosoftSQL Server
SQL SrvWeb Application
XML MessageWeb Application
Message ParserWeb Application
DatabaseWeb Service
Web Server (IIS, ASP.Net MVC 4)
Message
collectorPost RCV Message
WCF Data Service
WCF Data Service
Data
exportSample XML doc
w/ selected datasets
Uses for
message
consolidation
Inserts
message
object
Message
Database
Push selected
datasets for export
Selects
message object(s),
updates
message object
Uses for
message parsing
Configuration XML
Webpage
Message Database
Reorganisation
Webpage
Aspx
Aspx
Inserts
message
object
Inserts, deletes &
updates XML
structures
Aspx
Message objects grid
w/ details
Webpage
Component DiagramFloral Hall
![Page 5: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/5.jpg)
Message ParserWeb Service
MicrosoftSQL Server
DatabaseWeb Service
Web Server (IIS, ASP.Net MVC 4)
Message
collectorPost RCV Message
WCF Data Service
WCF Data Service
Data
exportSample XML doc
w/ selected datasets
Uses for
message
consolidation
Inserts
message
object
Message
Database
Push selected
datasets for export
Selects
message object(s),
updates
message object
Uses for
message parsing
Configuration XML
Webpage
Message Database
Reorganisation
Webpage
Aspx
Aspx
Inserts
message
object
Inserts, deletes &
updates XML
structures
Aspx
Message objects grid
w/ details
Webpage
Component DiagramFloral Hall
XML MessageStructure Repository
SQL SrvWeb Application(future feature)
XML MessageWeb Application(future feature)
Message ParserWeb Application
These are the proprietarycomponents of Floral Hall
![Page 6: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/6.jpg)
XML MessageStructure Repository
MicrosoftSQL Server
SQL SrvWeb Application
XML MessageWeb Application
Message ParserWeb Application
Web Server (IIS, ASP.Net MVC 4)
Message
collectorPost RCV Message
WCF Data Service
WCF Data Service
Data
exportSample XML doc
w/ selected datasets
Uses for
message
consolidation
Inserts
message
object
Message
Database
Push selected
datasets for export
Selects
message object(s),
updates
message object
Uses for
message parsing
Configuration XML
Webpage
Message Database
Reorganisation
Webpage
Aspx
Aspx
Inserts
message
object
Inserts, deletes &
updates XML
structures
Aspx
Message objects grid
w/ details
Webpage
Component DiagramFloral Hall
Message ParserWeb Service
DatabaseWeb Service
These two components ofFloral Hall depend on the
environment of thereporting airport. They will be
custom made.
![Page 7: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/7.jpg)
XML MessageStructure Repository
Message ParserWeb Service
SQL SrvWeb Application
XML MessageWeb Application
Message ParserWeb Application
DatabaseWeb Service
Message
collectorPost RCV Message
WCF Data Service
WCF Data Service
Data
exportSample XML doc
w/ selected datasets
Uses for
message
consolidation
Inserts
message
object
Message
Database
Push selected
datasets for export
Selects
message object(s),
updates
message object
Uses for
message parsing
Configuration XML
Webpage
Message Database
Reorganisation
Webpage
Aspx
Aspx
Inserts
message
object
Inserts, deletes &
updates XML
structures
Aspx
Message objects grid
w/ details
Webpage
Component DiagramFloral Hall
MicrosoftSQL Server
Web Server (IIS, ASP.Net MVC 4)
Floral Hall is a web basedpackage of components whichare based on Windows Server
with IIS and ASP.Net MVC 4 along with Microsoft SQL
Server (Express)
![Page 8: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/8.jpg)
Service parameters
ScalabilityResponse timePerformance
![Page 9: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/9.jpg)
Scalability
No issueNo matter which reporting airport
![Page 10: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/10.jpg)
Response time
Presentation layer throughweb technology
![Page 11: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/11.jpg)
Performance
Large database: 1.5 Mio records* will be listed in seconds* Equivalent of 3 years of messages for a mid-size airport with 100.000 movements per year.
![Page 12: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/12.jpg)
Data elements
Passenger Transfer Message
Load Message
Movement Inbound Connection List
![Page 13: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/13.jpg)
Load Message I/II
• Flight characteristics
– Flight identifier
– Departure date
– Registration
• Message data
– Message receive date
– Message receive time
• Address and flight information
– Priority
– Message identifier, SMI and Double signature
– Destination
– Origin
• Seat configuration
– First Class, Business Class and Ecomomy Class
– Alternatively Aircraft version
• Number of crew members
– At flight deck
– At cabin deck
![Page 14: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/14.jpg)
Load Message II/II
• Breakdown of passenger numbers
– Destination
– Pax Adults
– Pax Childs
– Pax Infants
– Pax First
– Pax Business
– Pax Economy
– Dead head crew (optional)
– Passengers allowed to be deplaned (optional))
• Breakdown of Load Weight
– Destination
– Cargo
– Baggage Weight
– Baggage Pieces
– Equipment
– Others
– Total Deadload
![Page 15: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/15.jpg)
Movement I/II
• Flight characteristics
– Flight identifier
– Departure date
– Registration
• Message data
– Message receive date
– Message receive time
• Address and flight information
– Priority
– Message identifier, SMI and Double signature
– Destination
– Origin
![Page 16: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/16.jpg)
Movement II/II
• Interpreted flight data
– Estimated arrival time
– Airport of movement
– Airport of concern
– Departure Information
• Is Actual
• Off block time
• Take off time
• Delay codes 1-2
• Delay time 1-2
• Passenger number
• Infant number
• DHC Number
– Arrival Information
• Is Actual
• Off block time
• Take off time
• Delay codes 1-2
• Delay time 1-2
![Page 17: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/17.jpg)
Transfer Messages I/II(Passenger Transfer Message & Inbound Connection List*)
• Flight characteristics
– Flight identifier
– Departure date
– Boarding point
– Transfer point
– Partnumber
• Message data
– Message receive date
– Message receive time
• Address and flight information
– Priority
– Message identifier, SMI and Double signature
– Destination
– Origin
* optional
![Page 18: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/18.jpg)
Transfer Messages II/II(Passenger Transfer Message & Inbound Connection List*)
• Transfering passengers
– Connecting flight number
– Passenger‘s destination
– Occupying seats
– Seat Class
– Number of bags
– Number of children
![Page 19: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/19.jpg)
The PriceAll prices net without VAT and other taxes.
Travel costs & accommodation: extra
![Page 20: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/20.jpg)
Message ParserWeb Service
MicrosoftSQL Server
DatabaseWeb Service
Web Server (IIS, ASP.Net MVC 4)
Message
collectorPost RCV Message
WCF Data Service
WCF Data Service
Data
exportSample XML doc
w/ selected datasets
Uses for
message
consolidation
Inserts
message
object
Message
Database
Push selected
datasets for export
Selects
message object(s),
updates
message object
Uses for
message parsing
Configuration XML
Webpage
Message Database
Reorganisation
Webpage
Aspx
Aspx
Inserts
message
object
Inserts, deletes &
updates XML
structures
Aspx
Message objects grid
w/ details
Webpage
Component DiagramFloral Hall
XML MessageWeb Application(future feature)
SQL SrvWeb Application(future feature)
XML MessageStructure Repository
Message ParserWeb Application
1. Web Application Package:plus 1-day kick-off workshop& 2-days training fordevelopers
EUR 15,000.00
2. Message Interpreting:Implemeting of in total up to 20 formats of e.g. LDM, PTM, MVT & ICL is part of the projectbased on a technical specification from the client
Included in 1.
Deliverables
![Page 21: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/21.jpg)
Message ParserWeb Service
MicrosoftSQL Server
DatabaseWeb Service
Web Server (IIS, ASP.Net MVC 4)
Message
collectorPost RCV Message
WCF Data Service
WCF Data Service
Data
exportSample XML doc
w/ selected datasets
Uses for
message
consolidation
Inserts
message
object
Message
Database
Push selected
datasets for export
Selects
message object(s),
updates
message object
Uses for
message parsing
Configuration XML
Webpage
Message Database
Reorganisation
Webpage
Aspx
Aspx
Inserts
message
object
Inserts, deletes &
updates XML
structures
Aspx
Message objects grid
w/ details
Webpage
Component DiagramFloral Hall
XML MessageStructure Repository
Message ParserWeb Application
• These components will beprovided w/ next release in 2nd Quarter 2014
Included in 1.
XML MessageWeb Application(future feature)
SQL SrvWeb Application(future feature)
Deliverables
![Page 22: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/22.jpg)
XML MessageStructure Repository
MicrosoftSQL Server
SQL SrvWeb Application
XML MessageWeb Application
Message ParserWeb Application
Web Server (IIS, ASP.Net MVC 4)
Message
collectorPost RCV Message
WCF Data Service
WCF Data Service
Data
exportSample XML doc
w/ selected datasets
Uses for
message
consolidation
Inserts
message
object
Message
Database
Push selected
datasets for export
Selects
message object(s),
updates
message object
Uses for
message parsing
Configuration XML
Webpage
Message Database
Reorganisation
Webpage
Aspx
Aspx
Inserts
message
object
Inserts, deletes &
updates XML
structures
Aspx
Message objects grid
w/ details
Webpage
Component DiagramFloral Hall
DatabaseWeb Service
Message ParserWeb Service
• This web service component will be provided by default, if sourcesystems are able to post messagecontent in SITA SDK format, IATA Type-B or Arinc
Included in 1. Any alteration to be
programmed is extra (not in cluded in 1.)
Message
collectorPost RCV Message
WCF Data Service
Deliverables
![Page 23: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/23.jpg)
XML MessageStructure Repository
MicrosoftSQL Server
SQL SrvWeb Application
XML MessageWeb Application
Message ParserWeb Application
Web Server (IIS, ASP.Net MVC 4)
Message
collectorPost RCV Message
WCF Data Service
WCF Data Service
Data
exportSample XML doc
w/ selected datasets
Uses for
message
consolidation
Inserts
message
object
Message
Database
Push selected
datasets for export
Selects
message object(s),
updates
message object
Uses for
message parsing
Configuration XML
Webpage
Message Database
Reorganisation
Webpage
Aspx
Aspx
Inserts
message
object
Inserts, deletes &
updates XML
structures
Aspx
Message objects grid
w/ details
Webpage
Component DiagramFloral Hall
Message ParserWeb Service
• The programming of thisweb service component ispart of the project based on a technical specificationfrom the client
Included in 1.
DatabaseWeb Service
WCF Data Service
Data
exportSample XML doc
w/ selected datasets
Deliverables
![Page 24: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/24.jpg)
XML MessageStructure Repository
Message ParserWeb Service
SQL SrvWeb Application
XML MessageWeb Application
Message ParserWeb Application
DatabaseWeb Service
Message
collectorPost RCV Message
WCF Data Service
WCF Data Service
Data
exportSample XML doc
w/ selected datasets
Uses for
message
consolidation
Inserts
message
object
Message
Database
Push selected
datasets for export
Selects
message object(s),
updates
message object
Uses for
message parsing
Configuration XML
Webpage
Message Database
Reorganisation
Webpage
Aspx
Aspx
Inserts
message
object
Inserts, deletes &
updates XML
structures
Aspx
Message objects grid
w/ details
Webpage
Component DiagramFloral Hall
MicrosoftSQL Server
Web Server (IIS, ASP.Net MVC 4)
3. Plattform & Development Software: Licenses andappropriate costs will bepaid by the client
Not included in 1.
Deliverables
![Page 25: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/25.jpg)
Message ParserWeb Service
MicrosoftSQL Server
DatabaseWeb Service
Web Server (IIS, ASP.Net MVC 4)
Message
collectorPost RCV Message
WCF Data Service
WCF Data Service
Data
exportSample XML doc
w/ selected datasets
Uses for
message
consolidation
Inserts
message
object
Message
Database
Push selected
datasets for export
Selects
message object(s),
updates
message object
Uses for
message parsing
Configuration XML
Webpage
Message Database
Reorganisation
Webpage
Aspx
Aspx
Inserts
message
object
Inserts, deletes &
updates XML
structures
Aspx
Message objects grid
w/ details
Webpage
Component DiagramFloral Hall
XML MessageWeb Application(future feature)
SQL SrvWeb Application(future feature)
Message ParserWeb Application
XML MessageStructure Repository4. Additional Message
Interpreting:Implementing of anotherportion of up to 20 formats ofmessages
EUR 6,250.00
Deliverables
![Page 26: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/26.jpg)
XML MessageStructure Repository
MicrosoftSQL Server
DatabaseWeb Service
Web Server (IIS, ASP.Net MVC 4)
Message
collectorPost RCV Message
WCF Data Service
WCF Data Service
Data
exportSample XML doc
w/ selected datasets
Uses for
message
consolidation
Inserts
message
object
Message
Database
Push selected
datasets for export
Selects
message object(s),
updates
message object
Uses for
message parsing
Configuration XML
Webpage
Message Database
Reorganisation
Webpage
Aspx
Aspx
Inserts
message
object
Inserts, deletes &
updates XML
structures
Aspx
Message objects grid
w/ details
Webpage
Component DiagramFloral Hall
Message ParserWeb Service
SQL SrvWeb Application
XML MessageWeb Application
Message ParserWeb Application
DatabaseWeb Service
5. Application Support:Optional (per year), seenext slide
EUR 500.00
Deliverables
![Page 27: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/27.jpg)
Application Support includes :
• 3rd level support for the application
• Provision of new or updated public domain XML templates for
message parsing
• Subscription of „Floral Hall“ newsletter
• No technical support for the application and web server or even its
implementation. Operational service responsibility remains at the
airport IT
• Solterbeck.net shall provide only code changes
• Performance Level: Within following five working days.
Extended Support is Application Support plus:
• On demand programming of XML templates for new message
formats at the airport
• Technical support for the application package. Operational service
responsibility remains at the airport IT
• Solterbeck.net implements the code changes
• Service Level: Mo-Fr 7-19h (CET),
Performance Level: Within following three working days.
500 €/year
625€/month
![Page 28: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/28.jpg)
Plan: Payable at
Contract signing EUR 8.000Implementation on site EUR 7.000Others: due upon receipt
![Page 29: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/29.jpg)
Your benefit
Self-driven approach Independently
Implemented inthree months
33% less investmentthan self-made
More accurate dataRealtime
processing
High granularity indata detailing
![Page 30: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/30.jpg)
Contact:solterbeck.net | Sven SolterbeckMecklenburger Straße 61 | 65824 SchwalbachGermany | Tel. +49 152 18 60 77 88Mail: [email protected]
![Page 31: Architecture and Business Model of Floral Hall by solterbeck.net: Do-it-yourself parser for Type-B-Messages](https://reader035.vdocuments.us/reader035/viewer/2022062514/558902d5d8b42a7a1b8b4624/html5/thumbnails/31.jpg)
Presentation by Sven Solterbeck
Sven Solterbeck, blogger, software developer and IT infrastructure consultant, knows the industry for more than 15 years. He has collaborated with well known airports in Germany, Europe, Mid East and Asia.
Solterbeck.net one hand is a blog about IT, airports and social media and on the other hand a start-up platform. Here new software solutions for the aviation industry are developed, with a focus on “Twittairport -Airport on Twitter in Numbers" or "Standardized Collection of Traffic Data at Airports for Billing, Marketing and Operations“.
Presentation made on 21 January 2014.Photo credits: © Jörg Hackemann, Orlando Florin Rosu, kalafoto, Acik, Visual Concepts,Helder Almeida, Michael Nivelet (Fotolia.com).