Navigation Links
Could Database Software Help Cure Alzheimer's and Save the Earth?
Date:11/6/2008

Asteroid-watchers and protein researchers are showing that Microsoft SQL

Server 2008 can support applications at scales up to 1 petabyte.

REDMOND, Wash., Nov. 6 /PRNewswire-FirstCall/ -- Just three months after Microsoft Corp. released its data management and business intelligence platform, Microsoft SQL Server 2008, several large customers are using the database software to scale new heights in data warehousing and transaction processing.

(Logo: http://www.newscom.com/cgi-bin/prnh/20000822/MSFTLOGO)

SQL Server 2008 gives companies the flexibility of "scaling up" individual servers by adding processors or memory and "scaling out" their databases by adding more nodes to increase performance. Microsoft is also taking advantage of the latest hardware advancements and announced this week at the Windows Hardware Engineering Conference (WinHEC) 2008 that Windows Server 2008 R2 and the next release of SQL Server, code-named "Kilimanjaro," will support more than 64 processor cores. This will provide customers with the option to consolidate data sources while maintaining similar or improved performance and scalability. Either way, SQL Server literally grows with a business.

SQL Server 2008 offers "a robust, scalable and secure database platform to support critical business applications. Large multiterabyte databases with SQL Server have become common for both transactional applications and data warehouses, as enterprises build larger and complex databases," according to a report from Forrester Research, "SQL Server 2008 Ups Pressure on Competitors; Microsoft Boosts Manageability, BI, Performance, Productivity and Security," by Noel Yuhanna, Mike Gilpin and David D'Silva; Sept. 22, 2008.

Warehousing the Heavens

Perhaps the most impressive application of SQL Server so far -- and one of the most dramatic -- is the Panoramic Survey Telescope and Rapid Response System, or Pan-STARRS for short, a wide-field celestial imaging facility being built at the University of Hawaii's Institute for Astronomy. Its architects plan to photograph the entire available sky several times each month, trying to discover asteroids and comets that could pose a danger to Earth. The huge volume of images produced by this system will no doubt also prove valuable for many other scientific programs.

When Pan-STARRS is fully operational, it will have four telescopes, each with a digital camera capable of 1.4-gigapixel resolution. With just one telescope in operation so far, the facility already generates 1.4 terabytes of image data per night. For the longer term, its architects are installing 1.1 petabytes (quadrillion bytes) of disk storage. Although Pan-STARRS won't use up all of that storage right away, it will still rank as one of the world's largest databases.

Compressing, storing and crunching that data is the job of SQL Server.

"There are only a handful of databases that large in the world," said Ted Kummert, corporate vice president of the Data and Storage Platform Division at Microsoft. "If SQL Server can handle applications this large, imagine how well it can meet the needs of the average enterprise. SQL Server 2008 is packed with technologies to scale up individual servers and scale out very large databases."

From Astronomy to Biology

Valerie Daggett's world-renowned protein research lab at the University of Washington is near the Microsoft campus in Redmond, Wash. Her team is investigating one of the fundamental unsolved problems in molecular bioengineering: the mechanism by which proteins fold themselves from essentially two-dimensional polypeptide chains into precise, three-dimensional structures. Experts believe that incorrectly folded proteins may be responsible for some of the most menacing diseases of our era, including mad cow disease, Alzheimer's disease, Parkinson's disease, emphysema and cystic fibrosis.

Because experimental approaches provide only limited amounts of information about the actual folding process, Daggett Research Group employs computer simulations, which generate massive amounts of data that must be analyzed. The lab has already produced more than 64 terabytes of data and is generating an additional 15 terabytes a year.

By taking advantage of the relational and online analytical processing (OLAP) capabilities of SQL Server, the team has been able to attack problems in new ways and accelerate its rate of progress. "We've begun to address substantial questions that move us closer to solving the protein-folding problem and other biomedical problems," Daggett said. "With SQL Server, we can investigate questions that were practically impossible to answer before. We can examine 100 times more data because some tasks that used to take hours are now reduced to fractions of a second."

"Data-warehousing techniques have been applied widely in business and financial applications, but are much less common in scientific research," said Andrew Simms, a graduate student in the Daggett lab. "We think the current model will scale beyond 100 terabytes."

Founded in 1975, Microsoft (Nasdaq: MSFT) is the worldwide leader in software, services and solutions that help people and businesses realize their full potential.


'/>"/>
SOURCE Microsoft Corp.
Copyright©2008 PR Newswire.
All rights reserved

Related biology technology :

1. A new material could act as a nanofridge for microchips
2. New knowledge about thermoelectric materials could give better energy efficiency
3. Carbon molecule with a charge could be tomorrows semiconductor
4. Vaxfectin(R)-formulated Measles DNA Vaccine Could Address Unmet Need for Infants
5. New technique to compress light could open doors for optical communications
6. Nanosculpture could enable new types of heat pumps and energy converters
7. Discovery by UC Riverside physicists could enable development of faster computers
8. Carbon nanoribbons could make smaller, speedier computer chips
9. Commencement 2008: Student innovation could improve data storage, magnetic sensors
10. Melting defects could lead to smaller, more powerful microchips
11. Fiber-based nanotechnology in clothing could harvest energy from physical movement
Post Your Comments:
*Name:
*Comment:
*Email:
(Date:5/23/2017)... ... ... Cambridge Semantics , the leading provider of Big Data management and analytics ... in Boston May 23-25 with a featured speaker and solution demos of its ... also a finalist for the Best of Show award. , James LaPointe, Managing Director ...
(Date:5/22/2017)... (PRWEB) , ... May 22, 2017 , ... Stratevi, a ... expanded to the East Coast. It has opened an office in downtown Boston at ... are finding it increasingly more important to generate evidence on the value they provide, ...
(Date:5/22/2017)... ... May 22, 2017 , ... Cancer diagnostics and pathology workflow ... at the Association for Pathology Informatics Annual Summit at the Wyndham ... its Cancer Diagnostic Cockpit and Consultation Portal, Inspirata will present research it led ...
(Date:5/21/2017)... ... May 20, 2017 , ... CNSDose is a ... and error process by finding the right antidepressant faster. CNSDose speeds recovery ... relationship through a personalized approach to treatment. , A peer-reviewed and ...
Breaking Biology Technology:
(Date:3/30/2017)... March 30, 2017 The research team of ... three-dimensional (3D) fingerprint identification by adopting ground breaking 3D fingerprint minutiae ... realm of speed and accuracy for use in identification, crime investigation, ... cost. ... A research ...
(Date:3/24/2017)... 2017 The Controller General of Immigration from Maldives ... Algeen have received the prestigious international IAIR Award for the most ... Reading ... Maldives ... Abdulla Algeen (small picture on the right) have received the IAIR award ...
(Date:3/22/2017)... YORK , March 21, 2017 ... Marketing Cloud used by retailers such as 1-800-Flowers ... its platform — Product Recommendations and Replenishment. Using Optimove,s ... give more personalized product and replenishment recommendations to ... but also on predictions of customer intent drawn ...
Breaking Biology News(10 mins):