Garmin International Consolidates 24 Databases onto a Single Footprint, Improves Performance up to 50%
 
Oracle 1-800-633-0738
Find an Oracle Specialized Partner
Oracle Customer Programs
 
 

Garmin International Consolidates 24 Databases onto a Single Footprint, Improves Performance up to 50%

A pioneer in global positioning system (GPS) navigation, Garmin International Inc. was founded in 1989 with a handful of dedicated engineers and the idea for an innovative product. Today, with 9,400 employees worldwide, Garmin is a global leader in the design, manufacture, and sale of navigation and communication devices and services. The company has built and sold more than 100 million devices that serve aviation, automotive, marine, outdoor, fitness, and wireless markets. Its goal is to enrich the lives of customers, suppliers, distributors, and employees by providing the very best products that offer superior quality, safety, and operational features at affordable prices.

 
 

 
 

Challenges

A word from Garmin International Inc.

  • “Oracle Exadata helped us meet our challenges by enabling us to consolidate onto a single footprint. We can more efficiently utilize space, power, and cool the data center while lowering administrative costs and ensuring high database availability to deliver optimal services to internal and external customers.” – Ed Link, Vice President, Information Technology, Garmin International Inc.

  • Reduce total cost of ownership for an extensive Oracle Database environment that powers Oracle Advanced Supply Chain Planning, Demantra Demand Management, and Oracle Hyperion Financial Management applications, each month processing13 million queries, as well as 30,000 batch jobs and reports
  • Enable high availability for additional GPS-based offerings, such as Garmin Connect, a community-based website for runners, cyclists, and outdoor enthusiasts who track their activities with Garmin devices
  • Reduce unplanned outages and ensure quick system and data recovery in the event of an outage―vital capabilities when providing essential GPS services
  • Create a solid foundation to support exponential, year-over-year, data growth for various enterprise applications without performance degradation

Solutions

  • Deployed Oracle Exadata Database Machine and improved database performance by 20% to 50% without making additional changes—such as modifying queries—boosting speed of critical business applications, such as Garmin Connect, a GPS-based offering that stores more than 400 billion miles of fitness activity
  • Consolidated 8 production databases and 40 nonproduction databases on the 4 Oracle Exadata Database Machines to reduce total cost of database ownership by saving maintenance, energy costs, and more
  • Reduced planned and unplanned Garmin Connect database outages—which previously plagued the system—making it more reliable for customers, even as site traffic increased by as much as 400% in the past year and data increased from 3 TB to 30 TB
  • Reduced storage area network backup times by up to 50% and decreased the time needed to duplicate Garmin’s largest database—up to 30 TB—from eight days to five hours
  • Implemented Oracle Active Data Guard to reduce the time to create database clones, decrease demand on the primary database, and provide standby failover protection 
  • Improved Oracle E-Business Suite Advanced Supply Chain Planning and Demantra Demand Management application performance by 20% to 50%, enabling Garmin to complete its planning cycle in record time to more accurately identify demand, efficiently process orders and specify manufacturing materials, and effectively plan production cycles to support just-in-time manufacturing
  • Deployed four Oracle Exadata Database Machine Half Racks, with two used for production systems—such as Garmin Connect, as well as Oracle Advanced Supply Chain Planning, Demantra Demand Management, and Oracle Hyperion Financial Management—and the others used for application development and testing environments
  • Created a highly scalable and extreme performance platform that enabled Garmin to continue to migrate applications to Oracle Exadata, including its core Oracle E-Business Suite database that supports the company’s financials, order management, inventory, warehouse, shipping, purchasing, and manufacturing operations, as well as other databases supporting critical business systems

Why Oracle

“We selected Oracle Exadata Database Machine because it efficiently integrates networking, input/output, and central processing unit in a single cabinet. This reduces the footprint in the data center regarding space, power, and cooling. Consolidating databases onto Oracle Exadata reduces patching, system management, and security maintenance demands,” said Ed Link, vice president, information technology, Garmin International Inc.

“Oracle Exadata provides a single hardware and software solution. The synergy between the hardware and the software components leads to high performance, and system consolidation eases environment management,” Link said.

Implementation Process

Garmin completed its Oracle Exadata implementation in three phases: first addressing the databases processing transactions from Oracle Advanced Supply Chain Planning and Demantra Demand Management, and then moving to the Garmin Connect environment, followed by moving the company’s Oracle Hyperion Financial Management data infrastructure, its core Oracle E-Business Suite infrastructure, and Oracle Business Intelligence Suite Enterprise Edition.

“The key lesson we learned is to perform extensive testing. In addition, it is important to purchase the latest versions for all solutions to maximize performance. Further, by performing a database consolidation project in parallel with the implementation, we could take full advantage of our investment,” Link said.

“Oracle Support helped us throughout our implementation―with personalized daily conference calls, late-night support, custom help from Exadata product management, and involvement with upper-level executives at Oracle,” Link said. “Oracle went above and beyond to help make sure our Oracle Exadata implementation was a success.”