Close
  • Latest News
  • Cybersecurity
  • Big Data and Analytics
  • Cloud
  • Mobile
  • Networking
  • Storage
  • Applications
  • IT Management
  • 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
Menu
Search
  • Latest News
  • Cybersecurity
  • Big Data and Analytics
  • Cloud
  • Mobile
  • Networking
  • Storage
  • Applications
  • IT Management
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Database
    • Database
    • Development

    Whidbey, Yukon Combo Provides BI Development Platform

    By
    Darryl K. Taft
    -
    April 25, 2005
    Share
    Facebook
    Twitter
    Linkedin

      While the integration of Microsofts Visual Studio 2005 development-tools suite with its SQL Server 2005 database is geared at helping developers more easily build database applications, it also delivers a platform for data warehousing and business intelligence, the company said.

      “We wanted to build a professional-grade development environment for data warehousing and BI, and if you look around, you say, who has a professional-grade development environment? Visual Studio,” said Bill Baker, general manager for SQL Server Business Intelligence at Microsoft Corp.

      “So, its a natural for us to say, lets take Visual Studio and extend that so it becomes a full-fledged BI development environment,” Baker said.

      “And thats what weve done. So, we have all the team development aspects that Visual Studio has anyway, and bring that into this space. Then we add the editors for ETL [extraction, transformation and loading], for cubes, for KPIs [key performance indicators], for reports, et cetera, and just put all that into Visual Studio,” Baker said.

      Baker said SQL Server 2005, code-named Yukon, has three business intelligence servers—Integration Services, Analysis Services and Reporting Services—and each are extensible: “The method for extending them is code written in one of the languages written against the Common Language Runtime [CLR].” The CLR is a key component in Visual Studio 2005, code-named Whidbey.

      Indeed, Baker said, Microsoft made a bet by basing its whole BI stack on managed code.

      “Reporting Services is probably one of the most widespread managed programs out there in terms of adoption—there are well over 100,000 servers at this point,” Baker said. “And data is managed all the way from day one. So, it was a huge bet on our part.”

      “I have said many times to many people that the real Yukon story is BI,” said Andrew Brust, chief of new technology at Citigate Hudson Inc., New York. “This is really the release where Analysis Services grows up.”

      Brust said OLAP [online analytical processing] features in the upcoming SQL Server product “have been improved in a number of ways to make building and maintaining cubes much, much easier. The creation of the unified dimensional model concept and the addition of something called proactive caching make it far easier to get fast performance and real-time or near-real-time analytics in place.”

      /zimages/1/28571.gifRead more here about Microsofts upcoming release of Visual Studio 2005, code-named Whidbey.

      In addition, Brust said, data mining features in the new, yet-to-be-released version “have matured so much that the SQL Server 2000 Data Mining engine looks like a simple prototype by comparison. Several statistical algorithms have been added, as have a number of tools and features to allow measuring the absolute and relative accuracy of multiple mining models on the same data. This stuff makes it immediately feasible for all kinds of organizations to derive predictive capabilities from their transactional data.”

      For instance, imagine a retail chain being able to determine which demographics correlate to sales of specific products, Brust said. “Or imagine pharmaceutical researchers being able to correlate symptoms and inherited traits with positive prognoses of a drug working well or causing serious side effects,” he added, noting that SQL Server enables this.

      Moreover, on the reporting side, the new ReportBuilder functionality in Yukon “makes it feasible to deliver true ad hoc reporting capabilities to end users, without the usual limitations in query types and output formats,” Brust said.

      Reiterating the value of the Visual Studio integration, Baker said, “If you want to write an ETL package to tear apart some record format that we dont know about, you would typically use some of the VBScript, and that would be running the CLR,” Baker said. “The way you write the equivalent of a stored procedure in Analysis Services is to use one of the CLR languages. The way you write expressions in reports is to use, again, extensions, expressions that we actually compile into C#, although youre not too aware of that as somebody writing a report; but everything in terms of extensibility is done with the CLR, or languages that compile on top of the CLR.”

      Baker said Microsoft realized business intelligence will be led by applications.

      “If you really believe in the goodness of BI, and want to see it used in a very widespread way, you have to put it in the everyday apps; you have to put it in things people are going to use anyway,” Baker said.

      /zimages/1/28571.gifClick here to read more about the Microsofts delayed Yukon 3.

      Microsoft simply moved to meet user needs where an integrated environment for building BI applications had never existed, Baker said. “It had been a best-of-breed kind of space, so youd pick the architecture for your OLAP bench, and youd pick one of three or four vendors depending on which architecture you picked. Youd pick a porting vendor, et cetera. You wind up with six or seven parts and seven or eight development environments, and you have to kind of be the general contractor to put that all together.”

      The Yukon/Whidbey integration eliminates the need for this, he said.

      /zimages/1/28571.gifCheck out eWEEK.coms for the latest news, reviews and analysis in programming environments and developer tools.

      Avatar
      Darryl K. Taft
      Darryl K. Taft covers the development tools and developer-related issues beat from his office in Baltimore. He has more than 10 years of experience in the business and is always looking for the next scoop. Taft is a member of the Association for Computing Machinery (ACM) and was named 'one of the most active middleware reporters in the world' by The Middleware Co. He also has his own card in the 'Who's Who in Enterprise Java' deck.

      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
      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
      Cybersecurity

      How Veritas Is Shining a Light Into...

      eWEEK EDITORS - September 25, 2020 0
      Protecting data has always been one of the most important tasks in all of IT, yet as more companies become data companies at the...
      Read more
      Big Data and Analytics

      How NVIDIA A100 Station Brings Data Center...

      Zeus Kerravala - November 18, 2020 0
      There’s little debate that graphics processor unit manufacturer NVIDIA is the de facto standard when it comes to providing silicon to power machine learning...
      Read more
      Apple

      Why iPhone 12 Pro Makes Sense for...

      Wayne Rash - November 26, 2020 0
      If you’ve been watching the Apple commercials for the past three weeks, you already know what the company thinks will happen if you buy...
      Read more
      eWeek


      Contact Us | About | Sitemap

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Property of TechnologyAdvice.
      Terms of Service | Privacy Notice | Advertise | California - Do Not Sell My Information

      © 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.

      ×