Oracle (Quote) on Monday announced that eHarmony, a leading online dating and match-making service, is now using the Oracle 10g database to play Cupid to more than 17 million love-starved users. While the actual transition from Microsoft’s SQL Server database software only took an uneventful three hours, the planning, testing and installation took more than 14 […]
Datamation content and product recommendations are
editorially independent. We may make money when you click on links
to our partners.
Learn More
Oracle (Quote) on Monday announced that eHarmony, a leading online dating and match-making service, is now using the Oracle 10g database to play Cupid to more than 17 million love-starved users.
While the actual transition from Microsoft’s SQL Server database software only took an uneventful three hours, the planning, testing and installation took more than 14 months, according to Mark Douglas, eHarmony’s vice president of technology.
But the days and weeks preceding those fateful three hours were every bit as nerve-wracking as those awkward, hesitant seconds leading up to a couple’s first kiss.
“It went flawlessly, but a lot of our IT people were nervous,” Douglas said in an interview with internetnews.com. “Some said they didn’t know a lot about databases but it sounded risky. We’re a 24/7 business. We can’t just shut our database down for the weekend.”
To make it happen, Douglas and his five-person IT crew embarked on the tedious task of scripting custom code that would allow eHarmony to seamlessly transfer data from the SQL Server database to Oracle 10g without any downtime.
The eHarmony site handles more than 400 million page views a month and processes between 400 and 1,200 transactions per second. Douglas wouldn’t comment on exactly how much revenue would be lost if the site went down but said it would “a lot more” than a $1,000 a minute.
“The analogy I like to use is that is was like transferring packages from one plane to another while both are in flight,” he said. “We had to write a really significant amount of code.”
eHarmony, along with competitors such as Yahoo Personals, Match.com, JDate and dozens of other more specialized sites, allows subscribers to build personal profiles, view other subscribers’ profiles and access an array of dating services, including a match-making system that connects would-be lovers with others based on their dating preferences. eHarmony, based in Pasadena, Calif., charges $59 a month for the service but does offer long-term contracts at a lower monthly rate.
In the past year, eHarmony’s registered user base has surged from around 11 million to more than 17 million, adding an average of 15,000 new daters each day. That kind of growth, Douglas said, couldn’t be accommodated on SQL Server.
“There’s nothing particularly wrong with SQL,” he said. “We just needed functionality that Microsoft doesn’t provide and didn’t want to write it all ourselves.”
Leading up to the live launch, eHarmony tested migrating more than five terabytes of its precious data every day for 100 days in a row. It uses more than 400 servers to process changes to customer profiles, queries for potential matches, searches and new customer orders.
This article was first published on InternetNews.com. To read the full article, click here.
-
Ethics and Artificial Intelligence: Driving Greater Equality
FEATURE | By James Maguire,
December 16, 2020
-
AI vs. Machine Learning vs. Deep Learning
FEATURE | By Cynthia Harvey,
December 11, 2020
-
Huawei’s AI Update: Things Are Moving Faster Than We Think
FEATURE | By Rob Enderle,
December 04, 2020
-
Keeping Machine Learning Algorithms Honest in the ‘Ethics-First’ Era
ARTIFICIAL INTELLIGENCE | By Guest Author,
November 18, 2020
-
Key Trends in Chatbots and RPA
FEATURE | By Guest Author,
November 10, 2020
-
Top 10 AIOps Companies
FEATURE | By Samuel Greengard,
November 05, 2020
-
What is Text Analysis?
ARTIFICIAL INTELLIGENCE | By Guest Author,
November 02, 2020
-
How Intel’s Work With Autonomous Cars Could Redefine General Purpose AI
ARTIFICIAL INTELLIGENCE | By Rob Enderle,
October 29, 2020
-
Dell Technologies World: Weaving Together Human And Machine Interaction For AI And Robotics
ARTIFICIAL INTELLIGENCE | By Rob Enderle,
October 23, 2020
-
The Super Moderator, or How IBM Project Debater Could Save Social Media
FEATURE | By Rob Enderle,
October 16, 2020
-
Top 10 Chatbot Platforms
FEATURE | By Cynthia Harvey,
October 07, 2020
-
Finding a Career Path in AI
ARTIFICIAL INTELLIGENCE | By Guest Author,
October 05, 2020
-
CIOs Discuss the Promise of AI and Data Science
FEATURE | By Guest Author,
September 25, 2020
-
Microsoft Is Building An AI Product That Could Predict The Future
FEATURE | By Rob Enderle,
September 25, 2020
-
Top 10 Machine Learning Companies 2021
FEATURE | By Cynthia Harvey,
September 22, 2020
-
NVIDIA and ARM: Massively Changing The AI Landscape
ARTIFICIAL INTELLIGENCE | By Rob Enderle,
September 18, 2020
-
Continuous Intelligence: Expert Discussion [Video and Podcast]
ARTIFICIAL INTELLIGENCE | By James Maguire,
September 14, 2020
-
Artificial Intelligence: Governance and Ethics [Video]
ARTIFICIAL INTELLIGENCE | By James Maguire,
September 13, 2020
-
IBM Watson At The US Open: Showcasing The Power Of A Mature Enterprise-Class AI
FEATURE | By Rob Enderle,
September 11, 2020
-
Artificial Intelligence: Perception vs. Reality
FEATURE | By James Maguire,
September 09, 2020
SEE ALL
APPLICATIONS ARTICLES