Query Plan Caching Workshop – Tomorrow
Don’t forget to sign up for the Query Plan Caching Workshop by Kalen Delaney. It will be well worth your time.
Today is the last day to register. So, Click Here to Register Now!
Web Scale Data Storage
Stephen brought up a few areas of concern when using non-relational kinds of storage. What does Web Scale really mean? Is it the loss of security; loss of strongly typed data; loss of Constraints; loss of ACID capability; loss of failover.
All of these questions are skills that database technicians have worked hard to develop. Can Web Scale really perform as promised and still be safe?
A couple of these questions are pretty easily answered. Data storage supporting large scale applications implement data security pretty much the same, even in an RDBMS. Most Web Scale databases don’t have multiple logins assigned to a schema in a database, ensuring schema level access to database objects. The maintenance of that kind of design would be too costly to design, implement and maintain.
So, what is the difference between an RDBMS that has a limited number of logins connecting to the database and credentials to a file system? In my opinion, there is virtually no difference.
In fact, one of the things we talked about a few weeks past was separating customer data. In a file based approach of storage, it is much easier to physically separate customer data than within one or more databases.
Still, who really needs Web Scale? Do we need Web Scale for the internal applications we build? Or are these only problems for certain kinds of internet facing applications?
How about dropping me an email to let me know what you are facing in your world? Drop me a note at facebook, twitter, or email at btaylor@sswug.org with your concerns, future plans or current successes using distributed storage.
Cheers,
Ben
$$SWYNK$$
Featured Article(s)
SQL Server 2008 Cluster Troubleshooting
In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2008 cluster. He also tells how you can resolve these problems.
Featured White Paper(s)
Upgrading to Microsoft SQL Server 2008 R2 from Microsoft SQL Server 2008, SQL Server 2005, and SQL Server 2000
More than ever, organizations rely on data storage and analysis for business operations. Companies need the ability to deploy… (read more)