Data storage device supporting accelerated database operations

Abstract

Disclosed herein are data storage device embodiments for accelerating database operations and associated methods. In one embodiment, the data storage device includes a controller; an array of one or more solid-state memory storage devices; a first memory for storing processor executable instructions associated with database operations; and a second memory for storing data related to the database operations; wherein the controller is configured to execute the instructions to: cause data to be read from the solid-state memory storage devices into the second memory; determine whether the data match a query specified by the instructions; and perform a database operation based on the query match determination.

what is claimed is: 
     
         1 . A non-volatile data storage device, comprising:
 a controller; and   an array of one or more solid-state memory storage devices, wherein the array of one or more solid-state memory storage devices is configured to:
 store a plurality of logical pages in one or more solid-state memory storage devices, each of the plurality of logical pages configured to correspond with an individual data field of a database record; and 
 store a plurality of database records comprising a plurality of data fields, wherein data stored in each of the plurality of data fields are indexable based on a plurality of logical addresses corresponding to the plurality of logical pages. 
   
     
     
         2 . The non-volatile data storage device of  claim 1 , wherein the controller is further configured to perform a query-related database operation by selectively skipping reading of the logical pages. 
     
     
         3 . The non-volatile data storage device of  claim 2 , wherein the selectively skipping is based on logic associated with user data access privilege. 
     
     
         4 . The non-volatile data storage device of  claim 2 , wherein the selectively skipping is performed by a modulo operation on a logical address associated with one or more of the logical pages. 
     
     
         5 . The method of  claim 2 , wherein the selectively skipping is based on logic associated with a query. 
     
     
         6 . The non-volatile data storage device of  claim 1 , comprising:
 a first memory for storing processor executable instructions associated with a database operation;   a second memory for storing data related to the database operations;   wherein the controller is configured to execute the instructions, the instructions causing the controller to:   cause data to be read from the solid-state memory storage devices into the second memory;   determine whether the data match a query specified by the instructions; and   perform a database operation based on the query match determination.   
     
     
         7 . The non-volatile data storage device of  claim 6 , wherein the controller comprises a processor dedicated to execute the instructions. 
     
     
         8 . The non-volatile data storage device of  claim 6 , wherein the instructions are received from a host system coupled to the data storage device. 
     
     
         9 . A method of performing data operation in a non-volatile data storage device comprising an array of one or more solid-state memory storage devices, the method comprising:
 storing a plurality of logical pages in one or more solid-state memory storage devices, each of the plurality of logical pages configured to correspond with an individual data field of a database record; and   storing a plurality of database records comprising a plurality of data fields, wherein data stored in each of the plurality of data fields are indexable based on a plurality of logical addresses corresponding to the plurality of logical pages.   
     
     
         10 . The method of  claim 9 , further comprising: performing a query-related database operation by selectively skipping reading of the logical pages. 
     
     
         11 . The method of  claim 10 , wherein the selectively skipping is based on logic associated with user data access privilege. 
     
     
         12 . The method of  claim 10 , wherein the selectively skipping is based on logic associated with a query. 
     
     
         13 . The method of  claim 10 , wherein the selectively skipping is performed by a modulo operation on a logical address associated with one or more of the logical pages. 
     
     
         14 . The method of  claim 9 , wherein, the non-volatile data storage device further a first memory, and a second memory, the method comprising:
 reading data from the solid-state memory storage devices of the non-volatile data storage device into the second memory;   determining whether the data match a query specified; and   performing a database operation based on the query match determination, wherein:   the first memory is configured to store processor executable instructions associated with database operations and the query is specified by the instructions; and   the second memory is configured to store data related to the database operations.   
     
     
         15 . The method of  claim 14 , wherein the instructions are executed in a dedicated processor. 
     
     
         16 . The method of  claim 14 , wherein the instructions are received from a host system coupled to the data storage device.