Problem solve Get help with specific problems with your technologies, process and projects.

RDBMS composite key definition

Oracle expert Brian Peasland explains the terms composite key and problem space in RDBMS.

What is meant by "composite key" in RDBMS terms? How do you define "problem space" in RDBMS terms?
In your table, you have attributes. Those attributes are denoted as the columns of that table. Depending on your data and the entity you are modeling, it is possible for one column to serve as the primary key. In other cases, the primary key is composed of more than one column. A composite key is simply a key that is composed of more than one column.

In all my years with database systems, I have never heard of the term "problem space". I even went back to my old...

textbooks from when I studied database systems in graduate school and we never used that term there either. On the web, I did find the term "problem space" defined here:

Picking the right approach to database software

From the above website, basically the problem space is the list of rules, tasks, and outcomes needed to solve a problem. Moving this definition into the database world, I would add that the problem space also contains the entities and attributes needed to help solve the problem, or solve the business needs the database needs to support.

This was last published in March 2008

Dig Deeper on Oracle database administration

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.