OT: RE: interview question on schema design
- From: "Brady, Mark" <mbrady@xxxxxxxxxxxxxxxx>
- To: "oracledbaquestions@xxxxxxxxx" <oracledbaquestions@xxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 12 Dec 2012 13:33:42 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxx> 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
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
