公車路線規劃系統之資料自動收集系統實作｜國立中央大學博碩士論文系統

簡易檢索 / 詳目顯示

回結果列表

研究生：	韓亞當 Adam Hendra Brata
論文名稱：	公車路線規劃系統之資料自動收集系統實作 Software Development of Automatic Data Collector for Bus Route Planning System
指導教授：	梁德容 Deron Liang Sholeh Hadi Pramono Sholeh Hadi Pramono
口試委員:
學位類別：	碩士 Master
系所名稱：	資訊電機學院 - 資訊工程學系 Department of Computer Science & Information Engineering
論文出版年：	2014
畢業學年度：	102
語文別：	英文
論文頁數：	109
中文關鍵詞：	自動化系統、公車路線規劃、Java伺服器應用、資料收集
外文關鍵詞：	Automated System, Bus Route Planning, Java Server Application, Data Collector
相關次數：	點閱：16 下載：0
分享至:	分享至facebook 分享至twitter

查詢本校圖書館目錄查詢臺灣博碩士論文知識加值系統勘誤回報

在台灣大眾運輸工具普遍被人們使用，近年來公車路線規劃手機程式開始被用於幫助使用者去取得並使用公車資訊，以台北公車使用為主大部分的公車路線規劃手機程式提供使用者台北公車處獲得的原始資訊，其中主要問題是台北公車處提供不準確的資訊，而且是難以理解GUI上所提供的資訊，所以為了解決這兩項問題我們需要兩種解決方案，第一是我們需要建構出精確的時間預估系統來預測公車到站時間，第二是我們使用擴增實境的技術來建構我們系統的使用者介面使得資訊更加簡單理解。
在這篇論文我們提出Automatic Data Collector系統去幫助前一段落提到的兩項解決方案的開發，我們提出的系統擁有兩項主要功能，第一是資料收集功能提供資料來建立時間預估系統的模組，第二是資料更新功能提供公車最新的資訊用於擴增實境的使用者介面，此外還提供資料管理功能使得本系統提供更好的功能來幫助建構兩個相關的系統。
我們使用設計批次處理結合SQL語言並使用Java語言開發Automatic Data Collector系統，最後我們進行測試證實我們的系統比實驗室現有的公車規劃系統的伺服器於資料庫存取大量資料的問題下取得較好的效能。

關鍵字：自動化系統、公車路線規劃、Java伺服器應用、資料收集

Public transportation is important issue in Taiwan. Recently, mobile application named Bus Route Planning was developed to help the user to get information about public transportation using bus. But, this application often gave the user inaccurate bus information and this application has less attractive GUI. To overcome those two problems, we need two kinds of solutions. First, we need a more accurate time prediction algorithm to predict the arrival time of bus. Second, we can use augmented reality technology to make an GUI improvement.
In this thesis, we proposed a Automatic Data Collector system that have ability to gave a support for those two solutions at once. This proposed system has two main functionalities. First, data collector function to provide us data set that can be further analyzed as an base of time prediction algorithm. Second, data updater function to provide us the most updated bus information to used in augmented reality system. Additionally, beside those two mentioned functions, we add one additional data management function to give our system better functionality to support those two related systems.
We developed this proposed system using batch data processing scenario and SQL native query in Java programming language. Finally, after we done some testing, we conclude that our proposed system is better than the current server system and the data processing scenario that used in our proposed system was very effective to made database manipulation especially for large-sized data.

Keywords : Automated System, Bus Route Planning, Java Server Application, Data Collector

摘       要    i
ABSTRACT    ii
ACKNOWLEDGEMENTS    iii
TABLE OF CONTENTS    iv
LIST OF FIGURES    viii
LIST OF TABLES    x
CHAPTER 1    1
INTRODUCTION    1
1    Background    1
2    Motivation    4
3    Research Objective    5
4    Thesis Structure    5
CHAPTER 2    6
LITERATURE REVIEW    6
1    Bus Route Planning System    6
2    Software Development Model and Programming Strategy    9
2.1    Incremental Software Development Model    9
2.2    Design Pattern    10
2.2.1    Model View Controller    11
3    Data Collection    13
4    Web Service API    13
4.1    XML    14
4.2    Taipei Bus API    16
4.3    OpenWeatherMap    17
4.4    Google Distance Matrix API    18
4.5    XML in Java    19
5    Java Database Connectivity and Manipulation    19
5.1    Object Relational Mapping    19
5.2    Java Persistence API    20
5.3    Java Database Connectivity    20
6    Batch Processing    21
6.1    Batch Processing    21
6.2    Java Batch Processing    22
CHAPTER 3    23
METHODOLOGY    23
1    Research Design    23
2    System Design    24
2.1    Software Description    24
2.2    System Scheme    26
2.3    Data Processing Scheme    27
2.4    Requirement List    28
2.5    Use Case Diagram    29
2.5.1    Use Case Diagram for Data Collector Functionality    30
2.5.2    Use Case Diagram for Data Updater Functionality    33
2.5.3    Use Case Diagram for Data Management Functionality    34
2.6    Data Analysis    39
2.7    Architectural Design    40
2.7.1    Prototype 1    40
2.7.2    Prototype 2    42
2.8    Sequence Diagram    44
2.8.1    Sequence Diagram for Data Collector Functionality    45
2.8.2    Sequence Diagram for Data Updater Functionality    47
2.8.3    Sequence Diagram for Data Management Functionality    48
2.9    Graphical User Interface Design    55
2.9.1    Graphical User Interface Design for Data Collector Page    55
2.9.2    Graphical User Interface Design for Data Management Page    56
3    System Implementation    58
3.1    System Specification for Implementation    58
3.1.1    Hardware Environment    58
3.1.2    Software Environment    58
3.2    Database Implementation    59
3.3    Class and Architecture Implementation    61
3.3.1    Prototype 1    61
3.3.2    Prototype 2    62
3.4    Graphical User Interface Implementation    62
4    System Testing    64
4.1    Functional Testing    64
4.1.1    Test Case for Collect Estimate Time and Weather Data    65
4.1.2    Test Case for Collect Bus Event Data    65
4.1.3    Test Case for Collect Bus Data    65
4.1.4    Test Case for Collect Car Unusual Data    66
4.1.5    Test Case for Stop Data Collecting by Press Stop Button    66
4.1.6    Test Case for Update the Most Updated Data    66
4.1.7    Test Case for Stop Update the Most Updated Data by Press Stop Button    67
4.1.8    Test Case for Renew Route Data    67
4.1.9    Test Case for Renew Car Information Data    67
4.1.10    Test Case for Renew Stop Data    68
4.1.11    Test Case for Open SQL Manager    68
4.1.12    Test Case for Canceling Open SQL Manager by Press Cancel Button    68
4.1.13    Test Case for Save System Log    69
4.1.14    Test Case for Cancelling Save System Log by Press Cancel Button    69
4.1.15    Test Case for Renew Distance Data    69
4.1.16    Test Case for Data Visualization    70
4.2    Performance Testing    70
4.2.1    Data Collection Running Testing    71
4.2.2    Database Stress Testing    72
4.2.3    Database Query Execution Testing    72
4.2.4    System Processing Time Testing    73
CHAPTER 4    74
RESULT AND ANALYSIS    74
1    Functionality Testing Result    74
2    Performance Testing Result    76
2.1    Data Collection Running Testing    76
2.2    Database Stress Testing Result    79
2.3    Database Query Execution Testing    80
2.4    System Processing Time Testing    82
CHAPTER 5    85
CONCLUSION    85
1    Conclusion    85
2    Discussions and Future Works    86
BIBLIOGRAPHY    87

                                

[1] International Monetary Fund : World Economic Outlook Database 2014. May, 2014, taken from www.imf.org.

[2] Taiwan Tourism Bureau : Visitor Arrivals by Purpose of Visit. January, 2014,
taken from www.admin.taiwan.net.tw.

[3] Wikipedia : Public transport. July 23, 2014,
taken from http://en.wikipedia.org/wiki/Public_transport.

[4] Boyce, David, Transportation Systems - Encyclopedia of Life Support Systems, Eolss Publishers, Oxford, USA, 2005.

[5] American Public Transportation Association, Public Transportation : Benefits for the 21st Century, American Public Transportation Association, USA, 2007.

[6] SORUPIA, Eden, “Rethinking The Role Of Transportation In Tourism”, Proceedings of the Eastern Asia Society for Transportation Studies, Vol. 5, pp. 1767 – 1777, 2005.

[7] Albalate, Daniel and Germa` Bel, “Tourism and urban public transport: Holding demand pressure under supply constraints”, Elsevier Journal on Tourism Management, Volume 31, Issue 3, Pages 425–433, June 2010.

[8] Lan, Lawrence W., Ming-Te Wang and April Y. Kuo, “Development and deployment of public transport policy and planning in Taiwan”, Springer Journal on Transportation, Volume 33, Issue 2, pp pp 153-170, March 2006.

[9] Taipei City Public Transportation Office : Taipei Bus Dynamic API, 2014,
taken from http://www.5284.com.tw/Dybus.aspx?Lang=En

[10] Ehlert, Steffi, Hamburg and Julian Frank, City Development of Taipei - Discovering the Geography of Taiwan : A Field Trip Report, Institute of Geography - University of Hamburg, Hamburg, 2009.

[11] Taiwan Department of Transportation : Fun Travel in Taipei, 2011,
Taken from :
http://english.dot.taipei.gov.tw/ct.asp?xItem=51165215&ctNode=65619&mp=117002

[12] Software Methodology Laboratory, “Bus Route Planner Application”, National Central University, Private communication, Taiwan, 2013.

[13] Fanani, Lutfi, “Bus Arrival Prediction – to Ensure Users Not to Miss the Bus (Preliminary Study based on Bus Line 243 Taipei)”, National Central University, Master Thesis, Taiwan, 2014.

[14] Brata, Komang Candra, “Developing Location-Based Augmented Reality Information Support for Bus Route Planning System”, National Central University, Master Thesis, Taiwan, 2014.

[15] L. Zhao and L. Bhuyan, “Performance Evaluation and Acceleration for XML Data Parsing”, Proc. 9th Workshop Computer Architecture Evaluation Using Commercial Workloads (CAECW 06), Texas, USA, 2006.

[16] Nicola, Mathias and Jasmi John, “XML Parsing: A Threat to Database Performance”, Proc. 12th Int’l Conf. Information and Knowledge Management (CIKM 03) pp. 175-178, ACM Press, New York, USA, 2003.

[17] Dwyer, Barry, “The Automatic Design of Batch Processing Systems”, University of Adelaide, Doctoral Thesis, Australia, 1999.

[18] Wikipedia : Incremental Build Model. April 7, 2014,
Taken from : http://en.wikipedia.org/wiki/Incremental_build_model.

[19] Pressman, Roger S., Software Engineering: a practitioner’s approach,7th edition, Mc Graw Hill, New York, 2010.

[20] The Office of Research Integrity : Data Collection. 2005,
Taken from :
http://ori.hhs.gov/education/products/n_illinois_u/datamanagement/dctopic.html.

[21] Word Wide Web Consortium (W3C) : Web Services Glossary. February 11, 2004,
Taken from : http://www.w3.org/TR/2004/NOTE-ws-gloss-20040211/#webservice.

[22] Word Wide Web Consortium (W3C) : Extensible Markup Language (XML) 1.0 (Second Edition). October 6, 2000,
Taken from : http://www.w3.org/TR/2000/REC-xml-20001006.pdf.

[23] Wikipedia : XML. July 25, 2014,
Taken from : http://en.wikipedia.org/wiki/XML.

[24] Chappel, David and Tyler Jewell, Java Web Services, O'Reilly Media, Sebastopol, California, 2002.

[25] OpenWeatherMap : OpenWeatherMap. 2014,
Taken from : http://openweathermap.org/.

[26] Google : Google Maps API - Google Distance Matrix API. June 12, 2014,
Taken from : https://developers.google.com/maps/documentation/distancematrix/.

[27] Ambler, Scott W : Mapping Objects to Relational Databases - O/R Mapping In Detail. 2006,
Taken from : http://www.agiledata.org/essays/mappingObjects.html.

[28] Keith, Mike and Merrick Schincariol, Pro JPA 2 Mastering the Java™ Persistence API, Apress Media Publisher, New York, 2009.

[29] Wikispaces : Batch, Online & real time Processing. November 3, 2010,
Taken from :
http://dis-dpcs.wikispaces.com/3.3.5+Batch,+Online+%26+real+time+Processing

[30] Walker, Michael : Batch vs. Real Time Data Processing. August 13, 2013,
Taken from :
http://www.datasciencecentral.com/profiles/blogs/batch-vs-real-time-data-processing

[31] Oracle : Oracle TimesTen In-Memory Database Java Developer's Guide. June 2014,
Taken from :
http://download.oracle.com/otn_hosted_doc/timesten/1122/doc/timesten.1122/e21638/tuning.htm#TTJDV251

[32] Software Methodology Laboratory, “Bus Route Planner Server Application”, National Central University, Private Communication, Taiwan, 2013.

[33] Pelc, Alejandro : Eye on SQL – Load Test. April 7, 2013,
Taken from :
http://eyeonsqlloadtest.codeplex.com/

[34] Ray, Erik T., Learning XML, 2nd Edition, O'Reilly Media, Sebastopol, California, 2003.

[35] Visual Paradigm : Object Relational Mapping. March 21, 2006,
Taken from :
http://oldresources.visual-paradigm.com/_media/object_relational_mapping/visual_modeling/showing_object_relational_mapping/showing_object_relational_mapping-8.jpg?w=&h=&cache=cache

[36] North Caroline State University : Object Relational Mapping. 2010,
Taken from :
http://wiki.expertiza.ncsu.edu/images/2/2c/ORM_Flowchart.jpg

[37] Wikipedia : Software Design Pattern. July 25, 2014,
Taken from : http://en.wikipedia.org/wiki/Software_design_pattern.

[38] Alexander, Christopher, Sara Ishikawa and Murray Silverstein, A Pattern Language : Towns, Building, Construction, Oxford University Press, Oxford, 1977.

[39] Gamma, Erich, et al., Design Patterns : Elements of Reusable Object-Oriented Software, Pearson Education, New Jersey, 1994.

[40] Wikipedia : Journey Planner. July 24, 2014,
Taken from : http://en.wikipedia.org/wiki/Journey_planner.

[41] UK Department for Transport : Journey Planner. April 19, 2014,
Taken from : http://www.dft.gov.uk/journeyweb/.

[42] Google : Google Maps, June 12, 2014,
Taken from : https://developers.google.com/maps/.

[43] OpenStreetMap : OpenStreetMap. 2014,
Taken from : http://www.openstreetmap.org/.

[44] Biagoni, James et al., “EasyTracker: Automatic Transit Tracking, Mapping, and Arrival
Time Prediction Using Smartphones”, Proceedings of the 9th ACM Conference on Embedded Networked Sensor Systems pp. 68-81, ACM Press, New York, USA, 2011.

[45] Zhou, Yuhong, Jean-Claude Thill and Zhengdong Huang, “EasyTracker: Automatic Transit Tracking, Mapping, and Arrival Time Prediction Using Smartphones”, Elsevier Journal on Applied Geography, Vol 31, Issue 3, pp. 1173–1184, July 2011.

[46] Buschmann, Frank et al., Pattern-Oriented Software Architecture Volume 1: A System of Patterns: Model View Controller. Wiley Publisher, Hoboken, USA, 1996.

[47] Zečević, Anđelka : Model View Controller. 2012,
Taken from : http://poincare.matf.bg.ac.rs/~andjelkaz/pzv/cas4/mvc.pdf.

[48] Patel, Pratik, Java Database Programming with JDBC: Discover the Essentials for Developing Databases for Internet and Intranet Applications, 2nd Edition, Coriolis Group, Scottsdale, Arizona, 1997.

簡易檢索 / 詳目顯示

相關論文