Abstract: Storing and/or accessing data in a transactional database, with use of the following technique: (i) selecting a set of base tables in a transactional database; and (ii) creating a factless materialized query table, having maximum sparsity, for the set of base tables. The set of base tables includes at least two base tables. The set of base tables includes a set of keys including at least two distinct primary keys. The factless materialized query table includes one record associated with each record in the set of base tables. Each record in the materialized query table includes a value for every primary key in the set of base tables.

Abstract: A storage system graphical user interface (GUI) renders indication of a plurality of selected storage systems. Selection is received of selected storage systems from the rendered indication of selected storage systems and a determination is made of performance metrics common to the selected storage systems. A performance metric GUI enabling selection of the determined performance metrics common to the selected storage systems is generated. In response to user selection of at least one selected performance metric of the determined performance metrics in the performance metric GUI, determination is made of performance metric values for the at least one of the selected performance metrics for the selected storage systems. A computer renderable visualization providing a visual comparison for each of the at least one selected performance metric of the determined performance metric values is generated for the selected storage systems.

Abstract: Storing and/or accessing data in a transactional database, with use of the following technique: (i) selecting a set of base tables in a transactional database; and (ii) creating a factless materialized query table, having maximum sparsity, for the set of base tables. The set of base tables includes at least two base tables. The set of base tables includes a set of keys including at least two distinct primary keys. The factless materialized query table includes one record associated with each record in the set of base tables. Each record in the materialized query table includes a value for every primary key in the set of base tables.

Abstract: Storing and/or accessing data in a transactional database, with use of the following technique: (i) selecting a set of base tables in a transactional database; and (ii) creating a factless materialized query table, having maximum sparsity, for the set of base tables. The set of base tables includes at least two base tables. The set of base tables includes a set of keys including at least two distinct primary keys. The factless materialized query table includes one record associated with each record in the set of base tables. Each record in the materialized query table includes a value for every primary key in the set of base tables.

Abstract: Storing and/or accessing data in a transactional database, with use of the following technique: (i) selecting a set of base tables in a transactional database; and (ii) creating a factless materialized query table, having maximum sparsity, for the set of base tables. The set of base tables includes at least two base tables. The set of base tables includes a set of keys including at least two distinct primary keys. The factless materialized query table includes one record associated with each record in the set of base tables. Each record in the materialized query table includes a value for every primary key in the set of base tables.

Abstract: Storing and/or accessing data in a transactional database, with use of the following technique: (i) selecting a set of base tables in a transactional database; and (ii) creating a factless materialized query table, having maximum sparsity, for the set of base tables. The set of base tables includes at least two base tables. The set of base tables includes a set of keys including at least two distinct primary keys. The factless materialized query table includes one record associated with each record in the set of base tables. Each record in the materialized query table includes a value for every primary key in the set of base tables.

Abstract: Storing and/or accessing data in a transactional database, with use of the following technique: (i) selecting a set of base tables in a transactional database; and (ii) creating a factless materialized query table, having maximum sparsity, for the set of base tables. The set of base tables includes at least two base tables. The set of base tables includes a set of keys including at least two distinct primary keys. The factless materialized query table includes one record associated with each record in the set of base tables. Each record in the materialized query table includes a value for every primary key in the set of base tables.

Abstract: Embodiments of the present invention provide an approach for providing cluster-aware (storage) resource provisioning in a networked computing environment (e.g., a cloud computing environment) based upon policies, best practices, and/or storage cluster/environment configurations. In a typical embodiment, a set of characteristics (e.g., computing resources/components, etc.) of a storage environment will be determined. A set of requirements for a set of workloads to be processed by the components of the storage environment will then be identified. A set of policies and a set of best practices will then be determined to identify a configuration of the storage environment to optimize the processing of the set of workloads according to the set of requirements. Based on the configuration, a plan will be generated that indicates a data path through the set of computing resources that minimizes a potential for error in processing the set of workloads.

Abstract: A storage system graphical user interface (GUI) renders indication of a plurality of selected storage systems. Selection is received of selected storage systems from the rendered indication of selected storage systems and a determination is made of performance metrics common to the selected storage systems. A performance metric GUI enabling selection of the determined performance metrics common to the selected storage systems is generated. In response to user selection of at least one selected performance metric of the determined performance metrics in the performance metric GUI, determination is made of performance metric values for the at least one of the selected performance metrics for the selected storage systems. A computer renderable visualization providing a visual comparison for each of the at least one selected performance metric of the determined performance metric values is generated for the selected storage systems.

Abstract: Storing and/or accessing data in a transactional database, with use of the following technique: (i) selecting a set of base tables in a transactional database; and (ii) creating a factless materialized query table, having maximum sparsity, for the set of base tables. The set of base tables includes at least two base tables. The set of base tables includes a set of keys including at least two distinct primary keys. The factless materialized query table includes one record associated with each record in the set of base tables. Each record in the materialized query table includes a value for every primary key in the set of base tables.

Abstract: Storing and/or accessing data in a transactional database, with use of the following technique: (i) selecting a set of base tables in a transactional database; and (ii) creating a factless materialized query table, having maximum sparsity, for the set of base tables. The set of base tables includes at least two base tables. The set of base tables includes a set of keys including at least two distinct primary keys. The factless materialized query table includes one record associated with each record in the set of base tables. Each record in the materialized query table includes a value for every primary key in the set of base tables.

Abstract: A storage environment includes a storage system and a reporting device. The storage system may operate in a first configuration utilizing only internal storage and may operate in a second configuration utilizing only external storage. The reporting device determines the operating configuration of the storage system and generates a report comprising at least one field identifying the storage system and at least one field identifying the operating configuration of the storage system. The storage system may also include a managed disk group that may operate in a first configuration comprising only internal storage and may operate in a second configuration comprising only external storage. The reporting device may determine the operating configuration of the managed disk group and generates a report including at least one field identifying the managed disk group and at least one field identifying the operating configuration of the managed disk group.

Abstract: Embodiments of the present invention provide an approach for providing cluster-aware (storage) resource provisioning in a networked computing environment (e.g., a cloud computing environment) based upon policies, best practices, and/or storage cluster/environment configurations. In a typical embodiment, a set of characteristics (e.g., computing resources/components, etc.) of a storage environment will be determined. A set of requirements for a set of workloads to be processed by the components of the storage environment will then be identified. A set of policies and a set of best practices will then be determined to identify a configuration of the storage environment to optimize the processing of the set of workloads according to the set of requirements. Based on the configuration, a plan will be generated that indicates a data path through the set of computing resources that minimizes a potential for error in processing the set of workloads.

Abstract: Provided are a method, system, and program for creating at least one volume in a disk storage system. A request is received to create at least one volume on the disk storage system indicating a volume size and number of volumes to create. Selection is made of a storage pool object representing one of a plurality of storage pools having available storage space to create the requested number of volumes. retrieving a storage configuration service of the disk storage system using an association of a disk storage system object representing the disk storage system and the selected storage pool object. The disk storage system object representing the disk storage system is associated with the retrieved storage configuration service. A volume size of the volume to create is set to a calculated size. The storage pool is set as the selected storage pool object. A method is invoked through the retrieved storage configuration service for each volume in the requested number of volumes to create.

Abstract: Novel storage area networks (SANs) and methods of operation thereof utilize a plurality of hosts coupled via an interconnect with one or more storage units. A manager device, process or other functionality in communication with a plurality of agent processes, devices or other functionality, each of which is associated with a host. The agents identify attributes of (i) their associated hosts, (ii) interconnect to which that host is coupled, and/or (iii) storage units to which that host is coupled via the interconnect. The manager responds to these attributes identified by the agents to manage the SAN. The manager can be implemented on a first digital data processor and the hosts on further digital data processors. These digital data processors can be coupled via a first network, e.g., an IP or other network, to support communications between the manager and the agents. A second network, e.g.

Abstract: Provided are a method, system, and program for creating at least one volume in a disk storage system. A request is received to create at least one volume on the disk storage system indicating a volume size and number of volumes to create. Selection is made of a storage pool object representing one of a plurality of storage pools having available storage space to create the requested number of volumes. retrieving a storage configuration service of the disk storage system using an association of a disk storage system object representing the disk storage system and the selected storage pool object. The disk storage system object representing the disk storage system is associated with the retrieved storage configuration service. A volume size of the volume to create is set to a calculated size. The storage pool is set as the selected storage pool object. A method is invoked through the retrieved storage configuration service for each volume in the requested number of volumes to create.

Abstract: An example of a method for assigning a resource (for example, storage) includes receiving a request for a resource, wherein the request includes a list of paths. This example also includes retrieving a HardwareAccount, Controller, and an AccessAuthorization object for a first path in the list of paths. This example further includes making an attach device request to a CIMOM for a first available resource, using the Controller and the AccessAuthorization object. This example also includes determining if the first available resource was successfully attached, and if so, recording the assignment as successful, and if not, rolling back all assignments for the first available resource that were previously recorded as successful. Another aspect of the invention is a method for creating at least one LUN.

Abstract: One aspect of the invention is a method for responding to an inquiry. An example of the method includes receiving the inquiry, obtaining information from a CIMOM, and creating at least one Storage Object. This example of the method also includes populating the at least one Storage Object with information received from the CIMOM, and sending the at least one Storage Object to a calling function.

Abstract: An example of a method for assigning a resource (for example, storage) includes receiving a request for a resource, wherein the request includes a list of paths. This example also includes retrieving a HardwareAccount, Controller, and an AccessAuthorization object for a first path in the list of paths. This example further includes making an attach device request to a CIMOM for a first available resource, using the Controller and the AccessAuthorization object. This example also includes determining if the first available resource was successfully attached, and if so, recording the assignment as successful, and if not, rolling back all assignments for the first available resource that were previously recorded as successful. Another aspect of the invention is a method for creating at least one LUN.

Abstract: An example of a method for assigning a resource (for example, storage) includes receiving a request for a resource, wherein the request includes a list of paths. This example also includes retrieving a HardwareAccount, Controller, and an AccessAuthorization object for a first path in the list of paths. This example further includes making an attach device request to a CIMOM for a first available resource, using the Controller and the AccessAuthorization object. This example also includes determining if the first available resource was successfully attached, and if so, recording the assignment as successful, and if not, rolling back all assignments for the first available resource that were previously recorded as successful. Another aspect of the invention is a method for creating at least one LUN.