Providing storage technology information to improve database performance

Patent metadata

Field	Value
Publication number	US-10152498-B2
Application number	US-201614995532-A
Country	US
Kind code	B2
Filing date	Jan 14, 2016
Priority date	Dec 11, 2015
Publication date	Dec 11, 2018
Grant date	Dec 11, 2018

Abstract

In one aspect, a method includes receiving a read or write command from a requester to read data from or write data to a database, inserting in a status message on a status of the read or write command an identifier to identify technology of storage for the data and providing the status message associated with the read or write command to the requester.

First claim

What is claimed is:

1. A method for storing data on a device comprising:
receiving a read or write command from a requester to read data from or write data to, respectively, a database;
inserting in a status message associated with the read or write command an identifier identifying a type of storage technology used for storing the data, the status message indicating whether the read or write command was successful, the identifier identifying a type of connection interface that is used by a storage device on which the data is stored;
providing the status message associated with the read or write command to the requester;
extracting storage technology information from the status message where the data is located;
providing the storage technology information to a database analyzer;
receiving a data storage recommendation from the database analyzer in response to providing the storage technology information; and
storing data from the database on a type of storage technology based upon the storage recommendation.

2. The method of claim 1 , wherein providing the data storage recommendation using the database analyzer comprises sending the recommendation to a storage tiering module on the storage array.

3. The method of claim 1 , wherein the identifier indicates whether the storage device used for storing the data includes at least one of a flash disk, an ATA disk, a SATA disk or a cloud storage.

4. The method of claim 1 , wherein receiving the read or write command from the requester comprises receiving a read or write command from a requester to read data from or write data to a storage array.

5. An apparatus for storing data on a device, comprising:
electronic hardware circuitry configured to:
receive a read or write command from a requester to read data from or write data to a database;
insert in a status message on a status of the read or write command an identifier to identifying a type of storage technology used for storing the data, the status message indicating whether the read or write command was successful, the identifier identifying a type of connection interface that is used by a storage device on which the data is stored;
provide the status message associated with the read or write command to the requester;
extract storage technology information from the status message;
provide the storage technology information to a database analyzer;
receive a data storage recommendation from the database analyzer in response to providing the storage technology information; and
store data from the database on a type of storage technology based upon the storage recommendation.

6. The apparatus of claim 5 , wherein the circuitry comprises at least one of a processor, a memory, a programmable logic device or a logic gate.

7. The apparatus of claim 5 , further comprising circuitry configured to:
send the read or write command to the database stored in a storage array;
receive the status message; and
extract storage technology information from the status message where the data is located.

8. The apparatus of claim 7 , further comprising circuitry configured to:
provide the storage technology information to a database analyzer; and
provide a data storage recommendation using the database analyzer based on the storage technology information.

9. The apparatus of claim 8 , wherein the circuitry configured to provide the data storage recommendation using the database analyzer comprises circuitry configured to send the recommendation to a storage tiering module on the storage array.

10. The apparatus of claim 5 , wherein the identifier indicates whether the storage device used for storing the data includes at least one of a flash disk, an ATA disk, a SATA disk or a cloud storage.

11. The apparatus of claim 5 , wherein circuitry configured to receive the read or write command from the requester comprises circuitry configured to receive a read or write command from a requester to read data from or write data to a storage array.

12. An article for storing data on a device comprising:
a non-transitory computer-readable medium that stores computer-executable instructions, the instructions causing a machine to:
receive a read or write command from a requester to read data from or write data to a database;
insert in a status message on a status of the read or write command an identifier identifying a type of a storage technology used for storing the data, the status message indicating whether the read or write command was successful, the identifier identifying a type of connection interface that is used by a storage device on which the data is stored; and
provide the status message associated with the read or write command to the requester;
extract storage technology information from the status message;
provide the storage technology information to a database analyzer;
receive a data storage recommendation from the database analyzer in response to providing the storage technology information; and
store data from the database on a type of storage technology based upon the storage recommendation.

13. The article of claim 12 , wherein the instructions causing the machine to provide the data storage recommendation using the database analyzer comprises instructions causing the machine to send the recommendation to a storage tiering module on the storage array.

14. The article of claim 12 , wherein the identifier indicates whether the storage device used for storing the data includes at least one of a flash disk, an ATA disk, a SATA disk a cloud storage.

15. The article of claim 12 , wherein instructions causing the machine to receive the read or write command from the requester comprises instructions causing the machine to receive a read or write command from a requester to read data from or write data to a storage array.

Assignees

• Emc Corp

Inventors

• Don Arieh
• Rao Vinay
• Benhanokh Gabi
• Dar Yaron
• Sela Nir

Classifications

• G06F3/0683

  Plurality of storage devices · CPC title

• G06F3/0604

  Improving or facilitating administration, e.g. storage management · CPC title

• G06F16/217 Primary

  Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409) · CPC title

• G06F16/185

  Hierarchical storage management [HSM] systems, e.g. file migration or policies thereof (details of archiving G06F16/11) · CPC title

• G06F11/3409

  for performance assessment · CPC title