Micron Electronics, Inc.

International Business Machines Corporation

Micron Technology Incorporated

Ahmad Nouri

Karl S Johnson

David Joseph Wisneski

Provided is an object oriented query path expression to relational outer join translator. A path expression, comprising a navigation path through a relationship in a schema, in an object oriented query is translated to a relational database outer join by analyzing each path expression defined in each level of the object oriented query, and by identifying each path expression which can be a candidate for a translation to an outer join. A quantifier is created for each path expression. A translation of the object oriented query to a relational query is then completed. An optimization may also be performed on the grouped quantifiers. After the optimization, an inner join is generated for each quantifier which remains a candidate for a translation to an inner join, and an outer join is generated for each quantifier which remains a candidate for a translation to an outer join.

Object oriented query path expression to relational outer join translator method, system, and article of manufacture, and computer program product

A path expression is translated to a relational database outer join by analyzing each path expression defined in each level of the object oriented query, and by identifying each path expression which can be a candidate for a translation to an outer join. The path expressions are ordered staffing with path expressions defined in a FROM clause. These ordered path expressions are grouped sequentially based upon on a source-target dependency between ordered path expressions and based upon the identifications as a candidate for a translation to an outer join. A quantifier is created for each path expression, said quantifier comprising a variable representing a table in a relational database, and each grouped path expression is replaced with a corresponding quantifier and related table in a relational database. A translation of the object oriented query to a relational query is then completed.

Object oriented query path expression to relational outer join translator method, system, article of manufacture, and computer program product

An object oriented query such as an enterprise java bean query is translated into a corresponding relational query by identifying an inter-hierarchal relationship relating two or more object oriented hierarchies; identifying a source object oriented hierarchy of the inter-hierarchal relationship; mapping the source object oriented hierarchy into corresponding source relational tables; building a source series of joins between the source relational tables, the source series being ordered in a top-down order from a root of the source object oriented hierarchy; identifying a target class of the inter-hierarchal relationship; mapping the target object oriented hierarchy into corresponding target relational tables; building a target series of joins between the target relational tables, the target series comprising a first target series and a second target series, the first target series corresponding to the target class, a root of the target object oriented hierarchy, and intervening nodes between the target class and the root of the target object oriented hierarchy, and the second target series corresponding to nodes in leaves of the target object oriented hierarchy located below the target class; and combining the source series of joins and the target series of joins into the corresponding relational query. For a query selection based upon a plurality of relationships between the object oriented hierarchies, the steps may be repeated for each of the plurality of relationships. The combined series of joins may be further reordered by recursively finding a join relationship between a current node and a preceding node in the combined series of joins. To improve performance, a join above a target of a relationship is built as an inner join, and a join below the target of relationship is built as an outer join.

Object oriented query root leaf inheritance to relational join translator method, system, article of manufacture, and computer program product

A fault tolerant computer system for obtaining and displaying, or updating the status of server components through a remote interface and either a local or remote client machine without intervention of the server operating system software. The remote machine accesses the server by use of a dial-in modem connection, while the local machine accesses the server by a local serial connection. The components that can be monitored include, but are not limited to, the following: Power Supplies, Temperatures, Fans, Processors, I/O Groups, I/O Canisters, Serial Numbers, and Revisions.

Method of updating a system environmental setting

A fault tolerant method of resetting a server through either a local or remote client machine. The remote machine accesses the server by use of a dial-in modem connection, while the local machine accesses the server by a local serial connection. The resetting operation brings the server and the operating system software to a normal operational state. Reset is used after diagnostics or recovery have been performed without the use of the server operating system software or to restart the server after an unexpected crash.

Method of resetting a server

A fault tolerant method of powering up and powering down a server through either a local or remote client machine. The remote machine accesses the server by use of a dial-in modem connection, while the local machine accesses the server by a local serial connection. The power up operation brings the server to a maintenance state such that diagnostics or recovery can be performed even though the server operating system software is not operational. Power down is used when certain types of diagnostic, maintenance, or administrative tasks need to be done.

Method of powering up or powering down a server to a maintenance state

System for displaying system status

A fault tolerant computer system for downloading the contents of a server system log through either a local or remote client machine without intervention of the server operating system software. The remote machine accesses the server by use of a dial-in modem connection, while the local machine accesses the server by a local serial connection. The system log may be stored in a non-volatile RAM which is powered by a remote interface if the server power is off. The downloaded information is displayed in a graphical user interface window to enable diagnosis and recovery of the server.

System for reading system log

A fault tolerant computer system for powering up and powering down a server through either a local or remote client machine. The remote machine accesses the server by use of a dial-in modem connection. The power up operation brings the server to an operational state such that diagnostics or recovery can be performed even though the operating system software on the server is not operational. Power down is used when diagnosis and maintenance, such as changing a part, needs to be done. Other reasons for power down are for security or power conservation.

System for powering up and powering down a server

A fault tolerant method of obtaining and displaying, or updating the status of server components through a Remote Interface Board and either a local or remote client machine without intervention of the server operating system software. The remote machine accesses the server by use of a dial-in modem connection, while the local machine accesses the server by a local serial connection. The components that can be monitored include, but are not limited to, the following: Power Supplies, Temperatures, Fans, Processors, I/O Groups, I/O Canisters, Serial Numbers, and Revisions.

Method of displaying system status

A fault tolerant method of downloading the contents of a server system log through either a local or remote client machine without intervention of the server operating system software. The remote machine accesses the server by use of a dial-in modem connection while the local machine accesses the server by a local serial connection. The system log may be stored in a non-volatile RAM which is powered by a remote interface if the server power is off. The downloaded information is displayed in a graphical user interface window to enable diagnosis and recovery of the server.

Method of reading system log

A fault tolerant computer system for resetting a server through either a local or remote client machine. The remote machine accesses the server by use of a dial-in modem connection, while the local machine accesses the server by a local serial connection. The resetting operation brings the server and operating system software to a normal operational state. Reset is used after diagnostics or recovery have been performed without the use of the server operating system software or to restart the server after an unexpected crash.

Growing community of inventors

San Jose, CA, United States of America

Ahmad Nouri