Method, device, computer equipment, readable storage medium and program product for constructing IT asset management system

Abstract

The present application relates to the field of database technology, and provides a method, device, computer equipment, readable storage medium and program product for constructing an IT asset management system. The method comprises: obtaining IT asset management business objects based on various business scenarios that the IT asset management system needs to involve; converting the IT asset management business objects into a general data model according to a general database standard; converting the general data model into a first database model and a second database model; adjusting the second database model according to the first database model to obtain a target database model; obtaining an IT asset management system according to the target database model and the target structured query language. The use of this method can improve the scalability of the IT asset management system, thereby improving the management efficiency and resource allocation efficiency of the IT asset management system.

Description

Technical Field

[0001] The present application relates to the field of database technology, and in particular to a method, apparatus, computer equipment, computer-readable storage medium, and computer program product for constructing an IT asset management system. Background Art

[0002] Different enterprises often use different database systems to store IT asset information. The diversity of this database system poses a huge challenge to the unified management of IT assets.

[0003] Most traditional IT asset management systems only support a single or limited number of databases, making it difficult to achieve seamless integration across platforms and databases. The IT asset management system has poor scalability, which affects the management efficiency and resource allocation efficiency of the IT asset management system. Summary of the invention

[0004] Based on this, it is necessary to provide a method, device, computer equipment, computer-readable storage medium and computer program product for constructing an IT asset management system in response to the above technical problems.

[0005] In a first aspect, the present application provides a method for constructing an IT asset management system, comprising:

[0006] Based on the various business scenarios that the IT asset management system needs to involve, obtain IT asset management business objects;

[0007] Converting the IT asset management business object into a common data model according to common database standards;

[0008] converting the common data model into a first database model and a second database model;

[0009] According to the first database model, adjusting the second database model to obtain a target database model;

[0010] According to the target database model and the target structured query language, an IT asset management system is obtained.

[0011] In one embodiment, adjusting the second database model according to the first database model to obtain a target database model includes:

[0012] According to the first database model, adjusting the data type definition and optimization strategy of the second database model to obtain an adjusted second database model;

[0013] The adjusted second database model is used as the target database model.

[0014] In one embodiment, before obtaining the IT asset management system according to the target database model and the target structured query language, the method further includes:

[0015] Get standard structured query language;

[0016] According to the functions and stored procedures supported by the first database, the standard structured query language is adjusted to obtain an intermediate structured query language;

[0017] The intermediate structured query language is adjusted according to the grammar of the first database to obtain a target structured query language.

[0018] In one embodiment, obtaining the IT asset management system according to the target database model and the target structured query language includes:

[0019] Feeding back the target database model and the target structured query language to the developer, and obtaining the system development program programmed by the developer according to the target database model and the target structured query language;

[0020] According to the system development procedure, an IT asset management system is obtained.

[0021] In one embodiment, the IT asset management system is obtained according to the system development program, including:

[0022] Obtaining a locking mechanism for a first database;

[0023] Checking the concurrency control logic of the system development program according to the locking mechanism of the first database;

[0024] When the concurrency control logic of the system development program is not adapted to the locking mechanism of the first database, adjusting the concurrency control logic of the system development program to obtain a system development program adapted to the locking mechanism of the first database;

[0025] According to the system development program adapted to the locking mechanism of the first database, an IT asset management system is obtained.

[0026] In one embodiment, after obtaining the IT asset management system according to the target database model and the target structured query language, the method further includes:

[0027] Get the database requirements to be configured;

[0028] According to the requirements of the database to be configured, the database of the IT asset management system is configured.

[0029] In a second aspect, the present application also provides a device for constructing an IT asset management system, including:

[0030] The business object acquisition module is used to obtain IT asset management business objects based on various business scenarios that the IT asset management system needs to involve;

[0031] A general data model acquisition module, used to convert the IT asset management business object into a general data model according to a general database standard;

[0032] A general data model conversion module, used to convert the general data model into a first database model and a second database model;

[0033] a target database model acquisition module, configured to adjust the second database model according to the first database model to obtain a target database model;

[0034] The IT asset management system construction module is used to obtain the IT asset management system according to the target database model and the target structured query language.

[0035] In a third aspect, the present application further provides a computer device, wherein the computer device comprises a memory and a processor, wherein the memory stores a computer program, and the processor executes the above method.

[0036] In a fourth aspect, the present application further provides a computer-readable storage medium, wherein a computer program is stored on the computer-readable storage medium, and the computer program is executed by a processor to execute the above method.

[0037] In a fifth aspect, the present application further provides a computer program product, wherein the computer program product comprises a computer program, and the computer program is executed by a processor to execute the above method.

[0038] The construction method, device, computer equipment, computer-readable storage medium and computer program product of the above-mentioned IT asset management system obtain IT asset management business objects based on various business scenarios that the IT asset management system needs to involve; convert the IT asset management business objects into a general data model according to the general database standard; convert the general data model into a first database model and a second database model; adjust the second database model according to the first database model to obtain a target database model; obtain an IT asset management system according to the target database model and the target structured query language. This application converts IT asset management business objects into a general data model according to the general database standard; obtains the first database model and the second database model adapted to the current mainstream database according to the general data model; adjusts the second database model according to the first database model to obtain the target database model; obtains an IT asset management system that is compatible with multiple types of databases according to the target database model and the target structured query language, thereby improving the scalability of the IT asset management system, thereby improving the management efficiency and resource allocation efficiency of the IT asset management system. BRIEF DESCRIPTION OF THE DRAWINGS

[0039] In order to more clearly illustrate the technical solutions in the embodiments of the present application or related technologies, the drawings required for use in the embodiments of the present application or related technical descriptions will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without paying creative work.

[0040] Figure 1 An application environment diagram of a method for constructing an IT asset management system in one embodiment;

[0041] Figure 2 A flowchart of a method for constructing an IT asset management system in one embodiment;

[0042] Figure 3 A schematic diagram of a process of obtaining a target structured query language in one embodiment;

[0043] Figure 4 is a structural block diagram of a device for building an IT asset management system in one embodiment;

[0044] Figure 5 FIG. 4 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION

[0045] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0046] The present application embodiment provides a method for constructing an IT asset management system, which can be executed by a computer device, such as Figure 1 As shown, the computer device can obtain IT asset management business objects based on the various business scenarios that the IT asset management system needs to involve, and then obtain the IT asset management system. It can be understood that the computer device can be implemented through a server, a terminal, or an interactive system between a terminal and a server. In this embodiment, the method includes Figure 2 The steps shown are:

[0047] Step S201, based on various business scenarios that the IT asset management system needs to involve, obtain IT asset management business objects.

[0048] Based on the various business scenarios that the IT (Information Technology) asset management system needs to involve, the IT asset management business objects can be sorted out.

[0049] Step S202: converting IT asset management business objects into a common data model according to common database standards.

[0050] IT asset management business objects can be converted into a common data model based on common database standards, such as timestamp (TIMESTAMP) and variable character type (VARCHAR).

[0051] Step S203: converting the common data model into a first database model and a second database model.

[0052] The first database and the second database may be databases of different types.

[0053] The common data model may be converted into a first database compatible model (may be referred to as a first database model), and the common data model may be converted into a second database compatible model (may be referred to as a second database model).

[0054] Step S204: adjust the second database model according to the first database model to obtain a target database model.

[0055] The data type definition and optimization strategy of the second database model can be adjusted according to the first database model to obtain an adjusted second database model; the adjusted second database model can be used as the target database model.

[0056] Step S205, obtaining an IT asset management system according to the target database model and the target structured query language.

[0057] A target structured query language can be obtained according to a standard structured query language (SQL).

[0058] The target database model and the target structured query language can be fed back to the developer, and the system development program programmed by the developer according to the target database model and the target structured query language can be obtained. According to the system development program, an IT asset management system can be constructed.

[0059] In the above-mentioned method for constructing the IT asset management system, according to the general database standard, the IT asset management business object is converted into a general data model; according to the general data model, the first database model and the second database model adapted to the current mainstream database are obtained; according to the first database model, the second database model is adjusted to obtain the target database model; according to the target database model and the target structured query language, an IT asset management system that can be compatible with multiple types of databases is obtained, which improves the scalability of the IT asset management system, thereby improving the management efficiency and resource allocation efficiency of the IT asset management system.

[0060] In one of the embodiments, the second database model is adjusted according to the first database model to obtain a target database model, and the specific steps are as follows: according to the first database model, the data type definition and optimization strategy of the second database model are adjusted to obtain an adjusted second database model; the adjusted second database model is used as the target database model.

[0061] The data type definition and optimization strategy of the second database model can be adjusted according to the first database model to obtain an adjusted second database model, wherein the optimization strategy can include index and query optimization.

[0062] The adjusted second database model may be used as the target database model.

[0063] In this embodiment, the data type definition and optimization strategy of the second database model can be adjusted according to the first database model to obtain the target database model, which can optimize the performance of the target database model and improve the compatibility of the target database model.

[0064] In one embodiment, before obtaining the IT asset management system according to the target database model and the target structured query language, the method provided by the present application further includes: Figure 3The steps shown are: step S301, obtaining a standard structured query language; step S302, adjusting the standard structured query language according to the functions and stored procedures supported by the first database to obtain an intermediate structured query language; step S303, adjusting the intermediate structured query language according to the syntax of the first database to obtain a target structured query language.

[0065] The standard structured query language can be adjusted according to the functions and stored procedures supported by the first database to obtain the intermediate structured query language. The intermediate structured query language can be adjusted according to the syntax of the first database to obtain the target structured query language.

[0066] In this embodiment, the standard structured query language is adjusted according to the functions and stored procedures supported by the first database to obtain an intermediate structured query language; the intermediate structured query language is adjusted according to the syntax of the first database to obtain a target structured query language, which can avoid the use of stored procedures, functions, and triggers as much as possible, so that the target structured query language can be executed in different databases, thereby improving the compatibility of the target structured query language.

[0067] In one of the embodiments, an IT asset management system is obtained based on a target database model and a target structured query language. The specific steps are as follows: the target database model and the target structured query language are fed back to developers, and a system development program is obtained by the developers based on the target database model and the target structured query language; and an IT asset management system is obtained based on the system development program.

[0068] The computer device can feed back the target database model and the target structured query language to the developer, and the developer can program a system development program according to the target database model and the target structured query language. The computer device can obtain the system development program programmed by the developer according to the target database model and the target structured query language to build an IT asset management system.

[0069] In this embodiment, the target database model and the target structured query language are fed back to the developer to obtain the system development program programmed by the developer according to the target database model and the target structured query language; according to the system development program, an IT asset management system is obtained. The target database model is compatible with multiple sets of databases, and the target structured query language can be executed in different databases, which improves the scalability of the IT asset management system, thereby improving the management efficiency and resource allocation efficiency of the IT asset management system.

[0070] In one of the embodiments, an IT asset management system is obtained according to a system development program, and the specific steps are as follows: obtaining a locking mechanism of a first database; checking the concurrency control logic of the system development program according to the locking mechanism of the first database; when the concurrency control logic of the system development program is not adapted to the locking mechanism of the first database, adjusting the concurrency control logic of the system development program to obtain a system development program adapted to the locking mechanism of the first database; obtaining an IT asset management system according to the system development program adapted to the locking mechanism of the first database.

[0071] The concurrency control logic of the system development program can be checked according to the locking mechanism of the first database.

[0072] When the concurrency control logic of the system development program is not adapted to the locking mechanism of the first database, the concurrency control logic of the system development program is adjusted to obtain the system development program adapted to the locking mechanism of the first database.

[0073] According to the system development procedure adapted to the locking mechanism of the first database, an IT asset management system with high scalability is obtained.

[0074] In this embodiment, when the concurrency control logic of the system development program is not suitable for the locking mechanism of the first database, the concurrency control logic of the system development program is adjusted to obtain a system development program that is suitable for the locking mechanism of the first database, so as to obtain an IT asset management system with higher scalability, thereby improving the management efficiency and resource allocation efficiency of the IT asset management system.

[0075] In one of the embodiments, after obtaining the IT asset management system according to the target database model and the target structured query language, the method provided by the present application further includes: obtaining the requirements of the database to be configured; and configuring the database of the IT asset management system according to the requirements of the database to be configured.

[0076] The database requirements to be configured refer to the requirements of the database that the IT asset management system needs to support.

[0077] The database of the IT asset management system can be configured according to the requirements of the database to be configured. During the configuration process, there is no need to make any modifications to the IT asset management system, thereby improving the resource allocation efficiency of the IT asset management system.

[0078] It should be understood that, although the various steps in the flowcharts involved in the above-mentioned embodiments are displayed in sequence according to the indication of the arrows, these steps are not necessarily executed in sequence according to the order indicated by the arrows. Unless there is a clear explanation in this article, the execution of these steps does not have a strict order restriction, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above-mentioned embodiments can include multiple steps or multiple stages, and these steps or stages are not necessarily executed at the same time, but can be executed at different times, and the execution order of these steps or stages is not necessarily to be carried out in sequence, but can be executed in turn or alternately with other steps or at least a part of the steps or stages in other steps.

[0079] Based on the same inventive concept, the embodiment of the present application also provides an IT asset management system construction device for implementing the above-mentioned IT asset management system construction method. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme recorded in the above-mentioned method, so the specific limitations in the one or more IT asset management system construction device embodiments provided below can refer to the limitations of the IT asset management system construction method above, and will not be repeated here.

[0080] In an exemplary embodiment, Figure 4 As shown, a device for constructing an IT asset management system is provided, wherein:

[0081] The business object acquisition module 401 is used to obtain IT asset management business objects based on various business scenarios that the IT asset management system needs to involve;

[0082] A general data model acquisition module 402, configured to convert the IT asset management business object into a general data model according to a general database standard;

[0083] A general data model conversion module 403, used to convert the general data model into a first database model and a second database model;

[0084] A target database model acquisition module 404 is used to adjust the second database model according to the first database model to obtain a target database model;

[0085] The IT asset management system construction module 405 is used to obtain the IT asset management system according to the target database model and the target structured query language.

[0086] In one embodiment, the target database model acquisition module 404 is further used to: adjust the data type definition and optimization strategy of the second database model according to the first database model to obtain an adjusted second database model; and use the adjusted second database model as the target database model.

[0087] In one of the embodiments, the device also includes a target structured query language acquisition module, which is used to: acquire a standard structured query language; adjust the standard structured query language according to the functions and stored procedures supported by the first database to obtain an intermediate structured query language; adjust the intermediate structured query language according to the syntax of the first database to obtain a target structured query language.

[0088] In one embodiment, the IT asset management system construction module 405 is also used to: feed back the target database model and target structured query language to the developer, obtain the system development program programmed by the developer according to the target database model and target structured query language; and obtain the IT asset management system according to the system development program.

[0089] In one of the embodiments, the IT asset management system construction module 405 is also used to: obtain the locking mechanism of the first database; check the concurrency control logic of the system development program according to the locking mechanism of the first database; when the concurrency control logic of the system development program is not suitable for the locking mechanism of the first database, adjust the concurrency control logic of the system development program to obtain a system development program that adapts to the locking mechanism of the first database; obtain an IT asset management system according to the system development program that adapts to the locking mechanism of the first database.

[0090] In one of the embodiments, the device further includes a database configuration module, which is used to: obtain requirements of a database to be configured; and configure the database of the IT asset management system according to the requirements of the database to be configured.

[0091] Each module in the construction device of the above IT asset management system can be implemented in whole or in part by software, hardware and their combination. Each module can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory of the computer device in the form of software, so that the processor can call and execute the operations corresponding to each module above.

[0092] In an exemplary embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as shown in FIG. Figure 5As shown. The computer device includes a processor, a memory, an input / output interface (Input / Output, referred to as I / O) and a communication interface. The processor, the memory and the input / output interface are connected through a system bus, and the communication interface is connected to the system bus through the input / output interface. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store data of an embodiment of a method for constructing an IT asset management system. The input / output interface of the computer device is used to exchange information between the processor and an external device. The communication interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a method for constructing an IT asset management system is implemented.

[0093] Those skilled in the art will understand that Figure 5 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0094] In one embodiment, a computer device is further provided, including a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the steps in the above method embodiments when executing the computer program.

[0095] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the steps in the above-mentioned method embodiments are implemented.

[0096] In one embodiment, a computer program product is provided, including a computer program, which implements the steps in the above method embodiments when executed by a processor.

[0097] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant regulations.

[0098] A person of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiment method can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to the memory, database or other medium used in the embodiments provided in the present application can include at least one of non-volatile memory and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetic random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The database involved in each embodiment provided in this application may include at least one of a relational database and a non-relational database. Non-relational databases may include distributed databases based on blockchains, etc., but are not limited to this. The processor involved in each embodiment provided in this application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, an artificial intelligence (AI) processor, etc., but are not limited to this.

[0099] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this application.

[0100] The above-described embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the present application. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application shall be subject to the attached claims.

Claims

1. A method for constructing an IT asset management system, characterized in that: The method comprises: Based on the various business scenarios that the IT asset management system needs to involve, obtain IT asset management business objects; Converting the IT asset management business object into a common data model according to common database standards; converting the common data model into a first database model and a second database model; According to the first database model, adjusting the second database model to obtain a target database model; According to the target database model and the target structured query language, an IT asset management system is obtained.

2. The method according to claim 1, characterized in that The step of adjusting the second database model according to the first database model to obtain a target database model includes: According to the first database model, adjusting the data type definition and optimization strategy of the second database model to obtain an adjusted second database model; The adjusted second database model is used as the target database model.

3. The method according to claim 1, characterized in that Before obtaining the IT asset management system according to the target database model and the target structured query language, the method further includes: Get standard structured query language; According to the functions and stored procedures supported by the first database, the standard structured query language is adjusted to obtain an intermediate structured query language; The intermediate structured query language is adjusted according to the grammar of the first database to obtain a target structured query language.

4. The method according to claim 1, characterized in that: The IT asset management system is obtained according to the target database model and the target structured query language, including: Feeding back the target database model and the target structured query language to the developer, and obtaining the system development program programmed by the developer according to the target database model and the target structured query language; According to the system development procedure, an IT asset management system is obtained.

5. The method according to claim 4, characterized in that According to the system development procedure, an IT asset management system is obtained, including: Obtaining a locking mechanism for a first database; Checking the concurrency control logic of the system development program according to the locking mechanism of the first database; When the concurrency control logic of the system development program is not adapted to the locking mechanism of the first database, adjusting the concurrency control logic of the system development program to obtain a system development program adapted to the locking mechanism of the first database; According to the system development program adapted to the locking mechanism of the first database, an IT asset management system is obtained.

6. The method according to claim 1, characterized in that After obtaining the IT asset management system according to the target database model and the target structured query language, the method further includes: Get the database requirements to be configured; According to the requirements of the database to be configured, the database of the IT asset management system is configured.

7. A device for constructing an IT asset management system, characterized in that: The device comprises: The business object acquisition module is used to obtain IT asset management business objects based on various business scenarios that the IT asset management system needs to involve; A general data model acquisition module, used to convert the IT asset management business object into a general data model according to a general database standard; A general data model conversion module, used to convert the general data model into a first database model and a second database model; a target database model acquisition module, configured to adjust the second database model according to the first database model to obtain a target database model; The IT asset management system construction module is used to obtain the IT asset management system according to the target database model and the target structured query language.

8. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 6 are implemented.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

Images