Close
  • Latest News
  • 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
  • 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

    Microsoft Getting a Bigger Slice of Database Pie

    By
    Brian Fonseca
    -
    January 12, 2004
    Share
    Facebook
    Twitter
    Linkedin

      As the absolute size of corporate and government databases continues to swell, more users are turning to technology they previously didnt consider for very large databases: Microsoft Corp. and its DBMS and Windows.

      A study by the Winter Corp., released last month, identifies the worlds largest, most heavily used databases and finds that Windows has grown from less than 20 percent to more than 40 percent in OLTP (online transaction processing) in operating system usage from 2001 to 2003. The increase narrowed the gap considerably between Windows and the Unix and IBM z/OS mainframe operating systems.

      But the study, according to company officials and users, is indicative only of a concerted effort by the Redmond, Wash., company to bolster its database and OLTP products and capabilities.

      Experts say sustained efforts by Microsoft to increase scalability across Windows and its SQL Server 2000 have enabled the company to inch toward multiterabyte OLTP systems in Windows.

      Tom Rizzo, Microsofts SQL Server product manager, said a growing number of the companys customers are running large databases on SQL Server 2000, including Verizon Communications Inc., which has 5 terabytes of capacity in a database for its billing and customer information.

      “It shows how SQL Server 2000 can scale. We expect Yukon [the next version of SQL Server, due late this year] to scale even better,” Rizzo said.

      SQL Server users, such as Brad Alford, a member of the SQL Server Group, in Charlotte, N.C., said that over the last few years Microsoft has instituted a “dramatic change” in its database storage and management techniques to address scalability hurdles.

      Alford said he expects the new online index option in Yukon, allowing database administrators to create, rebuild or drop an index, to suit impending database growth.

      “When [users] get into terabytes in an OLTP system, you have to very much pay attention to maintenance in databases,” said Alford. “Yukon online indexes rebuild, and thats very big in large databases because if you archive, you move [data] from a primary database to another … potentially creating fragmentation.”

      As databases continue to grow in storage capacity and performance, the expansion will have tremendous significance for users and impact the practices they use to adopt, operate and maintain larger databases, according to Richard Winter, president of Winter, in Waltham, Mass.

      “There are users out there [whose database size] requirements exceed the capabilities of products today,” said Winter. “My sense is that type of phenomenon is increasing.”

      To account for database capacity stretching current boundaries, Winter said that not only are companies storing more data but that theyre also analyzing it more deeply and “slicing and dicing” it to better understand customer patterns.

      In fact, according to Winter officials, study respondents expect their peak workloads for DSS (decision support system) to increase threefold by 2006.

      Microsoft is taking steps to address this increase, as the Winter study showed that Windows-based database size, particularly among DSS databases, is quickly rising.

      The Winter study examined 20 categories focusing on OLTP and DSS. Metrics used to determine winners included database size; normalized data volume; number of rows, records and objects; and peak workload activity. For peak load activity, the study examined the highest number of transactions per second for OLTP, while for DSS the highest number of concurrent, in-flight queries was analyzed.

      The company with the largest database size for all operating environments, including Unix, for the DSS portion was France Telecom S.A., with 29.2 terabytes. France Telecom uses Oracle Corp. for its DBMS.

      In the Windows comparison for database size, ComScore Networks Inc. secured the top spot with 8.9 terabytes for its database. ComScore relies on Sybase Inc.s Sybase IQ as its DBMS.

      Brian Fonseca
      Brian Fonseca is a senior writer at eWEEK who covers database, data management and storage management software, as well as storage hardware. He works out of eWEEK's Woburn, Mass., office. Prior to joining eWEEK, Brian spent four years at InfoWorld as the publication's security reporter. He also covered services, and systems management. Before becoming an IT journalist, Brian worked as a beat reporter for The Herald News in Fall River, Mass., and cut his teeth in the news business as a sports and news producer for Channel 12-WPRI/Fox 64-WNAC in Providence, RI. Brian holds a B.A. in Communications from the University of Massachusetts Amherst.

      MOST POPULAR ARTICLES

      Android

      Samsung Galaxy XCover Pro: Durability for Tough...

      Chris Preimesberger - December 5, 2020 0
      Have you ever dropped your phone, winced and felt the pain as it hit the sidewalk? Either the screen splintered like a windshield being...
      Read more
      Cybersecurity

      Visa’s Michael Jabbara on Cybersecurity and Digital...

      James Maguire - May 17, 2022 0
      I spoke with Michael Jabbara, VP and Global Head of Fraud Services at Visa, about the cybersecurity technology used to ensure the safe transfer...
      Read more
      Cloud

      Yotascale CEO Asim Razzaq on Controlling Multicloud...

      James Maguire - May 5, 2022 0
      Asim Razzaq, CEO of Yotascale, provides guidance on understanding—and containing—the complex cost structure of multicloud computing. Among the topics we covered:  As you survey the...
      Read more
      Cloud

      Why Data Security Will Face Even Harsher...

      Chris Preimesberger - December 1, 2020 0
      Who would know more about details of the hacking process than an actual former career hacker? And who wants to understand all they can...
      Read more
      Big Data and Analytics

      GoodData CEO Roman Stanek on Business Intelligence...

      James Maguire - May 4, 2022 0
      I spoke with Roman Stanek, CEO of GoodData, about business intelligence, data as a service, and the frustration that many executives have with data...
      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.
      © 2021 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.

      ×