TWM630236U

TWM630236U - Database system with editable data correlation

Info

Publication number: TWM630236U
Application number: TW111202534U
Authority: TW
Inventors: 彭耀志; 林庠邑; 詹婉莉
Original assignee: 時光科技有限公司
Priority date: 2022-03-15
Filing date: 2022-03-15
Publication date: 2022-08-01

Abstract

一可編輯資料關聯的資料庫系統，包括一記憶模組和一處理模組；該處理模組分別掃描該記憶模組存有一第一資料和一第二資料的內容以建立對應該第一資料的至少一第一資料節點和對應該第二資料的至少一第二資料節點；當該處理模組判斷該至少一第一資料節點和該至少一第二資料節點相同時，該處理模組建立該第一資料和該第二資料之間的關聯性，並對應產生一關聯性資料，且將該關聯性資料存於該記憶模組中；當使用本新型檢索該第一資料時，該處理模組將根據該關聯性資料更快速的一併檢索到具有關連性的該第二資料。A database system capable of editing data association, including a memory module and a processing module; the processing module scans the content of a first data and a second data stored in the memory module respectively to create a corresponding first data at least one first data node and at least one second data node corresponding to the second data; when the processing module determines that the at least one first data node and the at least one second data node are the same, the processing module establishes The correlation between the first data and the second data corresponds to generating a correlation data, and the correlation data is stored in the memory module; when the first data is retrieved using the present invention, the processing The module will retrieve the related second data together more quickly according to the related data.

Description

可編輯資料關聯的資料庫系統Database system with editable data associations

一種資料庫系統，尤指一種可編輯資料關聯的資料庫系統。 A database system, especially a database system that can edit data associations.

隨著社會朝著數位化的方向革新，社會上需要越來越多的資料庫協助儲存各式各樣的資料。目前現有資料庫的架構可大致分為一關聯式資料庫(Relational Database)使用一結構化查詢語言(Structured Query Language；SQL)來管理及查詢資料和一非關聯式資料庫(NoSQL Database)使用一非結構化查詢語言(NoSQL；Non-SQL；Not only SQL)來查詢資料。 As society is innovating in the direction of digitization, the society needs more and more databases to help store various kinds of data. The current database architecture can be roughly divided into a relational database (Relational Database) using a Structured Query Language (SQL) to manage and query data and a non-relational database (NoSQL Database) using a Unstructured query language (NoSQL; Non-SQL; Not only SQL) to query data.

然而，現有的該關聯式資料庫和該非關聯式資料庫各自存在著資料庫結構上的限制。舉例來說，該非關聯式資料庫不適合用於存取關聯性強的資料，因為其檢索資料時需花費大量的時間檢索整個資料庫的每一筆資料已歸納具有關聯性的檢索結果。而傳統的該關聯式資料庫，雖說可以簡單以較小的檢索運算花費檢索具有關聯性的結果，卻需要以非常制式化的方式存取資料，即在存取資料時必須清楚定義各資料的節點，並且各存取資料之間無法互相建立關聯性。 However, the existing relational database and the non-relational database each have limitations on the database structure. For example, the non-relational database is not suitable for accessing data with strong correlation, because it takes a lot of time to retrieve the data in the entire database, and the relevant retrieval results have been summarized for each data. In the traditional relational database, although it is possible to retrieve the related results with a small retrieval operation cost, it needs to access the data in a very standardized way, that is, when accessing the data, the data must be clearly defined. Nodes, and each access data cannot be correlated with each other.

請參閱圖5所示，如果以抽象一點的方式形容傳統的該關聯式資料庫，則可以用一樹狀圖代表傳統的資料存取系統。一表格主索引鍵值100A分別建立了一第一表格210A、一第二表格220A和一第三表格230A的連接關係，即該表格主索引鍵值100A連結了各該第一表格210A、該第二表格220A和該第三表格230A的節點。然而，傳統的該關聯式資料庫無法知曉該第一表格210A、該第二表格220A和該第三表格230A之間是否存在著關聯性，因此使用者在檢索資料關聯時，該關聯式資料庫只能多次的從該表格主索引鍵值100A出發尋找資料，而無法更快速、更有效率地找出具有關聯性的資料。 Referring to FIG. 5 , if the traditional relational database is described in an abstract way, a tree diagram can be used to represent the traditional data access system. A table primary index key value 100A establishes a connection relationship of a first table 210A, a second table 220A and a third table 230A respectively, that is, the table primary index key value 100A links each of the first table 210A, the first table 210A, the third table 230A Nodes of the second table 220A and the third table 230A. However, the traditional relational database cannot know whether there is a relation between the first table 210A, the second table 220A and the third table 230A, so use When retrieving data associations, the relational database can only search for data from the primary index key value 100A of the table many times, but cannot find relevant data more quickly and efficiently.

有鑑於上述的問題，本新型提供一可編輯資料關聯的資料庫系統，能夠跳脫現有資料庫的架構，重新打造一種新的資料庫系統，使具有關聯性的資料能更快速、更有效率地受到檢索。 In view of the above problems, the present invention provides a database system with editable data association, which can break away from the structure of the existing database and recreate a new database system, so that the related data can be faster and more efficient. be searched.

該可編輯資料關聯的資料庫系統包括一記憶模組和一處理模組，且該處理模組電連接該記憶模組。 The database system associated with editable data includes a memory module and a processing module, and the processing module is electrically connected to the memory module.

該記憶模組存有一第一資料和一第二資料。該處理模組分別掃描該第一資料和該第二資料的內容以建立對應該第一資料的至少一第一資料節點和對應該第二資料的至少一第二資料節點。該處理模組判斷該至少一第一資料節點是否和該至少一第二資料節點相同。若相同，則該處理模組建立該第一資料和該第二資料之間的關聯性，並對應產生一關聯性資料，且將該關聯性資料存於該記憶模組中。 The memory module stores a first data and a second data. The processing module scans the contents of the first data and the second data respectively to establish at least one first data node corresponding to the first data and at least one second data node corresponding to the second data. The processing module determines whether the at least one first data node is the same as the at least one second data node. If they are the same, the processing module establishes the correlation between the first data and the second data, and generates a correlation data correspondingly, and stores the correlation data in the memory module.

如此一來，當本新型之該處理模組在檢索該第一資料時，該處理模組即可根據該記憶模組存有的該關聯性資料確認該第二資料和該第一資料之間存在關聯性，而快速且有效率的一併檢索到該第二資料。本新型之該可編輯資料關聯的資料庫系統，能比現有的一非關聯式資料庫更有效率的檢索具有關聯性的資料，且能比現有的一關聯式資料庫更靈活且快速的檢索一資料和另一資料之間具有關聯性的所有資料。 In this way, when the processing module of the present invention is retrieving the first data, the processing module can confirm the relationship between the second data and the first data according to the correlation data stored in the memory module. Relevance exists, and the second data is retrieved together quickly and efficiently. The database system with editable data association of the present invention can retrieve relevant data more efficiently than an existing non-relational database, and can retrieve more flexibly and quickly than an existing relational database All data that have a relationship between one data and another.

10:記憶模組 10: Memory module

20:處理模組 20: Processing modules

21:節點建立單元 21: Node establishment unit

22:連結建立單元 22: Link Establishment Unit

23:資料檢索單元 23: Data Retrieval Unit

24:圖形化單元 24: Graphical Unit

30:介面模組 30: Interface module

80:檢索資訊 80: Retrieve information

90:關聯性資料 90: Relevance data

100:第一資料 100: First information

110:第一主索引鍵值 110: The first primary index key value

120:第一資料地址資訊 120: First data address information

200:第二資料 200: Second profile

210:第二主索引鍵值 210: The second primary index key value

220:第二資料地址資訊 220:Second data address information

230:電子產品資訊 230: Electronic Product Information

300:第三資料 300: Third information

310:第三主索引鍵值 310: The third primary index key value

320:第三資料地址資訊 320: Third data address information

330:家電產品資訊 330: Home Appliance Product Information

100A:表格主索引鍵值 100A: table primary index key value

210A:第一表格 210A: First Form

220A:第二表格 220A: Second Form

230A:第三表格 230A: Third Form

圖1為本新型一可編輯資料關聯的資料庫系統的裝置方塊圖。 FIG. 1 is a block diagram of an apparatus of a new type of database system with editable data association.

圖2為本新型一可編輯資料關聯的資料庫系統的裝置方塊圖。 FIG. 2 is a block diagram of an apparatus of a new database system capable of editing data association.

圖3為本新型該可編輯資料關聯的資料庫系統的資料系統圖。 FIG. 3 is a data system diagram of the new database system associated with the editable data.

圖4為本新型該可編輯資料關聯的資料庫系統的檢索資料系統圖。 FIG. 4 is a diagram of a retrieval data system of the new database system associated with the editable data.

圖5為傳統關聯式資料庫的資料庫系統示意圖。 FIG. 5 is a schematic diagram of a database system of a traditional relational database.

請參閱圖1所示，本新型為一可編輯資料關聯的資料庫系統。該可編輯資料關聯的資料庫系統包括一記憶模組10和一處理模組20，且該處理模組20電連接該記憶模組10。 Please refer to FIG. 1 , the present invention is a database system capable of editing data association. The database system associated with editable data includes a memory module 10 and a processing module 20 , and the processing module 20 is electrically connected to the memory module 10 .

該記憶模組10存有一第一資料和一第二資料。該處理模組20分別掃描該第一資料和該第二資料的內容以建立對應該第一資料的至少一第一資料節點和對應該第二資料的至少一第二資料節點。該處理模組20判斷該至少一第一資料節點是否和該至少一第二資料節點相同。若相同，則該處理模組20建立該第一資料和該第二資料之間的關聯性，並對應產生一關聯性資料，且將該關聯性資料存於該記憶模組10中。 The memory module 10 stores a first data and a second data. The processing module 20 scans the contents of the first data and the second data respectively to establish at least one first data node corresponding to the first data and at least one second data node corresponding to the second data. The processing module 20 determines whether the at least one first data node is the same as the at least one second data node. If they are the same, the processing module 20 establishes the correlation between the first data and the second data, generates a correlation data correspondingly, and stores the correlation data in the memory module 10 .

如此一來，當本新型之該處理模組20在檢索該第一資料時，該處理模組20即可根據該記憶模組10存有的該關聯性資料確認該第二資料和該第一資料之間存在關聯性，而進一步快速且有效率的一併檢索到該第二資料。本新型之該可編輯資料關聯的資料庫系統，能比現有的一非關聯式資料庫更有效率的檢索具有關聯性的資料，且能比現有的一關聯式資料庫更靈活且快速的檢索一資料和另一資料之間具有關聯性的所有資料。 In this way, when the processing module 20 of the present invention is retrieving the first data, the processing module 20 can confirm the second data and the first data according to the correlation data stored in the memory module 10 . There is a correlation between the data, and the second data can be retrieved together quickly and efficiently. The database system with editable data association of the present invention can retrieve relevant data more efficiently than an existing non-relational database, and can retrieve more flexibly and quickly than an existing relational database All data that have a relationship between one data and another.

詳細來說，若該記憶模組10中存有了複數個第一資料節點和複數個第二資料節點時，該處理模組20依序判斷每一個第一資料節點是否和該複數個第二資料節點中的任一個相同。若有任一個第一資料節點與任一個第二資料節點相同時，則在相同的第一資料節點與第二資料節點之間建立連接，以產生該關聯性資料。這是一個第一資料節點對應一個第二資料節點的連結關係。 Specifically, if the memory module 10 stores a plurality of first data nodes and a plurality of second data nodes, the processing module 20 determines whether each first data node and the plurality of second data nodes are in sequence. Either of the data nodes is the same. If any first data node is the same as any second data node, a connection is established between the same first data node and the second data node to generate the associated data. This is a connection relationship between a first data node and a second data node.

進一步而言，假設其中一個第一資料節點同時與複數個第二資料節點相同時，該處理模組20即在相同的該第一資料節點與該些第二資料節點之間建立連結以產生該關聯性資料。這是一個第一資料節點對應多個第二資料節點的連結關係。 Further, if one of the first data nodes is the same as a plurality of second data nodes at the same time, the processing module 20 establishes a link between the same first data node and the second data nodes to generate the Relevant data. This is a connection relationship between a first data node and a plurality of second data nodes.

假設複數個第一資料節點同時與一個第二資料節點相同時，該處理模組20即在該些第一資料節點與相同的該第二資料節點之間建立連結以產生該關聯性資料。這是多個第一資料節點對應一個第二資料節點的連結關係。 Assuming that a plurality of first data nodes are identical to a second data node at the same time, the processing module 20 establishes links between the first data nodes and the same second data node to generate the associated data. This is a connection relationship between a plurality of first data nodes corresponding to one second data node.

假設複數個第一資料節點同時與複數個第二資料節點相同時，該處理模組20即在該些第一資料節點與相同的該些第二資料節點之間建立連結以產生該關聯性資料。這是多個第一資料節點對應多個第二資料節點的連結關係。 Assuming that a plurality of first data nodes are identical to a plurality of second data nodes at the same time, the processing module 20 establishes links between the first data nodes and the same second data nodes to generate the association data . This is a connection relationship between a plurality of first data nodes corresponding to a plurality of second data nodes.

由上可知，本新型不會對該至少一第一資料節點和該至少一第二資料節點做任何資料節點數量上的限制。當本新型之該處理模組20判斷該至少一第一資料節點和該至少一第二資料節點相同時，可以建立一對一、一對多、多對一、或是多對多的節點連結關係。 As can be seen from the above, the present invention does not impose any limitation on the number of data nodes for the at least one first data node and the at least one second data node. When the processing module 20 of the present invention determines that the at least one first data node and the at least one second data node are the same, a one-to-one, one-to-many, many-to-one, or many-to-many node connection can be established relation.

請參閱圖2所示，在本新型的一實施例中，該可編輯資料關聯的資料庫系統進一步包括一介面模組30，而該介面模組30電連接該處理模組20。另外，該處理模組20進一步包括一節點建立單元21、一連結建立單元22、一資料檢索單元23和一圖形化單元24。 Referring to FIG. 2 , in an embodiment of the present invention, the database system associated with editable data further includes an interface module 30 , and the interface module 30 is electrically connected to the processing module 20 . In addition, the processing module 20 further includes a node establishment unit 21 , a link establishment unit 22 , a data retrieval unit 23 and a graphics unit 24 .

該介面模組30負責顯示一管理介面，用於管理該記憶模組20存有的資料。使用本新型的一使用者可透過該介面模組30將該第一資料和該第二資料存入該記憶模組10中。換句話說，本新型之該介面模組30將產生該第一資料和該第二資料，而該處理模組20將透過該介面模組30接收該第一資料和該第二資料，且將該第一資料和該第二資料存入該記憶模組10中。如此，該處理模組20才開始分別掃描該第一資料和該第二資料的內容以建立對應該第一資料的該至少一第一資料節點和該第二資料的該至少一第二資料節點。 The interface module 30 is responsible for displaying a management interface for managing the data stored in the memory module 20 . A user using the present invention can store the first data and the second data in the memory module 10 through the interface module 30 . In other words, the interface module 30 of the present invention will generate the first data and the second data, and the processing module 20 will receive the first data and the second data through the interface module 30, and will The first data and the second data are stored in the memory module 10 . In this way, the processing module 20 can Starting to scan the contents of the first data and the second data respectively to establish the at least one first data node corresponding to the first data and the at least one second data node of the second data.

當該介面模組30產生一修改訊號時，該處理模組20即修改該記憶模組10中的該關聯性資料，以對應修改該第一資料和該第二資料之間的關聯性，並更新該記憶模組10中存有的該關聯性資料。詳細來說，該處理模組20根據該修改訊號可以維持兩節點的連接關係，或是新增目前未存在的兩節點的連接關係，或是刪除目前存在兩節點的連接關係。更進一步來說，當修改後的該至少一第一資料節點仍和修改後的該至少一第二資料節點相同時，該處理模組20即維持此兩個相同的節點的連接關係。當修改後的該至少一第一資料節點和修改後的該至少一第二資料節點相同時，該處理模組20即新增此兩個相同的節點的連接關係。當修改後的該至少一第一資料節點和修改後的該至少一第二資料節點不再相同時，該處理模組20即刪除這兩不同的節點之間的連接關係。 When the interface module 30 generates a modification signal, the processing module 20 modifies the correlation data in the memory module 10 to correspondingly modify the correlation between the first data and the second data, and The correlation data stored in the memory module 10 is updated. Specifically, the processing module 20 can maintain the connection relationship between the two nodes according to the modification signal, or add a connection relationship between the two nodes that does not currently exist, or delete the connection relationship between the two nodes currently existing. Furthermore, when the modified at least one first data node is still the same as the modified at least one second data node, the processing module 20 maintains the connection relationship between the two identical nodes. When the modified at least one first data node is the same as the modified at least one second data node, the processing module 20 adds a connection relationship between the two identical nodes. When the modified at least one first data node and the modified at least one second data node are no longer the same, the processing module 20 deletes the connection relationship between the two different nodes.

上述進一步說明了，利用本新型存取資料時，可以無需如傳統關聯式資料庫一般預先定義所有資料的關聯性，而可以先存取之後再事後進一步定義和修改不同資料之間的關聯性，即先存取之後再事後進一步定義和修改兩節點之間的連接關係。如此，本新型並非利用現有之關聯式資料庫和非關聯式資料庫做應用，而是重新開發一種處於關聯和非關聯兩種極端中間的一種資料庫，既能有效率的檢索不同資料之間的關聯性，又能保有檢索和修改資料節點的靈活性。 The above further illustrates that, when using the new type of data access, it is not necessary to pre-define the correlation of all data as in the traditional relational database, and the correlation between different data can be further defined and modified after being accessed first. That is, the connection relationship between the two nodes is further defined and modified afterwards. In this way, the present invention does not use the existing relational database and non-relational database for application, but re-develops a kind of database which is in the middle of the two extremes of relational and non-relatedness, which can efficiently search between different data. It also retains the flexibility of retrieving and modifying data nodes.

在本實施例中，該可編輯資料關聯的資料庫系統為一電腦內部之資料庫系統，即該處理模組20為該電腦之處理器，該記憶模組10為該電腦之記憶體，而該介面模組30包括該電腦之顯示器、鍵盤和滑鼠。該介面模組30的顯示器負責顯示該管理介面，而該介面模組30的鍵盤和滑鼠負責產生該修改訊號。 In this embodiment, the database system associated with the editable data is a database system inside a computer, that is, the processing module 20 is the processor of the computer, the memory module 10 is the memory of the computer, and The interface module 30 includes a monitor, a keyboard and a mouse of the computer. The display of the interface module 30 is responsible for displaying the management interface, and the keyboard and mouse of the interface module 30 are responsible for generating the modification signal.

在另一實施例中，該可編輯資料關聯的資料庫系統為一平板電腦或一智慧型手機內部之資料庫系統，即該處理模組20為該平板電腦或該智慧型手機之處理器，該記憶模組10為該平板電腦或該智慧型手機之記憶體，而該介面模組30為該平板電腦或該智慧型手機之觸控螢幕。該介面模組30的觸控螢幕負責顯示該管理介面和接受該使用者的觸控而產生該修改訊號。 In another embodiment, the database system associated with the editable data is a database system inside a tablet computer or a smart phone, that is, the processing module 20 is a processor of the tablet computer or the smart phone, The memory module 10 is the memory of the tablet computer or the smart phone, and the interface module 30 is the touch screen of the tablet computer or the smart phone. The touch screen of the interface module 30 is responsible for displaying the management interface and receiving the touch of the user to generate the modification signal.

另外，該節點建立單元21分別掃描該第一資料和該第二資料的內容以建立對應該第一資料的該至少一第一資料節點和對應該第二資料的該至少一第二資料節點。該連結建立單元22判斷該至少一第一資料節點是否和該至少一第二資料節點相同。當該連結建立單元22判斷該至少一第一資料節點和該至少一第二資料節點相同時，該連結建立單元22建立該第一資料和該第二資料之間的關聯性，對應產生該關聯性資料，且將該關聯性資料存於該記憶模組10中。 In addition, the node establishing unit 21 scans the content of the first data and the second data respectively to establish the at least one first data node corresponding to the first data and the at least one second data node corresponding to the second data. The connection establishment unit 22 determines whether the at least one first data node is the same as the at least one second data node. When the connection establishment unit 22 determines that the at least one first data node and the at least one second data node are the same, the connection establishment unit 22 establishes an association between the first data and the second data, and generates the association correspondingly and store the related data in the memory module 10 .

進一步，該至少一第一資料節點和該至少一第二資料節點各分別包括該第一資料和該第二資料中的至少一代碼。並且，該至少一第一資料節點和該至少一第二資料節點也各分別包括該第一資料和該第二資料中自然語言(Natural Language)的至少一文字。 Further, each of the at least one first data node and the at least one second data node includes at least one code in the first data and the second data, respectively. Moreover, the at least one first data node and the at least one second data node also respectively include at least one character in natural language in the first data and the second data.

該節點建立單元22通過一自然語言處理(Natural Language Processing；NLP)理解該第一資料和該第二資料中的該至少一文字以對應建立該至少一第一資料節點和該至少一第二資料節點。 The node establishing unit 22 understands the at least one character in the first data and the second data through a natural language processing (NLP) to correspondingly establish the at least one first data node and the at least one second data node .

詳細來說，該第一資料和該第二資料各為一表格，且各該表格包括一主索引鍵值和一資料地址資訊。在本實施例中，該資料地址資訊為該表格中的一欄位資訊。該至少一第一資料節點包括該第一資料中的該主索引鍵值和該資料地址資訊，而該至少一第二資料節點包括該第二資料中的該主索引鍵值和該資料地址資訊。 Specifically, the first data and the second data are each a table, and each of the tables includes a primary index key value and a data address information. In this embodiment, the data address information is a column of information in the table. The at least one first data node includes the primary index key value and the data address information in the first data, and the at least one second data node includes the primary index key value and the data address information in the second data .

請參閱圖3所示，在本實施例中，該第一資料100包括了一第一主索引鍵值110和一第一資料地址資訊120，而該第二資料200包括了一第二主索引鍵值210、一第二資料地址資訊220和一電子產品資訊230。其中，該第一主索引鍵值110和該第一資料地址資訊120為該第一資料100的該至少一第一資料節點，而該第二主索引鍵值210、該第二資料地址資訊220和該電子產品資訊230為該第二資料200的該至少一第二資料節點。 Please refer to FIG. 3, in this embodiment, the first data 100 includes a first primary index key 110 and a first data address information 120, and the second data 200 includes a second primary index The key value 210 , a second data address information 220 and an electronic product information 230 . The first primary index key 110 and the first data address information 120 are the at least one first data node of the first data 100, and the second primary index key 210 and the second data address information 220 and the electronic product information 230 is the at least one second data node of the second data 200 .

該第一主索引鍵值110、該第二主索引鍵值210和該電子產品資訊230為該節點建立單元22根據通過該自然語言處理(NLP)所理解之文字資訊所建立的資料節點。而該第一資料地址資訊120和該第二資料地址資訊220分別為該第一資料100和該第二資料200中的代碼。 The first primary index key 110 , the second primary index key 210 and the electronic product information 230 are data nodes established by the node establishment unit 22 according to the text information understood by the natural language processing (NLP). The first data address information 120 and the second data address information 220 are codes in the first data 100 and the second data 200 respectively.

詳細來說，該第一主索引鍵值110的文字資訊和該第二主索引鍵值210的文字資訊相符，舉例來說都為A公司資料，故該連結建立單元22建立該第一資料和該第二資料之間的關聯性，即該第一主索引鍵值110和該第二主索引鍵值210這兩節點的連結關係。 Specifically, the text information of the first primary index key 110 is consistent with the text information of the second primary index key 210 , for example, both are company A data, so the link creation unit 22 creates the first data and the The correlation between the second data, that is, the connection relationship between the two nodes of the first primary index key value 110 and the second primary index key value 210 .

如圖3所示，該記憶模組10進一步存有該第三資料，且該第三資料包括一第三主索引鍵值310、一第三資料地址資訊320和一家電產品資訊330。 As shown in FIG. 3 , the memory module 10 further stores the third data, and the third data includes a third primary index key 310 , a third data address information 320 and home appliance product information 330 .

同理，該節點建立單元22掃描該第三資料300的內容以建立對應該第三資料300的至少一第三資料節點。該第三主索引鍵值310、該第三資料地址資訊320和該家電產品資訊330即為該第三資料300的該至少一第三資料節點。 Similarly, the node establishing unit 22 scans the content of the third data 300 to establish at least one third data node corresponding to the third data 300 . The third primary index key value 310 , the third data address information 320 and the home appliance product information 330 are the at least one third data node of the third data 300 .

該連結建立單元22進一步判斷該至少一第三資料節點是否和該至少一第一資料節點或是該至少一第二資料節點相同。然而，如圖3所示的結果，該連結建立單元22判斷該至少一第三資料節點未和該至少一第一資料節點或是該至少一第二資料節點相同，而未建立該第三資料300之於該第一資料100或該第二資料200之間的關聯性。 The connection establishment unit 22 further determines whether the at least one third data node is the same as the at least one first data node or the at least one second data node. However, as shown in FIG. 3 , the link establishment unit 22 determines that the at least one third data node is not the same as the at least one first data node or the at least one second data node, and does not establish the third data 300 is the correlation between the first data 100 or the second data 200 .

請參閱圖4所示，在本實施例中，當該介面模組30產生該修改訊號時，該處理模組20將根據該修改訊號增加該第三資料300和該第二資料200之間的關聯性，並對應更新該記憶模組10中存有的該關聯性資料90以記錄該第三資料300和該第二資料200之間所增加的關聯性。 Please refer to FIG. 4 , in this embodiment, when the interface module 30 generates the modification signal, the processing module 20 will increase the distance between the third data 300 and the second data 200 according to the modification signal correlation, and correspondingly update the correlation data 90 stored in the memory module 10 to record the increased correlation between the third data 300 and the second data 200 .

如圖4所示，該電子產品資訊230雖然在文字上未等於該家電產品資訊330，但是應該同屬於電子產品，故應該需建立關聯性。經由該使用者通過該介面模組30呈現的該管理介面發現此一事件後，該使用者通過該介面模組30產生該修改訊號，使該處理模組20根據該修改訊號增加該電子產品資訊230和該家電產品資訊330這兩節點之間的連接關係。 As shown in FIG. 4 , although the electronic product information 230 is not equal to the home appliance product information 330 in text, it should belong to the electronic product, so it should be related. After the user discovers this event through the management interface presented by the interface module 30, the user generates the modification signal through the interface module 30, so that the processing module 20 adds the electronic product information according to the modification signal 230 and the connection relationship between the two nodes of the home appliance product information 330 .

進一步，該資料檢索單元23用於檢索該記憶模組10中存有的資料以產生一檢索結果。當該介面模組30產生一檢索資訊80時，該資料檢索單元23接收該介面模組30的該檢索資訊80，並從該至少一第一資料節點開始判斷該檢索資訊80是否和該記憶模組10中存有的任一個資料節點相同。換句話說，該資料檢索單元23判斷該檢索資訊80是否和該記憶模組10中存有的該至少一第一資料節點相同。 Further, the data retrieval unit 23 is used for retrieving the data stored in the memory module 10 to generate a retrieval result. When the interface module 30 generates a retrieval information 80, the data retrieval unit 23 receives the retrieval information 80 of the interface module 30, and starts from the at least one first data node to determine whether the retrieval information 80 matches the memory module Any data node that exists in group 10 is the same. In other words, the data retrieval unit 23 determines whether the retrieval information 80 is the same as the at least one first data node stored in the memory module 10 .

當該資料檢索單元23判斷該檢索資訊80和該記憶模組10中存有的該至少一第一資料節點不相同時，該資料檢索單元23進一步判斷該檢索資訊80是否和該記憶模組10中存有的該至少一第二資料節點相同，以此類推。 When the data retrieval unit 23 determines that the retrieval information 80 is different from the at least one first data node stored in the memory module 10 , the data retrieval unit 23 further determines whether the retrieval information 80 is the same as the memory module 10 The at least one second data node stored in the same is the same, and so on.

當該資料檢索單元23判斷該檢索資訊80和該至少一第一資料節點相同時，該資料檢索單元23進一步根據該關聯性資料90判斷和該檢索資訊80相同的該至少一第一資料節點是否進一步和該至少一第二資料節點相同。 When the data retrieval unit 23 determines that the retrieval information 80 is the same as the at least one first data node, the data retrieval unit 23 further determines whether the at least one first data node identical to the retrieval information 80 is based on the correlation data 90 . Further the same as the at least one second data node.

當該資料檢索單元23判斷和該檢索資訊80相同的該至少一第一資料節點進一步和該至少一第二資料節點相同時，即判斷和該檢索資訊80相同的該至少一第一資料節點進一步關聯該至少一第二資料節點，而該資料檢索單元23透過該介面模組30呈現該檢索結果為該第一資料100和該第二資料200。 When the data retrieval unit 23 determines that the at least one first data node that is identical to the retrieval information 80 is further identical to the at least one second data node, that is, it determines that it is identical to the retrieval information 80 The at least one first data node is further associated with the at least one second data node, and the data retrieval unit 23 presents the retrieval result as the first data 100 and the second data 200 through the interface module 30 .

當該資料檢索單元23判斷和該檢索資訊80相同的該至少一第一資料節點和該至少一第二資料節點不相同時，即判斷和該檢索資訊80相同的該至少一第一資料節點未進一步關聯該至少一第二資料節點，該資料檢索單元23透過該介面模組30僅呈現該檢索結果為該第一資料100。 When the data retrieval unit 23 determines that the at least one first data node that is the same as the retrieval information 80 is not the same as the at least one second data node, that is, it determines that the at least one first data node that is the same as the retrieval information 80 is not the same. Further associated with the at least one second data node, the data retrieval unit 23 only presents the retrieval result as the first data 100 through the interface module 30 .

以圖4中的例子來說，該資料檢索單元23會根據該檢索資訊80找尋該關聯性資料90中所形容該第一資料100和該第二資料200之間的關聯性。當該資料檢索單元23檢索A公司資料時，該檢索結果即顯示該第一資料100和該第二資料200都符合該檢索資訊80。當該資料檢索單元23檢索該電子產品資訊230時，該檢索結果即顯示該第二資料200和該第三資料300都符合該檢索資訊80。 Taking the example in FIG. 4 as an example, the data retrieval unit 23 searches for the correlation between the first data 100 and the second data 200 described in the correlation data 90 according to the retrieval information 80 . When the data retrieval unit 23 retrieves company A's data, the retrieval result shows that both the first data 100 and the second data 200 match the search information 80 . When the data retrieval unit 23 retrieves the electronic product information 230 , the retrieval result shows that both the second data 200 and the third data 300 match the retrieval information 80 .

進一步來說，本新型可以根據不同種表格作出兩不同種表格間雙向的檢索移動。舉例來說，該第二資料200的該第二主索引鍵值210和該第三資料300的該第三主索引鍵值310不同，例如該第二主索引鍵值210為A公司資料，而該第三主索引鍵值310為B商家銷售資料。換句話說，該第二資料200和該第三資料300為兩種不同的表格。然而，當本新型檢索該電子產品資訊230時可以檢索的到該家電產品資訊330，並且雙向的，當本新型檢索該家電產品資訊330時也可以檢索的到該電子產品資訊230。如此展現本新型可做兩不同種表格間雙向檢索移動的靈活性，並顯示本新型之實用性。 Further, the present invention can perform two-way search movement between two different forms according to different forms. For example, the second primary index key value 210 of the second data 200 is different from the third primary index key value 310 of the third data 300. For example, the second primary index key value 210 is company A's data, and The third primary index key value 310 is the sales data of merchant B. In other words, the second data 200 and the third data 300 are two different tables. However, when the present invention retrieves the electronic product information 230, the home appliance product information 330 can be retrieved, and bidirectionally, when the present invention retrieves the home appliance product information 330, the electronic product information 230 can also be retrieved. In this way, the flexibility of the present invention to perform two-way search and movement between two different forms is demonstrated, and the utility of the present invention is shown.

另外，該圖形化單元24負責產生一資料系統圖以圖形化該記憶模組10中存有的資料，並且透過該介面模組30呈現該資料系統圖。圖3為本實施例中該資料系統圖的示意圖。 In addition, the graphic unit 24 is responsible for generating a data system diagram to graph the data stored in the memory module 10 , and presenting the data system diagram through the interface module 30 . FIG. 3 is a schematic diagram of the data system diagram in this embodiment.

並且，該圖形化單元24也根據該資料檢索單元23所產生的該檢索結果產生一檢索資料系統圖，並且透過該介面模組30呈現該檢索資料系統圖，以示意該檢索資訊80對應該檢索結果的情形。圖4為本實施例中檢索資料系統圖的示意圖。 In addition, the graphic unit 24 also generates a retrieval data system diagram according to the retrieval result generated by the data retrieval unit 23, and presents the retrieval data system diagram through the interface module 30, so as to It is shown that the retrieval information 80 corresponds to the retrieval result. FIG. 4 is a schematic diagram of a system diagram for retrieving data in this embodiment.

綜合前述之內容，本新型之該處理模組20做出了下述之內容：該處理模組20透過該介面模組30接收該第一資料100、該第二資料200和該第三資料300，且將該第一資料100、該第二資料200和該第三資料300存於該記憶模組10中。 In view of the foregoing, the processing module 20 of the present invention achieves the following contents: the processing module 20 receives the first data 100 , the second data 200 and the third data 300 through the interface module 30 , and the first data 100 , the second data 200 and the third data 300 are stored in the memory module 10 .

該處理模組20分別掃描各該第一資料100、該第二資料200和該第三資料300中的該至少一代碼和分別通過該自然語言處理(NLP)理解該第一資料100、該第二資料200和該第三資料300中的該至少一文字以對應建立該至少一第一資料節點、該至少一第二資料節點和該至少一第三資料節點。 The processing module 20 scans the at least one code in each of the first data 100 , the second data 200 and the third data 300 respectively and understands the first data 100 , the first data 100 and the third data through the natural language processing (NLP) respectively. The at least one word in the second data 200 and the third data 300 is correspondingly established to create the at least one first data node, the at least one second data node and the at least one third data node.

該處理模組20判斷該至少一第一資料節點是否和該至少一第二資料節點相同。當判斷該至少一第一資料節點和該至少一第二資料節點不相同時，則該處理模組20未建立該第一資料100和該第二資料200之間的連結。 The processing module 20 determines whether the at least one first data node is the same as the at least one second data node. When it is determined that the at least one first data node and the at least one second data node are different, the processing module 20 does not establish a link between the first data 100 and the second data 200 .

當判斷該至少一第一資料節點和該至少一第二資料節點相同時，該處理模組20連結相同的兩資料節點以建立該第一資料100和該第二資料200之間的關聯性，並對應產生該關聯性資料90，且將該關聯性資料90存於該記憶模組10中。 When judging that the at least one first data node and the at least one second data node are the same, the processing module 20 connects the same two data nodes to establish the association between the first data 100 and the second data 200, Correspondingly, the correlation data 90 is generated, and the correlation data 90 is stored in the memory module 10 .

該處理模組20進一步判斷該至少一第一資料節點是否和該至少一第三資料節點相同。當判斷該至少一第一資料節點和該至少一第三資料節點不相同時，則該處理模組20未建立該第一資料100和該第三資料300之間的連結。 The processing module 20 further determines whether the at least one first data node is the same as the at least one third data node. When it is determined that the at least one first data node and the at least one third data node are different, the processing module 20 does not establish a link between the first data 100 and the third data 300 .

當判斷該至少一第一資料節點和該至少一第三資料節點時，該處理模組20連結相同的兩資料節點以建立該第一資料100和該第三資料300之間的關聯性，並對應更新該關聯性資料90。 When determining the at least one first data node and the at least one third data node, the processing module 20 connects the same two data nodes to establish the association between the first data 100 and the third data 300, and The correlation data 90 is updated accordingly.

該處理模組20進一步判斷該至少一第二資料節點是否和該至少一第三資料節點相同。當判斷該至少一第二資料節點和該至少一第三資料節點不相同時，則該處理模組20未建立該第二資料200和該第三資料300之間的連結。 The processing module 20 further determines whether the at least one second data node is the same as the at least one third data node. When it is determined that the at least one second data node and the at least one third data node are different, the processing module 20 does not establish a link between the second data 200 and the third data 300 .

當判斷該至少一第二資料節點和該至少一第三資料節點相同時，該處理模組20連結相同的兩資料節點以建立該第二資料200和該第三資料300之間的關聯性，並對應更新該關聯性資料90。 When judging that the at least one second data node and the at least one third data node are the same, the processing module 20 connects the same two data nodes to establish the association between the second data 200 and the third data 300, And the correlation data 90 is updated accordingly.

該處理模組20產生該資料系統圖以圖形化該記憶模組10中存有的資料，並且透過該介面模組30呈現該資料系統圖。 The processing module 20 generates the data system diagram to graph the data stored in the memory module 10 , and presents the data system diagram through the interface module 30 .

該處理模組20判斷該介面模組30是否產生該修改訊號。 The processing module 20 determines whether the interface module 30 generates the modification signal.

當判斷該介面模組30未產生該修改訊號時，該處理模組20未修改該關聯性資料90和任兩資料之間的關聯性。 When it is determined that the interface module 30 does not generate the modification signal, the processing module 20 does not modify the association between the association data 90 and any two data.

當判斷該介面模組30產生該修改訊號時，該處理模組20根據該介面模組30產生的該修改訊號修改任兩資料之間的關聯性，並對應更新該記憶模組10中存有的該關聯性資料90。 When judging that the interface module 30 generates the modification signal, the processing module 20 modifies the correlation between any two data according to the modification signal generated by the interface module 30 , and correspondingly updates the data stored in the memory module 10 90 of the associated data.

該處理模組20判斷該介面模組30是否產生該檢索資訊80。 The processing module 20 determines whether the interface module 30 generates the retrieval information 80 .

當判斷該介面模組30未產生該檢索資訊80時，該處理模組20未開始檢索。 When it is determined that the interface module 30 does not generate the retrieval information 80, the processing module 20 does not start retrieval.

當判斷該介面模組30產生該檢索資訊80時，則該處理模組20開始檢索，即根據該介面模組30產生的該檢索資訊80依序判斷該檢索資訊80是否和該記憶模組10中存有的該至少一第一資料節點、該至少一第二資料節點或是該至少一第三資料節點相同。 When it is determined that the retrieval information 80 is generated by the interface module 30 , the processing module 20 starts retrieval, that is, according to the retrieval information 80 generated by the interface module 30 , it is determined whether the retrieval information 80 corresponds to the memory module 10 in sequence. The at least one first data node, the at least one second data node, or the at least one third data node stored in the are the same.

當判斷該檢索資訊80和該至少一第一資料節點相同時，進一步根據該記憶模組10中存有的該關聯性資料90判斷和該檢索資訊80相同的該至少一第一資料節點是否進一步和該至少一第二資料節點或該至少一第三資料節點相同。 When it is determined that the retrieval information 80 is the same as the at least one first data node, the at least one node that is the same as the retrieval information 80 is further determined according to the correlation data 90 stored in the memory module 10 . Whether the first data node is further identical to the at least one second data node or the at least one third data node.

當判斷和該檢索資訊80相同的該至少一第一資料節點進一步和該至少一第二資料節點或是該至少一第三資料節點相同時，該處理模組20透過該介面模組30呈現該檢索結果為該第一資料100和對應相同的該第二資料200或是該第三資料300。 When judging that the at least one first data node that is the same as the search information 80 is further identical to the at least one second data node or the at least one third data node, the processing module 20 presents the information through the interface module 30 The retrieval result is that the first data 100 corresponds to the same second data 200 or the third data 300 .

當判斷和該檢索資訊80相同的該至少一第一資料節點和該至少一第二資料節點或該至少一第三資料節點不相同時，該處理模組20透過該介面模組30呈現該檢索結果為該第一資料100。 When judging that the at least one first data node and the at least one second data node or the at least one third data node that are the same as the search information 80 are different, the processing module 20 presents the search through the interface module 30 The result is the first profile 100 .

當判斷該檢索資訊80和該至少一第一資料節點不相同時，該處理模組20則依序判斷判斷該檢索資訊80和該至少一第二資料節點是否相同。當判斷該檢索資訊80和該至少一第二資料節點不相同時，該處理模組20則依序判斷判斷該檢索資訊80和該至少一第三資料節點是否相同，以此類推。 When judging that the retrieval information 80 and the at least one first data node are different, the processing module 20 sequentially determines whether the retrieval information 80 and the at least one second data node are the same. When judging that the retrieval information 80 and the at least one second data node are different, the processing module 20 sequentially determines whether the retrieval information 80 and the at least one third data node are the same, and so on.

當判斷該檢索資訊80和該至少一第一資料節點、該至少一第二資料節點或是該至少一第三資料節點都不相同時，該處理模組20透過該介面模組30呈現該檢索結果為未對應任何資料。 When judging that the retrieval information 80 is different from the at least one first data node, the at least one second data node or the at least one third data node, the processing module 20 presents the retrieval through the interface module 30 The result is that there is no corresponding data.

該處理模組20根據該檢索結果產生該檢索資料系統圖，並且透過該介面模組30呈現該檢索資料系統圖，用於示意該檢索資訊80對應該檢索結果的情形。 The processing module 20 generates the system diagram of the retrieval data according to the retrieval result, and presents the system diagram of the retrieval data through the interface module 30 to indicate the situation that the retrieval information 80 corresponds to the retrieval result.

10:記憶模組 10: Memory module

20:處理模組 20: Processing modules

Claims

一種可編輯資料關聯的資料庫系統，包括：一記憶模組，存有一第一資料和一第二資料；一處理模組，電連接該記憶模組；其中，該處理模組分別掃描該第一資料和該第二資料的內容以建立對應該第一資料的至少一第一資料節點和對應該第二資料的至少一第二資料節點；其中，判斷該至少一第一資料節點是否和該至少一第二資料節點相同；若相同，則該處理模組建立該第一資料和該第二資料之間的關聯性，並對應產生一關聯性資料，且將該關聯性資料存於該記憶模組中。 A database system capable of editing data association, comprising: a memory module, storing a first data and a second data; a processing module, electrically connected to the memory module; wherein, the processing module scans the first data respectively a data and the content of the second data to establish at least one first data node corresponding to the first data and at least one second data node corresponding to the second data; wherein, it is determined whether the at least one first data node is the same as the At least one second data node is the same; if it is the same, the processing module establishes the correlation between the first data and the second data, and generates a correlation data correspondingly, and stores the correlation data in the memory in the module.

如請求項1所述之可編輯資料關聯的資料庫系統，進一步包括：一介面模組，電連接該處理模組，顯示一管理介面，用於管理該記憶模組存有的資料；其中，當該介面模組產生一修改訊號時，該處理模組即修改該記憶模組中的該關聯性資料，以對應修改該第一資料和該第二資料之間的關聯性，並更新該記憶模組中存有的該關聯性資料。 The database system capable of editing data association according to claim 1, further comprising: an interface module electrically connected to the processing module and displaying a management interface for managing the data stored in the memory module; wherein, When the interface module generates a modification signal, the processing module modifies the correlation data in the memory module to correspondingly modify the correlation between the first data and the second data, and update the memory The associated data that exists in the module.

如請求項2所述之可編輯資料關聯的資料庫系統，其中該處理模組進一步包括：一節點建立單元，分別掃描該第一資料和該第二資料的內容以建立對應該第一資料的該至少一第一資料節點和該第二資料的該至少一第二資料節點；和一連結建立單元，判斷該至少一第一資料節點是否和該至少一第二資料節點相同；當該連結建立單元判斷該至少一第一資料節點和該至少一第二資料節點相同時，該連結建立單元建立該第一資料和該第二資料之間的關聯性，並對應產生該關聯性資料，且將該關聯性資料存於該記憶模組中。 The database system capable of editing data associations according to claim 2, wherein the processing module further comprises: a node establishing unit, which scans the contents of the first data and the second data respectively to create a database corresponding to the first data the at least one first data node and the at least one second data node of the second data; and a connection establishment unit to determine whether the at least one first data node is the same as the at least one second data node; when the connection is established When the unit determines that the at least one first data node and the at least one second data node are the same, the link establishment unit establishes the association between the first data and the second data, and generates the association data correspondingly, and sets The associated data is stored in the memory module.

如請求項3所述之可編輯資料關聯的資料庫系統，其中該至少一第一資料節點和該至少一第二資料節點各分別包括該第一資料和該第二資料中的至少一代碼。 The database system for editable data associations as described in claim 3, wherein Each of the at least one first data node and the at least one second data node includes at least one code in the first data and the second data, respectively.

如請求項4所述之可編輯資料關聯的資料庫系統，其中該至少一第一資料節點和該至少一第二資料節點各分別包括該第一資料和該第二資料中自然語言(Natural Language)的至少一文字，且該節點建立單元通過一自然語言處理(Natural Language Processing)理解該第一資料和該第二資料中的該至少一文字以對應建立該至少一第一資料節點和該至少一第二資料節點。 The database system for editable data association according to claim 4, wherein the at least one first data node and the at least one second data node respectively comprise natural language in the first data and the second data, respectively ), and the node establishment unit understands the at least one character in the first data and the second data through a natural language processing to correspondingly establish the at least one first data node and the at least one first data node Two data nodes.

如請求項5所述之可編輯資料關聯的資料庫系統，其中該第一資料和該第二資料各為一表格，且各該表格包括一主索引鍵值和一資料地址資訊；該至少一第一資料節點包括該第一資料中的該主索引鍵值和該資料地址資訊；該至少一第二資料節點包括該第二資料中的該主索引鍵值和該資料地址資訊。 The database system with editable data association according to claim 5, wherein the first data and the second data are each a table, and each of the tables includes a primary index key value and a data address information; the at least one The first data node includes the primary index key value and the data address information in the first data; the at least one second data node includes the primary index key value and the data address information in the second data.

如請求項3所述之可編輯資料關聯的資料庫系統，其中該處理模組進一步包括一資料檢索單元，用於檢索該記憶模組中存有的資料以產生一檢索結果；當該介面模組產生一檢索資訊時，該資料檢索單元接收該介面模組的該檢索資訊，並判斷該檢索資訊是否和該記憶模組中存有的該至少一第一資料節點相同；當判斷該檢索資訊和該至少一第一資料節點相同時，該資料檢索單元進一步判斷該至少一第一資料節點是否有對應的該關聯性資料；若有，該資料檢索單元根據該關聯性資料讀取該第二資料節點，並判斷該檢索資訊是否和該至少一第二資料節點相同；當該檢索資訊和該至少一第二資料節點相同時，該資料檢索單元透過該介面模組呈現的該檢索結果為該第一資料和該第二資料；當該檢索資訊和該至少一第二資料節點不相同時，該資料檢索單元透過該介面模組呈現的該檢索結果為該第一資料。 The database system capable of editing data association according to claim 3, wherein the processing module further comprises a data retrieval unit for retrieving the data stored in the memory module to generate a retrieval result; when the interface module When the group generates a retrieval information, the data retrieval unit receives the retrieval information of the interface module, and judges whether the retrieval information is the same as the at least one first data node stored in the memory module; when judging the retrieval information When it is the same as the at least one first data node, the data retrieval unit further determines whether the at least one first data node has the corresponding related data; if so, the data retrieval unit reads the second data according to the related data a data node, and determine whether the retrieval information is the same as the at least one second data node; When the search information is the same as the at least one second data node, the search result presented by the data search unit through the interface module is the first data and the second data; when the search information and the at least one second data When the data nodes are different, the retrieval result presented by the data retrieval unit through the interface module is the first data.

如請求項7所述之可編輯資料關聯的資料庫系統，其中該處理模組進一步包括：一圖形化單元，產生一資料系統圖，用於圖形化該記憶模組中存有的資料，並且透過該介面模組呈現該資料系統圖。 The database system capable of editing data associations according to claim 7, wherein the processing module further comprises: a graphics unit for generating a data system diagram for graphics data stored in the memory module, and The data system diagram is presented through the interface module.

如請求項8所述之可編輯資料關聯的資料庫系統，其中：該圖形化單元根據該資料檢索單元所產生的該檢索結果產生一檢索資料系統圖，用於示意該檢索資訊對應該檢索結果的情形。 The database system with editable data association according to claim 8, wherein: the graphic unit generates a retrieval data system diagram according to the retrieval result generated by the data retrieval unit, which is used to indicate that the retrieval information corresponds to the retrieval result situation.

如請求項3至9中任一項所述之可編輯資料關聯的資料庫系統，其中：該記憶模組進一步存有一第三資料；該節點建立單元掃描該第三資料的內容以建立對應該第三資料的至少一第三資料節點；該連結建立單元判斷該至少一第三資料節點和該至少一第一資料節點或是該至少一第二資料節點不相同，而未建立該第三資料之於該第一資料或該第二資料之間的關聯性；當該介面模組產生該修改訊號時，該處理模組根據該修改訊號增加了該第三資料和該第二資料之間的關聯性，並對應更新該記憶模組中存有的該關聯性資料記錄該第三資料和該第二資料之間所增加的關聯性。 The database system capable of editing data association according to any one of claims 3 to 9, wherein: the memory module further stores a third data; the node establishment unit scans the content of the third data to create a corresponding at least one third data node of the third data; the link establishment unit determines that the at least one third data node is different from the at least one first data node or the at least one second data node, and does not create the third data the correlation between the first data or the second data; when the interface module generates the modification signal, the processing module increases the relationship between the third data and the second data according to the modification signal correlation, and correspondingly update the correlation data stored in the memory module to record the increased correlation between the third data and the second data.