TWI384746B - A database used in a solar panel associated with a wireless monitoring system and a method for controlling the same - Google Patents
A database used in a solar panel associated with a wireless monitoring system and a method for controlling the same Download PDFInfo
- Publication number
- TWI384746B TWI384746B TW98125225A TW98125225A TWI384746B TW I384746 B TWI384746 B TW I384746B TW 98125225 A TW98125225 A TW 98125225A TW 98125225 A TW98125225 A TW 98125225A TW I384746 B TWI384746 B TW I384746B
- Authority
- TW
- Taiwan
- Prior art keywords
- data
- database
- solar panel
- monitoring system
- terminal devices
- Prior art date
Links
Landscapes
- Photovoltaic Devices (AREA)
- Selective Calling Equipment (AREA)
Description
本發明係揭露一種使用於太陽能板無線監控系統之資料庫及其控制方法，尤指利用一資料庫永久儲存太陽能板之狀態參數資料，並利用一資料分析程式對太陽能板之狀態參數資料進行分析。The invention discloses a database for a solar panel wireless monitoring system and a control method thereof, in particular, using a database to permanently store state parameter data of a solar panel, and analyzing a state parameter data of the solar panel by using a data analysis program. .
目前全球的用油和家庭用油的價格居高不下，已經是普遍的現象。石油與煤炭，因人口過多加上人類的大量使用結果，讓人類用油的年數減少許多，地球上也因能源使用過度而出現種種環境生態之破壞。因此，為了因應石油和煤炭的快速減少，而能源需求卻愈來愈多的情況之下，人類不得不發展其他替代能源。此時，便是使用再生能源的最好時刻。The current high prices of oil and household oils around the world are already common. Oil and coal, due to the overpopulation and the large-scale use of human beings, have reduced the number of years of human oil use, and the destruction of various environmental and ecological environments on the earth due to excessive energy use. Therefore, in response to the rapid decline in oil and coal, and the increasing demand for energy, human beings have to develop alternative energy sources. At this time, it is the best time to use renewable energy.
由太陽輻射出來的能量相當龐大，據估計，其中34%反射回太空中，19%被大氣吸收，47%才被地表吸收使用，但一年中太陽傳送到地球的能量有1.3×1024 卡，這些能量是全人類一年使用總能量的26000倍，所以，祇要能多加利用，太陽能有潛力可以成為真正的永久能源。The energy radiated by the sun is quite large. It is estimated that 34% of it is reflected back into space, 19% is absorbed by the atmosphere, and 47% is absorbed by the surface, but the energy transmitted by the sun to the earth during the year is 1.3×10 24 cards. These energies are 26,000 times the total energy used by all humans in a year, so as long as they can be used more, solar energy has the potential to become a true permanent energy source.
利用太陽能板進行太陽能的吸收，已經是近年來相當熱門的課題，在不斷的研究與改良之下，太陽能板的使用效率以及使用範圍已越來越進步。一般來說，太陽能板在實際使用時，需注意的狀態參數包含溫度、濕度及電壓，若能對於這些參數進行良好的監控，自然能達到理想的使用情形。然而，在習知的太陽能板監控作業中，通常皆由工作人員在現場定時監測，避免太陽能板出現突發之異常狀況。亦有習知技術利用感測器進行量測，再以線路將資料傳送至監控之設備，但由於線路長度有限，若太陽能板與監控設備距離太遠，便會難以進行線路設置，另外，由於電線線路在長時間使用下，有折損之疑慮，此亦其不足之處。The use of solar panels for solar energy absorption has been a hot topic in recent years. With continuous research and improvement, the efficiency and range of use of solar panels have been increasing. In general, when the solar panel is actually used, the state parameters to be noted include temperature, humidity, and voltage. If these parameters are well monitored, the ideal use situation can be achieved. However, in the conventional solar panel monitoring operation, it is usually monitored by the staff at the site to avoid sudden abnormal conditions of the solar panel. There are also known techniques that use sensors to measure and then transmit data to the monitored equipment by line. However, due to the limited length of the line, if the solar panel is too far away from the monitoring equipment, it will be difficult to set up the line. When the wire line is used for a long time, there is a doubt that the wire is broken, and this is also a disadvantage.
再者，由於太陽能板係每分每秒都在進行太陽能轉換的工作，因此，太陽能板狀態資料的採集工作也必須盡量密集，才能達到及時監控的目的。由於資料採集密集的進行，相對的也產生非常龐大的資料，因此必須設計一資料庫才得以儲存這些資料，並加以分析。Furthermore, since the solar panel is performing solar energy conversion every minute, the collection of solar panel status data must be as dense as possible in order to achieve timely monitoring. Due to the intensive data collection, relatively large amounts of data are generated. Therefore, a database must be designed to store and analyze the data.
有鑑於此，必須發展出一套不需電線線路之太陽能板監控系統，並利用一可靠的資料庫系統以儲存資料，以達到及時監控及資料儲存分析的目的。In view of this, it is necessary to develop a solar panel monitoring system that does not require wire lines, and utilize a reliable database system to store data for timely monitoring and data storage analysis.
請參照申請書及相關證明文件所示，本發明所揭露之內容雖已公開於民國98年4月25日所舉辦之第五屆全國電子設計創意競賽，依據專利法第22條第2項第2款之規定：「發明有下列情事之一，致有前項各款情事，並於其事實發生之日起六個月內申請者，不受前項各款規定之限制：二、因陳列於政府主辦或認可之展覽會者」，本發明並未喪失新穎性。Please refer to the application form and relevant supporting documents. The contents disclosed in the present invention have been disclosed in the 5th National Electronic Design Innovation Competition held on April 25, 1998, in accordance with Article 22, Item 2 of the Patent Law. The provisions of paragraph 2: "Inventors have one of the following circumstances, and the applicants of the preceding paragraphs, and within six months from the date of their occurrence, are not subject to the provisions of the preceding paragraphs: Second, due to display in the government The present invention has not lost its novelty.
故，有鑑於前述之問題與缺失，發明人以多年之經驗累積，並發揮想像力與創造力，在不斷試作與修改之後，始有本發明之一種使用於太陽能板無線監控系統之資料庫及其控制方法。Therefore, in view of the aforementioned problems and deficiencies, the inventors have accumulated years of experience, and exerted imagination and creativity. After continuous trial and modification, the invention has a database for solar panel wireless monitoring system and Control Method.
本發明之第一目的係提供一種使用於太陽能板無線監控系統之資料庫及其控制方法，以將資料永久儲存，即在一伺服裝置中設置一資料庫系統，當該伺服裝置接收到太陽能板之狀態參數資料後，可將資料自動並永久儲存於該資料庫中。A first object of the present invention is to provide a database for a solar panel wireless monitoring system and a control method thereof for permanently storing data, that is, a database system is provided in a servo device, and when the servo device receives a solar panel After the status parameter data, the data can be automatically and permanently stored in the database.
本發明之第二目的係提供一種使用於太陽能板無線監控系統之資料庫及其控制方法，以進行資料之分析，即在一伺服裝置中設置一資料庫系統及一資料分析程式，當該伺服裝置接收到太陽能板之狀態參數資料後，可利用該資料分析程式對太陽能板之狀態參數資料進行分析，再將分析後之資料分類儲存於資料庫中。A second object of the present invention is to provide a database for a solar panel wireless monitoring system and a control method thereof for performing data analysis, that is, setting a database system and a data analysis program in a servo device, when the servo After receiving the state parameter data of the solar panel, the device may analyze the state parameter data of the solar panel by using the data analysis program, and then store the analyzed data in the database.
本發明之第三目的係提供一種使用於太陽能板無線監控系統之資料庫及其控制方法，讓管理員或其他使用者可得到即時訊息，即當一伺服裝置接收到太陽能板之狀態參數資料後，可將資料進行分析並儲存於一資料庫中，再將該資料庫中之資料藉由網路發布至網站及行動裝置中。A third object of the present invention is to provide a database for a solar panel wireless monitoring system and a control method thereof, so that an administrator or other user can obtain an instant message, that is, when a servo device receives the state parameter data of the solar panel. The data can be analyzed and stored in a database, and the data in the database is posted to the website and the mobile device through the Internet.
本發明係揭露一種使用於太陽能板無線監控系統之資料庫及其控制方法，係包含：複數個感測終端裝置，該複數個感測終端裝置係分別設置複數個太陽能板上，複數個感測終端裝置可對太陽能板進行各種狀態參數之量測；一中心協調裝置，該中心協調裝置可與複數個感測終端裝置以無線射頻方式互相進行數據資料之傳輸；一監控裝置，該監控裝置以一線路與中心協調裝置連接，並可接收來自中心協調裝置之數據資料，而這些數據資料系暫存於監控裝置中，並非永久保存；一伺服裝置，該伺服裝置與監控裝置以網路進行連結，並可互相進行數據資料之傳輸；及一資料庫，該資料庫設置於伺服裝置中，當監控裝置將數據資料傳送至伺服裝置後，伺服裝置利用一資料分析程式對這些數據資料進行分析，再將分析後之數據資料永久儲存於資料庫中，資料庫更至少含有一總體資料表及一異常資料表。The invention discloses a database for a solar panel wireless monitoring system and a control method thereof, comprising: a plurality of sensing terminal devices, wherein the plurality of sensing terminal devices respectively set a plurality of solar panels, and the plurality of sensing devices respectively The terminal device can perform measurement of various state parameters on the solar panel; a central coordination device that can transmit data data to each other in a radio frequency manner with a plurality of sensing terminal devices; and a monitoring device, the monitoring device A line is connected to the central coordination device and can receive data from the central coordination device, and the data is temporarily stored in the monitoring device and is not permanently stored; a servo device is connected to the monitoring device via the network And transmitting data data to each other; and a database, the database is set in the servo device, and after the monitoring device transmits the data data to the servo device, the server device analyzes the data data by using a data analysis program. The analyzed data is permanently stored in the database, the database Containing at least one abnormal overall table and a table.
為達前述之目的與功效，發明人將太陽能板與無線通訊網路做結合，並利用一完整之資料庫系統以及相關之控制程式，在不斷的修正與調整之下，始得到本發明之一種使用於太陽能板無線監控系統之資料庫及其控制方法。茲以本發明一較佳實施例之太陽能板無線監控系統，對本發明之系統架構及控制方法做詳細之介紹。In order to achieve the above purposes and effects, the inventors combined solar panels with wireless communication networks and used a complete database system and related control programs to obtain a use of the present invention under constant correction and adjustment. The database of solar panel wireless monitoring system and its control method. The system architecture and control method of the present invention will be described in detail in the solar panel wireless monitoring system according to a preferred embodiment of the present invention.
首先請參閱如第一圖所示，係本發明該較佳實施例之太陽能板無線監控系統之架構圖，其包含：複數個感測終端裝置110a、110b、110c，該複數個感測終端裝置110a、110b、110c係分別設置複數個太陽能板101a、101b、101c上，複數個感測終端裝置110a、110b、110c可對太陽能板101a、101b、101c進行各種狀態參數之量測，其中，複數個感測終端裝置110a、110b、110c更分別含有一多參數感測模組111a、111b、111c及一無線射頻模組112a、112b、112c，該多參數感測模組111a、111b、111c可對於該太陽能板101a、101b、101c進行多種參數資料的量測，而量測後所得到之資料再經由該無線射頻模組112a、112b、112c進行傳送，本發明之較佳實施例中，多參數感測模組111a、111b、111c可對於太陽能板101a、101b、101c之溫度及電壓進行量測；一中心協調裝置120，該中心協調裝置120可與複數個感測終端裝置110a、110b、110c以無線射頻方式互相進行數據資料之傳輸；一監控裝置130，該監控裝置130以一線路與中心協調裝置連接120，並可接收來自中心協調裝置120之數據資料，而這些數據資料係暫存於監控裝置130中，並非永久保存；一伺服裝置140，該伺服裝置140與監控裝置130以網路進行連結，並可互相進行數據資料之傳輸；一資料庫150，該資料庫150設置於伺服裝置140中，當監控裝置130將數據資料傳送至伺服裝置140後，伺服裝置140利用一資料分析程式141對這些數據資料進行分析，再將分析後之數據資料永久儲存於資料庫150中，資料庫150更含有一總體資料表151及一異常資料表152，其中，資料庫150係可選自於Access資料庫及SQL資料庫，而本發明之較佳實施例係使用Access資料庫做為架構基礎；及複數個外部行動裝置160a、160b、160c，伺服裝置140可將資料庫150之原始資料以及分析後之資料藉由網際網路傳送至該複數個外部行動裝置160a、160b、160c中，外部行動裝置160a、160b、160c之種類可以是行動電話、個人數位助理(personal digital assistant)、筆記型電腦及車用電話。First, please refer to the architecture diagram of the solar panel wireless monitoring system of the preferred embodiment of the present invention, which includes: a plurality of sensing terminal devices 110a, 110b, 110c, and the plurality of sensing terminal devices. 110a, 110b, 110c are respectively provided on a plurality of solar panels 101a, 101b, 101c, and a plurality of sensing terminal devices 110a, 110b, 110c can measure various state parameters of the solar panels 101a, 101b, 101c, wherein Each of the sensing terminal devices 110a, 110b, and 110c further includes a multi-parameter sensing module 111a, 111b, and 111c and a radio frequency module 112a, 112b, and 112c. The multi-parameter sensing module 111a, 111b, and 111c can be used. The solar panels 101a, 101b, and 101c are subjected to measurement of various parameter data, and the data obtained after the measurement is transmitted through the radio frequency modules 112a, 112b, and 112c. In the preferred embodiment of the present invention, The parameter sensing modules 111a, 111b, 111c can measure the temperature and voltage of the solar panels 101a, 101b, 101c; a central coordination device 120, the central coordination device 120 can be combined with a plurality of sensing terminal devices 110a , 110b, 110c transmit data data to each other in a radio frequency manner; a monitoring device 130, the monitoring device 130 is connected to the central coordination device 120 by a line, and can receive data data from the central coordination device 120, and the data data Temporarily stored in the monitoring device 130, not permanently stored; a servo device 140, the server device 140 and the monitoring device 130 are connected by a network, and can mutually transmit data data; a database 150, the database 150 The data is transmitted to the servo device 140. After the monitoring device 130 transmits the data to the server 140, the server 140 analyzes the data by using a data analysis program 141, and then stores the analyzed data in the database 150. The database 150 further includes an overall data table 151 and an abnormal data table 152. The database 150 can be selected from the Access database and the SQL database, and the preferred embodiment of the present invention uses the Access database. As an architectural basis; and a plurality of external mobile devices 160a, 160b, 160c, the server 140 can source the original data of the database 150 and The analyzed data is transmitted to the plurality of external mobile devices 160a, 160b, and 160c through the Internet. The types of the external mobile devices 160a, 160b, and 160c may be mobile phones, personal digital assistants, and notebooks. Computer and car phone.
接著請參閱如第二圖所示，係本發明較佳實施例之一種使用於太陽能板無線監控系統之資料庫之控制方法流程圖，控制方法包含以下步驟：(201) 複數個感測終端裝置110a、110b、110c分別對複數個太陽能板101a、101b、101c進行狀態參數之量測，其中，複數個感測終端裝置110a、110b、110c更分別含有一多參數感測模組111a、111b、111c及一無線射頻模組112a、112b、112c，該多參數感測模組111a、111b、111c可對於該太陽能板101a、101b、101c進行多種參數資料的量測，在本發明之較佳實施例中，係進行溫度及電壓之量測；(202) 複數個感測終端裝置110a、110b、110c分別利用該無線射頻模組112a、112b、112c將狀態參數資料傳送至中心協調裝置120中；(203) 中心協調裝置120利用RS232傳輸介面與監控裝置130連結，並將狀態參數資料傳送至監控裝置130中；(204) 監控裝置130與伺服裝置140進行網路連線；(205) 監控裝置130藉由網路將狀態參數資料傳送至伺服裝置140中；(206) 伺服裝置140利用資料分析程式141判斷狀態參數資料之格式是否錯誤，若是，則進行步驟(207)，若否，則進行步驟(208)；(207) 刪除格式錯誤之狀態參數資料，並進行步驟(204)；(208) 將狀態參數資料儲存於該資料庫150之該總體資料表151中，其中，資料庫150可選自於Access 資料庫及SQL資料庫，而本發明之較佳實施例係使用Access資料庫；(209) 伺服裝置140利用資料分析程式141判斷狀態參數資料是否異常，若是，則進行步驟(210)，若否，則進行步驟(211)，在本發明之較佳實施例中，將溫度資料之上限值設定為攝氏30度，將電壓資料之下限值設定為10V，若資料分析程式判斷溫度資料及電壓資料超過設定之範圍，便將此資料視為異常資料；(210) 將異常之狀態參數資料儲存於資料庫150中之該異常資料表152中，並進行步驟(211)；(211) 伺服裝置140利用網際網路將資料庫150之資料內容發佈於網站及複數個外部行動裝置160a、160b、160c上，該外部行動裝置160a、160b、160c可包含行動電話、個人數位助理(personal digital assistant)、筆記型電腦及車用電話；及(212) 監控裝置130判斷資料接收程序是否被工作人員控制而停止，若是，則結束步驟，若否，則進行步驟(204)。Next, please refer to a flow chart of a control method for a solar panel wireless monitoring system according to a preferred embodiment of the present invention. The control method includes the following steps: (201) a plurality of sensing terminal devices 110a, 110b, and 110c respectively measure the state parameters of the plurality of solar panels 101a, 101b, and 101c, wherein the plurality of sensing terminal devices 110a, 110b, and 110c respectively include a multi-parameter sensing module 111a, 111b, 111c and a radio frequency module 112a, 112b, 112c, the multi-parameter sensing module 111a, 111b, 111c can measure various parameter data for the solar panels 101a, 101b, 101c, in the preferred implementation of the present invention In the example, the temperature and voltage are measured; (202) the plurality of sensing terminal devices 110a, 110b, and 110c respectively transmit the state parameter data to the central coordination device 120 by using the radio frequency module 112a, 112b, and 112c; (203) The central coordination device 120 is connected to the monitoring device 130 by using the RS232 transmission interface, and transmits the state parameter data to the monitoring device 130; (204) the monitoring device 130 and the servo device 140 (205) the monitoring device 130 transmits the status parameter data to the server device 140 via the network; (206) the server device 140 uses the data analysis program 141 to determine whether the format of the status parameter data is incorrect, and if so, Go to step (207), if no, proceed to step (208); (207) delete the format error status parameter data, and perform step (204); (208) store the status parameter data in the total of the database 150 In the data table 151, the database 150 can be selected from the Access database and the SQL database, and the preferred embodiment of the present invention uses the Access database; (209) The servo device 140 uses the data analysis program 141 to determine the status parameter. Whether the data is abnormal, if yes, proceed to step (210), and if not, proceed to step (211). In the preferred embodiment of the present invention, the upper limit of the temperature data is set to 30 degrees Celsius, and the voltage data is The lower limit value is set to 10V. If the data analysis program determines that the temperature data and the voltage data exceed the set range, the data is regarded as abnormal data; (210) the abnormal state parameter data is stored in the database 150. In the abnormal data table 152, the step (211) is performed; (211) the servo device 140 uses the Internet to publish the data content of the database 150 on the website and the plurality of external mobile devices 160a, 160b, and 160c. The external mobile device 160a, 160b, 160c may include a mobile phone, a personal digital assistant, a notebook computer, and a car phone; and (212) the monitoring device 130 determines whether the data receiving program is stopped by the worker, if Then, the step is ended, and if not, step (204) is performed.
本發明所使用的無線網絡系統係名為Zigbee的無線網路系統，ZigBee是一種個人區域網路，特別為監測工業環境安全而設計。當初建構ZigBee是為了滿足市場對支援低資料速率、低功耗、安全可靠的基於標準的低成本無線網路的需求。請參照如第三A圖、第三B圖第三C圖所示，係分別為Zigbee無線網路系統所支援的三種網路架構示意圖，其中，圓形節點係表示中心協調裝置，一個網路可配置一個中心協調裝置；矩形節點係表示無線路由器，一個網路可配置數個無線路由器，但皆須與中心協調裝置連結；及三角形節點係表示終端裝置，可以是被控制之裝置或可進行感測之裝置，而終端裝置可與無線路由器連結，亦可直接與中心協調裝置連結。第三A圖為一種星狀(star)網路拓樸架構，其優點為容易同步化及延遲程度較低；第三B圖係為一種網狀(mesh)網路拓樸架構，其優點為允許多點傳播、網路形成較具彈性；及第三C圖係為一種叢集樹狀(cluster tree)網路拓樸架構，其優點為低路由成本以及允許多點傳播。而本發明之太陽能板無線監控系統係為一種星狀網路拓樸架構，由複數個感測終端裝置110a、110b、110c以及一個中心協調裝置120所組成。The wireless network system used in the present invention is a wireless network system called Zigbee, which is a personal area network, especially designed to monitor industrial environment security. ZigBee was originally created to meet the market's need for low-speed, low-power, secure, and reliable standards-based, low-cost wireless networks. Please refer to the three network diagrams supported by the Zigbee wireless network system, as shown in FIG. 3A and FIG. 3B and FIG. 3C. The circular node indicates the central coordination device and one network. A central coordination device can be configured; a rectangular node is a wireless router, a network can be configured with several wireless routers, but all must be connected with a central coordination device; and a triangular node is a terminal device, which can be a controlled device or can be performed. The sensing device, and the terminal device can be connected to the wireless router or directly connected to the central coordination device. The third A picture is a star network topology structure, which has the advantages of easy synchronization and low degree of delay; the third B picture is a mesh network topology, and the advantage is Allow multi-cast, network formation is more flexible; and the third C-picture is a cluster tree network topology, which has the advantages of low routing cost and allowing multi-point propagation. The solar panel wireless monitoring system of the present invention is a star network topology, and is composed of a plurality of sensing terminal devices 110a, 110b, 110c and a central coordination device 120.
本發明較佳實施例之系統架構係為一種整合式平台，在整合平台上，為達到節省成本及資源之消耗，監控裝置130之部分係使用一種嵌入式系統，該嵌入式系統是一種完全嵌入受控器件內部為特定應用設計的專用電腦系統。通常執行的是帶有特定要求的預先定義的任務，設計人員能夠對它進行優化，減小尺寸降低成本。再者，由於嵌入式系統通常進行大量生產，所以單個的成本節約能夠隨著產量進行成百上千的放大。本發明較佳實施例之嵌入式系統330之基本架構即如第四圖所示，嵌入式系統330所設置之軟體程式包含了完整之底層軟體331、作業系統332及應用程式333，而硬體部份包含了薄膜電晶體液晶顯示器(TFT-LCD)334、RS232串列介面335、音效輸出入界面336、核心處理器337、記憶體338及鍵盤339等。The system architecture of the preferred embodiment of the present invention is an integrated platform. In order to achieve cost saving and resource consumption on the integrated platform, part of the monitoring device 130 uses an embedded system, which is a fully embedded system. A dedicated computer system designed for specific applications within the controlled device. Often performed are pre-defined tasks with specific requirements that designers can optimize to reduce size and cost. Moreover, since embedded systems are typically mass produced, individual cost savings can be scaled up with yields. The basic architecture of the embedded system 330 of the preferred embodiment of the present invention is as shown in the fourth figure. The software program set by the embedded system 330 includes the complete underlying software 331, the operating system 332, and the application 333, and the hardware. Some of them include a thin film transistor liquid crystal display (TFT-LCD) 334, an RS232 serial interface 335, an audio output interface 336, a core processor 337, a memory 338, and a keyboard 339.
本發明較佳實施例之太陽能板無線監控資料庫之控制方法流程中，步驟(206)係利用資料分析程式141判斷狀態參數資料之格式是否錯誤，而在本發明之較佳實施例中更利用下列詳細之步驟進行資料格式之判斷，即如第五圖所示：(301) 資料分析程式利用string.GetLength()API函數抓取狀態參數資料之字串長度；(302) 獲得的字串長度帶入for迴圈進行資料格式判斷；(303) 資料分析程式判斷字串之第一字元是否為空格，若是，則進行步驟(207)，若否，則進行步驟(304)；(304) 資料分析程式讀取字串至第一空格出現，第一空格前方之字串為第一資料欄位；(305) 資料分析程式判斷第一空格後方之字元是否為空格，若是，則進行步驟(207)，若否，則進行步驟(306)；(306) 資料分析程式讀取字串至第二空格出現，第一空格與第二空格間之字串為第二資料欄位；(307) 資料分析程式判斷第二空格後方之字元是否為空格，若是，則進行步驟(207)，若否，則進行步驟(308)；及(308) 資料分析程式讀取字串至第三空格出現，第二空格與第三空格間之字串為第三資料欄位，並進行步驟(208)。In the flow of the method for controlling the solar panel wireless monitoring database of the preferred embodiment of the present invention, the step (206) uses the data analysis program 141 to determine whether the format of the state parameter data is incorrect, and is further utilized in the preferred embodiment of the present invention. The following detailed steps are used to judge the data format, as shown in the fifth figure: (301) The data analysis program uses the string.GetLength() API function to capture the string length of the state parameter data; (302) the obtained string length Bringing into a for loop for data format judgment; (303) The data analysis program determines whether the first character of the string is a space, and if so, proceeds to step (207), and if not, proceeds to step (304); (304) The data analysis program reads the string to the first space, and the string in front of the first space is the first data field; (305) the data analysis program determines whether the character after the first space is a space, and if so, proceeds to the step (207), if not, proceeding to step (306); (306) the data analysis program reads the string to the second space, and the string between the first space and the second space is the second data field; (307) ) Information points The program determines whether the character after the second space is a space, if yes, proceed to step (207), if not, proceed to step (308); and (308) the data analysis program reads the string to the third space, the first The string between the two spaces and the third space is the third data field, and step (208) is performed.
在上述之資料格式判斷步驟中，預設之資料格式為(資料1、空格、資料2、空格、資料3、空格)，因此在進行資料格式判斷時，若出現下列情形之一，則將此資料判斷為格式錯誤資料並將其刪除：a.第一個字元為空格；b.連續兩個空格；及c.傳送的任一資料為空格。In the above data format judging step, the default data format is (data 1, space, data 2, space, data 3, space), so when one of the following situations occurs, the data format is judged. The data is judged as a malformed data and deleted: a. The first character is a space; b. Two consecutive spaces; and c. Any data transmitted is a space.
在本發明之一種使用於太陽能板無線監控系統之資料庫之控制方法流程中，步驟(212)係為伺服裝置140利用網際網路將資料庫150之資料內容發佈於網站及至複數個外部行動裝置160a、160b、160c上，而此處對於資料庫150與網頁間之聯結及管理係使用ASP.NET程式系統來達成。ASP.NET是新一代Web應用程式開發的技術，具有簡易與快速開發的特色。ASP.NET包含幾項重要特色：In a control method flow of a database for a solar panel wireless monitoring system of the present invention, the step (212) is that the server 140 uses the Internet to publish the data content of the database 150 to the website and to a plurality of external mobile devices. 160a, 160b, 160c, and the connection and management between the database 150 and the webpage is achieved by using the ASP.NET program system. ASP.NET is a new generation of web application development technology with features that are easy and fast to develop. ASP.NET contains several important features:
1.可以使用多種語言來開發，例如：C#、VB.NET及Jscript等，不論使用哪一種程式語言，都使用同一套類別程式庫.NET Framework，因此簡化不同語言間的轉換問題。1. Can be developed in multiple languages, such as C#, VB.NET, and Jscript. No matter which programming language is used, the same set of libraries .NET Framework is used, thus simplifying the conversion between different languages.
2.透過.NET Framework，可以快速存取資料庫資料。2. With the .NET Framework, you can quickly access database data.
3.直接支援行動裝置用戶端，不論是手機或PDA之類的行動裝置，都可以瀏覽同一份ASP.NET網頁。3. Directly support the mobile device client, whether it is a mobile device or a mobile device such as a PDA, you can browse the same ASP.NET web page.
4.也使用類似C#表單(Windows Form)的開發方式來開發Web應用程式，包含屬性與事件處理，配合Visual Studio.NET整合開發環境，更可以使用和幾乎完全一樣的開發方式來開發Web應用程式。4. Also use a C# form (Windows Form) development method to develop a web application, including properties and event processing, with the Visual Studio.NET integrated development environment, and can develop web applications using almost the same development method. .
在網頁部份是透過VS.NET來執行ASP.NET連結至Access資料庫，使用GridView控制項連結資料庫位置，可以使用表格方式來顯示、分頁和排序複雜資料表功能，最後將資料發佈到網站上，並設定5秒重新整理網頁，讓管理者隨時監控最新資訊。In the webpage part, ASP.NET is used to connect to the Access database through VS.NET. The GridView control is used to link the database location. You can use the tabular method to display, page and sort the complex data table functions, and finally publish the data to the website. On, and set the page to refresh the page for 5 seconds, let the manager monitor the latest information at any time.
經由上述對於本發明進行較佳實施方式的詳細說明後，可以清楚的了解本發明應用於太陽能板101a、101b、101c之無線監控系統資料庫之架構，並且可依據資料庫150之控制流程進行資料的感測、傳送、判斷及儲存。本發明之系統架構以及控制方法係有以下之優點：After the above detailed description of the preferred embodiments of the present invention, the structure of the wireless monitoring system database applied to the solar panels 101a, 101b, and 101c of the present invention can be clearly understood, and the data can be processed according to the control flow of the database 150. Sensing, transmission, judgment and storage. The system architecture and control method of the present invention have the following advantages:
(1)本發明在一伺服裝置140中設置一資料庫150系統，當該伺服裝置140接收到太陽能板101a、101b、101c之狀態參數資料後，可將資料自動並永久儲存於該資料庫150中。(1) The present invention provides a database 150 system in a servo device 140. When the servo device 140 receives the state parameter data of the solar panels 101a, 101b, and 101c, the data can be automatically and permanently stored in the database 150. in.
(2)本發明在一伺服裝置140中設置一資料庫150系統及一資料分析程式141，當該伺服裝置140接收到太陽能板101a、101b、101c之狀態參數資料後，可利用該資料分析程式141對太陽能板101a、101b、101c之狀態參數資料進行分析，再將分析後之資料分類儲存於資料庫150中。(2) The present invention provides a database 150 system and a data analysis program 141 in a servo device 140. When the servo device 140 receives the state parameter data of the solar panels 101a, 101b, and 101c, the data analysis program can be utilized. 141 analyzes the state parameter data of the solar panels 101a, 101b, and 101c, and then stores the analyzed data in the database 150.
(3)本發明中，當一伺服裝置140接收到太陽能板101a、101b、101c之狀態參數資料後，可將資料進行分析並儲存於一資料庫150中，再將該資料庫150中之資料藉由網路發布至網站及行動裝置160a、160b、160c中，讓管理員或其他使用者可得到即時訊息。(3) In the present invention, after a servo device 140 receives the state parameter data of the solar panels 101a, 101b, and 101c, the data can be analyzed and stored in a database 150, and the data in the database 150 is further stored. By posting to the website and mobile devices 160a, 160b, 160c via the Internet, instant messages can be obtained by the administrator or other users.
以上所述之實施例僅係說明本發明之技術思想與特點，其目的在使熟習此項技藝之人士能夠瞭解本發明之內容並據以實施，當不能以之限定本發明之專利範圍，若依本發明所揭露之精神作均等變化或修飾，仍應涵蓋在本發明之專利範圍內。The embodiments described above are merely illustrative of the technical spirit and characteristics of the present invention, and the purpose of the present invention is to enable those skilled in the art to understand the contents of the present invention and to implement the present invention. Equivalent variations or modifications in accordance with the spirit of the invention are still intended to be included within the scope of the invention.
發明人經過不斷的構想與修改，最終得到本發明之設計，並且擁有上述之諸多優點，實為優良之發明，應符合申請發明專利之要件，特提出申請，盼 貴審查委員能早日賜與發明專利，以保障發明人之權益。The inventor has been continually conceived and modified to finally obtain the design of the present invention, and possesses the above-mentioned many advantages. It is an excellent invention, and should conform to the requirements of the invention patent, and the application is made, and the review committee can give the invention early. Patents to protect the rights of inventors.
101a、101b、101c．．．太陽能板101a, 101b, 101c. . . Solar panels
110a、110b、110c．．．感測終端裝置110a, 110b, 110c. . . Sensing terminal device
111a、111b、111c．．．多參數感測模組111a, 111b, 111c. . . Multi-parameter sensing module
112a、112b、112c．．．無線射頻模組112a, 112b, 112c. . . Wireless RF module
120．．．中心協調裝置120. . . Central coordination device
130．．．監控裝置130. . . Monitoring device
140．．．伺服裝置140. . . Servo device
141．．．資料分析程式141. . . Data analysis program
150．．．資料庫150. . . database
151．．．總體資料表151. . . General information sheet
152．．．異常資料表152. . . Abnormal data sheet
160a、160b、160c．．．外部行動裝置160a, 160b, 160c. . . External mobile device
201～212．．．係本發明較佳實施例之太陽能板無線監控資料庫之控制方法流程編號201~212. . . Method for controlling the solar panel wireless monitoring database of the preferred embodiment of the present invention
330．．．嵌入式系統330. . . Embedded Systems
331．．．底層軟體331. . . Bottom software
332．．．作業系統332. . . working system
333．．．應用程式333. . . application
334．．．薄膜電晶體液晶顯示器334. . . Thin film transistor liquid crystal display
335．．．RS232串列介面335. . . RS232 serial interface
336．．．音效輸出入界面336. . . Sound output interface
337．．．核心處理器337. . . Core processor
338．．．記憶體338. . . Memory
339．．．鍵盤339. . . keyboard
301～308．．．係本發明利用資料分析程式判斷狀態參數資料格式之步驟編號301~308. . . The step number of determining the state parameter data format by using the data analysis program of the present invention
第一圖 係本發明一較佳實施例之太陽能板無線監控系統之架構圖；1 is a structural diagram of a solar panel wireless monitoring system according to a preferred embodiment of the present invention;
第二圖 係本發明該較佳實施例之一種使用於太陽能板無線監控系統之資料庫之控制方法流程圖；2 is a flow chart of a control method for a database of a solar panel wireless monitoring system according to the preferred embodiment of the present invention;
第三A圖 係為星狀(star)網路拓樸架構示意圖；The third A diagram is a schematic diagram of a star network topology;
第三B圖 係為網狀(mesh)網路拓樸架構示意圖；The third B diagram is a schematic diagram of a mesh network topology;
第三C圖 係為叢集樹狀(cluster tree)網路拓樸架構示意圖；The third C diagram is a schematic diagram of a cluster tree network topology;
第四圖 係本發明較佳實施例之嵌入式系統之基本架構圖；及Figure 4 is a basic architectural diagram of an embedded system in accordance with a preferred embodiment of the present invention;
第五圖 係本發明利用資料分析程式判斷狀態參數資料格式之步驟流程圖。The fifth figure is a flow chart of the steps of the present invention for determining the format of the status parameter data by using the data analysis program.
101a、101b、101c．．．太陽能板101a, 101b, 101c. . . Solar panels
110a、110b、110c．．．感測終端裝置110a, 110b, 110c. . . Sensing terminal device
111a、111b、111c．．．多參數感測模組111a, 111b, 111c. . . Multi-parameter sensing module
112a、112b、112c．．．無線射頻模組112a, 112b, 112c. . . Wireless RF module
120．．．中心協調裝置120. . . Central coordination device
130．．．監控裝置130. . . Monitoring device
140．．．伺服裝置140. . . Servo device
141．．．資料分析程式141. . . Data analysis program
150．．．資料庫150. . . database
151．．．總體資料表151. . . General information sheet
152．．．異常資料表152. . . Abnormal data sheet
160a、160b、160c．．．外部行動裝置160a, 160b, 160c. . . External mobile device
Claims (8)
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| TW98125225A TWI384746B (en) | 2009-07-27 | 2009-07-27 | A database used in a solar panel associated with a wireless monitoring system and a method for controlling the same |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| TW98125225A TWI384746B (en) | 2009-07-27 | 2009-07-27 | A database used in a solar panel associated with a wireless monitoring system and a method for controlling the same |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| TW201105021A TW201105021A (en) | 2011-02-01 |
| TWI384746B true TWI384746B (en) | 2013-02-01 |
Family
ID=44813852
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| TW98125225A TWI384746B (en) | 2009-07-27 | 2009-07-27 | A database used in a solar panel associated with a wireless monitoring system and a method for controlling the same |
Country Status (1)
| Country | Link |
|---|---|
| TW (1) | TWI384746B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| ES1249523Y (en) * | 2020-03-25 | 2020-10-09 | Chemik Tarazona S L U | Wireless and non-invasive equipment for current monitoring directly in the wiring of photovoltaic installations. |
| CN113225018A (en) * | 2021-05-11 | 2021-08-06 | 上海芯喜电子科技有限公司 | Solar panel wireless power supply sensing device and monitoring system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| TW200839094A (en) * | 2007-03-16 | 2008-10-01 | Kuo-Ching Chiang | Control system with wireless transmission and solar cell energy device |
| US20090027001A1 (en) * | 2007-07-27 | 2009-01-29 | Haines Lance P | Solar powered apparatus |
| TW200928649A (en) * | 2007-12-26 | 2009-07-01 | Hon Hai Prec Ind Co Ltd | Solar energy control system |
-
2009
- 2009-07-27 TW TW98125225A patent/TWI384746B/en not_active IP Right Cessation
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| TW200839094A (en) * | 2007-03-16 | 2008-10-01 | Kuo-Ching Chiang | Control system with wireless transmission and solar cell energy device |
| US20090027001A1 (en) * | 2007-07-27 | 2009-01-29 | Haines Lance P | Solar powered apparatus |
| TW200928649A (en) * | 2007-12-26 | 2009-07-01 | Hon Hai Prec Ind Co Ltd | Solar energy control system |
Also Published As
| Publication number | Publication date |
|---|---|
| TW201105021A (en) | 2011-02-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Lee et al. | The use of normative energy calculation beyond building performance rating | |
| Liang et al. | A denial of service attack method for IoT system in photovoltaic energy system | |
| TWI384746B (en) | A database used in a solar panel associated with a wireless monitoring system and a method for controlling the same | |
| Shen et al. | Decoupling between economic growth and carbon emissions: based on four major regions in China | |
| Radia et al. | IoT-based wireless data acquisition and control system for photovoltaic module performance analysis | |
| Scott et al. | A DIY approach to pervasive computing for the Internet of Things: A smart alarm clock | |
| Wang et al. | Wind characteristics near the ground during typhoon Meari | |
| CN103514082A (en) | Test method for reflecting WEB energy efficiency of computer equipment | |
| Manghani et al. | An internet of things to maximum power point tracking approach of solar PV array | |
| JP5385174B2 (en) | Measurement display system and measurement control device | |
| Mardomi et al. | Agent-Based Modeling; a Paradigm to Deal with Complexity and Uncertainty in Architectural and Environmental Problems | |
| Huan-ding et al. | Research on equivalent simplified model of regular shock-insulation building | |
| Wu et al. | Investigation of maximum emergency guarantee duration of residential buildings during heating accidents | |
| Xhafa et al. | Special issue on cyber physical systems: Preface | |
| Elia et al. | Convergence of HPC, Big Data and Machine Learning for Earth System workflows | |
| Li et al. | Design of power grid full-service data monitoring platform based on cloud computing | |
| Xiong et al. | A Refined Coulomb Rate-state Forecast Model Based on a Retrospective Study of Aftershocks of the 2008 Mw 7.9 Wenchuan Earthquake, China | |
| Rabonza et al. | Modeling Time-Dependent Urban Risk for Policy Analysis in Disaster Risk Management | |
| Li et al. | Development and application of an environment monitoring system based on IPv6 | |
| Holloway | Power to the people: how much electricity can your roof really produce? | |
| Pedersen et al. | Blueprinting a Smart Grid Automated Demand Response System for Data Mining Research and Education | |
| Wang et al. | The application of heat supply information network platform based on C/S and B/S models | |
| Fili | Photonic crystal technology improves the efficiency of solar cells | |
| Tymkiewicz | The sun, wind and water in designs of exterior walls and facades-natural forces potential in shaping the architecture of sustainable development | |
| Treese | The coming of sensor networks |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| MM4A | Annulment or lapse of patent due to non-payment of fees |