XML- based Automated Data Collection 8 th International Forum on Tourism Statistics 14. November 2006, Cáceres, Spain Ville Vertanen ville. vertanen@stat. fi
Slide only in handout Introduction - Strategies Statistics Finland’s Strategy for EDR (Electronic Data Reporting) n To offer an electronic option in all data collections by 2007 (not in person statistics) n It’s the respondent’s choice whether to use it or not Business Data Collections n About 50 surveys (excluding collections with less than 30 respondents) n 45 Web (Internet form) collections in use 8 th Internationa Forum on Business 2
Tourism Statistics n n Monthly questionnaire l Includes all establishments with 10 or more rooms, cottages or caravan pitches l Covers 90% of room capacity in Finland Enquiry covers 1, 406 accommodation establishments in 2006, of which 756 hotels 185 similar establishments 283 camping sites 132 holiday villages 50 youth hostels 8 th Internationa Forum on Business 3
Slide only in handout Data collection for Tourism Statistics Up to 2005 collected information was keyed manually from paper forms into our database n From the beginning of 2005 it has been possible to respond by an Internet questionnaire (09/2006 ~250 answers) l Information is entered manually into the questionnaire n From autumn 2005 it has been possible to send information direct from hotel management systems into our collection database (09/2006 ~55 answers) l Typically, no manual input needed at Statistics Finland or at hotels n 8 th Internationa Forum on Business 4
Slide only in handout Data collection with paper questionnaire Accommodation establishment manual Database Accommodation establishment manual Statistics Finland Accommodation establishment print Accommodation establishment manual Accommodation establishment print manual Manual phases needed From SF to accomm. est. - Reminders and feedback by mail Head agency 8 th Internationa Forum on Business 5
Data collection via the Internet Accommodation establishment manual -Manual input needed at hotels but not at Statistics Finland Accommodation establishment - Reminders and feedback by email Statistics Finland Database manual 8 th Internationa Forum on Business 6
Direct data collection Accommodation establishment Head agency - No manual input needed - Reminders and feedback by email Accommodation establishment Statistics Finland Database Accommodation establishment 8 th Internationa Forum on Business 7
Slide only in handout Direct data collection Data are delivered direct from hotel management systems into our database l No manual work needed (except to initiate the transfer) n After their reception data are submitted to the standard validation process n Software vendors implement a module for the hotel’s management software using Statistics Finland’s definitions for data and service interface n Implemented using typical B 2 B integration technique: XML Web Services n 8 th Internationa Forum on Business 8
Response activity via the Internet 8 th Internationa Forum on Business 9
8 th Internationa Forum on Business 10
Definition of automated reporting n Information is saved on specified XML -file. Why? XML -file can be specified accurately with XML -schema l much of new data is based on XML l n XML -file is send by using Web Service. Why? After we have specified the WSDL description, the actual Web Service implementation takes just hours l In Web Service we can control the transmission and authentication. User is informed ether success or failure l 8 th Internationa Forum on Business 11
Experiences in Finland ”Data reporting is now extremely easy” said in Trade Magazine for Hotels and Restaurants. n Data quality is good n Data is coming faster than before, just few days after reference period n Response burden is almost zero, previously 1 -2 hours per month. n Cost have reduced in means of working hours, mailing and printing expenses n Internet form is not used widely because printing and faxing reports is easier n 8 th Internationa Forum on Business 12
Encountered problems n n n Room capacity and opening days are not always updated l Correction is possible through web form Updating hotel software’s takes time One country is a small market for a global software house. When there are different systems in every country it takes a long time to implement this system 8 th Internationa Forum on Business 13
How about international standard for automated data reporting? Standard data delivery specification (Web Service or ftp or…) n Standard file format (XML or txt or …) n Standard file description, same file for every country n l n Take what you need, leave the rest Benefits Software houses need to build only one system, this leads to faster implementation l Maybe free for the user, because no country specifications is needed l Good comparability between countries l Hotels can send the same file for example to their head agency l 8 th Internationa Forum on Business 14
Contact: Mr. Ville Vertanen ville. vertanen@stat. fi tel. +358 9 1734 3343 References: n Using the Web for collecting data for business statistics in Finland (Prepared by Ilkka Hyppönen), UNECE / CES Plenary Session (Geneva, 13 -15 June 2005). l http: //www. unece. org/stats/documents/ces/2005/8. e. pdf 8 th Internationa Forum on Business 15
Скачать презентацию XML- based Automated Data Collection 8 th International
520790e7a1ac2f0f7efe89c7f8719ef6.ppt