Abstract: A determination is made that an execution plan for a received structure query language (SQL) database query to execute on a database is not present in a database plan cache. An external offline optimization process is triggered to generate an externally optimized execution plan for the SQL database query. The generation of the externally optimized execution plan includes: receiving all or part of the received SQL database query as SQL statements and metadata associated with the database, looping over and analyzing all the received SQL statements, selecting at least one an optimization strategy for the SQL statements; and executing the selected at least one optimization strategy to generate the externally optimized execution plan. The externally optimized execution plan is then pinned into the database plan cache.

Abstract: A determination is made that an execution plan for a received structure query language (SQL) database query to execute on a database is not present in a database plan cache. An external offline optimization process is triggered to generate an externally optimized execution plan for the SQL database query. The generation of the externally optimized execution plan includes: receiving all or part of the received SQL database query as SQL statements and metadata associated with the database, looping over and analyzing all the received SQL statements, selecting at least one an optimization strategy for the SQL statements; and executing the selected at least one optimization strategy to generate the externally optimized execution plan. The externally optimized execution plan is then pinned into the database plan cache.

Abstract: The present disclosure describes methods, systems, and computer program products providing multi-dimensional visualization of a query executing in a distributed database according to an implementation. Log data for an executing query is received from each database server forming a distributed database system. The received log data is processed to generate a multi-dimensional visualization of the database query execution, the multi-dimensional visualization transmitted to display on a client device and including representing: 1) each database server as a point on a circular structure, 2) a progression of time with respect to each point as a line projecting perpendicularly from the circular structure and connecting to another circular structure with time the same at a particular corresponding point on each line, 3) data traffic as inwardly-pointing data traffic lines connecting the lines, and 4) information about database query execution in an outwardly direction from the lines representing the database.

Abstract: Methods, systems, and computer product products are provided for automatically configuring hardware, such as a new computer within a computer network. To allow fast booting, a generic part of an operating system may be loaded onto the new computer. Hardware properties of the new computer may be identified using the generic part of the operating system. Further, a request may be made for the preparation of a hardware specific part of the operating system depending on the identified hardware properties of the new computer. Additionally, at least part of the hardware specific part of the operating system may be communicated between the computer network and the new computer.

Abstract: In a computer system comprising a first computer (A) and a second computer (B) consecutive inquiries (311, 312) from an external computer (E) are processed by the observation (410) of the processing time (T1) that the first computer (A) requires for processing a first inquiry (311) of the external computer (E), and rerouting (420) of a second inquiry (312) from the first computer (A) to the second computer (B) if the processing time (T1) exceeds a standard time (TNORM).

Abstract: Network interfaces within a computer, which are connected to at least one physical network, are provided with logical network configuration data. The network interfaces may receive logical network identification information from the physical network. Network configuration data are then mapped onto the network interfaces based on the received logical network identification information to enable the network interfaces to provide communication between the computer and the corresponding logical network. Thus, a network interface card may be automatically configured to a logical network.

Abstract: Methods, systems, and computer product products are provided for automatically configuring hardware, such as a new computer within a computer network. To allow fast booting, a generic part of an operating system may be loaded onto the new computer. Hardware properties of the new computer may be identified using the generic part of the operating system. Further, a request may be made for the preparation of a hardware specific part of the operating system depending on the identified hardware properties of the new computer. Additionally, at least part of the hardware specific part of the operating system may be communicated between the computer network and the new computer.