US20170351737A1 - Methods and systems for autonomous memory searching - Google Patents

Methods and systems for autonomous memory searching Download PDF

Info

Publication number
US20170351737A1
US20170351737A1 US15/685,950 US201715685950A US2017351737A1 US 20170351737 A1 US20170351737 A1 US 20170351737A1 US 201715685950 A US201715685950 A US 201715685950A US 2017351737 A1 US2017351737 A1 US 2017351737A1
Authority
US
United States
Prior art keywords
search
memory
search results
indication
memory device
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Abandoned
Application number
US15/685,950
Inventor
Kenneth M. Curewitz
Sean Eilert
Hongyu Wang
Ameen D. Akel
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Micron Technology Inc
Original Assignee
Micron Technology Inc
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Micron Technology Inc filed Critical Micron Technology Inc
Priority to US15/685,950 priority Critical patent/US20170351737A1/en
Assigned to U.S. BANK NATIONAL ASSOCIATION, AS COLLATERAL AGENT reassignment U.S. BANK NATIONAL ASSOCIATION, AS COLLATERAL AGENT SUPPLEMENT NO. 6 TO PATENT SECURITY AGREEMENT Assignors: MICRON TECHNOLOGY, INC.
Assigned to MORGAN STANLEY SENIOR FUNDING, INC., AS COLLATERAL AGENT reassignment MORGAN STANLEY SENIOR FUNDING, INC., AS COLLATERAL AGENT SUPPLEMENT NO. 6 TO PATENT SECURITY AGREEMENT Assignors: MICRON TECHNOLOGY, INC.
Publication of US20170351737A1 publication Critical patent/US20170351737A1/en
Assigned to JPMORGAN CHASE BANK, N.A., AS COLLATERAL AGENT reassignment JPMORGAN CHASE BANK, N.A., AS COLLATERAL AGENT SECURITY INTEREST (SEE DOCUMENT FOR DETAILS). Assignors: MICRON SEMICONDUCTOR PRODUCTS, INC., MICRON TECHNOLOGY, INC.
Assigned to MICRON TECHNOLOGY, INC. reassignment MICRON TECHNOLOGY, INC. RELEASE BY SECURED PARTY (SEE DOCUMENT FOR DETAILS). Assignors: U.S. BANK NATIONAL ASSOCIATION, AS AGENT
Assigned to MICRON TECHNOLOGY, INC. reassignment MICRON TECHNOLOGY, INC. RELEASE BY SECURED PARTY (SEE DOCUMENT FOR DETAILS). Assignors: MORGAN STANLEY SENIOR FUNDING, INC., AS COLLATERAL AGENT
Assigned to MICRON SEMICONDUCTOR PRODUCTS, INC., MICRON TECHNOLOGY, INC. reassignment MICRON SEMICONDUCTOR PRODUCTS, INC. RELEASE BY SECURED PARTY (SEE DOCUMENT FOR DETAILS). Assignors: JPMORGAN CHASE BANK, N.A., AS COLLATERAL AGENT
Abandoned legal-status Critical Current

Links

Images

Classifications

    • G06F17/30519
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/24569Query processing with adaptation to specific hardware, e.g. adapted for using GPUs or SSDs
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10File systems; File servers
    • G06F16/18File system types
    • G06F16/1847File system types specifically adapted to static storage, e.g. adapted to flash memory or SSD
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/248Presentation of query results

Definitions

  • RAM random-access memory
  • ROM read only memory
  • DRAM dynamic random access memory
  • SDRAM synchronous dynamic random access memory
  • non-volatile memory e.g., flash
  • a number of non-volatile memory devices can be combined to make a solid state drive (SSD) that can emulate a mechanically-operated hard disk drive in a computer system.
  • SSD solid state drive
  • Solid state drives can provide faster access with greater reliability than mechanical hard drives due to the lack of moving parts.
  • memory and solid state drive manufactures are under constant pressure to increase the performance of their memory in order to try to keep pace with the computer system performance increases.
  • One way for memory manufacturers to increase memory performance is to decrease memory read/write times.
  • advancements in memory technology may hinder that effort.
  • Another way to increase memory performance can be to make searches of memory and SSDs more efficient.
  • FIG. 1 illustrates a block diagram of an embodiment of a database storage system.
  • FIG. 2 illustrates a block diagram of an embodiment of a memory system in accordance with the embodiment of FIG. 1 .
  • FIGS. 3A and 3B illustrate diagrams of embodiments of database storage formats.
  • FIGS. 4A and 4B illustrate protocol flow diagrams of embodiments of communication between a host and a memory.
  • FIG. 5 illustrates a functional block diagram of an embodiment of the method for autonomous memory searching.
  • FIGS. 6A and 6B illustrate flowcharts of embodiments of the method for autonomous memory searching.
  • FIG. 7 illustrates a block diagram of a system having multiple memory systems.
  • SSDs solid state drives
  • SQL structured query language
  • MySQL refers to a special purpose programming language designed for managing a relational database.
  • MySQL refers to a branded relational database management system that runs as a server to provide multi-user access to a number of databases.
  • a MySQLTM database system can often be characterized as a structured database.
  • the references herein to SQL and MySQLTM databases are thus for purposes of illustration only.
  • Embodiments of the autonomous memory search method disclosed herein may work equally well on other types of databases storing both structured and unstructured data. For example, any key-value store database (e.g., a NoSQL database) may use the autonomous memory searching method.
  • structured data can be data that is organized into discrete records (e.g., elements).
  • the records can be made up of one or more fields.
  • An example of structure data might be records that are partitioned into name, address, and identifying information.
  • unstructured data can be data that is not organized into discrete records (e.g., elements).
  • An example of unstructured data might be text from a book, a digital image, or a digital representation of human speech.
  • FIG. 1 illustrates a block diagram of an embodiment of a database system that can include a host 130 and a memory system (e.g., SSD) 108 .
  • the host 130 might be a computer system or CPU.
  • the memory system (e.g., SSD) 108 might be a single non-volatile memory device or a plurality of non-volatile memory devices combined into a single unit (e.g., SSD).
  • the host 130 can comprise a plurality of clients (e.g., client software, programs) 100 that can provide different database functions in the database system.
  • clients 100 might include database backup routines (e.g., mysqldump routine), table maintenance routines (e.g., mysqlcheck routine), command line interface routines (e.g., mysqlimport routine), and/or other database functions.
  • database backup routines e.g., mysqldump routine
  • table maintenance routines e.g., mysqlcheck routine
  • command line interface routines e.g., mysqlimport routine
  • the clients 100 communicate with the server 102 .
  • the server 102 might be a mysqld (MySQL Server) or some other type of server.
  • the server 102 can be the main program in the database system that manages access to the database stored in the memory system 108 for the clients 100 and a host (e.g., central processing unit, computer, controller).
  • a host e.g., central processing unit, computer, controller.
  • a storage engine 104 communicates between the server 102 and operating system (OS) file system protocols 106 of the host 130 .
  • the storage engine 104 transmits search criteria and search keys to the memory 108 through the OS file system 106 of the host 130 and receives the response to the search back from the memory system 108 through the OS file system 106 of the host 130 .
  • the search criteria and search keys are discussed subsequently.
  • a typical prior art storage engine might communicate large amounts of raw data from a database in memory during a typical search of the database. For example, in a typical prior art search of a database containing thousands of records in a table, most or all of the records are read from the memory into the CPU's main memory for processing by the CPU.
  • the storage engine 104 for the method for autonomous memory searching can communicate the search criteria and the search keys to the memory system 108 and receive back only the search results that resulted from a database search using the search criteria and search keys.
  • the storage engine 104 may not have to parse large amounts of raw data and the CPU may not have to use valuable time performing comparisons of search criteria and search keys to the raw data. This can result in a performance enhancement for systems using the methods for autonomous memory searching. This can also result in overall power savings, cost savings, and form factor advantages.
  • the memory system 108 can include any type of memory that can store a database to be searched.
  • FIG. 2 illustrates a block diagram of an embodiment for a memory system 108 (e.g., SSD).
  • a memory system 108 e.g., SSD
  • a controller e.g., processor
  • the controller 201 may comprise a module 210 (e.g., firmware or software) to direct the activities of the storage engine 104 , according to the protocols and methods described in FIGS. 4-6 .
  • FIG. 3A illustrates a diagram of an embodiment of a database storage format.
  • the database can be stored in a tabular format 300 .
  • the illustrated table 300 includes a header 301 and ‘n’ records (e.g., Record(0)-Record(n ⁇ 1)). Each record can point to the next record in the table 300 so that, when the table 300 is updated with a subsequent record, the previous record can be updated to point to the subsequent record.
  • n e.g., Record(0)-Record(n ⁇ 1)
  • the header 301 can include fields describing the table 300 .
  • the header 301 can include the number of records in the table 300 , a length of each record, a number of fields per record, and a length of each field.
  • Other embodiments might include additional description data in the header 301 .
  • Each record (e.g., Record(0)-Record(n ⁇ 1) 303 can include a plurality of fields (e.g., Field(0)-Field(m ⁇ 1)) of the data to be searched.
  • Each record 303 can also include a pointer field 305 to the next record. This pointer field 305 might be a logical address of another location in the memory that contains the next record. Thus, there is no need for the records to be located sequentially in memory.
  • Each field (e.g., Field(0)-Field(m ⁇ 1)) can comprise an element 307 that stores the field length and field data.
  • the field data can comprise the actual data 309 to be searched.
  • FIG. 3B illustrates another embodiment of a database storage format. This embodiment can also be in a tabular format 310 .
  • the formats of FIGS. 3A and 3B are for purposes of illustration only. The present embodiments are not limited to any one format, tabular or otherwise.
  • the table 310 comprises a table header 312 and ‘n’ record groups (e.g., Record Group(0)-Record Group(n ⁇ 1)). Each record group can point to the next record group in the table 300 so that, when the table 310 is updated with a subsequent record group, the previous record group can be updated to point to the subsequent record group.
  • n record groups
  • the header 312 can include fields describing the table 310 .
  • the header 312 can include a number of record groups, record group length, number of records, number of fields per record, field length, an address (e.g., logical address, physical address) of the first record group, and/or a version number of the table.
  • Each record group (e.g., Record Group(0)-Record Group(n ⁇ 1)) 314 can include ‘m’ records (e.g., Record(0)-Record(m ⁇ 1)).
  • Each record group 314 can include a pointer 320 to the next record group 314 and a field for the number of records 321 in each record group 314 in addition to the records 316 .
  • the pointer 320 might be a logical address of another location in the memory that contains the next record. Thus there is no need for the record groups to be located sequentially in memory.
  • Each record 316 can comprise ‘k’ fields 318 of data (e.g., Field(0)-Field(k ⁇ 1)).
  • Each field 318 can comprise the actual data to be searched.
  • FIGS. 4A and 4B illustrate protocol flow diagrams of two embodiments for communication between the host and the memory system. These embodiments are for purposes of illustration only as other embodiments might use alternate methods.
  • FIG. 4A illustrates a protocol flow diagram of an embodiment for communication between the host (e.g., CPU, computer) 130 and the memory system 108 , as described previously with reference to FIG. 1 , during the method for autonomous memory searching.
  • the host e.g., CPU, computer
  • three commands can be issued by the storage engine 104 to perform the search.
  • a write command e.g., small computer system interface (SCSI) write command
  • two or more read commands can be used to both transfer the search keys and search criteria to the memory system 108 as well as retrieve the results of the database search.
  • SCSI small computer system interface
  • the search of the database in the memory system 108 can be defined by one or more search keys (e.g., patterns), the search criteria (e.g., comparison criteria), and the dataset to be searched (e.g., database).
  • the search can be performed by comparing the search key to the dataset as a whole or to a series of subsets of the data. A match can be made when the comparison of the search key, qualified by the search criteria, matches at least a part of the dataset.
  • the result of the search might be no matches, one match, or a plurality of matches.
  • the search criteria can include operators such as “equal to”, “less than”, “greater than”, “not equal to”, “less than or equal to”, or “greater than or equal to”. Additionally, any logical operators such as “AND”, “OR”, “NOT”, and combinations of any logical operators, can be used either alone or in combination with other operators in searching the database.
  • the search can be initiated by the host 130 (e.g., command can be issued by a storage engine, such as the storage engine 104 of FIG. 1 ) issuing an initial command (e.g., SCSI write command) 401 to the memory system 108 .
  • the initial command 401 can include an indication of the search criteria and the search key.
  • the indication of the search criteria and the search key in the initial command can be a bit set in a particular field of the command indicating that a buffer implied by and associated with the command contain the search criteria and the search key.
  • a high order bit of the incoming logical block address (LBA) can be set to indicate to indicate queued search criteria and search key in the buffer.
  • the memory system 108 receives the initial command 401 and reads the indication of the queued search criteria and search key in the buffer. The memory system 108 can then reply back the host 130 with an acknowledgment 402 .
  • the acknowledgement may be considered as optional as the host 130 can simply assume that the memory system 108 received the initial command 401 .
  • the host 130 can then issue a second command (e.g., SCSI Read) 403 to the memory system 108 to indicate a readiness to receive the search results.
  • the second command 403 can remain outstanding with no response from the memory system 108 until the memory system 108 has either completed the search or filled its internal buffer allocated for the search results.
  • the memory system 108 can issue a response (e.g., sense data) 405 to the host 130 that indicates the search has been completed.
  • This response (e.g., sense data) 405 can indicate the number of results found from the search, if any, and if the search has been completed or the buffer is simply full and needs to be read in order to empty the buffer.
  • the host 130 can issue another command (e.g., SCSI Read) 407 , in response to this indication, to retrieve the results from the memory system buffer.
  • the memory system 108 can then issue another response (e.g., sense data) 409 that can contain the results of the search from the buffer.
  • the host 130 can return to this read step 403 and repeat the process until the search has been indicated as complete from the memory system 108 .
  • FIG. 4B illustrates a protocol flow diagram of another embodiment of communication between the host (e.g., CPU, computer) 130 and the memory system 108 , as described previously with reference to FIG. 1 , during the method for autonomous memory searching.
  • the host e.g., CPU, computer
  • three commands can be issued by the storage engine 104 to perform the search.
  • a write command e.g., small computer system interface (SCSI) write command
  • two or more read commands can be used to both transfer the search keys and search criteria to the memory system 108 as well as retrieve the results of the database search.
  • SCSI small computer system interface
  • the search can be initiated by the host 130 (e.g., command can be issued by a storage engine, such as the storage engine 104 of FIG. 1 ) issuing an initial command (e.g., SCSI write command) 410 to the memory system 108 .
  • the initial command 410 can include an indication of the search criteria and the search key.
  • the indication of the search criteria and the search key in the initial command can be a bit set in a particular field of the command indicating that a buffer implied by and associated with the command contain the search criteria and the search key.
  • a high order bit of the incoming logical block address (LBA) can be set to indicate to indicate queued search criteria and search key in the buffer.
  • the memory system 108 receives the initial command 410 and reads the indication of the queued search criteria and search key in the buffer. The memory system 108 can then reply back the host 130 with an acknowledgment 412 .
  • the acknowledgement may be considered as optional as the host 130 can simply assume that the memory system 108 received the initial command 410 .
  • the initial command 410 can remain outstanding with no response from the memory system 108 until the memory system 108 has either completed the search or filled its internal buffer allocated for the search results. Once the buffer has been filled with the search results or the search reaches the end of the database, the memory system 108 can issue a response (e.g., sense data) 414 to the host 130 that indicates the search has been completed or the search results buffers are full in response to the search request.
  • This response (e.g., sense data) 414 can indicate the number of results found from the search, if any, and if the search has been completed or the buffer is simply full and needs to be read in order to empty the buffer.
  • the memory system 108 can follow up the response 414 with the actual search results 416 (e.g., sense data), assuming a non-zero quantity of search results.
  • the host 130 can acknowledge the correct receipt of the search results with a command 418 (e.g., SCSI read command).
  • a command 418 e.g., SCSI read command
  • the memory system 108 can relinquish the buffers that were associated with the search. This may be indicated to the host 108 by a response (e.g., sense data) 420 from the memory system 108 .
  • the memory system 108 can still continue to operate normally. Thus, the memory system 108 can still respond to normal read and write commands from the host 130 .
  • FIG. 5 illustrates a functional block diagram of an embodiment of the method for autonomous memory searching. The execution of this functional block diagram may be performed by the controller 201 of the memory system 108 .
  • Commands e.g., search requests, reads
  • the memory bus e.g., Serial Advanced Technology Attachment (SATA)
  • SATA Serial Advanced Technology Attachment
  • the received command can be examined by parse block 501 to determine the type of command.
  • the received command is a search request (e.g. SCSI Write command 401 of FIG. 4 )
  • it can be queued in the request first-in-first-out (FIFO) buffer 503 for use by the search processing threads 512 .
  • the buffer 503 can store the search keys and search criteria. If the received command is determined by the parse block 501 to be one of the two subsequent commands (e.g., SCSI Read 403 , 407 of FIG. 4 ), indications of these commands can be stored in one of the two Outstanding Request buffers 505 , 506 .
  • the Continue buffer 505 can store an indication of the second command (e.g., SCSI Read 403 in FIG. 4 ) that requests the memory system to respond once the buffer is full or the search has been completed.
  • This buffer 505 is coupled to the Send Response Info block 507 so that, when the Response Info FIFO 508 contains data indicating that the search is done (e.g., Response FIFOs 510 , 511 are full, entire database has been searched), the Send Response Info block 507 can package the information response (e.g., Response 405 in FIG. 4 ) back to the host indicating that the buffers are full or the entire database has been searched.
  • the Response Info FIFO 508 contains data indicating that the search is done (e.g., Response FIFOs 510 , 511 are full, entire database has been searched)
  • the Send Response Info block 507 can package the information response (e.g., Response 405 in FIG. 4 ) back to the host indicating that the buffers are full or the entire database has been searched.
  • the Get-Response buffer 506 can store an indication of the third command (e.g., SCSI Read 407 in FIG. 4 ) that requests the search results from the memory system.
  • This buffer 508 is coupled to the Send Response block 509 so that, when the second command (e.g., SCSI Read 407 in FIG. 4 ) is received from the host, the Send Response block 509 can package the search results stored in the Response FIFO buffers 510 , 511 and send the data to the host over the memory bus.
  • an indication can be stored in the Response Buffer Free List 513 to indicate to the Search Processing Threads 512 that, if the search is still continuing, the Threads 512 can continue to fill up the buffers 510 , 511 .
  • the Search Processing Threads 512 each comprise a separate search as received from the host. By using multiple different Search Processing Threads 512 , a plurality of separate searches can be performed substantially simultaneously (e.g., substantially in parallel, partially or completely overlapping).
  • the search criteria and the search keys can be forwarded to one of the Search Processing Threads 512 . That particular Search Processing Thread 512 can then access the database record table (e.g., FIG. 3 ) to compare the search keys to the stored records according to the search criteria.
  • Each Search Processing Thread 512 might be executing a separate search having different search criteria and search keys.
  • an indication of what was accomplished can be stored in the Response Info FIFO 508 .
  • This indication can include a reference to the particular search to which the indication is referring in addition to the information as to whether the buffers 510 , 511 are simply full or the search is complete.
  • This indication can then be packaged by the Send Response Info block 507 and sent to the host, as previously discussed.
  • the functional blocks of FIG. 5 can be part of the memory system 108 and executed by the controller 201 in the memory system.
  • the functional blocks can be a combination of hardware and software/firmware modules.
  • the multiple Search Processing Threads 512 enable a plurality of parallel searches, the processing to accomplish these searches can be performed by the memory system 108 which can reduce the workload on the host 130 .
  • FIG. 6A illustrates a flowchart of an embodiment of the method for autonomous memory searching.
  • the host can transmit a command (e.g., a SCSI Write command, search request) to the memory system in order to initiate the search 601 .
  • This command can include an indication as to the search key and the search criteria.
  • the host can receive an acknowledgement from the memory system that the search request has been received 603 .
  • the host can then send a command (e.g., a SCSI Read command) to the memory system that indicates to the memory system that the host is ready to receive any results from the search request 605 .
  • a command e.g., a SCSI Read command
  • a response can be received from the memory system that can indicate either the search has been completed (e.g., entire database has been searched) or the search result buffers are full 607 .
  • the host can then send a command (e.g., SCSI Read command) to the memory system to retrieve those search results 609 to which the memory system can respond with the search results. If the memory system has indicated that the search is not complete 611 , the method repeats from the point where the host indicates its readiness to receive the search results 605 . If the search has been completed, the method is done 615 .
  • a command e.g., SCSI Read command
  • FIG. 6B illustrates a flowchart of another embodiment of the method for autonomous memory searching.
  • the memory might be configured prior to a search request.
  • the transfer size configuration e.g., size of the total responses before sending back to the requestor/initiator
  • the maximum/minimum record and page sizes e.g., sizes for the data structures stored and of the memory pages
  • the number of records per physical page might be set
  • partitioning of the drive for multiple regions some supporting conventional reads and writes and others supporting data-structure-aware operation
  • the existence of compression e.g., enabling/disabling, algorithm used
  • the existence of encryption e.g., enabling/disabling, algorithm used
  • the host can transmit a command (e.g., SCSI Write command, search request) to the memory system in order to initiate the search 620 .
  • This command can include an indication as to the search key and the search criteria.
  • the host can receive an acknowledgement from the memory system that the search request has been received 622 .
  • the memory system can issue a response to the host that indicates that the search has been completed or the search response buffers are full 624 .
  • the memory system can follow up this response with the actual search results 626 .
  • the host can then acknowledge receipt of the results and that the results were received correctly 628 .
  • the memory system can then relinquish the search results buffers that were associated with the search 630 .
  • the step of the memory system transmitting, and the host receiving, the indication that the search results exist can be combined with the step of the actual results being transmitted (e.g., 609 and 626 ).
  • FIGS. 6A and 6B are illustrated from the point of view of the host, one skilled in the art will know that these embodiments also illustrate the process as performed by the memory system. In other words, when the host receives a response from the memory system, one skilled in the art will understand that the memory system transmitted that response.
  • Embodiments may be implemented in one or a combination of hardware, firmware, and/or software including memory 203 of FIG. 2 . Embodiments may also be implemented as instructions stored on a computer-readable storage device, which may be read and executed by at least one processor to perform the operations described herein.
  • a computer-readable storage device may include any non-transitory mechanism for storing information in a form readable by a machine (e.g., a computer).
  • a computer-readable storage device may include read-only memory (ROM), random-access memory (RAM), magnetic disk storage media, optical storage media, flash-memory devices, and other storage devices and media.
  • a system may include one or more processors and may be configured with instructions stored on a computer-readable storage device.
  • the controller 201 of the memory system 108 can recognize the data structure format (e.g., as disclosed in FIGS. 3A and 3B ) that is being searched.
  • the software/firmware 210 has been written and/or upgraded to include, the attributes associated with that data structure.
  • the controller can then parse the individual fields of the data structure and, thus, perform operations involving that particular data structure. For example, a particular data structure might have been used previously or information regarding that data structure might have been pre-stored in the software/firmware executed by the controller 201 prior to an actual use of the particular data structure.
  • This information may include field descriptions in a database table, a database schema, a binary tree format, a graph structure or some other way to inform the memory system of the data structure format. All of this information may be part of (or updated to) the firmware/software of the controller so that the controller 201 knows what to expect when the particular database format is used in the memory system.
  • a user might instruct a memory system 108 to search a list in a database located at address 0.
  • the controller of the memory system could look at address 0 and find the proper format for the list.
  • the controller's firmware (or is sent via firmware upgrade) comprises stored routines that allow it to recognize the format of the stored data structure. If it's assumed that the controller finds the first element of the list there, it now recognizes the structure of that list (instead of just treating it as generic data), it can look at and associate different data fields as something meaningful (e.g., a pointer to the next list node and the stored data). Since the list is being searched, the software/firmware can instruct the controller to parse the pointer to the next list node, follow it, and begin processing the next list node in the same fashion.
  • the controller 201 of the memory system 108 can understand how to allocate space for the storage of new data structures that have not yet been used by the memory system. For example, the controller can manage the storage in the memory array and allocate any of that storage for an incoming command.
  • the controller 201 of the memory system 108 can understand and accept commands (e.g., from the host 130 ) to alter a state of the database.
  • the controller 201 might be configured to create a data base, create a table within the database, insert a record, delete a record, delete a table, or delete the database.
  • the controller 201 can also alter the state of the database where an index on a particular dataset is requested by the host 130 .
  • the controller 201 of the memory system 108 can control the memory system 108 such that a first memory system can act as a client to another database-enabled memory system.
  • a first memory system can act as a client to another database-enabled memory system.
  • the memory system is an SSD
  • one SSD with a database might be a client to and respond to commands from another SSD with a database. This can provide one memory system with the ability to also search the other memory system with the same search criteria and search keys.
  • FIG. 7 illustrates one example of such a system.
  • the host 130 can be coupled to and communicate with a plurality of memory systems (e.g., SSDs) 108 , 701 , 702 where each of the memory systems 108 , 701 , 702 are substantially similar.
  • the memory systems 108 , 701 , 702 can communicate not only with the host 130 but amongst themselves as well such that one memory system 701 can be a client to another memory system 108 .
  • the controller 201 of the memory system 108 can also have additional functions as determined by the firmware/software 210 executed by the controller. These functions are for illustration purposes only as the controller 201 is not limited to only certain functions.
  • the controller 201 can have the ability to reliably receive and control updating of the firmware/software 210 . This can be used for updating the abilities of the controller 201 .
  • the controller 201 can create new data structures to store the search results, create new data structures resulting from multiple input data structures (e.g., MySQLTM-style operations such as joins, unions, and other data manipulation operations), create new data structures based on a comparison of a common field in the data structure (e.g., MySQLTM-style join based on comparison of equivalent data in a particular column in multiple records), assign a value to a field in a record based on an aggregate function of other records (e.g., MySQLTM-style operations such as count, sum, average, standard deviation, and sum if).
  • MySQLTM-style operations such as count, sum, average, standard deviation, and sum if.
  • the controller 201 can further have the ability to add redundancy to the records of a database to be able to detect errors (e.g., error correction code (ECC)).
  • ECC error correction code
  • the controller 201 might control the addition of the ECC when the data is stored in the memory such that the ECC is stored with in the database or the controller 201 can control adding the ECC to the search results prior to transmission to the host.
  • the controller 201 can also replicate records such that the additional records can be examined in the case of errors detected in current records.
  • the controller 201 can further have the ability to create an index in one or more fields of the database in order to improve search performance. For example, the controller 201 can control storing of a flag in a particular field of each record so that a subsequent search can simply look for that flag to determine if that particular record meets the search key and search criteria.
  • the controller 201 can further have the ability to control the storing of the search results in a cache of the memory system.
  • This cache may be the search results data buffers or another cache used for other purposes in the memory system.
  • the controller 201 can further have the ability to control the clearing of memory and/or the search results data buffer when an indication (e.g., write command) has been received that the search results have been correctly received.
  • the controller 201 can further control the de-allocation of the memory locations (e.g., cache, data buffer, memory) used to store the search results.
  • An apparatus may be defined as circuitry, an integrated circuit die, a memory device, a memory array, or a system.
  • One or more embodiments of the apparatus and method for autonomous memory searching can perform a search of either a structured or unstructured dataset in a database of a memory system (e.g., SSD).
  • the search can be executed entirely within the memory system without intervention from the external host.
  • One or more search requests can be queued in the memory system. Multiple searches can be processed substantially in parallel. In a system with multiple memory systems (e.g., multiple SSDs), multiple searches per memory system can be queued.
  • a dataset can reside in a single memory system or span multiple memory systems and be searched by a single search to the entire dataset.

Abstract

Methods and systems operate to receive a plurality of search requests for searching a database in a memory system. The search requests can be stored in a FIFO queue and searches can be subsequently generated for each search request. The resulting plurality of searches can be executed substantially in parallel on the database. A respective indication is transmitted to a requesting host when either each respective search is complete or each respective search has generated search results.

Description

    PRIORITY APPLICATION
  • This application is a continuation of U.S. application Ser. No. 13/965,739, filed Aug. 13, 2013, which is incorporated herein by reference in its entirety.
  • BACKGROUND
  • Memory devices are typically provided as internal, semiconductor, integrated circuits in computers or other electronic devices. There are many different types of memory including random-access memory (RAM), read only memory (ROM), dynamic random access memory (DRAM), synchronous dynamic random access memory (SDRAM), and non-volatile (e.g., flash) memory.
  • A number of non-volatile memory devices can be combined to make a solid state drive (SSD) that can emulate a mechanically-operated hard disk drive in a computer system. Solid state drives can provide faster access with greater reliability than mechanical hard drives due to the lack of moving parts.
  • Due at least in part to the increasing performance of computer systems, memory and solid state drive manufactures are under constant pressure to increase the performance of their memory in order to try to keep pace with the computer system performance increases. One way for memory manufacturers to increase memory performance is to decrease memory read/write times. However, advancements in memory technology may hinder that effort. Another way to increase memory performance can be to make searches of memory and SSDs more efficient.
  • BRIEF DESCRIPTION OF THE DRAWINGS
  • FIG. 1 illustrates a block diagram of an embodiment of a database storage system.
  • FIG. 2 illustrates a block diagram of an embodiment of a memory system in accordance with the embodiment of FIG. 1.
  • FIGS. 3A and 3B illustrate diagrams of embodiments of database storage formats.
  • FIGS. 4A and 4B illustrate protocol flow diagrams of embodiments of communication between a host and a memory.
  • FIG. 5 illustrates a functional block diagram of an embodiment of the method for autonomous memory searching.
  • FIGS. 6A and 6B illustrate flowcharts of embodiments of the method for autonomous memory searching.
  • FIG. 7 illustrates a block diagram of a system having multiple memory systems.
  • DETAILED DESCRIPTION
  • In the following detailed description, reference is made to the accompanying drawings that form a part hereof and in which is shown, by way of illustration, specific embodiments. In the drawings, like numerals describe substantially similar components throughout the several views. Other embodiments may be utilized and structural, logical, and electrical changes may be made without departing from the scope of the present disclosure. The following detailed description is, therefore, not to be taken in a limiting sense.
  • Subsequent reference is made to solid state drives (SSDs) for purposes of illustration only. Autonomous memory searching operations, as disclosed herein, may work equally well on any type of memory device or group of memory devices including semiconductor memory, optical memory, or magnetic memory. Thus, the present disclosure is not limited to searches of SSDs.
  • Subsequent reference is also made to structured query language (SQL) and the term “MySQL”. SQL, as is known in the art, refers to a special purpose programming language designed for managing a relational database. The term “MySQL” refers to a branded relational database management system that runs as a server to provide multi-user access to a number of databases. A MySQL™ database system can often be characterized as a structured database. The references herein to SQL and MySQL™ databases are thus for purposes of illustration only. Embodiments of the autonomous memory search method disclosed herein may work equally well on other types of databases storing both structured and unstructured data. For example, any key-value store database (e.g., a NoSQL database) may use the autonomous memory searching method.
  • As used herein, structured data can be data that is organized into discrete records (e.g., elements). The records can be made up of one or more fields. An example of structure data might be records that are partitioned into name, address, and identifying information.
  • As used herein, unstructured data can be data that is not organized into discrete records (e.g., elements). An example of unstructured data might be text from a book, a digital image, or a digital representation of human speech.
  • FIG. 1 illustrates a block diagram of an embodiment of a database system that can include a host 130 and a memory system (e.g., SSD) 108. The host 130 might be a computer system or CPU. The memory system (e.g., SSD) 108 might be a single non-volatile memory device or a plurality of non-volatile memory devices combined into a single unit (e.g., SSD).
  • The host 130 can comprise a plurality of clients (e.g., client software, programs) 100 that can provide different database functions in the database system. For example, these clients 100 might include database backup routines (e.g., mysqldump routine), table maintenance routines (e.g., mysqlcheck routine), command line interface routines (e.g., mysqlimport routine), and/or other database functions.
  • The clients 100 communicate with the server 102. The server 102 might be a mysqld (MySQL Server) or some other type of server. The server 102 can be the main program in the database system that manages access to the database stored in the memory system 108 for the clients 100 and a host (e.g., central processing unit, computer, controller).
  • A storage engine 104 communicates between the server 102 and operating system (OS) file system protocols 106 of the host 130. The storage engine 104 transmits search criteria and search keys to the memory 108 through the OS file system 106 of the host 130 and receives the response to the search back from the memory system 108 through the OS file system 106 of the host 130. The search criteria and search keys are discussed subsequently.
  • A typical prior art storage engine might communicate large amounts of raw data from a database in memory during a typical search of the database. For example, in a typical prior art search of a database containing thousands of records in a table, most or all of the records are read from the memory into the CPU's main memory for processing by the CPU.
  • The storage engine 104 for the method for autonomous memory searching can communicate the search criteria and the search keys to the memory system 108 and receive back only the search results that resulted from a database search using the search criteria and search keys. Thus, the storage engine 104 may not have to parse large amounts of raw data and the CPU may not have to use valuable time performing comparisons of search criteria and search keys to the raw data. This can result in a performance enhancement for systems using the methods for autonomous memory searching. This can also result in overall power savings, cost savings, and form factor advantages.
  • The memory system 108 can include any type of memory that can store a database to be searched. FIG. 2 illustrates a block diagram of an embodiment for a memory system 108 (e.g., SSD). For example, a plurality of non-volatile memory devices (e.g., Flash memory) can be combined to form the memory block 203. The memory system 108 (e.g., SSD) can have a controller (e.g., processor) 201 coupled to the memory block 203 for controlling operation of the memory system 108 (e.g., SSD). The controller 201 may comprise a module 210 (e.g., firmware or software) to direct the activities of the storage engine 104, according to the protocols and methods described in FIGS. 4-6.
  • FIG. 3A illustrates a diagram of an embodiment of a database storage format. In the illustrated embodiment, the database can be stored in a tabular format 300. The illustrated table 300 includes a header 301 and ‘n’ records (e.g., Record(0)-Record(n−1)). Each record can point to the next record in the table 300 so that, when the table 300 is updated with a subsequent record, the previous record can be updated to point to the subsequent record.
  • The header 301 can include fields describing the table 300. For example, the header 301 can include the number of records in the table 300, a length of each record, a number of fields per record, and a length of each field. Other embodiments might include additional description data in the header 301.
  • Each record (e.g., Record(0)-Record(n−1) 303 can include a plurality of fields (e.g., Field(0)-Field(m−1)) of the data to be searched. Each record 303 can also include a pointer field 305 to the next record. This pointer field 305 might be a logical address of another location in the memory that contains the next record. Thus, there is no need for the records to be located sequentially in memory.
  • Each field (e.g., Field(0)-Field(m−1)) can comprise an element 307 that stores the field length and field data. The field data can comprise the actual data 309 to be searched.
  • FIG. 3B illustrates another embodiment of a database storage format. This embodiment can also be in a tabular format 310. However, the formats of FIGS. 3A and 3B are for purposes of illustration only. The present embodiments are not limited to any one format, tabular or otherwise.
  • The table 310 comprises a table header 312 and ‘n’ record groups (e.g., Record Group(0)-Record Group(n−1)). Each record group can point to the next record group in the table 300 so that, when the table 310 is updated with a subsequent record group, the previous record group can be updated to point to the subsequent record group.
  • The header 312 can include fields describing the table 310. For example, the header 312 can include a number of record groups, record group length, number of records, number of fields per record, field length, an address (e.g., logical address, physical address) of the first record group, and/or a version number of the table.
  • Each record group (e.g., Record Group(0)-Record Group(n−1)) 314 can include ‘m’ records (e.g., Record(0)-Record(m−1)). Each record group 314 can include a pointer 320 to the next record group 314 and a field for the number of records 321 in each record group 314 in addition to the records 316. The pointer 320 might be a logical address of another location in the memory that contains the next record. Thus there is no need for the record groups to be located sequentially in memory.
  • Each record 316 can comprise ‘k’ fields 318 of data (e.g., Field(0)-Field(k−1)). Each field 318 can comprise the actual data to be searched.
  • FIGS. 4A and 4B illustrate protocol flow diagrams of two embodiments for communication between the host and the memory system. These embodiments are for purposes of illustration only as other embodiments might use alternate methods.
  • FIG. 4A illustrates a protocol flow diagram of an embodiment for communication between the host (e.g., CPU, computer) 130 and the memory system 108, as described previously with reference to FIG. 1, during the method for autonomous memory searching. In the illustrated embodiment, three commands can be issued by the storage engine 104 to perform the search. For example, a write command (e.g., small computer system interface (SCSI) write command) followed by two or more read commands can be used to both transfer the search keys and search criteria to the memory system 108 as well as retrieve the results of the database search.
  • The search of the database in the memory system 108 can be defined by one or more search keys (e.g., patterns), the search criteria (e.g., comparison criteria), and the dataset to be searched (e.g., database). The search can be performed by comparing the search key to the dataset as a whole or to a series of subsets of the data. A match can be made when the comparison of the search key, qualified by the search criteria, matches at least a part of the dataset. The result of the search might be no matches, one match, or a plurality of matches.
  • The search criteria can include operators such as “equal to”, “less than”, “greater than”, “not equal to”, “less than or equal to”, or “greater than or equal to”. Additionally, any logical operators such as “AND”, “OR”, “NOT”, and combinations of any logical operators, can be used either alone or in combination with other operators in searching the database.
  • The search can be initiated by the host 130 (e.g., command can be issued by a storage engine, such as the storage engine 104 of FIG. 1) issuing an initial command (e.g., SCSI write command) 401 to the memory system 108. The initial command 401 can include an indication of the search criteria and the search key.
  • The indication of the search criteria and the search key in the initial command (e.g., SCSI Write command) can be a bit set in a particular field of the command indicating that a buffer implied by and associated with the command contain the search criteria and the search key. For example, in a SCSI Write command, a high order bit of the incoming logical block address (LBA) can be set to indicate to indicate queued search criteria and search key in the buffer.
  • The memory system 108 receives the initial command 401 and reads the indication of the queued search criteria and search key in the buffer. The memory system 108 can then reply back the host 130 with an acknowledgment 402. The acknowledgement may be considered as optional as the host 130 can simply assume that the memory system 108 received the initial command 401.
  • The host 130 (e.g., storage engine) can then issue a second command (e.g., SCSI Read) 403 to the memory system 108 to indicate a readiness to receive the search results. The second command 403 can remain outstanding with no response from the memory system 108 until the memory system 108 has either completed the search or filled its internal buffer allocated for the search results. Once the buffer has been filled with the search results or the search reaches the end of the database, the memory system 108 can issue a response (e.g., sense data) 405 to the host 130 that indicates the search has been completed. This response (e.g., sense data) 405 can indicate the number of results found from the search, if any, and if the search has been completed or the buffer is simply full and needs to be read in order to empty the buffer.
  • If the response 405 from the memory system 108 indicates a non-zero number of search results, the host 130 can issue another command (e.g., SCSI Read) 407, in response to this indication, to retrieve the results from the memory system buffer. The memory system 108 can then issue another response (e.g., sense data) 409 that can contain the results of the search from the buffer.
  • If the results of the first read command 403 from the host 130 indicates that the search is not yet complete, the host 130 can return to this read step 403 and repeat the process until the search has been indicated as complete from the memory system 108.
  • FIG. 4B illustrates a protocol flow diagram of another embodiment of communication between the host (e.g., CPU, computer) 130 and the memory system 108, as described previously with reference to FIG. 1, during the method for autonomous memory searching. In the illustrated embodiment, three commands can be issued by the storage engine 104 to perform the search. For example, a write command (e.g., small computer system interface (SCSI) write command) followed by two or more read commands can be used to both transfer the search keys and search criteria to the memory system 108 as well as retrieve the results of the database search.
  • The search can be initiated by the host 130 (e.g., command can be issued by a storage engine, such as the storage engine 104 of FIG. 1) issuing an initial command (e.g., SCSI write command) 410 to the memory system 108. The initial command 410 can include an indication of the search criteria and the search key.
  • The indication of the search criteria and the search key in the initial command (e.g., SCSI Write command) can be a bit set in a particular field of the command indicating that a buffer implied by and associated with the command contain the search criteria and the search key. For example, in a SCSI Write command, a high order bit of the incoming logical block address (LBA) can be set to indicate to indicate queued search criteria and search key in the buffer.
  • The memory system 108 receives the initial command 410 and reads the indication of the queued search criteria and search key in the buffer. The memory system 108 can then reply back the host 130 with an acknowledgment 412. The acknowledgement may be considered as optional as the host 130 can simply assume that the memory system 108 received the initial command 410.
  • The initial command 410 can remain outstanding with no response from the memory system 108 until the memory system 108 has either completed the search or filled its internal buffer allocated for the search results. Once the buffer has been filled with the search results or the search reaches the end of the database, the memory system 108 can issue a response (e.g., sense data) 414 to the host 130 that indicates the search has been completed or the search results buffers are full in response to the search request. This response (e.g., sense data) 414 can indicate the number of results found from the search, if any, and if the search has been completed or the buffer is simply full and needs to be read in order to empty the buffer.
  • The memory system 108 can follow up the response 414 with the actual search results 416 (e.g., sense data), assuming a non-zero quantity of search results. The host 130 can acknowledge the correct receipt of the search results with a command 418 (e.g., SCSI read command).
  • The memory system 108 can relinquish the buffers that were associated with the search. This may be indicated to the host 108 by a response (e.g., sense data) 420 from the memory system 108.
  • During the protocol flow diagrams illustrated in FIGS. 4A and 4B, the memory system 108 can still continue to operate normally. Thus, the memory system 108 can still respond to normal read and write commands from the host 130.
  • FIG. 5 illustrates a functional block diagram of an embodiment of the method for autonomous memory searching. The execution of this functional block diagram may be performed by the controller 201 of the memory system 108.
  • Commands (e.g., search requests, reads) can be received off the memory bus (e.g., Serial Advanced Technology Attachment (SATA)) from the host. The received command can be examined by parse block 501 to determine the type of command.
  • If the received command is a search request (e.g. SCSI Write command 401 of FIG. 4), it can be queued in the request first-in-first-out (FIFO) buffer 503 for use by the search processing threads 512. The buffer 503 can store the search keys and search criteria. If the received command is determined by the parse block 501 to be one of the two subsequent commands (e.g., SCSI Read 403, 407 of FIG. 4), indications of these commands can be stored in one of the two Outstanding Request buffers 505, 506.
  • The Continue buffer 505 can store an indication of the second command (e.g., SCSI Read 403 in FIG. 4) that requests the memory system to respond once the buffer is full or the search has been completed. This buffer 505 is coupled to the Send Response Info block 507 so that, when the Response Info FIFO 508 contains data indicating that the search is done (e.g., Response FIFOs 510, 511 are full, entire database has been searched), the Send Response Info block 507 can package the information response (e.g., Response 405 in FIG. 4) back to the host indicating that the buffers are full or the entire database has been searched.
  • The Get-Response buffer 506 can store an indication of the third command (e.g., SCSI Read 407 in FIG. 4) that requests the search results from the memory system. This buffer 508 is coupled to the Send Response block 509 so that, when the second command (e.g., SCSI Read 407 in FIG. 4) is received from the host, the Send Response block 509 can package the search results stored in the Response FIFO buffers 510, 511 and send the data to the host over the memory bus. Once these buffers 510, 511 have been emptied, an indication can be stored in the Response Buffer Free List 513 to indicate to the Search Processing Threads 512 that, if the search is still continuing, the Threads 512 can continue to fill up the buffers 510, 511.
  • The Search Processing Threads 512 each comprise a separate search as received from the host. By using multiple different Search Processing Threads 512, a plurality of separate searches can be performed substantially simultaneously (e.g., substantially in parallel, partially or completely overlapping).
  • When the initiating command (e.g., SCSI Write 401 in FIG. 4) is received from the host, the search criteria and the search keys can be forwarded to one of the Search Processing Threads 512. That particular Search Processing Thread 512 can then access the database record table (e.g., FIG. 3) to compare the search keys to the stored records according to the search criteria. Each Search Processing Thread 512 might be executing a separate search having different search criteria and search keys.
  • Once one of the Search Processing Threads 512 has either filled the buffers 510, 511 with results from the search or searched the entire database (e.g., search completed), an indication of what was accomplished can be stored in the Response Info FIFO 508. This indication can include a reference to the particular search to which the indication is referring in addition to the information as to whether the buffers 510, 511 are simply full or the search is complete. This indication can then be packaged by the Send Response Info block 507 and sent to the host, as previously discussed.
  • The functional blocks of FIG. 5 can be part of the memory system 108 and executed by the controller 201 in the memory system. The functional blocks can be a combination of hardware and software/firmware modules. Thus, not only can the multiple Search Processing Threads 512 enable a plurality of parallel searches, the processing to accomplish these searches can be performed by the memory system 108 which can reduce the workload on the host 130.
  • FIG. 6A illustrates a flowchart of an embodiment of the method for autonomous memory searching. The host can transmit a command (e.g., a SCSI Write command, search request) to the memory system in order to initiate the search 601. This command can include an indication as to the search key and the search criteria. The host can receive an acknowledgement from the memory system that the search request has been received 603.
  • The host can then send a command (e.g., a SCSI Read command) to the memory system that indicates to the memory system that the host is ready to receive any results from the search request 605. A response can be received from the memory system that can indicate either the search has been completed (e.g., entire database has been searched) or the search result buffers are full 607.
  • The host can then send a command (e.g., SCSI Read command) to the memory system to retrieve those search results 609 to which the memory system can respond with the search results. If the memory system has indicated that the search is not complete 611, the method repeats from the point where the host indicates its readiness to receive the search results 605. If the search has been completed, the method is done 615.
  • FIG. 6B illustrates a flowchart of another embodiment of the method for autonomous memory searching. In an optional step, the memory might be configured prior to a search request. For example, the transfer size configuration (e.g., size of the total responses before sending back to the requestor/initiator) might be set up, the maximum/minimum record and page sizes (e.g., sizes for the data structures stored and of the memory pages) might be set, the number of records per physical page might be set, partitioning of the drive for multiple regions, some supporting conventional reads and writes and others supporting data-structure-aware operation might be set, the existence of compression (e.g., enabling/disabling, algorithm used) might be set, and/or the existence of encryption (e.g., enabling/disabling, algorithm used) might be set.
  • The host can transmit a command (e.g., SCSI Write command, search request) to the memory system in order to initiate the search 620. This command can include an indication as to the search key and the search criteria. The host can receive an acknowledgement from the memory system that the search request has been received 622.
  • The memory system can issue a response to the host that indicates that the search has been completed or the search response buffers are full 624. The memory system can follow up this response with the actual search results 626. The host can then acknowledge receipt of the results and that the results were received correctly 628. The memory system can then relinquish the search results buffers that were associated with the search 630.
  • In another embodiment, the step of the memory system transmitting, and the host receiving, the indication that the search results exist (e.g., 607 and 624) can be combined with the step of the actual results being transmitted (e.g., 609 and 626).
  • While the embodiments of FIGS. 6A and 6B are illustrated from the point of view of the host, one skilled in the art will know that these embodiments also illustrate the process as performed by the memory system. In other words, when the host receives a response from the memory system, one skilled in the art will understand that the memory system transmitted that response.
  • Embodiments may be implemented in one or a combination of hardware, firmware, and/or software including memory 203 of FIG. 2. Embodiments may also be implemented as instructions stored on a computer-readable storage device, which may be read and executed by at least one processor to perform the operations described herein. A computer-readable storage device may include any non-transitory mechanism for storing information in a form readable by a machine (e.g., a computer). For example, a computer-readable storage device may include read-only memory (ROM), random-access memory (RAM), magnetic disk storage media, optical storage media, flash-memory devices, and other storage devices and media. In some embodiments, a system may include one or more processors and may be configured with instructions stored on a computer-readable storage device.
  • The controller 201 of the memory system 108 can recognize the data structure format (e.g., as disclosed in FIGS. 3A and 3B) that is being searched. In order for the controller 201 to recognize the data structure, the software/firmware 210 has been written and/or upgraded to include, the attributes associated with that data structure. The controller can then parse the individual fields of the data structure and, thus, perform operations involving that particular data structure. For example, a particular data structure might have been used previously or information regarding that data structure might have been pre-stored in the software/firmware executed by the controller 201 prior to an actual use of the particular data structure. This information may include field descriptions in a database table, a database schema, a binary tree format, a graph structure or some other way to inform the memory system of the data structure format. All of this information may be part of (or updated to) the firmware/software of the controller so that the controller 201 knows what to expect when the particular database format is used in the memory system.
  • As an example of such an operation where the controller 201 can recognize the data structure format, a user might instruct a memory system 108 to search a list in a database located at address 0. The controller of the memory system could look at address 0 and find the proper format for the list. The controller's firmware (or is sent via firmware upgrade) comprises stored routines that allow it to recognize the format of the stored data structure. If it's assumed that the controller finds the first element of the list there, it now recognizes the structure of that list (instead of just treating it as generic data), it can look at and associate different data fields as something meaningful (e.g., a pointer to the next list node and the stored data). Since the list is being searched, the software/firmware can instruct the controller to parse the pointer to the next list node, follow it, and begin processing the next list node in the same fashion.
  • The controller 201 of the memory system 108 can understand how to allocate space for the storage of new data structures that have not yet been used by the memory system. For example, the controller can manage the storage in the memory array and allocate any of that storage for an incoming command.
  • The controller 201 of the memory system 108 can understand and accept commands (e.g., from the host 130) to alter a state of the database. In other words, the controller 201 might be configured to create a data base, create a table within the database, insert a record, delete a record, delete a table, or delete the database. The controller 201 can also alter the state of the database where an index on a particular dataset is requested by the host 130.
  • The controller 201 of the memory system 108 can control the memory system 108 such that a first memory system can act as a client to another database-enabled memory system. For example, if the memory system is an SSD, one SSD with a database might be a client to and respond to commands from another SSD with a database. This can provide one memory system with the ability to also search the other memory system with the same search criteria and search keys.
  • FIG. 7 illustrates one example of such a system. The host 130 can be coupled to and communicate with a plurality of memory systems (e.g., SSDs) 108, 701, 702 where each of the memory systems 108, 701, 702 are substantially similar. The memory systems 108, 701, 702 can communicate not only with the host 130 but amongst themselves as well such that one memory system 701 can be a client to another memory system 108.
  • The controller 201 of the memory system 108 can also have additional functions as determined by the firmware/software 210 executed by the controller. These functions are for illustration purposes only as the controller 201 is not limited to only certain functions.
  • For example, the controller 201 can have the ability to reliably receive and control updating of the firmware/software 210. This can be used for updating the abilities of the controller 201. The controller 201 can create new data structures to store the search results, create new data structures resulting from multiple input data structures (e.g., MySQL™-style operations such as joins, unions, and other data manipulation operations), create new data structures based on a comparison of a common field in the data structure (e.g., MySQL™-style join based on comparison of equivalent data in a particular column in multiple records), assign a value to a field in a record based on an aggregate function of other records (e.g., MySQL™-style operations such as count, sum, average, standard deviation, and sum if).
  • The controller 201 can further have the ability to add redundancy to the records of a database to be able to detect errors (e.g., error correction code (ECC)). For example, the controller 201 might control the addition of the ECC when the data is stored in the memory such that the ECC is stored with in the database or the controller 201 can control adding the ECC to the search results prior to transmission to the host. The controller 201 can also replicate records such that the additional records can be examined in the case of errors detected in current records.
  • The controller 201 can further have the ability to create an index in one or more fields of the database in order to improve search performance. For example, the controller 201 can control storing of a flag in a particular field of each record so that a subsequent search can simply look for that flag to determine if that particular record meets the search key and search criteria.
  • The controller 201 can further have the ability to control the storing of the search results in a cache of the memory system. This cache may be the search results data buffers or another cache used for other purposes in the memory system.
  • The controller 201 can further have the ability to control the clearing of memory and/or the search results data buffer when an indication (e.g., write command) has been received that the search results have been correctly received. The controller 201 can further control the de-allocation of the memory locations (e.g., cache, data buffer, memory) used to store the search results.
  • An apparatus may be defined as circuitry, an integrated circuit die, a memory device, a memory array, or a system.
  • CONCLUSION
  • One or more embodiments of the apparatus and method for autonomous memory searching can perform a search of either a structured or unstructured dataset in a database of a memory system (e.g., SSD). The search can be executed entirely within the memory system without intervention from the external host. One or more search requests can be queued in the memory system. Multiple searches can be processed substantially in parallel. In a system with multiple memory systems (e.g., multiple SSDs), multiple searches per memory system can be queued. A dataset can reside in a single memory system or span multiple memory systems and be searched by a single search to the entire dataset.
  • Although specific embodiments have been illustrated and described herein, it will be appreciated by those of ordinary skill in the art that any arrangement that is calculated to achieve the same purpose may be substituted for the specific embodiments shown. Many adaptations will be apparent to those of ordinary skill in the art. Accordingly, this application is intended to cover any adaptations or variations.

Claims (32)

What is claimed is:
1. A method of autonomous memory searching performed by a memory controller of a memory device, for searching a non-volatile memory of the memory device, the method comprising:
processing a write command provided from a host to the memory device, wherein the write command is addressed to the memory device and includes a search request indicated by a predetermined bit in a logical block address field of the write command;
initiating a search of the memory in response to the write command, wherein the logical block address field of the write command further includes bits indicating information to initiate the search, such that the logical block address field in the write command includes the predetermined bit and additional bits in place of a logical block address; and
obtaining results of the search of the memory.
2. The method of claim 1, wherein the write command includes an indication of a search criteria and a search key.
3. The method of claim 2, wherein the search criteria includes one or more of: “equal to”, “less than”, “greater than”, “not equal to”, “less than or equal to”, “greater than or equal to”, “AND”, “OR”, or “NOT”.
4. The method of claim 1, wherein the predetermined bit in the logical block address field further indicates search information is available to the memory device to perform the search request.
5. The method of claim 1, wherein the results include an indication that the search has been completed or that search results have been found, and wherein when the search results have been found, the search results are provided from the memory in response to the indication.
6. The method of claim 5, wherein obtaining the indication that the search has been completed or that the search results have been found comprises obtaining an indication that the search has reached an end of a database stored in the memory.
7. The method of claim 5, wherein obtaining the indication that the search has been completed or that the search results have been found comprises obtaining an indication that buffers to provide the search results are full.
8. The method of claim 1, wherein providing the search results from the memory comprises providing the search results in response to a read command to the memory device that causes the memory device to transmit back the search results.
9. The method of claim 1, wherein providing the search results from the memory in comprises providing the search results in response to a command issued to the memory that indicates that the host is ready to receive the search results.
10. The method of claim 9, wherein the write command includes a small computer system interface (SCSI) Write command, and wherein the command that indicates that the host is ready to receive the search results includes a SCSI Read command.
11. The method of claim 1, further comprising:
transmitting an indication, to the host, that the search has been completed or that search results have been found.
12. A non-transitory device-readable storage medium, that provides instructions that, when executed by a memory controller of a memory device, performs autonomous memory searching of a non-volatile memory of the memory device, wherein the instructions cause the controller to perform operations comprising:
processing a write command transmitted from a host to the memory device, wherein the write command is addressed to the memory device and includes a search request indicated by a predetermined bit in a logical block address field of the write command;
initiating a search of the memory in response to the write command, wherein the logical block address field of the write command further includes bits indicating information to initiate the search, such that the logical block address field in the write command includes the predetermined bit and additional bits in place of a logical block address; and
obtaining results of the search of the memory, the results including an indication that the search has been completed or that search results have been found.
13. The storage medium of claim 12, wherein the write command includes an indication of a search criteria and a search key.
14. The storage medium of claim 13, wherein the search criteria includes one or more of: “equal to”, “less than”, “greater than”, “not equal to”, “less than or equal to”, “greater than or equal to”, “AND”, “OR”, or “NOT”.
15. The storage medium of claim 12, wherein when the search results have been found, the operations further comprise providing the search results from the memory in response to the indication.
16. The storage medium of claim 12, wherein obtaining the indication that the search has been completed or that the search results have been found comprises obtaining an indication that the search has reached an end of a database stored in the memory.
17. The storage medium of claim 12, wherein obtaining the indication that the search has been completed or that the search results have been found comprises obtaining an indication that buffers to provide the search results are full.
18. The storage medium of claim 12, wherein providing the search results from the memory comprises providing the search results in response to a read command to the memory device that causes the memory device to transmit back the search results.
19. The storage medium of claim 12, wherein providing the search results from the memory in comprises providing the search results in response to a command issued to the memory that indicates that the host is ready to receive the search results.
20. The storage medium of claim 19, wherein the write command includes a small computer system interface (SCSI) Write command, and wherein the command that indicates that the host is ready to receive the search results includes a SCSI Read command.
21. The storage medium of claim 12, further comprising:
transmitting an indication, to the host, that the search has been completed or that search results have been found.
22. A memory device, comprising:
a non-volatile memory; and
a memory controller operably coupled to the non-volatile memory, the memory controller to perform operations comprising:
processing a write command transmitted from a host to the memory device, wherein the write command is addressed to the memory device and includes a search request indicated by a predetermined bit in a logical block address field of the write command;
initiating a search of the memory in response to the write command, wherein the logical block address field of the write command further includes bits indicating information to initiate the search, such that the logical block address field in the write command includes the predetermined bit and additional bits in place of a logical block address; and
obtaining results of the search of the memory.
23. The memory device of claim 22, wherein the write command includes an indication of a search criteria and a search key.
24. The memory device of claim 23, wherein the search criteria includes one or more of: “equal to”, “less than”, “greater than”, “not equal to”, “less than or equal to”, “greater than or equal to”, “AND”, “OR”, or “NOT”.
25. The memory device of claim 22, the operations further comprising:
obtaining an indication that the search has been completed or that search results have been found; and
when the search results have been found, providing the search results from the memory in response to the indication.
26. The memory device of claim 25, wherein obtaining the indication that the search has been completed or that the search results have been found comprises obtaining an indication that the search has reached an end of a database stored in the memory.
27. The memory device of claim 25, wherein obtaining the indication that the search has been completed or that the search results have been found comprises obtaining an indication that buffers to provide the search results are full.
28. The memory device of claim 22, wherein providing the search results from the memory comprises providing the search results in response to a read command to the memory device that causes the memory device to transmit back the search results.
29. The memory device of claim 22, wherein providing the search results from the memory comprises providing the search results in response to a command issued to the memory that indicates that the host is ready to receive the search results.
30. The memory device of claim 29, wherein the write command includes a small computer system interface (SCSI) Write command, and wherein the command that indicates that the host is ready to receive the search results includes a SCSI Read command.
31. The memory device of claim 22, further comprising:
transmitting an indication, to the host, that the search has been completed or that search results have been found.
32. The memory device of claim 22, wherein the memory device is a solid state drive, and wherein the host is a computing device.
US15/685,950 2013-08-13 2017-08-24 Methods and systems for autonomous memory searching Abandoned US20170351737A1 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
US15/685,950 US20170351737A1 (en) 2013-08-13 2017-08-24 Methods and systems for autonomous memory searching

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US13/965,739 US9779138B2 (en) 2013-08-13 2013-08-13 Methods and systems for autonomous memory searching
US15/685,950 US20170351737A1 (en) 2013-08-13 2017-08-24 Methods and systems for autonomous memory searching

Related Parent Applications (1)

Application Number Title Priority Date Filing Date
US13/965,739 Continuation US9779138B2 (en) 2013-08-13 2013-08-13 Methods and systems for autonomous memory searching

Publications (1)

Publication Number Publication Date
US20170351737A1 true US20170351737A1 (en) 2017-12-07

Family

ID=52467568

Family Applications (2)

Application Number Title Priority Date Filing Date
US13/965,739 Active 2034-05-31 US9779138B2 (en) 2013-08-13 2013-08-13 Methods and systems for autonomous memory searching
US15/685,950 Abandoned US20170351737A1 (en) 2013-08-13 2017-08-24 Methods and systems for autonomous memory searching

Family Applications Before (1)

Application Number Title Priority Date Filing Date
US13/965,739 Active 2034-05-31 US9779138B2 (en) 2013-08-13 2013-08-13 Methods and systems for autonomous memory searching

Country Status (7)

Country Link
US (2) US9779138B2 (en)
EP (1) EP3033701B1 (en)
JP (1) JP6211196B2 (en)
KR (2) KR101927677B1 (en)
CN (2) CN105612518B (en)
TW (2) TWI664541B (en)
WO (1) WO2015023625A1 (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20180067645A1 (en) * 2015-03-03 2018-03-08 Shanghai Chule (Coo Tek) Information Technology Co., Ltd. System and method for efficient text entry with touch screen
US10003675B2 (en) 2013-12-02 2018-06-19 Micron Technology, Inc. Packet processor receiving packets containing instructions, data, and starting location and generating packets containing instructions and data
US11586577B2 (en) 2009-09-11 2023-02-21 Micron Technology, Inc. Autonomous memory architecture

Families Citing this family (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10198350B2 (en) 2011-07-28 2019-02-05 Netlist, Inc. Memory module having volatile and non-volatile memory subsystems and method of operation
US10838646B2 (en) 2011-07-28 2020-11-17 Netlist, Inc. Method and apparatus for presearching stored data
US10380022B2 (en) 2011-07-28 2019-08-13 Netlist, Inc. Hybrid memory module and system and method of operating the same
US9779138B2 (en) 2013-08-13 2017-10-03 Micron Technology, Inc. Methods and systems for autonomous memory searching
US10248328B2 (en) 2013-11-07 2019-04-02 Netlist, Inc. Direct data move between DRAM and storage on a memory module
CN111176585A (en) 2013-11-07 2020-05-19 奈特力斯股份有限公司 Hybrid memory module and system and method for operating the same
US11182284B2 (en) 2013-11-07 2021-11-23 Netlist, Inc. Memory module having volatile and non-volatile memory subsystems and method of operation
US9633074B1 (en) * 2014-01-03 2017-04-25 Amazon Technologies, Inc. Querying data set tables in a non-transactional database
US9483346B2 (en) * 2014-08-07 2016-11-01 Pure Storage, Inc. Data rebuild on feedback from a queue in a non-volatile solid-state storage
US9927984B2 (en) * 2015-10-14 2018-03-27 Samsung Electronics Co., Ltd. Electronic system with interface control mechanism and method of operation thereof
KR20190023433A (en) * 2017-08-29 2019-03-08 에스케이하이닉스 주식회사 Memory system and operating method thereof
TWI664527B (en) * 2018-03-20 2019-07-01 慧榮科技股份有限公司 Method for performing initialization in a memory device, associated memory device and controller thereof, and associated electronic device
CN110765156A (en) * 2018-07-09 2020-02-07 慧荣科技股份有限公司 Linked list searching device and method
US10990323B2 (en) * 2019-05-28 2021-04-27 Silicon Motion, Inc. Flash memory controller, memory device and method for accessing flash memory module

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080077736A1 (en) * 2006-09-27 2008-03-27 Lsi Logic Corporation Method and apparatus of a RAID configuration module
US20120203761A1 (en) * 2011-02-08 2012-08-09 International Business Machines Corporation Pattern matching accelerator

Family Cites Families (44)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5134711A (en) 1988-05-13 1992-07-28 At&T Bell Laboratories Computer with intelligent memory system
GB8816413D0 (en) 1988-07-09 1988-08-17 Int Computers Ltd Data processing system
GB9023096D0 (en) 1990-10-24 1990-12-05 Int Computers Ltd Database search processor
US5671430A (en) 1993-06-30 1997-09-23 Gunzinger; Anton Parallel data processing system with communication apparatus control
CA2145106C (en) 1994-04-22 1999-08-24 Abhaya Asthana Intelligent memory-based input/output system
JP3289101B2 (en) * 1996-01-25 2002-06-04 東京エレクトロン株式会社 Method and apparatus for initializing flash disk system
KR100359414B1 (en) * 1996-01-25 2003-01-24 동경 엘렉트론 디바이스 주식회사 Data reading method and memory controlling apparatus
US5913217A (en) * 1997-06-30 1999-06-15 Microsoft Corporation Generating and compressing universally unique identifiers (UUIDs) using counter having high-order bit to low-order bit
US6105130A (en) 1997-12-23 2000-08-15 Adaptec, Inc. Method for selectively booting from a desired peripheral device
US6751606B1 (en) * 1998-12-23 2004-06-15 Microsoft Corporation System for enhancing a query interface
US7328277B2 (en) 2000-03-03 2008-02-05 Enterasys Networks, Inc. High-speed data processing using internal processor memory space
US6516380B2 (en) * 2001-02-05 2003-02-04 International Business Machines Corporation System and method for a log-based non-volatile write cache in a storage controller
US7581080B2 (en) 2003-04-23 2009-08-25 Micron Technology, Inc. Method for manipulating data in a group of processing elements according to locally maintained counts
GB2406399A (en) * 2003-09-23 2005-03-30 Ibm Seaching within a computer network by entering a search term and optional URI into a web browser
US7243200B2 (en) 2004-07-15 2007-07-10 International Business Machines Corporation Establishing command order in an out of order DMA command queue
US7242216B1 (en) 2004-11-08 2007-07-10 Herman Schmit Embedding memory between tile arrangement of a configurable IC
US7634622B1 (en) 2005-06-14 2009-12-15 Consentry Networks, Inc. Packet processor that generates packet-start offsets to immediately store incoming streamed packets using parallel, staggered round-robin arbitration to interleaved banks of memory
US20070165457A1 (en) 2005-09-30 2007-07-19 Jin-Ki Kim Nonvolatile memory system
DE102006009027A1 (en) 2006-02-27 2007-08-30 Infineon Technologies Ag Memory arrangement comprises interface, two memory banks with one memory cell, and two memory bank access devices, intermediate storage devices are provided for intermediate saving of data
TW200743991A (en) * 2006-05-18 2007-12-01 Realtek Semiconductor Corp Data search method and apparatus thereof
US7941579B2 (en) 2006-06-30 2011-05-10 Brother Kogyo Kabushiki Kaisha Communication system for authenticating authority of host device for accessing storage medium set to periphery device
US8285707B2 (en) * 2006-11-08 2012-10-09 International Business Machines Corporation Method of querying relational database management systems
US9141670B2 (en) 2007-08-27 2015-09-22 Teradata Us, Inc. Methods and systems for hardware acceleration of streamed database operations and queries based on multiple hardware accelerators
US7895151B2 (en) 2008-06-23 2011-02-22 Teradata Us, Inc. Fast bulk loading and incremental loading of data into a database
US7623365B2 (en) 2007-08-29 2009-11-24 Micron Technology, Inc. Memory device interface methods, apparatus, and systems
US7913033B2 (en) 2007-10-09 2011-03-22 Micron Technology, Inc. Non-volatile memory device having assignable network identification
TWI346289B (en) 2007-12-19 2011-08-01 Ralink Technology Corp Peripheral complying with sdio standard and method for managing sdio command
US8493979B2 (en) 2008-12-30 2013-07-23 Intel Corporation Single instruction processing of network packets
US8549092B2 (en) 2009-02-19 2013-10-01 Micron Technology, Inc. Memory network methods, apparatus, and systems
TWI406130B (en) * 2009-03-10 2013-08-21 Phison Electronics Corp Data processing system, controller, and method thereof for searching specific memory area
US8427952B1 (en) 2009-03-24 2013-04-23 Packet Plus, Inc. Microcode engine for packet processing
US9779057B2 (en) 2009-09-11 2017-10-03 Micron Technology, Inc. Autonomous memory architecture
US9792307B2 (en) * 2010-07-27 2017-10-17 Oracle International Corporation Enterprise-based searching of new and updated data
US8930618B2 (en) 2010-08-24 2015-01-06 Futurewei Technologies, Inc. Smart memory
US10026458B2 (en) 2010-10-21 2018-07-17 Micron Technology, Inc. Memories and methods for performing vector atomic memory operations with mask control and variable data length and data unit size
JP2012159903A (en) * 2011-01-31 2012-08-23 Fujitsu Semiconductor Ltd Data processing system, data-processing device and data processing method
KR101306622B1 (en) 2011-06-22 2013-09-11 주식회사 에이디칩스 instructin queue control apparatus
JP2013045378A (en) 2011-08-26 2013-03-04 Fujitsu Ltd Storage control method, information processing device and program
US8775685B1 (en) 2011-10-13 2014-07-08 Xilinx, Inc. Parallel processing of network packets
US20130173655A1 (en) * 2012-01-04 2013-07-04 International Business Machines Corporation Selective fetching of search results
US9424202B2 (en) * 2012-11-19 2016-08-23 Smartfocus Holdings Limited Database search facility
US10089043B2 (en) 2013-03-15 2018-10-02 Micron Technology, Inc. Apparatus and methods for a distributed memory system including memory nodes
US9779138B2 (en) 2013-08-13 2017-10-03 Micron Technology, Inc. Methods and systems for autonomous memory searching
US10003675B2 (en) 2013-12-02 2018-06-19 Micron Technology, Inc. Packet processor receiving packets containing instructions, data, and starting location and generating packets containing instructions and data

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20080077736A1 (en) * 2006-09-27 2008-03-27 Lsi Logic Corporation Method and apparatus of a RAID configuration module
US20120203761A1 (en) * 2011-02-08 2012-08-09 International Business Machines Corporation Pattern matching accelerator

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US11586577B2 (en) 2009-09-11 2023-02-21 Micron Technology, Inc. Autonomous memory architecture
US10003675B2 (en) 2013-12-02 2018-06-19 Micron Technology, Inc. Packet processor receiving packets containing instructions, data, and starting location and generating packets containing instructions and data
US10778815B2 (en) 2013-12-02 2020-09-15 Micron Technology, Inc. Methods and systems for parsing and executing instructions to retrieve data using autonomous memory
US20180067645A1 (en) * 2015-03-03 2018-03-08 Shanghai Chule (Coo Tek) Information Technology Co., Ltd. System and method for efficient text entry with touch screen

Also Published As

Publication number Publication date
JP2016536694A (en) 2016-11-24
KR20180067729A (en) 2018-06-20
CN111221848A (en) 2020-06-02
TW201518968A (en) 2015-05-16
CN105612518A (en) 2016-05-25
US20150052114A1 (en) 2015-02-19
WO2015023625A1 (en) 2015-02-19
KR20160042122A (en) 2016-04-18
US9779138B2 (en) 2017-10-03
CN105612518B (en) 2020-01-14
KR101927677B1 (en) 2018-12-10
KR101868850B1 (en) 2018-06-19
TWI610187B (en) 2018-01-01
TW201810088A (en) 2018-03-16
EP3033701A4 (en) 2017-04-05
EP3033701B1 (en) 2020-05-27
EP3033701A1 (en) 2016-06-22
TWI664541B (en) 2019-07-01
JP6211196B2 (en) 2017-10-11

Similar Documents

Publication Publication Date Title
US20170351737A1 (en) Methods and systems for autonomous memory searching
US9846642B2 (en) Efficient key collision handling
US8819335B1 (en) System and method for executing map-reduce tasks in a storage device
US9886464B2 (en) Versioned bloom filter
JP2016536694A5 (en)
US10515078B2 (en) Database management apparatus, database management method, and storage medium
WO2016117022A1 (en) Log management method and computer system
US20220129464A1 (en) Re-ordered processing of read requests
US20170177653A1 (en) Computer system, method for inspecting data, and computer
US11797506B2 (en) Database management systems for managing data with data confidence
US20160170892A1 (en) Expression pattern matching in a storage subsystem
US10154113B2 (en) Computer system
EP3293643B1 (en) Paging mechanism for in-memory data management system
JPWO2015141219A1 (en) Storage system, control device, data access method and program
US20180074970A1 (en) Cache-Efficient Fragmentation of Data Structures
WO2018083751A1 (en) Intelligent storage subsystem

Legal Events

Date Code Title Description
AS Assignment

Owner name: U.S. BANK NATIONAL ASSOCIATION, AS COLLATERAL AGENT, MINNESOTA

Free format text: SUPPLEMENT NO. 6 TO PATENT SECURITY AGREEMENT;ASSIGNOR:MICRON TECHNOLOGY, INC.;REEL/FRAME:044348/0253

Effective date: 20171023

Owner name: MORGAN STANLEY SENIOR FUNDING, INC., AS COLLATERAL AGENT, MARYLAND

Free format text: SUPPLEMENT NO. 6 TO PATENT SECURITY AGREEMENT;ASSIGNOR:MICRON TECHNOLOGY, INC.;REEL/FRAME:044653/0333

Effective date: 20171023

Owner name: U.S. BANK NATIONAL ASSOCIATION, AS COLLATERAL AGEN

Free format text: SUPPLEMENT NO. 6 TO PATENT SECURITY AGREEMENT;ASSIGNOR:MICRON TECHNOLOGY, INC.;REEL/FRAME:044348/0253

Effective date: 20171023

Owner name: MORGAN STANLEY SENIOR FUNDING, INC., AS COLLATERAL

Free format text: SUPPLEMENT NO. 6 TO PATENT SECURITY AGREEMENT;ASSIGNOR:MICRON TECHNOLOGY, INC.;REEL/FRAME:044653/0333

Effective date: 20171023

STPP Information on status: patent application and granting procedure in general

Free format text: DOCKETED NEW CASE - READY FOR EXAMINATION

AS Assignment

Owner name: JPMORGAN CHASE BANK, N.A., AS COLLATERAL AGENT, ILLINOIS

Free format text: SECURITY INTEREST;ASSIGNORS:MICRON TECHNOLOGY, INC.;MICRON SEMICONDUCTOR PRODUCTS, INC.;REEL/FRAME:047540/0001

Effective date: 20180703

Owner name: JPMORGAN CHASE BANK, N.A., AS COLLATERAL AGENT, IL

Free format text: SECURITY INTEREST;ASSIGNORS:MICRON TECHNOLOGY, INC.;MICRON SEMICONDUCTOR PRODUCTS, INC.;REEL/FRAME:047540/0001

Effective date: 20180703

AS Assignment

Owner name: MICRON TECHNOLOGY, INC., IDAHO

Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:U.S. BANK NATIONAL ASSOCIATION, AS AGENT;REEL/FRAME:046597/0333

Effective date: 20180629

AS Assignment

Owner name: MICRON TECHNOLOGY, INC., CALIFORNIA

Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:MORGAN STANLEY SENIOR FUNDING, INC., AS COLLATERAL AGENT;REEL/FRAME:050709/0838

Effective date: 20190731

AS Assignment

Owner name: MICRON TECHNOLOGY, INC., IDAHO

Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:JPMORGAN CHASE BANK, N.A., AS COLLATERAL AGENT;REEL/FRAME:051028/0001

Effective date: 20190731

Owner name: MICRON SEMICONDUCTOR PRODUCTS, INC., IDAHO

Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:JPMORGAN CHASE BANK, N.A., AS COLLATERAL AGENT;REEL/FRAME:051028/0001

Effective date: 20190731

STPP Information on status: patent application and granting procedure in general

Free format text: NON FINAL ACTION MAILED

STPP Information on status: patent application and granting procedure in general

Free format text: NON FINAL ACTION MAILED

STPP Information on status: patent application and granting procedure in general

Free format text: RESPONSE TO NON-FINAL OFFICE ACTION ENTERED AND FORWARDED TO EXAMINER

STPP Information on status: patent application and granting procedure in general

Free format text: FINAL REJECTION MAILED

STCB Information on status: application discontinuation

Free format text: ABANDONED -- FAILURE TO RESPOND TO AN OFFICE ACTION