Physical Database Design
- Type product
Physical Database Design
Opleiderscore:
Beschrijving
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…
Veelgestelde vragen
Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.
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
Blijf op de hoogte van nieuwe ervaringen
Deel je ervaring
Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.