TWI423055B - Management and display simulating model by using relational database - Google Patents

Management and display simulating model by using relational database Download PDF

Info

Publication number
TWI423055B
TWI423055B TW100128580A TW100128580A TWI423055B TW I423055 B TWI423055 B TW I423055B TW 100128580 A TW100128580 A TW 100128580A TW 100128580 A TW100128580 A TW 100128580A TW I423055 B TWI423055 B TW I423055B
Authority
TW
Taiwan
Prior art keywords
database
display
model
secondary object
managing
Prior art date
Application number
TW100128580A
Other languages
Chinese (zh)
Other versions
TW201308109A (en
Inventor
S Janus Liang
Hui Chuan Wang
Original Assignee
Vimtek Virtual Reality Tech Co Ltd
Hui Chuan Wang
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 Vimtek Virtual Reality Tech Co Ltd, Hui Chuan Wang filed Critical Vimtek Virtual Reality Tech Co Ltd
Priority to TW100128580A priority Critical patent/TWI423055B/en
Publication of TW201308109A publication Critical patent/TW201308109A/en
Application granted granted Critical
Publication of TWI423055B publication Critical patent/TWI423055B/en

Links

Description

以關聯式資料庫管理及展示擬真模型之方法Method for managing and displaying immersive models with an associated database

  本發明係有關於一種以關聯式資料庫管理及展示擬真模型之方法,特別是指一種將展示模型分解成多個次物件圖形,每一次物件圖形規劃有至少一個以上之特徵項目,每一特徵項目允許有複數個不同的變數,並藉由關聯式資料庫管理及展示該次物件圖形,使其呈現一擬真模型之方法。The invention relates to a method for managing and displaying a immersive model in an associated database, in particular to decomposing a display model into a plurality of secondary object graphics, each of which has at least one feature item, each of which has a feature item, each The feature item allows for a plurality of different variables, and the method of managing and presenting the object graph by the associated database to present a pseudo-real model.

  由於繪圖軟體的進步以及電腦效能的提昇,利用電腦圖像展示產品的技術也逐漸從2D平面展示轉變為3D立體展示,以及從靜態的展示轉變為動態的展示。Due to the advancement of graphics software and the improvement of computer performance, the technology of using computer image display products has gradually changed from 2D flat display to 3D stereo display, and from static display to dynamic display.

  但是越精緻的圖像呈現通常需要佔用較多的電腦資源,且當我們要為某一產品繪出其展示模型時,由於產品通常包含有多個零組件,因此當我們欲展示相同產品某一零組件之材質、顏色、尺寸等特徵項目的不同變數時,例如我們欲展示某一產品的某零組件在顏色特徵的不同顏色(藍色、紅色、綠色等等)變數,我們需重複繪製多個相同展示模型的其餘零組件圖形,不僅耗費工時成本,成品之檔案量通常非常巨大,所需要的電腦資源也極大,也不易儲存及傳輸。But the more refined image presentation usually requires more computer resources, and when we want to draw a display model for a product, because the product usually contains multiple components, when we want to show the same product When different components of the material, color, size, etc. of the component have different variables, for example, we want to display the different color (blue, red, green, etc.) variables of a certain component of a certain product, we need to draw more The remaining component graphics of the same display model not only cost labor, the file size of the finished product is usually very large, the computer resources required are also great, and it is not easy to store and transmit.

  要再說明的是,目前為了因應資訊越來越龐大,電腦資訊的呈現有所謂關聯式資料庫的電腦資訊呈現方式,避免佔用電腦資源,以最簡單的表單資訊作說明:To be more important, at present, in order to cope with the increasing information, computer information presents a computer information presentation method called a related database, avoiding the use of computer resources, and explaining the simplest form information:

表一Table I

  在表一中,我們需要鍵入重複的供應商及供應商電話,需要耗費較多的鍵入時間,也需要較多的儲存空間。In Table 1, we need to type in duplicate supplier and supplier calls, which requires more typing time and more storage space.

  在關聯式資料庫的儲存則是以表二方式紀錄儲存:The storage in the associated database is recorded and stored in Table 2:

表二Table II

  在表二中,分別儲存唯一不重複的產品資訊,以及唯一不重複的供應商資訊,藉由給定每筆供應商資訊不同且特定的供應商代碼使二者產生關聯,如此大大節省工作時間及電腦所需資源,這便是關聯式資料庫的原理。In Table 2, store the unique product information that is not duplicated, and the only non-repeated supplier information, which saves working time by giving each supplier information different and specific supplier code to correlate the two. And the resources required by the computer, this is the principle of the associated database.

  因此本發明擬利用關聯式資料庫的資訊呈現方式,建立展示模型各次物件圖形的圖庫,配合第一資料庫等其他關聯資料庫,作為圖面展示的方法。Therefore, the present invention intends to use the information presentation mode of the associated database to establish a library for displaying the object graphics of each model, and cooperate with other related databases such as the first database as a method for displaying the surface.

  爰此,本發明提出一種以關聯式資料庫管理及展示擬真模型之方法,包括下列步驟:A.將一展示模型分解成一個以上之次物件圖形,每一次物件圖形規劃有至少一個以上之特徵項目,每一特徵項目允許有複數個不同的變數;B.使不同變數分別關聯一特定的次物件圖形,並將該特定的次物件圖形儲存於一次物件資料庫中;C.建立一第一資料庫,包括有多個欄位,使該第一資料庫之每一欄位唯一對應於上述次物件圖形之每一特徵項目,且每一欄位之不同特定值係唯一對應於上述特徵項目中之一變數;D.使該展示模型被顯示於一展示畫面中,並藉由改變該第一資料庫中任一欄位之特定值,使次物件資料庫中被對應之具有相符變數的次物件圖形取代原有次物件圖形而被顯示於該展示畫面中。Accordingly, the present invention provides a method for managing and displaying a immersive model in an associated database, comprising the following steps: A. Decomposing a display model into more than one secondary object graph, each of which has at least one or more graphical graphics. Feature items, each feature item is allowed to have a plurality of different variables; B. respectively, different variables are associated with a specific secondary object graphic, and the specific secondary object graphic is stored in a first object database; C. a database comprising a plurality of fields such that each field of the first database uniquely corresponds to each feature item of the secondary object graphic, and different specific values of each field uniquely correspond to the above features One of the variables in the project; D. causes the display model to be displayed in a display screen, and by changing the specific value of any field in the first database, the corresponding object in the secondary object database has corresponding variables The secondary object graphic is displayed in the display screen instead of the original secondary object graphic.

  上述B步驟之使不同變數分別關聯一特定的次物件圖形,係指預先繪製不同的次物件圖形,並使每一次物件圖形唯一對應於一變數。The above-mentioned step B, which causes different variables to be associated with a specific secondary object pattern, means that different secondary object graphics are drawn in advance, and each object graphic uniquely corresponds to a variable.

  上述B步驟之使不同變數分別關聯一特定的次物件圖形,係指藉由改變該變數之值,使次物件圖形之尺寸產生對應之變化。The above-mentioned step B is to associate different variables with a specific secondary object pattern, which means that the size of the secondary object pattern is changed correspondingly by changing the value of the variable.

  本發明進一步包括有一特效資料庫之關聯步驟,該特效資料庫係儲存有特效指令,其係輸出一特效指令使上述展示模型依該指令在該展示畫面中呈現一預設的特效畫面。The invention further includes an association step of the special effect database, wherein the special effect database stores the special effect instruction, which outputs an special effect instruction to cause the display model to present a preset special effect picture in the display screen according to the instruction.

  上述特效指令包括移動指令、旋轉指令、透明化指令、剖面指令、靜止指令、出現/消失指令、拆解指令及縮放指令。The above special effect instructions include a move instruction, a rotation instruction, a transparency instruction, a profile instruction, a stationary instruction, an appearance/disappearance instruction, a disassembly instruction, and a scaling instruction.

  本發明進一步包括有一背景畫面資料庫之關聯步驟,該背景畫面資料庫係供輸出一背景畫面至該展示畫面中。The invention further includes an associated step of a background image database for outputting a background image to the display.

  本發明進一步包括有一影音資料庫之關聯步驟,該影音資料庫係儲存有動畫資料、聲音資料,以供該展示模型被顯示於該展示畫面中時被同步輸出。The invention further includes an associating step of a video library, wherein the video library stores animation data and sound data for being synchronously output when the display model is displayed in the display image.

  本發明進一步包括有一物件規格資料庫之關聯步驟,該物件規格資料庫設有對應於該展示模型之特徵數據值,以供該展示模型被顯示於該展示畫面中時被同步輸出。The present invention further includes an associated step of an object specification database having feature data values corresponding to the display model for simultaneous output when the display model is displayed in the display.

  本發明進一步包括有一特效資料庫之關聯步驟、一背景畫面資料庫之關聯步驟、一影音資料庫之關聯步驟、一物件規格資料庫之關聯步驟。The invention further includes an association step of an effect database, an association step of a background image database, an association step of a video library, and an association step of an object specification database.

  上述之第一資料庫與次物件資料庫係設置於一伺服端,而該展示畫面位於一需求端,該伺服端與該需求端係透過內部網路或網際網路等網路介面相連接。The first database and the secondary object database are disposed on a server, and the display is located at a demand end, and the server and the demand terminal are connected through a network interface such as an internal network or an Internet.

  本發明包含有下列功效:The invention includes the following effects:

  1.本發明方法可以建立一視覺化的3D擬真互動平台,展示產品實體樣貌及與使用者互動呈現產品多元資訊,同時可以提昇觀看者對產品認知度,並且簡化操作程序。1. The method of the invention can establish a visual 3D immersive interactive platform, display product entity appearance and interact with the user to present product multi-information, and at the same time enhance viewers' product awareness and simplify operation procedures.

  2.利用關聯式資料庫之技術,作為展示某項產品之不同材質、顏色、尺寸等不同特徵項目的不同變數,可以大大縮小展示模型的檔案量,方便儲存及傳輸,並藉由次物件資料庫等標準元件庫之建立,可以有效儲存、管理,減少產品功能重複設定及規劃時間。2. Using the technology of the associated database as a different variable for displaying different characteristics of different materials, colors, sizes, etc. of a product, the file size of the display model can be greatly reduced, which is convenient for storage and transmission, and by the secondary object data. The establishment of a library of standard components such as libraries can be effectively stored and managed, reducing the duplication of product functions and planning time.

  3.展示模型被分解成多個次物件圖形,各次物件圖形具有「小檔案」、「以獨立物件儲存管理」、「可以匯整組合為展示模型」之特色。當多個次物件圖形匯整組合為一展示模型時,如果改變局部的展示內容,其只涉及部分之次物件圖形的改變,此一改變的總位元數不多,因此該改變結果可以快速呈現,也非常適合執行遠端展示。據此,本發明之第一資料庫與次物件資料庫可以設置於一伺服端,而一個以上之需求端則可以透過內部網路或網際網路傳輸該伺服端所提供之資訊,以便進行線上瀏覽及線上改變展示模型之操作,藉此可以降低需求端的系統規格門檻,使需求端的建置成本大幅降低。3. The display model is decomposed into multiple secondary object graphics. Each object graphic has the characteristics of “small file”, “single object storage management” and “can be combined to display model”. When a plurality of secondary object graphics are combined into a display model, if the partial display content is changed, it only involves the change of the partial secondary object graphic, and the total number of bits of the change is small, so the result of the change can be fast. Rendering, also very suitable for performing remote display. Accordingly, the first database and the secondary object database of the present invention can be set on a server, and more than one demand terminal can transmit the information provided by the server through the internal network or the Internet to perform online. By browsing and changing the operation of the display model online, the system specification threshold at the demand side can be reduced, and the construction cost of the demand side can be greatly reduced.

  4.本發明方法可以供使用者方便對客戶展示資訊,或者方便供使用者內部人員討論之用。4. The method of the present invention can be used by the user to conveniently present information to the client or conveniently for discussion by internal users.

  綜合上述技術特徵,本發明以關聯式資料庫管理及展示擬真模型之方法的主要功效可在下述實施例清楚呈現。In summary of the above technical features, the main functions of the method for managing and displaying the immersive model in the associated database of the present invention can be clearly presented in the following embodiments.

  本發明第一實施例請參閱第一圖所示,本實施例係在一單機電腦上實施,包括在該電腦安裝使用程式(A),並使該電腦儲存有一次物件資料庫(1)、一第一資料庫(2)、一特效資料庫(3)、一背景畫面資料庫(4)、一影音資料庫(5)及一物件規格資料庫(6),利用電腦執行該使用程式(A),使該使用程式(A)將前述各資料庫產生關聯,使包括次物件資料庫(1)在內的各資料庫之資訊可以呈現在一顯示單元(7),尤其次物件資料庫(1)中的次物件圖形(11)可以被整合為一擬真模型而呈現於顯示單元(7),另藉由改變該第一資料庫(2)之欄位(21)之值,使該次物件圖形(11)即時對應改變,呈現一擬真且可變之展示效果。Referring to the first embodiment of the present invention, the present embodiment is implemented on a single computer, including installing a program (A) on the computer, and storing the object object database (1), a first database (2), a special effect database (3), a background image database (4), a video library (5), and an object specification database (6), which are executed by a computer ( A), causing the use program (A) to associate the foregoing databases, so that the information of each database including the secondary object database (1) can be presented in a display unit (7), especially the secondary object database. The secondary object graphic (11) in (1) can be integrated into a immersive model and presented to the display unit (7), and by changing the value of the field (21) of the first database (2), The object graphic (11) changes instantly, and presents an imaginative and variable display effect.

  配合參閱第二圖所示,本實施例各資料庫之架構方式及使用方式之步驟包括:Referring to the second figure, the steps of the architecture and usage of each database in this embodiment include:

  A.將一展示模型分解成一個以上之次物件圖形(11),本實施例該展示模型以一鎖定組合件圖形(11)為例,該鎖定組合件圖形(11)包括一螺絲次物件圖形(111)及一六角螺帽次物件圖形(112),將前述螺絲次物件圖形(111)及六角螺帽次物件圖形(112)規劃有材質、顏色、尺寸等特徵項目,每一特徵項目並允許有複數個不同的變數,例如顏色特徵允許有紅色、藍色、綠色等各種顏色的變數。A. Decomposing a display model into more than one object graphic (11). In this embodiment, the display model is exemplified by a locking assembly graphic (11), which includes a screw object graphic. (111) and a hexagonal nut secondary object pattern (112), the screw element object pattern (111) and the hex nut secondary object pattern (112) are planned with material, color, size and other feature items, each feature item It is also allowed to have a plurality of different variables, for example, the color feature allows variables of various colors such as red, blue, and green.

  B.預先繪製前述螺絲次物件圖形(111)及六角螺帽次物件圖形(112),並根據不同的變數分別繪製相對應的螺絲次物件圖形(111)及六角螺帽次物件圖形(112),例如分別繪製紅色、藍色、綠色的螺絲次物件圖形(111)與分別繪製紅色、藍色、綠色的六角螺帽次物件圖形(112),然後將該所有的螺絲次物件圖形(111)與六角螺帽次物件圖形(112)儲存於該次物件資料庫(1)中。B. pre-rendering the aforementioned screw secondary object graphic (111) and the hex nut secondary object graphic (112), and respectively drawing corresponding screw secondary object graphics (111) and hexagonal nut secondary object graphics (112) according to different variables. For example, drawing a red, blue, and green screw secondary object graphic (111) and respectively drawing red, blue, and green hexagonal nut secondary object graphics (112), and then all the screw secondary object graphics (111) And the hex nut secondary object graphic (112) is stored in the secondary object database (1).

  C.建立該第一資料庫(2),包括有多個欄位,使該第一資料庫(2)之每一欄位(21)唯一對應於上述螺絲次物件圖形(111)及六角螺帽次物件圖形(112)之每一特徵項目,且每一欄位(21)中所輸入之不同的特定值(22)係唯一對應於特徵項目中之一變數。C. Establishing the first database (2), comprising a plurality of fields, such that each field (21) of the first database (2) uniquely corresponds to the screw object pattern (111) and the hex screw Each feature item of the cap object graphic (112), and the different specific value (22) entered in each field (21) uniquely corresponds to one of the feature items.

  D.使該鎖定組合件圖形(11)被顯示於一顯示單元(7)之展示畫面(B)中,並藉由改變該第一資料庫(2)中任一欄位(21)之特定值(22),使該次物件資料庫(1)中被對應之具有相符變數的螺絲次物件圖形(111)及六角螺帽次物件圖形(112)取代原有的螺絲次物件圖形(111)及六角螺帽次物件圖形(112)而被顯示於該展示畫面(B)中。本實施例該欄位(21)之特定值(22)選擇方式以下拉式選單選擇,例如在該六角螺帽次物件圖形(112)之顏色特徵所對應的欄位(21)中點選所欲展示的六角螺帽次物件圖形(112)之顏色所對應之特定值(22),則該鎖定組合件圖形(11)之六角螺帽次物件圖形(112)會直接呈現該特定值(22)所唯一對應的六角螺帽次物件圖形(112),如第三圖所示,但不限於此,亦可由使用者直接輸入該特定值(22)。D. causing the lock assembly graphic (11) to be displayed in a display (B) of a display unit (7) and by changing the specificity of any of the fields (21) in the first database (2) The value (22) replaces the original screw secondary object graphic (111) by the corresponding screw secondary object pattern (111) and the hex nut secondary object graphic (112) having the corresponding variables in the object database (1). And the hex nut secondary object graphic (112) is displayed on the display screen (B). In this embodiment, the specific value (22) of the field (21) is selected by the pull-down menu selection, for example, in the field (21) corresponding to the color feature of the hexagonal nut secondary object graphic (112). If the color of the hexagonal nut secondary object graphic (112) to be displayed corresponds to a specific value (22), the hexagonal nut secondary object graphic (112) of the locking assembly graphic (11) will directly present the specific value (22). The only corresponding hexagonal nut secondary object graphic (112) is shown in the third figure, but is not limited thereto, and the specific value (22) may be directly input by the user.

  在前述說明中,該第一資料庫(2)藉由欄位(21)中一特定值(22)而關聯次物件資料庫(1)中之一次物件圖形(112),而各次物件圖形(112)係預先被繪製完成而儲存於次物件資料庫(1)中。因此,使用者欲變化展示效果時,只要改變該第一資料庫(2)之欄位(21)的特定值(22),即可使鎖定組合件圖形(11)即時產生同步變化,呈現一「即選即變」的展示效果。所以,對於一相同的展示模型而言,藉由上述欄位(21)的特定值(22)之改變,將可以立即變化該展示模型之顏色、材質、尺寸等,使展示效果多變、即時且擬真。In the foregoing description, the first database (2) associates one object graphic (112) in the secondary object database (1) by a specific value (22) in the field (21), and each object graphic (112) is pre-drawn and stored in the secondary object database (1). Therefore, when the user wants to change the display effect, by changing the specific value (22) of the field (21) of the first database (2), the lock assembly graphic (11) can be synchronously changed in time to present a The effect of "immediately change". Therefore, for a same display model, by changing the specific value (22) of the above field (21), the color, material, size, etc. of the display model can be changed immediately, so that the display effect is changeable and instant. And immersive.

  在本實施例中,該使用程式(A)同時執行該背景畫面資料庫(4)之關聯步驟,藉以由該背景畫面資料庫(4)同步輸出一背景畫面(41)至該展示畫面(B)中,例如本實施例中,可藉由輸入代表使用者之圖騰或文字,而在商業用途中可具有廣告宣傳之效果;該使用程式(A)同時執行該影音資料庫(5)之關聯步驟,藉以由該影音資料庫(5)同步輸出一動畫資料(51)至該展示畫面(B)中,並同部輸出一聲音資料(52),例如該動畫資料(51)是跑馬燈式介紹使用者資料,同樣在商業上具有宣傳效果,該聲音資料(52)則可用以介紹本發明系統之操作方式;該使用程式(A)同時執行該物件規格資料庫(6)之關聯步驟,藉以由該物件規格資料庫(6)同步輸出一對應該鎖定組合件圖形(11)之特徵數據值(61)至該展示畫面(B)中,亦即該特徵數據值(61)即該鎖定組合件圖形(11)之零件規格表。In this embodiment, the usage program (A) simultaneously performs the association step of the background picture database (4), thereby synchronously outputting a background picture (41) to the display picture (B) by the background picture database (4). In the present embodiment, for example, the effect of advertising can be used in commercial use by inputting a totem or text representing the user; the usage program (A) simultaneously performs the association of the video library (5) a step of synchronously outputting an animation material (51) to the display screen (B) by the video library (5), and outputting a sound data (52) in the same part, for example, the animation material (51) is a marquee type Introducing user data, which is also commercially advertised, and the sound data (52) can be used to introduce the operation mode of the system of the present invention; the user program (A) simultaneously executes the associated steps of the object specification database (6). The feature data value (61) of the combination pattern (11) should be synchronously outputted by the object specification database (6) to the display screen (B), that is, the feature data. (61), that the locking assembly pattern (11) of the table part specifications.

  另外,請參閱第四圖所示,該使用程式(A)同時執行該特效資料庫(3)之關聯步驟,而該特效資料庫(3)係包括有特效指令,例如移動指令(31)、旋轉指令(32)、透明化指令(33)、剖面指令(34)、靜止指令(35)、出現/消失指令(36)、拆解指令(37)及縮放指令(38)等,而在該展示畫面(B)中,可藉由點選前述任一指令,使該使用程式(A)執行該特效資料庫(3)之關聯步驟,而在該展示畫面(B)中呈現一預設的特效畫面,例如本實施例中,藉由點選該拆解指令(37)使得該鎖定組合件圖形(11)之螺絲次物件圖形(111)及六角螺帽次物件圖形(112)執行拆解,呈現爆炸圖圖示之呈現。In addition, as shown in the fourth figure, the application program (A) simultaneously performs the association step of the effect database (3), and the effect database (3) includes special effects instructions, such as a mobile instruction (31), a rotation command (32), a transparency command (33), a profile command (34), a stationary command (35), an appearance/disappear command (36), a disassembly command (37), and a zoom command (38), etc. In the display screen (B), the user (A) can execute the associated step of the special effect database (3) by clicking any of the above instructions, and a preset is presented in the display screen (B). In the special effect screen, for example, in the embodiment, the screw sub-object graphic (111) and the hex nut secondary object graphic (112) of the locking assembly graphic (11) are disassembled by clicking the disassembly command (37). , presenting an illustration of an exploded map.

  再請參閱第五圖所示,在該次物件資料庫(1)中更包括一個以上之替代次物件圖形,並且該替代次物件圖形係執行與該次物件圖形相同步驟。在步驟C之第一資料庫(2)中,該欄位(21)之二個不同特定值(22)係分別對應該次物件圖形與該替代次物件圖形,例如本實施例中,該鎖定組合件圖形(11)之六角螺帽次物件圖形(112)係一次物件圖形,而四角螺帽次物件圖形(113)則為一替代次物件圖形,當欄位(21)之特定値被改變,展示畫面中之六角螺帽次物件圖形(112)將對應改變為四角螺帽次物件圖形(113)。Referring to FIG. 5 again, more than one alternative secondary object graphic is further included in the secondary object database (1), and the replacement secondary object graphic performs the same steps as the secondary object graphic. In the first database (2) of step C, two different specific values (22) of the field (21) are respectively corresponding to the secondary object graphic and the replacement secondary object graphic, for example, in the embodiment, the locking The hexagonal nut secondary object graphic (112) of the assembly graphic (11) is a primary object graphic, and the square nut secondary object graphic (113) is an alternative secondary object graphic, when the specific defect of the field (21) is changed. The hexagonal nut secondary object graphic (112) in the display screen is changed to a square nut secondary object graphic (113).

  本發明第二實施例請參閱第六圖所示,本發明使用關聯式資料庫模式管理次物件圖形(112),將大型的展示圖形(例如建築物、汽車、廠房設備等)分解成多個次物件圖形(112),因此每一次物件圖形(112)之位元數甚小,極適合網路傳輸,本發明可將前述次物件資料庫(1)、第一資料庫(2)及其餘資料庫等設置於一伺服端(C),而在一需求端(D)安裝該使用程式(A),並使該伺服端(C)與該需求端(D)透過內部網路或網際網路等網路介面(E)相連接,而在該需求端(D)呈現該展示畫面(B)。Referring to the sixth embodiment of the present invention, the present invention uses the associated database mode to manage the secondary object graphics (112), and decomposes large display graphics (such as buildings, automobiles, plant equipment, etc.) into multiple The secondary object graphic (112), so that the number of bits per object graphic (112) is very small, which is very suitable for network transmission, and the foregoing secondary object database (1), the first database (2) and the rest can be used in the present invention. The database is set at a server (C), and the application (A) is installed at a demand end (D), and the server (C) and the demand terminal (D) are transmitted through an internal network or the Internet. A network interface (E) such as a road is connected, and the display screen (B) is presented at the demand side (D).

  與傳統AUTO CAD 或SOLIDWORK的3D圖檔相較,以一完整的汽車3D圖檔為例(包括車體、懸吊、動力、傳動、制動、轉向、內裝等所有零件),該傳統的3D圖檔並非以關聯式資料庫的形態建立,因此進行3D圖檔展示時,遇需更改3D圖檔之某元件之尺寸、材質、顏色等,其必須AUTO CAD 或SOLIDWORK等軟體再重新予以繪製,所以無法快速且及時進行3D圖檔之某元件的替換或變更,這樣的限制也使得傳統的3D圖檔不適合進行遠端展示,尤其是在遠端進行即時的替換3D圖檔中之零組件的操作,使得展示效果並不理想。至於本案,大型的3D汽車被分解成包括車體、懸吊、動力、傳動、制動、轉向、內裝等多個次物件圖形(112),每一次物件圖形(112)又與一欄位的特定値相關聯,較小的次物件圖形(112)適合於網路上傳輸及遠端展示,且透過關聯式資料庫之架構,次物件圖形(112)之改變或替換將更快速且便捷,可提供一種即時擬真且富變化的展示效果。Compared with the traditional AUTO CAD or SOLIDWORK 3D image, take a complete car 3D image as an example (including car body, suspension, power, transmission, brake, steering, interior and other parts), the traditional 3D The image file is not created in the form of an associated database. Therefore, when displaying a 3D image file, the size, material, color, etc. of a component of the 3D image file need to be changed, and the software such as AUTO CAD or SOLIDWORK must be redrawn. Therefore, the replacement or change of a component of the 3D image file cannot be performed quickly and in a timely manner. Such a limitation also makes the conventional 3D image file unsuitable for remote display, especially at the remote end for instantaneous replacement of components in the 3D image file. The operation makes the display effect not ideal. As for the case, the large 3D car is decomposed into a plurality of secondary object graphics (112) including the vehicle body, suspension, power, transmission, braking, steering, interior, etc., each time the object graphic (112) is associated with a field. The specific secondary object graphics (112) are suitable for transmission on the network and remote display, and the change or replacement of the secondary object graphics (112) will be faster and more convenient through the architecture of the associated database. Provides an instant, immersive and varied display.

  請參閱附件一所示,其為本發明運用於氣缸之擬真展示之展示畫面(B)之示意圖,畫面左側為第一資料庫之欄位區域,畫面中之氣缸則包含多個次物件圖形(112),氣缸下方之「開始運轉」、「旋轉展示」、「透明化」等選項則為特效資料庫之關聯,畫面下方之「序號」、「零件名稱」、「料號」等則為物件規格資料庫之關聯。Please refer to Appendix I, which is a schematic diagram of the display screen (B) of the immersive display of the cylinder of the present invention. The left side of the screen is the field area of the first database, and the cylinder in the picture contains multiple secondary object graphics. (112), the options such as "start operation", "rotation display" and "transparency" under the cylinder are related to the special effects database. The "serial number", "part name" and "item number" at the bottom of the screen are The association of the object specification database.

  附件二為本發明運用於都市規劃之畫面,畫面中之建築物包含多個次物件圖形(112),其可以藉由改變第一資料庫(2)之欄位(21)之特定値(22),進而改變建築物之玻璃帷幕或樑柱之顏色。Annex II is a picture of the present invention applied to urban planning. The building in the picture contains a plurality of secondary object graphics (112), which can be changed by changing the specific field of the field (21) of the first database (2) (22) ), thereby changing the color of the glass curtain or beam of the building.

  附件三係本發明應用於室內裝潢擬真展示之畫面,畫面中所陳設之傢俱或裝潢由多個次物件圖形(112)組成,其可以藉由改變第一資料庫(2)之欄位(21)之特定値(22),進而改變該傢俱或裝潢之材質。Annex III is a picture of the present invention applied to the interior decoration simulation display, and the furniture or decoration arranged in the picture is composed of a plurality of secondary object graphics (112), which can be changed by changing the field of the first database (2) ( 21) The specific 値 (22), which in turn changes the material of the furniture or decoration.

  附件四至附件八係本發明應用於汽車擬真展示之畫面,該汽車圖形亦包含多個次物件圖形(112)。The fourth to eighth embodiments of the present invention are applied to a picture of an automobile immersive display, and the automobile graphic also includes a plurality of secondary object patterns (112).

  附件九係本發明應用於機械構件擬真展示之畫面,該機械構件亦包含多個次物件圖形(112)。Annex IX is a picture of the present invention applied to the immersive display of mechanical components, which also includes a plurality of secondary object graphics (112).

  綜合上述實施例之說明,當可充分瞭解本發明之操作、使用及本發明產生之功效,惟以上所述實施例僅係為本發明之較佳實施例,當不能以此限定本發明實施之範圍,即依本發明申請專利範圍及發明說明內容所作簡單的等效變化與修飾,皆屬本發明涵蓋之範圍內。In view of the foregoing description of the embodiments, the operation and the use of the present invention and the effects of the present invention are fully understood, but the above described embodiments are merely preferred embodiments of the present invention, and the invention may not be limited thereto. Included within the scope of the present invention are the scope of the present invention.

(1)‧‧‧次物件資料庫(1) ‧ ‧ times object database

(11)‧‧‧鎖定組合件圖形(11) ‧‧‧Locking assembly graphics

(111)‧‧‧螺絲次物件圖形(111)‧‧‧ Screw secondary object graphics

(112)‧‧‧六角螺帽次物件圖形(112)‧‧‧Hex Nuts Secondary Object Graphics

(113)‧‧‧四角螺帽次物件圖形(113)‧‧‧ Four-corner nut secondary object graphics

(2)‧‧‧第一資料庫(2) ‧ ‧ first database

(21)‧‧‧欄位(21)‧‧‧ fields

(22)‧‧‧特定值(22) ‧ ‧ specific values

(3)‧‧‧特效資料庫(3) ‧‧‧ special effects database

(31)‧‧‧移動指令(31)‧‧‧Mobile Instructions

(32)‧‧‧旋轉指令(32)‧‧‧Rotary Instructions

(33)‧‧‧透明化指令(33) ‧ ‧ transparent instructions

(34)‧‧‧剖面指令(34) ‧‧‧section instructions

(35)‧‧‧靜止指令(35) ‧‧‧Standing instructions

(36)‧‧‧出現/消失指令(36)‧‧‧ Appearance/disappearance order

(37)‧‧‧拆解指令(37) ‧ ‧ Dismantling Instructions

(38)‧‧‧縮放指令(38)‧‧‧Scale instructions

(4)‧‧‧背景畫面資料庫(4) ‧‧‧Background image database

(41)‧‧‧背景畫面(41)‧‧‧Background picture

(5)‧‧‧影音資料庫(5) ‧ ‧ audio and video database

(51)‧‧‧動畫資料(51)‧‧‧Animation materials

(52)‧‧‧聲音資料(52) ‧‧‧Sound data

(6)‧‧‧物件規格資料庫(6) ‧‧‧ Object Specification Database

(61)‧‧‧特徵數據值(61)‧‧‧Characteristic data values

(7)‧‧‧顯示單元(7)‧‧‧Display unit

(A)‧‧‧使用程式(A) ‧‧‧Using programs

(B)‧‧‧展示畫面(B) ‧ ‧ display screen

(C)‧‧‧伺服端(C) ‧‧‧Server

(D)‧‧‧需求端(D) ‧‧‧ demand side

(E)‧‧‧網路介面(E) ‧‧‧Internet interface

  第一圖係為本發明第一實施例之系統架構示意圖。The first figure is a schematic diagram of the system architecture of the first embodiment of the present invention.

  第二圖係為本發明第一實施例於使用時之展示畫面示意圖之其一。The second figure is one of the schematic diagrams of the display screen when the first embodiment of the present invention is used.

  第三圖係為本發明第一實施例於使用時之展示畫面示意圖之其二。The third figure is the second schematic diagram of the display screen when the first embodiment of the present invention is used.

  第四圖係為本發明第一實施例於使用時之展示畫面示意圖之其三。The fourth figure is the third of the schematic diagrams of the display screen when the first embodiment of the present invention is used.

  第五圖係為本發明第一實施例於使用時之展示畫面示意圖之其四。The fifth figure is the fourth of the schematic diagrams of the display screen when the first embodiment of the present invention is used.

  第六圖係為本發明第二實施例之系統架構示意圖。The sixth figure is a schematic diagram of the system architecture of the second embodiment of the present invention.

  附件一係本發明應用於氣缸擬真展示之畫面。Annex I is a picture of the invention applied to the simulation of the cylinder.

  附件二為本發明運用於都市規劃擬真展示之畫面。Annex II is a picture of the invention applied to the immersive display of urban planning.

  附件三係本發明應用於室內裝潢擬真展示之畫面。Annex III is a picture of the present invention applied to the interior decoration simulation display.

  附件四至附件七係本發明應用於汽車擬真展示之畫面。Annexes IV to VII are the pictures of the present invention applied to the immersive display of automobiles.

  附件八係本發明應用於機械構件擬真展示之畫面。Annex VIII is a picture of the invention applied to the simulation of mechanical components.

(1)‧‧‧次物件資料庫 (1) ‧ ‧ times object database

(2)‧‧‧第一資料庫 (2) ‧ ‧ first database

(3)‧‧‧特效資料庫 (3) ‧‧‧ special effects database

(4)‧‧‧背景畫面資料庫 (4) ‧‧‧Background image database

(5)‧‧‧影音資料庫 (5) ‧ ‧ audio and video database

(6)‧‧‧物件規格資料庫 (6) ‧‧‧ Object Specification Database

(7)‧‧‧顯示單元 (7)‧‧‧Display unit

(A)‧‧‧使用程式 (A) ‧‧‧Using programs

Claims (10)

一種以關聯式資料庫管理及展示擬真模型之方法,包括下列步驟:
  A.將一展示模型分解成一個以上之次物件圖形,每一次物件圖形規劃有至少一個以上之特徵項目,每一特徵項目允許有複數個不同的變數;
  B.使不同變數分別關聯一特定的次物件圖形,並將該特定的次物件圖形儲存於一次物件資料庫中;
  C.建立一第一資料庫,包括有多個欄位,使該第一資料庫之每一欄位唯一對應於上述次物件圖形之每一特徵項目,且每一欄位之不同特定值係唯一對應於上述特徵項目中之一變數;
  D.使該展示模型被顯示於一展示畫面中,並藉由改變該第一資料庫中任一欄位之特定值,使次物件資料庫中被對應之具有相符變數的次物件圖形取代原有次物件圖形而被顯示於該展示畫面中。
A method of managing and presenting a immersive model in an associated database, comprising the following steps:
A. Decomposing a display model into more than one object graph, each object graph plan has at least one feature item, and each feature item is allowed to have a plurality of different variables;
B. Associate different variables with a specific secondary object graphic, and store the specific secondary object graphic in a first object database;
C. Establishing a first database, comprising a plurality of fields, such that each field of the first database uniquely corresponds to each feature item of the secondary object graphic, and each specific value of each field is The only one corresponding to one of the above feature items;
D. causing the display model to be displayed in a display screen, and by changing the specific value of any field in the first database, the secondary object data in the secondary object database is replaced by the corresponding secondary object graphic having the matching variable The object graphic is displayed in the display.
如申請專利範圍第1項所述之以關聯式資料庫管理及展示擬真模型之方法,其中B步驟之使不同變數分別關聯一特定的次物件圖形,係指預先繪製不同的次物件圖形,並使每一次物件圖形唯一對應於一變數。For example, in the method of claim 1, the method for managing and displaying the immersive model by the associated database, wherein the step B is to associate different variables with a specific secondary object graphic, which means that different secondary object graphics are drawn in advance. And make each object graphic uniquely correspond to a variable. 如申請專利範圍第1項所述之以關聯式資料庫管理及展示擬真模型之方法,其中B步驟之使不同變數分別關聯一特定的次物件圖形,係指藉由改變該變數之值,使次物件圖形之尺寸產生對應之變化。For example, in the method of claim 1, the method for managing and displaying the immersive model by the associated database, wherein the step B is to associate different variables with a specific secondary object graphic, by changing the value of the variable. Corresponding changes are made to the dimensions of the secondary object graphic. 如申請專利範圍第1項所述之以關聯式資料庫管理及展示擬真模型之方法,進一步包括有一特效資料庫之關聯步驟,該特效資料庫係儲存有特效指令,其係輸出一特效指令使上述展示模型依該指令在該展示畫面中呈現一預設的特效畫面。The method for managing and displaying the immersive model in the associated database as described in claim 1 further includes an association step of the special effect database, wherein the special effect database stores a special effect instruction, which outputs a special effect instruction. The display model is caused to present a preset special effect picture in the display screen according to the instruction. 如申請專利範圍第4項所述之以關聯式資料庫管理及展示擬真模型之方法,其中該特效指令包括移動指令、旋轉指令、透明化指令、剖面指令、靜止指令、出現/消失指令、拆解指令及縮放指令。The method for managing and displaying a immersive model in an associated database, as described in claim 4, wherein the special effect instructions include a move instruction, a rotation instruction, a transparency instruction, a profile instruction, a stationary instruction, an appearance/disappearance instruction, Disassemble instructions and zoom instructions. 如申請專利範圍第1項所述之以關聯式資料庫管理及展示擬真模型之方法,進一步包括有一背景畫面資料庫之關聯步驟,該背景畫面資料庫係供輸出一背景畫面至該展示畫面中。The method for managing and displaying a immersive model in an associated database as described in claim 1 further includes a step of associating a background image database for outputting a background image to the display screen in. 如申請專利範圍第1項所述之以關聯式資料庫管理及展示擬真模型之方法,進一步包括有一影音資料庫之關聯步驟,該影音資料庫係儲存有動畫資料、聲音資料,以供該展示模型被顯示於該展示畫面中時被同步輸出。The method for managing and displaying the immersive model in the associated database as described in claim 1 further includes a step of associating a video library, wherein the video library stores animation data and sound data for the The presentation model is output synchronously when it is displayed in the display. 如申請專利範圍第1項所述之以關聯式資料庫管理及展示擬真模型之方法,其進一步包括有一物件規格資料庫之關聯步驟,該物件規格資料庫設有對應於該展示模型之特徵數據值,以供該展示模型被顯示於該展示畫面中時被同步輸出。The method for managing and displaying a immersive model in an associated database as described in claim 1 further includes an associated step of an object specification database having characteristics corresponding to the display model The data value is output synchronously when the presentation model is displayed in the presentation. 如申請專利範圍第1項所述之以關聯式資料庫管理及展示擬真模型之方法,進一步包括有一特效資料庫之關聯步驟、一背景畫面資料庫之關聯步驟、一影音資料庫之關聯步驟、一物件規格資料庫之關聯步驟。The method for managing and displaying the immersive model in the associated database as described in claim 1 further includes an association step of an effect database, an association step of a background image database, and an association step of a video library. , the associated steps of an object specification database. 如申請專利範圍第1項所述之以關聯式資料庫管理及展示擬真模型之方法,其中該第一資料庫與次物件資料庫係設置於一伺服端,而該展示畫面位於一需求端,該伺服端與該需求端係透過網路介面相連接。The method for managing and displaying a immersive model in an associated database, as described in claim 1, wherein the first database and the secondary object database are disposed on a server, and the display is located at a demand end. The server is connected to the demand terminal through a network interface.
TW100128580A 2011-08-10 2011-08-10 Management and display simulating model by using relational database TWI423055B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
TW100128580A TWI423055B (en) 2011-08-10 2011-08-10 Management and display simulating model by using relational database

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
TW100128580A TWI423055B (en) 2011-08-10 2011-08-10 Management and display simulating model by using relational database

Publications (2)

Publication Number Publication Date
TW201308109A TW201308109A (en) 2013-02-16
TWI423055B true TWI423055B (en) 2014-01-11

Family

ID=48169817

Family Applications (1)

Application Number Title Priority Date Filing Date
TW100128580A TWI423055B (en) 2011-08-10 2011-08-10 Management and display simulating model by using relational database

Country Status (1)

Country Link
TW (1) TWI423055B (en)

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6650346B1 (en) * 2000-07-20 2003-11-18 Ge Medical Technology Services, Inc. Method and apparatus for classifying equipment in asset management database
TW200636510A (en) * 2005-03-28 2006-10-16 Microsoft Corp Mapping of a file system model to a database object
US7299202B2 (en) * 2001-02-07 2007-11-20 Exalt Solutions, Inc. Intelligent multimedia e-catalog
TW200849044A (en) * 2007-06-15 2008-12-16 Tsu-Shun Lin Database files-management system, integration module and browsing interface of database files-management system, database files-management method

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6650346B1 (en) * 2000-07-20 2003-11-18 Ge Medical Technology Services, Inc. Method and apparatus for classifying equipment in asset management database
US7299202B2 (en) * 2001-02-07 2007-11-20 Exalt Solutions, Inc. Intelligent multimedia e-catalog
TW200636510A (en) * 2005-03-28 2006-10-16 Microsoft Corp Mapping of a file system model to a database object
TW200849044A (en) * 2007-06-15 2008-12-16 Tsu-Shun Lin Database files-management system, integration module and browsing interface of database files-management system, database files-management method

Also Published As

Publication number Publication date
TW201308109A (en) 2013-02-16

Similar Documents

Publication Publication Date Title
CN104318042A (en) Home design system
WO2016050082A1 (en) Platform for displaying three-dimensional image of a building and application system thereof
WO2016177288A1 (en) Method for displaying three-dimensional simulation scene image
WO2014063657A1 (en) Online experience system for 3d products
CN103413245A (en) Furniture choosing method based on database
CN108984832B (en) Method and system for loading BIM model by utilizing Unity3D in intelligent building operation and maintenance
CN103761760A (en) Method for manufacturing multi-view indoor design effect picture
JP2017525031A (en) Method and system for converting an existing three-dimensional model into graphic data
CN104504085A (en) Method and device for displaying statistical data
Li et al. Advanced aggregate computation for large data visualization
CN107315842A (en) A kind of unstructured data collection method for visualizing based on clustering
EP1922700B1 (en) 2d/3d combined rendering
WO2023159595A1 (en) Method and device for constructing and configuring three-dimensional space scene model, and computer program product
Sinenko et al. Automation of visualization process for organizational and technological design solutions
Wang et al. Interactive visualization of complex dynamic virtual environments for industrial assemblies
TWI423055B (en) Management and display simulating model by using relational database
Jin et al. Interior soft decoration product design based on 3d modeling and image processing technology
CN107704483A (en) A kind of loading method of threedimensional model
CN102789379B (en) Build the method and apparatus of user interface
TWM419193U (en) Interactive demonstration system of virtual model
Yang et al. A human-centered virtual factory
CA3150688A1 (en) Performant configuration user interface
Lin et al. Integrate BIM and virtual reality to assist construction visual marketing
Boton et al. A metamodel to describe nD CAD visualization as coordinated multiple views
TWM461855U (en) Interactive display system using touch interface to perform immersive digital model

Legal Events

Date Code Title Description
MM4A Annulment or lapse of patent due to non-payment of fees