# US 2022/0046036 A1 · Mirage Instance of a Database Server

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2022/0046036 A1
- Document ID: US20220046036A1
- Status: Published application
- Kind: A1
- Application number: 16/984,165
- Filed: 2020-08-04
- Published: 2022-02-10
- Earliest claimed: 2020-08-04
- Assignees: Oracle International Corporation
- Applicants: Oracle International Corporation
- Inventors: Mehul D. Bastawala; Ravi Thammaiah
- Web page: https://patentgrep.com/patent/US20220046036A1

## CPC

- G06F 16/2471: {Distributed queries}
- G06F 11/3006: {where the computing system is distributed, e.g. networked systems, clusters, multiprocessor systems (multiprogramming arrangements G06F9/46; allocation of resources G06F9/50)}
- G06F 11/3433: {for load management (allocation of a server based on load conditions G06F9/505; load rebalancing G06F9/5083; redistributing the load in a network by a load balancer H04L67/1029)}
- G06F 11/3452: {Performance evaluation by statistical analysis}
- G06F 11/3612: {by runtime analysis (performance monitoring G06F11/3466)}
- G06F 16/21: Design, administration or maintenance of databases
- G06F 16/24: Querying
- G06F 16/252: {between a Database Management System and a front-end application}
- G06F 16/27: Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F 2201/80: Database-specific techniques
- G06F 2201/81: Threshold
- H04L 63/1416: {Event detection, e.g. attack signature detection}
- H04L 63/1425: {Traffic logging, e.g. anomaly detection}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- H04L: TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION (arrangements common to telegraphic and telephonic communication H04M)

## Abstract

Instances of a database server can be of two kinds, regular or mirage that respectively handle database requests in sessions behaving normally or abnormally, and based on changes in behavior, sessions are relocated therebetween. Behavior of sessions is evaluated based on statistics generated in processing requests in individual steps within one or more stages, such as parse stage. The evaluation may be automatically tuned by changing tests that are enabled based on priorities, changing thresholds within tests, changing whether sessions are evaluated together as a group, and changing periodicity of evaluation. Evaluation may be triggered by news of normal/abnormal activity in locations of sessions' origin. Mirage instances can be of multiple classes, execute in lower/higher capacity computers. Sessions may start in either kind of instance. Sessions may be relocated for reasons unrelated to maliciousness, such as excessive utilization of resources, excessive errors, or update of software of the database server.

## Claims

### Claim 1

A method of managing a database management system in one or more computers, the method comprising:
receiving one or more requests to perform database operations in a specific session that originates from a specific client application outside the one or more computers;
handling the one or more requests of the specific session at least partially, in one or more instances of a database server of a first kind in the database management system or in one or more instances of a database server of a second kind in the database management system;
automatically relocating the handling, from a first instance among the one or more instances of the database server of the first kind to a second instance among the one or more instances of the database server of the second kind; and
automatically relocating the handling, from the second instance to an instance among the one or more instances of the database server of the first kind; and
transmitting to the specific client application, in the specific session, at least a result of the handling.

### Claim 2 (depends on 1)

The method of claim 1 wherein:
the automatically relocating of the handling, from the first instance to the second instance, is performed at least partially in response to occurrence of a predetermined event during the handling in the first instance.

### Claim 3 (depends on 1)

The method of claim 1 wherein:
the automatically relocating of the handling, from the first instance to the second instance, is performed at least partially in response to a first outcome of a first evaluation that applies one or more first tests to one or more first statistics, the one or more first statistics being generated based on the handling in the first instance.

### Claim 4 (depends on 3)

The method of claim 3 further comprising:
automatically changing one or more first thresholds used in the one or more first tests, in response to a percentage of sessions that are handled in the second instance exceeding an upper limit thereon.

### Claim 5 (depends on 3)

The method of claim 3 further comprising:
automatically disabling at least one test in the one or more first tests, in response to finding that usage at machine level of a computational resource by the first instance in a specific computer among the one or more computers is greater than or equal to, or greater than, an upper limit thereon; and
automatically enabling at least one test in the one or more first tests, at least on finding that the usage of the computational resource is less than or equal to, or less than, a lower limit thereon.

### Claim 6 (depends on 3)

The method of claim 3 wherein:
before the first evaluation, the handling in the first instance is performed in a plurality of stages, the plurality of stages comprising a parse stage, an execution stage, and a fetch stage, at least one of the stages comprising a plurality of steps; and
the one or more first statistics comprise multiple statistics generated in corresponding multiple steps in the plurality of steps.

### Claim 7 (depends on 3)

The method of claim 3 wherein:
among the first statistics, a statistic specific to the specific session is generated in the first instance at least by counting news reports of hacking in a geographic location of a client computer in which execute the specific client application from which originates the specific session.

### Claim 8 (depends on 3)

The method of claim 3 wherein:
among the one or more first statistics, a particular first statistic counts errors related to transmission of requests received by the first instance in the specific session over a communication network;
the first evaluation further comprises applying to the particular first statistic, a first test for abnormality; and
the automatically relocating from the first instance to the second instance is based on the particular first statistic satisfying the first test for abnormality.

### Claim 9 (depends on 3)

The method of claim 3 wherein:
before the automatically relocating from the first instance to the second instance, a particular first statistic among the one or more first statistics measures usage of a particular resource in the first instance, by the handling of the one or more requests received in the specific session;
the first evaluation comprises applying to the particular first statistic, a first test for abnormality;
wherein the automatically relocating from the first instance to the second instance is based on the particular first statistic satisfying the first test for abnormality.

### Claim 10 (depends on 3)

The method of claim 3 wherein:
the first instance executes in a first computer comprising a first hardware component of a specific type with a first capacity;
the second instance executes in a second computer comprising a second hardware component of the specific type with a second capacity, the second capacity being lower than the first capacity;
the one or more first statistics comprise one or more error statistics that count occurrences of one or more respective errors in the handling of the one or more requests;
the one or more first statistics further comprise one or more resource usage statistics that respectively measure usage of one or more particular resources by the handling of the one or more requests;
the first evaluation finds that among the one or more error statistics, at least one error statistic specific to the specific session satisfies at least one test for abnormality;
an additional second instance of the database server executes in a third computer comprising a third hardware component of the specific type with a third capacity, the third capacity being higher than the first capacity;
the method further comprises automatically relocating one or more additional sessions, from the first instance to the additional second instance based on an additional evaluation; and
the additional evaluation finds that at least one additional resource usage statistic specific to the one or more additional sessions satisfies another test for abnormality.

### Claim 11 (depends on 1)

The method of claim 1 wherein:
the automatically relocating from the first instance to the second instance is performed at least partially in response to a first outcome of a first evaluation;
the automatically relocating from the second instance to said any instance is performed at least partially in response to a second outcome of a second evaluation; and
the second evaluation performs one or more checks that are not performed by the first evaluation.

### Claim 12 (depends on 1)

The method of claim 1 further comprising:
automatically starting execution of at least the second instance by the first instance issuing a command to cluster ware.

### Claim 13 (depends on 12)

The method of claim 12 further comprising:
automatically starting execution of one or more additional second instances, at least partially based on: usage at machine level of a computational resource in a specific computer by the second instance being above a first upper limit thereon, or a number of sessions handled by the second instance being above a second upper limit thereon; and
automatically shutting down the second instance, at least partially in response to: the usage of the computational resource by the second instance being below a first lower limit thereon or the number of sessions handled by the second instance being below a second lower limit thereon.

### Claim 14 (depends on 1)

The method of claim 1 wherein:
a first number of processes of a specific type in the first instance is greater than a second number of processes of the specific type in the second instance.

### Claim 15 (depends on 1)

The method of claim 1 wherein:
the automatically relocating from the first instance to the second instance is performed at least partially in response to a first outcome of a first evaluation;
the first evaluation applies one or more first tests to one or more first statistics, the one or more first statistics being specific to the specific session and being generated based on the handling in the first instance;
among the one or more first statistics specific to the one or more sessions, a particular first statistic counts occurrences of a particular error or measures usage of a particular resource;
the automatically relocating from the second instance to said any instance is performed at least partially in response to a second outcome of a second evaluation;
the second evaluation applies one or more second tests to one or more second statistics, the one or more second statistics being specific to the specific session and being generated based on the handling in the second instance;
among the one or more second statistics specific to the one or more sessions, a particular second statistic counts occurrences of the particular error or measures usage of the particular resource; and
a first threshold in a first test applied to the particular first statistic in the first evaluation is different from a second threshold in a second test applied to a particular second statistic in the second evaluation.

### Claim 16 (depends on 1)

The method of claim 1 wherein:
the specific session is set up initially with the first instance; and
each of the one or more first instances is a mirage instance, and each of the one or more second instances is a regular instance.

### Claim 17 (depends on 1)

The method of claim 1 wherein the specific session is hereinafter a first session and wherein:
the automatically relocating from the first instance to the second instance is performed at least partially in response to a first evaluation; and
the method further comprises automatically relocating one or more second sessions from the first instance to the second instance, at least partially in response to the first evaluation finding the first session to be abnormal and in addition finding a pattern between one or more first statistics specific to the first session and one or more second statistics specific to the one or more second sessions.

### Claim 18 (depends on 1)

The method of claim 1 wherein t the specific session is hereinafter a first session and wherein:
the automatically relocating from the first instance to the second instance is performed at least partially in response to a first evaluation;
the first session and one or more second sessions are grouped into a first group, and additional sessions are grouped into at least a second group; and
the method further comprises automatically relocating one or more second sessions from the first instance to the second instance, at least partially in response to the first evaluation finding the first session to be abnormal and in addition finding a preset limit is exceeded by a count of sessions in the first group which relocated from the first instance to the second instance.

### Claim 19 (depends on 1)

The method of claim 1 wherein:
the automatically relocating from the first instance to the second instance is performed at least partially in response to a first outcome of a first evaluation;
the automatically relocating from the second instance to said any instance is performed at least partially in response to a second outcome of a second evaluation;
at least one of the first evaluation or the second evaluation is repeated at a periodic time interval; and
the periodic time interval is automatically increased for at least the one or more sessions, on finding a preset limit being exceeded by a number of times of performance of the automatically relocatings.

### Claim 20 (depends on 1)

The method of claim 1 wherein the automatically relocating from the first instance to the second instance is performed at least partially in response to a first outcome of a first evaluation that applies one or more first tests to one or more first statistics, the one or more first statistics being generated based on the handling in the first instance; and
the method further comprises:
obtaining an indication of enablement or disablement of a statistic among the one or more first statistics by using one or more tables, based on a priority with which the statistic is associated; and
based on the indication of enablement or disablement, the statistic is used or not used respectively, in the first evaluation;
wherein the using of the one or more tables comprises:
based on a current value of a criterion, looking up a first table, to identify enablement or disablement of a plurality of priorities, the plurality of priorities comprising said priority; and
based on the plurality of priorities, looking up a second table, to determine indications of enablement or disablement of the one or more first statistics that comprise said statistic.

### Claim 21 (depends on 1)

The method of claim 1 wherein:
the automatically relocating from the first instance to the second instance is performed at least partially in response to a first outcome of a first evaluation that applies one or more first tests to one or more first statistics, the one or more first statistics being generated based on the handling in the first instance;
each statistic among the one or more first statistics is generated by a corresponding stage or by a corresponding step within a stage, in the handling; and
in the first evaluation:
using the one or more first statistics individually by applying corresponding thresholds thereto, when a current measurement of resource usage is in a first range; and
using a cumulative statistic obtained by adding the one or more first statistics to one another and applying a single threshold to the cumulative statistic, when the current measurement of resource usage is in a second range above the first range.

### Claim 22 (depends on 1)

The method of claim 1 wherein the one or more sessions are hereinafter one or more first sessions, and the method further comprises:
the second instance performing, on requests received in the one or more first sessions, at least a first additional check, wherein the second instance does not perform a second additional check;
handling additional requests of one or more additional sessions in the first instance;
automatically relocating the handling of additional requests of the one or more additional sessions, from the first instance to another second instance among the one or more instances of the database server of the second kind; and
the another second instance performing, on new requests received in the one or more additional sessions after the automatically relocating of the handling of additional requests of the one or more additional sessions, at least the second additional check, wherein the another second instance does not perform the first additional check.

### Claim 23 (depends on 1)

The method of claim 1 wherein:
the automatically relocating from the first instance to the second instance is performed at least partially in response to a first outcome of a first evaluation;
the automatically relocating from the second instance to said any instance is performed at least partially in response to a second outcome of a second evaluation;
the second evaluation comprises checking a history of errors, to determine whether a current error whose occurrence is counted by any of the first statistics matches any previous error that occurred before a current change to the database management system; and
the method further comprises:
checking on availability of a new software update associated with the current error, at least based on the second evaluation finding that the current error did not occur before the current change to the database management system; and
automatically installing the new software update in at least said any instance, in response to finding the new software update is available;
wherein the automatically relocating from the second instance to said any instance is performed after the installing of the new software update.

### Claim 24 (depends on 23)

The method of claim 23 wherein:
the checking on availability finds that no new software update associated with the current error is available; and
said any instance executes a version of software of the database server prior to the current change to the database management system.

### Claim 25 (depends on 23)

The method of claim 23 wherein:
the handling in the second instance comprises recording a sequence of calls to a second database;
the automatically relocating from the second instance to said any instance is performed after the installing of the new software update; and
the handling in said any instance comprises replaying the sequence of calls, on a first database; and
the first database is accessed by the one or more instances of the database server of the first kind, the second database is accessed by the one or more instances of the database server of the second kind; and
the second database is a replica of the first database.

### Claim 26 (depends on 1)

The method of claim 1 wherein:
the automatically relocating from the first instance to the second instance is performed without notifying the specific client application; and
the automatically relocating from the second instance to said any instance is performed without notifying the specific client application.

### Claim 27

One or more computer-readable storage media comprising a plurality of instructions to one or more processors to manage a database management system in one or more computers, the plurality of instructions comprising:
instructions to receive one or more requests to perform database operations in a specific session that originates from a specific client application outside the one or more computers;
instructions to handle the one or more requests at least partially, in one or more instances of a database server of a first kind in the database management system or in one or more instances of a database server of a second kind in the database management system;
instructions to automatically relocate handling, from a first instance among the one or more instances of the database server of the first kind to a second instance among the one or more instances of the database server of the second kind, when the handling is in the first instance; and
instructions to automatically relocate the handling, from the second instance to any instance among the one or more instances of the database server of the first kind, when the handling is in the second instance; and
instructions to transmit to the specific client application, in the specific session, at least a result of the handling.

### Claim 28

An apparatus comprising one or more computer memories coupled to one or more processors in one or more computers, the one or more processors being configured to execute instructions in the one or more computer memories to manage a database management system in the one or more computers, the instructions causing the one or more computers to:
receive one or more requests to perform database operations in a specific session that originates from a specific client application outside the one or more computers;
handle the one or more requests at least partially, in one or more instances of a database server of a first kind in the database management system or in one or more instances of a database server of a second kind in the database management system;
automatically relocate handling, from a first instance among the one or more instances of the database server of the first kind to a second instance among the one or more instances of the database server of the second kind, when the handling is in the first instance; and
automatically relocate the handling of the one or more requests or handling of any new requests in the one or more sessions or both the handlings from the second instance to any instance among the one or more instances of the first kind; and
transmit to the one or more client applications, in the one or more sessions, at least a result of the handling of the one or more requests;
automatically relocating the handling, from a first instance among the one or more instances of the database server of the first kind to a second instance among the one or more instances of the database server of the second kind, when the handling is in the first instance; and
automatically relocating the handling, from the second instance to any instance among the one or more instances of the database server of the first kind, when the handling is in the second instance; and
transmitting to the specific client application, in the specific session, at least a result of the handling.
