Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
paprica
Starting Member
1 Post |
 Posted - 2011-12-09 : 03:49:42
|
| Hello. I thought of using C++ code for managing a user database for a website.It could be something that creates a file for each new user, named by his ID, so then it should be easy to read from the database too.It should work faster too, right?Is this okay? Are there any website (Facebook, YouTube, etc...) that don't use SQL for their database management? |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2011-12-09 : 05:19:41
|
| there are many, many different data technologies.A relational database ( sql server / oracle / mysql / lots of others ) is a general purpose data storage and retrieval engine. SQL is the declarative language that is used to query the relational database.A document store ( CouchDB / SOLR / MongoDB / others) is a document storage and retrieval engine. They talk in terms of Documents rather than atomic units of data and generally support a lot of extra nice things that a traditional relational DB does not (faceting / string tokenisation / etc). However, in general, they make very poor 'truth stores' compared to a relationaldb. They generally support add hoc queries where predicates find documents.A Key value store (Membase / Memcache / tokyo cabinet / many others) are for storing individual atomic datums by a key and then retrieving them by the same key -- they are blazingly fast at this but you have to know the key (or be able to deterministically work out what the key is) to get a value back -- they don't support ad hoc queries in the sense that you probably mean.Then there are many hybrid types.Facebook uses cassandra I believe which a datastore they developed in house. Many big companies do this (build their own engine) because they have very specific requirements that traditional rdbms are not good at handling.So it depends!Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
|
|
|
Is SQL a must for database management?