1 / 19

CONSISTENCIA DE LAS BASES DE DATOS

CONSISTENCIA DE LAS BASES DE DATOS. Servidor de Bases de datos ASE Sybase. Términos. Base de datos Almacenamiento Página Llave primaria Índice Clúster/no clúster Holgura Allocation Unit Extent O bject A llocation M ap OAM Page linkage. Base de datos – Visión lógica. Base de Datos.

miles
Download Presentation

CONSISTENCIA DE LAS BASES DE DATOS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CONSISTENCIA DE LAS BASES DE DATOS Servidor de Bases de datos ASE Sybase

  2. Términos • Base de datos • Almacenamiento • Página • Llave primaria • Índice • Clúster/no clúster • Holgura • AllocationUnit • Extent • ObjectAllocationMapOAM • Page linkage

  3. Base de datos – Visión lógica Base de Datos

  4. Almacenamiento cronológico Base de Datos

  5. Almacenamiento con PK Base de Datos

  6. Almacenamiento usando páginas P0 P1 P2 Pn Pn-1 P3 P4 P5 P6 P7 P8 P9 Base de Datos

  7. Almacenamiento usando páginas y holgura P1 P0 P1 P2 Pn Pn-1 P3 P4 P5 P6 P7 P8 P9 Base de Datos Holgura

  8. Pages & Allocation Unit & Database P1 P2 P3 P4 P5 P6 P18 P7 P9 P10 P11 P12 P13 P14 P15 P16 P8 P0 P17 P19 P29 P23 P24 P25 P26 P27 P28 P20 P255 P31 P248 P249 P250 P251 P252 P253 P254 P30 P22 P21 Base de Datos Allocation Unit

  9. Pages & Allocation Unit & Allocation page Allocation Page P3 P4 P5 P6 P7 P19 P9 P11 P12 P13 P14 P15 P16 P17 P18 P10 P0 P2 P1 P8 P31 P24 P25 P26 P27 P28 P29 P30 P21 P23 P248 P250 P251 P252 P253 P254 P255 P22 P20 P249 Allocation Unit Extent Allocation Unit = 256 pages Extent = 8 pages

  10. Pages & Allocation Unit & Object Allocation Map OAM AP P3 P4 P5 P6 P7 P8 P9 P11 P19 P12 P13 P14 P15 P16 P17 P18 P10 P20 P22 P0 P23 P24 P25 P26 P27 P28 P29 P30 P31 P248 P249 P250 P251 P252 P253 P254 P255 P21 P257 P258 P256 P259 P260 P261 P262 P263 P264 P265 P267 P275 P268 P269 P270 P271 P272 P273 P274 P2 P266 P1 P276 P278 P279 P280 P281 P282 P283 P284 P285 P286 P287 P504 P505 P506 P507 P508 P509 P510 P511 P277 Allocation Unit

  11. Page Linkage P P N N

  12. Page Linkage P P N N

  13. Page Linkage P P N N

  14. Page Linkage P P P N N N

  15. Page Linkage P P P P P N N N N N

  16. Page Linkage P P P N N N

  17. Page Linkage P P P N N N

  18. Page Linkage P P P P P N N N N N

  19. Page Linkage P P P P P N N N N N

More Related