OT: RE: interview question on schema design
Date: Wed, 12 Dec 2012 13:33:42 -0500
Message-ID: <DB806F2BEB98ED4FB8172F8CE09447FF946A6CD1E1_at_EXCH-MBX05.allegisgroup.com>
That attitude is promulgated by tools like hibernate (http://www.hibernate.org/) which increases the developer's ability to rapidly develop new applications by abstracting the database [away]. It abstracts the database away, so you no longer have to /think/ about it. Adoption of those frameworks has been slower in .net communities but where it is adopted you find the same attitude.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dba DBA
Sent: Monday, December 10, 2012 3:24 PM
To: ORACLE-L
Subject: re: interview question on schema design
About 2 years ago I was working with a java architect who hated relational databases. He was convinced that a relational database could not handle the recursive style friend relationships that facebook had. I didn't get a chance to explain to him that yeah you can and that I think facebook primarily uses relational databases. I think they have some other things they use also. Then again this guy also told me that views were evil and his developers wanted to write their own database. this was a system that was about 100 gbs. 98 gbs of it were in a couple of CLOB fields. They were stored .pdfs. So you had 2 gbs of relational data and it was really slow. I turned on oracle auditing (just the basic stuff) and audit all the sqls to the database. Locked in and clicked a few buttons. Each button click was 15-25 separate sql statements. I tried to explain to him that if you cut down the number of sqls and did some joins. possibly simplified the table struct, this would run really fast. Got a blank look. All the SQL was generated. They considered the DB the 'persistence layer'. There were alot of 1 to 1 relationships mapping to objects as well. This lead to even queries.
For some reason its only the java people who are like this. I never run into this problem with C, python, .net or anything else developers.
On Fri, Dec 7, 2012 at 4:25 PM, kyle Hailey <kylelf_at_gmail.com> wrote:
> Here is an interview question using facebook for an example.
> It's a data modeling question that applies to a lot of social network
> sites and startups:
> http://dboptimizer.com/2012/11/07/facebook-news-feed-performance/
>
> I haven't answered the question, just provided some ideas.
>
> - Kyle
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-l This electronic mail (including any attachments) may contain information that is privileged, confidential, and/or otherwise protected from disclosure to anyone other than its intended recipient(s). Any dissemination or use of this electronic mail or its contents (including any attachments) by persons other than the intended recipient(s) is strictly prohibited. If you have received this message in error, please notify us immediately by reply e-mail so that we may correct our internal records. Please then delete the original message (including any attachments) in its entirety. Thank you. -- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 12 2012 - 19:33:42 CET