Planning and design
The first requirement for the successful operation of a distributed relational database is thorough planning. You must consider the needs and goals of your enterprise when making the decision to use a distributed relational database.
How you code an application program, where it resides in relation to the data, and the network design that connects application programs to data are all important design considerations.
Database design in a distributed relational database is more critical than when you deal with just one i5/OS® relational database. With more than one System i™ product to consider, develop a consistent management strategy across the network. The following operations require particular attention when forming your strategy:
- General operations
- Networking protocol
- System security
- Accounting
- Problem analysis
- Backup and recovery processes
To prepare for a distributed relational database, understand both the needs of the business and relational database technology.
- Identifying your needs and expectations for a distributed relational database
Consider these items when analyzing your needs and expectations of a distributed relational database.
- Designing the application, network, and data for a distributed relational database
Designing a distributed relational database involves making choices about applications, network considerations, and data considerations.
- Developing a management strategy for a distributed relational database
When you are managing a distributed relational database, keep these strategies in mind.
Parent topic:
Distributed database programming
Related concepts
Improving distributed relational database performance through the database