Patent Application
20140372389
The present invention relates to compressing and storing a plurality of data elements in a page format. More specifically, the invention relates to the manner in which the page format is organized, including indexing of the data elements, so that the stored data elements can be accessed.
Data compression is the process of transforming information from a first representation to a second representation, with the second representation being smaller than the first representation (also known as the original representation). Compressed data may be decompressed from which the original, or a close approximation to it, can be recovered. Compression and decompression processes are often referred to as encoding and decoding. Data compression has important applications in the areas of data storage and data transmission. Besides space savings, other parameters of concern include encoding and decoding speeds and workspace requirements, the ability to access and decode partial files, and error generation and propagation.
This invention comprises a method, system, and computer program product for compressing and storing data elements and accessing the stored elements.
A method and computer program product is provided for storing compressed data in a page format, and accessing the stored data elements. A page of column data is compressed and stored in a format having multiple arrays and a vector. More specifically, a first array in the page stores compressed data that has a first common characteristic and a second array in the page stores compressed data that has a second common characteristic. The first and second common characteristics are different. The stored data is indexed into a vector, with the index including a mapping of the data elements stored in the first and second arrays. Access to the stored data elements employs the vector to ascertain a corresponding offset and array in which the data is stored.
Other features and advantages of this invention will become apparent from the following detailed description of the presently preferred embodiment of the invention, taken in conjunction with the accompanying drawings.
BRIEF DESCRIPTION OF THE SEVERAL VIEWS OF THE DRAWINGS
The drawings referenced herein form a part of the specification. Features shown in the drawings are meant as illustrative of only some embodiments of the invention, and not of all embodiments of the invention unless otherwise explicitly indicated.
It will be readily understood that the components of the present invention, as generally described and illustrated in the Figures herein, may be arranged and designed in a wide variety of different configurations. Thus, the following detailed description of the embodiments of the apparatus, system, and method of the present invention, as presented in the Figures, is not intended to limit the scope of the invention, as claimed, but is merely representative of selected embodiments of the invention.
Reference throughout this specification to “a select embodiment,” “one embodiment,” or “an embodiment” means that a particular feature, structure, or characteristic described in connection with the embodiment is included in at least one embodiment of the present invention. Thus, appearances of the phrases “a select embodiment,” “in one embodiment,” or “in an embodiment” in various places throughout this specification are not necessarily referring to the same embodiment.
The illustrated embodiments of the invention will be best understood by reference to the drawings, wherein like parts are designated by like numerals throughout. The following description is intended only by way of example, and simply illustrates certain selected embodiments of devices, systems, and processes that are consistent with the invention as claimed herein.
Order preserving frequency-based dictionary compression is exploited to perform SQL operations on compressed values. In one embodiment, the compressed values are packed in a dense bit-aligned manner so that multiple values fit in a register and can be processed simultaneously via single-instruction multiple-data (SIMD).
Columns of a database table are partitioned into column groups. In one embodiment, each column belongs to exactly one column group. In a select embodiment, commonly referred to as a column store, each column group contains a single column. Column group data are stored in pages which may be of a fixed or variable. A projection of a row/tuple onto a column group is referred to as a tuplet. Tuples are stored in the same order across all column groups; tuples are identified by a virtual identifier referred to herein as a tuple sequence number (TSN), an integer that may be used to locate a given tuple. In one embodiment, a page contains a single range of TSNs.
In order to leverage the benefits of compression without the overhead of decompression, the data in each array (130) and (132) is binary-wise comparable for testing equality and range predicates. Each array holds data that is compressed with common characteristics, with the different arrays holding data with different characteristics. More specifically, the data in array (130) possesses a first characteristic and the data in the array (132) possesses a second characteristic, with the first and second characteristic being different. For example, data in the array (130) may represent all data for the page that is encoded with 2 bits per value, while data in the array (132) may represent all data encoded with 7 bits. Each array holds the maximum number of values that can fit in a processing unit register for that server. In one embodiment, encoded sizes that are not a power of two indicates that some number of bits in each array may be padded to fit the register's length. The special region (140) is a region employed to hold data that is variable length. The data in the special region (140), also referred to herein as a third array, is indexed via the tuple map (120). Each entry in the tuple map (120) is an index indicating in which array that TSN is located. Since the data in this region is not encoded to a fixed-length value, the data is not processed as fixed length arrays.
As values are placed on the page based on the encoded width, it is unlikely that they will appear on the page in the order of their arrival. In order to reconstruct the original sequence of the values, i.e. in order to find the Nth value on the page, a bit map is stored which indicates the identifier of the region in which the Nth value is located. For example, for a page containing three regions, two bits are required to indicate whether a value is located in the first, second, or third region of the page. The bit map is called the tuple map (120), also referred to herein as a vector, and is stored directly as a bit map or as a separate data bank packed to match the register width of the processing unit registers. More specifically, the tuple map (120) records to which region each tuple was assigned by the encoding. An index of the tuple map (120) is a page-relative TSN and each entry is the index of the region to which the TSN belongs. Data elements stored in the arrays (130) and (132) are indexed via the vector (120), which includes a mapping of the data elements stored in the arrays (130) and (132). For example, in an embodiment with a two region page, the tuple map entries are one bit each. Accordingly, by grouping like formatted tuplets together into arrays, long runs of tuplets that have the same format are formed. In one embodiment, the tuple map can be stored in bit-major order. For example, in a tuple map where entries are two bits each, the first bit of each entry can be stored as one bitmap, followed by a second bitmap holding the second bit of each entry.
The compressed pages are utilized for query processing, which includes accessing values of code from one or more banks of the region.
The density check is shown herein following the array identification. However, the density check may occur at a different step in the value and code access. For example, the density check may occur following the identification of relevant TSNs at step (202), or optionally following the partitioning of TSNs after page (204). In one embodiment, the density check is an approximation based on an estimation sample of a population of data. Similarly, in one embodiment, occupancy of less than 25% is considered sparse, although this value is not limiting. Accordingly, values and codes are accessed for each region, with an access technique selected based on the density check.
The results of the density check directly correlate with the process of accessing values or codes for each array Y and each page X (218). In a sparsely populated region, for each input TSN the array offset is identified and the value or code is accessed. In a densely populated region, the entire region is loaded and filtered. Regardless of the technique employs, a data element and position of the data element in one of the arrays is determined. In one embodiment, the machine word multiple at which the data element is stored within one of the arrays is computed, and a bit offset of the data element is calculated at the computed machine word multiple. Similarly, in one embodiment, the calculation at the machine word multiple includes multiplying a position of the data element by a pre-computed integer modular inverse of a quantity of data elements that fit within each machine word multiple, e.g. indicates the location of which machine word the code is located. The code access at step (218) includes accessing at least one data element at a specific position from one of the arrays. This includes identifying the array, accessing the data elements in the identified array, and placing the accessed data elements into a new array. In one embodiment, an arrangement of the placed data elements is word-aligned.
Following the access with the associated technique, the counting variable for the page arrays, Y, is incremented (220). It is then determined if all of the page arrays have been processed (222). A negative response to the determination at step (222) is followed by a return to step (216), and a positive response to the determination at step (222) is followed by an increment of the page counting variable, X, (224). It is then determined if all of the identified pages have been processed (226). A negative response to the determination at step (226) is followed by a return to step (210), and a positive response to the determination at step (226) concludes the value access and placement process from the compressed pages of data.
As demonstrated in
The processes shown in
The computer (510) includes a functional unit (550) having one or more tools (560) to support data encoding and access thereto. The tools (560) embedded in the functional unit (550) support the functionality of compression and storage of a page of column data as described in detail in
As identified above, the tools (560) are shown residing in the functional unit (550) of the computer (510). Although in one embodiment, the functional unit (550) and tools (560), respectively, may reside as hardware tools external to the memory (514). In another embodiment, the tools (560) may be implemented as a combination of hardware and software in the shared pool of resources. Similarly, in one embodiment, the tools (560) may be combined into a single functional item that incorporates the functionality of separate items. As shown herein, the tools (560) are shown local to one computer system (510). However, in one embodiment they may be collectively or individually distributed across a shared pool of configurable computer resources and function as a unit. Accordingly, the tools may be implemented as software tools, hardware tools, or a combination of software and hardware tools.
Furthermore, the described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments. One skilled in the relevant art will recognize, however, that the invention can be practiced without one or more of the specific details, or with other methods, components, materials, etc. In other instances, well-known structures, materials, or operations are not shown or described in detail to avoid obscuring aspects of the invention.
The tools (560) may be implemented in programmable hardware devices such as field programmable gate arrays, programmable array logic, programmable logic devices, or the like. The tools (560) may also be implemented in software for processing by various types of processors. An identified director or manager of executable code may, for instance, comprise one or more physical or logical blocks of computer instructions which may, for instance, be organized as an object, procedure, function, or other construct. Nevertheless, the executable of an identified director or manager need not be physically located together, but may comprise disparate instructions stored in different locations which, when joined logically together, comprise the managers and achieve the stated purpose of the director and managers.
Indeed, executable code could be a single instruction, or many instructions, and may even be distributed over several different code segments, among different applications, and across several memory devices. Similarly, operational data may be identified and illustrated herein within the tool, and may be embodied in any suitable form and organized within any suitable type of data structure. The operational data may be collected as a single data set, or may be distributed over different locations including over different storage devices, and may exist, at least partially, as electronic signals on a system or network.
Referring now to the block diagram of
The computer system can include a display interface (606) that forwards graphics, text, and other data from the communication infrastructure (604) (or from a frame buffer not shown) for display on a display unit (608). The computer system also includes a main memory (610), preferably random access memory (RAM), and may also include a secondary memory (612). The secondary memory (612) may include, for example, a hard disk drive (614), a solid state drive, and/or a removable storage drive (616), representing, for example, a floppy disk drive, a magnetic tape drive, or an optical disk drive. The removable storage drive (616) reads from and/or writes to a removable storage unit (618) in a manner well known to those having ordinary skill in the art. Removable storage unit (618) represents, for example, a floppy disk, a compact disc, a magnetic tape, or an optical disk, etc., which is read by and written to by removable storage drive (616). As will be appreciated, the removable storage unit (618) includes a computer readable medium having stored therein computer software and/or data.
In alternative embodiments, the secondary memory (612) may include other similar means for allowing computer programs or other instructions to be loaded into the computer system. Such means may include, for example, a removable storage unit (620) and an interface (622). Examples of such means may include a program package and package interface (such as that found in video game devices), a removable memory chip (such as an EPROM, or PROM) and associated socket, and other removable storage units (620) and interfaces (622) which allow software and data to be transferred from the removable storage unit (620) to the computer system.
The computer system may also include a communications interface (624). Communications interface (624) allows software and data to be transferred between the computer system and external devices. Examples of communications interface (624) may include a modem, a network interface (such as an Ethernet card), a communications port, or a PCMCIA slot and card, etc. Software and data transferred via communications interface (624) is in the form of signals which may be, for example, electronic, electromagnetic, optical, or other signals capable of being received by communications interface (624). These signals are provided to communications interface (624) via a communications path (i.e., channel) (626). This communications path (626) carries signals and may be implemented using wire or cable, fiber optics, a phone line, a cellular phone link, a radio frequency (RF) link, and/or other communication channels.
In this document, the terms “computer program medium,” “computer usable medium,” and “computer readable medium” are used to generally refer to media such as main memory (610) and secondary memory (612), removable storage drive (616), and a hard disk installed in hard disk drive (614).
Computer programs (also called computer control logic) are stored in main memory (610) and/or secondary memory (612). Computer programs may also be received via a communication interface (624). Such computer programs, when run, enable the computer system to perform the features of the present invention as discussed herein. In particular, the computer programs, when run, enable the processor (602) to perform the features of the computer system. Accordingly, such computer programs represent controllers of the computer system.
As will be appreciated by one skilled in the art, aspects of the present invention may be embodied as a system, method or computer program product. Accordingly, aspects of the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment (including firmware, resident software, micro-code, etc.) or an embodiment combining software and hardware aspects that may all generally be referred to herein as a “circuit,” “module” or “system.” Furthermore, aspects of the present invention may take the form of a computer program product embodied in one or more computer readable medium(s) having computer readable program code embodied thereon.
Any combination of one or more computer readable medium(s) may be utilized. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. More specific examples (a non-exhaustive list) of the computer readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a solid state drive, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or Flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
A computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.
Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Computer program code for carrying out operations for aspects of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, Smalltalk, C++ or the like and conventional procedural programming languages, such as the “C” programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the latter scenario, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or the connection may be made to an external computer (for example, through the Internet using an Internet Service Provider).
Aspects of the present invention are described above with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and/or block diagrams, and combinations of blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions/acts specified in the flowchart and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer readable medium that can direct a computer, other programmable data processing apparatus, or other devices to function in a particular manner, such that the instructions stored in the computer readable medium produce an article of manufacture including instructions which implement the function/act specified in the flowchart and/or block diagram block or blocks.
The computer program instructions may also be loaded onto a computer, other programmable data processing apparatus, or other devices to cause a series of operational steps to be performed on the computer, other programmable apparatus or other devices to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide processes for implementing the functions/acts specified in the flowchart and/or block diagram block or blocks.
The flowcharts and block diagrams in the Figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowcharts or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems that perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. As used herein, the singular forms “a”, “an” and “the” are intended to include the plural forms as well, unless the context clearly indicates otherwise. It will be further understood that the terms “comprises” and/or “comprising,” when used in this specification, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.
The corresponding structures, materials, acts, and equivalents of all means or step plus function elements in the claims below are intended to include any structure, material, or act for performing the function in combination with other claimed elements as specifically claimed. The description of the present invention has been presented for purposes of illustration and description, but is not intended to be exhaustive or limited to the invention in the form disclosed. Many modifications and variations will be apparent to those of ordinary skill in the art without departing from the scope and spirit of the invention. The embodiment was chosen and described in order to best explain the principles of the invention and the practical application, and to enable others of ordinary skill in the art to understand the invention for various embodiments with various modifications as are suited to the particular use contemplated. Accordingly, the code stream compression supports flexibility with respect to decompression, including, decompression of the code stream from an arbitrary position therein, with the decompression being a recursive process to the underlying literal of a referenced phrase.
It will be appreciated that, although specific embodiments of the invention have been described herein for purposes of illustration, various modifications may be made without departing from the spirit and scope of the invention. Accordingly, the scope of protection of this invention is limited only by the following claims and their equivalents.
