KR102488466B1 - Apparatus and method to design key-value database based in table diagram - Google Patents

Abstract

The present invention relates to a key-value DB design information processing apparatus based on a table diagram, comprising: a user interface unit receiving an input of a user setting command for designing a key-value DB; a storage unit storing the key-value DB designed in accordance with the inputted user setting command; and a control unit visualizing big data into the figure of a table diagram based on a table of the key-value DB in accordance with the inputted user setting command, and designing the key-value DB. The control unit classifies the big data into data structure types of hash, list, set/sorted set, and hyperloglogs written in each table figure classified in accordance with the data type characteristics, firstly draws a data structure in one or more of the data structure types in accordance with a user setting command, expresses data personalities between the data structures as a link type, which is a relation structure connecting tables with independent task correlation between tables, generates a table diagram based on an operation of secondly drawing the data personalities in accordance with the user setting command, and visualizes the big data into a table figure, thereby designing the key-value DB. Therefore, a key-value DB can be very easily and intuitively designed.

Description

Table diagram-based key-value DB design information processing device and method {Apparatus and method to design key-value database based in table diagram}

The present invention relates to a database design apparatus and method, and more particularly, to a table diagram-based key-value DB design information processing apparatus and method represented by symbols and figures that can be easily understood intuitively. .

Big data technology is a technology that has emerged to extract valuable information by collecting, storing, and analyzing large-scale data that is large in size, rapidly increasing in size, and has an atypical data format at low cost. Software for big data processing typically includes data storage software NoSQL DBMS, distributed processing, distributed file system Hadoop, software R for analysis and visualization.

Various technologies related to big data became known to the world as Google announced GFS (Google File System) in 2003, MapReduce in 2004, and BigTable in 2006, which were used in Google's search service. GFS is a distributed network file system created by connecting hardware equipment with low-cost specifications, and it served as a catalyst for the development of cloud technology, which is currently attracting worldwide attention.

MapReduce and BigTable are technologies for analyzing and storing large amounts of data in a distributed computing environment and have become core technologies in the big data industry. In addition, research on distributed data processing around the world, including Google's thesis, has been applied to the industry by various NoSQL products such as Apache Hadoop, Hadoop Distributed File System (HDFS-Hadoop Distributed File System), MapReduce, and HBase, which are open source projects. It led to applied results.

In order to apply these big data technologies, big data collection and conversion technology for collecting large amounts of data, big data storage technology for distributed storage of collected data, big data management technology for monitoring and management of distributed and stored data, It can be classified as a big data distribution technology for data analysis and processing. In addition, various open source and commercial software exist in each technology area, and most of them are foreign technologies and products, including the United States. Most of the companies that want to create value through big data are leading the big data technology market, and foreign technologies and products is dependent on and will have to do so in the future. In order to reduce price competitiveness and technology dependence, domestic solution companies must secure and develop technologies and products suitable for each technology area.

The existing relational database problems and the necessity of NoSQL are as follows. That is, a relational database having atomicity, consistency, isolation, and durability maintains the integrity of the database through a transaction function. Also, relational databases have a predefined schema structure. Therefore, when storing data in a relational database, data redundancy can be minimized because it goes through a normalization process.

In addition, relational databases have the advantage of being able to perform complex query operations such as join operations. However, although relational databases are used in many fields because of these advantages, they have a structure that is very inefficient in processing unstructured data because a formalization process is required to store data in a strict predefined schema structure of relational databases.

In addition, it has a limitation that it is difficult to expand through node distribution when data grows rapidly. NoSQL (Not only SQL) is a non-relational database that does not support complex operations such as join operations provided by existing relational databases, but provides ease of expansion through node distribution when data grows rapidly, and provides unstructured data Since it has a structure suitable for processing and can easily expand the database structure through flexible schema structure and node distribution according to data growth, it has attracted attention from many distributed system developers and is an alternative to overcome the limitations of relational databases. It is getting attention.

NoSQL, which means Not Only SQL, is not a database that came out to replace SQL, but a database that was created to provide more options for processing data that is not suitable for SQL. In other words, NoSQL and SQL coexist and have their own areas. NoSQL was mainly created to handle large amounts of data without being limited by a fixed schema, and the lack of a fixed schema means that, unlike relational databases, tables do not have a pre-determined schema.

In addition, NoSQL does not have a join operation, which is a basic operation of relational databases, and expands performance through scale-out instead of scale-up. Scale-out enables distributed systems by taking multiple machines with lower performance and creating a single virtual machine that combines the performance of several machines.

Companies are interested in various forms of unstructured data that we have not been interested in so far, and it is a reality that they are interested in collecting and storing data using new data storage technologies, not existing data storage technologies. Keeping pace with the needs of the times, NoSQL technology will become a required base technology, and design and monitoring tools based on it will be desperately required.

The inconveniences and shortcomings of using NoSQL are as follows. In other words, data storage technology using NoSQL began to develop in the United States in the early 2000s, and it was only in 2013 that the stability of the technology was recognized, and in 2015, the reality is that the base is rapidly expanding. to be. The core technology of NoSQL database has been developed beyond recognition over the past 15 years, but in order to be utilized and applied in a real business environment, it must be designed easily and simply, and a monitoring tool that can control tens to hundreds of servers is essential. necessary.

Although some tools have been developed by domestic and foreign 3rd parties, the technology to monitor tens to hundreds of servers by domain at the same time is missing, and since it provides only monitoring functions for each server, the reality is that there are functional limitations and technical problems. to be. In addition, in order to efficiently build a NoSQL database, an easy and convenient design tool is essential, but the reality is that there are only a few products that provide design tool technology domestically and internationally.

The object of the present invention to solve the above problems is as follows.

First, an object of the present invention is to provide a device and method for applying a unique notation that allows anyone to easily and conveniently analyze and design a key-value database.

Second, the task of the present invention is to provide a device that enables the construction of a big data platform quickly, and to design a table diagram-based key-value DB design information processing device marked with symbols and figures that can be easily understood intuitively. and to provide a method.

A first feature of the present invention for solving the above problems is, a key-value (Key-Value) user interface unit for receiving a user setting command to design the DB; a storage unit for storing a key-value DB designed according to the input user setting command; and a control unit designing the Key-Value DB by visualizing the big data in the shape of a table diagram according to the table base of the Key-Value DB according to the input user setting command. However, the control unit converts the big data into hash, list, set/sorted set, and hyperloglogs types, which are created in each table shape classified according to data type characteristics. Classified by data structure type (Type), a data structure is first drawn with at least one data structure type according to a user setting command, and the control unit determines the data characteristics between the respective data structures as a table having an independent business correlation between the tables. is expressed as a link type, which is a relational structure connecting the It may be to design a Key-Value DB.

Here, the first drawing of the data structure is performed by analyzing the big data to select data structure types such as Hash, List, Set/Sorted Set, and HyperLogLogs. The first drawing may be made by selecting one, and the table figure may be classified according to the characteristics of the data structure type.

In addition, the table figure of the Hash and Set/Sorted Set type data structure type is a rectangle, and the key written at the top and the value written at the bottom inside the figure are arranged in a straight bar ( Bar), but the bar of the data structure type table figure of the Set/Sorted Set type may be a dotted line.

In addition, the table figure of the data structure type of the List and HyperLogLogs type is a rectangle, and the key written at the top and the value written at the bottom inside the figure are a straight bar , but the outer corner of the list (List) table figure may be round, and the hyperlog outline may be a dotted line.

In addition, the control unit assigns the designed table diagram to a corresponding DB of a user-designated server with at least one of a domain name, a server name, and a DB name corresponding to a user business area in response to a user setting command, may be designing

And, the second feature of the present invention is provided in a key-value DB design information processing device for designing a key-value DB of large-capacity big data, and the key-value -Value) In the key-value DB design method of the control unit that processes the DB design, (a) the big data hash, list, set / sorted set, hyper First drawing a data structure by classifying it into one of data structure types of the log (HyperLogLogs) type and visualizing the big data in a table figure that classifies at least one of the data structure types according to a user setting command; (b) constructing a second data characteristic according to a user setting command by expressing the data characteristic between the respective data structures as a link type, which is a relational structure connecting tables having independent business correlation between tables; (c) generating a table diagram based on the second drawing operation; and (d) assigning the designed table diagram to the corresponding DB of the user-designated server with the domain name, server name, and DB name corresponding to the user's business area in correspondence with the user setting command, Value) may include a step of designing the DB.

Here, the table figure of the Hash and Set/Sorted Set type data structure type is a rectangle, and the key located at the top inside the figure and the value located at the bottom are arranged in a straight bar ( Bar), but the bar of the table figure of the data structure type of the set type is a dotted line, the outer edge of the list table figure is round, and the HyperLogLogs table figure The outline may be a dotted line.

The effects of the present invention for solving the above problems are as follows.

First, the present invention provides an information processing device and a DB design method having a unique notation that anyone can easily and conveniently analyze and design a key-value database, which is one of big data storage technologies.

Second, since the present invention can immediately create logical structures such as tables and indexes in a specific key-value database, a table diagram-based key-value DB capable of building a big data platform quickly Design information processing device and method are provided.

Third, the present invention provides a table diagram-based key-value DB design information processing device and method to enable efficient communication about key-value data structures between developers, designers, and DB operators. to provide.

Fourth, it is possible to build a high-quality big data storage platform through the present invention, and to provide a table diagram-based key-value DB design information processing device and method that can reduce maintenance costs after construction.

Fifth, the present invention is for reverse engineering analysis to collect and analyze the structure of a key-value database by marking the key-value data structure with symbols and figures that can be easily understood. Provides a very effective table diagram-based key-value DB design information processing device and method.

Sixth, since Key-Value DB, which is an unstructured data structure, is not standardized, information processing that can design Key-Value DB very easily and intuitively even if understanding of design technology is insufficient. An apparatus and method are provided.

1 is a diagram showing the block configuration of a table diagram-based key-value DB design information processing device according to an embodiment of the present invention.
2 is a diagram showing the flow of a key-value DB design method used in the table diagram-based key-value DB design information processing device 100 according to an embodiment of the present invention. to be.
3 is a diagram illustrating a DB design tool provided in a table diagram-based key-value DB design information processing device according to an embodiment of the present invention.
4 is a diagram illustrating a hash and list data model to which a table diagram-based key-value DB design method according to an embodiment of the present invention is applied.
5 is a diagram illustrating list-list and list-set data models to which a table diagram-based key-value DB design method according to an embodiment of the present invention is applied.

Specific structural or functional descriptions of the embodiments according to the concept of the present invention disclosed in this specification are only illustrated for the purpose of explaining the embodiments according to the concept of the present invention, and the embodiments according to the concept of the present invention These may be embodied in various forms and are not limited to the embodiments described herein.

Embodiments according to the concept of the present invention can apply various changes and can have various forms, so the embodiments are illustrated in the drawings and described in detail herein. However, this is not intended to limit the embodiments according to the concept of the present invention to specific disclosures, and includes modifications, equivalents, or substitutes included in the spirit and scope of the present invention.

Terms such as first or second may be used to describe various components, but the components should not be limited by the terms. The above terms are used only for the purpose of distinguishing one component from another component, for example, without departing from the scope of rights according to the concept of the present invention, a first component may be named a second component, Similarly, the second component may also be referred to as the first component.

It is understood that when an element is referred to as being "connected" or "connected" to another element, it may be directly connected or connected to the other element, but other elements may exist in the middle. It should be. On the other hand, when an element is referred to as “directly connected” or “directly connected” to another element, it should be understood that no other element exists in the middle. Expressions describing the relationship between components, such as "between" and "directly between" or "directly adjacent to" should be interpreted similarly.

Terms used in this specification are only used to describe specific embodiments, and are not intended to limit the present invention. Singular expressions include plural expressions unless the context clearly dictates otherwise. In this specification, terms such as "comprise" or "have" are intended to designate that the described feature, number, step, operation, component, part, or combination thereof exists, but one or more other features or numbers, It should be understood that the presence or addition of steps, operations, components, parts, or combinations thereof is not precluded.

Unless defined otherwise, all terms used herein, including technical or scientific terms, have the same meaning as commonly understood by one of ordinary skill in the art to which the present invention belongs. Terms such as those defined in commonly used dictionaries should be interpreted as having a meaning consistent with the meaning in the context of the related art, and unless explicitly defined in this specification, it should not be interpreted in an ideal or excessively formal meaning. don't

Hereinafter, embodiments will be described in detail with reference to the accompanying drawings. However, the scope of the patent application is not limited or limited by these examples. Like reference numerals in each figure indicate like elements.

1 is a diagram showing the block configuration of a table diagram-based key-value DB design information processing device according to an embodiment of the present invention.

As shown in FIG. 1, the table diagram-based Key-Value DB design system according to an embodiment of the present invention includes a Key-Value DB design information processing device 100, It may be configured to include an interworking server 200 that operates its own DB in conjunction with a table diagram designed by the key-value DB design information processing device 100.

Here, Key-Value Database (Key-Value Database) or Key-Value Store is the storage of associative arrays, which are data structures well known today as dictionaries and hashes. It is a data storage paradigm designed for data storage, retrieval, and management. A dictionary contains a table of objects or records, each containing a number of different fields, each containing data.

These records are stored and retrieved using a "key" that uniquely identifies the record and is used to quickly find data within a database (DB:DataBase). Key-value databases, represented as key-value pairs, are very different from the better-known relational databases (RDBs).

An RDB predefines the data structure in a database as a series of tables containing fields with well-defined data types. Datatypes allow numerous optimizations by exposing them to database programs. On the other hand, a key-value system treats data as a single opaque table, and each record can have different fields. It more closely follows modern concepts such as object-oriented programming and provides a great deal of flexibility. Because optional values are not represented by placeholders as in most databases, key-value databases often use much more memory for the same database storage, so under certain loads there may be significant performance gains. can That is, the Key-Value DB is a data storage highly optimized for applications that perform simple queries such as session information, user information, and relationship information.

The table diagram-based key-value DB design information processing device 100 according to an embodiment of the present invention includes user profile information, messages, personal setting data and themes, recommendations, and promotions for users of web applications. It is a device that designs a key-value DB by visualizing big data, such as all session data related to discounts and discounts, and billions of order data from e-commerce websites, in the form of table diagrams.

And, as shown in FIG. 1, the table diagram-based key-value DB design information processing device 100 corresponds to the user description command to the designed table diagram, and the domain name corresponding to the user's business area. Assign at least one of , server name, and DB name to the corresponding DB of the user-specified server.

The interlocking server 200 (200) can operate its own specific DB in conjunction with the table diagram assigned by the table diagram-based key-value DB design information processing device 100. Also, it may be a server that uses and manages big data such as all session data of web applications based on the table diagram.

The key-value DB design information processing device 100 according to the present invention shown in FIG. 1 includes a user interface unit 101 that receives a user setting command to design a key-value DB. And, a Key-Value DB storage unit 102 that stores a Key-Value DB designed according to the input user setting command, and a key-value DB storing big data according to the input user setting command -Value) It can be configured to include a control unit 103 that designs a key-value DB by visualizing it as a figure of a table diagram according to the table base of the DB.

More specifically, the user interface unit 101 provides various user setting commands for designing a Key-Value DB (e.g., user setting commands for designating data structures or user setting commands for designating data characteristics). command, field creation, user setting command, etc.) is provided. In addition, various user setting commands for designing a key-value DB using the provided key are received.

The Key-Value DB storage unit 102 stores a Key-Value DB designed according to a user setting command. In particular, under the control of the control unit 103, a key-value DB designed by visualizing a figure of a table diagram according to the present invention is stored.

In addition, according to the user setting command input through the control unit 103 and the user interface unit 101, the big data is visualized in the form of a table diagram according to the table base of the key-value DB, and the key-value Design (Key-Value) DB.

Here, visualization in the form of a table diagram is a hash, a list, a set/sorted set, and a hyperlog created by each table form classified according to the data type (Type) characteristic of the big data. (HyperLogLogs) type of data structure type (Type) to first construct a data structure with at least one data structure type according to a user setting command, and the control unit displays the data characteristics between each data structure in a table A table diagram is created based on the operation of second drawing the data characteristics according to a user setting command by expressing it as a link type, which is a relational structure that connects tables with independent work correlation between It may be to visualize the data in the table shape.

In addition, the display unit 104 displays a table diagram-based key-value DB design user interface according to the present invention in response to a user setting command under the control of the control unit 103.

The communication unit 105 communicates with various interworking servers 200 and is assigned by the table diagram-based key-value DB design information processing device 100 according to the embodiment of the present invention. ) to communicate with various interworking servers 200 that operate their own specific DB in conjunction with the table diagram.

As such, the table diagram-based Key-Value DB design information processing device 100 according to an embodiment of the present invention allows anyone to use a Key-Value database, which is one of big data storage technologies. A device that applies a unique notation that can be easily and conveniently analyzed and designed. A device that enables quick big data platform construction by immediately creating logical structures such as tables and indexes in a key-value DB. It provides a very effective device for reverse engineering in that the data structure of such a key-value DB is marked with symbols and figures that can be easily understood intuitively. can

2 is a diagram showing the flow of a key-value DB design method used in the table diagram-based key-value DB design information processing device 100 according to an embodiment of the present invention. to be.

As shown in FIG. 2, the table diagram-based Key-Value DB design method according to an embodiment of the present invention includes (a) big data as hashes, lists, and sets ( Set/Sorted Set), hyperlog (HyperLogLogs) type of data structure type (Type), according to the user-set command, the big data is visualized in a table figure that distinguishes at least one of the above data structure types, and the data structure A first drawing step (S100); (b) Expressing the data characteristics between the data structures as a link 60 (Link) type, which is a relational structure connecting tables having independent business correlation between tables, and drawing the data characteristics secondly according to a user setting command (S200); (c) generating a table diagram based on the second drawing operation (S300); and (d) assigning the designed table diagram to the corresponding DB of the user-designated server with the domain name, server name, and DB name corresponding to the user's business area in correspondence with the user setting command, Value) may include designing a DB (S400).

More specifically, an embodiment of the present invention is a method of visualizing big data as a figure of a table diagram according to a table base of a key-value DB, and may include a first drawing step and a second drawing step. there is.

The first drawing step is step (a), which divides big data into table-type hash, list, set/Sorted Set, and HyperLogLogs data structure types, and each This is the step of visualizing each data type as a table shape according to the characteristics of the data type. Here, the structure of each table figure divides the upper and lower ends with a bar in a rectangular box, the key value is marked at the top, and the value value and its attribute value are displayed at the bottom in the form of an array. has a structure denoted by

The hash table (100) shape is a data structure that stores data in (Key, Value), and has upper and lower parts that can clearly distinguish keys and values to suit the characteristics of a data structure that can quickly search for data. It is desirable to have a differentiated basic box-type structure, and in the case of a list, a list is also an ordered list and is an ordered data type structure like an array, and a set (Set/Sorted Set) is an ordered set or In that it is a data type structure and a probability data structure used to estimate the radix of a HyperLogLogs set, the object name (object name or table name) is written at the top and the elements are written at the bottom. It is desirable to be

In this first drawing step, a box-type table structure divided at the top and bottom is drawn in order to diagram the data structure having each characteristic of the big data table type into a figure, and each figure structure is divided into the shape of the outline and the top and bottom It is divided into the shape of a bar that divides the bottom so that it can be checked visually at a glance, and provides a notation that anyone can intuitively and easily understand the Key-Value database.

In the second drawing step, (b) step, the data characteristics between each data structure are expressed as a link 60 (Link) type, which is a relational structure connecting tables having independent business correlation between tables, according to a user setting command. This is the stage of constructing data characteristics. That is, when a correlation is formed by sharing at least one of the value data of the above-described data structure, each data table figure is connected with a line in order to intuitively and easily understand the relationship between them (link 60 ): Link) This is the stage of construction. The link 60 of the table figure of each data type can be performed by a user setting command through the user interface unit 101 .

Step (c) is a step of generating a table diagram of each data type of big data based on the above-described first and second drawing information, and step (d) is a user setting command for the designed table diagram. Correspondingly, this is a step of designing a Key-Value DB by assigning at least one of the domain name, server name, and DB name corresponding to the user's business area to the corresponding DB of the user-designated server. Then, the custom server operates its own specific DB in conjunction with the assigned table diagram.

Hereinafter, an example of a first construction and a second construction using the key-value DB design information processing device 100 will be described in detail with reference to the drawings.

3 is a diagram illustrating a DB design tool provided by the table diagram-based key-value DB design information processing device 100 according to an embodiment of the present invention.

As shown in FIG. 3, at the top left of the screen, table figures representing four data types or types for the first drawing are listed as examples, and at the top right, links 60 (Link) for the second drawing are displayed. , and at the center of the screen, the shapes and structures of different table figures of four data types are exemplified.

The hash table 100 has a rectangular box structure with upper and lower ends partitioned by bars, with object names and keys marked at the top and values at the bottom mark The outline 11 and the bar 15 are represented by solid lines, the list table 20 is represented by a rectangular soft box with four rounded corners, and the set/sorted set table 30 The outer line is a solid line, but the bar 35 is displayed as a dotted line to be distinguished from the hash table, and the HyperLogLogs table 40 displays the outer line 41 as a dotted line to distinguish data types.

Here, the shape of the outline is a similar table type and is applied in the sense of distinguishing the main and the sub, and the data type of the main and sub relationship is the shape of the outline of the hash table 10 and the list table 20. can indicate

In addition, the meaning of the solid line and the dotted line of the outline is to distinguish the case where the key is clearly defined or arbitrarily set, and the hash table 10 in which the key is clearly defined is a solid line, and the key ) is not clearly defined and arbitrarily set, the hyperlog table 40 is indicated by a dotted outline. And, the meaning of the solid line and the dotted line of the bar is to distinguish the characteristics of the relationship between the key and the value, and the set/sorted set table 30 is indicated by the dotted line.

As such, the table diagram-based key-value DB design information processing apparatus 100 and method according to an embodiment of the present invention transform big data into corresponding data types in the shape and structure of different table figures. A notation that enables anyone to easily and conveniently analyze and design a Key-Value DB by allowing each data type to be intuitively distinguished from a Key-Value database (DB) provides

4 is a diagram illustrating a hash and list data model to which a table diagram-based key-value DB design method according to an embodiment of the present invention is applied.

4 is a first drawing of a hash table 100 figure and a list table figure for big data related to product orders using a key-value DB design method according to an embodiment of the present invention. And it shows an example of generating a table diagram (Table Diagram) by second construction. [Object name: Key] is displayed at the upper part of the hash table 100, and value data for the corresponding key is listed at the lower part. For example, order number (order:201808010001) is the key, and information such as order date (order_date), customer name (customer_name), employee in charge (employee_id), and payment type (payment_type) Mark the value data at the bottom of the table figure.

The list (List) table 20 is a data structure in which order detail information is stored, and an order detail information number (order_detail: order_no) is written at the top, and order detail information content information is written with a corresponding value at the bottom. can For example, the order detail number (order_datail:order_no) is entered at the top of the list table, and the field (Filed) name such as order detail information such as order number (item_id), product number (product_id), and product name (product_name) is entered at the bottom. List them in the direction below. Data properties (String, Integer, Geo, etc.) can be written after the field name. Such a data structure can be created as an array structure in a key-value DB.

And, as shown in FIG. 4, the link 60 (Link) drawn by connecting the hash table and the list table with a line (second drawing) indicates that there is a certain relationship between each data structure, and product order Indicates the relationship with the order details of the same product as the information. The reason for this relationship can be seen that the order numbers (order_no) are the same. In addition, as the meaning of the hash table and the list table, it can be intuitively and quickly confirmed that the relationship between the main and the sub.

5 is a diagram illustrating list-list and list-set data models to which a table diagram-based key-value DB design method according to an embodiment of the present invention is applied.

5 is a first diagram of a list-list table figure and a list-set table figure for big data related to product orders using a key-value DB design method according to an embodiment of the present invention. 2 shows an example of creating a table diagram by drawing. In the main list table (20a), the order number (order_no) corresponding to the key is displayed at the top divided by a bar, and the field name is written sequentially downward as value data for the key at the bottom do. Write data properties (String, Integer, etc.) after the field name. For example, order number (order:201808010001) is the key, and order date (order_date), customer name (customer_name), employee in charge (employee_id), payment type (payment_type), etc. Write the value data of the information in the downward direction at the bottom of the table figure.

In addition, in FIG. 5, a sub list table 20b is created and linked 60 to the right centering on the above-described main list table 20a, and a hash table 10 is created downward to link 60 represents a table diagram.

As shown in FIG. 5, the sub list table 20b is a data structure in which order detail information is stored, and the order detail information number (order_detail: order_no) is described at the top, and the order detail information content with the corresponding value at the bottom information can be written. For example, the upper part of the main list table 20a creates an order detail number (order_datail:order_no), and the lower part corresponds to order details such as order number (item_id), product number (product_id), and product price (product_price). List the field names to be written in the downward direction. In addition, data properties (String, Integer, Geo, etc.) can be written after the field name, and such a data structure can be created as an array structure in a key-value DB.

In addition, in the Sorted Set table 30 located vertically below the main list table 20a, management staff information corresponding to the key is written at the top, and staff corresponding to the value at the bottom. Detailed information data is created by listing them at the bottom.

And, as shown in FIG. 5, it can be seen that the link 60 (Link) drawn by connecting the main list table 20a and the sub list table 20b with a line is table data having the same relationship with the product order number. There is, and the main list table 20a and the set (Set / Sorted Set) table 30 linked downward 60 can intuitively and quickly confirm that the management staff (employee) is the same relationship.

As such, in the embodiment of the present invention, table figures, which are data structures having at least one data type, are arranged, keys and values are created (first drawing), and displayed as a link 60 indicating a connection relationship with each other (Second drawing) The generated table diagram can identify data characteristics through table figures representing each data type, and the relationship between each table data is provided so that anyone can easily, quickly and intuitively understand the relationship between each table data through the link 60 (connection line). To provide a key-value DB design information processing device 100 and method having high performance and efficiency.

As described above, although the embodiments have been described with limited drawings, those skilled in the art can make various modifications and variations from the above description. For example, the described techniques may be performed in an order different from the method described, and/or the components of the described system, structure, device, circuit, etc. may be combined or combined in a different form than the method described, or other components may be used. Or even if it is replaced or substituted by equivalents, appropriate results can be achieved.

Therefore, other implementations, other embodiments, and equivalents of the claims are within the scope of the following claims.

100: information processing device
101: user interface unit
102: Key-Value DB storage unit
103: control unit
104: display unit
105: communication department
200: linked server

Claims (7)

A user interface unit that receives a user setting command to design a key-value DB; a storage unit for storing a key-value DB designed according to the input user setting command; and a control unit that designs the key-value DB by visualizing the big data in the form of a table diagram according to the table base of the key-value DB according to the input user setting command. but
Hash, List, Set/Sorted Set, and HyperLogLogs types of data structures in which the controller converts the big data into table shapes classified according to data type characteristics. Classifying into types and first constructing a data structure with at least one data structure type according to a user setting command,
Based on the operation of the control unit to secondly draw the data characteristics according to a user setting command by expressing the data characteristics between each data structure as a link type, which is a relationship structure that connects tables having independent business correlation between tables. By creating a table diagram,
Designing a key-value DB by visualizing the big data in the table shape,
In the first drawing of the data structure, the big data is analyzed to be one of the data structure types of Hash, List, Set/Sorted Set, and HyperLogLogs types. Select and draw a first drawing, but the table figure is divided according to the characteristics of the data structure type,
The control unit assigns the designed table diagram to a corresponding DB of a user-specified server with at least one of a domain name, a server name, and a DB name corresponding to a user business area in response to a user setting command, designing the DB,
The table figure of the Hash and Set/Sorted Set type data structure type is a rectangle. divided into,
The bar of the table figure of the set type data structure type is a dotted line, the outer corner of the table figure of the list type data type structure is round, and the HyperLogLogs type data Table diagram-based key-value DB design information processing device, characterized in that the outline of the table figure of the type structure is a dotted line.
delete delete delete delete It is provided in a key-value DB design information processing device that designs a key-value DB with large-capacity big data, and a control unit that processes the key-value DB design. In the key-value DB design method,
(a) Classifying the big data into one of the data structure types of Hash, List, Set/Sorted Set, and HyperLogLogs, and following a user-set command first drawing a data structure by visualizing it as a table figure that classifies at least one of the data structure types;
(b) second drawing the data characteristics according to a user setting command by expressing the data characteristics between each data structure as a link type, which is a relational structure connecting tables having independent business correlation between tables;
(c) generating a table diagram based on the second drawing operation; and
(d) Assign the designed table diagram to the corresponding DB of the user-designated server with the domain name, server name, and DB name corresponding to the user's business area in accordance with the user setting command, ) designing a DB;
The table figure of the Hash and Set/Sorted Set type data structure type is a rectangle. divided into,
The bar of the table figure of the set type data structure type is a dotted line, the outer corner of the table figure of the list type data type structure is round, and the HyperLogLogs type data A key-value DB design method used in a table diagram-based key-value DB design information processing device, characterized in that the outline of the table figure of the type structure is a dotted line. delete

Images