Method for improving performance of large databases
    1.
    发明授权
    Method for improving performance of large databases 失效
    提高大型数据库性能的方法

    公开(公告)号:US6035306A

    公开(公告)日:2000-03-07

    申请号:US977268

    申请日:1997-11-24

    摘要: The present invention provides a tool with which a DBA can analyze a VLDB at all levels of data storage, both logical and physical, to analyze performance problems. The invention is particularly applicable to systems in which database files are striped over multiple disk drives. In the present invention, storage of information is monitored at three levels: database files, file system files, and individual disk drives Parameters indicating the activity and performance level of each of the levels of storage are taken at selected intervals and stored. An analysis tool is provided that allows a DBA to select a time window during which the database performance is be assessed. The analysis tool has a map of the logical and physical arrangement of the database being monitored and allows a DBA to move from level to level of both logical and physical structures involved in storing the data while displaying I/O activity in an easily understood manner.

    摘要翻译: 本发明提供了一种工具,通过该工具,DBA可以在逻辑和物理的数据存储的所有级别上分析VLDB,以分析性能问题。 本发明特别适用于数据库文件在多个磁盘驱动器上分条的系统。 在本发明中,信息的存储在三个级别被监视:数据库文件,文件系统文件和单独的磁盘驱动器,以选定的间隔进行指示每个存储级别的活动和性能级别的参数并被存储。 提供了一个分析工具,允许DBA选择一个时间窗口,在此期间对数据库性能进行评估。 分析工具具有所监视的数据库的逻辑和物理排列的映射,并允许DBA以易于理解的方式显示I / O活动而在存储数据时涉及的逻辑和物理结构的级别移动到级别。

    Method and apparatus for provisioning storage resources
    2.
    发明授权
    Method and apparatus for provisioning storage resources 有权
    提供存储资源的方法和装置

    公开(公告)号:US07945669B2

    公开(公告)日:2011-05-17

    申请号:US10283908

    申请日:2002-10-30

    IPC分类号: G06F15/173 G06F15/16

    CPC分类号: H04L67/1097 H04L69/329

    摘要: A method and apparatus for automatically provisioning at least a portion of a computer system to meet a specification provided in a provisioning request. In one embodiment, the provisioning includes provisioning at least one resource from each of at least one host computer, at least one storage system, and at least one connectivity resource that connects the at least one host computer to the at least one storage system. In another embodiment, the provisioning includes selecting and configuring at least one logical volume of storage and configuring the computer system to provide access to the selected volume. In another aspect, a computer-readable provisioning transaction is created to provision the computer system, and a computer-readable undo transaction is created to undo it. In a further embodiment, an existing computer system is reverse engineered to create a specification that is modified to create the specification in the provisioning request.

    摘要翻译: 一种用于自动配置计算机系统的至少一部分以满足在供应请求中提供的规范的方法和装置。 在一个实施例中,所述供应包括从至少一个主计算机,至少一个存储系统以及至少一个将所述至少一个主计算机连接到所述至少一个存储系统的至少一个连接资源提供至少一个资源。 在另一个实施例中,配置包括选择和配置至少一个逻辑卷的存储并配置计算机系统以提供对所选择的卷的访问。 在另一方面,创建计算机可读供应事务以配置计算机系统,并且创建计算机可读的撤销事务以将其撤销。 在另一个实施例中,现有的计算机系统被逆向工程以创建被修改以在供应请求中创建规范的规范。

    Methods and apparatus for naming resources
    3.
    发明授权
    Methods and apparatus for naming resources 有权
    命名资源的方法和设备

    公开(公告)号:US07454437B1

    公开(公告)日:2008-11-18

    申请号:US10947063

    申请日:2004-09-22

    IPC分类号: G06F7/00 G06F17/00 G06F15/173

    摘要: A software process receives a command initiating creation of a zone naming policy for automatically generating zone names in a storage area network. During creation of a zone naming policy, the software process receives selection of one or more format elements to be used in the zone naming policy. The one or more format elements each identify which corresponding at least one type of characteristic associated with a given zone in the storage area network shall be used to automatically generate a respective zone name for the given zone. For example, the format elements in a zone policy may identify how to generate a respective zone name using identifiers associated with resources associated with the zone. Accordingly, a network manager can create a zone naming policy for automatically generating zone names in a storage area network rather than having to manually create zone names for each created zone.

    摘要翻译: 软件进程接收到启动创建区域命名策略的命令,以在存储区域网络中自动生成区域名称。 在创建区域命名策略期间,软件进程接收在区域命名策略中使用的一个或多个格式元素的选择。 一个或多个格式元素各自识别与存储区域网络中的给定区域相关联的相应的至少一种类型的特征将被用于自动生成给定区域的相应区域名称。 例如,区域策略中的格式元素可以标识如何使用与该区域相关联的资源相关联的标识符来生成相应的区域名称。 因此,网络管理器可以创建区域命名策略,以在存储区域网络中自动生成区域名称,而不必为每个创建的区域手动创建区域名称。

    Methods and apparatus for naming resources
    4.
    发明授权
    Methods and apparatus for naming resources 有权
    命名资源的方法和设备

    公开(公告)号:US07818428B1

    公开(公告)日:2010-10-19

    申请号:US12257174

    申请日:2008-10-23

    摘要: A software process receives a command initiating creation of a zone naming policy for automatically generating zone names in a storage area network. During creation of a zone naming policy, the software process receives selection of one or more format elements to be used in the zone naming policy. The one or more format elements each identify which corresponding at least one type of characteristic associated with a given zone in the storage area network shall be used to automatically generate a respective zone name for the given zone. For example, the format elements in a zone policy may identify how to generate a respective zone name using identifiers associated with resources associated with the zone. Accordingly, a network manager can create a zone naming policy for automatically generating zone names in a storage area network rather than having to manually create zone names for each created zone.

    摘要翻译: 软件进程接收到启动创建区域命名策略的命令,以在存储区域网络中自动生成区域名称。 在创建区域命名策略期间,软件进程接收在区域命名策略中使用的一个或多个格式元素的选择。 一个或多个格式元素各自识别与存储区域网络中的给定区域相关联的相应的至少一种类型的特征将被用于自动生成给定区域的相应区域名称。 例如,区域策略中的格式元素可以标识如何使用与该区域相关联的资源相关联的标识符来生成相应的区域名称。 因此,网络管理器可以创建区域命名策略,以在存储区域网络中自动生成区域名称,而不必为每个创建的区域手动创建区域名称。