Microsoft's Future "Soul"--sql Server 2005 Secret

Source: Internet
Author: User
Tags file system microsoft sql server new features query web services sql server management
server| Microsoft Killer Code "Yukon" Www.yestar2000iTbulo.comuYGqwqB


It's been 15 years since Microsoft released SQL Server 1.0 in 1989, and in the 15-year SQL Server, from scratch, from small to large, has gone through the legends of time and time again. It eats into the market share of IBM and Oracle databases, and the next generation of SQL Server is becoming the core of the future of Windows operating systems. And in the mouth of Bill Gates's repeated "seamless computing" is the core of Yukon, the code name "Yukon" Next Generation database will be
What kind of a world do you bring us into? Www.yestar2000iTbulo.comuYGqwqB


The "soft" pillar of the Internet Www.yestar2000iTbulo.comuYGqwqB


In today's network era, data search, data storage, data classification and so on all of these have become the Internet network of the "soft" pillar, and the database system is the most critical of this pillar. If there is no database support, we simply can not find the information we need in Google or Baidu, and can not use fast and convenient e-mail, but said that the network world is completely a large database composition. Www.yestar2000iTbulo.comuYGqwqB


According to IDC's latest data, the global database software market appears to be on the rise, with revenues of 2003 reaching $13.6 billion trillion, up from $12.6 billion in 2002. Oracle, IBM and Microsoft currently control 75% of market share. Oracle's market share last year was 39.8%,IBM 31.3%, and Microsoft was 12.1%. Www.yestar2000iTbulo.comuYGqwqB


So what is a database? In the university's computer textbooks, the database is interpreted as follows: The database is a specialized system for managing data resources in the computer application system. There are many forms of data, such as text, digital, symbols, graphics, images, and sounds. Data is the object to be processed by all computer systems. One familiar approach is to make documents, the process of processing into a program file, the data involved in accordance with the requirements of the program to organize data files, using program files to call. The data file maintains a certain correspondence with the program file. With the rapid development of computer applications, this document-style approach is inadequate. For example, it makes the data common poor, not easy to transplant, in different files to store a large number of duplicate information, waste storage space, update inconvenience and so on. The database system can solve these problems. The database system does not start with a specific application, rather, it is based on the management of the data itself, which keeps all the data in the database, organizes it scientifically, and uses the database management system as an intermediary to interface with various applications or application systems to make it easy to use the data in the database. Www.yestar2000iTbulo.comuYGqwqB


This description is indeed very detailed, but you may look dizzy, in fact, simply said that the database is a group of data after the computer, stored in one or more files, and the management of the database software is called the database management system. A general database system can be divided into databases (database) and Data management system (DB Management System,dbms) two parts, all of which constitute the Internet "soft" pillars of all. Www.yestar2000iTbulo.comuYGqwqB


Microsoft SQL Server as one of many database software, after upgrading from 6.5 to 7.0 version, began to gradually become mainstream database software, and SQL Server 2000 proved that the Windows operating system can also afford high-end data applications, As a mainstream database management software for business applications. It breaks the myth that UNIX dominates large database software, and how will a new generation of SQL Server 2005 change? Www.yestar2000iTbulo.comuYGqwqB


Direct hit Yukon core secret Www.yestar2000iTbulo.comuYGqwqB


In the next version of Microsoft SQL Server (code-named Yukon), consider more about the future development of the database and the programming capabilities of SQL Server. Developers within Microsoft have long been aware of the need to introduce more unified programming models in the future and to provide more flexibility for different data models. The unification of programming models means that ordinary data access and manipulation tasks can be done in a variety of ways, such as you can choose to use XML or MICROSOFT.NET framework or Transact-SQL (T-SQL) code. Www.yestar2000iTbulo.comuYGqwqB


The result of this program is a new database programming platform, which has been extended in many ways. First, the host. NET Framework the functionality of the common language runtime (CLR) extends the database to the realm of procedural programming and managed code. Second,Www.yestar2000iTbulo.comuYGqwqB


. NET Framework hosting integration provides powerful object database capabilities from within SQL Server. Deep support for XML is implemented through a full-featured XML data type that has all the functionality of a relational data type. In addition, server-side support for XML query (XQuery) and XML Schema definition language (XSD) standards has been added. Finally, the SQL Server Yukon contains important enhancements to the T-SQL language. Www.yestar2000iTbulo.comuYGqwqB


The history of XML in the SQL Server Yukon actually starts with SQL Server 2000. SQL Server 2000 introduces the ability to return relational data in XML format, loads and splits XML documents, and exposes database objects as xml-based Web services, but Yukon provides more advanced XML query capabilities, The improved Yukon will give full play to all the benefits of XML. Why is XML so critical? In fact, XML has evolved from an initial alternative HTML representation to a line format and is now viewed as a storage format. Persistent storage in XML has aroused widespread concern, and many applications of XML data types have appeared on the Internet. XML itself is a data representation format that spans any system platform, originally used as a document format, and as XML is widely recognized in large enterprises, users begin to use XML to solve difficult business problems, such as data integration. This makes XML, as a data storage format, evolve to this day, and as XML can show the same effect on any platform, XML is becoming a mainstream storage format for databases. Yukon's built-in support for XML will spark a new database technology revolution. Www.yestar2000iTbulo.comuYGqwqB


These new programming models and enhanced languages together create a series of programmability that complements and expands the current relational database model. The end result of this architecture is the ability to create more scalable, more reliable, more robust applications, and to improve the productivity of developers. Another result of these models is a new application framework called the SQL Service Broker-a distributed application framework for asynchronous messaging. Www.yestar2000iTbulo.comuYGqwqB


Yukon joined the century gambling Www.yestar2000iTbulo.comuYGqwqB


Before we ramble about a lot of technology application advantages, you may be very curious at this time, why should we introduce such a seemingly high-end application of the database software technology? Maybe now we should solve the mystery. Www.yestar2000iTbulo.comuYGqwqB


The richest man on Earth predicted the future of the computer, and he thought that in the future, every ordinary computer would have a big enough super hard disk, and by that time our hard drive would be 80GB, probably 80TB, though just a GB of TB, But that means a 1000 times-fold increase in the size of the hard disk. With the NTFS format of the existing Windows storage hard disk data, it is impossible to cope with such a large hard drive data search capability. To say an image example, if you are using Windows XP at that time in a computer with 100TB hard disk space, it is likely that the time you need to defragment your disk is two days and nights, and if you're looking for a file, you'll have to wait a few hours. It feels like a return to the age of 286. Www.yestar2000iTbulo.comuYGqwqB


To address this thorny issue, the next-generation Windows operating system Longhorn decided to adopt a radically different programming model from previous Windows. Its core is Avalon (development code). Avalon is a new GUI library for Windows. The new Longhorn imports new features of indigo (Web Services) and WinFS (file system). Including Avalon, these three new features are called WinFX. WinFX is a new "local" API for Longhorn. Although it is added to be compatible with the current Win32 API, it is generally necessary to use WinFX in order to use the new functionality of Longhorn. WinFX belong to the current. NET framework extension. The classes used in the. NET Framework are also available in the WinFX, and the WinFX support programs run the same mechanism as. NET. Www.yestar2000iTbulo.comuYGqwqB


The. NET framework will perform a major version upgrade (Major Versionup) when it supplies SQL Server Yukon, with a specific date expected at the end of 2004. Yukon will run on the. NET framework. class libraries for the. NET framework can be used in the storage process (Stored procedures). The. NET Framework running in Yukon is version 2.0 and will append the multimedia-related classes not currently available in the. NET Framework 1.1. The WinFS uses Yukon engines. In other words, in Longhorn, the file system will use the database engine. Www.yestar2000iTbulo.comuYGqwqB


Do you understand this time, the next generation of Windows operating system, the entire file data management will introduce the structure of SQL Server management, then, our computer data query capabilities, data integration capabilities will be greatly improved. Of course, this is a crucial step for the rich to keep talking about "seamless computing," and for Microsoft, the project of integrating database software and operating systems is a big gamble, and if it succeeds, Microsoft will become a database hegemon, but if it fails, This will almost even slow down the next generation of Windows ' normal listing schedule.



Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.