Patent us20110208784 – database partitioning by virtual partitions – google patentsuche

In some embodiments, the data records include primary and secondary data records. Data recovery wd passport A primary data record is a data record that is not dependent on another data record; the primary data record is typically the first data record of a set of related data records to be produced or stored, and thus is the first data record of the set to be assigned a location in the database. Relational database management system A secondary or subsidiary data record is a data record that is dependent on or refers to, and is associated with a primary data record.


Database generator The secondary data record refers to a primary data record and is associated with that primary data record. Database 3nf example For example, in an exemplary database of customer data and transactions by customers, a customer data record is a primary data record. Data recovery hard drive software A customer data record is independent of other customer records and is not associated with or dependent on other data records. Iphone 4 data recovery On the other hand, transaction records are secondary data records, wherein each transaction record is associated with a particular customer, namely the particular customer that engaged in the transaction.

The tables 304, 306, 308 and the last record identifier table 310 are all partitioned into virtual partitions. Database logo More particularly, the data records in the 304, 306, 308 and the last record identifier table 310 are assigned to virtual partitions, and thus the tables are partitioned based on the assignment of the data records to the virtual partitions. Moto g data recovery Table partitions 304- 1, 306- 1, 308- 1 assigned to virtual partitions 0 thru i, i.e. Database analyst salary data records in the tables 304, 306, 308 that are assigned to virtual partitions 0 thru i, are stored in physical database DB- 0 ( 302- 1). Data recovery engineer Table partitions 304- 2, 306- 2, 308- 2 assigned to virtual partitions i+1 thru j, i.e., data records in the tables 304, 306, 308 that are assigned to virtual partitions i+1 thru j, are stored in physical database DB- 1 ( 302- 2). Gt m database Table partitions 304- 3, 306- 3, 308- 3 assigned to virtual partitions k+1 thru m, i.e., data records in the tables 304, 306, 308 that are assigned to virtual partitions k+1 thru m, are stored in physical database DB-(N−1) ( 302- 3).

Additional physical databases are created within the database and the database is divided amongst the increased number of physical databases ( 410). In databases information is organized in Whenever the database grows sufficiently large, additional physical databases may be created and the data records of the database are divided amongst the existing and new physical databases; the database is divided into more and more physical databases as it grows. Data recovery tools iphone The virtual partitions are remapped to the post-division physical databases ( 406) and the data records are stored in accordance with the updated virtual partition-physical database mappings ( 408). A database driver is software that lets the As the database grows further, further divisions may be performed ( 410), the virtual partitions are remapped ( 406), and the data records are stored in the physical databases in accordance with the updated mappings ( 408). 7 data recovery suite key The process of dividing the database into physical databases, mapping virtual partitions to physical databases, and storing the data records continues up to when there is a one-to-one correspondence between virtual partitions and physical databases, i.e., there is exactly one virtual partition mapped to each physical database and each physical database is mapped to a different virtual partition, and the data records are stored in accordance with the one-to-one correspondence. Data recovery linux However, in some embodiments, the total number of virtual partitions may be increased, further details of which are described below in relation to FIG. Database modeling tools 6.

FIG. G info database search 5 is a flow diagram illustrating a process 500 for assigning data records to virtual partitions in accordance with some embodiments. Database administrator salary The process for assigning a data record to a virtual partition differs slightly depending on whether the data record is a primary or secondary data record. Database triggers If the data record is a primary data record ( 502—Primary), the data record is assigned to a virtual partition ( 504). Data recovery recuva In some embodiments, the assignment of a virtual partition is performed in a round-robin order. Data recovery texas For example, if there are 3 virtual partitions, data records are assigned one at a time to the virtual partitions as they are inserted into the database, first to the first partition, then to the second partition, then to the third partition, then back to the first partition again, and so forth. Database resume In some other embodiments, the data record is assigned a virtual partition randomly or pseudo-randomly. Data recovery external hard drive mac In yet other embodiments, the data records are assigned to virtual partitions in accordance with a load balancing strategy, with new primary data records being assigned to virtual partitions having the lowest loads.

The record identifier 600 also includes a segment of buffer bits 604. Database management systems In some embodiments, the buffer bits are 20 bits long in a 64-bit record identifier; the buffer bits are the remaining bits after the 12-bit virtual partition identifier and the 32-bit sequential identifier are subtracted from the 64-bit record identifier. 7 data recovery review The number of virtual partitions may be increased by taking bits from the buffer bits 604 that are adjacent to the virtual partition identifier segment 602 and incorporating them into the virtual partition identifier segment 602. Mode s database In other words, the virtual partition identifier segment is expanded at the expense of the buffer bits. Windows 8 data recovery This increases the number of available virtual partitions. Java 8 database Similarly, the size of virtual partitions may be increased by taking bits from the buffer bits 604 that are adjacent to the sequential identifier segment 606 and incorporating them into the sequential identifier segment 606. Database tools In other words, the sequential identifier segment is expanded at the expense of the buffer bits. Drupal 7 database api In some embodiments, the buffer bits of each record identifier are set to 0. Raid 6 data recovery Only when buffer bits are reassigned to the virtual partition identifier 602 or the sequential identifier 606 are these bits assigned values other than zero.

FIG. Database architecture 9 illustrates a physical database computer 900 in accordance with some embodiments. Iphone 4 data recovery software The physical database computer 900 may correspond to one of the physical databases 110 shown in FIG. Database java 1, and typically includes one or more processing units or CPU’s 902, one or more network or other communications interfaces 904, memory 906, and one or more communication buses 908 for interconnecting these components. Data recovery android The communication buses 908 may include circuitry (sometimes called a chipset) that interconnects and controls communications between system components. C database tutorial The physical database computer 900 optionally may include a user interface comprising a display device and a keyboard (not shown). Data recovery services cost Memory 906 (which may comprise or include a computer readable storage medium) includes random access memory, such as DRAM, SRAM, DDR RAM or other random access solid state memory devices; and may include non-volatile memory, such as one or more magnetic disk storage devices, optical disk storage devices, flash memory devices, or other non-volatile solid state storage devices. Data recovery professional Memory 906 may optionally include one or more storage devices remotely located from the CPU(s) 902. Data recovery images In some embodiments, memory 906 stores the following programs, modules and data structures, or a subset thereof:

• a network communication module 912 that is used for connecting the physical database computer 900 to other computers via the one or more communication network interfaces 904 (wired or wireless), such as the Internet, other wide area networks, local area networks, metropolitan area networks, and so on;

• a last data record table 916 for storing next available sequential identifier values (or last used sequential identifier values) for those table-virtual partitions that are stored in the physical database services by this computer 900; the last data record table 916 is partitioned in accordance with the same virtual partitions that are used to partition the data tables in the database.

FIG. Database management system 10 illustrates a server computer 1000 in accordance with some embodiments. Sony xperia z data recovery The server computer 1000 may correspond to one of the servers 108 shown in FIG. Note 3 data recovery 1, and typically includes one or more processing units or CPU’s 1002, one or more network or other communications interfaces 1004, memory 1006, and one or more communication buses 1008 for interconnecting these components. Database image The communication buses 1008 may include circuitry (sometimes called a chipset) that interconnects and controls communications between system components. S note data recovery The server computer 1000 optionally may include a user interface comprising a display device and a keyboard (not shown). Database 4d Memory 1006 (which may comprise or include a computer readable storage medium) includes random access memory, such as DRAM, SRAM, DDR RAM or other random access solid state memory devices; and may include non-volatile memory, such as one or more magnetic disk storage devices, optical disk storage devices, flash memory devices, or other non-volatile solid state storage devices. List of data recovery software Memory 1006 may optionally include one or more storage devices remotely located from the CPU(s) 1002. Types of data recovery In some embodiments, memory 1006 stores the following programs, modules and data structures, or a subset thereof:

• a network communication module 1012 that is used for connecting the server computer 1000 to other computers via the one or more communication network interfaces 1004 (wired or wireless), such as the Internet, other wide area networks, local area networks, metropolitan area networks, and so on;

• a physical database polling module 1016 for polling physical databases regarding associated virtual partitions and generating the virtual partition—physical database mapping.

banner