Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

From this answer to What database does Google use?,

BigTable is not a relational database. It does not support joins nor does it support rich SQL-like queries.

Is this obvious? I do not understand why.

share|improve this question
add comment

1 Answer 1

BigTable doesn't use SQL (a query language) so SQL can't be used directly to query the database. And BigTable doesn't have "relations" in the same way as relational databases, it's more like bare tables.

If you want to get data from two tables, you have to do two lookups, and combine the result set in the application code. In other words the "join" operation is not built-in in the database, so you have to do that kind of operations in the application, if needed.

The fact that BigTable doesn't support SQL and JOIN operations has nothing to do with that it is a distributed database system. There are distributed databases that has support for SQL. E.g. VoltDB and MySQL Cluster. There are also many databases that aren't distributed and doesn't use SQL e.g. Kyoto Cabinet.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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