Close
  • Latest News
  • Artificial Intelligence
  • Video
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Subscribe
Logo
  • Latest News
  • Artificial Intelligence
  • Video
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Subscribe
    Home Database
    • Database

    A Healthier Way to Archive Databases

    Written by

    eWEEK EDITORS
    Published January 22, 2002
    Share
    Facebook
    Twitter
    Linkedin

      eWEEK content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More.

      The task of archiving high-end databases while minimizing downtime becomes more complex and uses expensive storage each time its done. However, niche firm OuterBay Technologies Inc. may have the solution.

      The San Jose, Calif., company late last year launched LiveArchive for Oracle Database, and plans new versions this summer and in 2003, CEO Rich Butterfield said.

      Bursts of transaction data, like cholesterol in a persons veins, accumulate over time and can eventually slow Oracle application performance to a crawl, he said. LiveArchive automates the cleanup of that problem for the largest customers; the softwares average price is $200,000, he said.

      The version this summer will support new users of Oracle Corp.s 11i suite in upgrading from 10.7, which Oracle will stop supporting in June 2003, Butterfield said. The key to upgrading is retaining transaction history through a real product, not a one-off custom application, he said. LiveArchive performance improvements and versions for other databases are also on the horizon, as is support for non-Oracle applications.

      “Data cholesterol happens when you have an enterprise database that grows too quickly,” Butterfield said.

      Oracles latest database feature—application clustering for Oracle 9i—helps somewhat.

      “Certainly that changes the ballgame a little bit, [but] it doesnt completely solve the problem,” he said. Data marts and data warehouse also help, but they require extensive training and dont go as deep as LiveArchive, he said.

      Rather than address the problem with more and faster hardware, Sun Microsystems Inc. brought in OuterBay about three years ago, said Sean Meighan, manager of performance architecture for enterprise applications at Sun. Meighan is in charge of keeping alive an Oracle 7.3.4 enterprise resource planning database that ultimately controls about 90 percent of Suns revenue, while keeping 400 GB of data online for seven years.

      “Fifty people looking at archive data per week … wasnt going to be manageable,” he said. LiveArchive “makes all that data transparent to the user. The only person who really gets involved is the DBA.”

      Most people, he said, “think of this as tidy-bowl maintenance,” but despite the complexity of the solutions, “weve never had an outage, never had to offer a training class.”

      “We use half of a person to manage the purge. Its ended up saving us storage,” Meighan said.

      eWEEK EDITORS
      eWEEK EDITORS
      eWeek editors publish top thought leaders and leading experts in emerging technology across a wide variety of Enterprise B2B sectors. Our focus is providing actionable information for today’s technology decision makers.

      Get the Free Newsletter!

      Subscribe to Daily Tech Insider for top news, trends & analysis

      Get the Free Newsletter!

      Subscribe to Daily Tech Insider for top news, trends & analysis

      MOST POPULAR ARTICLES

      Artificial Intelligence

      9 Best AI 3D Generators You Need...

      Sam Rinko - June 25, 2024 0
      AI 3D Generators are powerful tools for many different industries. Discover the best AI 3D Generators, and learn which is best for your specific use case.
      Read more
      Cloud

      RingCentral Expands Its Collaboration Platform

      Zeus Kerravala - November 22, 2023 0
      RingCentral adds AI-enabled contact center and hybrid event products to its suite of collaboration services.
      Read more
      Artificial Intelligence

      8 Best AI Data Analytics Software &...

      Aminu Abdullahi - January 18, 2024 0
      Learn the top AI data analytics software to use. Compare AI data analytics solutions & features to make the best choice for your business.
      Read more
      Latest News

      Zeus Kerravala on Networking: Multicloud, 5G, and...

      James Maguire - December 16, 2022 0
      I spoke with Zeus Kerravala, industry analyst at ZK Research, about the rapid changes in enterprise networking, as tech advances and digital transformation prompt...
      Read more
      Video

      Datadog President Amit Agarwal on Trends in...

      James Maguire - November 11, 2022 0
      I spoke with Amit Agarwal, President of Datadog, about infrastructure observability, from current trends to key challenges to the future of this rapidly growing...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • AI Usage Policy
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2024 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.