公車路線規劃系統之資料自動收集系統實作

以作者查詢圖書館館藏

、以作者查詢臺灣博碩士

、以作者查詢全國書目

、勘誤回報

、線上人數：31

、訪客IP：3.129.210.224

姓名

韓亞當(Adam Hendra Brata) 查詢紙本館藏

畢業系所

資訊工程學系

論文名稱

公車路線規劃系統之資料自動收集系統實作
(Software Development of Automatic Data Collector for Bus Route Planning System)

相關論文

★ 基於最大期望算法之分析陶瓷基板機器暗裂破片率	★ 基於時間序列預測的機器良率預測
★ 基於OpenPose特徵的行人分心偵測	★ 建構深度學習CNN模型以正確分類傳統AOI模型之偵測結果
★ 一種結合循序向後選擇法與回歸樹分析的瑕疵肇因關鍵因子擷取方法與系統－以紡織製程為例	★ 融合生成對抗網路及領域知識的分層式影像擴增
★ 針織布異常偵測方法研究	★ 基於工廠生產資料的異常機器維修預測
★ 萃取駕駛人在不同環境之駕駛行為方法	★ 基於刮痕瑕疵資料擴增的分割拼接影像生成
★ 應用卷積神經網路於航攝影像做基於坵塊的水稻判釋之研究	★ 採迴歸樹進行規則探勘以有效同時降低多種紡織瑕疵
★ 應用增量式學習於多種農作物判釋之研究	★ 應用自動化測試於異質環境機器學習管道之 MLOps 系統
★ 農業影像二元分類：坵塊分離的檢測	★ 應用遷移學習於胚布瑕疵檢測

檔案

[Endnote RIS 格式]

[Bibtex 格式]

[相關文章]

[文章引用]

[完整記錄]

[館藏目錄]

[檢視]

[下載]

本電子論文使用權限為同意立即開放。
已達開放權限電子全文僅授權使用者為學術研究之目的，進行個人非營利性質之檢索、閱讀、列印。
請遵守中華民國著作權法之相關規定，切勿任意重製、散佈、改作、轉貼、播送，以免觸法。

摘要(中)

在台灣大眾運輸工具普遍被人們使用，近年來公車路線規劃手機程式開始被用於幫助使用者去取得並使用公車資訊，以台北公車使用為主大部分的公車路線規劃手機程式提供使用者台北公車處獲得的原始資訊，其中主要問題是台北公車處提供不準確的資訊，而且是難以理解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

關鍵字(中)

★ 自動化系統
★ 公車路線規劃
★ Java伺服器應用
★ 資料收集

關鍵字(英)

★ 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.1 Background 1
1.2 Motivation 4
1.3 Research Objective 5
1.4 Thesis Structure 5
CHAPTER 2 6
LITERATURE REVIEW 6
2.1 Bus Route Planning System 6
2.2 Software Development Model and Programming Strategy 9
2.2.1 Incremental Software Development Model 9
2.2.2 Design Pattern 10
2.2.2.1 Model View Controller 11
2.3 Data Collection 13
2.4 Web Service API 13
2.4.1 XML 14
2.4.2 Taipei Bus API 16
2.4.3 OpenWeatherMap 17
2.4.4 Google Distance Matrix API 18
2.4.5 XML in Java 19
2.5 Java Database Connectivity and Manipulation 19
2.5.1 Object Relational Mapping 19
2.5.2 Java Persistence API 20
2.5.3 Java Database Connectivity 20
2.6 Batch Processing 21
2.6.1 Batch Processing 21
2.6.2 Java Batch Processing 22
CHAPTER 3 23
METHODOLOGY 23
3.1 Research Design 23
3.2 System Design 24
3.2.1 Software Description 24
3.2.2 System Scheme 26
3.2.3 Data Processing Scheme 27
3.2.4 Requirement List 28
3.2.5 Use Case Diagram 29
3.2.5.1 Use Case Diagram for Data Collector Functionality 30
3.2.5.2 Use Case Diagram for Data Updater Functionality 33
3.2.5.3 Use Case Diagram for Data Management Functionality 34
3.2.6 Data Analysis 39
3.2.7 Architectural Design 40
3.2.7.1 Prototype 1 40
3.2.7.2 Prototype 2 42
3.2.8 Sequence Diagram 44
3.2.8.1 Sequence Diagram for Data Collector Functionality 45
3.2.8.2 Sequence Diagram for Data Updater Functionality 47
3.2.8.3 Sequence Diagram for Data Management Functionality 48
3.2.9 Graphical User Interface Design 55
3.2.9.1 Graphical User Interface Design for Data Collector Page 55
3.2.9.2 Graphical User Interface Design for Data Management Page 56
3.3 System Implementation 58
3.3.1 System Specification for Implementation 58
3.3.1.1 Hardware Environment 58
3.3.1.2 Software Environment 58
3.3.2 Database Implementation 59
3.3.3 Class and Architecture Implementation 61
3.3.3.1 Prototype 1 61
3.3.3.2 Prototype 2 62
3.3.4 Graphical User Interface Implementation 62
3.4 System Testing 64
3.4.1 Functional Testing 64
3.4.1.1 Test Case for Collect Estimate Time and Weather Data 65
3.4.1.2 Test Case for Collect Bus Event Data 65
3.4.1.3 Test Case for Collect Bus Data 65
3.4.1.4 Test Case for Collect Car Unusual Data 66
3.4.1.5 Test Case for Stop Data Collecting by Press Stop Button 66
3.4.1.6 Test Case for Update the Most Updated Data 66
3.4.1.7 Test Case for Stop Update the Most Updated Data by Press Stop Button 67
3.4.1.8 Test Case for Renew Route Data 67
3.4.1.9 Test Case for Renew Car Information Data 67
3.4.1.10 Test Case for Renew Stop Data 68
3.4.1.11 Test Case for Open SQL Manager 68
3.4.1.12 Test Case for Canceling Open SQL Manager by Press Cancel Button 68
3.4.1.13 Test Case for Save System Log 69
3.4.1.14 Test Case for Cancelling Save System Log by Press Cancel Button 69
3.4.1.15 Test Case for Renew Distance Data 69
3.4.1.16 Test Case for Data Visualization 70
3.4.2 Performance Testing 70
3.4.2.1 Data Collection Running Testing 71
3.4.2.2 Database Stress Testing 72
3.4.2.3 Database Query Execution Testing 72
3.4.2.4 System Processing Time Testing 73
CHAPTER 4 74
RESULT AND ANALYSIS 74
4.1 Functionality Testing Result 74
4.2 Performance Testing Result 76
4.2.1 Data Collection Running Testing 76
4.2.2 Database Stress Testing Result 79
4.2.3 Database Query Execution Testing 80
4.2.4 System Processing Time Testing 82
CHAPTER 5 85
CONCLUSION 85
5.1 Conclusion 85
5.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.

指導教授

梁德容、Sholeh Hadi Pramono
(Deron Liang、Sholeh Hadi Pramono)

審核日期

2014-7-30

推文