Archive

Posts Tagged ‘Oracle Database’

LinkedIn Architecture

October 27, 2011 Leave a comment

Software

  • Solaris (running on Sun x86 platform and Sparc)
  • Tomcat and Jetty as application servers
  • Oracle and MySQL as DBs
  • No ORM (such as Hibernate); they use straight JDBC
  • ActiveMQ for JMS. (It’s partitioned by type of messages. Backed by MySQL.)
  • Lucene as a foundation for search
  • Spring as glue

Cookies are for Closers: Oren Hurvitz’s Blog » LinkedIn Architecture.

Oracle’s special handling of NULL

October 9, 2011 Leave a comment

The Oracle database handled NULLs slightly differently than the other databases. An empty string is considered NULL which can be confusing:

select * from dual where '' is null;

D
-
X1 row selected.

Source: NULL and index performance in the Oracle SQL database.