CN111427865A - Method and device for managing objects of database - Google Patents
Method and device for managing objects of database Download PDFInfo
- Publication number
- CN111427865A CN111427865A CN202010191101.7A CN202010191101A CN111427865A CN 111427865 A CN111427865 A CN 111427865A CN 202010191101 A CN202010191101 A CN 202010191101A CN 111427865 A CN111427865 A CN 111427865A
- Authority
- CN
- China
- Prior art keywords
- directed
- graph
- objects
- database
- information
- 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.)
- Withdrawn
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/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/901—Indexing; Data structures therefor; Storage structures
- G06F16/9024—Graphs; Linked lists
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)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the application discloses a method and a device for managing objects of a database. The method comprises the following steps: acquiring objects of a database and referenced information among the objects; determining a directed relation graph of the objects of the database according to the referenced information among the objects, wherein nodes in the directed relation graph represent the objects of the database, and directed connection lines among the nodes are the referenced relation among the objects; and managing the object information of the database according to the directed relational graph.
Description
Technical Field
The present disclosure relates to the field of information processing, and more particularly, to a method and apparatus for managing objects of a database.
Background
The database is the core of an organization for information management automation, particularly, the relational database is used most, the relational database model is used for reducing a complex data structure into a simple binary relation, and the operation on data is almost completely established on one or more relational tables, however, with the arrival of a big data era, a data warehouse is slowly converted into a distributed architecture, and the complexity of a service is added, so that a database manager has more problems when using database objects.
In the related art, the data table relationship may be recorded by creating a relationship graph. For example, when a system architecture is made, entities in the system and relationships between the entities are abstracted by an Entity-Relationship Diagram (ER), so as to help a database manager analyze data table relationships; or analyzing complex data table relationships by a method of deriving data table relationships from a database in reverse.
In addition, in the related technology, an ER table is not needed to be used, and a data table relation based on the service is established.
In practical applications, the above-mentioned manner of maintaining the relationship of the management data table still needs to further reduce the learning cost and the management cost.
Disclosure of Invention
In order to solve any technical problem, embodiments of the present application provide a method and an apparatus for managing objects of a database.
To achieve the object of the embodiment of the present application, an embodiment of the present application provides a method for managing objects of a database, including:
acquiring objects of a database and referenced information among the objects;
determining a directed relation graph of the objects of the database according to the referenced information among the objects, wherein nodes in the directed relation graph represent the objects of the database, and directed connection lines among the nodes are the referenced relation among the objects;
and managing the object information of the database according to the directed relational graph.
An apparatus for managing objects of a database, comprising:
the acquisition module is used for acquiring objects of the database and referenced information among the objects;
the determining module is used for determining a directed relation graph of the objects of the database according to the referenced information among the objects, wherein nodes in the directed relation graph represent the objects of the database, and directed connecting lines among the nodes are referenced relations among the objects;
and the management module is used for managing the object information of the database according to the directed relational graph.
A storage medium having a computer program stored therein, wherein the computer program is arranged to perform the method as described above when executed.
An electronic device comprising a memory having a computer program stored therein and a processor arranged to execute the computer program to perform the method as described above.
One of the above technical solutions has the following advantages or beneficial effects:
the method comprises the steps of obtaining objects of a database and quoted information among the objects, determining a directed relational graph of the objects of the database according to the quoted information among the objects, managing the object information of the database according to the directed relational graph, accurately locating data in the database, and reducing management cost and learning cost.
Additional features and advantages of the embodiments of the application will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by the practice of the embodiments of the application. The objectives and other advantages of the embodiments of the application may be realized and attained by the structure particularly pointed out in the written description and claims hereof as well as the appended drawings.
Drawings
The accompanying drawings are included to provide a further understanding of the embodiments of the present application and are incorporated in and constitute a part of this specification, illustrate embodiments of the present application and together with the examples of the embodiments of the present application do not constitute a limitation of the embodiments of the present application.
FIG. 1 is a flow chart of a method for managing objects of a database provided by an embodiment of the present application;
fig. 2 is a schematic processing diagram of object information of a database according to an embodiment of the present disclosure;
fig. 3 is a block diagram of an apparatus for managing objects of a database according to an embodiment of the present application.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present application more apparent, the embodiments of the present application will be described in detail below with reference to the accompanying drawings. It should be noted that, in the embodiments of the present application, features in the embodiments and the examples may be arbitrarily combined with each other without conflict.
In the process of implementing the present application, the inventor analyzes the related art, and finds that the problem of the related art that the learning cost and the management cost are too high is due to the following reasons, and the specific analysis is as follows:
the problem with ER graphs and the derivation of data relational tables from databases in reverse is that: the analysis of the referred relation between the objects in the database is only limited to the data table, the types of the database objects are various, and clear analysis cannot be given to the relation between the non-data table objects and the data table; the ER diagram analysis data table relation still needs to be manually analyzed by a database manager, automation is not achieved, and the database manager cannot be helped to directly locate a specific data table; the method of deriving the data table relationship from the database in the reverse direction still requires a large operation cost, and the analysis result cannot be automatically saved.
The problem of the method for constructing the data relation table based on the service is that: a visual operation interface is not provided for the data table merging operation, and a large amount of operation cost is still needed; relationship combing is still limited to relationships between data tables, while no combing method is given for referenced relationships of other database objects.
Based on the analysis, the directed relational graph is generated by utilizing the referred relation among the objects in the database, so that the referred relation among the objects in the database can be quickly combed and stored, database management personnel can quickly acquire the referred relation among the objects in the database without looking at codes, data in the database can be accurately positioned, and management cost and learning cost are reduced.
Fig. 1 is a flowchart of a method for managing objects of a database according to an embodiment of the present application. As shown in fig. 1, the method includes:
in an exemplary embodiment, after the data source is configured, a communication connection is established with the configured data source, the data source is connected to a database corresponding to the data source, and object information in the database and referenced information between objects are obtained. The database objects that need to be manipulated can be determined by direct localization or by semantic search. When the obtaining operation is carried out, the referenced information between the objects can be classified by the database, so that the selection of the specific object and the specific object relation is convenient.
in an exemplary embodiment, the directed relationship graph includes at least two nodes, each node corresponds to an object in the database, and nodes having a referenced relationship are connected by a directed connection line, wherein the direction of the directed connection line indicates the referenced relationship of the two objects. For example, node a and node B correspond to object 1 and object 2, respectively, where object 1 references object 2, and then in the directed graph, node a and node are connected by a connecting line with an arrow, where the connecting line points from node a to node B.
In an exemplary embodiment, a processing tool in the related art can be controlled to generate a directed relationship graph by using the obtained object information and the referenced information, so that the processing efficiency is improved.
And 103, managing the object information of the database according to the directed relational graph.
In an exemplary embodiment, by means of the information of the referenced relationship between the objects and the objects displayed in the directed relationship graph, the position of the object and the information between the object and other objects are conveniently located, the management cost is increased, and the learning cost of a manager is reduced.
According to the method provided by the embodiment of the application, the objects of the database and the referenced information among the objects are obtained; and determining a directed relation graph of the objects of the database according to the quoted information among the objects, and managing the object information of the database according to the directed relation graph, so that the data in the database is accurately positioned, and the management cost and the learning cost are reduced.
The method provided by the embodiments of the present application is explained as follows:
in one exemplary embodiment, the nodes in the directed relationship graph can perform at least one of the following node control operations on the adjacent nodes and directed connection lines connected thereto, including:
extending all referenced relationships of the object upward;
shrink all referenced relationships of the object upward;
extending all reference relations of the object downwards;
shrink all reference relationships of the object downward;
the managing the object information of the database according to the directed relationship graph comprises:
after receiving a selection request of a node, acquiring a control operation of the selected node;
and executing corresponding control operation on the selected node according to the control operation.
Wherein the common operation of each object can be upward extension, upward contraction, downward extension, and downward contraction, wherein: the contents of upward expansion and upward contraction are all referenced relationships of the object, and the contents of downward expansion and downward contraction are all referenced relationships of the object. Wherein, the number of layers of the spreading operation can define the maximum number of spreading layers in advance.
After receiving a request for viewing information of an object, determining position information of a node of the object in a directed relationship graph, selecting the node, viewing the object referring to the object and/or the information of the object referred to by the node according to content to be viewed, and in the viewing process, contracting or expanding the display of other nodes connected with the node according to the display requirement of a user.
By setting the contraction or extension of the nodes, the referenced relation among the objects of the selected nodes is conveniently displayed.
When at least two objects are viewed, the other nodes connected with the nodes corresponding to the objects can be contracted or expanded according to the size of the current display area.
And when the distance of the selected objects in the display area accords with the preset long-distance judgment condition, the nodes of other objects between the selected objects are contracted, and when the distance of the selected objects in the display area accords with the preset short-distance judgment condition, the nodes of other objects between the selected objects are expanded.
By setting the contraction or extension of the nodes, when at least two displayed objects are displayed, on the premise of ensuring that all selected contents are displayed, irrelevant information in the display area is simplified, and the display effect is optimized.
In an exemplary embodiment, the managing object information of the database according to the directed relationship graph includes:
generating a relation set graph of the business according to the object information of the business in the directed relation graph;
if receiving an update request for the object information in the service and/or the referred relation between the objects, outputting a relation information graph of the service;
and adjusting the content in the relationship information graph according to the updating request to obtain an updated relationship information graph.
After the directed relation graph is obtained, an object matched with the service can be selected according to the service content, a relation set graph corresponding to the service is generated, and the relation set graph is stored according to the identification information of the service.
When a relation set graph is used, the attributes owned by the object and the operations capable of being executed are displayed around the nodes of the relation set graph, wherein the attributes and the operations include field display of a data table, data addition and deletion, check, and calling of a storage process. The data objects affected by each operation are stored as historical operations, and the affected data objects themselves can be displayed as a relationship set for a database manager to view the storage and the like.
If the update request of the object information and/or the referred relation of the service is received and the relation set graph of the service is changed, the corresponding relation set graph is searched according to the identification information of the service, and the relation set graph is adjusted to realize the dynamic maintenance of the relation set graph.
By dynamically maintaining the relation set diagram corresponding to the service, the consistency of the recorded relation set diagram and the service information can be ensured, and the accuracy of the information is improved.
In an exemplary embodiment, the nodes in the directed relational graph comprise at least two node icons, wherein each node icon corresponds to an object of one type of database, and/or at least two connecting line icons, wherein each connecting line icon corresponds to relational information of one type of database;
the nodes in the directed relation graph can hide adjacent nodes and directed connecting lines connected with the nodes;
the managing the object information of the database according to the directed relationship graph comprises:
receiving a selection request for the type of a node icon and/or a connecting line icon in the directed relationship graph;
screening the contents in the directed relationship graph according to the selected type in the selection request to obtain the selected contents;
hiding the non-screened content in the directed relationship graph.
The selectively hidden contents are a kind of relationship or a certain relationship.
Objects in the database include class names, table semantics, table fields, table masters, foreign keys, view fields, statement sets that store procedures, and the like. Objects in the database may be classified and represented by different nodes. The primary classification of objects in the database includes: data tables, indexes, views, stored procedures, functions, users, etc. The primary classification objects can be subdivided, for example, the data table can be divided into a main table, a secondary table and the like; the views may be divided into single source table views, multi-source table views, etc. The display mode of the objects in the database can be displayed according to the classification level, or can be displayed according to the letter sorting list, and the like; one or more objects may be added to the main operation panel by means of dragging, button operation, or the like.
Each piece of referenced relationship information in the database can be marked by the classification name of the relationship and the objects at the two ends of the relationship. The referenced relationships may be represented by different connecting lines. The referenced relationships between database objects include at least one of the following categories, including: the master-slave relation between the data tables, the foreign key relation between the data tables, the calling relation between the storage process and the data tables, the nesting relation between the storage process and the storage process, the authority relation between the user and the database object and the like. When identifying the referenced relationship between the objects, it is also necessary to label the relationship between the objects as a homologous data table relationship or a heterologous data table relationship, so as to provide a reference for subsequent use.
The specific objects of one or more types can be screened according to the classification information, and/or the referenced information of one or more types can be screened, so that the screening and analysis of the information are facilitated.
The number of the irrelevant information of the display area can be increased and the display effect can be optimized by controlling the unselected content to hide.
The method provided by the embodiments of the present application is explained as follows:
fig. 2 is a schematic processing diagram of object information of a database according to an embodiment of the present application. As shown in fig. 2, the processing steps include:
1. acquiring object information of a database;
after the data source is configured, communication connection is established with the configured data source, the data source is connected to a database corresponding to the data source, and all object information in the database is acquired. The database objects that need to be manipulated can be determined by direct localization or by semantic search. When the obtaining operation is carried out, the referenced information between the objects can be classified by the database, so that the selection of the specific object and the specific object relation is convenient.
2. Outputting a directed relation graph of the object information of the database by using a preset graph display tool;
adding database objects to a main operation panel, calling a Cytoscape tool to output directed relationships, processing referenced relationship information among the database objects by using the Cytoscape tool, displaying a directed relationship diagram of the database objects, and finishing relationship combing.
Wherein the common operation of each object is upward extension, upward contraction, downward extension, downward contraction, selective hiding, wherein: the contents of upward extension and upward contraction are all referenced relations of the object, the contents of downward extension and downward contraction are all referenced relations of the object, and the selectively hidden contents are a class relation or a certain relation. Wherein, the layer number of the spreading operation can define the maximum spreading layer number.
3. According to preset service information, the relationship of the objects in the database is combed;
the database manager performs a relationship combing operation on the database object according to a service or a series of services, and then stores the database object as a relationship set. The existing relation sets can be edited and saved again, or one or more existing relation sets are added to the main operation panel and edited again to generate a new relation set. The relation set can be stored in a graph database, the operations of dynamic addition and deletion, multi-order query, depth traversal, breadth traversal and the like of the incidence relation can be effectively supported, and the data storage problem of the complex incidence relation is effectively solved; or can be stored in a relational database to realize the relation through operations such as classification, combination, connection or selection
The referencing object and referenced relationships can be viewed through the use of the call commands, including:
sys.sql_expression_dependencies；
sys.dm_sql_referencing_entities；
sys.sql_modules。
referenced objects and reference relationships can be viewed through the use of call commands, including:
sys.sql_expression_dependencies；
sys.dm_sql_referenced_entities。
the technical scheme of the invention has the following beneficial effects: the database manager is effectively helped to comb the referred relation among the objects in the database, and the operation cost is reduced; the database manager is effectively helped to operate data quickly, and the management cost is reduced; the complexity of database management handover work is effectively solved, and the learning cost is reduced.
Fig. 3 is a block diagram of an apparatus for managing objects of a database according to an embodiment of the present application. As shown in fig. 3, the apparatus includes:
the acquisition module is used for acquiring objects of the database and referenced information among the objects;
the determining module is used for determining a directed relation graph of the objects of the database according to the referenced information among the objects, wherein nodes in the directed relation graph represent the objects of the database, and directed connecting lines among the nodes are referenced relations among the objects;
and the management module is used for managing the object information of the database according to the directed relational graph.
In an exemplary embodiment, the nodes in the directed relationship graph determined by the determining module can perform at least one of the following node control operations on the adjacent nodes and the directed connection lines connected thereto, including:
extending all referenced relationships of the object upward;
shrink all referenced relationships of the object upward;
extending all reference relations of the object downwards;
shrink all reference relationships of the object downward;
wherein, the management module comprises:
the device comprises an acquisition unit, a selection unit and a control unit, wherein the acquisition unit is used for acquiring control operation on a selected node after receiving a selection request on the node;
and the execution unit is used for executing corresponding control operation on the selected node according to the control operation.
In one exemplary embodiment, the management module includes:
a generating unit, configured to generate a relationship set graph of the service according to object information of the service in the directed relationship graph;
the output unit is used for outputting a relation information graph of the business if receiving an updating request for the object information in the business and/or the referred relation between the objects;
and the adjusting unit is used for adjusting the content in the relationship information graph according to the updating request to obtain an updated relationship information graph.
In an exemplary embodiment, the nodes in the directed relationship graph determined by the determining module include at least two node icons, wherein each node icon corresponds to an object of one database, and/or include at least two connecting line icons, wherein each connecting line icon corresponds to relationship information of one database;
the nodes in the directed relation graph can hide adjacent nodes and directed connecting lines connected with the nodes;
the management module comprises:
a receiving unit, configured to receive a selection request for a type of a node icon and/or a connection line icon in the directed relationship graph;
the screening unit is used for screening the contents in the directed relationship graph according to the selected type in the selection request to obtain the selected contents;
and the hiding unit is used for hiding the non-screened contents in the directed relational graph.
The device provided by the embodiment of the application,
a storage medium having a computer program stored therein, wherein the computer program is arranged to perform any of the methods described above when executed.
An electronic device comprising a memory having a computer program stored therein and a processor arranged to run the computer program to perform the method of any of the above.
It will be understood by those of ordinary skill in the art that all or some of the steps in the apparatus, systems, functional modules/units in the apparatus disclosed above may be implemented as software, firmware, hardware, and suitable combinations thereof. In a hardware implementation, the division between functional modules/units mentioned in the above description does not necessarily correspond to the division of physical components; for example, one physical component may have multiple functions, or one function or step may be performed by several physical components in cooperation. Some or all of the components may be implemented as software executed by a processor, such as a digital signal processor or microprocessor, or as hardware, or as an integrated circuit, such as an application specific integrated circuit. Such software may be distributed on computer readable media, which may include computer storage media (or non-transitory media) and communication media (or transitory media). The term computer storage media includes volatile and nonvolatile, removable and non-removable media implemented in any device or technology for storage of information such as computer readable instructions, data structures, program modules or other data as is known to one of ordinary skill in the art. Computer storage media includes, but is not limited to, RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, Digital Versatile Disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to store the desired information and which can accessed by a computer. In addition, communication media typically embodies computer readable instructions, data structures, program modules or other data in a modulated data signal such as a carrier wave or other transport mechanism and includes any information delivery media as known to those skilled in the art.
Claims (10)
1. A method of managing objects of a database, comprising:
acquiring objects of a database and referenced information among the objects;
determining a directed relation graph of the objects of the database according to the referenced information among the objects, wherein nodes in the directed relation graph represent the objects of the database, and directed connection lines among the nodes are the referenced relation among the objects;
and managing the object information of the database according to the directed relational graph.
2. The method of claim 1, wherein:
the nodes in the directed relation graph can perform at least one node control operation on the adjacent nodes and the directed connection lines connected with the nodes, and the node control operation comprises the following steps:
extending all referenced relationships of the object upward;
shrink all referenced relationships of the object upward;
extending all reference relations of the object downwards;
shrink all reference relationships of the object downward;
the managing the object information of the database according to the directed relationship graph comprises:
after receiving a selection request of a node, acquiring a control operation of the selected node;
and executing corresponding control operation on the selected node according to the control operation.
3. The method according to claim 1, wherein the managing object information of the database according to the directed relationship graph comprises:
generating a relation set graph of the business according to the object information of the business in the directed relation graph;
if receiving an update request for the object information in the service and/or the referred relation between the objects, outputting a relation information graph of the service;
and adjusting the content in the relationship information graph according to the updating request to obtain an updated relationship information graph.
4. The method of claim 1, wherein:
the nodes in the directed relational graph comprise at least two node icons, wherein each node icon corresponds to an object of one database, and/or at least two connecting line icons, wherein each connecting line icon corresponds to relational information of one database;
the nodes in the directed relation graph can hide adjacent nodes and directed connecting lines connected with the nodes;
the managing the object information of the database according to the directed relationship graph comprises:
receiving a selection request for the type of a node icon and/or a connecting line icon in the directed relationship graph;
screening the contents in the directed relationship graph according to the selected type in the selection request to obtain the selected contents;
hiding the non-screened content in the directed relationship graph.
5. An apparatus for managing objects of a database, comprising:
the acquisition module is used for acquiring objects of the database and referenced information among the objects;
the determining module is used for determining a directed relation graph of the objects of the database according to the referenced information among the objects, wherein nodes in the directed relation graph represent the objects of the database, and directed connecting lines among the nodes are referenced relations among the objects;
and the management module is used for managing the object information of the database according to the directed relational graph.
6. The apparatus of claim 5, wherein:
the node in the directed relation graph determined by the determining module can perform at least one of the following node control operations on the adjacent nodes and the directed connection lines connected with the node, and the node control operations comprise:
extending all referenced relationships of the object upward;
shrink all referenced relationships of the object upward;
extending all reference relations of the object downwards;
shrink all reference relationships of the object downward;
wherein, the management module comprises:
the device comprises an acquisition unit, a selection unit and a control unit, wherein the acquisition unit is used for acquiring control operation on a selected node after receiving a selection request on the node;
and the execution unit is used for executing corresponding control operation on the selected node according to the control operation.
7. The apparatus of claim 5, wherein the management module comprises:
a generating unit, configured to generate a relationship set graph of the service according to object information of the service in the directed relationship graph;
the output unit is used for outputting a relation information graph of the business if receiving an updating request for the object information in the business and/or the referred relation between the objects;
and the adjusting unit is used for adjusting the content in the relationship information graph according to the updating request to obtain an updated relationship information graph.
8. The apparatus of claim 5, wherein:
the nodes in the directed relational graph determined by the determining module comprise at least two node icons, wherein each node icon corresponds to an object of a database, and/or at least two connecting line icons, wherein each connecting line icon corresponds to relational information of a database;
the nodes in the directed relation graph can hide adjacent nodes and directed connecting lines connected with the nodes;
the management module comprises:
a receiving unit, configured to receive a selection request for a type of a node icon and/or a connection line icon in the directed relationship graph;
the screening unit is used for screening the contents in the directed relationship graph according to the selected type in the selection request to obtain the selected contents;
and the hiding unit is used for hiding the non-screened contents in the directed relational graph.
9. A storage medium, in which a computer program is stored, wherein the computer program is arranged to perform the method of any of claims 1 to 4 when executed.
10. An electronic device comprising a memory and a processor, wherein the memory has stored therein a computer program, and wherein the processor is arranged to execute the computer program to perform the method of any of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010191101.7A CN111427865A (en) | 2020-03-18 | 2020-03-18 | Method and device for managing objects of database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010191101.7A CN111427865A (en) | 2020-03-18 | 2020-03-18 | Method and device for managing objects of database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111427865A true CN111427865A (en) | 2020-07-17 |
Family
ID=71548088
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010191101.7A Withdrawn CN111427865A (en) | 2020-03-18 | 2020-03-18 | Method and device for managing objects of database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111427865A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112380286A (en) * | 2020-11-17 | 2021-02-19 | 平安科技（深圳）有限公司 | Method, device, equipment and medium for generating data object relation map of database |
| CN111737323B (en) * | 2020-08-14 | 2021-03-16 | 支付宝(杭州)信息技术有限公司 | Information query method and device based on block chain and electronic equipment |
| CN112711629A (en) * | 2020-12-30 | 2021-04-27 | 浙江中控技术股份有限公司 | Data and associated data import and export method, device, equipment and storage medium |
| CN114595231A (en) * | 2022-03-15 | 2022-06-07 | 苏州峰之鼎信息科技有限公司 | Database table generation method and device, electronic equipment and storage medium |
| CN114968348A (en) * | 2022-05-26 | 2022-08-30 | 中国平安人寿保险股份有限公司 | Data analysis method and device, electronic equipment, storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030154204A1 (en) * | 2002-01-14 | 2003-08-14 | Kathy Chen-Wright | System and method for a hierarchical database management system for educational training and competency testing simulations |
| WO2017186774A1 (en) * | 2016-04-26 | 2017-11-02 | Pilab S.A. | Systems and methods for querying databases |
| CN110795453A (en) * | 2019-10-22 | 2020-02-14 | 中国西安卫星测控中心 | Method for automatically constructing RDF (remote data format) based on relational database |
-
2020
- 2020-03-18 CN CN202010191101.7A patent/CN111427865A/en not_active Withdrawn
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030154204A1 (en) * | 2002-01-14 | 2003-08-14 | Kathy Chen-Wright | System and method for a hierarchical database management system for educational training and competency testing simulations |
| WO2017186774A1 (en) * | 2016-04-26 | 2017-11-02 | Pilab S.A. | Systems and methods for querying databases |
| CN110795453A (en) * | 2019-10-22 | 2020-02-14 | 中国西安卫星测控中心 | Method for automatically constructing RDF (remote data format) based on relational database |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111737323B (en) * | 2020-08-14 | 2021-03-16 | 支付宝(杭州)信息技术有限公司 | Information query method and device based on block chain and electronic equipment |
| CN112380286A (en) * | 2020-11-17 | 2021-02-19 | 平安科技（深圳）有限公司 | Method, device, equipment and medium for generating data object relation map of database |
| CN112380286B (en) * | 2020-11-17 | 2022-03-18 | 平安科技（深圳）有限公司 | Method, device, equipment and medium for generating data object relation map of database |
| CN112711629A (en) * | 2020-12-30 | 2021-04-27 | 浙江中控技术股份有限公司 | Data and associated data import and export method, device, equipment and storage medium |
| CN114595231A (en) * | 2022-03-15 | 2022-06-07 | 苏州峰之鼎信息科技有限公司 | Database table generation method and device, electronic equipment and storage medium |
| CN114595231B (en) * | 2022-03-15 | 2024-02-27 | 苏州峰之鼎信息科技有限公司 | Database table generation method and device, electronic equipment and storage medium |
| CN114968348A (en) * | 2022-05-26 | 2022-08-30 | 中国平安人寿保险股份有限公司 | Data analysis method and device, electronic equipment, storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111427865A (en) | Method and device for managing objects of database | |
| US12248515B2 (en) | Resource dependency system and graphical user interface | |
| EP0647909B1 (en) | Information catalog system with object-dependent functionality | |
| US8543943B2 (en) | Methods and systems for entering object assignments | |
| US8250532B2 (en) | Efficient development of configurable software systems in a large software development community | |
| WO2006059240A2 (en) | User interface for complex process inplementation | |
| CN112286601B (en) | User interface display method and device | |
| CN116662441B (en) | A Distributed Data Lineage Construction and Representation Method | |
| CN109033157B (en) | Complex data retrieval method and system based on user-defined search condition tree | |
| CN112364084A (en) | Visual data processing method and system for in-depth customization algorithm integration | |
| US9760603B2 (en) | Method and system to provide composite view of data from disparate data sources | |
| CN112416923A (en) | Metadata management method and device, equipment and storage medium | |
| CN119719048B (en) | Dynamic management method for tree structure data based on node level attribute and recursion update | |
| CN114969261A (en) | Data query method and device based on artificial intelligence, electronic equipment and medium | |
| CN109800069B (en) | Method and device for realizing data management | |
| CN117215582A (en) | Visual customization method, device and medium for industrial Internet application | |
| CN111126961A (en) | Complex product full life cycle digital mainline service system | |
| CN113434585B (en) | Resource preservation method and equipment | |
| CN110727729A (en) | Method and device for realizing intelligent operation | |
| CN113934801A (en) | Data blood relationship processing method and device and electronic equipment | |
| US12189602B2 (en) | Methods and systems for connecting data with non-standardized schemas in connected graph data exchanges | |
| CN112860725A (en) | SQL automatic generation method and device, storage medium and electronic equipment | |
| CN108399188B (en) | Universal establishing and processing method for strong service object based on type metadata | |
| US10990255B1 (en) | Hierarchical data display | |
| CN117235172A (en) | An interactive method and device that integrates data analysis flow and visualization system construction |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WW01 | Invention patent application withdrawn after publication | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20200717 |