[go: up one dir, main page]

TW200929025A - Automatic report system and method - Google Patents

Automatic report system and method Download PDF

Info

Publication number
TW200929025A
TW200929025A TW96151338A TW96151338A TW200929025A TW 200929025 A TW200929025 A TW 200929025A TW 96151338 A TW96151338 A TW 96151338A TW 96151338 A TW96151338 A TW 96151338A TW 200929025 A TW200929025 A TW 200929025A
Authority
TW
Taiwan
Prior art keywords
data
unit
point
report
database
Prior art date
Application number
TW96151338A
Other languages
Chinese (zh)
Inventor
Wen-Yao Chang
Cheng-Chien Huang
Pai-His Ting
Ming-Wei Lee
Yen-Shu Huang
Ying-Chu Su
Original Assignee
Ind Tech Res Inst
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Ind Tech Res Inst filed Critical Ind Tech Res Inst
Priority to TW96151338A priority Critical patent/TW200929025A/en
Publication of TW200929025A publication Critical patent/TW200929025A/en

Links

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present invention relates to an automatic report system, for periodically gathering data from a database and completing a report, the automatic report system comprising: an online data gathering unit, for accessing data from a data point of the database on a regular time schedule; a retrieving data point managing unit, for adding or editing at least a data point; and an altering data patching unit, for added or edited retrieving data point to retrieve the generated data of a corresponding data point of the database.

Description

200929025 九、發明說明: 【發明所屬之技術領域】 本發明係有關一種自動化報表系統盥方法 種可避免因原始資料庫無法連線所造叙資料遺=是-化報表產生及派送系統與方法。 %天的自動 【先前技術】 e 〇 隨著資訊系統廣泛的採用,資料的產生 過系統自動化的完成,對於這些快迷累積的資料集二已透 被解讀及運用’才能有效的協助經營者做出營也,如何 變成是報表設計人員很重要的日常工作,一 '、束’就 達一個抽象的概念或是一個趨勢的涫 而s ’在傳 料以圖表的方式呈現,除了利於呈現,方便將資 易於進行多元化的區別比較。 鳴考外’更 一般而言,系統品質管制組人員通常會 間,例如每週週一、每月月初、每季季初, 疋某時 上級進行簡報或提交報告,由於多數人在固,,表向 始資料進行及大量的資料查詢卫作,使得於原 資料的儲存作業的資料庫系統負载異常遽增,量 資料庫系統效能不彰或發生異常。 低谷易造成 【發明内容】 本發明之^的在於提供一種在多 供操作效率,並避免影響原始資料庫 表系統與方法。 π ρ系之自動化報 5 200929025 為達到上述目的,本發明係提供一種自動化報表系 統,定期操取一資料庫之負料並元成~~報表,該自動化^ 表系統包括:一線上資料擷取單元,用以定期從該資料庫 之一資料點讀取資料;一擷取資料點管理單元,用以新増 或修改至少一擷取資料點’該擷取資料點係對應該資料庫 一資料點;以及一異動資料補值單元,用以擷取該擷取資 料點所對應之該資料庫之資料點所產生之資料。 '200929025 IX. Description of the invention: [Technical field to which the invention pertains] The present invention relates to an automated reporting system and method for avoiding the generation of data and the delivery system and method for the inability of the original database to be linked. %天的自动 [Prior Art] e 〇 With the widespread adoption of information systems, data generation has been completed by system automation. The data set 2 accumulated for these fans has been interpreted and used to effectively assist operators. Out of the camp, how to become a very important daily work for report designers, a ', bundle' to reach an abstract concept or a trend of 涫 s ' in the material delivery in the form of a chart, in addition to facilitate presentation, convenient The difference is easy to diversify. In addition, in general, the system quality control team usually has a briefing, such as weekly, monthly, and quarterly, when the seniors make a briefing or submit a report, because most people are in solid, The data from the beginning of the table and a large number of data query, so that the database system load of the original data storage operations is abnormally increased, the database system performance is not good or abnormal. The present invention is directed to providing a system and method for providing operational efficiency and avoiding affecting the original database. π ρ Automatic Report 5 200929025 In order to achieve the above object, the present invention provides an automated report system, which regularly takes a negative data of a database and converts it into a ~~ report. The automated system includes: online data capture a unit for periodically reading data from one of the data points of the database; a data point management unit for updating or modifying at least one data point of the data point And a transaction data replenishment unit for extracting data generated by the data points of the database corresponding to the data points. '

為達到上述目的’本發明復提供—種自動化報表方 法,定期擷取一資料庫之資料並完成一報表,該自動化報 表方法包括:定期由該資料庫一資料點摘取資料;新増戈 ,改至少一擷取資料點,該擷取資料點係對應該資料庫一 資料點;擷取該擷取資料點所對應之該資料庫之 產生之資料。 、” w 縱上所述 役';;7,彳本發明目的之自動化報表系統及方法 取資料避免在多人同時編輯報表時所ίί 亦可將#誤郊且在定期擷取資料過程中發生錯誤時, ί的ΐ料擷取作業重新擷取所遺失二η 亦可藉由對所新增或体“ ^幻貝計为外本發明 取該資料點在新增^㈣點進行異動資料補值,梅 料,以增加所擷取:二前的時間點範圍所產生之資 為完善的資料。之元整性,並提供所建立之報表更 本發明之前述目的— 說明,惟需明瞭的是,徵,將依據後附圖式加以詳細 明而非在關或縮限本式及所舉之例’祇是做為說 6 200929025 200929025 【實施方式】 雖然本發明將參閱含有本發明較佳實施例之所附圖示 予以,分描述’但在此描述之前應瞭解熟悉本行技藝之人 士可U改本文中所描述之發明,同 瞭解以下之描述對熟悉本行技藝之二V 廣泛之揭不,且其内容不在於限制本發明。 至少亡自動化報表系統與方法,定期的將 “庫:===回,並储存至本地端 多人同+的貝枓儲存於數個資料表中,以達到 產生過大負荷。 避免原始資料庫因多人同時存取而 —資:而i在線正常時得 ,提供新增資料點的補值 例係自,該實施 操取所需之資料,以建;;並派用&定期從-原始資料庫2 =系,括一資料圖所:該自動 B理早几20、一資料早兀、、且10、一擷取資料點 及一報表派送單元50。 70 30、一報表管理單元初以 該資料擷取單元紐 需之資料’其中包括一糸用:對該原始資料庫2擷取所 線上資料擷取單元12以及一異動資 200929025 設之各時間點對該元12係用以在使用者預 示)操取所需之資料的複數個資料點(圖中未顯 散每次綠取^^=3_庫2擷取資料的方式分 造成該原始資=的生負之載負過載大以避免因多人同時使用而 ❹ 應該原始資中理須早截個擷取資料點對 維護該原始資料庫2 ==之理與 :名:進《:在新增報表時,根據所新 料點時’控制該異動資料補值單元二資 取資料點所對應之該原始資料庫2的^^或修改之操 貝產生的資料,以維護所操取資料的完整=的 該報表管理單元40係可自動產生趨 報、月報、年報等報表内容,以定期建^表格等如周 報表格式以建立新的報表。該報表管理’或新2 S報表與試算表(Excell)或投影片(P0W姓:將3 體或以單一報表方式匯出成檔案。 ’以集 該報表派送單元5G制啸據贿表管理單元40所 8 200929025 報表定期將建立之報表派送至遠端用戶,且可读、 ^ ^伺服器(圖中未顯示)自動將所建立報表發送到至^ w粕,以有效降低資料儲存單元3〇的負载。 曰 沾猫第二圖為本發明—實施例之線上#料擷取單元1? 圖100。錢程101時,該線上資料擷取單ί ’、建/、該原始資料庫2的連線,以用於定期從 2的複數個資料點擷取資料;在流程1〇2時了該‘ 資ΐ = 12即確認所需擷取資料之資料點以及;需 1 二根據所確認資料點與時間點,在該時間 進仃貝料擷取並對所擷取之資料進行包括取平均值、取 小值、取最大值或其料算料處理運算 ==流程―搁取資料的過程= 單元=逾時二該=線2上與資 ❹ 無法有效擷取所需之資料’因此該線上資料擷取單元 記錄發生錯誤的時間點,並待進行下—次時間點的資料 取時再將發生錯誤的時間點之#料重新進行触,以 ?操取資料的完整性;在流程1G5時,當該線上資料榻^ U對該資料點完成資料練時,魏—步驗證所摘取 _貝料的正確性與完整性,若驗證的結果是正確的話, 程107 ’反之若驗證的結果不是正確的話,則進行流程 在流程106時,該線上資料摘取單元12在驗證所擁取 9 200929025 ^料不正確時,即進一步擷取該資料點最後產生的正確資 料,以維護所擷取資料的正確性,並紀錄發生錯誤的時間 點以及所擷取正確資料的時間點,以提供該自動化報表系 =1進行後續之分析處理;以及在流程107時,當該線上 . 料摘取單元12完成資料擷取的動作並正確驗證所擷取之 資料,,該線上資料擷取單元12即將已進行相關前處理之 • 擷=資料儲存至該資料儲存單元30,以完成該等資料表, 並提供該報表管理單元40與該報表派送單元50建立及派 ^ 送報表。 當該揭取資料點管理單元20新增或修改資料擷取點以 對應在該原始資料庫2中所欲擷取資料之資料點時,則該 ,取資料點管理單元2〇除了將所新增或修改之擷取資料點 提供予該線上資料擷取單元12,致使該線上資料擷取單元 12得以對該擷取資料點所對應該原始資料庫2之資料點開 始進行定期之資料擷取作業之外,該擷取資料點管理單元 20進一步將所新增或修改之擷取資料點提供予該異動資料 ❹ ,值單元11 ’致使該異動資料補值單元11得以對該擷取資 料點所對應該原始資料庫2之資料點進行新增或修改前之 • 時間點的資料補值。 . 參考第三圖為本發明一實施例之異動資料補值單元11 的操作流程圖120。在流程121時,該異動資料補值單元 12,接收來自該資料點管理單元2〇中有關新增或修改之擷 取資料點訊息;在流程122時,該異動資料補值單元11即 選擇新增或修改之擷取資料點所對應該原始資料庫2之資 料點所需進行補值的時間點範圍;在流程123時,該異動 200929025 資料補值單元11即連線至該新增或修改擷取資料點所對應 之原始資料庫2 ;在流程124時,該異動資料補值單元u 即根據所確認擷取資料點所對應該原始資料庫2之資料點 與時間點範圍,對該資料點擷取有關該時間點範圍内的所 有資料。 • 在流程125時,當該異動資料補值單元11對該資料點 ^ 完成資料擷取時,則進一步驗證所擷取資料的正確性與完 ❹ 整性,若驗證的結果是正確的話,則進行流程127,反之若 驗證的結果不是正確的話,則進行流程126;在流程126時, 該異動資料補值單元n在驗證所擷取資料不正確時,即進 步擷取該資料點最後產生的正確資料,以維護所擷取資 =的正確性,並紀錄發生錯誤的時間點以及所擷取正確資 '虚的時間點,以提供該自動化報表系統1進行後續之分析 次以及在流程127時’當該異動資料補值單元11完成 動Λ並正確驗證所擷取之資料後’該異動資料 © _儲存單元^已ΐ仃相關前處理之齡資料儲存至該資 元4〇盘储辆料料,錄供該報表管理單 一这報表派送早兀50建立及派送報表。 •為,明—實施例之報表管理單元4〇的摔 140。在流程14 ㈣ 面遠端連線至該報表管理單元;係藉由網路介 '編輯報表,或執行流程149 了流程142以 進-步選擇所欲新^ 卞出報表,在流程142時, 别(圖表或表格);在^報表名稱’以及該報表的類 表新增或修改資料 、’根據所要新增或修改之報 貝料點,並進而執行流程144以編輯圖表, 11 200929025 或執行流程】45以編輯表格,·在 修改所選擇圖表的_以及上“以’即可新增或 J48,·在流程〗45時, 等貧訊,並進行流程 資訊,·在流程146時η [± mS ^所選擇表袼的行、列 於新增-報表,若是的話即進之表袼是否用 流程148 ;在流程147時 旅右否的話則進行 的試算表範本,以用於產生新的H或修改之表格匯入新 即將所新增或似之料 ⑽時, 理資料表⑽中未顯示),用理早以㈣-管 該等資料完成並建立報表 該報表官理單元4〇根據 在流程149時,兮鈕主缺他w 一 表’即連線至該資料^存f早疋40為了建立及輸出報 ㈣。時’該報; = 需之資料;在流 =管理資料表建立並輪出所以 程151用以建立及輪 輅之報表並進而執行流 =建立及輸出表格式的出^式的,表’或執行流程152用 早元4〇即根據該管理資料,:程151時,該報表管理 30榻取所需要之資料,’的貝訊條件對該資料館存單元 表;在流程152時該報矣進行圖形顯示’以建立圖表式報 表的資訊條件來執扞;官理單元4〇即根據該管理資料 30的資料進行篩Ϊ ;在=程序’用以對該資料儲存單元 根據所執行預存程序對’該報表管理單元40即 料’並進行表格顯示,^ =存早兀3G擷取所需要之資 係將流程⑸所顯,立表格式報表;在流程154時, 輪出-圖形式報表 开/與投影片結合,以在流程156 田莱,在流程155時,係將流程153所 200929025 顯=之表格與試算表結合’以在流程156輪出一表格式報 表檔案;以及在流程156時,即將流程154或汽程155所 產生之報表匯出。 一, >考第五圖為本發明一實施例之報表派送單元50的操 作圖160。在流程161時,遠端之使用者係藉由網路介 面退端連線至該報表派送單元5〇以進行相關敎作業,並 ❹ ❹ =執行流程162以設定派送時間,或執行流程163以設 ^表派送權案產生的時間及類別,或執行雜164以設 對象;在流程162 ·,使用者係藉由遠端連線以 進Λ報表派送的報送軸;在流程⑹時,使用 別·、在、連線以設定報表派送檔案產生的時間及類 以Γ二時,使用ί係藉由遠端連線以設定所欲派 顯示),用以根據所設定之對t讀=員資料庫(圖中未 及164戶斤完成之設定更新派送根據流程⑹、⑹以 報表派送單元5〇即定期執行該^ :在流程⑹時,該 否進行報表派送的作業;在^^迗執行檔,以定期檢查是 5〇及在每次定期執行派送執^ =8時,該報表派送單元 所設定之派送時間,若是的話/時’檢查是否符合流程162 返回流程167以等待下次定°期=進行流程169,若否的話則 該報表派送單元50即完成所查的時間;在流程169時, 17〇時,該報表派送單元5〇 g派送之報表檔;以及在流程 進行報表檔的派送。 P艮據流程164所設定之對象 縱上所述,本發明之自 報表系統及方法係可藉由 13 200929025 定期擷取資料避免在多人同時編輯報表時所產生負載過大 的情形,且在定期擷取資料過程中發生錯誤時,亦可將錯 誤之資訊記錄以供後續分析研究,並可利用下一次的資料 擷取作業重新擷取所遺失的資料。另外,本發明亦可藉由 對所新增或修改之資料點進行異動資料補值,擷取該資料 點在新增或修改之前的時間點範圍所產生之資料,以增加 所擷取資料之完整性,並提供所建立之報表更為完善的資 料。 在詳細說明本發明的較佳實施例之後,熟悉該項技術 人士可清楚的暸解,在不脫離下述申請專利範圍與精神下 進行各種變化與改變,且本發明亦不受限於說明書中所舉 實施例的實施方式。In order to achieve the above purpose, the present invention provides an automated reporting method, periodically extracting data from a database and completing a report. The automated reporting method includes: periodically extracting data from a data point of the database; Change at least one data point, the data point is a data point corresponding to the database; and the data generated by the database corresponding to the data point is retrieved. , "w hang the above service";; 7, the automatic reporting system and method of the present invention take data to avoid when multiple people edit the report at the same time ίί can also be misunderstood and occur in the process of regularly collecting data In the case of an error, the 撷 撷 撷 作业 撷 撷 撷 撷 撷 撷 撷 撷 撷 撷 撷 撷 撷 撷 撷 撷 撷 撷 撷 撷 撷 撷 撷 亦可 亦可 亦可 亦可 亦可 亦可 亦可 亦可 亦可 亦可 亦可 亦可 亦可 亦可 亦可 亦可 亦可 亦可 亦可 亦可 亦可 亦可Value, plum, to increase the amount of money: the amount of money generated by the time point range before the second is the perfect data. The integrity of the element, and the provision of the statement to create the above-mentioned purpose of the present invention - the description, but it is necessary to understand that the levy will be detailed in the following figures, rather than in the context of The present invention will be described with reference to the accompanying drawings, which are included in the preferred embodiments of the present invention, and the description of the present invention will be understood by those skilled in the art. The invention described in the present specification is not to be construed as limiting the scope of the invention. At least the automated reporting system and method, the regular "library: === back, and stored to the local end of the multi-person plus + Bessie stored in several data tables, in order to achieve excessive load. Avoid the original database Many people access at the same time - capital: and i online normal time, provide additional information points of the supplementary value system, the implementation of the required information to build;; and send & regular from - the original Database 2 = Department, including a data map: The automatic B is a few 20, one data is early, and 10, one data point and one report delivery unit 50. 70 30, a report management unit The data of the data acquisition unit is required to be included in the data collection unit 12 and the time zone 12290 of the original database 2 is used for the user. Predicting) the multiple data points of the required data (the figure is not scattered every time the green is taken ^^=3_2), the way of collecting the data is divided into the negative load of the original capital= Avoid the use of multiple people at the same time. Maintain the original database 2 == rationale and: name: into the ": when adding a new report, according to the new material point, 'control the transaction data supplementary unit two resources to take the data point corresponding to the original database 2 The information generated by the ^^ or the modified operation to maintain the integrity of the processed data = the report management unit 40 can automatically generate the report content of the report, monthly report, annual report, etc., to regularly build a form such as a weekly report Format to create a new report. The report management 'or new 2 S report and spreadsheet (Excell) or slide (P0W surname: will be 3 or a single report to export to a file. 'To set the report delivery unit 5G The report will be sent to the remote user on a regular basis, and the report will be sent to the remote user automatically, and the server (not shown) will automatically send the created report to ^w粕. The load of the data storage unit 3〇 is effectively reduced. The second picture of the 曰 猫 cat is the line #料取取 unit 1 of the present invention - Fig. 100. When the money is 101, the online data acquisition unit ί ', built / , the connection of the original database 2, for regular use from 2 Several data points are used to retrieve the data; at the time of the process 1〇2, the 'asset=12 is the data point for confirming the required data; and 1 2 according to the confirmed data points and time points, at that time The material is extracted and the data taken includes averaging, taking the small value, taking the maximum value or calculating the material calculation operation == process - the process of data acquisition = unit = timeout 2 = line 2 The above information and the information cannot be used to effectively retrieve the required information. Therefore, the online data retrieval unit records the time when the error occurred, and waits for the next time point when the data is taken out and then the error occurs. To perform the touch, to obtain the integrity of the data; in the process 1G5, when the online data is completed, the correctness and integrity of the extracted material are obtained. If the result of the verification is correct, the process 107 'or vice versa, if the result of the verification is not correct, then the process proceeds to the process 106, and the online data extraction unit 12 further confirms that the acquisition is not correct, that is, further Take the right point of the data point Information to maintain the correctness of the data retrieved, and to record the point in time at which the error occurred and the point in time at which the correct data was obtained to provide the automated reporting system for subsequent analysis; and at process 107, The online material extracting unit 12 performs the data capturing operation and correctly verifies the captured data, and the online data capturing unit 12 stores the data of the relevant pre-processing 撷= data to the data storage unit 30. To complete the data table, and provide the report management unit 40 to establish and dispatch a report with the report dispatch unit 50. When the data point management unit 20 adds or modifies the data extraction point to correspond to the data point of the data to be retrieved in the original data base 2, then the data point management unit 2 removes the new information. The added or modified data point is provided to the online data extraction unit 12, so that the online data extraction unit 12 can start the periodic data acquisition of the data point corresponding to the original data base 2 of the captured data point. In addition to the homework, the captured data point management unit 20 further provides the newly added or modified captured data points to the transaction data, and the value unit 11' causes the transaction data complementing unit 11 to obtain the data points. The data points of the original database 2 are added or modified before the time point. Referring to the third figure, an operation flowchart 120 of the transaction data complementing unit 11 according to an embodiment of the present invention is shown. In the process of the process 121, the transaction data replenishing unit 12 receives the information about the newly added or modified data point from the data point management unit 2; at the time of the process 122, the transaction data complementing unit 11 selects a new one. Add or modify the time point range of the data point corresponding to the data point of the original database 2; in the process 123, the transaction 200929025 data complement unit 11 is connected to the new or modified The original database corresponding to the data point is captured; in the process 124, the data supplementing unit u is based on the data point and the time point corresponding to the original data base 2 according to the confirmed data point. Click on all the data in the range of the time point. • At the time of the process 125, when the transaction data complementing unit 11 completes the data acquisition for the data point ^, it further verifies the correctness and completeness of the captured data, and if the verification result is correct, then If the result of the verification is not correct, the process 126 is performed; when the process 126 is performed, the transaction data complementing unit n is in progress to obtain the last data generated by the data point when the verification data is incorrect. Correct information to maintain the correctness of the amount of money received, and to record the time point at which the error occurred and the correct time point for the virtual resource to provide the automated reporting system 1 for subsequent analysis and at process 127 'When the transaction data replenishment unit 11 completes the operation and correctly verifies the captured data, the transaction data is stored in the relevant information. Material, record the report management, a single report, send and submit the report as early as 50. • For example, the report management unit 4 of the embodiment is dropped 140. Connect to the report management unit at the far end of the process (4); use the network to 'edit the report, or execute the process 149 to process 142 to select the desired new report, at process 142, Don't (chart or table); add or modify the data in the ^Report Name' and the class table of the report, 'According to the report points to be added or modified, and then execute the process 144 to edit the chart, 11 200929025 or execute Flow] 45 to edit the table, · modify the _ of the selected chart and "can be added to / or J48, in the process of 45, etc., and wait for the news, and process information, · η at process 146 [ ± mS ^ The row of the selected table is listed in the new-report, if it is, then the process is used to use the process 148; in the case of the process 147, if the right is not, the sample spreadsheet is used to generate the new H or the modified form is imported into the new or similar material (10), which is not shown in the data sheet (10), and is processed by the (4)-management of the data and the report is established. In the process 149, the button is missing the main table, that is, even To the information ^ save f early 40 in order to establish and export the report (four). When the 'report; = need information; in the flow = management data table to establish and rotate so the process 151 to establish and rim report and then execute Flow = create and output the format of the table format, the table ' or the execution process 152 uses the early element 4, that is, according to the management data, when the process is 151, the report manages the information required for the 30 couch, 'Beixun The condition is stored in the library; in the process 152, the newspaper is displayed graphically to establish the information condition of the chart report; the official unit 4 is screened according to the data of the management data 30; The program 'for the data storage unit according to the executed stored procedure pair 'the report management unit 40 is expected' and the table is displayed, ^ = save the early 3G acquisition of the required capital will be shown in the process (5), the table Format report; at process 154, the round-out-form report is opened/in combination with the slide to be used in the process 156 Tianlai, and in the process 155, the process 153 is used to combine the form of the 200929025 with the trial balance. Flow 156 rotates a tabular report file; At the time of the process 156, the report generated by the process 154 or the steam process 155 is remitted. 1. The fifth chart is an operation diagram 160 of the report dispatch unit 50 according to an embodiment of the present invention. The end user connects to the report dispatching unit 5 through the network interface to perform related operations, and ❹ 执行 executes the process 162 to set the delivery time, or executes the process 163 to set the dispatching rights. The time and category generated, or the execution of the 164 to set the object; in the process 162, the user is connected to the report axis by the remote connection; in the process (6), the use of the other, in, and even The time and class of the line to set the report delivery file are used at 2 o'clock, using ί to connect to the remote to set the desired display), according to the set of t read = member database (not shown in the figure) And 164 households complete the setting update delivery according to the process (6), (6) to report the unit 5 to execute the ^ regularly: in the process (6), the report delivery operation; 5〇 and each time the delivery is executed ^=8, The delivery time set by the report dispatching unit, if yes/time 'check whether the process 162 is returned to the flow 167 to wait for the next fixed period = the process 169 is performed, and if not, the report dispatching unit 50 completes the checked time. At the time of process 169, at 17 o'clock, the report dispatch unit delivers the report file of the 5〇g; and dispatches the report file in the process. According to the object set by the process 164, the self-reporting system and method of the present invention can periodically retrieve data by 13 200929025 to avoid excessive load when multiple people simultaneously edit the report, and periodically. When an error occurs during the data retrieval process, the error information may also be recorded for subsequent analysis and research, and the lost data may be retrieved using the next data retrieval operation. In addition, the present invention may also add data to the newly added or modified data points by using the data generated by the data points before the new or modified time points to increase the data acquired. Integrity and provide more complete information on the established reports. Various changes and modifications can be made without departing from the scope and spirit of the invention, and the invention is not limited by the description. Embodiments of the embodiments are given.

14 200929025 【圖式簡單規明】 ,二圖為本發明一實施例之系統架構圖; 。第了圖為本發明一實施例之線上資料擷取單元的操作 流程圖; ’' 第二圖為本發明一實施例之異動資料補值單元的操作 流程圖; ’' .第四圖為本發明一實施例之報表管理單元的操作流程 圖;以及 第五圖為本發明一實施例之報表派送單元的操作流程 圖。 【主要元件符號說明】 1…自動化報表系統 ίο—-資料擷取單元組 11-_-異動資料補值單元 12…線上資料擷取單元 20-—擷取資料點管理單元 30---資料儲存單元 40---報表管理單元 5〇…報表派送單元 2…原始資料庫 100 ' 120、140、160…操作流程圖 101 〜107、121 〜127、141 〜156、161 〜170…流程 1514 200929025 [Simple diagram of the diagram], the second diagram is a system architecture diagram of an embodiment of the invention; The figure is an operation flowchart of the online data capturing unit according to an embodiment of the present invention; '' The second figure is an operation flowchart of the variable data supplementing unit according to an embodiment of the present invention; ''. The flowchart of the operation of the report management unit of the embodiment of the invention; and the fifth diagram is a flowchart of the operation of the report dispatch unit according to an embodiment of the invention. [Main component symbol description] 1...Automatic report system ίο--Data capture unit group 11-_-Transaction data complement unit 12... Online data capture unit 20--Collection data point management unit 30---Data storage Unit 40---Report Management Unit 5...Report Delivery Unit 2...Original Database 100 '120, 140, 160... Operation Flowcharts 101 to 107, 121 to 127, 141 to 156, 161 to 170... Flow 15

Claims (1)

200929025 十、申謗專利範面: h 一=動表系統,定期擷取-資料庫之資料並* t表’該自動化報表系統包括: 、科並凡成 點靖―^線次上資料摘取單元,用以定期從該資料庫之一次輕 料i以資擷取單元紀錄無法連線至該; 時,叙Ϊ 制的時間點’並於下次進行資料魅 ❻ 擷取單-t該資料點位於該時間點之資料,該線上資料 誤,則步驗證賴取之資料,^所擷取的資料以 誤’則重新擷取該資料點最後產生之正麵=貝枓錯 =”_管理單元,用輯增或修改至^ ,4該絲資料點係對應該資料庫-資料點.取 : 異動資料補值單元,用以操取該擷取資料點所= 該-貝料庫之資料點所產生之資料。 ,子應 2· 專利範圍第1項之自動化報表系統,其中兮綠U 單元進一步將所擷取之資料進行前處:ϊΐ 3 ^騎平触、取最大值絲最小值。 ^ lh势明ί利範圍第1項之自動化報表系統,其中該次%L 4如:理單兀根據所修改之資料點修改對應之-資; 4. 2請專利範圍第!項之自動化報表系統,其 5該賁料庫之資料點進行一完整性檢測, 2 !該異動資料補值單元擷取資料。 疋 H清專利範圍第1項之自動化報表系統’其中該里氣 二補值單元紀錄無法連線至該資料點以進行資^ 、時間點,並提供該時間點予該線上資料擷取單元〔 u Μ 200929025 提供該線上資料擷取單元於下次進行資料擷取時重新揭 取該資料點位於該時間點之資料。 6. 如申清專利範圍第1項之自動化報表系統,進一步包括 一,表管理單元,用以根據該線上資料擷取單元或該異 動資料補值單元所擷取之資料產生該報表。 7. =申請專利範圍第1項之自動化報表系統,進一步包括 二報表派送單元’用以將該報表派送至指定使用者。 8·二種自動化報表方法,定期擷取一資料庫之資料並完成 一2表’該自動化報表方法包括: 疋期由該資料庫一資料點擷取資料; ,增或修改至少一擷取資料點,該擷取資料點係對應 該資料庫一資料點; 榻取該揭取資料點所對應之該資料庫之資料點所產 生之資料;及 間點,並於下次進行資料擷 取時重新擷取該資料點位於200929025 X. Application for patents: h ==moving system, regularly extracting data from the database and *t table 'The automated reporting system includes: The unit is used to periodically select a unit record from the database to obtain the unit record and cannot connect to the line; when, the time point of the system is 'and the next time the data is collected. Point the data at the time point. If the online data is incorrect, then the data obtained by the step is verified. If the data obtained is incorrect, the data generated by the data point will be re-acquired. Unit, use the series to increase or modify to ^, 4 the data points correspond to the database - data points. Take: the variable data replenishment unit, used to fetch the data points = the data of the - The information generated by the point., sub-2. The automatic reporting system of the first item of the patent scope, in which the green U unit further carries the data obtained before: ϊΐ 3 ^ riding the flat touch, taking the maximum wire minimum ^ lh mingming ί 利 range of item 1 of the automated reporting system, where the %L 4 For example, the management order 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改 修改The data replenishment unit retrieves the data. 疋H clear patent scope item 1 of the automated reporting system 'where the gas two compensation unit record can not be connected to the data point for the time, time point, and provide the time point The online data retrieval unit [u Μ 200929025 provides the online data retrieval unit to re-extract the data at the point in time when the data is retrieved. 6. If the patent scope is the first item The automated report system further includes a table management unit for generating the report according to the data retrieved by the online data extraction unit or the transaction data supplementation unit. 7. = The automatic report system of claim 1 Further, the second report dispatching unit is configured to send the report to the designated user. 8. Two automated reporting methods, periodically extracting data from a database and completing a 2 table 'The automated reporting method includes: extracting data from a data point of the database during the flood period; adding or modifying at least one data point, the data point corresponding to the data base; The data generated by the data points of the database corresponding to the data points; and the points, and the data points are retrieved at the next data acquisition. μ^中’紀錄無法連線至該資料點以進行資料擷取的時 ❹ —完整性檢測,以決定是否 200929025 擷取該新增或修改之擷取資料點所對應之該資料庫之資 料點在新增或修改之前所產生之資料。 12. 如申請專利範圍第8項之自動化報表方法,進一步包括 根據所擷取之資料產生該報表。 13. 如申請專利範圍第8項之自動化報表方法,進一步包括 將該報表派送至指定使用者。In μ^, the record cannot be connected to the data point for data retrieval - integrity check to determine whether 200929025 retrieves the data point of the database corresponding to the newly added or modified data point. Information generated before adding or modifying. 12. The automated reporting method of claim 8 of the patent scope further includes generating the report based on the information obtained. 13. The automated reporting method of claim 8 of the patent scope further includes dispatching the report to a designated user. 1818
TW96151338A 2007-12-31 2007-12-31 Automatic report system and method TW200929025A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
TW96151338A TW200929025A (en) 2007-12-31 2007-12-31 Automatic report system and method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
TW96151338A TW200929025A (en) 2007-12-31 2007-12-31 Automatic report system and method

Publications (1)

Publication Number Publication Date
TW200929025A true TW200929025A (en) 2009-07-01

Family

ID=44864342

Family Applications (1)

Application Number Title Priority Date Filing Date
TW96151338A TW200929025A (en) 2007-12-31 2007-12-31 Automatic report system and method

Country Status (1)

Country Link
TW (1) TW200929025A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114911779A (en) * 2021-02-09 2022-08-16 台湾中华电信股份有限公司 Device, system and method for analyzing data missing and supplementing values of networking equipment

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114911779A (en) * 2021-02-09 2022-08-16 台湾中华电信股份有限公司 Device, system and method for analyzing data missing and supplementing values of networking equipment

Similar Documents

Publication Publication Date Title
CN111984390A (en) Task scheduling method, device, device and storage medium
CN104317618B (en) A kind of firmware partition treating method and apparatus
TW200941214A (en) Executing software performance test jobs in a clustered system
US12482541B2 (en) Rule-based low-latency delivery of healthcare data
CN111081356A (en) Method for flow management based on WEB
TW200939052A (en) Dynamic formulas for spreadsheet cells
CN105868391A (en) Method and device for recording log
JP5624674B2 (en) How to improve queries for searching databases
CN115455106B (en) Power distribution monitoring method, service platform, equipment and storage medium for power distribution operation and maintenance
CN113435830A (en) Mail information summarizing method, system, electronic device and storage medium
CN116226112A (en) Data cleaning method, device, storage medium and electronic equipment
CN110097342B (en) Method and device for document cooperative processing
CN109614271A (en) Control method, device, device and storage medium for data consistency of multiple clusters
CN108363780A (en) A kind of regulation engine and method of anti money washing
CN112069197A (en) Abnormal work order method and device
CN114398359A (en) Order data automatic reconciliation method, device and storage medium
TW200929025A (en) Automatic report system and method
CN117555541A (en) Data page display method, device, equipment and storage medium
CN116796950A (en) Online review system and method for power distribution network project capable of being researched
CN116126875A (en) Metadata processing method and device
CN116126415A (en) Scene-based cloud component configuration recommendation method and system
CN115718741A (en) Automatic cleaning method and device for health data, electronic equipment and storage medium
CN115775188A (en) Asset financial integrated system
JP4295288B2 (en) Form creation device, form creation method, and form creation program
CN119692950B (en) Task planning execution method, device, equipment and medium based on flow engine