 |
 |
Home > Relational Database Management System (RDBMS) fundamentals tutorial |
 |
 |
 |
Relational Database Management System (RDBMS) fundamentals tutorial |
 |
| 21 Jun 2005 | SearchOracle.com |
 |


|
New to database administration or development? Here is a quick guide that can get you started in the right direction by providing background on the relational model and practical advice for working with relational database management systems (RDBMS).
TABLE OF CONTENTS
[IMAGE] The relational model
[IMAGE] Database structure
[IMAGE] Database design
[IMAGE] Normalization
[IMAGE] Working with an RDBMS
[IMAGE] More Learning Guides
The relational model[IMAGE] Return to top
Because much confusion stems from vague database-related terms, a good starting point is to know the terminology. First described by E. F. Codd at IBM in 1970, a relational database is a collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables. The best backgrounder on the relational model is this chapter from Chris Date's new book, Database in Depth:
Relational Theory for Practitioners.
Definitions of more database-related terms are available from our sister site WhatIs.com:
The ...
To continue reading for free, register below or login
To read more you must become a member of SearchOracle.com
');
// -->

relational model is not without controversy, pitting purists versus theorists versus practitioners versus flat-out critics. For some background, check out these links:
Database structure[IMAGE] Return to top
As mentioned above, database terminology sometimes gets in the way of database administration. The terms "database" and "instance" are important to know when using Oracle systems, and it is also important to know that different vendors will use the terms to mean different things. Here are some examples:
Another important distinction to make is the difference between the physical structure of the database, which consists of data files, redo log files and control files, and the logical structure, which consists of the tablespaces, schema objects, segments and extents. For further explanation:
Database design[IMAGE] Return to top
Most of the time, database performance and ease of use is only as good as its design. And good design can, like everything else so far, be open to considerable debate. Here are a few resources to help you decide for yourself:
Normalization[IMAGE] Return to top
The rules of normalization are critical to database design, and with controversy continuing into this section, here are plenty of viewpoints on how normalization and denormalization affect the design and use of a database:
Working with an RDBMS[IMAGE] Return to top
For practical matters, sometimes you have questions that are pretty basic, but you don't know where to start to look for an answer if you can't find it in the Oracle documentation. For those types of issues, a great resource is our repository of expert answers, which you can search. SearchOracle.com's panel of experts have answered hundreds of basic questions, and here is a very small sampling.
Oracle features explained:
Here are examples of how to:
For more, here's a field survey of database best practices, and a chapter excerpt of the book Oracle9i: The complete reference.
To retrieve data, you need to know the structured query language (SQL). We have a complete SQL Learning Guide, but for a basic understanding of what it can do for you, read below:
More Learning Guides[IMAGE] Return to top
- Crash Course: Oracle basics
This guide helps you to research, compare or work with the Oracle DBMS.
It provides Oracle basics for versions 8.x, 9.x and 10g.
- Solving common Oracle errors guide
Solve your Oracle errors quickly and easily with help from this fast
guide. It covers every expert response pertaining to Oracle errors on
SearchOracle.com.
- Oracle database performance tuning guide
Newbies and experts will benefit from this guide; you'll establish a
smart approach to tuning, use and interpret Oracle's tuning utilities
and identify specific problem areas.
- Oracle PL/SQL tutorial
This fast guide to PL/SQL can help both newbies and veterans become
better acquainted with the language and hone their developer skills.
- Oracle database security guide This guide covers a wide variety of topics on many aspects of Oracle security to help you lock down your data.
- Fast Guide: Becoming an Oracle Certified Professional
Get expert technical advice on where to begin your certification
studies, passing the final exam and putting your certification into
effect in the workplace.
- Guide to Oracle freeware and shareware A library of freeware, shareware and inexpensive tools to help with Oracle administration and development.
- Learning Guide: Backup and recovery
This guide covers everything from the basics of creating a backup and
recovery plan to the specifics of using RMAN and other methods of hot
and cold backups.
- SQL guide for Oracle users
Whether you are a newbie or a seasoned expert looking to tweak query
performance, this learning guide can help you figure out how to get the
data you need by looking at solutions to real-world problems.

|
 |
|
 |
 |
 |
| TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of . |
|
| |
All Rights Reserved, , TechTarget |
|
|
|
|
|