A properly designed and configured database can provide ready access to the enterprise-wide data to answer the ad hoc, tactical, decision support, data mining, and analytic requests that a modern business enterprise generates in its quest to remain ahead of its competition.
This section discusses aspects of the Vantage architecture that need to be understood for database design and provides general design considerations. This section also introduces the concepts of database modeling, both logical and physical, as a preview for the remaining sections in this document.
The following content is mainly applicable to the standard nodes of the primary cluster in VantageCloud Lake and may not apply to compute clusters on the primary cluster.
For information about the primary cluster and compute clusters, see Managing Compute Resources.
- Database Engine 20
- Data Placement to Support Parallel Processing
- Synchronization of Parallel Operations
- Design Considerations
- Databases and Data Modeling
- Database Design Life Cycle
- Designing for OLTP and Designing for Data Warehousing Support
- ANSI/X3/SPARC Three Schema Architecture
- Requirements Analysis
- Logical Database Design
- Activity Transaction Modeling
- Physical Database Design