Back to results
US 11,379,434 B2Granted
Efficient and automatic database patching using elevated privileges
AssigneeJPMorgan Chase Bank, N.A.
InventorsMustafa Sherazi, Barath Thankappan, Christopher Festa
Life of this patent
Estimating the term…
Abstract
Systems and methods for improved database patching are provided. Exemplary embodiments may receive a database patching request and access patching instructions related to the database patching request. A configuration file based on the patching instructions may then be generated at a patching server. A controller may then execute a command at the patching server which causes the patching server to establish a direct connection to a client database and transmit the configuration file to the client database. The controller may then execute a command which causes the client database to perform a database patching activity.
Claims20
A method of database patching, the method comprising:
- generating, with a patching server, a configuration file based on patching instructions from a patching controller that is a separate device from the patching server, wherein the configuration file comprises at least a first patching server command and a first client database command;
- receiving, with the patching controller, a database patching request from a user computer having a user interface for entering a database patching request;
- accessing, with the patching controller, the patching instructions related to the database patching request;
- transmitting the patching instructions from the patching controller to the patching server, thereby causing the patching server to generate the configuration file based on the patching instructions;
- triggering, with the patching controller, executing of the first client database command by the patching server;
- executing, with the patching server, the first patching server command triggered by the patching controller, which causes the patching server to establish a direct connection to a client database and transmit the configuration file to the client database;
- executing, with the patching server, of the first client database command causing the client database to:
- perform at least one database patching activity;
- generate a patching output file based on the database patching activity;
- and,
- transmit the patching output file to the patching server;
- wherein the patching controller receives the database patching request, accesses the patching instructions, and triggers execution of the first client database command, while the patching server generates and transmits the configuration file to the client database, thereby allocating to different devices i) the generating of the configuration file and transmitting the configuration file to the client database, and ii) receiving the database patching request, the accessing of the patching instructions, and triggering execution of the first database command;
- and
- parsing the patching output file at the patching server.
11 more elements
A system for database patching, the system comprising:
- a patching controller;
- and
- a patching server, which is a separate device from the patching controller, configured to generate a configuration file based on patching instructions from the patching controller, wherein the configuration file comprises at least a first patching server command and a first client database command;
- and
- the patching controller comprising a computer configured to:
- receive a database patching request from a user computer having a user interface for entering a database patching request;
- access the patching instructions related to the database patching request;
- transmit the patching instructions to the patching server, causing the patching server to generate the configuration file based on the patching instructions;
- and
- trigger execution of the first client database command by the patching server, which causes the patching server to establish a direct connection to a client database and transmit the configuration file to the client database;
- triggering of execution of the first client database command causing the client database to:
- perform at least one patching activity;
- generate a patching output file based on the database patching activity;
- and
- transmit the patching output file to the patching server, causing the patching server to parse the patching output file,
- wherein the patching controller receives the database patching request, accesses the patching instructions, and triggers execution of the first client database command, while the patching server generates and transmits the configuration file to the client database, thereby allocating to different devices i) the generating of the configuration file and transmitting the configuration file to the client database, and ii) receiving the database patching request, the accessing of the patching instructions, and triggering execution of the first client database command.
13 more elements
Dependencies are inferred from the claim text.