I have a logical model developed which I need to convert into physical design. What is the procedure to do this? What steps and considerations are important during this transition. Things like indexes, Access patterns (I'm not clear as to what access patterns are and how to deal with them), access paths (not sure of this either). If someone can help me with these or point me to an online resource with examples to do the same. The implementation technology will be Oracle on IDS.
Can someone also gimme some insight into IDS?