WO2023218534A1 - データベース管理装置、データベース管理方法およびデータベース管理プログラム - Google Patents
データベース管理装置、データベース管理方法およびデータベース管理プログラム Download PDFInfo
- Publication number
- WO2023218534A1 WO2023218534A1 PCT/JP2022/019839 JP2022019839W WO2023218534A1 WO 2023218534 A1 WO2023218534 A1 WO 2023218534A1 JP 2022019839 W JP2022019839 W JP 2022019839W WO 2023218534 A1 WO2023218534 A1 WO 2023218534A1
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- node
- database management
- nodes
- information
- database
- Prior art date
- Legal status (The legal status 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 status listed.)
- Ceased
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
Definitions
- the present invention relates to a database management device, a database management method, and a database management program.
- graph databases that can acquire interconnection relationships between data at higher speeds are attracting attention (see Patent Documents 1 and 2).
- the graph DB is implemented in the form of nodes (points) and relationships (lines) that connect two nodes.
- the present invention has been made in view of the above, and aims to enable database developers and database users to easily understand the internal structure of a graph DB.
- a database management device provides, for each node, attribute information of the node including information identifying the hierarchy to which the node belongs, and relationships between the nodes. and a configuration unit that configures a database that associates the acquired attribute information of each node with information representing the relationship between the nodes. .
- FIG. 1 is a diagram for explaining an overview of a database management device.
- FIG. 2 is a schematic diagram illustrating a schematic configuration of a database management device.
- FIG. 3 is a diagram for explaining the processing of the constituent parts.
- FIG. 4 is a flowchart showing the database management processing procedure.
- FIG. 5 is a diagram illustrating a computer that executes a database management program.
- FIG. 1 is a diagram for explaining an overview of a database management device.
- a graph DB is described by nodes and relationships between two nodes.
- FIG. 1A for example, for a node with a node name "node 11,” ID “ID11” and attributes “attribute 11,””attribute21,” and “attribute 31" are described. Further, the relationship between nodes 11 and 12 and the relationship between nodes 12 and 13 are each described by lines.
- the database management device of this embodiment assigns a hierarchy number to the attribute of each node, as illustrated in FIG. 1(b).
- a layer number "layer 10" is assigned to the node 11.
- layer 10 has node 11, node 12, and node It consists of 13. Therefore, by assigning a hierarchy number to the attribute of each node, it is possible to describe a graph DB having a hierarchical structure between nodes.
- the hierarchical structure is made clear in the internal representation of the graph DB, and the description of the relationships between nodes is optimized. Therefore, development efficiency is improved for DB developers. Additionally, for DB users, the output of the graph DB based on searches from applications is sped up.
- FIG. 2 is a schematic diagram illustrating a schematic configuration of a database management device.
- the database management device 10 is realized by a general-purpose computer such as a personal computer, and includes an input section 11, an output section 12, a communication control section 13, a storage section 14, and a control section 15.
- the input unit 11 is realized using an input device such as a keyboard or a mouse, and inputs various instruction information such as starting processing to the control unit 15 in response to an input operation by an operator.
- the output unit 12 is realized by a display device such as a liquid crystal display, a printing device such as a printer, and the like.
- the communication control unit 13 is realized by a NIC (Network Interface Card) or the like, and controls communication between the control unit 15 and an external device such as a server via a network.
- the communication control unit 13 controls communication between the control unit 15 and a database device of another system that manages data used in database management processing, which will be described later, or a user terminal on which an application is installed.
- the storage unit 14 is realized by a semiconductor memory element such as a RAM (Random Access Memory) or a flash memory, or a storage device such as a hard disk or an optical disk.
- a processing program for operating the database management device 10 data used during execution of the processing program, and the like are stored in advance, or are temporarily stored each time processing is performed.
- the storage unit 14 may be configured to communicate with the control unit 15 via the communication control unit 13.
- the storage unit 14 stores a graph DB 14a configured by database management processing described below, and is used as a database for applications.
- the control unit 15 is realized using a CPU (Central Processing Unit) or the like, and executes a processing program stored in a memory. Thereby, the control unit 15 functions as an acquisition unit 15a and a configuration unit 15b, as illustrated in FIG. 2, and executes a database management process to be described later. Note that these functional units may be implemented in different hardware. Further, the control unit 15 may include other functional units.
- CPU Central Processing Unit
- the acquisition unit 15a acquires, for each node, information on attributes of the node, including information identifying the hierarchy to which the node belongs, and information representing relationships between nodes. For example, the acquisition unit 15a acquires data used for processing by the configuration unit 15b, which will be described later, via the input unit 11 or from a database device of another system or the like via the communication control unit 13.
- the configuration unit 15b configures a database in which the acquired attribute information of each node is associated with information representing the relationship between the nodes. Specifically, the configuration unit 15b configures a database by associating attribute information of each node with information representing relationships between nodes, and stores the database in the storage unit 14 as the graph DB 14a.
- the acquired node attribute information includes information such as a layer number that identifies the layer to which the node belongs. Therefore, the graph DB 14a is given a layer number that identifies the layer to which each node belongs, as illustrated in FIG. 1(b). In this way, it becomes possible to describe a graph DB that has a hierarchical structure between nodes. Therefore, the hierarchy constituted by the plurality of nodes in the graph DB 14a becomes clear.
- FIG. 3 is a diagram for explaining the processing of the component parts.
- FIG. 3 exemplifies the configuration of the graph DB 14a when communication equipment is used as a node.
- a node is a communication facility
- a hierarchy is a layer within a network of communication facilities.
- the graph DB 14a has each of point equipment 01 to point equipment 03, optical cable 01 to optical cable 03, and optical fiber specification status 01 to optical fiber usage status 03 as nodes, and information on the attributes of each node is stored. It has been described.
- Each node includes information on a node name, node ID, and attributes.
- the attribute information includes a hierarchy number in addition to the equipment name and equipment number.
- the layer number is information that identifies the layer that the node configures.
- the point equipment layer is composed of point equipment 01 to point equipment 03.
- Information identifying the point equipment layer is set as the layer number of point equipment 01 to point equipment 03.
- the nodes may be organizations within a company, and the hierarchy may be the order of the chain of command of each organization within the company.
- the node attribute information includes personnel information of employees belonging to each organization, information on products and services handled by each organization, and the like. This attribute information includes hierarchy numbers assigned in ascending order, starting with the president or head office, and then, for example, branches, branches, and sales offices.
- FIG. 4 is a flowchart showing the database management processing procedure.
- the flowchart in FIG. 4 is started, for example, at the timing when an operation input instructing the start of database management processing is received.
- the acquisition unit 15a acquires, for each node, information on the attributes of the node, including information identifying the hierarchy to which the node belongs, and information representing the relationship between the nodes (step S1). For example, the acquisition unit 15a acquires data used for processing by the configuration unit 15b, which will be described later, via the input unit 11 or from a database device of another system or the like via the communication control unit 13.
- the configuration unit 15b configures a database in which the acquired attribute information of each node is associated with information representing the relationship between the nodes (step S2). Specifically, the configuration unit 15b configures a database by associating attribute information of each node with information representing relationships between nodes, and stores the database in the storage unit 14 as the graph DB 14a. This completes a series of database management processes.
- the acquisition unit 15a acquires, for each node, attribute information of the node including information identifying the hierarchy to which the node belongs, and information representing the relationship between the nodes. get.
- the configuration unit 15b configures a graph DB 14a that associates acquired attribute information of each node with information representing relationships between nodes.
- a node is a communication facility
- a hierarchy is a layer within a network of communication facilities.
- the node may be an organization within a company, and the hierarchy may be the order of the organization's chain of command within the company.
- the database management device 10 of this embodiment even if the graph DB 14a becomes complex, the hierarchical structure is made clear in its internal representation, and the description of the relationships between nodes is optimized. Therefore, development efficiency is improved for DB developers. Furthermore, for DB users, the output of the graph DB 14a based on searches from applications is sped up.
- the database management device 10 can be implemented by installing a database management program that executes the above-described database management processing into a desired computer as packaged software or online software. For example, by causing the information processing device to execute the above database management program, the information processing device can be made to function as the database management device 10.
- information processing devices include mobile communication terminals such as smartphones, mobile phones, and PHSs (Personal Handyphone Systems), as well as slate terminals such as PDAs (Personal Digital Assistants).
- the functions of the database management device 10 may be implemented in a cloud server.
- FIG. 5 is a diagram showing an example of a computer that executes a database management program.
- Computer 1000 includes, for example, memory 1010, CPU 1020, hard disk drive interface 1030, disk drive interface 1040, serial port interface 1050, video adapter 1060, and network interface 1070. These parts are connected by a bus 1080.
- the memory 1010 includes a ROM (Read Only Memory) 1011 and a RAM 1012.
- the ROM 1011 stores, for example, a boot program such as BIOS (Basic Input Output System).
- Hard disk drive interface 1030 is connected to hard disk drive 1031.
- Disk drive interface 1040 is connected to disk drive 1041.
- a removable storage medium such as a magnetic disk or an optical disk is inserted into the disk drive 1041, for example.
- a mouse 1051 and a keyboard 1052 are connected to the serial port interface 1050.
- a display 1061 is connected to the video adapter 1060.
- the hard disk drive 1031 stores, for example, an OS 1091, an application program 1092, a program module 1093, and program data 1094. Each piece of information described in the above embodiments is stored in, for example, the hard disk drive 1031 or the memory 1010.
- the database management program is stored in the hard disk drive 1031, for example, as a program module 1093 in which commands to be executed by the computer 1000 are written.
- a program module 1093 in which each process executed by the database management device 10 described in the above embodiment is described is stored in the hard disk drive 1031.
- data used for information processing by the database management program is stored as program data 1094 in, for example, the hard disk drive 1031.
- the CPU 1020 reads out the program module 1093 and program data 1094 stored in the hard disk drive 1031 to the RAM 1012 as necessary, and executes each of the above-described procedures.
- program module 1093 and program data 1094 related to the database management program are not limited to being stored in the hard disk drive 1031; for example, they may be stored in a removable storage medium and read by the CPU 1020 via the disk drive 1041 or the like. May be served.
- the program module 1093 and program data 1094 related to the database management program are stored in another computer connected via a network such as a LAN (Local Area Network) or WAN (Wide Area Network), and are transmitted via the network interface 1070. The data may also be read out by the CPU 1020.
- LAN Local Area Network
- WAN Wide Area Network
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
図1は、データベース管理装置の概要を説明するための図である。図1(a)に示すように、従来、グラフDBは、ノードと2つのノード間の関係性とで記述されている。図1(a)には、例えばノード名「ノード11」のノードについて、ID「ID11」、属性「属性11」「属性21」「属性31」が記述されている。またノード11とノード12との関係性、ノード12とノード13との関係性がそれぞれ線で記述されている。
図2は、データベース管理装置の概略構成を例示する模式図である。図2に例示するように、データベース管理装置10は、パソコン等の汎用コンピュータで実現され、入力部11、出力部12、通信制御部13、記憶部14、および制御部15を備える。
次に、図4を参照して、本実施形態に係るデータベース管理装置10によるデータベース管理処理について説明する。図4は、データベース管理処理手順を示すフローチャートである。図4のフローチャートは、例えば、データベース管理処理の開始を指示する操作入力があったタイミングで開始される。
以上、説明したように、データベース管理装置10において、取得部15aが、各ノードについて、該ノードが属する階層を識別する情報を含む該ノードの属性の情報と、ノード間の関係を表す情報とを取得する。構成部15bが、取得された各ノードの属性の情報と、ノード間の関係を表す情報と対応付けたグラフDB14aを構成する。
上記実施形態に係るデータベース管理装置10が実行する処理をコンピュータが実行可能な言語で記述したプログラムを作成することもできる。一実施形態として、データベース管理装置10は、パッケージソフトウェアやオンラインソフトウェアとして上記のデータベース管理処理を実行するデータベース管理プログラムを所望のコンピュータにインストールさせることによって実装できる。例えば、上記のデータベース管理プログラムを情報処理装置に実行させることにより、情報処理装置をデータベース管理装置10として機能させることができる。また、その他にも、情報処理装置にはスマートフォン、携帯電話機やPHS(Personal Handyphone System)等の移動体通信端末、さらには、PDA(Personal Digital Assistant)等のスレート端末等がその範疇に含まれる。また、データベース管理装置10の機能を、クラウドサーバに実装してもよい。
11 入力部
12 出力部
13 通信制御部
14 記憶部
14a グラフDB
15 制御部
15a 取得部
15b 構成部
Claims (5)
- 各ノードについて、該ノードが属する階層を識別する情報を含む該ノードの属性の情報と、ノード間の関係を表す情報とを取得する取得部と、
取得された各ノードの前記属性の情報と、前記ノード間の関係を表す情報と対応付けたデータベースを構成する構成部と、
を有することを特徴とするデータベース管理装置。 - 前記ノードは通信設備であり、前記階層は前記通信設備のネットワーク内におけるレイヤであることを特徴とする請求項1に記載のデータベース管理装置。
- 前記ノードは企業内の組織であり、前記階層は前記組織の企業内での命令系統の順位であることを特徴とする請求項1に記載のデータベース管理装置。
- データベース管理装置が実行するデータベース管理方法であって、
各ノードについて、該ノードが属する階層を識別する情報を含む該ノードの属性の情報と、ノード間の関係を表す情報とを取得する取得工程と、
取得された各ノードの前記属性の情報と、前記ノード間の関係を表す情報と対応付けたデータベースを構成する構成工程と、
を含んだことを特徴とするデータベース管理方法。 - 各ノードについて、該ノードが属する階層を識別する情報を含む該ノードの属性の情報と、ノード間の関係を表す情報とを取得する取得ステップと、
取得された各ノードの前記属性の情報と、前記ノード間の関係を表す情報と対応付けたデータベースを構成する構成ステップと、
をコンピュータに実行させるためのデータベース管理プログラム。
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| PCT/JP2022/019839 WO2023218534A1 (ja) | 2022-05-10 | 2022-05-10 | データベース管理装置、データベース管理方法およびデータベース管理プログラム |
| JP2024520122A JP7761141B2 (ja) | 2022-05-10 | 2022-05-10 | データベース管理装置、データベース管理方法およびデータベース管理プログラム |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| PCT/JP2022/019839 WO2023218534A1 (ja) | 2022-05-10 | 2022-05-10 | データベース管理装置、データベース管理方法およびデータベース管理プログラム |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| WO2023218534A1 true WO2023218534A1 (ja) | 2023-11-16 |
Family
ID=88729931
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| PCT/JP2022/019839 Ceased WO2023218534A1 (ja) | 2022-05-10 | 2022-05-10 | データベース管理装置、データベース管理方法およびデータベース管理プログラム |
Country Status (2)
| Country | Link |
|---|---|
| JP (1) | JP7761141B2 (ja) |
| WO (1) | WO2023218534A1 (ja) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20070107340A (ko) * | 2006-05-02 | 2007-11-07 | 주식회사 케이티프리텔 | 유통 조직 신규 등록 및 수정의 자동화를 위한 유통 조직관리 장치 및 그 방법 |
| US20130002676A1 (en) * | 2011-06-28 | 2013-01-03 | Salesforce.Com, Inc. | Computer implemented systems and methods for visualizing organizational connections |
-
2022
- 2022-05-10 JP JP2024520122A patent/JP7761141B2/ja active Active
- 2022-05-10 WO PCT/JP2022/019839 patent/WO2023218534A1/ja not_active Ceased
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20070107340A (ko) * | 2006-05-02 | 2007-11-07 | 주식회사 케이티프리텔 | 유통 조직 신규 등록 및 수정의 자동화를 위한 유통 조직관리 장치 및 그 방법 |
| US20130002676A1 (en) * | 2011-06-28 | 2013-01-03 | Salesforce.Com, Inc. | Computer implemented systems and methods for visualizing organizational connections |
Non-Patent Citations (1)
| Title |
|---|
| YASUYUKI KATO, YASUO KATAOKA: "An Object-Oriented Database Application for Subscriber Outside Plants Operating System", SIG TECHNICAL REPORT, DBS, vol. 91, no. 93 (91-DBS-86), 8 November 1991 (1991-11-08), pages 89 - 97, XP009550524 * |
Also Published As
| Publication number | Publication date |
|---|---|
| JPWO2023218534A1 (ja) | 2023-11-16 |
| JP7761141B2 (ja) | 2025-10-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10866791B2 (en) | Transforming non-Apex code to Apex code | |
| CN102165419B (zh) | 用于管理批作业的计算机系统及其方法及计算机程序 | |
| WO2024155432A1 (en) | Schema-aware encoding of natural language | |
| CN1647040A (zh) | 用于管理计算机系统的方法和系统 | |
| CN116601605A (zh) | 在云平台上声明式供应资源 | |
| CN114172808A (zh) | Kubernetes集群升级方法、系统、设备及存储介质 | |
| WO2025124172A1 (zh) | 一种组件部署升级方法、装置、计算机设备及存储介质 | |
| US11184251B2 (en) | Data center cartography bootstrapping from process table data | |
| CN113902387A (zh) | 一种工作流的处理方法、装置及电子设备 | |
| WO2023218534A1 (ja) | データベース管理装置、データベース管理方法およびデータベース管理プログラム | |
| CN114490694A (zh) | 一种业务规则处理方法、装置、服务器及存储介质 | |
| WO2023275945A1 (ja) | データベース管理装置、データベース管理方法およびデータベース管理プログラム | |
| Arifiany et al. | Leveraging headless content management system as a service in a service-based architecture: Enhancing user experience and overcoming resource limitations for start-ups | |
| US20240370294A1 (en) | Horizontally scalable system for managing container clusters | |
| KR20240144276A (ko) | 보존된 이력 정보를 사용한 서비스 맵 변환 | |
| CN116820500A (zh) | 一种集群镜像部署方法、装置、设备及存储介质 | |
| CN111176786A (zh) | 一种基于docker的配置管理系统及方法 | |
| US9733931B2 (en) | Configuration management of engineering artifacts with automatic identification of related change sets based on type system | |
| CN115658773A (zh) | 一种敏感数据发现方法及装置 | |
| CN116483707A (zh) | 测试方法、装置、设备、存储介质及程序产品 | |
| WO2023238244A1 (ja) | 探索装置、探索方法および探索プログラム | |
| CN115576977A (zh) | 数据分页查询方法、装置、电子设备及存储介质 | |
| CN114003302A (zh) | 一种基于kubernetes的资源运维管理方法及系统 | |
| CN115357253A (zh) | 一种软件产品部署方法、装置、设备及存储介质 | |
| CN112968897B (zh) | 一种在去中心化系统中运行的容器计算方法 |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| 121 | Ep: the epo has been informed by wipo that ep was designated in this application |
Ref document number: 22941616 Country of ref document: EP Kind code of ref document: A1 |
|
| ENP | Entry into the national phase |
Ref document number: 2024520122 Country of ref document: JP Kind code of ref document: A |
|
| WWE | Wipo information: entry into national phase |
Ref document number: 18863756 Country of ref document: US |
|
| NENP | Non-entry into the national phase |
Ref country code: DE |
|
| 122 | Ep: pct application non-entry in european phase |
Ref document number: 22941616 Country of ref document: EP Kind code of ref document: A1 |