Close
  • Latest News
  • Artificial Intelligence
  • 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
Logo
  • Latest News
  • Artificial Intelligence
  • 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
    Home Database
    • Database

    Open-Source Databases Hike Enterprise Appeal

    By
    Matthew Hicks
    -
    August 19, 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 creators of the open-source databases MySQL and PostgreSQL are trying to push them further into the enterprise with new features aimed at better support for transactions, database recovery and replication.

      MySQL ABs MySQL 4.0, expected to be released as a stable version by years end, provides the InnoDB transaction storage engine that includes row-level locking.

      Coming in Version 4.1 early next year will be the ability to handle stored procedures and triggers. MySQL 5.0, due late next year, will add more advanced management tools and replication as well as speed improvements, said Marten Mickos, CEO of MySQL, in Uppsala, Sweden.

      “We became famous as a Web content database, and now we are adding new features to make us more applicable for enterprise use,” said Mickos.

      Separately, developers of PostgreSQL, which has transactional capabilities, are working to add support for distributed databases. That support as well as new replication capabilities are likely to be available in the next year or two, according to Thomas Lockhart, a member of the PostgreSQL steering committee and a director at Postgre- SQL Inc., one of many companies providing the PostgreSQL database.

      A PostgreSQL feature that would enable point-in-time recovery, so that database administrators dont have to restore an entire database after a crash, should be out within six months, said Lockhart, in Wolfville, Nova Scotia.

      PostgreSQLs next full release, Version 7.3, is likely in the next few months and should include further schema support with the SQL99 standard.

      Users said additional enterprise features will help their companies expand their use of open-source databases. Yahoo Inc. uses a mix of MySQL and Oracle Corp.s namesake database for various parts of its Web portal, said Jeremy Zawodny, an engineer for the Yahoo Finance site. Zawodny said he expects stored procedures and InnoDB will be appealing to Yahoo departments that have home-grown applications and are looking for a lower-cost database.

      However, Zawodny said he doesnt expect MySQL to be used any time soon for large-enterprise applications. Yahoo on its business side is solidified on Oracle, and most enterprises would want application vendors to support MySQL before considering it.

      “Until you can run [SAP AG applications] on MySQL or buy apps off the shelf and plug in MySQL, then its an uphill battle,” said Zawodny, in Sunnyvale, Calif. “For the other 95 percent of apps, its a pretty good fit right now.”

      Other users, though, have found that open-source databases arent always the best answer as a Web site grows in use and functionality. Open Source Development Network Inc. last week at LinuxWorld here announced plans to move its SourceForge.net site off PostgreSQL and onto IBMs DB2 database by January. Open-source databases “work well, but they dont handle the scale,” said Patrick McGovern, director of SourceForge.net, in Fremont, Calif.

      Commercial database makers are making their software more friendly to open source. Oracle, of Redwood Shores, Calif., at LinuxWorld an- nounced an open-source version of the cluster file system in its Oracle9i database for Linux.

      Related stories:

      • OSDN Chooses IBMs DB2
      • Oracle to Unveil Open-Source Cluster
      • Review: Server Databases Clash
      • MySQL Database to Get Revamped
      Matthew Hicks
      As an online reporter for eWEEK.com, Matt Hicks covers the fast-changing developments in Internet technologies. His coverage includes the growing field of Web conferencing software and services. With eight years as a business and technology journalist, Matt has gained insight into the market strategies of IT vendors as well as the needs of enterprise IT managers. He joined Ziff Davis in 1999 as a staff writer for the former Strategies section of eWEEK, where he wrote in-depth features about corporate strategies for e-business and enterprise software. In 2002, he moved to the News department at the magazine as a senior writer specializing in coverage of database software and enterprise networking. Later that year Matt started a yearlong fellowship in Washington, DC, after being awarded an American Political Science Association Congressional Fellowship for Journalist. As a fellow, he spent nine months working on policy issues, including technology policy, in for a Member of the U.S. House of Representatives. He rejoined Ziff Davis in August 2003 as a reporter dedicated to online coverage for eWEEK.com. Along with Web conferencing, he follows search engines, Web browsers, speech technology and the Internet domain-naming system.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.

      MOST POPULAR ARTICLES

      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
      Applications

      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
      Cloud

      IGEL CEO Jed Ayres on Edge and...

      James Maguire - June 14, 2022 0
      I spoke with Jed Ayres, CEO of IGEL, about the endpoint sector, and an open source OS for the cloud; we also spoke about...
      Read more
      Applications

      Kyndryl’s Nicolas Sekkaki on Handling AI and...

      James Maguire - November 9, 2022 0
      I spoke with Nicolas Sekkaki, Group Practice Leader for Applications, Data and AI at Kyndryl, about how companies can boost both their AI and...
      Read more
      IT Management

      Intuit’s Nhung Ho on AI for the...

      James Maguire - May 13, 2022 0
      I spoke with Nhung Ho, Vice President of AI at Intuit, about adoption of AI in the small and medium-sized business market, and how...
      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
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2022 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.

      ×