CN115687288A

CN115687288A - Information display method and corresponding equipment

Info

Publication number: CN115687288A
Application number: CN202110836826.1A
Authority: CN
Inventors: 杨少兵; 凌云; 罗标; 何国平
Original assignee: Huawei Cloud Computing Technologies Co Ltd
Current assignee: Huawei Cloud Computing Technologies Co Ltd
Priority date: 2021-07-23
Filing date: 2021-07-23
Publication date: 2023-02-03

Abstract

The application discloses an information display method, which comprises the following steps: in response to a first instruction indicating that a difference of a first version relative to a second version is displayed, obtaining difference information of the first version of a logical model of a database relative to the second version of the logical model; and generating a target interface and displaying the target interface. In this embodiment, the difference information included in the target interface is obtained by rendering based on the display interface of the first version, so that the difference information can be presented based on the presentation mode of the display interface of the first version, which is convenient for a user to intuitively view the change condition between different versions of the logic model on the basis of the display interface of the first version of the logic model.

Description

Information display method and corresponding equipment

Technical Field

The application relates to the technical field of databases, in particular to an information display method and corresponding equipment.

Background

In the processes of design development and application of a database, version iteration is often required to be performed on a logic model in the database, and therefore each iteration version for the logic model is generated. At present, the change information of the logic model is difficult to record, so that related personnel are difficult to conveniently know the change condition of the database.

Disclosure of Invention

The embodiment of the application provides an information display method, which is used for solving the problem that related personnel cannot conveniently know the change condition of a database. The embodiment of the application also provides a corresponding device, a computer readable storage medium, a computer program product and the like.

A first aspect of the present application provides an information display method, including: acquiring difference information of a first version of a logic model of a database relative to a second version of the logic model in response to a first instruction, wherein the first instruction is used for indicating that the difference of the first version relative to the second version is displayed, and the logic model is used for describing a data structure of the database; generating a target interface, wherein the difference information included in the target interface is obtained by rendering based on the display interface of the first version; and displaying the target interface.

The information display method provided by the first aspect may be applied to a computer device including a display device to display a target interface through the display device. The computer device may be a server, a terminal device, a Virtual Machine (VM), or a container (container). The computer equipment can be provided with a database design program, and a user creates and designs a logic model for the database in a visual mode on a front-end interface of the database design program. The data structure of the database may be described in the logical model by a table, tree structure, or graph structure. The number of the second versions of the logical model may be one or more. If the number of the second versions is multiple, the difference information of the first version of the logical model of the database relative to each second version of the logical model can be obtained, and the difference information of the first version relative to each second version is displayed in the target interface. In the present application, a plurality includes two or more, and may be described as at least two. The first version and the second version may be determined based on the first instruction, for example, the first instruction may carry a first identifier of the first version and a second identifier of the second version, or the first instruction may carry the first identifier of the first version and take a last version of the first version as the second version.

Since the first version of the display interface may visually display the logical model, the difference information included in the target interface is obtained by rendering based on the first version of the display interface, and the difference information may be visually displayed to the user on the target interface based on the first version of the display interface. The layout and rendering method of the difference information on the target interface can be obtained based on the layout and rendering method of the first version of the display interface, so that the display manner of the difference information in the target interface is similar to the display manner of the corresponding information of the difference information in the first version of the display interface.

As can be seen from the above, in the first aspect, the difference information included in the target interface is obtained by rendering based on the display interface of the first version, so that the difference information can be presented based on the presentation manner of the display interface of the first version, which is convenient for a user to intuitively view a change situation between different versions of the logical model on the basis of the display interface of the first version of the logical model.

In a possible implementation manner of the first aspect, the difference type corresponding to the difference information includes one or more of a deletion type, a modification type, and a new addition type, and the display manners of the difference information corresponding to different difference types in the target interface are different.

In this possible implementation manner, if different difference types exist in the difference information, the difference information corresponding to the different difference types may be highlighted in different display manners, so that a user can conveniently identify specific change conditions corresponding to different operations, such as deletion, addition, modification and the like of the first version relative to the second version in the target interface.

In a possible implementation manner of the first aspect, if the difference type corresponding to the difference information includes a modification type, in the target interface, the difference information corresponding to the modification type in the first version is displayed in a first display manner, the difference information corresponding to the modification type in the second version is displayed in a second display manner, and the first display manner is different from the second display manner.

In this possible implementation, if there is modified content in the first version relative to the second version, then the modified content may have pre-modified content and post-modified content in the first version and the second version, respectively. Different display modes are adopted for displaying the content before modification and the content after modification on the target interface, so that a user can clearly see the evolution process of the modified content between the first version and the second version, and the specific situation of version change can be intuitively known.

In a possible implementation manner of the first aspect, the first instruction is triggered by a user on a first interface of the database design program, the first version is a version displayed in the first interface, and the second version is a previous version relative to the version displayed in the first interface.

In this possible implementation manner, the first interface may be a certain design interface for the logic model in the database design program, and the user may trigger the first instruction by clicking a designated key on the design interface, so that the change condition of the current version relative to the previous version can be conveniently checked through the target interface in the process of designing the logic model, and the current design process can be known in detail. Alternatively, the first interface may also be an interface for submitting model reviews in the database design program. Before submitting the version of the logic model displayed in the first interface to the auditing node, a user can trigger a first instruction in the interface for submitting auditing to indicate the database design program to display the difference of the version displayed in the first interface relative to the previous version of the displayed version, so that the user can conveniently look up the changed part in the iteration of the version through a target interface before submitting auditing.

In a possible implementation manner of the first aspect, the first version is determined according to a first identifier corresponding to a first selected operation of a user in a second interface of the database design program, the second version is determined according to a second identifier corresponding to a second selected operation of the user in the second interface, and the first instruction includes the first identifier and the second identifier.

In this possible implementation manner, the second interface may include identification information of at least two versions of the logic model, and the second interface may be the same as or different from the first interface.

In the possible implementation mode, the first version and the second version can be determined according to the corresponding selected operation of the user, so that the user can flexibly check the difference between any two versions in the logic model of the database as required, the change history of the database which the user wants to check is customized, the user can conveniently check the evolution process of the database, trace the change history of the database, and provide convenience for the user to position the logic model.

In a possible implementation manner of the first aspect, the logic model includes information of entities, attributes, and relationships; the steps are as follows: in response to the first instruction, obtaining difference information of the first version of the logical model of the database relative to the second version of the logical model, including: responding to the first instruction, comparing the entity in the first version with the entity in the second version, and obtaining entity difference information; if the entity difference information contains the first entities, determining attribute difference information and relationship difference information of each first entity in the first version relative to the corresponding first entity in the second version, wherein the first entities are entities included in the first version and the second version; the steps are as follows: generating a target interface, comprising: and generating a target interface based on the entity difference information, the attribute difference information and the relationship difference information.

An Entity reference (Entity) may be a data object, and the Entity may be a concrete concept or an abstract concept. Attributes are used to describe properties that an entity has, and an entity may be described by one or more attributes. Relationships refer to the way data objects are related to each other. In a logical model, the relationship between two entities may be represented by a relationship connection line connecting the entities. In this possible implementation, based on the specific content of the logic model, an efficient and feasible version comparison method for the logic model is provided.

In a possible implementation manner of the first aspect, the target interface is displayed based on a target display manner, the target display manner includes a display manner of difference information and a display manner of unchanged information, and the unchanged information is information in which the first version is unchanged relative to the second version.

In this possible implementation, it may be determined, based on the target display mode, to display the difference information in the target interface without displaying the unchanged information, or to display both the difference information and the unchanged information. Therefore, by setting the target display mode, the user can flexibly determine whether the display content of the target interface comprises unchanged information.

In a possible implementation manner of the first aspect, the information display method further includes: and setting a target display mode in response to a second instruction triggered by a third interface in the database design program.

The third interface may be the same as the first interface or the second interface, or may be different from both the first interface and the second interface. In the third interface, a selection key related to the target display mode may be provided for the user to select, and after the user selects the selection key related to the target display mode, the second instruction is triggered. The second instruction carries setting information of a target display mode. This possible implementation provides a feasible way of setting the target display.

A second aspect of the present application provides an information display apparatus having the functionality of a method implementing the first aspect or any one of the possible implementation manners of the first aspect. The function can be realized by hardware, and can also be realized by hardware executing corresponding software. The hardware or software includes one or more modules corresponding to the above functions, such as: the device comprises an acquisition module, a generation module and a display module.

A third aspect of the present application provides a computer device comprising at least one processor, a memory, a communication interface, and computer executable instructions stored in the memory and executable on the processor, wherein when the computer executable instructions are executed by the processor, the processor performs the method according to the first aspect or any one of the possible implementation manners of the first aspect.

A fourth aspect of the present application provides a computer-readable storage medium storing one or more computer-executable instructions that, when executed by a processor, perform a method according to the first aspect or any one of the possible implementations of the first aspect.

A fifth aspect of the present application provides a computer program product storing one or more computer executable instructions that, when executed by a processor, cause the processor to perform a method as set forth in the first aspect or any one of the possible implementations of the first aspect.

For technical effects brought by any one of the possible implementation manners of the second aspect to the fifth aspect, reference may be made to technical effects brought by different possible implementation manners of the first aspect or the first aspect, and details are not described here.

Drawings

Fig. 1 is a schematic diagram of an embodiment of a scenario provided in an embodiment of the present application;

FIG. 2A is a schematic diagram of an embodiment of a database system interacting with a terminal device;

FIG. 2B is a schematic diagram of another embodiment of a database system interacting with a terminal device;

FIG. 3 is a schematic diagram of an embodiment of a computer device provided in an embodiment of the present application;

fig. 4 is a schematic diagram of an embodiment of an information display method provided in an embodiment of the present application;

FIG. 5 is a schematic diagram of an embodiment of a display interface and a target interface of a first version of a logical model provided by an embodiment of the present application;

FIG. 6A is a schematic diagram of an embodiment of a first interface provided by an embodiment of the present application;

FIG. 6B is a schematic diagram of another embodiment of a first interface provided by an embodiment of the present application;

FIG. 7 is a schematic diagram of another embodiment of an information display method provided in an embodiment of the present application;

FIG. 8 is a schematic diagram of an embodiment of a target interface provided by an embodiment of the present application;

fig. 9 is a schematic view of an embodiment of an information display device according to an embodiment of the present application;

fig. 10 is a schematic structural diagram of a computer device provided in an embodiment of the present application.

Detailed Description

Embodiments of the present application will now be described with reference to the accompanying drawings, and it is to be understood that the described embodiments are merely illustrative of some, but not all, embodiments of the present application. As can be known to those skilled in the art, with the development of technology and the emergence of new scenarios, the technical solution provided in the embodiments of the present application is also applicable to similar technical problems.

The terms "first," "second," and the like in the description and claims of this application and in the foregoing drawings are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It will be appreciated that the data so used may be interchanged under appropriate circumstances such that the embodiments described herein may be practiced otherwise than as specifically illustrated or described herein. Moreover, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.

The embodiment of the application provides an information display method, which is used for solving the problem that related personnel cannot conveniently know the change condition of a database. The embodiment of the application also provides a corresponding device, computer equipment, a computer readable storage medium, a computer program product and the like. The following are detailed below.

In the processes of design development and application of a database, version iteration is often required to be performed on a logic model in the database, and therefore each iteration version for the logic model is generated. Users usually visually create and design a logical model of a database through a database design program, apply the logical model to a database management system (DBMS), and then the database management system converts the logical model into a Physical Data Model (PDM) to realize efficient management of the database. The database design program is software (such as Application (APP)), the logical model is used for describing a data structure of the database, the physical data model is also called a physical model, is oriented to a computer system, describes information such as an organization structure, an order and an access path of data in a storage medium, and can realize the database at a system layer.

Fig. 1 is a diagram illustrating a scenario provided in an embodiment of the present application.

Wherein the database design program is installed in the computer device. In the example shown in fig. 1, the computer device is a terminal device, and is connected to a cloud device that deploys a database management system.

Illustratively, the terminal device may be a mobile phone (mobile phone), a tablet (pad), a computer with wireless transceiving function, a Virtual Reality (VR) terminal, an Augmented Reality (AR) terminal, a wireless terminal in industrial control (industrial control), a wireless terminal in self driving (self driving), a wireless terminal in remote medical (remote medical), a wireless terminal in smart grid (smart grid), a wireless terminal in transportation safety (transportation safety), a wireless terminal in smart city (smart city), a wireless terminal in smart home (smart home), a wireless terminal in internet of things (IoT), and the like.

A database management system in a database system (database system) may be deployed in the cloud appliance. The database system generally comprises the following three parts: (1) Database (DB) refers to an organized, sharable collection of data stored in a computer for a long period of time. The data in the database is organized, described and stored according to a certain mathematical model, has smaller redundancy, higher data independence and easy expansibility, and can be shared by various users. (2) Hardware, including data storage such as memory and/or disks, required for storing data. (3) The software comprises a database management system, wherein the database management system is core software of the database system and is system software for scientifically organizing and storing data and efficiently acquiring and maintaining the data.

The database system may be a stand-alone database system or a clustered database system.

Specifically, fig. 2A is a schematic diagram of a standalone database system interacting with a terminal device, and includes a database management system and a data storage (data storage), where the database management system is used to provide services such as querying and modifying a database, and the database management system stores data in the data storage. In a stand-alone database system, the database management system and the data store are typically located on a single server, such as a symmetric multi-processor (SMP) server. The SMP server includes multiple processors, all of which share resources, such as buses, memory and I/O systems. The functions of the database management system may be implemented by one or more processors executing programs in memory.

In this way, the terminal device mounted with the database design tool can communicate with the server mounted with the database management system to acquire database data from the server for the design of the logical model, and after the logical model is designed, transmit to the database management system of the server.

Fig. 2B is a schematic diagram of a cluster database system adopting a shared-storage architecture, and the cluster database system includes a plurality of nodes (e.g., nodes 1-N in fig. 2B), each node is deployed with a database management system to provide services such as query and modification of a database for a user, and the plurality of database management systems store shared data in a shared data storage and perform read-write operations on the data in the data storage through a switch. The shared data storage may be a shared disk array. The nodes in the clustered database system may be physical machines, such as database servers, or Virtual Machines (VMs) or containers (containers) running on abstract hardware resources. When a node is a virtual machine or a container, a database management system deployed in the node is a DBMS instance (instance), which may be a process or a thread. If the node is a physical machine, the switch is a Storage Area Network (SAN) switch, an ethernet switch, a fiber switch, or other physical switching device. If the node is a virtual machine or a container, the switch is a virtual switch.

In the example shown in fig. 2B, since the dbms deployed on each node manage the same shared data storage, the dbms deployed on each node may adopt the same logical model. After a user finishes designing a logic model in a database design program of computer equipment, the logic model can be respectively transmitted to each node where a database management system is deployed, and the logic model is converted into a Physical Data Model (PDM) by each database management system, so as to realize efficient management of a database. Of course, in other examples, the logic model may also be designed separately for the database management system deployed by each node, which is only exemplary and not limiting herein.

As shown in fig. 3, another exemplary scenario provided in the embodiment of the present application is illustrated.

In the example shown in FIG. 3, both the database design program and the database management system are installed in a computer device. The computer equipment can be a single server in a stand-alone database system, and can also be any node server with a database management system deployed in a cluster database system.

Of course, the database design program and the database management system may also have other deployment manners, which are not limited herein. For example, the database system may be a cluster server system of a shared-nothing architecture, with each node having its own hardware resources (e.g., data storage), operating system, and database, with the nodes communicating over a network.

The information display method provided by the embodiment of the present application is described below with reference to the drawings.

As shown in fig. 4, an embodiment of the information display method provided in the embodiment of the present application may be applied to the computer device, where the embodiment includes:

101. in response to the first instruction, difference information of a first version of a logical model of the database relative to a second version of the logical model is obtained.

The first instruction is used for indicating the difference of the first version relative to the second version, and the logic model is used for describing a data structure of the database.

The logical model may record information of entities, attributes, and relationships in a structural form such as a tree structure, a graph structure, or a two-dimensional table structure. An Entity reference (Entity) may be a data object, and the Entity may be a concrete concept or an abstract concept. Attributes are used to describe properties that an entity has, and an entity may be described by one or more attributes. Relationships refer to the way data objects are related to each other. In a logical model, the relationship between two entities may be represented by a relationship connection line connecting the entities.

There are many situations in which each version of the logical model can be generated in a particular manner.

For example, a version uploaded to the audit node by the user in the database design program for auditing may be used as one version of the logical model; or, the version uploaded to the auditing node for auditing and passing can be used as one version of the logic model; or, the version stored by the user in the database design program every time can be used as one version; alternatively, the version of the logical model that the user is editing in the database design program may also be used as a version of the logical model. Each version of the logical model may be identified by a name, a flag number, and/or a timestamp.

Among the versions of the logical model of the database, the version with the latest timestamp or the version in the editing state in the database designer may be taken as the latest version of the logical model, and the other versions except the latest version may be taken as the historical versions of the logical model. The first version and the second version may both be historical versions, or one of them may be the latest version and the other may be a historical version.

It should be noted that, in this embodiment, the sequential relationship between the first version and the second version (for example, the sequence of the timestamps and the sequence of the version numbers) may be determined according to the relevant operation of the user or the specific interface condition, which is not limited herein. That is, in some examples, the first version may have a timestamp that is earlier than the second version, while in another example, the first version may have a timestamp that is later than the second version.

The number of the second versions of the logical model may be one or more. If the number of the second versions is multiple, the difference information of the first version of the logical model of the database relative to each second version of the logical model can be obtained, and the difference information of the first version relative to each second version is displayed in the target interface.

The first version and the second version may be determined based on the first instruction, for example, the first instruction may carry a first identifier of the first version and a second identifier of the second version, or the first instruction may carry the first identifier of the first version and take a last version of the first version as the second version.

The first instruction may be generated in a variety of ways. For example, the method can be triggered in response to a specified trigger operation of a user on a specified interface of the database design program, for example, in response to a selected operation of a specific selection key in the design interface of the database design program by the user; alternatively, other terminals may be sent to the computer device.

The difference information may include one or more of structure difference information, content difference information, and format difference information. The structural difference information refers to information regarding differences of structural frameworks (e.g., a table structural framework, a graph structural framework, etc.) of the logical model. The content difference information refers to information on differences in relation between text, images, and objects (text and images) in the logical model. The content difference information may be used to describe information of differences in entities, attributes, and relationships of the logical model. The format difference information refers to information on a difference in format design of content in the logical model, for example, information on a difference in font, color, page layout position, and size.

In this embodiment, after a version of a logical model is generated, version information such as an identifier of the version and model detail data may be stored. The version information of the version may be stored in the computer device, or may be transmitted to another device (for example, a cloud server) by the computer device for storage. Furthermore, it is also possible that one or more versions of the logical model are stored in the computer device and one or more other versions are stored in other devices. If the version information of each version of the logic model is stored in other devices, in the step 101, the computer device may acquire the version information of the first version and the version information of the second version from the other devices, and then compare the version information of the first version and the version information of the second version with the computer device to acquire difference information of the first version relative to the second version; or, the computer device may send a specified instruction to the other storage device to instruct the other device to compare the version information of the first version with the version information of the second version, obtain difference information of the first version relative to the second version, and then send the difference information to the computer device by the other device.

The manner of comparing the version information of the first version and the version information of the second version may be determined based on the specific content of the version information and the storage manner. For example, if the first version and the second version in the logical model are both table structures, it may be compared whether there are additional table structures and deleted table structures relative to the first version and the second version, and for each table structure included in both the first version and the second version, the difference information between the table structure in the first version relative to the corresponding table structure in the second version may be compared.

102. And generating a target interface.

The difference information included in the target interface is rendered based on the first version of the display interface.

The target interface includes the difference information, and may further include other information besides the difference information, such as: information that the first version has not changed relative to the second version, and a navigation menu.

Because the first version of the display interface can visually display the logic model, the difference information included in the target interface is obtained by rendering the display interface based on the first version of the display interface, and the difference information can be visually displayed to the user on the target interface based on the display interface of the first version. The layout and rendering method of the difference information on the target interface can be obtained based on the layout and rendering method of the first version of the display interface, so that the display mode of the difference information in the target interface is similar to the display mode of the corresponding information of the difference information in the first version of the display interface in the first version.

103. And displaying the target interface.

In the embodiment of the application, the target interface can be displayed on the display screen. The target interface can be displayed on the display in a full screen mode or only in a partial area of the display. The display may be an internal component of the computer device or an external device to the computer device. The specific structure and type of the display is not limited herein.

The display process of the target interface may be: refreshing a front-end interface in a database design program according to the data of the target interface so as to display the target interface; alternatively, a target window may be generated in the database design program, and rendered in the target window to display the target interface.

FIG. 5 is an exemplary diagram of a display interface and a target interface of a first version of a logical model.

The display interface of the first version of the logic model comprises three tables in the first version, namely a table 1, a table 2 and a table 3, the table 1 is a newly added table of the first version of the logic model relative to the second version of the logic model, a second row in the table 2 of the first version has a modified field relative to a second row in the table 2 of the second version of the logic model, and a fourth row in the table 2 of the first version has a deleted field relative to a fourth row in the table 2 of the second version of the logic model. Table 3 is a table in which the first version of the logical model is deleted relative to the second version of the logical model.

In the example of fig. 5, in the target interface, the layout method of the difference information on the target interface is similar to that of the display interface of the first version, and is displayed on the basis of the structure of the three tables in the first version, but the background color of the difference information on the target interface is different from that of the corresponding information on the display interface of the first version, so that the difference information can be visually highlighted to the user.

In the scheme provided by the embodiment of the application, the difference information included in the target interface is obtained by rendering based on the display interface of the first version, so that the difference information can be presented based on the presentation mode of the display interface of the first version, and a user can conveniently and intuitively view the change condition between different versions of the logic model on the basis of the display interface of the first version of the logic model.

Optionally, the determining manner of the first version and the second version may include, but is not limited to, the following two:

1. in one embodiment, the first instruction is triggered by a user at a first interface of the database design program, the first version is a version displayed in the first interface, and the second version is a previous version relative to the version displayed in the first interface.

As shown in fig. 6A, in an example, the first interface may be a certain design interface for a logic model in a database design program, and a user may trigger the first instruction by clicking a "display design difference" button on the design interface, so that a change of a current version relative to a previous version may be conveniently checked through a target interface in a process of designing the logic model, so as to understand a design process in detail. Alternatively, as shown in fig. 6B, the first interface may also be an interface for submitting a model audit in the database design program. Before submitting the version of the logic model displayed in the first interface to the auditing node, a user can select a 'display design difference' key in the interface submitted for auditing so as to trigger a first instruction and instruct the database design program to display the difference of the version displayed in the first interface relative to the previous version of the displayed version, so that the user can conveniently look up the changed part in the iteration of the version through a target interface before submitting the auditing.

2. In another embodiment, the first version is determined according to a first identifier corresponding to a first selected operation of a user in a second interface of the database design program, the second version is determined according to a second identifier corresponding to a second selected operation of the user in the second interface, and the first instruction comprises the first identifier and the second identifier.

Identification information for at least two versions of the logical model may be included in the second interface. Illustratively, the second interface may be a page displaying the identification of all versions of the logical model; or, the second interface may be a certain design interface for the logic model in the database design program, and display the identification information of at least two versions of the logic model in the operation guidance area on the left side of the design page; alternatively, the second interface may be an interface for submitting a model audit, and the identification information of at least two versions of the logical model is displayed in the operating area below the interface for submitting the model audit. The second interface may be the same as or different from the first interface.

In this embodiment, the first version and the second version may be determined according to a corresponding selected operation of a user, so that the user may flexibly view a difference between any two versions in the logical model of the database as needed, customize a change history of the database that the user wants to view, facilitate the user to view an evolution process of the database, trace the change history of the database, and provide convenience for the user to locate the logical model.

Optionally, the logic model of the difference information includes information of entities, attributes, and relationships;

as shown in fig. 7, in the information display method provided in the embodiment of the present application, an embodiment of a process of acquiring difference information and generating a target interface includes:

201. and responding to the first instruction, comparing the entity in the first version with the entity in the second version, and obtaining entity difference information.

202. If the entity difference information includes first entities, attribute difference information and relationship difference information of each first entity in the first version relative to a corresponding first entity in the second version are determined.

The first entity is an entity included in both the first version and the second version.

203. And generating a target interface based on the entity difference information, the attribute difference information and the relationship difference information.

In the specific structure of the logical model, entities can have different representations. For example, if the logical model is a relational model and the relationship between the data is represented in the form of a two-dimensional table, each two-dimensional table in the logical model is used to represent an entity, each row or each column in the two-dimensional table may be used to describe an attribute of the corresponding entity, and a connection line between two-dimensional tables may represent the relationship between two entities corresponding to the two-dimensional tables. If the logical model is a hierarchical model and the relationship between data is represented in the form of a tree structure, each node in the logical model is used to represent an entity, the attribute of the entity corresponding to the node may be recorded in the field corresponding to the node, and the connection line between the nodes may reflect the relationship between the entities.

In this embodiment, comparing is performed on the basis of entities, entities that are changed are determined by comparing the first version and the second version, and a specific change condition is determined for each changed entity, so as to obtain difference information of the first version relative to the second version, where the difference information may include entity difference information, attribute difference information, and relationship difference information. Based on the specific content of the logic model, the embodiment provides an efficient and feasible version comparison method for the logic model.

Alternatively, the specific presentation manner of the content in the target interface may be determined based on at least one of the following methods.

1. And generating a target interface according to the difference type corresponding to the difference information, and displaying the target interface on a display.

In an embodiment, the difference type corresponding to the difference information includes one or more of a deletion type, a modification type and an addition type, and the display modes of the difference information corresponding to different difference types on the target interface are different. The display mode corresponding to the difference type may refer to a display mode of the difference information corresponding to the difference type on the target interface. The display mode corresponding to the difference type comprises one or more of a color display mode, a line display mode and a font display mode. The display modes corresponding to different difference types are different, for example: as shown in fig. 8, in one example, the newly added type may be displayed with a background color having a higher gray value, the deleted type may be displayed with a black background and a white font color, and the modified type may be displayed with a background color having a lower gray value. In yet another example, the new type may be highlighted in green, the delete type may be highlighted in red, and the modify type may be highlighted in blue. Through different display modes, the difference information corresponding to different difference types can be highlighted, and the user can conveniently and quickly identify the difference information.

In the process of generating the target interface, the difference types corresponding to the difference information can be determined, and then the target interface is generated based on the display mode corresponding to each difference type and the difference information corresponding to each difference type, so that the difference information corresponding to different difference types can be highlighted in different display modes, and a user can conveniently identify specific change conditions corresponding to different operations such as deletion, addition and modification of the first version relative to the second version in the target interface.

Optionally, if the difference type corresponding to the difference information includes a modification type, in the target interface, the difference information corresponding to the modification type in the first version is displayed in a first display manner, the difference information corresponding to the modification type in the second version is displayed in a second display manner, and the first display manner is different from the second display manner.

If the first version has modified content relative to the second version, then the modified content may have pre-modified content and post-modified content in the first version and the second version, respectively. Different display modes are adopted for displaying the content before modification and the content after modification, so that a user can clearly see the evolution process of the modified content between the first version and the second version and trace the specific situation of version change.

2. And generating a target interface according to the display mode of the difference information and the display mode of the unchanged information, and displaying the target interface on the display.

In one embodiment, the target interface is displayed based on a target display mode, the target display mode comprises a display mode of the difference information and a display mode of the unchanged information, and the unchanged information is the information that the first version is not changed relative to the second version.

In this embodiment, it may be determined that the difference information is displayed in the target interface without displaying the unchanged information based on the target display manner, for example, the example shown in fig. 7; alternatively, both difference information and unchanged information are displayed, such as the example of the target interface shown in FIG. 5. Therefore, by setting the target display mode, the user can flexibly determine whether the display content of the target interface comprises unchanged information.

Optionally, the information display method further includes:

and responding to a second instruction triggered by a third interface in the database design program by the user, and setting a target display mode.

The second instruction carries setting information of a target display mode. Illustratively, the third interface may be a certain design interface for the logic model in the database design program, or may also be an interface that the database design program pops up after the user triggers the first instruction. In the third interface, a selection key related to the target display mode may be provided for the user to select, and after the user selects the selection key related to the target display mode, the second instruction is triggered.

It is noted that, in some examples, the specific presentation manner of the content in the target interface may be determined based on a plurality of the above aspects. That is, in some examples, the target interface may be generated according to a display mode of the difference information and a display mode of the unchanged information, and the target interface may be displayed on the display screen, where the display mode of the difference information includes a display mode of a difference type corresponding to the difference information. Specifically, for the unchanged information, whether the unchanged information is displayed on the target interface may be determined according to the display mode of the unchanged information, and for the difference information, the presentation mode of the difference information corresponding to each difference type on the target interface may be specifically determined according to the display mode of the difference type corresponding to the difference information.

In the above, the information display method is described in various aspects in the embodiments of the present application, and the information display device of the present application is described below with reference to the drawings.

As shown in fig. 9, an embodiment of the present application provides an information display apparatus 30, where an embodiment of the information display apparatus 30 includes:

an obtaining module 301, configured to obtain, in response to a first instruction, difference information of a first version of a logical model of a database relative to a second version of the logical model, where the first instruction is used to indicate that a difference of the first version relative to the second version is displayed, and the logical model is used to describe a data structure of the database;

a generating module 302, configured to generate a target interface, where difference information included in the target interface is obtained by rendering based on a display interface of a first version;

and a display module 303, configured to display the target interface.

Optionally, the difference type corresponding to the difference information includes one or more of a deletion type, a modification type, and an addition type, and the display modes of the difference information corresponding to different difference types on the target interface are different.

Optionally, if the difference type corresponding to the difference information includes a modification type, in the target interface, the difference information corresponding to the modification type in the first version is displayed in a first display mode, the difference information corresponding to the modification type in the second version is displayed in a second display mode, and the first display mode is different from the second display mode.

Optionally, the first instruction is triggered by a user at a first interface of the database design program, the first version is a version displayed in the first interface, and the second version is a previous version relative to the version displayed in the first interface.

Optionally, the first version is determined according to a first identifier corresponding to a first selected operation of a user in a second interface of the database design program, the second version is determined according to a second identifier corresponding to a second selected operation of the user in the second interface, and the first instruction includes the first identifier and the second identifier.

Optionally, the logic model includes information of entities, attributes, and relationships;

the obtaining module 301 is configured to:

responding to the first instruction, comparing the entity in the first version with the entity in the second version, and obtaining entity difference information;

if the entity difference information contains the first entities, determining attribute difference information and relationship difference information of each first entity in the first version relative to the corresponding first entity in the second version, wherein the first entities are entities included in the first version and the second version;

the generation module 302 is configured to:

and generating a target interface based on the entity difference information, the attribute difference information and the relationship difference information.

Optionally, the target interface is displayed based on a target display mode, the target display mode includes a display mode of the difference information and a display mode of the unchanged information, and the unchanged information is information in which the first version is unchanged relative to the second version.

Optionally, the information display device 30 further includes: a setup module 304, the setup module 304 to: and setting a target display mode in response to a second instruction triggered by a third interface in the database design program.

The information display device described above can be understood by referring to the corresponding content of the foregoing information display method, and is not repeated herein.

Fig. 10 is a schematic diagram illustrating a possible logical structure of the computer device 40 according to an embodiment of the present disclosure. The computer device 40 includes: a processor 401, a communication interface 402, a memory 403, a bus 404, and a display 405. The processor 401, the communication interface 402, the memory 403 and the display 405 are connected to each other through the bus 404.

The Memory 403 may be a Read Only Memory (ROM), a static Memory device, a dynamic Memory device, or a Random Access Memory (RAM). The memory 403 may store a program, and the processor 401 and the communication interface 402 are configured to perform steps 101-102 and steps 201-203, etc. of the above-described information display method embodiment when the program stored in the memory 403 is executed by the processor 401.

The processor 401 may adopt a Central Processing Unit (CPU), a microprocessor, an Application Specific Integrated Circuit (ASIC), a Graphics Processing Unit (GPU), a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), a Field Programmable Gate Array (FPGA) or other Programmable logic device, a discrete Gate or transistor logic device, a discrete hardware component, or any combination thereof, and is configured to execute the relevant programs to implement the functions required to be executed by the obtaining module, the generating module, and the setting module in the information display device according to the embodiment of the present Application, or execute steps 101 to 102 and steps 201 to 203 in the information display method according to the embodiment of the present Application. For example, step 101 in the information display method according to the embodiment of the present application may be executed by the central processing unit, step 102 in the information display method according to the embodiment of the present application is executed by the graphics processing unit, so as to complete the rendering of the target interface, and then the central processing unit sends an instruction to the display 405 to instruct the display 405 to execute step 103 in the information display method according to the embodiment of the present application, so as to implement the display of the target interface. The steps of the method disclosed in connection with the embodiments of the present application may be directly implemented by a hardware decoding processor, or implemented by a combination of hardware and software modules in the decoding processor. The software modules may be located in ram, flash, rom, prom, or eprom, registers, etc. as is well known in the art. The storage medium is located in the memory 403, and the processor 401 reads the information in the memory 403, and executes steps 101 to 102, steps 201 to 203, and the like of the above-described embodiment of the information display method in combination with hardware thereof.

Communication interface 402 enables communication between computer device 40 and other devices or communication networks using transceiver means, such as, but not limited to, transceivers. For example, version information of a first version, version information of a second version, and difference information of a logical model of a database may be obtained from a server in which a database management system is deployed through the communication interface 402.

Bus 404 may enable a path for information to be transferred between components of computer device 40, such as processor 401, communication interface 402, memory 403, and display 405. The bus 404 may be a Peripheral Component Interconnect (PCI) bus, an Extended Industry Standard Architecture (EISA) bus, or the like. The bus may be divided into an address bus, a data bus, a control bus, etc. For ease of illustration, only one thick line is shown in FIG. 10, but this is not intended to represent only one bus or type of bus.

The display 405 is used to execute step 103 in the above-mentioned information display method embodiment, i.e. to display the target interface. The Display may be a Liquid Crystal Display (LCD) Display, a Cathode Ray Tube (CRT) Display, or a light-emitting diode (LED) Display. The particular type and configuration of display 405 is not intended to be limiting.

In another embodiment of the present application, a computer-readable storage medium is further provided, in which computer-executable instructions are stored, and when the processor of the device executes the computer-executable instructions, the device executes the steps executed by the processor in fig. 10.

In another embodiment of the present application, there is also provided a computer program product comprising computer executable instructions stored in a computer readable storage medium; when the computer executes the instructions, the processor of the device performs the steps described above as being performed by the processor of fig. 10.

In another embodiment of the present application, a chip system is further provided, where the chip system includes a processor, and the processor is configured to support an information display apparatus to implement the steps performed by the processor in fig. 10. In one possible design, the system-on-chip may further include a memory, the memory being configured to hold program instructions and data necessary for the means for writing data. The chip system may be constituted by a chip, or may include a chip and other discrete devices.

Those of ordinary skill in the art will appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, or combinations of computer software and electronic hardware. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the embodiments of the present application.

It can be clearly understood by those skilled in the art that, for convenience and simplicity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.

In the several embodiments provided in the embodiments of the present application, it should be understood that the disclosed system, apparatus, and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, a division of a unit is only a logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.

Units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.

In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit.

The functions, if implemented in the form of software functional units and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solutions of the embodiments of the present application, which are essential or part of the technical solutions contributing to the prior art, may be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for enabling a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the methods of the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, an optical disk, or other various media capable of storing program codes.

The above description is only a specific embodiment of the embodiments of the present application, but the scope of the embodiments of the present application is not limited thereto.

Claims

1. An information display method, comprising:

acquiring difference information of a first version of a logic model of a database relative to a second version of the logic model in response to a first instruction, wherein the first instruction is used for indicating that the difference of the first version relative to the second version is displayed, and the logic model is used for describing a data structure of the database;

generating a target interface, wherein the difference information included in the target interface is obtained by rendering based on the display interface of the first version;

and displaying the target interface.

2. The information display method according to claim 1, wherein the difference type corresponding to the difference information includes one or more of a deletion type, a modification type, and an addition type, and the difference information corresponding to different difference types is displayed in different manners on the target interface.

3. The information display method according to claim 2, wherein if the difference type corresponding to the difference information includes a modification type, in the target interface, the difference information corresponding to the modification type in the first version is displayed in a first display manner, the difference information corresponding to the modification type in the second version is displayed in a second display manner, and the first display manner is different from the second display manner.

4. The information display method according to any one of claims 1 to 3, wherein the first instruction is triggered by a user on a first interface of a database design program, the first version is a version displayed in the first interface, and the second version is a previous version relative to the version displayed in the first interface.

5. The information display method according to any one of claims 1 to 3, wherein the first version is determined according to a first identifier corresponding to a first selected operation of a user in a second interface of a database design program, the second version is determined according to a second identifier corresponding to a second selected operation of the user in the second interface, and the first instruction comprises the first identifier and the second identifier.

6. The information display method according to any one of claims 1 to 5, wherein the logical model includes information of entities, attributes, and relationships;

the obtaining difference information of the first version of the logical model of the database relative to the second version of the logical model in response to the first instruction comprises:

comparing the entity in the first version with the entity in the second version in response to the first instruction to obtain entity difference information;

if the entity difference information includes first entities, determining attribute difference information and relationship difference information of each first entity in the first version relative to a corresponding first entity in the second version, wherein the first entities are entities included in both the first version and the second version;

the generating a target interface includes:

generating the target interface based on the entity difference information, the attribute difference information, and the relationship difference information.

7. The information display method according to any one of claims 1 to 6, wherein the target interface displays based on a target display mode, the target display mode including a display mode of the difference information and a display mode of unchanged information, the unchanged information being information in which the first version is unchanged with respect to the second version.

8. The information display method according to claim 7, characterized in that the information display method further comprises:

and responding to a second instruction triggered by a third interface in the database design program of the user, and setting the target display mode.

9. An information display device characterized by comprising:

the obtaining module is used for responding to a first instruction, obtaining difference information of a first version of a logic model of a database relative to a second version of the logic model, wherein the first instruction is used for indicating that the difference of the first version relative to the second version is displayed, and the logic model is used for describing a data structure of the database;

a generating module, configured to generate a target interface, where the difference information included in the target interface is obtained by rendering based on the display interface of the first version;

and the display module is used for displaying the target interface.

10. The information display device of claim 9, wherein the difference types corresponding to the difference information comprise one or more of a delete type, a modify type, and a add type, and the difference information corresponding to different difference types are displayed in different ways on the target interface.

11. The information display device according to claim 10, wherein if the difference type corresponding to the difference information includes a modification type, in the target interface, the difference information corresponding to the modification type in the first version is displayed in a first display manner, and the difference information corresponding to the modification type in the second version is displayed in a second display manner, and the first display manner and the second display manner are different.

12. The information display device according to any one of claims 9 to 11, wherein the first instruction is triggered by a user at a first interface of a database design program, the first version is a version displayed in the first interface, and the second version is a previous version with respect to the version displayed in the first interface.

13. The information display device according to any one of claims 9 to 11, wherein the first version is determined according to a first identifier corresponding to a first selected operation of a user in a second interface of a database design program, the second version is determined according to a second identifier corresponding to a second selected operation of the user in the second interface, and the first instruction includes the first identifier and the second identifier.

14. The information display device according to any one of claims 9 to 13, wherein the logical model includes information of entities, attributes, and relationships;

the acquisition module is configured to:

the generation module is configured to:

15. The information display device according to any one of claims 9 to 14, wherein the target interface is displayed based on a target display mode, the target display mode including a display mode of the difference information and a display mode of unchanged information, the unchanged information being information in which the first version is unchanged with respect to the second version.

16. The information display device according to claim 15, characterized by further comprising:

and the setting module is used for responding to a second instruction triggered by a third interface of the user in the database design program and setting the target display mode.

17. A computer device comprising at least one processor, memory, and instructions stored on the memory and executable by the at least one processor, the at least one processor executing the instructions to perform the steps of the method of any one of claims 1 to 8.

18. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the method of any one of claims 1 to 8.