Notes on 'Expert Oracle' - No.13.2: partition - partition mechanism

2010-02-25  来源:本站原创  分类:Database  人气:164 

Q: What area by then?
A: four kinds of programs
1. By numerical interval points. Such as [1-100] let A,, [101-200] put B,
2. By enumeration values of the discrete values of zoning, as in [Jiangxi, Fujian] let A,, [Beijing, Zhejiang] let B,. This is called "list partition"
3. Directly by the hash value of partition. This is fine to say.
4. Combined use of several regional mechanisms for more than several partitions, and then in the large partition into smaller partitions.

Q: Data does not migrate between partitions, right?
A: will.
1. Such as the original records have a value of 1, on the A zone; now its value becomes 105, you must move the B zone.
2. This "moving line" is expensive. If you choose the extension mechanism leading to this kind of thing often happens that the District failed

相关文章
  • Notes on 'Expert Oracle' - No.13.3: Zoning - Zoning Index 2010-02-25

    Two modes of partition index 1. Table partition => corresponding index partition. A corresponding index partition table partition A, B corresponds to the index table partition partition B. This is called "local index partition" 2. Independent

  • Notes on 'Expert Oracle' - No.13.1: partition - partition of benefits 2010-02-25

    1. To improve the system reliability (HA): do not put all your eggs in one basket a. A bad area, but the data partition B can still be inquiries into b. A bad partition, and restore the partition of the time table than the entire restoration was much

  • Notes on 'Expert Oracle' - No.13.2: partition - partition mechanism 2010-02-25

    Q: What area by then? A: four kinds of programs 1. By numerical interval points. Such as [1-100] let A,, [101-200] put B, 2. By enumeration values of the discrete values of zoning, as in [Jiangxi, Fujian] let A,, [Beijing, Zhejiang] let B,. This is c

  • Notes on 'Expert Oracle' - No.11.1: Index - Index Category 2010-02-22

    1. B * tree - an index of the most common 2. BitMap Index - mainly for a high degree of duplication of data, not for OLTP system 3. BitMap Join Index - table set up in the field for the index of another table 4. Function-based Index - can be the name

  • Notes on 'Expert Oracle' - No.11.2: Index - B * Index 2010-02-22

    1. Structure a. similar to the binary tree b. a high degree of balance: all leaf nodes have the same level in the tree c. In general height is 2 or 3 (need 2 to 3 times I / O) 2.When B *? a. If the query with the index returned only a few rows, you c

  • Notes on 'Expert Oracle' - No.11.3: Index - BitMap Index 2010-02-23

    BitMap Index 1. Basically, for OLAP, OLTP environment generally does not apply to 2. Structure BitMap Index: an index entry corresponding to multiple lines B * Index: an index entry corresponding to a line only 3. An entry corresponding to multi-line

  • Notes on 'Expert Oracle' - No.11.4: Index - Tips 2010-02-23

    1.B * null value of the index will not index the entire entry so select * from T where x is null will not use the index (if the index built on the x field) However, if the following two conditions, the index will be used a. index built in (x, y) on b

  • Notes on 'Expert Oracle' - No.12.1: data type - character types 2010-02-25

    1. Note that character set, that NLS 2.char/nchar simply do not have access i. It will fill the vacant space through space, causing a waste of space ii. It also led to select ... where column_five_char = 'ABC' not hit record, because the database is

  • Notes on 'Expert Oracle' - No.12.2: data type - numeric type 2010-02-25

    1. Generally use "Number" This type of 2. Database how to deal with the definition of precision than the input data? a. Rounding: too many decimal places, but the nearest whole number not exceeding, was rounded and decimal places to insert the d

  • Notes on 'Expert Oracle' - No.12.3: Data Type - Date / Time Types 2010-02-25

    1. Query, try to avoid the type in the date field to use the function a. make the field on which the index is invalid. Bad example: select ... where to_char (birthday) = '2010-1-1 ' Good: select ... where birthday = to_date ('2010-1-1 ') b. If the no

  • Expert Oracle Exadata译者序 2014-03-23

    最近博客很少更新,一是沉迷于新浪微博AskHelloDBA,回答大家的数据库问题:二是与Kaya.Kamus共同翻译<Expert Oracle Exadata>这本书,最近书籍的翻译工作已经进入尾声,即将定稿并出版,以下是我的译者序. 译者序-Jacky 2008年,Oracle在OOW上发布了与HP合作开发的Exadata V1.当时,我就对Exadata充满了好奇,很快我就在自己的博客上写了第一篇介绍Exadata的文章<Oracle Database Machine>.现在

  • Understanding of MySQL - parallel database and partition (Partition) 2011-08-01

    1, parallel database 1.1, parallel database architecture parallel machines there, gave birth to the emergence of parallel databases, no, the relationship is highly parallel computing has always been the. Database system performance measures are mainl

  • Understanding of MySQL - the database in parallel with the partition (Partition) 2011-08-01

    1, parallel database 1.1, parallel database architecture parallel machines there, gave birth to the emergence of parallel databases, no, it should be relational operators always been highly parallel. Measure the performance of database systems, there

  • MySQL partition (Partition) function tests (reprint) 2010-06-01

    MySQL partition (Partition) function tests 2008-07-06 20:02 directory [Overview] [Partition table and not the partition table testing process] [Division Command Xiangjie] [Overview] 5.1 Since the beginning of the partition (Partition) with the suppor

  • Sharding with the database partition (Partition) the difference between 2010-07-02

    With the passage of time, data in the database table increases, the server has been overwhelmed, in order to solve this problem, a data partition of the software concept, called sharding. Here is the related idea of introducing the software. 1.Shardi

  • [Change] MySQL partition (Partition) function tests 2010-09-17

    MySQL partition (Partition) function tests 2008-07-06 20:02 directory [Overview] [Partition table and not the partition table testing process] [Division Command Xiangjie] [Overview] 5.1 Since the beginning of the partition (Partition) with the suppor

  • MySQL partition (Partition) function tests 2010-10-19

    [Overview] [Partition table partition table and not during the test] [Partition Command Detailed] [Overview] 5.1 Since the beginning of the partition (Partition) with the support of 6.0 should be relatively stable = Horizontal partition (divided by r

  • [Transfer] MySQL partition (Partition) function tests 2010-09-17

    MySQL partition (Partition) catalog function tests 2008-07-06 20:02 [Overview] [Partition table partition table and not during the test] [Partition Command Detailed] [Overview] 5.1 Since the beginning of the partition (Partition) with support from 6.

  • Through the partition (Partition) to enhance the performance of MySQL 2010-10-19

    A few years ago, I wrote an article entitled "The Foundation of Excellent Performance" article (and still can http://www.tdan.com/i016fe03.htm see), I is the impact of database-driven SQL statement The first element of the system performance poi

  • KEY MySQL data partition partition Practice 2010-06-29

    For RANGE and LIST partitions, some examples from the Internet learned, can be specified for each partition corresponding database server, as follows: drop database if exists myspider; create database myspider; use myspider; Create table tbl_b ( col_