current community

your communities

more stack exchange communities

Stack Exchange Inbox Reputation and Badges
tour help
Sign up ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free.
up vote 2 down vote favorite
1

In DB2, it seems there is a strong separation between what a database is and what a tablespace is. Where as in MySQL and MS SQL Server tablespace and database seemed to be used synonymously.

What are the differences, if any?

share|improve this question

closed as off-topic by user61852, MichaelT, GlenH7, Wayne M, gnat Aug 3 '14 at 2:19

  • This question does not appear to be about software development within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.
3  
This question appears to be off-topic because it's about inner workings of RDBMSs. It's more suitable for dba.stackexchange.com. –  user61852 Aug 2 '14 at 4:06

1 Answer 1

up vote 1 down vote accepted

In DB2 and Oracle, tablespace is roughly the child 'containers' within a database. You can, for example, organize your huge tables to be created on a specific tablespace, for managing the disk storage.

In MS SQL server there is no concept of tablespaces AFAIK. It uses file groups for the purpose of organizing storage and there is no one-to-one correlation with the tablespace concept.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.