MyYearbook Speeds Web Responses - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Software // Information Management
News
12/29/2009
12:47 PM
Connect Directly
Twitter
RSS
E-Mail
50%
50%

MyYearbook Speeds Web Responses

EXtremeDB, McObject's in-memory, object-oriented database, helps MyYearbook meet the high performance demands of the social networking site.

MyYearbook.com uses an application that generates heavy database processing demands as traffic builds. To meet that demand, it's implemented McObject's eXtremeDB database, an in-memory system, to meet the high performance needs of the social networking site.

For example, one application on the MyYearbook.com site is a BlindDate system that allows participants to supply questions about themselves with their preferred answers. MyYearbook presents a description of the person along with a questionnaire that has three choices for each answer. To be matched up with the question's supplier, a person needs to answer the questions in the way the submitter prefers.

"We give you three choices to answer a question about another person. If your answer is deemed compatible, we match you up," said Jonah Harris, a senior database administrator who supervises use of the special matching algorithm and application on the site.

Most participants like to submit a lot of questions about themselves and their favorite foods, pets, and music in hopes of weeding out unwanted attention and finding someone with a similar outlook, lifestyle, and pattern of thinking about the world, said Harris in an interview. Two hundred is usually the minimum number of questions submitted, but 2,000 isn't uncommon. In one case, a BlindDate participant submitted 8,000 questions. To match up that many answers with those of someone seeking a blind date is a tough assignment for the standard relational database system.

Harris tested a relational system with that task and it took 800 milliseconds, or nearly a second, to complete. He timed it with eXtremeDB, an in-memory, object-oriented database system, and it took 76 microseconds, or 76 millionths of a second. In both cases the database and application were running on the same four-CPU server, each CPU containing four cores; it also used 128 GB of random access memory.

The time required by the database must be added to the time required for application processing and network latencies involved in delivering a response from MyYearbook.com. Harris wants that response returned as quickly as possible and he opted for the in-memory system over a standard relational database.

MyYearbook.com, an early user of eXtremeDB, was launched in 2005. It is also a user of the open source PostgreSQL system for relational database work, Harris said.

Oracle and other vendors offer embeddable database systems, both relational and non-relational. Harris said he considered TimesTen, an in-memory relational system, as an option but opted for eXtremeDB because he didn't like "the way you program against it."

Object-oriented databases are sometimes easier to implement when dealing with complex data, as opposed to data that fits into rows and columns. A multiple choice questionnaire with thousands of unique questions is a source of complex data, though Harris said part of the speed of eXtremeDB lies in its implementor's ability to get a complex answer from the questionnaire down to a 1.5-byte representation in the database.

In-memory systems speed database response times by eliminating the need to go to disk. High performance Web applications are taking on more in-memory characteristics, from caching the data they use in memory to putting the objects that make up the application in memory as well.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
Slideshows
What Digital Transformation Is (And Isn't)
Cynthia Harvey, Freelance Journalist, InformationWeek,  12/4/2019
Commentary
Watch Out for New Barriers to Faster Software Development
Lisa Morgan, Freelance Writer,  12/3/2019
Commentary
If DevOps Is So Awesome, Why Is Your Initiative Failing?
Guest Commentary, Guest Commentary,  12/2/2019
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
The Cloud Gets Ready for the 20's
This IT Trend Report explores how cloud computing is being shaped for the next phase in its maturation. It will help enterprise IT decision makers and business leaders understand some of the key trends reflected emerging cloud concepts and technologies, and in enterprise cloud usage patterns. Get it today!
Slideshows
Flash Poll