CS540_C_HW#6_14072_LAVANYA - Course ID CS540_C Student ID 14072 Student Name Lavanya Soma Homework 06 1 Table partition Scalability and availability are

CS540_C_HW#6_14072_LAVANYA - Course ID CS540_C Student ID...

This preview shows page 1 - 3 out of 4 pages.

Course ID: CS540_CStudent ID: 14072Student Name: Lavanya SomaHomework : 061)Table partition: Scalability and availability are major concerns when there is a table in a database with high concurrent usage. In such cases, data within a table may be stored in several partitions, each of which resides in a different tablespace. The Oracle server currently supports partitioning by a range of key values or by a hashing algorithm. If a table is partitioned, each portion is a segment, and storage parameters can be specified to control them independently. Use of this type of segment requires the partitioning option within the Oracle9i Enterprise Edition.2) Cluster:A cluster, like a table, is a type of data segment. Rows in a cluster arestored based on key column values. A cluster may contain one or moretables. Tables in a cluster belong to the same segment and share thesame storage characteristics. The rows in a clustered table can be
Background image
accessed with an index or hashing algorithm.3)Index-Organized Table:In an index organized table, data is stored within the index based on the key value. An index organized table does not need a table
Background image
Image of page 3

You've reached the end of your free preview.

Want to read all 4 pages?

  • Spring '16
  • Oracle Database, Oracle Corporation, Disk partitioning

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture