Abstract: A computing device can automatically generate a flow diagram showing statuses that objects in a system can possess, and the possible transitions between these statuses. Using snapshots of database data, the device can determine how the statuses of these objects have changed over time. The device can analyze the data to suggest which database fields likely represent object status. The device can render the flow diagram to illustrate system states at different selected times. Each rendered flow diagram can indicate, for the selected time point, the quantity of objects that possessed each status at that time, and, for a selected time interval, the quantity of objects that changed from each status to each other status during that time interval. The statuses can be represented in the flow diagram as status bubbles having sizes that are based on the quantities of objects having those bubble's statuses at the selected time point.

Abstract: A computing device can automatically generate a flow diagram showing statuses that objects in a system can possess, and the possible transitions between these statuses. Using snapshots of database data, the device can determine how the statuses of these objects have changed over time. The device can analyze the data to suggest which database fields likely represent object status. The device can render the flow diagram to illustrate system states at different selected times. Each rendered flow diagram can indicate, for the selected time point, the quantity of objects that possessed each status at that time, and, for a selected time interval, the quantity of objects that changed from each status to each other status during that time interval. The statuses can be represented in the flow diagram as status bubbles having sizes that are based on the quantities of objects having those bubble's statuses at the selected time point.

Abstract: A computing device can automatically generate a flow diagram showing statuses that objects in a system can possess, and the possible transitions between these statuses. Using snapshots of database data, the device can determine how the statuses of these objects have changed over time. The device can analyze the data to suggest which database fields likely represent object status. The device can render the flow diagram to illustrate system states at different selected times. Each rendered flow diagram can indicate, for the selected time point, the quantity of objects that possessed each status at that time, and, for a selected time interval, the quantity of objects that changed from each status to each other status during that time interval. The statuses can be represented in the flow diagram as status bubbles having sizes that are based on the quantities of objects have those bubble's statuses at the selected time point.

Abstract: A computing device can automatically generate a flow diagram showing statuses that objects in a system can possess, and the possible transitions between these statuses. Using snapshots of database data, the device can determine how the statuses of these objects have changed over time. The device can analyze the data to suggest which database fields likely represent object status. The device can render the flow diagram to illustrate system states at different selected times. Each rendered flow diagram can indicate, for the selected time point, the quantity of objects that possessed each status at that time, and, for a selected time interval, the quantity of objects that changed from each status to each other status during that time interval. The statuses can be represented in the flow diagram as status bubbles having sizes that are based on the quantities of objects have those bubble's statuses at the selected time point.

Abstract: Facilitating identification of star schemas in database environments. In an embodiment, queries directed to relational database tables (organized according to normalized schema) are examined to determine the relationships specified in the queries. A star schema is then generated by including the specified relationships. A data warehouse may be organized according to the generated star schema and the data previously stored in the database tables may be copied to the data warehouse.

Abstract: A computing device can automatically generate a flow diagram showing statuses that objects in a system can possess, and the possible transitions between these statuses. Using snapshots of database data, the device can determine how the statuses of these objects have changed over time. The device can analyze the data to suggest which database fields likely represent object status. The device can render the flow diagram to illustrate system states at different selected times. Each rendered flow diagram can indicate, for the selected time point, the quantity of objects that possessed each status at that time, and, for a selected time interval, the quantity of objects that changed from each status to each other status during that time interval. The statuses can be represented in the flow diagram as status bubbles having sizes that are based on the quantities of objects have those bubble's statuses at the selected time point.

Abstract: A computing device can automatically generate a flow diagram showing statuses that objects in a system can possess, and the possible transitions between these statuses. Using snapshots of database data, the device can determine how the statuses of these objects have changed over time. The device can analyze the data to suggest which database fields likely represent object status. The device can render the flow diagram to illustrate system states at different selected times. Each rendered flow diagram can indicate, for the selected time point, the quantity of objects that possessed each status at that time, and, for a selected time interval, the quantity of objects that changed from each status to each other status during that time interval. The statuses can be represented in the flow diagram as status bubbles having sizes that are based on the quantities of objects have those bubble's statuses at the selected time point.

Abstract: A computing device can automatically generate a flow diagram showing statuses that objects in a system can possess, and the possible transitions between these statuses. Using snapshots of database data, the device can determine how the statuses of these objects have changed over time. The device can analyze the data to suggest which database fields likely represent object status. The device can render the flow diagram to illustrate system states at different selected times. Each rendered flow diagram can indicate, for the selected time point, the quantity of objects that possessed each status at that time, and, for a selected time interval, the quantity of objects that changed from each status to each other status during that time interval. The statuses can be represented in the flow diagram as status bubbles having sizes that are based on the quantities of objects have those bubble's statuses at the selected time point.

Abstract: A computing device can automatically generate a flow diagram showing statuses that objects in a system can possess, and the possible transitions between these statuses. Using snapshots of database data, the device can determine how the statuses of these objects have changed over time. The device can analyze the data to suggest which database fields likely represent object status. The device can render the flow diagram to illustrate system states at different selected times. Each rendered flow diagram can indicate, for the selected time point, the quantity of objects that possessed each status at that time, and, for a selected time interval, the quantity of objects that changed from each status to each other status during that time interval. The statuses can be represented in the flow diagram as status bubbles having sizes that are based on the quantities of objects have those bubble's statuses at the selected time point.

Abstract: Systems and methods defining a service oriented object framework for use in providing an open application environment facilitating application function integration are shown. Embodiments provide object life management, platform resources management, and event management capabilities. A multi-layer architecture, defining object layers within an application container, may be used. A primary layer of such an architecture may comprise infrastructure objects providing foundational element blocks embodying protocol specific functions of the services that are to be built on top of a development container. An intermediate layer of such an architecture may comprise service objects providing service level functions. An upper layer of such an architecture may comprise business objects providing application orchestration element blocks defining the logical application created by combining the foregoing objects.

Abstract: A query generator for generating a query for retrieving data from a database comprising at least one table is disclosed. The query refers to one or more data items in a first view defined to expose a portion of the database and to one or more data items that are not exposed by the first view, at least one of which has an associated reach through flag set thereby defining it as a reach through item. The query generator is adapted to: receive user input indicating selected items to be retrieved from the database; ascertain whether any of the selected items that are not exposed by the first view are defined as reach through items; and, if so: create a second view that is a copy of the first view and add a copy of each reach through item to it; and create a query that refers only to the second view and the items exposed by it.

Abstract: Facilitating identification of star schemas in database environments. In an embodiment, queries are examined to determine the joins required. The two tables of each join are added as a relationship in the star schema.

Abstract: A method of rewriting a Structured Query Language (SQL) statement in order to prevent processing of a join between a master table and a detail table in a database is disclosed. The method includes determining in the SQL statement a unique identifier to a row of the master table. The unique identifier is then equated to an identifier to related rows of the detail table using the join condition. A revised SQL statement may then be produced that only refers to the detail table using the identifier to the rows of the detail table. Subsequently, the revised SQL statement is processed.

Abstract: Systems and methods defining a service oriented object framework for use in providing an open application environment facilitating application function integration are shown. Embodiments provide object life management, platform resources management, and event management capabilities. A multi-layer architecture, defining object layers within an application container, may be used. A primary layer of such an architecture may comprise infrastructure objects providing foundational element blocks embodying protocol specific functions of the services that are to be built on top of a development container. An intermediate layer of such an architecture may comprise service objects providing service level functions. An upper layer of such an architecture may comprise business objects providing application orchestration element blocks defining the logical application created by combining the foregoing objects.

Abstract: A query generator for generating a query for retrieving data from a database comprising at least one table is disclosed. The query refers to one or more data items in a first view defined to expose a portion of the database and to one or more data items that are not exposed by the first view, at least one of which has an associated reach through flag set thereby defining it as a reach through item. The query generator is adapted to: a) receive user input indicating selected items to be retrieved from the database; b) ascertain whether any of the selected items that are not exposed by the first view are defined as reach through items; and, c) if so: i) create a second view that is a copy of the first view and add a copy of each reach through item to it; and ii) create a query that refers only to the second view and the items exposed by it.

Abstract: Disclosed are systems and methods which provide high availability with respect to equipment deployed in a distributed system architecture. The distributed system architecture may comprise one or more equipment clusters of a plurality of processor-based systems cooperating to host one or more application servers. Redundancy is provided with respect to equipment of the equipment clusters to provide high availability with respect to equipment used in providing services of the application servers as well as to provide continuity of applications provided by the application servers. Various equipment elements of an equipment cluster may be provided different levels and/or types of redundancy. Other equipment elements of an equipment cluster may be provided different levels and/or types of redundancy.

Abstract: A method of preventing execution of unnecessary joins between tables in a database is described.

Abstract: A method of rewriting a Structured Query Language (SQL) statement in order to prevent processing of a join between a master table and a detail table in a database is described.

Abstract: A guard for repelling rats and other animals from entering a toilet bowl fixture installed on a wax sealing ring. The guard comprises a guard tube and a plurality of flexible, resilient wires having their base ends attached to circumferentially-spaced points of the tube and their free ends extending longitudinally and radially inward in a generally truncated, conelike formation. When the toilet is flushed, the wires spread radially outward to permit human waste and wads of toilet paper to easily pass. When an animal attempts to enter a toilet bowl fixture from an attached sewer line, however, pressure by the animal against the wires moves the wires radially inward to obstruct passage of the animal.