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.

Abstract: Described is an improved approach to implement parallel queries where session states are saved for parallelization resources. When work needs to be performed in the parallel query system for a given session, a search can be performed to identify a resource (from among the pool of available resources) that had previously been used by that session, and which had saved a session state object for that previous connection to the session. Instead of incurring the entirety of setup costs each time workload is assigned to a resource, the saved session state can be used to re-set the context for the resource to the configuration requirements for that session.

Abstract: The embodiments disclosed herein select and assign a floating IP address (FIP) to an application based on characteristics of the application. Floating IP addresses are assigned a classification, and one or more network adapters are mapped to a FIP according to the FIPs assigned classification. The endpoint of a connection for an application initiating a network connection with a target application may be assigned a floating IP address according to attributes of the application being consistent with the classification of a FIP. Applications may be grouped according to their respective classification, and the group of applications may share a corresponding FIP. FIPs may be dynamically configured for an application with mapped network adapters selected based on the attributes of the application. An application's characteristics may change during executions, and the network adapters mapped to the FIP assigned to the application's connection may be reassigned.

Abstract: A server receives a query and checks how columns in rows responsive to the query are to be sent to a client. Based on one result of checking, the server prepares and transmits a redacted version of one or more rows or portions thereof. The redacted version may be prepared by discarding from the retrieved rows or portions thereof, any columns that are to not be sent, by applying a specific redaction technique, while maintaining columns that are to be sent in a database storage format in which the retrieved rows are stored. Based on another result of checking, the server prepares and transmits a raw version of the retrieved rows or portions thereof, in the database storage format. Based on yet another result of checking, the server extracts columns selected by the query to memory and sends processed versions of the rows or portions thereof.

Abstract: The embodiments disclosed herein select and assign a floating IP address (FIP) to an application based on characteristics of the application. Floating IP addresses are assigned a classification, and one or more network adapters are mapped to a FIP according to the FIPs assigned classification. The endpoint of a connection for an application initiating a network connection with a target application may be assigned a floating IP address according to attributes of the application being consistent with the classification of a FIP. Applications may be grouped according to their respective classification, and the group of applications may share a corresponding FIP. FIPs may be dynamically configured for an application with mapped network adapters selected based on the atttributes of the application. An application's characteristics may change during executions, and the network adapters mapped to the FIP assigned to the application's connection may be reassigned.

Abstract: The embodiments disclosed herein select and assign a floating IP address (FIP) to an application based on characteristics of the application. Floating IP addresses are assigned a classification, and one or more network adapters are mapped to a FIP according to the FIPs assigned classification. The endpoint of a connection for an application initiating a network connection with a target application may be assigned a floating IP address according to attributes of the application being consistent with the classification of a FIP. Applications may be grouped according to their respective classification, and the group of applications may share a corresponding FIP. FIPs may be dynamically configured for an application with mapped network adapters selected based on the attributes of the application. An application's characteristics may change during executions, and the network adapters mapped to the FIP assigned to the application's connection may be reassigned.

Abstract: The embodiments disclosed herein select and assign a floating IP address (FIP) to an application based on characteristics of the application. Floating IP addresses are assigned a classification, and one or more network adapters are mapped to a FIP according to the FIPs assigned classification. The endpoint of a connection for an application initiating a network connection with a target application may be assigned a floating IP address according to attributes of the application being consistent with the classification of a FIP. Applications may be grouped according to their respective classification, and the group of applications may share a corresponding FIP. FIPs may be dynamically configured for an application with mapped network adapters selected based on the atttributes of the application. An application's characteristics may change during executions, and the network adapters mapped to the FIP assigned to the application's connection may be reassigned.

Abstract: Described is an improved approach to implement parallel queries where session states are saved for parallelization resources. When work needs to be performed in the parallel query system for a given session, a search can be performed to identify a resource (from among the pool of available resources) that had previously been used by that session, and which had saved a session state object for that previous connection to the session. Instead of incurring the entirety of setup costs each time workload is assigned to a resource, the saved session state can be used to re-set the context for the resource to the configuration requirements for that session.

Abstract: A server receives a query and checks how columns in rows responsive to the query are to be sent to a client. Based on one result of checking, the server prepares and transmits a redacted version of one or more rows or portions thereof. The redacted version may be prepared by discarding from the retrieved rows or portions thereof, any columns that are to not be sent, by applying a specific redaction technique, while maintaining columns that are to be sent in a database storage format in which the retrieved rows are stored. Based on another result of checking, the server prepares and transmits a raw version of the retrieved rows or portions thereof, in the database storage format. Based on yet another result of checking, the server extracts columns selected by the query to memory and sends processed versions of the rows or portions thereof.

Abstract: A system, method, computer program and system for suspending a result set and continuing from a suspended result set for a scrollable cursor is disclosed. The rows from a row source corresponding to the scrollable cursor result set are suspended into storage so that when a fetch is requested the data can be sent (continued) from the suspended storage and does not depend on the original scrollable cursor row source or session to be available.

Abstract: A system, method, computer program and system for suspending a result set and continuing from a suspended result set for a cursor is disclosed. The rows from a row source corresponding to the cursor result set are suspended into storage so that when a fetch is requested the data can be sent (continued) from the suspended storage and does not depend on the original cursor row source or session to be available.

Abstract: A system, method, computer program and system for suspending a result set and continuing from a suspended result set for transparent session migration is disclosed. The rows from a row source are suspended into storage, so that after session migration, the client fetches can transparently continue from the suspended result set.