CN116450622A - Method, apparatus, device and computer readable medium for data warehouse entry - Google Patents
Method, apparatus, device and computer readable medium for data warehouse entry Download PDFInfo
- Publication number
- CN116450622A CN116450622A CN202310715929.1A CN202310715929A CN116450622A CN 116450622 A CN116450622 A CN 116450622A CN 202310715929 A CN202310715929 A CN 202310715929A CN 116450622 A CN116450622 A CN 116450622A
- Authority
- CN
- China
- Prior art keywords
- software
- data
- maintenance script
- script
- service server
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 71
- 238000013515 script Methods 0.000 claims abstract description 144
- 238000012423 maintenance Methods 0.000 claims abstract description 131
- 238000007726 management method Methods 0.000 claims abstract description 68
- 238000013500 data storage Methods 0.000 claims abstract description 26
- 230000008569 process Effects 0.000 claims description 36
- 238000004590 computer program Methods 0.000 claims description 15
- 238000010586 diagram Methods 0.000 description 14
- 238000004891 communication Methods 0.000 description 9
- 230000006870 function Effects 0.000 description 6
- 238000012545 processing Methods 0.000 description 5
- 230000003287 optical effect Effects 0.000 description 4
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 230000008859 change Effects 0.000 description 2
- 239000000835 fiber Substances 0.000 description 2
- 230000002452 interceptive effect Effects 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 239000004065 semiconductor Substances 0.000 description 2
- 241000677635 Tuxedo Species 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method, a device, equipment and a computer readable medium for data warehousing, and relates to the technical field of cloud computing. One embodiment of the method comprises the following steps: identifying software running on a service server, and adding a software type label to the software; establishing an operation and maintenance script of the software based on the software type label, and recording the operation and maintenance script of the software in a configuration management database; and acquiring configuration item data of the software through the operation and maintenance script, and inputting the configuration item data serving as an output result of the operation and maintenance script to the configuration management database through an application programming interface to realize data storage. According to the embodiment, automatic data storage can be realized, and the effectiveness of the data is improved.
Description
Technical Field
The present invention relates to the field of cloud computing technologies, and in particular, to a method, an apparatus, a device, and a computer readable medium for data storage.
Background
A database is a repository that organizes, stores and manages data according to a data structure, and is a collection of large amounts of data stored in a computer for a long period of time, organized, sharable, and uniformly managed. At present, the database is mostly manually input by people to realize data storage.
In the process of implementing the present invention, the inventor finds that at least the following problems exist in the prior art: in the data warehouse-in process, time and labor are consumed, and the data validity is difficult to be ensured.
Disclosure of Invention
In view of the above, embodiments of the present invention provide a method, an apparatus, a device, and a computer readable medium for data storage, which can implement automatic data storage and improve the effectiveness of data.
To achieve the above object, according to an aspect of the embodiments of the present invention, there is provided a method for data warehousing, including:
identifying software running on a service server, and adding a software type label to the software;
establishing an operation and maintenance script of the software based on the software type label, and recording the operation and maintenance script of the software in a configuration management database;
and acquiring configuration item data of the software through the operation and maintenance script, and inputting the configuration item data serving as an output result of the operation and maintenance script to the configuration management database through an application programming interface to realize data storage.
The identifying the software running on the service server and adding a software type tag to the software comprises the following steps:
identifying software running on the service server based on the process information in the service server;
and adding a software type label corresponding to the software type in the software information to the software.
The identifying software running on the service server based on the process information in the service server comprises the following steps:
running a process command in the service server queries the process information to identify software running on the service server.
The identifying software running on the service server based on the process information in the service server comprises the following steps:
and identifying the software running on the service server according to the preset identification period based on the process information in the service server.
The operation and maintenance script of the software is established based on the software type label, and the operation and maintenance script of the software is input in a configuration management database, and the operation and maintenance script comprises:
outputting the software type label and receiving an operation and maintenance script of the software established based on the software type label;
and recording the operation and maintenance script of the software in a configuration management database by adopting a script for recording data.
The collecting, by the operation and maintenance script, configuration item data of the software includes:
and acquiring configuration item data of the software in a server of the software type label through the operation and maintenance script.
The collecting the configuration item data of the software comprises the following steps:
and acquiring configuration item data of the software through a timing task.
The step of inputting the configuration item data as an output result of the operation and maintenance script to the configuration management database through an application programming interface to realize data warehousing comprises the following steps:
acquiring the application programming interface;
and taking the configuration item data as an output result of the operation and maintenance script, and inputting the configuration item data into the configuration management database through the application programming interface to realize data storage.
The current software type tag is the same as the historical software history tag,
the operation and maintenance script of the software is established based on the software type label, and the operation and maintenance script of the software is input in a configuration management database, and the operation and maintenance script comprises:
and establishing a current operation and maintenance script of the software based on the historical software type label, and recording the current operation and maintenance script of the software in a configuration management database.
According to a second aspect of an embodiment of the present invention, there is provided an apparatus for data warehousing, including:
the identification module is used for identifying the software running on the service server and adding a software type label to the software;
the script module is used for establishing an operation and maintenance script of the software based on the software type label and inputting the operation and maintenance script of the software in the configuration management database;
the warehousing module is used for collecting the configuration item data of the software through the operation and maintenance script, and the configuration item data is used as an output result of the operation and maintenance script and is input into the configuration management database through an application programming interface to realize data storage.
According to a third aspect of an embodiment of the present invention, there is provided an electronic device for data warehousing, including:
one or more processors;
storage means for storing one or more programs,
the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the methods as described above.
According to a fourth aspect of embodiments of the present invention, there is provided a computer readable medium having stored thereon a computer program which when executed by a processor implements a method as described above.
According to a fifth aspect of embodiments of the present invention, there is provided a computer program product comprising a computer program which, when executed by a processor, implements a method as provided by embodiments of the present invention.
One embodiment of the above invention has the following advantages or benefits: identifying software running on a service server, and adding a software type label to the software; establishing an operation and maintenance script of the software based on the software type label, and recording the operation and maintenance script of the software in a configuration management database; and acquiring configuration item data of the software through the operation and maintenance script, and inputting the configuration item data serving as an output result of the operation and maintenance script to the configuration management database through an application programming interface to realize data storage. And storing the configuration item data of the software into a configuration management database by adopting an operation and maintenance script, so as to realize automatic data storage. The data can be put into storage in time, so that the effectiveness of the data is improved.
Further effects of the above-described non-conventional alternatives are described below in connection with the embodiments.
Drawings
The drawings are included to provide a better understanding of the invention and are not to be construed as unduly limiting the invention. Wherein:
FIG. 1 is a schematic flow diagram of a method of data warehousing according to an embodiment of the invention;
FIG. 2 is a schematic flow chart of identifying software and adding a software type tag according to an embodiment of the invention;
FIG. 3 is a flow diagram of an operation and maintenance script for logging software in a configuration management database according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of configuration item data of an operation and maintenance script acquisition software according to an embodiment of the present invention;
FIG. 5 is a flow chart of inputting the input result of an operation and maintenance script into a configuration management database according to an embodiment of the present invention;
FIG. 6 is a schematic diagram of the main structure of a data warehouse entry device according to an embodiment of the present invention;
FIG. 7 is an exemplary system architecture diagram in which embodiments of the present invention may be applied;
fig. 8 is a schematic diagram of a computer system suitable for use in implementing an embodiment of the invention.
Detailed Description
Exemplary embodiments of the present invention will now be described with reference to the accompanying drawings, in which various details of the embodiments of the present invention are included to facilitate understanding, and are to be considered merely exemplary. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness. The data acquisition, storage, use, processing and the like in the technical scheme meet the relevant regulations of national laws and regulations.
In order to solve the technical problems of time and labor consumption in the data warehouse entry process, the following technical scheme in the embodiment of the invention can be adopted.
Referring to fig. 1, fig. 1 is a main flow chart of a data warehousing method according to an embodiment of the invention, an operation and maintenance script is built by adding a software type identifier, and configuration item data is automatically collected by the operation and maintenance script and stored in a configuration management database to realize automatic data warehousing. As shown in fig. 1, the method specifically comprises the following steps:
s101, identifying software running on a service server, and adding a software type label to the software.
In an embodiment of the invention, the data warehousing includes implementing the data warehousing in a configuration management database (Configuration Management Database, CMDB). The CMDB is a logical database containing information about the full life cycle of configuration items and relationships between configuration items. As one example, the relationship between configuration items includes: physical relationships, real-time communication relationships, non-real-time communication relationships, and dependencies. A configuration item (configuration item, CI) is a collection of hardware, software, or both designed for configuration management. It is treated as a single entity in configuration management.
CMDB data configuration is often configured by manual entry or form importation. In the configuration process, the data validity is difficult to be ensured due to the longer configuration time. Such as: the requirement of large-batch warehouse entry can lead to larger configuration errors, time and labor are consumed, and the operation and maintenance cost is relatively high.
The service server carries data of the service system. As one example, the data of the business system includes base data, monitoring data, event data, change data, and production data. Such as:
the production data comprises warehouse-in article identifiers, warehouse-in article numbers, warehouse-out article identifiers and warehouse-out article numbers.
And a plurality of software is deployed in the service server, and the data is processed through the deployed software. As one example, the software includes one or more of the following: tomcat, weblogic, tuxedo, MQ middleware, oracle, mysql and elastiscearch databases.
Considering that a service server deploys more than one type of software, it is necessary to identify the software running on the service server first and add a software type tag to the software to which the software belongs.
Referring to fig. 2, fig. 2 is a schematic flow chart of identifying software and adding a software type tag according to an embodiment of the present invention. The method specifically comprises the following steps:
s201, identifying software running on the service server based on the process information in the service server.
The service server has the process information of the software running process, and the software running on the service server can be identified based on the process information in the service server.
In one embodiment of the invention, a process command is run in a service server to query process information to identify software running on the service server. As one example, in the case where the service server uses the Linux system, the process command includes a ps command. That is, the ps command is run in the service server to inquire the process information, and the software running on the service server is identified by the process information. The ps command returns a corresponding process string, and represents software running on the identified service server; ps command does not return the corresponding process string, which represents no software running on the service server.
In one embodiment of the invention, software running on the service server is identified according to a preset identification period based on process information in the service server. The process information in the service server changes with time, and in order to improve accuracy of identifying software, the software running on the service server can be identified according to a preset identification period. As one example, the preset recognition period may be 10 minutes.
S202, adding a software type label corresponding to the software type in the software information to the software.
After the software running on the service server is identified, a software type tag corresponding to the software type in the software information can be added to the software. As one example, the software types include: and adding the label a corresponding to the tomcat into the software.
In the embodiment of fig. 2, the software is identified using a software type tag, from which the type of software is known.
S102, establishing an operation and maintenance script of the software based on the software type label, and inputting the operation and maintenance script of the software in the configuration management database.
The purpose of adding a software type tag to software is to: and inputting the operation and maintenance script of the software in the configuration management database. An operation and maintenance script is a script for running and maintaining configuration item data of software.
Referring to fig. 3, fig. 3 is a flow diagram of an operation and maintenance script for logging software in a configuration management database according to an embodiment of the present invention. The method specifically comprises the following steps:
s301, outputting a software type label and receiving an operation and maintenance script of the software established based on the software type label.
In the embodiment of the invention, the operation and maintenance script of the software is received through outputting the software type label. As one example, a software type tag is output in an interactive interface. And receiving an operation and maintenance script of the software established based on the software type label at the interactive interface. Such as: and pre-establishing an operation and maintenance script of the software aiming at each software type label. Then, an operation and maintenance script of the software built based on the software type tag is transmitted.
As another example, a software type tag is sent to a database storing an operation and maintenance script of the software. And after receiving the software type label, the database storing the operation and maintenance script of the software sends the operation and maintenance script of the software established based on the software type label.
S302, inputting the operation and maintenance script of the software in the configuration management database by adopting the script for inputting the data.
And recording the operation and maintenance script of the software in the configuration management database. Specifically, a script for inputting data may be used to input an operation and maintenance script of software in the configuration management database. The script for inputting data is a script for inputting data in the configuration management database.
The operation and maintenance script of the software is recorded in the configuration management database, and the purpose of the operation and maintenance script is that: and automatically collecting data by adopting an operation and maintenance script. In the configuration management database, operation and maintenance scripts of various software are stored, so that the operation and maintenance scripts of the software can be adopted to automatically collect corresponding data.
In the embodiment of fig. 3, the software operation and maintenance script is entered in the configuration management database based on the software type tag. Different software type tags correspond to different operation and maintenance scripts.
S103, acquiring configuration item data of the software through the operation and maintenance script, and inputting the configuration item data as an output result of the operation and maintenance script to a configuration management database through an application programming interface to realize data storage.
And acquiring configuration item data by adopting an operation and maintenance script, and inputting the configuration item data into a configuration management database to realize data storage. Wherein the configuration item data includes configuration items and relationships between the configuration items.
In one embodiment of the present invention, collecting configuration item data of software through an operation and maintenance script includes: and collecting configuration item data of the software in a server of the software type label through the operation and maintenance script.
In the server of the software type tag, configuration item data of the software is stored. And the servers of different software type labels store configuration item data corresponding to the software types. Specifically, an operation and maintenance script is issued to a server of the software type label, and configuration item data of the software is collected through the operation and maintenance script.
In one embodiment of the invention, to increase the validity of configuration item data. Configuration item data for the software may be collected by a timed task. In this way, the configuration item data of the software is automatically collected in a timed task manner within a preset time period.
In one embodiment of the invention, the configuration item data comprises a json-format stored configuration item.
Referring to fig. 4, fig. 4 is a schematic diagram of configuration item data of an operation and maintenance script collecting software according to an embodiment of the present invention.
The software type tags in FIG. 4 include a Tomcat tag, an Oracle tag, a Mysql tag, and a Weblogic tag. Then, the configuration item data are collected by adopting a Tomcat operation and maintenance script, an Oracle operation and maintenance script, a Mysql operation and maintenance script and a Weblogic operation and maintenance script which correspond to the labels respectively.
Referring to fig. 5, fig. 5 is a flowchart illustrating an input result of an operation and maintenance script to a configuration management database according to an embodiment of the present invention. The method specifically comprises the following steps:
s501, acquiring an application programming interface.
In order to input the output result of the operation and maintenance script, an application programming interface needs to be acquired. Specifically, an Application Programming Interface (API) document of the CMDB is obtained.
S502, the configuration item data is used as an output result of the operation and maintenance script and is input into a configuration management database through an application programming interface to realize data storage.
And storing configuration item data acquired by the operation and maintenance script into a configuration management database as an output result of the operation and maintenance script. Specifically, the output result of the operation and maintenance script is input into a configuration management database through an application programming interface to realize data storage.
As one example, the output of the operation and maintenance script is: json format
{
"name": "Zhang san",
"age": 18,
"sex": "man",
"......": "......."
}
in the embodiment of fig. 5, the output result of the operation and maintenance script is input into the configuration management database through the application programming interface, so as to realize automatic data warehousing.
In one embodiment of the invention, it is contemplated that software running on the service server will change less over a period of time, such as: at 00:00 to 05:00, the software running in the service server hardly changes. That is, the current software type tag is the same as the historical software history tag. The current operation and maintenance script of the software can be established by using the historical software type label so as to improve the efficiency of inputting the current operation and maintenance script.
Specifically, a current operation and maintenance script of the software is established based on the historical software type label, and the current operation and maintenance script of the software is recorded in the configuration management database.
In the embodiment of the invention, the software running on the service server is identified, and a software type label is added to the software; establishing an operation and maintenance script of the software based on the software type label, and recording the operation and maintenance script of the software in a configuration management database; and acquiring configuration item data of the software through the operation and maintenance script, and inputting the configuration item data serving as an output result of the operation and maintenance script to the configuration management database through an application programming interface to realize data storage. The configuration item data of the software is stored into a configuration management database by adopting an operation and maintenance script, and realizing automatic data storage. The data can be put into storage in time, so that the effectiveness of the data is improved.
In the practical application scene of the embodiment of the invention, data storage of hundreds, even thousands of service servers is required to be realized at the same time. The manual operation has low data warehouse-in efficiency and high data error rate. By adopting the technical scheme in the embodiment of the invention, the software type label is automatically added for each service server, so that the operation and maintenance script of the software is input in the configuration management database. The operation and maintenance script corresponds to the software, and can automatically collect configuration item data of various software. And then, the configuration item data is subjected to data warehousing in a configuration management database.
Referring to fig. 6, fig. 6 is a schematic main structural diagram of a data warehousing device according to an embodiment of the present invention, where the data warehousing device may implement a data warehousing method, as shown in fig. 6, where the data warehousing device specifically includes:
the identifying module 601 is configured to identify software running on a service server, and add a software type tag to the software;
the script module 602 is configured to establish an operation and maintenance script of the software based on the software type tag, and enter the operation and maintenance script of the software in a configuration management database;
and the warehousing module 603 is configured to collect configuration item data of the software through the operation and maintenance script, and input the configuration item data as an output result of the operation and maintenance script to the configuration management database through an application programming interface to realize data warehousing.
In one embodiment of the present invention, the identification module 601 is specifically configured to identify software running on the service server based on the process information in the service server;
and adding a software type label corresponding to the software type in the software information to the software.
In one embodiment of the present invention, the identification module 601 is specifically configured to execute a process command in the service server to query the process information to identify software running on the service server.
In one embodiment of the present invention, the identification module 601 is specifically configured to identify software running on the service server according to a preset identification period based on process information in the service server.
In one embodiment of the present invention, the script module 602 is specifically configured to output the software type tag, and receive an operation and maintenance script of the software built based on the software type tag;
and recording the operation and maintenance script of the software in a configuration management database by adopting a script for recording data.
In one embodiment of the present invention, the warehousing module 603 is specifically configured to collect, through the operation and maintenance script, configuration item data of the software in the server of the software type tag.
In one embodiment of the present invention, the binning module 603 is specifically configured to collect configuration item data of the software through a timing task.
In one embodiment of the present invention, the binning module 603 is specifically configured to obtain the application programming interface;
and taking the configuration item data as an output result of the operation and maintenance script, and inputting the configuration item data into the configuration management database through the application programming interface to realize data storage.
In one embodiment of the invention, the current software type tag is the same as the historical software history tag. The script module 602 is specifically configured to establish a current operation and maintenance script of the software based on the historical software type tag, and enter the current operation and maintenance script of the software in a configuration management database.
Fig. 7 illustrates an exemplary system architecture 700 of a data warehousing method or data warehousing apparatus to which embodiments of the invention may be applied.
As shown in fig. 7, a system architecture 700 may include terminal devices 701, 702, 703, a network 704, and a server 705. The network 704 is the medium used to provide communication links between the terminal devices 701, 702, 703 and the server 705. The network 704 may include various connection types, such as wired, wireless communication links, or fiber optic cables, among others.
A user may interact with the server 705 via the network 704 using the terminal devices 701, 702, 703 to receive or send messages or the like. Various communication client applications such as shopping class applications, web browser applications, search class applications, instant messaging tools, mailbox clients, social platform software, etc. (by way of example only) may be installed on the terminal devices 701, 702, 703.
The terminal devices 701, 702, 703 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smartphones, tablets, laptop and desktop computers, and the like.
The server 705 may be a server providing various services, such as a background management server (by way of example only) providing support for shopping-type websites browsed by users using the terminal devices 701, 702, 703. The background management server may analyze and process the received data such as the product information query request, and feedback the processing result (e.g., the target push information, the product information—only an example) to the terminal device.
It should be noted that, the method for data storage provided in the embodiment of the present invention is generally executed by the server 705, and accordingly, the device for data storage is generally disposed in the server 705.
It should be understood that the number of terminal devices, networks and servers in fig. 7 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.
The computer program product of the embodiment of the invention comprises a computer program, and the program is executed by a processor to realize the data warehousing method provided by the embodiment of the invention.
Referring now to FIG. 8, there is illustrated a schematic diagram of a computer system 800 suitable for use in implementing an embodiment of the present invention. The terminal device shown in fig. 8 is only an example, and should not impose any limitation on the functions and the scope of use of the embodiment of the present invention.
As shown in fig. 8, the computer system 800 includes a Central Processing Unit (CPU) 801 that can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM) 802 or a program loaded from a storage section 808 into a Random Access Memory (RAM) 803. In the RAM 803, various programs and data required for the operation of the system 800 are also stored. The CPU 801, ROM 802, and RAM 803 are connected to each other by a bus 804. An input/output (I/O) interface 805 is also connected to the bus 804.
The following components are connected to the I/O interface 805: an input portion 806 including a keyboard, mouse, etc.; an output portion 807 including a display such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and a speaker; a storage section 808 including a hard disk or the like; and a communication section 809 including a network interface card such as a LAN card, a modem, or the like. The communication section 809 performs communication processing via a network such as the internet. The drive 810 is also connected to the I/O interface 805 as needed. A removable medium 811 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 810 as needed so that a computer program read out therefrom is mounted into the storage section 808 as needed.
In particular, according to embodiments of the present disclosure, the processes described above with reference to flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method shown in the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network via the communication section 809, and/or installed from the removable media 811. The above-described functions defined in the system of the present invention are performed when the computer program is executed by a Central Processing Unit (CPU) 801.
The computer readable medium shown in the present invention may be a computer readable signal medium or a computer readable storage medium, or any combination of the two. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples of the computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In the present invention, however, the computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, with the computer-readable program code embodied therein. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.
The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The modules involved in the embodiments of the present invention may be implemented in software or in hardware. The described modules may also be provided in a processor, for example, as: a processor includes an identification module, a script module, and a binning module. The names of these modules do not constitute a limitation on the module itself in some cases, and for example, the identification module may also be described as "for identifying software running on a service server and adding a software type tag to the software".
As another aspect, the present invention also provides a computer-readable medium that may be contained in the apparatus described in the above embodiments; or may be present alone without being fitted into the device. The computer readable medium carries one or more programs which, when executed by a device, cause the device to include:
identifying software running on a service server, and adding a software type label to the software;
establishing an operation and maintenance script of the software based on the software type label, and recording the operation and maintenance script of the software in a configuration management database;
and acquiring configuration item data of the software through the operation and maintenance script, and inputting the configuration item data serving as an output result of the operation and maintenance script to the configuration management database through an application programming interface to realize data storage.
According to the technical scheme of the embodiment of the invention, the software running on the service server is identified, and a software type label is added to the software; establishing an operation and maintenance script of the software based on the software type label, and recording the operation and maintenance script of the software in a configuration management database; and acquiring configuration item data of the software through the operation and maintenance script, and inputting the configuration item data serving as an output result of the operation and maintenance script to the configuration management database through an application programming interface to realize data storage. And storing the configuration item data of the software into a configuration management database by adopting an operation and maintenance script, so as to realize automatic data storage. The data can be put into storage in time, so that the effectiveness of the data is improved.
The above embodiments do not limit the scope of the present invention. It will be apparent to those skilled in the art that various modifications, combinations, sub-combinations and alternatives can occur depending upon design requirements and other factors. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the scope of the present invention.
In the technical scheme of the invention, the aspects of acquisition, analysis, use, transmission, storage and the like of the related user personal information all meet the requirements of related laws and regulations, are used for legal and reasonable purposes, are not shared, leaked or sold outside the aspects of legal use and the like, and are subjected to supervision and management of a supervision department. Necessary measures should be taken for the personal information of the user to prevent illegal access to such personal information data, ensure that personnel having access to the personal information data comply with the regulations of the relevant laws and regulations, and ensure the personal information of the user. Once these user personal information data are no longer needed, the risk should be minimized by limiting or even prohibiting the data collection and/or deletion.
User privacy is protected, when applicable, by de-identifying the data, including in some related applications, such as by removing a particular identifier (e.g., date of birth, etc.), controlling the amount or specificity of stored data (e.g., collecting location data at a city level rather than at a specific address level), controlling how the data is stored, and/or other methods.
Claims (13)
1. A method of data warehousing, comprising:
identifying software running on a service server, and adding a software type label to the software;
establishing an operation and maintenance script of the software based on the software type label, and recording the operation and maintenance script of the software in a configuration management database;
and acquiring configuration item data of the software through the operation and maintenance script, and inputting the configuration item data serving as an output result of the operation and maintenance script to the configuration management database through an application programming interface to realize data storage.
2. The method of data warehousing of claim 1, wherein the identifying software running on a service server and adding a software type tag to the software comprises:
identifying software running on the service server based on the process information in the service server;
and adding a software type label corresponding to the software type in the software information to the software.
3. The method of data warehousing of claim 2, wherein the identifying software running on the service server based on process information in the service server comprises:
running a process command in the service server queries the process information to identify software running on the service server.
4. The method of data warehousing of claim 2, wherein the identifying software running on the service server based on process information in the service server comprises:
and identifying the software running on the service server according to the preset identification period based on the process information in the service server.
5. The method of data warehousing of claim 1, wherein the creating an operation and maintenance script for the software based on the software type tag, entering the operation and maintenance script for the software in a configuration management database, comprises:
outputting the software type label and receiving an operation and maintenance script of the software established based on the software type label;
and recording the operation and maintenance script of the software in a configuration management database by adopting a script for recording data.
6. The method of data warehousing of claim 1, wherein the collecting, by the operation and maintenance script, configuration item data of the software comprises:
and acquiring configuration item data of the software in a server of the software type label through the operation and maintenance script.
7. The method of data warehousing of claim 6, wherein the collecting configuration item data of the software comprises:
and acquiring configuration item data of the software through a timing task.
8. The method of claim 1, wherein the inputting the configuration item data as the output result of the operation and maintenance script to the configuration management database via an application programming interface to realize data warehousing comprises:
acquiring the application programming interface;
and taking the configuration item data as an output result of the operation and maintenance script, and inputting the configuration item data into the configuration management database through the application programming interface to realize data storage.
9. The method of claim 1, wherein the current software type tag is the same as the historical software history tag,
the operation and maintenance script of the software is established based on the software type label, and the operation and maintenance script of the software is input in a configuration management database, and the operation and maintenance script comprises:
and establishing a current operation and maintenance script of the software based on the historical software type label, and recording the current operation and maintenance script of the software in a configuration management database.
10. An apparatus for data warehousing, comprising:
the identification module is used for identifying the software running on the service server and adding a software type label to the software;
the script module is used for establishing an operation and maintenance script of the software based on the software type label and inputting the operation and maintenance script of the software in the configuration management database;
and the warehousing module is used for collecting the configuration item data of the software through the operation and maintenance script, and inputting the configuration item data serving as an output result of the operation and maintenance script to the configuration management database through an application programming interface to realize data warehousing.
11. An electronic device for data warehousing, comprising:
one or more processors;
storage means for storing one or more programs,
when executed by the one or more processors, causes the one or more processors to implement the method of any of claims 1-9.
12. A computer readable medium, on which a computer program is stored, characterized in that the program, when being executed by a processor, implements the method according to any of claims 1-9.
13. A computer program product comprising a computer program which, when executed by a processor, implements the method according to any one of claims 1-9.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310715929.1A CN116450622B (en) | 2023-06-16 | 2023-06-16 | Method, apparatus, device and computer readable medium for data warehouse entry |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310715929.1A CN116450622B (en) | 2023-06-16 | 2023-06-16 | Method, apparatus, device and computer readable medium for data warehouse entry |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN116450622A true CN116450622A (en) | 2023-07-18 |
| CN116450622B CN116450622B (en) | 2023-09-22 |
Family
ID=87127681
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310715929.1A Active CN116450622B (en) | 2023-06-16 | 2023-06-16 | Method, apparatus, device and computer readable medium for data warehouse entry |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116450622B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117492874A (en) * | 2023-10-26 | 2024-02-02 | 厦门国际银行股份有限公司 | Middleware configuration discovery management method, system, equipment and storage medium |
Citations (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| GB201212168D0 (en) * | 2009-12-18 | 2012-08-22 | Ibm | Method, program, and system for forming configuration information of configuring element of system containing configuring element wherein acquisition |
| CN106325951A (en) * | 2016-08-30 | 2017-01-11 | 广西电网有限责任公司 | Automatic deployment method for application system supporting multiple databases and multiple middleware types |
| CN109086182A (en) * | 2018-06-27 | 2018-12-25 | 平安科技（深圳）有限公司 | The method and terminal device of database auto-alarming |
| CN111125226A (en) * | 2019-12-24 | 2020-05-08 | 中国建设银行股份有限公司 | Configuration data acquisition method and device |
| CN111580884A (en) * | 2020-04-30 | 2020-08-25 | 北京金山云网络技术有限公司 | Configuration updating method and device, server and electronic equipment |
| CN111858253A (en) * | 2020-07-23 | 2020-10-30 | 平安普惠企业管理有限公司 | Server operation and maintenance control method and device, computer equipment and storage medium |
| CN111930466A (en) * | 2020-05-28 | 2020-11-13 | 武汉达梦数据库有限公司 | Kubernetes-based data synchronization environment deployment method and device |
| CN112235130A (en) * | 2020-09-23 | 2021-01-15 | 建信金融科技有限责任公司 | Method and device for realizing operation and maintenance automation based on SDN network |
| CN112346752A (en) * | 2020-12-03 | 2021-02-09 | 江苏云坤信息科技有限公司 | Software environment rapid deployment method based on jenkins and K3S |
| CN112882700A (en) * | 2021-02-09 | 2021-06-01 | 京东方科技集团股份有限公司 | iOS application program construction method and device, electronic equipment and storage medium |
| CN113094088A (en) * | 2021-04-15 | 2021-07-09 | 中国建设银行股份有限公司 | Database configuration information acquisition method and device, computer equipment and storage medium |
| CN113806176A (en) * | 2021-09-22 | 2021-12-17 | 中国建设银行股份有限公司 | Data object identification method and device based on configuration management |
| CN114090019A (en) * | 2021-11-19 | 2022-02-25 | 浪潮云信息技术股份公司 | Code construction, scanning and storage platform based on software integration |
| CN114116679A (en) * | 2021-12-09 | 2022-03-01 | 建信金融科技有限责任公司 | Multi-database environment operation and maintenance method and system |
| CN114185590A (en) * | 2021-12-17 | 2022-03-15 | 中国建设银行股份有限公司 | Application system operation and maintenance configuration management method and device |
| US20230088244A1 (en) * | 2021-09-20 | 2023-03-23 | Servicenow, Inc. | Common Interface for Supporting Virtualized Architectures |
-
2023
- 2023-06-16 CN CN202310715929.1A patent/CN116450622B/en active Active
Patent Citations (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| GB201212168D0 (en) * | 2009-12-18 | 2012-08-22 | Ibm | Method, program, and system for forming configuration information of configuring element of system containing configuring element wherein acquisition |
| CN106325951A (en) * | 2016-08-30 | 2017-01-11 | 广西电网有限责任公司 | Automatic deployment method for application system supporting multiple databases and multiple middleware types |
| CN109086182A (en) * | 2018-06-27 | 2018-12-25 | 平安科技（深圳）有限公司 | The method and terminal device of database auto-alarming |
| CN111125226A (en) * | 2019-12-24 | 2020-05-08 | 中国建设银行股份有限公司 | Configuration data acquisition method and device |
| CN111580884A (en) * | 2020-04-30 | 2020-08-25 | 北京金山云网络技术有限公司 | Configuration updating method and device, server and electronic equipment |
| CN111930466A (en) * | 2020-05-28 | 2020-11-13 | 武汉达梦数据库有限公司 | Kubernetes-based data synchronization environment deployment method and device |
| CN111858253A (en) * | 2020-07-23 | 2020-10-30 | 平安普惠企业管理有限公司 | Server operation and maintenance control method and device, computer equipment and storage medium |
| CN112235130A (en) * | 2020-09-23 | 2021-01-15 | 建信金融科技有限责任公司 | Method and device for realizing operation and maintenance automation based on SDN network |
| CN112346752A (en) * | 2020-12-03 | 2021-02-09 | 江苏云坤信息科技有限公司 | Software environment rapid deployment method based on jenkins and K3S |
| CN112882700A (en) * | 2021-02-09 | 2021-06-01 | 京东方科技集团股份有限公司 | iOS application program construction method and device, electronic equipment and storage medium |
| WO2022170801A1 (en) * | 2021-02-09 | 2022-08-18 | 京东方科技集团股份有限公司 | Ios application program construction method and apparatus, electronic device, and storage medium |
| CN113094088A (en) * | 2021-04-15 | 2021-07-09 | 中国建设银行股份有限公司 | Database configuration information acquisition method and device, computer equipment and storage medium |
| US20230088244A1 (en) * | 2021-09-20 | 2023-03-23 | Servicenow, Inc. | Common Interface for Supporting Virtualized Architectures |
| CN113806176A (en) * | 2021-09-22 | 2021-12-17 | 中国建设银行股份有限公司 | Data object identification method and device based on configuration management |
| CN114090019A (en) * | 2021-11-19 | 2022-02-25 | 浪潮云信息技术股份公司 | Code construction, scanning and storage platform based on software integration |
| CN114116679A (en) * | 2021-12-09 | 2022-03-01 | 建信金融科技有限责任公司 | Multi-database environment operation and maintenance method and system |
| CN114185590A (en) * | 2021-12-17 | 2022-03-15 | 中国建设银行股份有限公司 | Application system operation and maintenance configuration management method and device |
Non-Patent Citations (3)
| Title |
|---|
| V. TAM 等: "A fast and flexible framework of scripting for Web application development: a preliminary experience report", 《PROCEEDINGS OF THE FIRST INTERNATIONAL CONFERENCE ON WEB INFORMATION SYSTEMS ENGINEERING》, vol. 1, pages 450 - 455, XP010521887, DOI: 10.1109/WISE.2000.882425 * |
| 冷迪: "自动化运维管理平台设计及实现", 《技术与市场》, vol. 25, no. 11, pages 62 - 64 * |
| 湛蓝 等: "配置管理应用框架的设计及应用", 《金融科技时代》, no. 09, pages 56 - 59 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117492874A (en) * | 2023-10-26 | 2024-02-02 | 厦门国际银行股份有限公司 | Middleware configuration discovery management method, system, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN116450622B (en) | 2023-09-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110019350B (en) | Data query method and device based on configuration information | |
| CN109446274B (en) | Method and device for managing BI metadata of big data platform | |
| CN111038906B (en) | Order sorting method and device | |
| CN111324786B (en) | Method and device for processing consultation problem information | |
| CN111427701A (en) | Workflow engine system and business processing method | |
| CN110795315A (en) | Method and device for monitoring service | |
| CN111460129A (en) | Method and device for generating identification, electronic equipment and storage medium | |
| CN116450622B (en) | Method, apparatus, device and computer readable medium for data warehouse entry | |
| CN111984234A (en) | Method and device for processing work order | |
| CN116303608A (en) | Data processing method and device for application service | |
| CN110895591B (en) | Method and device for positioning self-lifting point | |
| CN114297278A (en) | Method, system and device for quickly writing batch data | |
| CN110928594A (en) | Service development method and platform | |
| CN113190558A (en) | Data processing method and system | |
| CN110866001A (en) | Method and device for determining order to be processed | |
| CN111858621B (en) | Method, apparatus, device and computer readable medium for monitoring business process | |
| CN114138758A (en) | Data cleaning and merging method and device based on multi-source system and readable medium | |
| CN112559001B (en) | Method and device for updating application | |
| CN113282455A (en) | Monitoring processing method and device | |
| CN109087097B (en) | Method and device for updating same identifier of chain code | |
| CN109213815B (en) | Method, device, server terminal and readable medium for controlling execution times | |
| CN113779017A (en) | Method and apparatus for data asset management | |
| CN113704222A (en) | Method and device for processing service request | |
| CN113535768A (en) | Production monitoring method and device | |
| CN112214500A (en) | Data comparison method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |