Pluggable storage system for distributed file systems

Abstract

A method, article of manufacture, and apparatus for managing data. In some embodiments, this includes an initial instruction for a file stored in a first storage system, determining that the initial instruction is not supported by the first storage system, identifying a combination of instructions to the first storage system after determining that the initial instruction is not supported by the first storage system, wherein the combination of instructions is based on the initial instruction, performing the identified combination of instructions on the file stored in the first storage system, and storing results of the performed identified combination of instructions.

Description

FIELD OF THE INVENTION

This invention relates generally to databases, and more particularly to systems and methods for managing datasets in databases.

BACKGROUND OF THE INVENTION

With the large amounts of data generated in recent years, data mining and machine learning are playing an increasingly important role in today's computing environment. For example, businesses may utilize either data mining or machine learning to predict the behavior of users. This predicted behavior may then be used by businesses to determine which plan to proceed with, or how to grow the business.

The data used in data mining and analytics is typically not stored in a uniform data storage system. Many data storage systems utilize different file systems, and those different file systems are typically not compatible with each other. Further, the data may reside in geographically diverse locations.

One conventional method to performing data analytics across different databases includes copying data from one database to a central database, and performing the data analytics on the central database. However, this results in an inefficient use of storage space, and creates issues with data consistency between the two databases.

There is a need, therefore, for an improved method, article of manufacture, and apparatus for managing data.

BRIEF DESCRIPTION OF THE DRAWINGS

The present invention will be readily understood by the following detailed description in conjunction with the accompanying drawings, wherein like reference numerals designate like structural elements, and in which:

FIG. 1 illustrates a database system in accordance with some embodiments.

FIG. 2 is a flowchart of a method to manage data in accordance with some embodiments.

DETAILED DESCRIPTION

A detailed description of one or more embodiments of the invention is provided below along with accompanying figures that illustrate the principles of the invention. While the invention is described in conjunction with such embodiment(s), it should be understood that the invention is not limited to any one embodiment. On the contrary, the scope of the invention is limited only by the claims and the invention encompasses numerous alternatives, modifications, and equivalents. For the purpose of example, numerous specific details are set forth in the following description in order to provide a thorough understanding of the present invention. These details are provided for the purpose of example, and the present invention may be practiced according to the claims without some or all of these specific details. For the purpose of clarity, technical material that is known in the technical fields related to the invention has not been described in detail so that the present invention is not unnecessarily obscured.

It should be appreciated that the present invention can be implemented in numerous ways, including as a process, an apparatus, a system, a device, a method, or a computer readable medium such as a computer readable storage medium or a computer network wherein computer program instructions are sent over optical or electronic communication links. Applications may take the form of software executing on a general purpose computer or be hardwired or hard coded in hardware. In this specification, these implementations, or any other form that the invention may take, may be referred to as techniques. In general, the order of the steps of disclosed processes may be altered within the scope of the invention.

An embodiment of the invention will be described with reference to a data storage system in the form of a storage system configured to store files, but it should be understood that the principles of the invention are not limited to this configuration. Rather, they are applicable to any system capable of storing and handling various types of objects, in analog, digital, or other form. Although terms such as document, file, object, etc. may be used by way of example, the principles of the invention are not limited to any particular form of representing and storing data or other information; rather, they are equally applicable to any object capable of representing information.

FIG. 1 illustrates a database system in accordance with some embodiments. Primary Master 102 accepts queries, plans queries, and dispatches queries to Segments 106 for execution. Primary Master 102 also collects results from Segments 106. Segments 106 are each a compute unit of the database system. Rack 108 can store multiple segments as hosts (hosts not shown in FIG. 1). Standby Master 100 is a warm backup of the primary host. Primary Master 102 and Standby Master 100 communicate to Rack 108 via the network connection. The tables of the database system are stored in Storage Nodes 112. Access, including read and write, are done through Storage Abstraction Layer 110. Primary Master 102, in some embodiments, may include a meta store (not shown in FIG. 1).

The meta store includes information about the different files systems in Storage Nodes 112, such as API information of the file system's interface, and different attributes and metadata of the file system. The meta store also includes information on the binary location of the Storage Abstraction Layer 110. As new file systems are added to the database system, the new file systems are registered (e.g. provided API information, other attributes, etc.) with the meta store. Once the new file systems are added, instances of that file system may be created to store data objects, such as databases and tables.

The storage nodes may be different file systems. For example, one storage node may be Hadoop File System (HDFS), while another storage node may be NFS. Having multiple file systems presents some challenges. One challenge is that file systems do not support all the same commands. The Storage Abstraction Layer helps address this challenge.

In some embodiments, the Storage Abstraction Layer selects a file system instance. A file system instance means a physical storage system for a specific file system. As discussed above, there may be several different file systems, and several different instances. The instances may be of the same file system, or they may be of different file systems. Different file systems may have different semantics or different performance characteristics. For example, some file systems allow you to update data, while other file systems only let you append data. The Storage Abstraction Layer chooses a file system based on the file system's attributes.

For example, in some embodiments, if a user wanted to modify or update a file that is stored on an underlying storage system which does not support file modification, the Storage Abstraction Layer may recognize the update command and move the file from the underlying storage system to another which does support file modification. The move may be temporary (e.g. move the file back after the user is finished with the file), or the move may be permanent.

In some embodiments, the Storage Abstraction Layer may choose to store a data object in a file system that does not allow updating. This may be preferable in cases where the data object is only read and never modified, and the file system is efficient for retrieving data. Thus, the Storage Abstraction Layer may take into account the usage statistics of the data object to determine what file system to use to store the data.

In some embodiments, the Storage Abstraction Layer may perform semantic adaptation. This may be preferable when the underlying file system may not be able to communicate directly with segments. This may occur when the interface the Storage Abstraction Layer exposes to the segment execution engine does not match with the semantics of the underlying file system. Other examples include instances where the functionality required by the segments is not supported by the underlying file system.

For example, a user may wish to truncate a file. However, the file may be stored on a segment where the underlying storage does not allow truncating files. The user is not aware of this because the user is not aware of where the files are physically stored. Typically, without a Storage Abstraction Layer, the underlying file system would not be able to understand the truncate command.

One example of semantic adaption includes adapting the truncate command. Suppose that a segment requires a piece of data to be truncated. However, the underlying file system does not support the truncate functionality. The Storage Abstraction Layer may be able to put various commands together to mimic a truncate command. Since the Storage Abstraction Layer has access to the metadata of the file system stored in the meta store, it knows what commands are allowed in the file system, as well as how to access the file system via APIs. Suppose that the file to be truncated is File A, and File A consists of 20 bytes. The segment wants the last 10 bytes to be deleted. With this requirement, the Storage Abstraction Layer may employ semantic adaptation to complete the truncation even when the underlying file system does not support a truncate command. In some embodiments, the Storage Abstraction Layer may first copy the first 10 bytes of File A to a temporary file, called File B. Then, the original File A is deleted, leaving only the temporary File B. After the original File A is deleted, the temporary File B is renamed to File A. File A is now only half of the original File A. In other words, File A has been truncated, even though the underlying file system did not support truncation. The Storage Abstraction Layer, by understanding how to access the underlying file system via the meta store, sent a series of commands to mimic a truncate. This series of commands may be stored in the meta store so that future truncate requests may make use of it.

Another example of semantic adaption includes a file update command. As mentioned above, some file systems do not allow for updating a file. Suppose a segment required that a file be updated. However, the file is stored in a file system that does not allow files to be updated. In some embodiments, the Storage Abstraction Layer may record the modifications in separate file as a new version. For example, if File A was to be modified, the separate file may be called File A_ver2. The segment (or user) will see that changes are being made to File A, but in fact, File A remains unchanged and the changes are being stored in File A_ver2. After the segment is finished modifying or updating the file, there may be two files stored—one is File A, and the other is File A_ver2. When subsequent users want to access File A, the Storage Abstraction Layer may cause the two files to be merged. With File A merged with File A_ver2 and called File A, the new File A will include all the changes made by the previous user. In other words, File A has been modified, even though the underlying file system did not support updating.

With the Storage Abstraction Layer, many different file systems may be supported. New and different storage systems with different file systems may be “plugged” into the database, without affecting the ability for the database to run its queries or jobs, as long as the meta store is updated with information about the new file system, such as its APIs.

FIG. 2 illustrates a method to manage data in accordance with some embodiments. In step 200, an initial instruction for a file stored in a first storage system is received. In step 202, it is determined that the initial instruction is not supported by the first storage system. In step 204, a combination of instructions to the first storage system is identified after determining that the initial instruction is not supported by the first storage system, wherein the combination of instructions is based on the initial instruction. In step 206, the identified combination of instructions is performed on the file stored in the first storage system. In step 208, results of the performed identified combination of instructions are stored.

For the sake of clarity, the processes and methods herein have been illustrated with a specific flow, but it should be understood that other sequences may be possible and that some may be performed in parallel, without departing from the spirit of the invention. Further, though the techniques herein teach creating one SwR sample in parallel, those with ordinary skill in the art will readily appreciate that the techniques are easily extendable to generate many SwR samples. Additionally, steps may be subdivided or combined. As disclosed herein, software written in accordance with the present invention may be stored in some form of computer-readable medium, such as memory or CD-ROM, or transmitted over a network, and executed by a processor.

All references cited herein are intended to be incorporated by reference. Although the present invention has been described above in terms of specific embodiments, it is anticipated that alterations and modifications to this invention will no doubt become apparent to those skilled in the art and may be practiced within the scope and equivalents of the appended claims. More than one computer may be used, such as by using multiple computers in a parallel or load-sharing arrangement or distributing tasks across multiple computers such that, as a whole, they perform the functions of the components identified herein; i.e. they take the place of a single computer. Various functions described above may be performed by a single process or groups of processes, on a single computer or distributed over several computers. Processes may invoke other processes to handle certain tasks. A single storage device may be used, or several may be used to take the place of a single storage device. The disclosed embodiments are illustrative and not restrictive, and the invention is not to be limited to the details given herein. There are many alternative ways of implementing the invention. It is therefore intended that the disclosure and following claims be interpreted as covering all such alterations and modifications as fall within the true spirit and scope of the invention.

Claims

1. A method for managing data, comprising: receiving, by an interfacing module between a segment execution engine and a first storage system, an initial instruction for a file stored in the first storage system;determining, by the interfacing module, that the initial instruction is not supported by the first storage system;identifying, by the interfacing module, a combination of instructions to the first storage system after determining that the initial instruction is not supported by the first storage system, wherein the combination of instructions is based on the initial instruction;performing the identified combination of instructions on the file stored in the first storage system; andstoring results of the performed identified combination of instructions.

2. The method of claim 1, wherein the combination of instructions is determined based at least in part on metadata associated with the first storage system, and the metadata associated with the first storage system is stored in a meta store that includes information respectively associated with one or more storage systems.

3. The method of claim 1, wherein the combination of instructions is determined based at least in part on metadata associated with the first storage system, and the metadata associated with the first storage system indicates a mechanism for accessing a file system corresponding to the first storage system.

4. The method of claim 1, wherein the combination of instructions comprise one or more instructions that are determined based at least in part on metadata associated with the first storage system.

5. The method of claim 1, wherein the combination of instructions comprise one or more instructions that are determined based at least in part on the initial instruction.

6. The method of claim 1, further comprising: selecting a second storage system to which the file is to be moved;storing the file on the second storage system; andperforming a series of actions in connection with carrying out the collective result.

7. The method of claim 6, wherein the combination of instructions comprise one or more instructions, the one or more instructions include one or more of the selecting of the second storage system, the storing of the file on the second storage system, and the performing of the series of actions in connection with carrying out the collective result.

8. The method of claim 6, wherein the second storage system is selected based at least in part on the second storage system having a second file system.

9. The method of claim 6, further comprising: in response to performing the series of actions, moving the file to the first storage system.

10. The method of claim 1, wherein the initial instruction includes a truncate instruction.

11. The method of claim 10, wherein the combination of instructions comprise one or more instructions, the one or more instructions include copy a first portion of the file, delete the file, and rename the first portion of the file.

12. The method of claim 1, wherein the initial instruction includes an update instruction.

13. A system for managing data, comprising a storage device and at least one processor configured to: receive, by an interfacing module between a segment execution engine and a first storage system, an initial instruction associated with performing a first action in relation to a file stored in the first storage system, wherein the file is stored in the first storage system based at least in part on file system functionality associated with a first file system associated with the first storage system and one or more usage statistics associated with the file;determine, by the interfacing module, that the initial instruction associated with performing the first action is not supported by the first storage system based at least in part on metadata associated with the first storage system;in response to determining that the initial instruction associated with performing the first action is not supported by the first storage system, identify, by the interfacing module, one or more instructions that have a collective result that is equivalent to a result of the first action, wherein to identify the combination of instructions includes to store an update in a second file and merging the second file with the file after the update is complete;perform the identified one or more instructions in connection with the file stored in the first storage system; andstore results of the performed identified one or more instructions.

14. The system of claim 13, wherein the combination of instructions is determined based at least in part on metadata associated with the first storage system, and the metadata associated with the first storage system is stored in a meta store that includes information respectively associated with one or more storage systems.

15. The system of claim 13, wherein the combination of instructions is determined based at least in part on metadata associated with the first storage system, and the metadata associated with the first storage system indicates a mechanism for accessing a file system corresponding to the first storage system.

16. The system of claim 13, wherein the combination of instructions comprise one or more instructions that are determined based at least in part on metadata associated with the first storage system.

17. The system of claim 13, wherein the combination of instructions comprise one or more instructions that are determined based at least in part on the initial instruction.

18. The system of claim 13, wherein the at least one processor is further configured to: select a second storage system to which the file is to be moved;store the file on the second storage system; andperform a series of actions in connection with carrying out the collective result.

19. The system of claim 18, wherein the combination of instructions comprise one or more instructions that cause the processor to perform one or more of the selecting of the second storage system, the storing of the file on the second storage system, and the performing of the series of actions in connection with carrying out the collective result.

20. A computer program product for processing data, comprising a non-transitory computer readable medium having program instructions embodied therein for: receiving, by an interfacing module between a segment execution engine and a first storage system, an initial instruction associated with performing a first action in relation to a file stored in a first storage system, wherein the file is stored in the first storage system based at least in part on file system functionality associated with a first file system associated with the first storage system and one or more usage statistics associated with the file;determining, by the interfacing module, that the initial instruction associated with performing the first action is not supported by the first storage system based at least in part on metadata associated with the first storage system;in response to determining that the initial instruction associated with performing the first action is not supported by the first storage system, identifying, by the interfacing module, one or more instructions that have a collective result that is equivalent to a result of the first action, wherein the identifying of the combination of instructions includes storing an update in a second file and merging the second file with the file after the update is complete;performing the identified one or more instructions in connection with the file stored in the first storage system; andstoring results of the performed identified one or more instructions.