Add Papers Marked0
Paper checked off!

Marked works

Viewed0

Viewed works

Shopping Cart0
Paper added to shopping cart!

Shopping Cart

Register Now

eKönyvtár library
FAQ
 

Great deal: today with a discount!

Regular price:
1 433 Ft
You save:
213 Ft
Discounted price*:
1 219 Ft
Purchase
Add to Wish List
ID number:390573
Evaluation:
Published: 24.09.2003.
Language: English
Level: Secondary school
Literature: n/a
References: Not used
Extract

A physical design is a specification for database implementation. At this phase of development, you must know the database platform you're going to use--perhaps SQL Server 7.0 on Windows NT Server 4.0, Microsoft Access on the desktop, Oracle on the mainframe, or some other platform. To create a physical design, you pull together all the specifications and models you've created so far, then modify and optimize them for your target platform. For example, you need to modify all column properties, including data types, so that they're specific to your target environment. You can add extra columns that don't appear in the conceptual or logical models, such as flag columns and timestamp columns that facilitate data processing. You also need to size the database, analyze data volume and use, incorporate any replication or distribution plans, and select candidate columns for indexing. If you're thinking ahead, you'll also determine user roles (groups), logins, and security permissions; requirements for data retention (archiving plans); and failover and backup and recovery plans.…

Load more similar papers

Send to email

Your name:

Enter an email address where the link will be sent:

Hi!
{Your name} suggests you to check out this eKönyvtár paper on „The Physical Design”.

Link to paper:
https://eng.ekonyvtar.eu/w/390573

Send

Email has been sent

Choose Authorization Method

Email & Password

Email & Password

Wrong e-mail adress or password!
Log In

Forgot your password?

Facebook

Not registered yet?

Register and redeem free papers!

To receive free papers from eKönyvtár.com it is necessary to register. It's quick and will only take a few seconds.

If you have already registered, simply to access the free content.

Cancel Register