473,626 Members | 3,340 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Logical and physical Structure

1 New Member
Hello,

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 2170
debasisdas
8,127 Recognized Expert Expert
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

6
4085
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 compiler.parse instead of text manipulation functions, so it isn't incredibly fast, but the speed is good enough to be usable for me. If you want to take a look, the file is at <http://ecritters.biz/linecount.py>. I don't really care about how people...
0
1443
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, Win32_DiskDrive, Win32_PhysicalMedia in system.management... I've also run through WM_DEVICECHANGE and the device types under DEV_BROADCAST_HDR. I can't find anything that gives me the logical drive letter mapping for physical device/drive - in this...
9
2496
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 folder, but it seems a bit inelegant.
3
1572
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' First and Last Names that sold between $100,000 and $200,000. First let me create a function that takes the EmployeeID
4
3549
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 etc... Ok it's not a pretty code and my job is to make it better. But for now one thing I would like to understand with your help is why the same SP on the same server and everything the same without me changing anything at all in terms of SQL...
1
2013
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 each entity but since the data was simple it mapped to a physical table (ex. customer). But what do you do if your tables don't match up the physical and logical? For example, you could have a table for people, a table for job codes, and a...
3
12791
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 what is the use of physical structure? Regards, Naveen
2
5536
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 from memory and no I/O involved? So why is Logical Reads = CPU Consumption ? I ran into an exact scenario last week when our applciation were running something, and each time an application started, the CPU would go from 99% idle to 48% idle. I...
1
1562
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
0
8199
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8638
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8505
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6125
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5574
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4092
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2626
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1811
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1511
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.