473,224 Members | 1,972 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,224 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 2152
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

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

Similar topics

by: Leif K-Brooks | last post by:
I got bored with working on larger projects and wrote a little script/module for counting logical (not physical) lines of Python code in a file or directory. It uses ASTs generated by...
by: chris6995 | last post by:
I'm looking for a way to programatically query for the association between a physical device (i.e. removable USB storage) and it's logical drive letter. I've gone through Win32_LogicalDisk,...
by: dgk | last post by:
Is there some built in way to know whether a physical folder path is 'My Documents" for a specific user? I can always use xxx.StartsWith to compare it to the enumeration returned by the Personal...
by: serge | last post by:
How do I determine which method I should use if I want to optimize the performance of a database. I took Northwind's database to run my example. My query is I want to retrieve the Employees'...
by: serge | last post by:
I am running a query in SQL 2000 SP4, Windows 2000 Server that is not being shared with any other users or any sql connections users. The db involves a lot of tables, JOINs, LEFT JOINs, UNIONS...
by: MattM | last post by:
Looking at a tutorial for Asp.Net 2.0 using Northwind, the DAL was built by dragging the tables on to an XSN to create a dataTable object for each table in the database. The BLL was then mapped for...
by: nkumarin001 | last post by:
Hi, a) Why oracle architecture is divided into 2 types logical and physical structure? b) What is the use of logical structure in oracle as it does not consume any space if so then...
by: dbtwo | last post by:
Until today I always thought as long as you see a lot of logical reads as compared to physical reads, then you're good. But it looks like it isn't so. But doesn't logical read mean it's being read...
by: Jose Barragan | last post by:
Can anyone tell me whats the difference between logical pages and physical pages and how are logical pages created on the fly? Thanks
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

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.