I am given the task of normalising a database used in a Lotus Notes application. The tables have been created already. Now the application is to be scaled up. How do I approach this situation? How do I load test for Oracle and SQL Server databases?
Depending on how the Notes database is modeled, it may not be possible to project it into a normalized model. If there is a lot of LotusScript that is wedded to the existing structure, it may not be practical to normalize the design, even if it is possible.
Without detailed knowledge of your Notes application, I can't give you "step by step" instructions, or even really tell you what traps to avoid. The simplest answer is to review the application in detail, including the structure of the Notes databases. Then step back, and determine if you can normalize this in your own mind (third normal form is more than adequate).
If you can do this, I'd simply create a new Oracle database without slavishly trying to recreate the existing Notes schema. This will force you to rewrite a bit of the Notes application, but it should be the quickest and most cost effective way to get a working application that is at least moderately scalable.
For More Information
- Dozens more answers to tough database design questions from Pat Phelan are available here.
- The Best Database Design Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your database design -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Dig Deeper on Oracle database design and architecture
Related Q&A from Pat Phelan
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.