Navigation Links
Could Database Software Help Cure Alzheimer's and Save the Earth?

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.


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:
(Date:11/24/2015)... QUEBEC CITY , Nov. 24, 2015 /PRNewswire/ ... (the "Company") announced today that the remaining 11,000 ... Common Share Purchase Warrants (the "Series B Warrants") ... agreement were exercised on November 23, 2015, which ... Common Shares.  After giving effect to the issuance ...
(Date:11/24/2015)... ... November 24, 2015 , ... ... environment are paramount. Insertion points for in-line sensors can represent a weak spot ... InTrac 781/784 series of retractable sensor housings , which are designed to ...
(Date:11/24/2015)... ... November 24, 2015 , ... ... Inc., on being named to Deloitte's 2015 Technology Fast 500 list of the ... manufactures AcceleDent®, a FDA-cleared, Class II medical device that speeds up orthodontic tooth ...
(Date:11/24/2015)... 24, 2015 Capricor Therapeutics, Inc. ... the discovery, development and commercialization of first-in-class therapeutics, today ... Officer, is scheduled to present at the 2015 Piper ... a.m. EST, at The Lotte New York Palace Hotel ... . --> . ...
Breaking Biology Technology:
(Date:11/20/2015)... 20, 2015 NXTD ) ("NXT-ID" ... the growing mobile commerce market and creator of the ... , was recently interviewed on The RedChip Money ... this weekend on Bloomberg Europe , Bloomberg Asia, ... --> NXTD ) ("NXT-ID" or the "Company"), a ...
(Date:11/18/2015)... Nov. 18, 2015  As new scientific discoveries deepen ... and other healthcare providers face challenges in better using ... patients. In addition, as more children continue to survive ... adulthood and old age. John M. Maris, ... Hospital of Philadelphia (CHOP) . --> ...
(Date:11/17/2015)... November 17, 2015 Paris ... 2015.  --> Paris , qui ... DERMALOG, le leader de l,innovation biométrique, a inventé ... passeports et empreintes sur la même surface de balayage. ... et l,autre pour les empreintes digitales. Désormais, un seul ...
Breaking Biology News(10 mins):