Physical Database Design

Product type

Physical Database Design

SAP Training
Logo SAP Training
Provider rating: starstarstarstar_halfstar_border 6.5 SAP Training has an average rating of 6.5 (out of 2 reviews)

Need more information? Get more details on the site of the provider.

Description

Goals

  • Present the essential tools to generate optimal database designs
  • Introduce the Information Systems Architecture (IAS)
  • Explain a formal database design methodology
  • Describe the physical design deliverables of the data architecture
  • Introduce the process matrix as a tool used to collect application requirements
  • Show the impact that selecting an optimal primary key can have on the design and performance of a database
  • Determine whether the “cost” of implementing integrity is beneficial
  • Provide a solid foundation for implementing indexes and index strategies
  • Introduce techniques that can reduce access time and disk I/Os for the most important processes
  • Introduce techniques to eliminate join…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Goals

  • Present the essential tools to generate optimal database designs
  • Introduce the Information Systems Architecture (IAS)
  • Explain a formal database design methodology
  • Describe the physical design deliverables of the data architecture
  • Introduce the process matrix as a tool used to collect application requirements
  • Show the impact that selecting an optimal primary key can have on the design and performance of a database
  • Determine whether the “cost” of implementing integrity is beneficial
  • Provide a solid foundation for implementing indexes and index strategies
  • Introduce techniques that can reduce access time and disk I/Os for the most important processes
  • Introduce techniques to eliminate joins and improve overall data access when joining tables
  • Determine how to best place objects (indexes, tables, logs) for optimal performance given object placement guidelines

Audience

  • Database Designers, Application Developers, Database Administrators

Prerequisites

Essential
  • Fast Track to Adaptive Server Enterprise (EDB110) or equivalent experience
  • Logical Database Design (SYB144)

Content

  • Learn how to plan and implement Adaptive Server Enterprise (ASE) tables, indexes, and data integrity to satisfy the data and processing requirements of an enterprise.
  • Gain exposure to all major physical design principles needed to create optimal database designs on the ASE 12.0 platform.
  • Study a formal design methodology that starts with a logical data model, and translate that into a relational representation. Both local and distributed requirements are used to design the most optimal physical implementation possible.
  • Course material also covers parallel query processing; enhanced partition statistics updates; bi-directional scans of indexes; higher maximum number of table references; DOL locking schemes, page formats and indexes; mixed indexes; enhanced alter table command; table-specific identity gaps; and Java in the database.

Notes

  • A review of specifying data, processing and distributed processing requirements, optimal indexing strategies, data integrity enforcement options, optimal data object placement strategies, security and auditing considerations, database administration issues, and distributed architecture options.

Popular tags

No tags submitted for this course yet

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.