471,337 Members | 1,066 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,337 software developers and data experts.

Logical and physical Structure


This is my first post to this forum.

I'm working through an exercise where I am required to 'design and describe' the logical and physical structure for a case study.

I've made quite good progress so far.

For logical part I have done the following:

1. ERD diagram
2. Database sizing of all the tables
3. Have talked about the tablespaces that I'm going to need and how big they are going to be
4. Talked about the what block size I'm going to be using

However for the physical side I'm a little confused about what I should be doing. I found another post on this forum which states the physical structures as:

Datafiles - This I understand, I could easily state how big these should be.

Control Files
Redo Log files
Archive log files
Parameter Files
Alert and trace log files
backup files

I'm not sure how I can 'design' these features - aren't these just created automatically when the database is created.

Perhaps I'm missing something obvious here, hopefully someone can point me in the right direction.
Feb 16 '08 #1
1 2009
8,127 Expert 4TB
Your question is too much theoritical and is beyond the scope of this discussion . Please follow some good book for the purpose. Else you can easily find all that by investing some time in web-searching.
Feb 18 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Leif K-Brooks | last post: by
reply views Thread by chris6995 | last post: by
1 post views Thread by MattM | last post: by
2 posts views Thread by dbtwo | last post: by
1 post views Thread by Jose Barragan | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.