( ), , (), , .
, , . .
- , . OLAP- .
OLAP- . , , OLAP- , ( ), , SQL-, .
SQL SERVER 2000
SQL Server 2000
. , . . , .
Microsoft SQL Server 2000 , (, , , () , ). , - . , , OLE Automation Visual Basic for Applications, , . - Microsoft , ANSI SQL ODBC.
|
|
Microsoft SQL Server 2000 Microsoft BackOffice, , . , -.
Microsoft SQL Server 2000 ; , . , , .
SQL Server 2000 .
, . , , , , . SQL Server 2000 . .
SQL Server 2000 Enterprise Edition SQL Server 2000 Standard Edition SQL Server 2000, () . , , SQL Server 2000, SQL Server 2000 Standard Enterprise Edition. - . (deployed and live) , , under development in testing in testing.
, , : Standard Enterprise Edition. , Standard Enterprise Edition , : Microsoft Windows 2000, Windows 2000 Advanced Server, Windows 2000 Datacenter , Windows NT 4.0 Windows NT 4.0 Enterprise Edition.
1. SQL Server 2000 Enterprise Edition : SQL Server , , SQL Server 2000. , Web OLTP . , -. , , SQL Server 2000 Standard Edition. , SQL Server 2000 Enterprise Edition: , /, , .
|
|
, Enterprise Standard Edition.
. Enterprise Edition. , Standard Edition, ( 64 ) ( 32). Enterprise Edition :
- ;
- 2 (RAM);
- (.. );
- System Area Networking (SAN) (, Compaq ServerNet II Giganet cLAN).
. Enterprise Edition , . Enterprise Edition :
- , , ;
- .
. , , Enterprise Edition , . , ( ) SQL Server 2000 Enterprise Edition. Enterprise Edition :
- , SMP (.. );
- , , , ( );
- , .
. OLAP Enterprise Edition , OLAP- , , . Enterprise Edition :
- OLAP;
- ;
- , OLAP (ROLAP) ;
- ;
- Web.
2. SQL Server 2000 Standard Edition , , , SQL Server 2000 Enterprise Edition. Standard Edition , 2 .
Standard Edition , , -. , XML, Enterprise Edition, Standard Edition. , OLAP Enterprise Edition, OLAP SQL Server 2000 Analysis Services Standard Edition. , , , Enterprise , Standard Edition:
|
|
- Data Transformation Services (DTS);
- (snapshot, transactional merge);
- ;
- English Query;
- ;
- SQL Profiler .
SQL Server 2000, :
3. SQL Server 2000 Personal Edition. , , , SQL Server, , SQL Server, . Standard Edition, .
4. SQL Server 2000 Developer Edition. SQL Server. Enterprise Edition, (EULA), .
5. SQL Server 2000 Evaluation Edition (SQL Server 2000 Enterprise Evaluation Edition) SQL Server 2000 Enterprise Edition, , , 120 . , Evaluation Edition ; SQL Server 2000 Enterprise Standard Edition. Evaluation Edition 120 . , .
6. Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) , . SQL Server CE SQL Server 2000 , SQL-. SQL Server CE SQL Server 2000, Windows CE . SQL Server CE . SQL Server CE , Windows CE 2.11 , .
7. SQL Server 2000 Desktop Engine (MSDE) Microsoft Data Engine 1.0 (MSDE), SQL Server 7.0. , Desktop Engine , , .. SQL Server. , SQL Server . Desktop Engine , SQL Server 2000. SQL Server 2000 Desktop Engine ; , .