Kroll Factual stabilizes mortgage portal with Oracle RAC
It moved away from SQL Server because of availability, scalability issues
Computerworld - The latest version of Microsoft Corp.'s SQL Server may be proving itself adept at handling databases that are tens or hundreds of terabytes in size. But for at least one fast-growing business information services provider, SQL Server wasn't up to the task because of availability and scalability issues.
So after several successful rollouts of Oracle Corp.'s 10g database with Real Application Clusters (RAC) technology, Kroll Factual Data Inc. decided to move its entire 10TB of relational data off of Microsoft SQL Server for Oracle databases, according to Russ Donnan, CIO at Loveland, Colo.-based Kroll, which provides data to mortgage brokers and real estate investors.
That's despite Kroll's near-total loyalty to other parts of the Windows platform.
"We're an e-business that needs to be available all of the time to customers," Donnan said. "We are also an acquisitive company, growing very quickly. We need a scalable infrastructure. With SQL Server 2000, every time we needed to add performance, we had to migrate to a new server, which was a fairly painful process, to say the least."
Microsoft offers clustering in SQL Server 2005 using a different technology than Oracle's, and the vendor is promising to improve that feature in future versions of its database.
But that's not soon enough for Kroll.
"In order to get SQL Server  to a level where it was reasonably available, we had to use third-party tools, which works OK, though it is not a really good solution because of the support issues," Donnan said. "Oracle [High Availability] works exceptionally well in 10g.
"And with RAC, we are able to have asymmetrical hardware all in the same grid, which is very nice," he added. "Now, if we have a long-running query, we can push it off to a slower box, one with less processors or less memory. It's a better use of horsepower."
Kroll first began using Oracle RAC in 2003, after deploying the vendor's E-Business Suite. That database "gets hit really, really hard, about 150,000 transactions a day," Donnan said, adding that he hasn't experienced any of the "lock-up issues" Microsoft executives claim still exist with Oracle RAC.
Kroll followed that up in the fall 2005 by taking an acquired flood zone map database and converting the tens of thousands of MapInfo formatted files into a single Oracle 10g database cluster. Now, mortgage brokers who type in an address at Kroll's Web site can find out within seconds whether the property lies in a flood-prone area 93% of the time. The remaining queries are almost all processed within four hours, Donnan said, or offered for free.
- 15 Non-Certified IT Skills Growing in Demand
- How 19 Tech Titans Target Healthcare
- Twitter Suffering From Growing Pains (and Facebook Comparisons)
- Agile Comes to Data Integration
- Slideshow: 7 security mistakes people make with their mobile device
- iOS vs. Android: Which is more secure?
- 11 sure signs you've been hacked
- What Datapipe customers need to know about the new PCI DSS 3.0 compliance standard This handy quick reference outlines what PCI DSS 3.0 is, who needs to be compliant and how Alert Logic solutions address the new...
- The 12 PCI DSS 3.0 requirements addressed by Peer 1 Hosting This handy quick reference outlines the 12 PCI DSS 3.0 requirements, who needs to be compliant and how Alert Logic solutions address the...
- Defense Throughout the Vulnerability Life Cycle This whitepaper provides insight into how to leverage threat and log management technologies to protect your IT assets throughout their vulnerability life cycle.
- The Critical Role of Support in Your Enterprise Mobility Management Strategy Most business leaders underestimate the importance of tech support when they choose an EMM solution. Here's what to put on your checklist.
- Live Webcast Best Practices for the Hyperconverged Enterprise Network To the Age of Constant Connectivity and Information overload
- Live Webcast Unmasking the Differences between Consumer and Enterprise File Sync & Share The consumerization of IT combined with the rapid pace of the modern mobile workplace is forcing enterprise IT teams to evaluate file sync...
- Live Webcast Government Agency Webifies Outdated COBOL Applications Let this CTO tell you how his agency converted 1980s-era green screens into an e-filing portal for the 100,000 cases handled each year...
- The New Way to Work Knowledge Vault This Knowledge Vault focuses on how, in today's increasingly virtual world, it's more important than ever to engage deeply with employees, suppliers, partners,...
- Getting Ready for BlackBerry Enterprise Service 10.2 Find out how BlackBerry® Enterprise Service 10 helps organizations address the full spectrum of EMM challenges, while balancing the needs of both the... All Applications White Papers | Webcasts