Data searching method of database, apparatus and computer program for the same
The present invention provides a data searching method of database, apparatus and computer program for the same. The data searching apparatus of a database includes: a storage unit configured to store graph data; and a controller configured to store physical location information in which vertex and edge information included in the graph data is stored in the storage unit, and perform a search for the vertex and the edge based on the physical location information. Thereby, it is possible to efficiently search the data by improving a search speed of a graph, minimize the update of the information even when a storage location of the data is changed, and facilitate query by the graph data regardless of types of the database and a storage structure, and efficiently use a storage space.
1. A data searching apparatus of a database, comprising:
a storage unit configured to store graph data thererin; and
a controller comprising a microcomputer and configured to store physical location information in which vertex and edge information included in the graph data is stored in the storage unit, and perform a search for the vertex and the edge based on the physical location information,
wherein the controller updates the physical location information in response to at least one of deletion of the vertex information, addition of the edge information, update of the edge information, and deletion of the edge information,
wherein the storage unit additionally stores a global index for searching for an actual storage location of the graph data, and
wherein the controller postpones an update timing of the physical location information until a timing in which it is determined by the global index that the physical location information does not point accurate vertex and/or edge information.
2. A data searching apparatus of a database, comprising:
a storage unit configured to store a table therein, wherein the table stores graph data therein; and
a controller comprising a computer and configured to store physical location information in which vertex and edge information included in the graph data is stored in the storage unit, and perform a search for the vertex and the edge based on the physical location information,
wherein the table includes a vertex table configured to store the vertex information and the physical location information corresponding to the vertex information, and an edge table configured to store the edge information and the physical location information corresponding to the edge information, and
wherein the vertex table stores physical location information on an edge that enters a specific vertex and physical location information on an edge that leaves the specific vertex, in a list form.
3. The data searching apparatus of a database according to claim 2 , wherein the vertex table includes a vertex property table configured to store properties of the vertex, and
the edge table includes an edge property table configured to store properties of the edge.
4. The data searching apparatus of a database according to claim 2 , wherein the table stores data by a JavaScript object notation (JSON) data type.
5. The data searching apparatus of a database according to claim 2 , wherein, when a row is added due to update of the database or the row is dispersed such that physical location movement occurs, the controller updates the physical location information in a chain form so that the physical location information points the added row.
6. The data searching apparatus of a database according to claim 2 , wherein the controller updates the physical location information in response to at least one of deletion of the vertex information, addition of the edge information, update of the edge information, and deletion of the edge information.
7. A method for searching data in a database by a controller comprising a computer, the method comprising:
storing, by the controller, graph data in a storage unit;
storing, by the controller, physical location information in which vertex and edge information included in the graph data is stored in the storage unit;
performing, by the controller, a search for the vertex and the edge based on the physical location information;
updating, by the controller, the physical location information in response to at least one of deletion of the vertex information, addition of the edge information, update of the edge information, and deletion of the edge information;
additionally storing, by the controller, a global index for searching for an actual storage location of the graph data by a control of the controller; and
postponing, by the controller, an update timing of the physical location information until it is determined by the global index that the physical location information does not point accurate vertex and/or edge information.
8. A non-transitory computer-readable recording medium or media comprising a set of instructions for searching data in a database, wherein execution of the set of instructions by one or more processors causes the one or more processors to perform the steps of:
storing graph data in a storage unit;
storing physical location information in which vertex and edge information included in the graph data is stored in the storage unit;
performing a search for the vertex and the edge based on the physical location information;
updating the physical location information in response to at least one of deletion of the vertex information, addition of the edge information, update of the edge information, and deletion of the edge information;
additionally storing a global index for searching for an actual storage location of the graph data by a control of the controller; and
postponing an update timing of the physical location information until it is determined by the global index that the physical location information does not point accurate vertex and/or edge information.