公开(公告)号：US10162597B1

公开(公告)日：2018-12-25

申请号：US13610214

申请日：2012-09-11

Applicant: Ron Bigman ,  Adi Hirschtein ,  Nir Sela

Inventor： Ron Bigman ,  Adi Hirschtein ,  Nir Sela

IPC: G06F7/00 ,  G06F17/30

Abstract: Certain database structures and operations are recognized in order to generate hints for a tiered storage array. Historical snapshots of a database data dictionary are searched for patterns corresponding to the structures and operations. After a structure or operation is identified, a corresponding set of extents is identified. Logic predicts future activity associated with the extents, and a corresponding hint is provided to the storage array. Statistical information associated with the identified structure or operation may be maintained and updated to facilitate prediction of activity.

公开(公告)号：US10037279B1

公开(公告)日：2018-07-31

申请号：US13527761

申请日：2012-06-20

Applicant: Ron Bigman ,  Nir Sela ,  Adi Hirschtein

Inventor： Ron Bigman ,  Nir Sela ,  Adi Hirschtein

IPC: G06F12/00 ,  G06F12/0846 ,  G06F12/0891 ,  G06F12/0888

CPC classification number: G06F12/0848 ,  G06F12/084 ,  G06F12/0877 ,  G06F12/0888 ,  G06F12/0891 ,  G06F2212/1016 ,  G06F2212/222 ,  G06F2212/261 ,  G06F2212/28 ,  G06F2212/311 ,  G06F2212/45 ,  G06F2212/60

Abstract: A data storage subsystem includes a data storage array and a host device in communication with the data storage array. Applications on servers and user terminals communicate with the host to access data maintained by the storage array. In order to enhance performance, the host includes a cache resource and a computer program including cache configuration logic which determines whether an IO received from an application is associated with a predetermined type of business process, and configures the cache resource to store data associated with the received IO where it is determined that the IO is associated with the predetermined type of business process, thereby enabling the data to be available directly from the host without accessing the storage subsystem in response to a subsequent Read request.

公开(公告)号：US10360192B1

公开(公告)日：2019-07-23

申请号：US13539176

申请日：2012-06-29

Applicant: Nir Sela ,  Adi Hirschtein ,  Ron Bigman ,  Shay Zukerman

Inventor： Nir Sela ,  Adi Hirschtein ,  Ron Bigman ,  Shay Zukerman

IPC: G06F16/00 ,  G06F16/21 ,  G06F9/455

Abstract: A SQL database tool maps database objects to storage addresses. The SQL database translates SQL requests to I/O requests on specific extents of OS files. A data structure maps the OS file extents to database objects. Using this mapping, I/O requests on files can be correlated to their relevant database objects, providing analysis of I/O activity and I/O wait time for database objects. Based on the computed database object activity level, the database objects may be allocated to different storage tiers according to their I/O needs.

公开(公告)号：US09760306B1

公开(公告)日：2017-09-12

申请号：US13596570

申请日：2012-08-28

Applicant: Ron Bigman ,  Adi Hirschtein ,  Nir Sela

Inventor： Ron Bigman ,  Adi Hirschtein ,  Nir Sela

IPC: G06F3/06 ,  G06F11/34 ,  G06F17/30

CPC classification number: G06F3/0649 ,  G06F3/0605 ,  G06F3/0653 ,  G06F3/0685 ,  G06F11/3433 ,  G06F17/30221

Abstract: Data access is monitored in order to calculate priorities for extents of data based on extent access activity and priority of a business process associated with the extent. The priorities of the extents are used to generate priority hints for a tiered storage array. The priority may be time-dependent, including being indicative of anticipated future activity.

公开(公告)号：US09665630B1

公开(公告)日：2017-05-30

申请号：US13525816

申请日：2012-06-18

Applicant: Ron Bigman ,  Adi Hirschtein

Inventor： Ron Bigman ,  Adi Hirschtein

IPC: G06F17/30

CPC classification number: G06F17/3053 ,  G06F3/0647 ,  G06F17/30221

Abstract: Described are techniques for providing hints. Activity data for data portions is received. For each data portion, activity data is aggregated for each of a plurality of time periods and a value for a metric is determined for the data portion in accordance with the aggregated activity data. The values for the metric are ranked. A set of one or more data portions are identified based on the ranked metric values. Hint generation processing is performed to generate a hint for each data portion in said set. The hint may be used in connection with performing data storage movement optimizations to move selected data portions between different storage tiers having different performance classifications. The metric may be determined using one or more criteria including standard deviation, entropy and/or a maximum probability for a time period having the largest portion of I/O wait time for a data portion.