TWI236803B - Method of converting geospatial database into compressive database for multiple dimensional data storage - Google Patents
Method of converting geospatial database into compressive database for multiple dimensional data storage Download PDFInfo
- Publication number
- TWI236803B TWI236803B TW90112743A TW90112743A TWI236803B TW I236803 B TWI236803 B TW I236803B TW 90112743 A TW90112743 A TW 90112743A TW 90112743 A TW90112743 A TW 90112743A TW I236803 B TWI236803 B TW I236803B
- Authority
- TW
- Taiwan
- Prior art keywords
- database
- data
- coordinate system
- coordinates
- geographic
- Prior art date
Links
- 238000000034 method Methods 0.000 title claims abstract description 63
- 238000013500 data storage Methods 0.000 title claims abstract description 20
- 238000006243 chemical reaction Methods 0.000 claims abstract description 40
- 230000008569 process Effects 0.000 claims abstract description 37
- 238000007906 compression Methods 0.000 claims description 11
- 230000006835 compression Effects 0.000 claims description 11
- 238000005259 measurement Methods 0.000 claims description 4
- 230000001131 transforming effect Effects 0.000 claims 1
- 238000000638 solvent extraction Methods 0.000 abstract 1
- 238000012545 processing Methods 0.000 description 15
- 230000009466 transformation Effects 0.000 description 12
- 239000012634 fragment Substances 0.000 description 7
- 230000006870 function Effects 0.000 description 7
- 230000014509 gene expression Effects 0.000 description 6
- 238000004364 calculation method Methods 0.000 description 5
- 239000011159 matrix material Substances 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 238000012546 transfer Methods 0.000 description 4
- 238000013501 data transformation Methods 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 238000013461 design Methods 0.000 description 2
- 238000011156 evaluation Methods 0.000 description 2
- 230000011218 segmentation Effects 0.000 description 2
- 230000008901 benefit Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008602 contraction Effects 0.000 description 1
- 238000013144 data compression Methods 0.000 description 1
- 230000007123 defense Effects 0.000 description 1
- 239000003814 drug Substances 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000007613 environmental effect Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 238000000547 structure data Methods 0.000 description 1
- 238000000844 transformation Methods 0.000 description 1
- 238000013519 translation Methods 0.000 description 1
- 230000007306 turnover Effects 0.000 description 1
Landscapes
- Processing Or Creating Images (AREA)
- Instructional Devices (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
1236803 五、發明說明(1) 發明說明 數據庫 先專利 發明背 發明領 這 戶採用 發明背 數 地說訪 存儲性 說不是 以是任 據顯示 單獨應 問的數 定要求 素到壓 如 壓縮數 庫,不 數 據庫, 這是一個申請號碼 壓縮方法 正式專利 的結構 申請之 景 域 項發明 的轉換 景 據庫是 問數據 能,例 重要問 意形式 、數據 用的最 據庫從 。數字 縮數據 果通用 據庫不 需做任 據轉換 還需要 為60/168, 183,標題為,一種地理 ,申請日期為1999年11月27日的預 申請0 與計算機 和構造計 由很 庫是 如數 題。 、或 訪問 通常 一般 數據 庫元 數據 是關 何轉 過程 增強 多用 由不 據庫 特別 幾種 〇由 任務 意義 轉換 素。 庫已 鍵問 換。 大多 應用 數據轉換過程有關,特別是針對用 算機存儲數據語言、格式或方法。 戶訪問的信息元素的集合。更一般 同級別的用戶和應用產生的。數據 大小、容易訪問和容易訪問一般來 地,訪問數據庫的單一應用方面可 形式的組合,例如,數據傳送、數 於一般目的的數據庫性能差,每個 是創建一個數據數字轉換過程將訪 的語言轉換到易懂的語言來滿足特 過程就是轉換一般目的的數據庫元 非常接近理想的壓縮數據庫,或者 題,則數據庫用戶可直接訪問數據 數應用是有必要懂得一般目的的數 性能來取得理想的花費,拓寬應用1236803 V. Description of the invention (1) Description of the invention Database first patent invention back invention collar This family uses the invention back number to talk about storage, not to let the data show that the number of independent questions is required to be compressed, such as compressed data base. No database, this is a structured application for the patent application of the number compression method for the patent application of the field of invention. The conversion of the database is to ask about the data, such as the important question form and the most used data for the data. The digital data reduction database does not need to be converted. It also needs to be 60/168, 183. The title is a kind of geography. The application date is November 27, 1999. The pre-application 0 is related to the computer and structural design. Such as the number of questions. Or access to the general database metadata is usually related to the process enhancement multi-purpose from the database, especially several kinds of 〇 conversion of the meaning of the task. The library has been changed. Most applications are related to the data conversion process, especially for computer storage languages, formats, or methods. A collection of information elements accessed by users. More generally generated by users and applications of the same level. Data size, easy access and easy access In general, the single application aspects of accessing the database can be combined formally, for example, data transfer, poor performance of databases for general purposes, and each is the language that will be accessed during the process of digital data conversion The conversion to an easy-to-understand language to meet the special process is to convert the general purpose database elements that are very close to the ideal compressed database, or questions, then the database user can directly access the data number application. It is necessary to understand the general purpose number performance to achieve the desired cost. , Broadening applications
1236803 五、發明說明(2) 領域。 在最近的 工業 在主 到很 點來 的信 成本 的特 的空 以訪 空間 平台 生的 言或 應用 來存 十億 決的 發明 法, 域0 。在 機中 多單 看, 息通 。該 殊應 間和 問空 地理 下載 。對 格式 領域 目前 儲空 字節 方法 概述 該項 以便 經過 互聯 一個 個客 雖然 過互 項發 用要 文本 間信 數據 數據 於空 ,以 〇 用於 間地 大小 不僅 發明 增強 數據 應用 網或 大的 戶而 很多 聯網 明中 求而 數據 息、 庫, 庫很 間地 增強 中, 電子 數據 沒有 發明 傳送 數據 創建,以 相應 對於 困難 理數 用戶 數據轉換 商務 通過 考慮 用來 ,浪 轉換 的過 文件 的特 有限 。空 據庫 使用 領域 一般 數據 提高 費了 過程 程。 系統 點和 存儲 間地 的特 性能 過程很少 數據傳送 目的的數 的特殊要 傳送性能 有限的資 是基於獲 空間地理 和列表形 文本描述 資源的象 理數據庫 殊應用必 ,獲得理 應用在 是基本 據存儲 求。從 ,然而 源,同 得最大 數據庫 似組織 。由於 掌上PC 是一般 須轉換 想的成 數據處理 的元素。 語言傳送 硬件的觀 很多冗餘 時'增加了 應用性能 是大容量 。用戶用 大容量的 機的應用 意義下產 成特殊語 本,拓寬 空間地理數據庫的系統需要昂貴的存儲設備 理數據庫。基於狀態的空間地理數據庫大約 。但目前最大的存儲設備才兆字節。硬件解 昂貴,而且有時不可行。 的最初目的是提供一個數據轉換過程和方 應用性能,獲得理想的成本,拓寬應用領 轉換後,數據庫大小減小,硬件要求降低。1236803 V. Description of Invention (2) Field. In the recent industry, the cost of a letter from the host to the point of the cost of a special space to visit the space platform to generate language or application to save billions of inventions, domain 0. If you look at the machine, you can see the news. The special room and space geography download. This article outlines the current method of storing empty bytes in the format field so that each customer can pass through the interconnection. Although the text is used to send data to the space, it is not only used to occasionally increase the size of the data application network or large users. However, many networked data sources and libraries have been enhanced. Electronic data has not been invented to transmit data to create data. In response to the difficulties in managing user data conversion, business has been considered. The number of files that have been converted is limited. . The improvement of general data in the field of air database use has taken a long time. The special performance process between system points and storage is very rare. The number of data transfer purposes is special. The data with limited transfer performance is based on the application of imagery databases that acquire spatial geography and tabular text description resources. Obtaining application is fundamental. According to storage requirements. From the source, however, the largest database is similar to the organization. Because the handheld PC is generally an element that must be converted into data processing. The view of language transmission hardware is a lot of redundancy when 'increased application performance is large capacity. Users use large-capacity computers to produce special languages in the sense of application. Broadening the system of spatial geodatabases requires expensive storage facilities to manage databases. State-based spatial geodatabase approx. But currently the largest storage device is only megabytes. Hardware solutions are expensive and sometimes not feasible. The original purpose is to provide a data conversion process and application performance, to obtain the ideal cost, and to broaden the application domain. After conversion, the database size is reduced and hardware requirements are reduced.
第6頁 1236803 五、發明說明(3) 該項發明的另一目的是提供一個數據轉換過程和方法從一 個給定一般意義數據庫來產生一個壓縮數據庫,從一個提 供的意義數據庫來產生一個應用數據庫來增強應用性能, 獲得理想的成本,拓寬應用領域。 該項發明的另一目的是提供一種方法來評估數據轉換 過程和由數據轉換過程產生的壓縮數據庫的效率和性能。 發明概述 該項發明的最初目的是提供一個數據轉換過程和方 法,以便增強應用性能,獲得理想的成本,拓寬應用領 _ 域。經過數據轉換後,數據庫大小減小,硬件要求降低。 該項發明的另一目的是提供一個數據轉換過程和方法從一 _ 個給定一般意義數據庫來產生一個壓縮數據庫,從一個提 供的意義數據庫來產生一個應用數據庫來增強應用性能, 獲得理想的成本,拓寬應用領域。該項發明的另一目的是 提供一種方法來評估數據轉換過程和由數據轉換過程產生 的壓縮數據庫的效率和性能。 該項發明的另一目的是提供一種方法來轉換一般空間 地理數據庫語言到壓縮語言,以取得最小數據存儲大小和 最大的數據訪問性能。 該項發明的另一目的是提供一種方法來轉換一般意義 地理數據庫到經過坐標變換的壓縮多維空間地理數據庫。 該項發明的另一目的是提供一個壓縮數據庫結構來轉 φ 換一般意義地理數據庫到壓縮多維空間地理數據庫,以滿 足應用要求。 'Page 61236803 5. Description of the invention (3) Another object of the invention is to provide a data conversion process and method to generate a compressed database from a given general meaning database and an application database from a provided meaning database. To enhance application performance, obtain ideal costs, and broaden application areas. Another object of this invention is to provide a method to evaluate the efficiency and performance of the data conversion process and the compressed database produced by the data conversion process. Summary of the invention The original purpose of the invention is to provide a data conversion process and method in order to enhance application performance, obtain ideal costs, and broaden application domains. After data conversion, the database size is reduced and hardware requirements are reduced. Another object of the invention is to provide a data conversion process and method to generate a compressed database from a given general meaning database, and to generate an application database from a provided meaning database to enhance application performance and obtain ideal cost. To broaden the application area. Another object of this invention is to provide a method to evaluate the efficiency and performance of the data conversion process and the compressed database produced by the data conversion process. Another object of this invention is to provide a method to convert a general spatial geodatabase language to a compressed language in order to achieve the smallest data storage size and the largest data access performance. Another object of the invention is to provide a method for converting a general-purpose geodatabase to a compressed multidimensional spatial geodatabase that has undergone coordinate transformation. Another object of this invention is to provide a compressed database structure to convert φ from a general-purpose geodatabase to a compressed multidimensional spatial geodatabase to meet application requirements. '
第7頁 1236803 五、發明說明(4) 為了實現以上目的,該項發明提供一種方法來轉換一 般地理數據庫到二維或三維的特定壓縮數據庫。它包括以 下幾步。 (a )分析物理設備(例如掌上PC )的可用的存儲大 小、二維或三維地理坐標的原始空間地理數據庫以及有關 增加存儲量的成本。基於以上的分析,確定在物理設備上 的最後的最大顯示分辨率。 (b )將二維或三維地理坐標的原始空間地理數據庫 分塊,其中每個數據塊根據選定的尺度因子部分或全部顯 示在物理設備的顯示區域。 (c )在每個數據塊中選定一個特定位置作為參考點 鲁 位置(RPP ),或者說把它作為整個數據塊的參考坐標原 點(RC0P ),對整個的原始空間地理數據庫形成RPP集 合。 (d )對每個數據塊分別產生一個局部坐標系統。每 個局部坐標系統使用步驟(c )確定的R P P作為坐標原點。 在分別的數據塊中轉變原始的二維或三維地理坐標到對應 的局部坐標。每個局部坐標都與各個數據塊的原始坐標有 相對位置關係。 例1 ··考慮點B 1在三維迪卡爾坐標系内。點坐標值 為xb= 〔 1 0 0〕τ,假定這個點的坐標元素在0 - 2 5 5之間 變化。點B 1在坐標系中僅需三個字節來存儲坐標值。考慮 _ 另一坐標系B ,其坐標原點與坐標系A相同,它由坐標系A 繞Z軸順時針旋轉3 0度得到。B 1點的坐標值在坐標系B中為Page 7 1236803 V. Description of the invention (4) In order to achieve the above purpose, the invention provides a method to convert a general geographic database to a specific compressed database of two or three dimensions. It includes the following steps. (a) Analyze the physical storage geodatabase of physical devices (such as palm-size PCs) with available storage sizes, two- or three-dimensional geographic coordinates, and the costs associated with increasing storage. Based on the above analysis, determine the final maximum display resolution on the physical device. (b) The original spatial geodatabase of two-dimensional or three-dimensional geographic coordinates is divided into blocks, wherein each data block is displayed in part or all of the display area of the physical device according to the selected scale factor. (c) Select a specific position in each data block as the reference point (RPP), or use it as the reference coordinate origin (RC0P) of the entire data block to form an RPP set for the entire original spatial geodatabase. (d) Generate a local coordinate system for each data block. Each local coordinate system uses the R P P determined in step (c) as the coordinate origin. The original two-dimensional or three-dimensional geographic coordinates are transformed into corresponding local coordinates in separate data blocks. Each local coordinate has a relative positional relationship with the original coordinates of each data block. Example 1 · Consider point B 1 in a three-dimensional Cartesian coordinate system. The coordinate value of the point is xb = [1 0 0] τ. It is assumed that the coordinate element of this point varies between 0-2 5 5. Point B 1 only needs three bytes in the coordinate system to store the coordinate value. Consider _ another coordinate system B whose coordinate origin is the same as coordinate system A, which is obtained by rotating coordinate system A clockwise about 30 degrees around the Z axis. The coordinate value of point 1 in coordinate system B is
第8頁 1236803 五、發明說明(5) x 〔0.866025 0.5 〇·〇〕τ。在不丢失精度情況下需要24 子節存儲同樣的點雙精度浮點值格式。 中 例2 :考慮存儲在ESRI (環境系統研究所)形狀文件 它的,道記錄塊,它包括一系列經度和緯度的坐標。例如 =有三個點:Pl — (— l80〇05 0001,,2 4G 34.0524,),ρ2 — s"^80。05·0 0 0 3,,24034·0512,)和Ρ3—(―u〇g〇5-〇〇〇6,, 果選捏〇 5 24’)。對於這個街道塊需要48個字節存儲。如’ 部迦$個點P1作為參考點坐標,後面的兩個點P2和P3在局 (、〇票系中和為 RP1— (一 〇·00〇2,,〇·0010,)和PR2 — 01和/㈣5’,〇· 0 0 2 2’)。如果引入刻度因子1 〇〇〇,那末 儲。用破表示為(- 2,1 0 ) , ( - 5,2 2 ),僅需4字節存 4字節用於兩個局部坐標點(RP1和RP2 和(c )所述,街道塊記錄屬於數據塊 參考机來存儲衔道的塊的所有字節為20,其中16字節用於 \ 勒位置ρ 1 此 / , \ v. y 7 W ie % aG m 取黎 " 、塊RPP根據選定的參考坐標系統表示為一個局部 數據大小進一步減小。 襟則S 1)^轉$換每個數據塊的一系列參考點位置和局部坐 辕庫,发坐ΐ系統中的像素形式,以形成特殊數字地圖數 式。“中每個數據塊都從雙精度形式轉變到短整數形 藥1據集分析模塊 廣始數據集的分割模塊4 2 -基本參考坐標系的產生模塊 子參考坐標系的產生模塊 1236803 五、發明說明(6) 5 -數據變換模塊 7 -成本函數比較 1 0 -數據庫 3 0 -特定數據庫 模塊 6 -判決函數選擇和計算模塊 8 -數據儲存模塊 2 0 -數據壓縮過程 優選方案之詳細說明 第一圖至第十 明首 中特 首先 言來 得理 器的 構造 據庫 案轉換到 據庫3 0由 選方 定數 由數據壓縮過 表示一種特定 從一般目的數 想成本,擴大 主要目的是評 該項發明主要 應用數據庫, 五圖描述了 一種地理數據庫根據該項發 二維至多維壓縮存儲數據庫的方法。其 一個一般數據庫1 0導出。一般數據庫10 程2 0得到,然後產生一種特定應用的語 數據庫3 0。 據庫應用出發,為了增強應用性能,獲 一般數據庫的應用範圍,產生數據轉換 估數據轉換。 是從應用需求出發,由一般目的數據庫 創建一種特殊語言來描述或明白轉換數 第二圖描述如何評價數據轉換過程2 0性能的基本概 念。 轉換效率E定義為Page 8 1236803 V. Description of the invention (5) x [0.866025 0.5 〇 · 〇] τ. You need 24 subsections to store the same point double precision floating point value format without losing precision. Example 2: Consider a shape file stored in the ESRI (Environmental Systems Research Institute) shape file. It is a track record block that includes a series of longitude and latitude coordinates. For example = there are three points: Pl — (— 8080 05 0001 ,, 2 4G 34.0524,), ρ 2 — s " ^ 80. 05 · 0 0 0 3, 24034 · 0512,) and P3 — (― u〇g 〇5-〇〇〇〇, 〇 〇 5-24 '). For this street block 48 bytes of storage are needed. Such as' Bujia $ point P1 as the reference point coordinates, the next two points P2 and P3 are in the round (, 〇 ticket system is neutralized as RP1-(10. 00, 2, 0, 0010,) and PR2- 01 and / ㈣ 5 ', 〇 0 0 2 2'). If a scale factor of 1000 is introduced, then it is stored. Expressed as (-2, 1 0), (-5, 2 2), only 4 bytes are needed to store 4 bytes for two local coordinate points (RP1 and RP2 and (c)), street block records All bytes belonging to the block that the data block reference machine uses to store the title channel are 20, of which 16 bytes are used for \ LE position ρ 1 this /, \ v. Y 7 W ie% aG m to take the "quote", block RPP according to The selected reference coordinate system is represented as a local data size that is further reduced. The rule S 1) ^ turn $ to change a series of reference point positions and local positioning library for each data block, and send the pixel form in the positioning system to Form special digital map numbers. "Each data block in the transformation from double precision to short integer medicine 1 dataset analysis module segmentation module of Guangshi dataset 4 2-generation of basic reference coordinate system module generation module of sub-reference coordinate system 1236883 V. invention Explanation (6) 5-Data transformation module 7-Cost function comparison 1 0-Database 3 0-Specific database module 6-Decision function selection and calculation module 8-Data storage module 2 0-Detailed description of the preferred scheme of the data compression process First In the picture to the tenth Ming head, the structure of the data processor is transferred to the database 30. The number is selected by the selected party and the data is compressed. It represents a specific cost from the general purpose. The main purpose of the expansion is to evaluate the item. The main application database of the invention is shown in Figure 5. Figure 5 describes a method for a geographic database to send a two-dimensional to multi-dimensional compression storage database according to the item. A general database 10 is exported. The general database 10 is obtained in 20 passes, and then an application-specific language database is generated. 30. Based on the database application, in order to enhance the application performance, obtain the application scope of the general database and generate data conversion. Data conversion. Starting from the application requirements, create a special language to describe a general object database apparent turnover number or a second diagram for describing how to evaluate the performance of the data conversion process 20 the fundamental concepts. Conversion efficiency is defined as E
E ||Da ⑽ 其中,llil表示數 義來度量數據轉換 據轉換過程效率的測度 過程的性能。 應用下面的定E || Da ⑽ where llil represents a number to measure the efficiency of the data conversion process and measure the performance of the process. Apply the following
第10頁 1236803 五、發明說明(7) & ·數據存儲大小的性能測度 數據庫處理的性能測度 數據讀取過程的性能評測 數據庫查詢過程的性能評測 ea: 根據定義 E > 1, 有效的數據轉換過程 E < 1 , 多餘的數據轉換過程 基本的概念是創建該數據轉換過程並且搜索一個使得 E > 1的轉換效率。 參考第三圖根據優選的實現方案一個地理空間信息數 據庫中的一個集合被用來創建一個數字地圖。根據第二圖 地理空間信息數據庫被描述為’’數據庫A π數字地圖數據庫 被描述為由所給地理空間信息數據庫所派生的數據庫Β π 。 ||DatabaseA ||:在通常環境下數據庫Α所需要的存儲 空間 ||DatabaseB ||: 在特定環境下數據庫B所需要的存 儲空間。 顯然,數據庫中的存儲和利用語言或者是地理空間數 據是從地理坐標系統(Geodetic Coordinate, GDC)派生 出來的,其中點是用經緯度坐標來表示的。 地理坐標系統(G D C )是基於地球形狀的某個近似上 的。經典的導航儀器將地球的形狀定義為一個圓形。更精Page 101236803 V. Description of the invention (7) & · Data storage size performance measurement Database processing performance measurement Data reading process performance evaluation Database query process performance evaluation ea: According to the definition E > 1, valid data Conversion process E < 1, The basic concept of redundant data conversion process is to create the data conversion process and search for a conversion efficiency that makes E > 1. Referring to the third figure, a set in a geospatial information database is used to create a digital map according to a preferred implementation. According to the second figure, the geospatial information database is described as a 'database A π digital map database is described as a database B π derived from the given geospatial information database. || DatabaseA ||: Storage space required by database A under normal circumstances || DatabaseB ||: Storage space required by database B under specific circumstances. Obviously, the storage or utilization language or geospatial data in the database is derived from the geographic coordinate system (Geodetic Coordinate, GDC), where the points are represented by latitude and longitude coordinates. The geographic coordinate system (G D C) is based on some approximation of the shape of the earth. Classic navigation instruments define the shape of the earth as a circle. More refined
第11頁 1236803 五、發明說明(8) 確的地理坐標系統要求地球被描述成一個回轉橢圓面,或 者是一個由旋轉形成的橢球。 緯度被定義為從橢球面上某點引申的垂直於該點處橢 球面的一條直線與赤道面之間的夾角。在赤道以北緯度的 取值為正,在赤道以南緯度的取值為負.。經度被定義為經 過橢球面上某點的一個大圓與某個主大圓的小軸(極性轴 )之間的夾角。在該主大圓以東經度的取值為正,在該主 大圓以西經度的取值為負。與起點位於赤道的緯度不同, 作為經度測量起點的橢圓並沒有什麼特徵。經度起點能夠 是任何大圓。在歷史上,國家通常使用通過其國家級天文 台的大圓作為經度起點,由此產生了很多主大圓。按照現 在的慣例,通過英格蘭格林威治的大圓被認為是標準的主 大圓。 橢球和參考點是一個地理坐標的兩個主要部分。目前 有很多橢球被用來模擬地球,其中任何一個橢球都可以通 過不同的方式來將其位置和指向和地球聯系起來。1 9 8 4年 制定的世界地理坐標系統(w 〇 r 1 d G e 〇 d e t i c S y s t e m 1 9 8 4, WGS-84 )定義了當前美國國防部的標準參考點。 W G S - 8 4作為G P S接收機的參考系統,平均海平面(M e a η Sea Level,MSL)被規定為垂直方向上的參考點當空間地 理數據庫使用不同的參考系統或者是參考點的時候,必須 進行不同參考系統或者是之間的轉換。 如何以一種更有效的方式利用空間地理數據庫來在一 個物理顯示設備上創建一幅數字地圖,如何利用最少的計Page 11 1236803 V. Description of the invention (8) The accurate geographic coordinate system requires that the earth be described as a rotating ellipsoid, or an ellipsoid formed by rotation. Latitude is defined as the angle between a straight line extending from a point on the ellipsoid and perpendicular to the ellipsoid at that point and the equatorial plane. At the north latitude, the value is positive, at the south latitude, the value is negative. Longitude is defined as the angle between a large circle passing through a point on the ellipsoid and the minor axis (polar axis) of a major large circle. The value of longitude east of the main great circle is positive, and the value of longitude west of the main great circle is negative. Unlike the latitude where the starting point is at the equator, the ellipse as the starting point for longitude measurement has no characteristics. The starting point of longitude can be any great circle. Historically, countries have often used the great circle passing through their national observatory as the starting point for longitude, which has produced many major great circles. According to current practice, the Great Circle passing through Greenwich, England is considered the standard major circle. The ellipsoid and reference point are the two main parts of a geographic coordinate. Many ellipsoids are currently used to simulate the earth, and any one of them can be used to associate its position and orientation with the earth in different ways. The World Geographic Coordinate System (w o r 1 d G e o d e c s s t e m 1 98, WGS-84), established in 1984, defines the current standard reference point for the US Department of Defense. WGS-8 is used as the reference system for GPS receivers. Mean Sea Level (MSL) is specified as the vertical reference point. When the spatial geodatabase uses different reference systems or reference points, it must be Switch between different reference systems. How to use a spatial geodatabase in a more efficient way to create a digital map on a physical display device
第12頁 1236803 五、發明說明(9) 算機内存存儲這個空間地理數據庫(譬如說最小化數據庫 存儲的空間需求和最大化數據庫存取和查詢的性能),是 本項發明的主要論題。 根據優選的實現方案,將一個通用的地理空間信息數 據庫轉換成一個特殊的經過壓縮的數據庫以實現多維數據 存儲的方法有下列步驟組成: (a )通過分析物理顯示設備(譬如掌上型電腦)可 用的的存儲空間,一個原始的含有二維或者是多維地理坐 標的地理空間信息數據庫,以及增加存儲空間所需要的代 價,為所選用的具有一定顯示面積的物理顯示設備確定一 個最終的顯示分辨率的最大值。 (b )將原來的空間地理坐標系數據庫中的二維或者 是多維地理坐標轉換成一系列數據片斷,其中每個數據片 斷根據所選定的放縮指數部分或者是全部被顯示在物理顯 示設備的現實範圍里。 (c )在每個數據片斷中選取一個特定的點作為整個 數據片段的參考點(Reference Point Position, RPP) 或者將其認為是參考坐標系原點(Reference Coordinate 0 r i g i η P o i n t, R C 0 P ),從而為原來的空間地理信息數 據庫生成一系列的參考點。 (d )為沒個數據片段提供一個局部坐標系統。其中 每個局部坐標系統使用在步驟(c )中確定的參考點(RPP )作為坐標原點。將該數據片段中原來的空間地理數據庫 的二維或者是多維的地理坐標轉換成相對應的局部坐標,Page 12 1236803 V. Description of the invention (9) The computer memory stores this spatial geodatabase (for example, minimizing the storage space of the database and maximizing the performance of database access and query) is the main topic of this invention. According to a preferred implementation scheme, a method for converting a universal geospatial information database into a special compressed database to implement multidimensional data storage consists of the following steps: (a) Available by analyzing a physical display device (such as a palm computer) Storage space, an original geospatial information database containing two-dimensional or multi-dimensional geographic coordinates, and the price required to increase storage space, determine a final display resolution for the physical display device selected with a certain display area The maximum value. (b) Converting the two-dimensional or multi-dimensional geographic coordinates in the original spatial geographic coordinate system database into a series of data fragments, where each data fragment is partially or entirely displayed on the physical display device according to the selected scaling index. Within range. (c) Select a specific point in each data segment as the reference point position (RPP) of the entire data segment or consider it as the reference coordinate system origin (Reference Coordinate 0 rigi η P oint, RC 0 P ) To generate a series of reference points for the original spatial geographic information database. (d) Provide a local coordinate system for each data segment. Each local coordinate system uses the reference point (RPP) determined in step (c) as the coordinate origin. Transform the two-dimensional or multi-dimensional geographic coordinates of the original spatial geodatabase in the data fragment into corresponding local coordinates,
第13頁 1236803 五、發明說明(ίο) 每一個局部坐標是一個局部的點,與該數據片段原來的坐 標相對應。 (e )將一系列參考點位置和每個數據片段的局部地 理坐標轉換成用象素坐標系表示的象素坐標以構成特殊的 數字地圖數據庫,其中每個數據片段從雙精度格式被轉換 成短精度格式。 另外,根據本項發明的優選實現方案,數據庫B或者 式數字地圖數據庫的存儲和使用語言是物理顯示設備上用 象素坐標表示的屏幕平面,而顯示範圍是屏幕平面的表面 積。=在屏幕平面上一個點的坐標(在象素坐標系上)是 用整數來表示的。對於VGA模式來說,屏幕平面的覆蓋範 圍是640X480,對於超級VGA模式來說,屏幕平面的覆蓋範 圍是800X600 。 在傳統的地理坐標系中,經緯度坐標需要用一個6 4位 的詞(雙精度格式)來表示,因此 || Database A || =64 根據本項發明,在數字地圖數據庫中,當數字地圖在 物理顯示設備上被顯示時使用象素坐標系統。根據目前最 先進的顯示設備指標,顯示範圍能夠用一個1 0位的詞(短 整數格式)來表示,因此 || Database B || =10Page 13 1236803 V. Description of the Invention (ίο) Each local coordinate is a local point, which corresponds to the original coordinates of the data segment. (e) Converting a series of reference point positions and local geographic coordinates of each data segment into pixel coordinates represented by a pixel coordinate system to form a special digital map database, where each data segment is converted from a double-precision format into Short precision format. In addition, according to a preferred implementation of the present invention, the storage and use language of the database B or the digital map database is a screen plane represented by pixel coordinates on a physical display device, and the display range is a surface area of the screen plane. = The coordinates of a point on the screen plane (in the pixel coordinate system) are expressed as integers. For VGA mode, the coverage of the screen plane is 640X480, and for Super VGA mode, the coverage of the screen plane is 800X600. In the traditional geographic coordinate system, the latitude and longitude coordinates need to be represented by a 64-bit word (double precision format), so || Database A || = 64 According to this invention, in the digital map database, when the digital map is in The pixel coordinate system is used when displayed on a physical display device. According to the most advanced display equipment indicators, the display range can be represented by a 10-bit word (short integer format), so || Database B || = 10
1236803 五、發明說明(11) 結合以上結果,可以得到數據庫存儲空間的性能 6.4 c _\\ Database A\\s 64 XI ^ ~ ——— || Database B ||5 j〇 根據上面的結論,將數據存儲語言從經緯度坐標系轉 換到象素圖形坐標系的轉換效率大概是6 · 4,這表明特殊 數據庫的性能得到了大幅度的提高。 根據數據庫處理的性能計算,本項發明中的數據轉換 過程還有另外一個好處。為了獲取或者是查詢經緯度坐 標,數據庫處理的性能由如下公式計算: || Database A || =浮點處理器的性能 在象素坐標系中,數據庫處理的性能由如下公式計 算: || Database B || =整數計算的性能 數據轉換過程中的數據庫處理性能被定義為 || Database A ||p _ Performance of float processor || Database B \\p Performance of Integer Calculation1236803 V. Description of the invention (11) Combining the above results, the performance of the database storage space can be obtained 6.4 c _ \\ Database A \\ s 64 XI ^ ~ ——— | | Database B || 5 j〇 According to the above conclusion, The conversion efficiency of the data storage language from the latitude and longitude coordinate system to the pixel graphics coordinate system is about 6.4, which indicates that the performance of the special database has been greatly improved. According to the performance calculation of the database processing, the data conversion process in this invention has another advantage. In order to obtain or query the latitude and longitude coordinates, the performance of the database processing is calculated by the following formula: || Database A || = Performance of the floating-point processor In the pixel coordinate system, the performance of the database processing is calculated by the following formula: || Database B || = Integer calculation performance The database processing performance during data conversion is defined as || Database A || p _ Performance of float processor || Database B \\ p Performance of Integer Calculation
第15頁 1236803 五、發明說明(12) 在一些應用或者是應用平台中,沒有配備支持浮點處 理的硬件。這或者使處理雙精度數據格式成為不可能,或 者是由於使用軟件模擬器而導致不好的性能。 在沒有配備支持浮點處理硬件的應用平台上,數據轉 換過程的數據庫處理性能被估計為:Page 15 1236803 V. Description of the invention (12) In some applications or application platforms, there is no hardware that supports floating point processing. This either makes it impossible to handle double-precision data formats, or results in poor performance due to the use of software simulators. On an application platform not equipped with hardware supporting floating point processing, the database processing performance of the data conversion process is estimated as:
Ep > > 1 在配備了支持浮點處理硬件的應用平台上,數據轉換 過程中的數據庫處理性能被估計為·· 1<EP<2 從數據庫處理性能的角度來看,本項發明的數據轉換 過程導致了數據庫處理速度的提高並改善了應用系統的性 能。 數據訪問和查詢的性能由數據存儲語言所決定。通常 來說,數據訪問和查詢的性能不能夠在一個普通的層面上 考慮。當數據存儲語言被重新構造之後,數據訪問和查詢 的性能能夠輕易的被大幅度提高,使得:Ep > > 1 On an application platform equipped with hardware supporting floating point processing, the database processing performance during data conversion is estimated to be 1 < EP < 2 from the perspective of database processing performance, The data conversion process leads to an increase in database processing speed and improves the performance of the application system. The performance of data access and query is determined by the data storage language. In general, the performance of data access and query cannot be considered at a general level. After the data storage language is restructured, the performance of data access and query can be greatly improved, making:
EA EQ >> >> 第四圖示出產生基於象素的平面的過程。第五圖示出 數據轉換的流程。 一般的地理數據庫是基於緯度和經度坐標系產生EA EQ > > > > The fourth figure shows the process of generating a pixel-based plane. The fifth figure shows the flow of data conversion. General geodatabases are generated based on latitude and longitude coordinate systems
第16頁 1236803 五、發明說明(13) 的。在數字地圖數據庫中,當數字地圖被顯示在物理器件 上時’象素坐標系被使用。根據具體的應用場合,需要從 地理數據庫中’生成特定的數據庫,以便與將數字地圖顯 示在物理器件上。數據轉換過程被定義為,從地理緯度和 經度坐標的語言和形式變化到象素坐標的的語言和形式。 完成這樣一數據轉換,有幾個步驟。第六圖到第十一圖示 出建立倆個或倆個以上的應用數據庫和產生基於象素的平 面的詳細過程。 根據本項發明的優選實現方案,上述步驟(a )進一 步包含:Page 16 1236803 V. Description of Invention (13). In a digital map database, the 'pixel coordinate system is used when a digital map is displayed on a physical device. According to the specific application, a specific database needs to be generated from the geodatabase to display the digital map on the physical device. The data conversion process is defined as the change from the language and form of geographic latitude and longitude coordinates to the language and form of pixel coordinates. There are several steps to complete such a data conversion. The sixth to eleventh diagrams illustrate the detailed process of creating two or more application databases and generating pixel-based planes. According to a preferred implementation solution of the present invention, the above step (a) further includes:
(a - 1 )計算特定顯示物理器件的最大顯示區域,以 便獲得最好的性能。特定顯示器件的最大顯示區域,對 VGA,是640x480,對超VGa,是 1024x780。 (a - 2 )根據倆維或多維地理數據庫(如經度和緯度 ),計算最大刻度係數,以便增強系統性能。(a - 2 )是 由地理數據庫所定的。 .為了清晰地描述步驟(a - 2 ),考慮例2。一個文件存 儲的街道記錄片段’包括三個點P 1 - ( 1 8 0 ° 0 5 . 0 0 0 1,, 24° 34·0502’ ),P2-(-180° 05.0003,,24° 34.0512,),和 P3-(-180° 05.0006’, 24° 34.0524’),被轉換為RPP (-180° 05.0001’,2434.0502,)和二個精度為〇·0001 (即 1 / 1 0 0 0 0 )二個本地點 R P 1 ( - 2,1 0 )和 R P 2 ( - 5,2 2 ) ° 其 中,這三點可用2 0字節存儲。如果根據二維或多維地理坐 標系,將精度降低為0 · 0 〇 1 (1 /1 〇 〇 〇 ),則後續二點可表達(a-1) Calculate the maximum display area of a specific display physical device to obtain the best performance. The maximum display area for a particular display device is 640x480 for VGA and 1024x780 for Super VGa. (a-2) Calculate the maximum scale factor based on a two-dimensional or multi-dimensional geodatabase (such as longitude and latitude) to enhance system performance. (A-2) is determined by the geodatabase. To clearly describe step (a-2), consider Example 2. A file stored street record snippet 'includes three points P 1-(18 0 ° 0 .5 0 0 0 1, 24 ° 34 · 0502'), P2-(-180 ° 05.0003, 24 ° 34.0512, ), And P3-(-180 ° 05.0006 ', 24 ° 34.0524'), are converted to RPP (-180 ° 05.0001 ', 2434.0502,) and the two precisions are 0.001 (ie 1/1 0 0 0 0) Two local locations RP 1 (-2,1 0) and RP 2 (-5,2 2) ° Among them, these three points can be stored by 20 bytes. If the accuracy is reduced to 0 · 0 〇 1 (1/1 〇 〇 〇) according to the two-dimensional or multi-dimensional geographic coordinate system, the following two points can be expressed
第17頁 1236803 五、發明說明(14) 為((K 0 0 0,0 · 0 0 1 )和(-0 · 0 0 1,0 · 0 0 2 )。引入刻度係數為 1 0 0 0 ,則PR1和PR2可表示為(0, 1)和(-1,2)可用2字節存 儲。用來存儲街道記錄片段所用的總字節數為1 8,其中1 6 字節用於參考點p 1 ,2字節用於倆本地點(P R 1和P R 2 )。 (a - 3 )根據象素坐標系,決定最大精度,以便地理 數據點在二維或多維地理坐標系内達到最大的精度。其 中,決定能被特定顯示器件的最大顯示區域以不損失精度 方式所表示的在倆維或多維地理坐標系的實際尺寸。當根 據象素坐標系,決定最大精度時,也考慮到增加存儲量的 成本。 在步驟(b )中基於以二維或多維地理坐標表達的實 際數據庫尺寸,地理數據庫被最優分割為數個數據段,其 二維或多維地理坐標是以選定的顯示器件或單元的最大顯 示區域表示的,且無精度損失。每一數據段被顯示在選定 的顯示器件或單元的最大顯示區域内,且無精度損失。該 步驟的方框圖表示在第八圖内。 上述步驟(c)進一步包括以下分步驟: (c - 1 )在全球坐標系内,分析以二維或多維地理坐 標表達的通用地理數據庫,以便唯一地產生分割的數據 段; (c - 2 )在每一數據段内,找出一特別點(稱為參考 點),用來表示該數據段。該選種的點(PPR )被定義為 該數據段的原點。其中,該數據段内的每一點的絕對位 置,都可通過該原點,以倆維或多維地理坐標,精確表Page 171236803 V. Description of the invention (14) is ((K 0 0 0, 0 · 0 0 1) and (-0 · 0 0 1, 0 · 0 0 2). The scale factor is introduced as 1 0 0 0. Then PR1 and PR2 can be expressed as (0, 1) and (-1, 2) can be stored in 2 bytes. The total number of bytes used to store the street record segment is 18, of which 16 bytes are used as reference points p 1 and 2 bytes are used for the two locations (PR 1 and PR 2). (a-3) According to the pixel coordinate system, the maximum accuracy is determined so that the geographic data points reach the maximum in the two-dimensional or multi-dimensional geographic coordinate system. Precision. Among them, determine the actual size in a two-dimensional or multi-dimensional geographic coordinate system that can be represented by the maximum display area of a particular display device without loss of accuracy. When determining the maximum accuracy based on the pixel coordinate system, it is also considered to increase The cost of storage. In step (b), based on the actual database size expressed in two-dimensional or multi-dimensional geographic coordinates, the geographic database is optimally divided into several data segments whose two-dimensional or multi-dimensional geographic coordinates are based on the selected display device or The maximum display area of the unit is indicated without loss of precision. Each number The segment is displayed within the maximum display area of the selected display device or unit without loss of accuracy. The block diagram of this step is shown in Figure 8. The above step (c) further includes the following sub-steps: (c-1) worldwide In a coordinate system, analyze a general geographic database expressed in two-dimensional or multi-dimensional geographic coordinates to uniquely generate segmented data segments; (c-2) In each data segment, find a special point (called a reference point) , Used to represent the data segment. The selected point (PPR) is defined as the origin of the data segment. Among them, the absolute position of each point in the data segment can pass through the origin in two dimensions or Multidimensional geographic coordinates, accurate table
第18頁 1236803 五、發明說明(15) 示。 在步驟(d )中,相對與原點的本地位置是以雙精度 方式表示的。本地位置關係可轉換到全球坐標系内。Page 18 1236803 V. Description of Invention (15). In step (d), the local position relative to the origin is expressed in double precision. Local position relationships can be transformed into a global coordinate system.
V local CT] 77original 其中,β 代表本地坐標,β Mginal代表選定點在原 來坐標系内的坐標。矩陣〔T〕代表從全球坐標系到本地 坐標系的變換矩陣。 在步驟(e )中,以二維或多維地理坐標表示的每一 數據段被轉換為象素坐標: )i X e 1 τV local CT] 77original where β represents local coordinates and β Mginal represents the coordinates of the selected point in the original coordinate system. Matrix [T] represents the transformation matrix from the global coordinate system to the local coordinate system. In step (e), each data segment represented by two-dimensional or multi-dimensional geographic coordinates is converted into pixel coordinates:) i X e 1 τ
GPGP
V local 其中,tpixel是象素坐標形式。變換矩陣用來將雙精 度的數據段轉換為短精度表示的數據段。本質上,步驟 (E )是將二維或多維地理坐標轉換為象素坐標。變換矩 陣是從地理空間到象素空間的坐標變換的橋梁。 第六圖示出數據集A的步驟1分析和處理的情形。第七 圖示出數據集A的步驟(A )到(E )的基本坐標系和參考 坐標系的建立過程。第八圖示出根據給定的判決函數,數 據集A被分成幾個子數據集的情形。第九圖示出從第八圖 得出的子坐標系和參考點的建立過程,即數據集A的子點 的建立。第十圖示出數據集A變換為子數據集B 6的情形。V local where tpixel is the pixel coordinate form. The transformation matrix is used to convert a double-precision data segment into a short-precision data segment. In essence, step (E) is to convert two-dimensional or multi-dimensional geographic coordinates to pixel coordinates. The transformation matrix is a bridge for coordinate transformation from geographic space to pixel space. The sixth figure shows the analysis and processing of step 1 of the data set A. The seventh figure shows the process of establishing the basic coordinate system and the reference coordinate system of steps (A) to (E) of the data set A. The eighth figure shows a case where the data set A is divided into several sub-data sets according to a given decision function. The ninth figure shows the establishment process of the sub-coordinate system and the reference point obtained from the eighth figure, that is, the establishment of the sub-points of the data set A. The tenth figure shows a case where the data set A is transformed into a sub-data set B 6.
第19頁 1236803 五、發明說明(16) 第十二圖示出本發明的新的層次數據存儲結構 步驟(e )之後,數據存儲的性能指標Page 19 1236803 V. Description of the invention (16) The twelfth figure shows the new hierarchical data storage structure of the present invention. After step (e), the performance index of data storage
Ec || Database Λ ||5 _ 64 II Database B ||5 10 6.4 可以達到。 在步驟(e )之後,為了極大地提高產生的數據庫的 訪問和查詢速度,本發明進一步包含一附加步驟(f ), 建立一與步驟(a )到(e )數據變換過程相連的索引文 件。 步驟(f )用來提高數據庫的訪問和查詢速度,實 現: EA >> 1 EQ >> 1 如第五圖所示,本發明的實現包含7個模塊,即數據 集分析模塊1 ,基本參考坐標系的產生模塊2,原始數據集 的分割模塊3,子參考坐標系的產生模塊4,數據變換模塊 5,判決函數選擇和計算模塊6,成本函數比較模塊7,以 及數據儲存模塊8。 數據集的任何一點,都可考慮為一特定參數空間的 一點,其中,該空間的維數是根據特定問題的要求而確定Ec || Database Λ || 5 _ 64 II Database B || 5 10 6.4 can be reached. After step (e), in order to greatly improve the access and query speed of the generated database, the present invention further includes an additional step (f), establishing an index file connected to the data transformation process of steps (a) to (e). Step (f) is used to improve the speed of database access and query to achieve: EA > > 1 EQ > > 1 As shown in the fifth figure, the implementation of the present invention includes 7 modules, namely a data set analysis module 1 , Basic reference coordinate system generation module 2, original data set segmentation module 3, sub-reference coordinate system generation module 4, data transformation module 5, decision function selection and calculation module 6, cost function comparison module 7, and data storage module 8. Any point in the data set can be considered as a point in a specific parameter space, where the dimension of the space is determined according to the requirements of a specific problem
第20頁 1236803 五、發明說明(17) 的。我們知道,同樣的參數空間,可用不同的坐標系表 示。參數空間的一點可有不同的表達形式。不同的坐標系 之間存在特定的關係。我們將參數空間的坐標系A到坐標 系B的關係定義為影像,表示為Page 20 1236803 V. Description of Invention (17). We know that the same parameter space can be represented by different coordinate systems. A point in the parameter space can have different expressions. There are specific relationships between different coordinate systems. We define the relationship between the coordinate system A to the coordinate system B in the parameter space as an image, expressed as
R: A=>B 一坐標系如A坐標系的一點p的表達被認為是坐標 值。p點的表達的複雜程度隨選用的該參數空間的不同坐 標系而變化。因此。對p點來說,肯定存在一坐標系,P點 -在該坐標系内,有最簡單的表達形式。這樣,也降低了數 據存儲的尺寸,即,我們使用最簡單的表達形式來表示或 ® 記錄同樣的點和數據集。 通常,二維或多維地理坐標系統的任何二坐標系之 間,有二類坐標變換。即平移變換和旋轉變換。 作為一個例子,我們考慮在三維卡第爾坐標系内的一般坐 標變換。假定坐標系xbybzb是由基本坐標系xyz平移x〇,繞 X -、或y -、或z -軸旋轉而得到的。則,p點的相應與坐標 系xbybzb的坐標值xb可轉換為相應與基本坐標系xy z的值X, 可表達為 X = x0 + R xb 其中,繞x-、或y-、或z -軸旋轉的旋轉矩陣R用來表 · 達坐標和函數空間變換的處理。 通過定義相對與一直角坐標系的方位角,可建立一套 _R: A = > B An expression of a point p in a coordinate system such as the A coordinate system is considered to be a coordinate value. The complexity of the p-point expression varies with the different coordinate systems of the parameter space selected. therefore. For point p, there must be a coordinate system. In point P, there is the simplest form of expression. This also reduces the size of the data store, that is, we use the simplest form of representation to represent or record the same points and data sets. Generally, there are two types of coordinate transformations between any two coordinate systems of a two-dimensional or multi-dimensional geographic coordinate system. That is, translation transformation and rotation transformation. As an example, we consider a general coordinate transformation in a three-dimensional Cartier coordinate system. It is assumed that the coordinate system xbybzb is obtained by translating x0 by the basic coordinate system xyz and rotating about the X-, or y-, or z-axis. Then, the coordinate value xb corresponding to the p point and the coordinate system xbybzb can be converted into a value X corresponding to the basic coordinate system xy z, which can be expressed as X = x0 + R xb where X-, or y-, or z- The rotation matrix R of the axis rotation is used to represent the processing of coordinate and function space transformation. By defining azimuths relative to the rectangular coordinate system, a set of _
第21頁 1236803 五、發明說明(18) 坐標變量。橫滚角,俯仰角,航向角(R P Y )可定義為相 對與參考坐標系繞X、γ、Z軸旋轉的旋轉角(r,/5和α )。 以橫滾角(7 ),俯仰角(/3 ),航向角(α )表示的相對與參 考坐標系坐標變換(RPY )可表示為以下的連續旋轉操 作,其中參考坐標系的軸平行與基本坐標系的軸: RPY(Y,P,a) = Rz (y)R/(P)Rx^ (α)= cos 7 cos β cos γ sin j8 sin oc - sin y cos a cos γ sin β cos a + sin 7 sin a sin 7 cos β sin y sin /3 sin a + cos 7 cos a sin γ sin β cos a cos y sin sa 一 sin )8 cos sin a cos cos a 〔a b c〕 假定丨P點在坐標系xbybzb中的坐標為 P點在基本坐標系的值χ為: 'a cos 7 cos β + b(cos γ sin /3 sin a - sin γ cos a) + c(cos 7 sin /3 cos a + sin y sin a) ’ a sin γ cos j8 + &(sin 7 sin j3 sin a + cos y cos a) + c(sin 7 sin j3 cos a - cos 7 sin a(-sin j8) + b(cos β sin a) + c(cos β cos a) p點在基本坐標系的表達的複雜程度明顯要大於坐標 系xbybzb的表達。 第十二圖是每一數據的内部結構的數據結構。這種數 據結構可成指數形式增加數據的訪問和查詢性能。數據段 包括從1到N個記錄。每個記錄包括含幾個偏值和内容。偏Page 21 1236803 V. Description of the invention (18) Coordinate variables. The roll angle, pitch angle, and heading angle (RPY) can be defined as the rotation angles (r, / 5, and α) that rotate relative to the reference coordinate system around the X, γ, and Z axes. The relative and reference coordinate system coordinate transformation (RPY) represented by roll angle (7), pitch angle (/ 3), and heading angle (α) can be expressed as the following continuous rotation operations, where the axis of the reference coordinate system is parallel to the basic Axis of the coordinate system: RPY (Y, P, a) = Rz (y) R / (P) Rx ^ (α) = cos 7 cos β cos γ sin j8 sin oc-sin y cos a cos γ sin β cos a + sin 7 sin a sin 7 cos β sin y sin / 3 sin a + cos 7 cos a sin γ sin β cos a cos y sin sa-sin) 8 cos sin a cos cos a (abc) Assume that the point P is in the coordinates The coordinates in the system xbybzb are the values of the point P in the basic coordinate system χ are: 'a cos 7 cos β + b (cos γ sin / 3 sin a-sin γ cos a) + c (cos 7 sin / 3 cos a + sin y sin a) 'a sin γ cos j8 + & (sin 7 sin j3 sin a + cos y cos a) + c (sin 7 sin j3 cos a-cos 7 sin a (-sin j8) + b (cos The expression of β sin a) + c (cos β cos a) in the basic coordinate system is obviously more complicated than the expression of the coordinate system xbybzb. The twelfth figure is the data structure of the internal structure of each data. This data Structure can be indexed to increase data access and queryability The data segment includes from 1 to N records. Each record includes content and containing several offset value. Partial
第22頁 1236803 五、發明說明(19) 值是内容的索引。内容記錄實際的值。其它文件用來記錄 每個記錄的偏值。 設計的存儲數據結構提高了數據的訪問和查詢性能, 實現了 : E a > > 1 Eg >> 1 第三圖是數據搜索和查詢的方框圖。 數據查詢過程是從每一記錄開始。如果被查詢的數據 屬於被搜索的數據段,則開始搜索它的子記錄,直到數據 查詢完畢。這裡存在一個在數據結構設計折衷問題,以便 達到最好的性能。 第十四圖是本項發明的基於GPS或者是I MU的空間查詢 程序。這一步驟是本項發明的另外一個重要部分。 基於GPS或者是IMU的點查詢程序是一個經過改進的創 建基於象素的可應用之數據庫的程序。該程序從GPS或者 是I MU輸入中查找與顯示設備相關聯的象素坐標,該顯示 設備包含有所述數據的圖形化表示。 空間查詢是通過訪問一個空間地理數據庫獲取與某個 空間對象的屬性或者是特徵,例如點,的程序。該空間對 象由GPS或者是IMU輸入定義在含有數據的圖形化表示的顯 示設備上的某個特定的位置處。為了獲取關於該空間對象 的信息,查詢算法必須首先搜索索引文件。 通過空間查詢得到的空間索引給出了相關的數據片 斷,因為空間索引文件是從屬於數據片斷目錄的。因此,Page 22 1236803 V. Description of the invention (19) The value is an index of the content. The content records the actual value. Other files are used to record the bias of each record. The designed storage data structure improves data access and query performance, and realizes: E a > > 1 Eg > > 1 The third figure is a block diagram of data search and query. The data query process starts with each record. If the queried data belongs to the searched data segment, it starts to search its child records until the data query is completed. There is a trade-off in data structure design in order to achieve the best performance. The fourteenth figure is a GPS or I MU-based spatial query program of the present invention. This step is another important part of the invention. The point query program based on GPS or IMU is an improved program for creating a pixel-based applicable database. The program looks up the GPS or IMU input for pixel coordinates associated with a display device that contains a graphical representation of the data. Spatial query is a program that accesses a spatial geodatabase to obtain the attributes or characteristics of a spatial object, such as points. The spatial object is defined by GPS or IMU input at a specific location on a display device containing a graphical representation of the data. In order to obtain information about the spatial object, the query algorithm must first search the index file. The spatial index obtained by the spatial query gives the relevant data fragment, because the spatial index file belongs to the data fragment directory. therefore,
第23頁 1236803 五、發明說明(20) 當適當的數 數據片斷中 通過基 夠直接的被 的數據片斷 些記錄。該 Amax ]以内 的下一個步 或者是多維 坐標表示的 改的從象素 第十五 程。 將顯示 為〔xs、ys〕 的坐標在平 幕上某點相 出: 詢 間的·、。圖據描轉空 查空詢 一min數十數圖的找 , 的查、0m條第始三標查 後效象2、C的。原十坐中 以 有對1圍.錄集的第據入 來的間1=範記子示。數輸 出MU空Μ在的的表程理极 認 U行以定及錄式過地點 確 者進含限、> 記形的間幕 被 或小包被是找據式空屏 斷。S5縮庫庫tη查數形到在 片行GP來據據其是標集標是 據進於用數數,驟坐子坐圖 可以只在相關的 地理數據訪問能 範圍。假定相關 、η)表示的一 入 min,必 max、 查找目標記錄 描述了將以二維 庫轉換為以象素 述了一個經過修 換過程。 間地理坐標的流 備 設 其 原 某中 示 表 中 統 系 標 坐 面 平 幕 屏 在 標 坐 的 左 的 幕 屏 於 位 角 左 幕 結 ο 的 /—\ ο加 y相 XO量 C向 為下 示如 表由 被標 中坐 統角 系直 標面 坐平 角的 直應 面對 角屏 上與 得 果 〔xs、ys〕=〔 xs、ys〕+〔 kiXs、k2ys J 在上面的公式中,k i和k 2分別是水平軸和垂直軸上的 放縮係數。通常來說,kn和k2。 下一步,平面上的點〔X · y〕被轉換成橢球上的點Page 23 1236803 V. Description of the invention (20) When the appropriate number of data fragments is passed through the data fragments that are directly direct. The next step within the Amax] or the multi-dimensional coordinate representation is changed from the pixel to the fifteenth pass. Coordinates displayed as [xs, ys] are displayed at a point on the screen: ·, between queries. The picture is turned to empty, and the empty query is searched for a few dozens of minutes in one minute. In the original ten sits, there is a time interval 1 = Fan Jizi shown in the first record of the collection. The schedule of the digital output MU is very clear. The U line is used to determine and record the location. The limit of entry, > the shape of the curtain or the small envelope is an evidence-based empty screen. The S5 contraction library tη checks the number and shape to the on-line GP, according to which it is the standard set, and the data is based on the number of use. The abrupt map can only be accessed in the relevant geographic data range. Assume that the correlation, η) is entered into min, must be max, and the search for the target record describes the process of converting from a two-dimensional library to pixels. The flow of geographic coordinates is based on the original system shown in the table below. The flat screen on the left side of the standard screen on the left side of the standard position is located at the left corner of the screen. Add the y phase XO amount C to the downward direction. As shown in the table above, the angle of the sitting angle of the standard system, the straight angle of the sitting plane, and the straight angle of the flat angle face, and the result [xs, ys] = [xs, ys] + [kiXs, k2ys J. In the above formula, ki and k 2 are the scaling factors on the horizontal and vertical axes, respectively. In general, kn and k2. Next, the point [X · y] on the plane is converted into a point on the ellipsoid
第24頁Page 24
1236803 五、發明說明(21) 〔0 . λ〕。在這個轉換過程中包括以下兩個步驟。 步驟1 :將數據片斷中的平面上的點〔X . y〕換成以地 理經緯度坐標表示的〔0 . λ〕。這是第四圖中所述過程 的一個修正過程。 步驟2 :利用建立的空間索引文件獲取空間信息。重 新建立空間坐標的算法是將數據從分塊的局部坐標系統轉 換到全局的坐標系統。1236803 V. Description of the invention (21) [0. Λ]. There are two steps involved in this conversion process. Step 1: Replace the point [X.y] on the plane in the data segment with [0.λ] expressed in geological latitude and longitude coordinates. This is a modification of the process described in the fourth figure. Step 2: Use the created spatial index file to obtain spatial information. The algorithm for re-establishing spatial coordinates is to transform the data from the local coordinate system of the block to the global coordinate system.
第25頁 1236803 圖式簡單說明 圖示說明 第一圖: 第二圖: 第三圖: 第四圖: 第五圖: 第六圖: 第七圖: 第八圖: 第九圖: 第十圖: 第十一圖 第十二圖 第十三圖 第十四圖 第十五圖 。據 圖數 塊生 方產 的法 能方 功該 換由 轉和 字能 數性 據程 數過 明換 發轉 項據 該數 述述 ^0 务日 是是 圖 。塊 圖方 塊的 方程 的過 念換 概轉 本據 基數 的述 率描 效是 塊 方 的 能 。功 圖縮 塊壓 方級 的逐 程據 過數 面圖 平地 素明 像發 建項 創該 述述 ¾¾ 是是 。數 圖是 A 集 據 來 用 將 它 本 έκ 榡 的 \ly 據 數 圖 地 如 例 據 數 個 干 若 成 分 A 標集 坐據 本數 基將 立 1¾ 建準 中的 。集定 理據給 處數據 和在根 析述述 分描描 考 參 和 統 系 和 統 系 標 坐 子 的 集 子 據 數 的 得 獲 所 中 圖 八 。第 集述 子描 換 變 的 6 B 集 子 據 數 Ο 立到 A 建集 的據 胃ρ數 考述 參描 。構 構結 結據 儲數 存的 據構 數結 層部 分内 的塊 新據 明數 發個 項每 該明 述說 描是 塊 方 的 作 操 ο 問 圖卩 塊Η標f坐 /Ί S 操P 才G 問的 訪明 庫發 據項 數該 述述 +曰 务9 程 過 的 標 坐 ίι 地 索 搜 入 輸 幕 屏 鼠 滑 擊 單 。述 圖描Page 25, 1236883 The drawings are briefly explained and illustrated the first picture: the second picture: the third picture: the fourth picture: the fifth picture: the sixth picture: the seventh picture: the eighth picture: the ninth picture: the tenth picture : Eleventh figure Twelfth figure Thirteenth figure Fourteenth figure Fifteenth figure. According to the figure, the method and function produced by the block producer should be replaced by Zhuanhe and the word data. The number of data can be changed and the transfer data should be replaced. The block graph square block equation's conversion is based on the basic radix rate description effect is the block square's energy. The work chart is compact and the square-by-step data is based on a number of maps. The ground is plain and the image is created. The project is created. ¾ Yes. A number is set according to FIG it with the present έκ Su \ LY data according to several embodiments of the present data the number of stem-yl standpipe 1¾ to FIG built Registration Number as component A landmark set when sitting. Figure 8 shows the set data obtained from the set of data and the description of the reference data of the reference system and the reference system of the system. In the first episode, the subdata of the 6B episode, which is changed from the first episode, to the first episode of A, is described in reference. The new data of the block in the structure layer of the data structure are stored in the structure data structure, and each item should be explicitly described as the operation of the block side. The number of items issued by G's visit to Mingku should be described + the standard 9th pass of the task has been searched for and entered into the input screen mouse swipe slip. Description
第26頁Page 26
Claims (1)
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US09/724,430 US6868421B1 (en) | 1999-11-27 | 2000-11-27 | Method of converting geospatial database into compressive database for multiple dimensional data storage |
Publications (1)
Publication Number | Publication Date |
---|---|
TWI236803B true TWI236803B (en) | 2005-07-21 |
Family
ID=36675057
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
TW90112743A TWI236803B (en) | 2000-11-27 | 2001-05-24 | Method of converting geospatial database into compressive database for multiple dimensional data storage |
Country Status (1)
Country | Link |
---|---|
TW (1) | TWI236803B (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113658271A (en) * | 2021-08-18 | 2021-11-16 | 上海智能新能源汽车科创功能平台有限公司 | Obstacle space coordinate edge calculation method based on road side monocular vision |
CN110869981B (en) * | 2016-12-30 | 2023-12-01 | 辉达公司 | Vector data encoding of high definition map data for autonomous vehicles |
-
2001
- 2001-05-24 TW TW90112743A patent/TWI236803B/en not_active IP Right Cessation
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110869981B (en) * | 2016-12-30 | 2023-12-01 | 辉达公司 | Vector data encoding of high definition map data for autonomous vehicles |
CN113658271A (en) * | 2021-08-18 | 2021-11-16 | 上海智能新能源汽车科创功能平台有限公司 | Obstacle space coordinate edge calculation method based on road side monocular vision |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US6868421B1 (en) | Method of converting geospatial database into compressive database for multiple dimensional data storage | |
US7562289B2 (en) | Methods and systems for encoding geographic coordinates and features in a portable document format file | |
Yang et al. | Performance‐improving techniques in web‐based GIS | |
Coors | 3D-GIS in networking environments | |
US7966301B2 (en) | System and method for employing a grid index for location and precision encoding | |
Schilling et al. | Using glTF for streaming CityGML 3D city models | |
Benhamu et al. | Toward a spatial 3D cadastre in Israel | |
WO2021168989A1 (en) | Method and apparatus for constructing multi-source spatial database for transmission line corridor | |
AU2018213401A1 (en) | Digital earth framework and indexing schema to extend any "surface" Discrete Global Grid System to construct interoperable "volumetric" Discrete Global Grid Systems | |
US20130339411A1 (en) | Storage of Arbitrary Points in N-Space and Retrieval of Subset Thereof Based on Criteria Including Maximum Distance to an Arbitrary Reference Point | |
CN109299184B (en) | Unified coding visualization method for three-dimensional point cloud in near-earth space | |
Reddy et al. | Under the hood of GeoVRML 1.0 | |
Trapp et al. | 3D generalization lenses for interactive focus+ context visualization of virtual city models | |
Adams | Wāhi, a discrete global grid gazetteer built using linked open data | |
Cetl et al. | A comparison of address geocoding techniques–case study of the city of Zagreb, Croatia | |
US20150058390A1 (en) | Storage of Arbitrary Points in N-Space and Retrieval of Subset Thereof Based on a Determinate Distance Interval from an Arbitrary Reference Point | |
TWI240085B (en) | Enhanced global positioning system and map navigation process | |
Bowater et al. | An open-source web service for creating quadrilateral grids based on the rHEALPix Discrete Global Grid System | |
TWI236803B (en) | Method of converting geospatial database into compressive database for multiple dimensional data storage | |
Kim et al. | Preparing and evaluating geospatial data models using X3D encodings for web 3D geovisualization services | |
CN113360586A (en) | Address aggregation degree query method, device and equipment and computer readable storage medium | |
Safra et al. | Integrating data from maps on the world-wide web | |
Goodchild et al. | Discrete global grids: A web book | |
Zhu et al. | Efficient management of ubiquitous location information using geospatial grid region name | |
US20060279436A1 (en) | Digital elevation model data structure for geospatial analysis |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
MM4A | Annulment or lapse of patent due to non-payment of fees |