リーズナブルソリューション
Exactly what is SQL Server 2008?
When you first install the product, what are all the pieces you get, what do they do, and which of them do you need?
At its core, SQL Server 2008 is an enterprise-class data-base management system(DBMS) that is capable of run-ning anything from a personal database
only a few megabytes in size on a handheld Windows Mobile device up to a multiserver database system managing terabytes of information.
However, SQL Server 2008 is much more than just a database engine.
The SQL Server product is made up of a number of differ-ent components.
This chapter describes each of the pieces that make up the SQL Server product and what role each plays.
Each of these topics is dealt with in more detail later in the book.
In addition, this chapter looks at the en-vironments that support SQL Server 2008 and SQL Server 2008 R2 and the features available
in each of the various SQL Server editions.
Why SQL Server 2008?
The following discussion is my point of view, and although it no doubt differs from that of others, the basis of the discussion holds true.
SQL Server faces competition from other databases, not only from other Microsoft products such as Microsoft Access and Microsoft Visual FoxPro,
but also from competitors such as Oracle, Sybase, DB2, and Informix, to name a few. Microsoft Access is found on a large number of PCs.
The fact that it is packaged with some editions of Office and has been around for a number of years in different versions of Office has helped make this database ubiquitous;
in fact, a great number of people actually do use the software.
Unfortu-nately, it does have its limitations when it comes to scalability,speed, and flexibility, but for many small, in-house systems,
these areas of concern are not an issue, as such systems do not require major database functionality.
What Is SQL Server 2008?
As you most likely know, SQL Server 2008 is primarily thought of as a Relational Database Management System(RDBMS).
It is certainly that, but it is also much more.
SQL Server 2008 can be more accurately described as an Enterprise Data Platform.
It builds on many of the features that had first been incorporated in SQL Server 2005,
while also expanding its offerings to include several improvements and additions.
Primarily known for its traditional RDBMS role, SQL Server 2008 also provides rich reporting capabilities, powerful data analysis, and data mining.
It also has features that support asynchronous data applications, data-driven Event Notification, and more.
The days of SQL Server being merely a departmental database are lomg gone. SQL Server can now easily scale to databases dozens of terabytes in size.
Database Engine
Database Engine is the primary component of SQL Server 2008.
It is the Online Transaction Process-ing(OLTP) engine for SQL Server and has received further enhancements since SQL Server 2005.
The Database Engine is a high-performance component responsible for the efficient storage,
retrieval, and manipulation of relation and Extensible Markup Language(XML) formatted data.
SQL Server 2008's Database Engine is highly optimized for transaction processing, but offers exceptional performance in complex data retrieval operations.
The Database Engine is also responsible for the con-trolled access and modification of data through its security subsystem.
The Relational Database Engine in SQL Server 2008 has many improvements to support scalability, availability, security, and programma-bility.
The following list is by no means a comprehensive list, but just a short overview of what's new in SQL Server 2008:
SQL Server Architecture
In older editions of SQL Server, you had to use many different tools depending on the function you were trying to perform.
In SQL Server 2008, the challenge for Microsoft was to avoid increasing the number of management tools while increasing the features and products that ship with SQL Server.
They accomplished this by creating one tool for business-intelligence development (Busineess Intelligence Development Studio-BIDS) and another for management of the entire platform,
including business intelligence and the database engine (SQL Server Management Studio) BIDS is based on a lightweight version of Visual Studio 2008.
A new end-user report development tool is also added-Report Designer. SQL Server envelops a large surface now.
It can act as a reporting tool and store your OLAP cubes. It can also perform your ETL services through SQL Server Integration Services.
Many people just use SQL Server for its classic use: to store data. SQL Server 2008 can run on Windows XP, 2000, Vista, and Windows Server 2003 and 2008.
Tools such as SharePoint and Office quickly integrate on top of SQL Server and can provide an easy user interface(UI) for SQL Server data.
This book covers administration on each of these tiers.
このサイトの推奨ブラウザ環境： 古いブラウザご使用の方へ
Copyright 2011 reasonable solution All Rights Reserved.