Create a physical model and implement it in the database Avoid nullable relationships as much as possible Reverse engineer the database into Visio to check for correctness Design the user interface to support paging Lazy load trees as much as possible Evaluate all queries that require a DISTINCT clause Load test for scalability Summary Semantic data models can be very complex and until semantic databases are commonly available, the challenge remains to find the optimal balance between the pure object model and the pure relational model for each application. The key to success is to understand the issues, make the necessary mitigations for those issues, and then test, test, and test. Scalability testing is a critical success factor if you are going to find that optimal design. For more information: Did this help you? Please give us your feedback. Tell us on a scale of 1 (poor) to 5 (excellent), how would you rate this paper and why have you given it this rating? For example: Are you rating it high because it has good examples, excellent screenshots, clear writing, or another reason? Are you rating it low because of poor examples, fuzzy screenshots, unclear writing? This feedback will help us improve the quality of white papers we release. .
Create a physical model and implement it in the database Avoid nullable relationships as much as possible Reverse engineer the database into Visio to check for correctness Design the user interface to support paging Lazy load trees as much as possible Evaluate all queries that require a DISTINCT clause Load test for scalability Summary Semantic data models can be very complex and until semantic databases are commonly available, the challenge remains to find the optimal balance between the pure object model and the pure relational model for each application. The key to success is to understand the issues, make the necessary mitigations for those issues, and then test, test, and test. Scalability testing is a critical success factor if you are going to find that optimal design. For more information: Did this help you? Please give us your feedback. Tell us on a scale of 1 (poor) to 5 (excellent), how would you rate this paper and why have you given it this rating? For example: Are you rating it high because it has good examples, excellent screenshots, clear writing, or another reason? Are you rating it low because of poor examples, fuzzy screenshots, unclear writing? This feedback will help us improve the quality of white papers we release. .
BPSemanticDBModeling.docx