.

Скорость обработки запросов на SQL серверах

Язык: русский
Формат: реферат
Тип документа: Word Doc
76 805
Скачать документ

I?I?NOA?NOAI INA?OE OE?A?IE

EE?ANUeEEE OI?AA?N?OAO ?IAI? OA?ANA OAA*AIEA

Oaeoeueoao e?aa?iaoeee

Eaoaae?a oai?aoe/ii? e?aa?iaoeee

AEIONEIA EAAE?O?EAOe?EIA ?IAIOA

AAEEAA?A

Ia oaio : Oaeaee?noue ia?iaee caieo?a

ia SQL-na?aa?ao

Aeeiiaaaoeue: nooaeaio 4 eo?no

Aeeia
Iaaei Einoyioeiiae/

Iaoeiaee ea??aiee : annenoaio
Eiaaeue TH.A.

Aeioneia eaae?o?eaoe?eia ?iaioa aaeaeaa?a

?aeiiaiaeiaaia aei caoenoo a AeAE

I?ioieie ? 10, a?ae “25” o?aaiy 2000 ?.

Caa.eaoaae?e i?io. Aaeia TH.A

i Ee?a – 2000

CI?NO

1.Anooi………..………………………………………………………….2

2.Oaeaee?noue ?iaioe SQL na?aa?a…………………………………….5

2.1 Oaoiieia?y DAO…….………………………………………………6

2.2 Oaoiieia?y ODBC…..………………………………………………6

2.3 JSCRIPT……………………………………………………………..7

3. ?acoeueoaoe oanooaaiiy..…………………………………………….17

Aeniiaie………………………………………………………………..21

Nienie aeei?enoaii? e?oa?aoo?e…………………………………….22

*anoeia 1 : ANOOI

O na?o? no/anieo ?ioi?iaoe?eieo oaoiieia?e iniaeeai
aeae?ey?-oueny anana?oiy ia?aaea Internet. Iii?iei aeaiaioii a
oe?e ia?aae? ? na?aa?a aac aeaiieo. Naia ia na?aa??
caa??aa?oueny ?ioi?iaoe?y aei yei? iiaeooue io?eiaoe aeinooi
ei?enooaa/?. I?e ?iaio? ei?enooaa/a c aacith aeaiieo a Internet,
a?i iineea? caieo aei aace aeaiieoth oeae caieo noi?iiaaii ca
i?aaeeaie iiae SQL (Structured Query Language) – iiaa
no?oeoo?iaaieo caieo?a.

A ia?aaeao aeei?enoiaothoueny oae? SQL–na?aa?a ye Oracle,
Microsoft SQL Server, Sybase, dbase, Informix, Progress oa ?io?.
sse i?eeeaae SQL – na?aa?a a?cueiaii Microsoft SQL Server 7.0 .

Nenoaia MS SQL Server – oea aaaaoi??aiaaa nenoaia iai?io
aeaiieie a?ae ee??ioa aei na?aa?a, aeicaiey? noai?thaaoe ?
i?aeo?eioaaoe aace aeaiieo.

Ia a?ae?io a?ae aace aeaiieo i???ioiaaieo ia aaeee?
eiii”thoa?e oa i?i?-eiii”thoa?e, aei na?aa?ii? aace aeaiieo
ei?enooaa/? io?eiothoue aeinooi c? nai?o eiii”thoa??a, a ia c
aeiiiiiaith oa?i?iae?a. I?e oeueiio iaoai?cie ?iaioe SQL-na?aa?a
aeiiiiaaa? ?ica”ycoaaoe i?iaeaie, ui aeieeathoue o ?acoeueoao?
caa?iaiue aei aace aeaiieo aaaaoueio eiii”thoa??a, eiaeai c yeeo
iiaea iacaeaaeii caa?oaoenue aei ??cieo /anoei aace aeaiieo, ui
caa??aa?oueny ia na?aa??.

Ca”ycie nenoaie ee??io/na?aa? c eiii”thoa?aie-ee??ioaie
caaacia/o-?oueny /a?ac caniae ia?aaea/? aeaiieo ? aaciai?
iia?aoe?eii? nenoaie. Aeey oeueiai nenoaia ee??io/na?aa? MS SQL
Server 7.0 aeei?enoiao? aaoaeiaai? eiiiiiaioe IN Windows NT.

Na?aa?ia NOAAe MS SQL Server 7.0 aeiaaaey? aei ia?aaeaaeo
eiiiiiaio ie?ai? aeaiaioe na?a?na, oae? ye OLE-DB a?aeiia?aea?
ca ca”ycie oa oi?iaaaeaeaiiy ia”?eo?a aac aeaieo ? ODBC –
a?aee?eoee ?ioa?oaen aac aeaieo. Oe? eiiiiiaioe caaacia/othoue
o?niee ca”ycie iaiao?aeiiai i?ia?aiiiai caaacia/aiiy.

SQL Server 7.0 ia? aaaaoi ?ino?oiaio?a, i?ecia/aieo aeey
?ic?iaee ciai?oiueiai ?ioa?oaeno aace aeaieo. Ie??i iiae SQL
aeey caa??aaiiy, aea??ee aeaiieo iiaeia aeei?eoiaoaaoe aeiaeaoee
[i?eeiaeaiey] c a?ao?/iei ?ioa?oaenii ei?enooaa/a GUI. Oea
aeoaea ni?iuo? ?ic?iaeo aac aeaieo, oaaeeoeue ? ca”yce?a i?ae
ieie. C?o/ii aeei?enoiaoaaoe SQL Server ?acii c i?ia?aiaie aeey
?iaioe a Internet.

Oeaio?aeueiei eiiiiiaioii nenoaie SQL Server ? ?aeyoe?eia aaca
aeaieo oa ?? no?oeoo?a. A ?aeyoe?ei?e aac? aeaieo ?ioi?iaoe?y
i?aaenoaaey?oueny a aeaeyae? ?yaee?a oa noiaaoe?a. ?yaeee ia
aii?yaeeiaai?, e??i aeiaaeeo, eiee aeey oaaeeoe? noai?th?oueny
eeanoa?iee ?iaeaen. Naia no?oeoo?a iia?aoi??a caieo?a, c
aeiiiiiaith yeeo i?ioiaeyoue aeai?ea aeaieo c ?yaee?a oaaeeoe?, ia
caeaaeeoue a?ae oiai aii?yaeeiaai? ?yaeee /e i?.

*anoeia 2 : OAEAeE?NOUe ?IAIOE SQL SERVER 7.0

A i?ioean? ?iccaeoeo SQL Server i?e ?ic?iaoe? ee??ionueeeo
aeiaeaoe?a aeei?enoiaoaaeinue aeae?eueea i?aeoiae?a. ssae?ii
nenoaie caaaeaee aoa i?ioeanni? ia?iaee caieo?a, yeee i?aoethaaa
ia na?aa??. Caieoe ienaeenue ia iia? SQL aaiaeeeenue ?
ii?aoeueiaoaaeenue /a?ac oo?e?oe oeio Query Analyzer.

I?e iaienaii? i?ia?aiieo aeiaeaoe?a aeey aca?iiae?? c SQL Server
/ano?oa ca ona aeei?enoiaothoue :

DB-Library

ODBC ? DAO

DB-Library yaey? niaith niaoeeo?/iee aeey SQL Server ?ioa?oaen
i?eeeaaeieo i?ia?ai . A?i ? iaio c?o/iee i?ae ODBC, aeey ia?aiino
i?ia?aiiiai aeiaeaoeo a ?ioo na?aa?io nenoaio aea c oi/ee ci?o
i?aoeacaeaoiino? a?i ?aae?ciao? naiee oaeaeeee aeinooi aei
?ioi?iaoe??.

Oea caaacia/o?oueny ia o?eueee oei, ui a?i iaaea? iioei?ciaaiee
?ioa?oaen API, aea aeei?enoiao? a i?ia?aiao iniaenoo iiao
nenoaie SQL Server. ODBC (ye ? SQL-OLE ) iaaeathoue oaeee aea
??aaiue na?a?no aea noai?ththoue aeiaeaoeiaee ??aaiue aano?aeoe??
i?ae aeiaeaoeii ? oa i?ioeanni?ii caieo?a SQL Server .

A DB-Lib ia i?aeo?eio?oueny ca”ycie oaaeeoeue aai
aaoiiaoe/iiai iiiaeaiiy cia/aiue. Oea iiaeia ?icaeyaeaoe ye
iiceoea ine?eueee aa?aioo?oueny iiaiee eiio?ieue iaae aca?iiae??th
i?ia?aiiiai aeiaeaoeo c na?aa?ii ? iioei?caoe??th ca”yce?a.
Aeiaeaoeiai i?ia?ai?noo aeiaea?oueny iiaiee eiio?ieue iaae
aeyaaeaiiyi ? ia?iaeith iiieeie, iia”ycaieo c o?aicaeoe?yie.

2.1 OAOIIEIA?ss DAO

(Data Access Object – ia”?eoe aeinooio aei aeaiieo) i?eccia/aia
aeey aeei?eoaiiy ia”?eo?a, iaoiae?a, aeanoeaioae, cia/ii
iieaaooothoue ?iaioo i?ia?aiiiai aeiaeaoeo c aacith aeaieo. Aeey
iai?io ?ioi?iaoe??th c SQL na?aa?ii a ia”?eoao DAO
aeei?eoiao-thoueny ??ai? aeiooio Jet ? ODBC, iaeia aiie
ooai?ththoue ua iaeei ??aaiue aano?aeoe?? i?ae aeiaeaoeaie ?
aeeeeeaie ooieoe?e ODBC, ye? aeei?enoiaothoueny i?e ia?iaoe?
caieo?a.

Oaoiieia?y DAO aeey ?iaioe c aacaie aeaieo, oaaeeoeyie, aeaeaie
ia?aaeaa/a? aeei?eoaiiy eieeaeoe?e ia”?eo?a. Iai?eeeaae aeey
noai?aiiy iiai? oaaeeoe? eaaoa aeeeeeaoe iaoiae Add
a?aeiia?aeiiai ia”?eoa, i?ae aeei?enoiaoaaoe noaiaea?oiee i?aeo?ae
oaoiieia?? ODBC.

I?e ?iaio? c aacith aeaieo iiaeia aeei?enoaoe noaiaea?oiee
i?aeo?ae aeey aeinooio aei iaeaea aoaeue-yeiai noiaeua aeaieo,
ui i?aeo?eeio?oueny caniaiie ODBC.

Aea o?aaa a?aei?oeoe, ui oaoiieia?y DAO iinooiiai
aeo?niy?oueny a?eueo i?ia?aneaiith oaoiieia??th ADO(ActiveX Data
Object – ia”?eoe aeaio ActiveX ) .

2.2 OAOIIEIA?ss ODBC

C iaoith iiaeeeaiai anoaiiaeaiiy ca”yceo c ??cieie NOAAe
o??iith Microsoft aoea ?ic?iaeaia oaoiieia?y ODBC . Aiia
caaacia/o? noai?aiiy aeiaeaoeiaiai ??aiy aano?aeoe?? i?ae
i?ia?aiiei aeiaeaoeii ? NOAAe. Aeaiee ??aaiue aeicaiey? noai?eoe
iaeio eiiaiaeo Select ? aeei?enoiaoaaoe ?? aeey aeai?ee aeaieo
c aoaeue-yeeo i?aeo?eio?ieo oei?a aac aeaieo, a?aoiaoth/e o?
aeiaaeee, eiee NOAAe acaaae? ia i?aeo?eio? iiao SQL.

Neoaeae ODBC yaeythoue niaith ie?aiee ??aaiue aeinooio aei
oaee?a aac aeaieo. ODBC aa?a ia naaa a?aeiia?aeaeuei?noueca
io?eiaiiy a?ae aei-aeaoe?a caieo?a ia aea??eo ?ioi?iaoe?? ?
ia?aaaaeaiiy ?o ia iiao, ui aeei?enoiao? yae?i aaca aeaieo,
aeey ia?iaee caieoo. Aa?iei i?eeeaaeii aeei?enoaiiy ODBC
oaoiieia?? ? NOAAe Access o??ie Microsoft. Aieiaia ??cieoey i?ae
ODBC ? BD-Lib iieyaa? o oiio, ui ODBC aeiaaa? iiaoaeiae ?
ia?aaea/? eiio eeoa noaiaea?oieo SQL eiiaiae, a BD-Lib aeiaaa?
iniaeeaiai neioaeneno i?e iiaoaeia? o aooa?? eiiaiae, ui
iai??aaeythoueny aaciina?aaeiuei o na?aa?ia na?aaeiaeua.

Aieiaiei iaaeie?eii ODBC ? iaiao?aei?noue a o?aineyoe?? caieo?a.
I?iaaaeaiiy oe??? aeiaeaoeiai? ?iaioe a?aeiia?aeii
a?aeia?aaea?oueny ia oaeaeeino? aeinooio aei aeaieo. I?e ?iaio?
c ODBC iiaeia io?eiaoe nooo?aee aea?ao o oaeaeeino? ia?iaee
aeaieo, yeui a nenoai? ee?-?io/na?aa? naia ia na?aa?? nenoaie
SQL Server aoaea ia?iaeyoenue caieo, a ia ia ee??ionueeiio
eiii”thoa??. Oaeiae i?e??no o oaeaeeino? ?iaioe ODBC aea?
aeei?enoaiiy ano?i?iieo i?ioeaaeo?.

2.3 JSCRIPT

Oaia? ia?aeaeaii aei i?ioean?a, ui iia”ycai? c aei??thaaiiyi
oaeaeeino? nenoaie SQL Server 7.0 . O aeaii?e ?iaio? i?iiio?oueny
iaienaiiy i?ia?aiiiai aeiaeaoeo ia ano?i?iiiio shell OS Windows
NT – Java Script . Nai i?ia?aiiee aeiaeaoie oea i?ia?aia
iaienaia aeey ?ioa?i?eooth/a iiaa. Oaee c ?icoe?aiiyi . js
aoaea aeeiiaa/ei aeey OS Windows NT. Nii/aoeo iaieoaii Script
aeey noai?aiiy aace aeaieo :

// ADO Flags

var adLockOptimistic = 3;

var adOpenStatic = 3;

var SQL_DataBase = “DSN=OTSt;UID=sa;PWD=;DATABASE=OTSt”

//var SQL_DataBase = “DSN=OTStt;UID=;PWD=”

var oConn;

var oRs;

function db_Connect(){

// Create ADO Connection Object. Use IISSDK OBDC Souce with

// default sa account and no password

oConn = new ActiveXObject(“ADODB.Connection”);

oConn.Open(SQL_DataBase);

oConn.CommandTimeout=600;

}

function db_Record(SQL){

var oRs;

// Create ADO Recordset Component, and associate it with ADO

connection

oRs = new ActiveXObject(“ADODB.Recordset”);

oRs.ActiveConnection = oConn;

// Get empty recordset

oRs.Source = SQL;

oRs.CursorType = adOpenStatic; // use a cursor

other than Forward Only

oRs.LockType = adLockOptimistic; // use a locktype

permitting insertions

oRs.Open();

return oRs;

}

function db_Close(){

oConn.Close();

}

function db_Requery(Rec,SQL){

Rec.Close();

Rec.Source = SQL;

Rec.Open();

}

db_Connect();

try {

oRs=db_Record(“CREATE TABLE dbo.DBTEST ( String char (30) NULL, Number
int NOT NULL DEFAULT (0), Random int NOT NULL DEFAULT (0))”);

} catch (e) {

}

oRs=db_Record(“SELECT * FROM DBTEST WHERE 0=1”);

for(i=0;i ‘ User10000 ‘ ) ” ,
50);

Test(12 , “INSERT INTO DBTEST (String,Number)

VALUES(‘User30’,30) ” , 50 );

Test(13 , “DELETE FROM DBTEST (String,Number)

VALUES(‘User30’,30) ” , 50);

Test(14 ,” DELETE FROM DBTEST ” , 1);

db_Close()

Aieiaia ooieoe?y Test o oeeee? 50 ?ac?a iineea? caieo ia
na?aa?, ia?aoiao? ??cieoeth i?ae ii/aoeii ia?iaee caieoo ? /anii
cae?i/aiiy ia?iaee :

StartTime=new Date();

« ia?iaea caieoo »

EndTime=new Date();

Delta=(EndTime – StartTime);

O inoaiiueiio script ia?ii 14 oano?a aeey oanooaaiiy ??cieo
iiaeee-ainoae SQL Server. ?icaeyiaii ?o aeieeaaei?oa .

Oanoe 12 ? 13 oa?aeoa?ecothoue oaeaee?noue anoaaee ?
aeeo/aiiy aeaiaio?a o aac? aeaieo.

Oano 14 cieuo? onth oaaeeoeth.

Caieoe ia aea??eo ?ioi?iaoe?? :

Oano 1:” SELECT * FROM DBTEST ” – aeae?eeoe an? aeaiaioe
;

Oano 2: ” SELECT * FROM DBTEST ORDER BY String”
-a?aeni?ooaaoe on? aeaiaioe ca cia/aiiyi o noiaa/eeo “String”;

Oano 3:” SELECT * FROM DBTEST ORDER BY Number”- a?aeni?ooaa-oe
on? aeaiaioe ca cia/aiiyi o noiaa/eeo “ Number ”;

Oano 4:”SELECT Sum(Number) FROM DBTEST GROUP BY String”

– neeanoe on? aeaiaioe noiaa/eea “ Number ” ca cia/aiiyi o
noiaa/e-eo “String”;

Oano 5:” SELECT Sum(Number) FROM DBTEST GROUP BY

Random” – neeanoe on? aeaiaioe noiaa/eea “ Number ” ca cia/aiiyi
o noiaa/eeo “ Random ”;

Oano 6:” SELECT * FROM DBTEST WHERE Number = 99999 ” –
aecia/eoe on? aeaiaioe, o yeeo cia/aiiy o noiaa/eeo “ Number ” =
99999;

Oano 7:” SELECT * FROM DBTEST WHERE String = ‘User99999′” –
aecia/eoe on? aeaiaioe, o yeeo cia/aiiy o noiaa/eeo “String “ =
‘User99999’ ;

Oano 8 : “SELECT * FROM DBTEST WHERE Number in (SELECT
Number FROM DBTEST ) ” – aecia/eoe on? aeaiaioe c iiiaeeie
/enae ;

Oano 9 :”SELECT * FROM DBTEST WHERE Number in (SELECT

Number FROM DBTEST WHERE String ‘ User10000 ‘ ) “- aecia/eoe on?
aeaiaioe c iiiaeeie aeaiaio?a, o yeeo cia/aiiy o noiaa/eeo “String
“ > ‘ User10000’ ;

*anoeia 3 : ?ACOEUeOAOE OANOOAAIIss

Aeey iaaaaeaiiy i?eeeaaeo oi?aa?naeueiino? i?e aeei?enoaii?
iaienai-iiai script i?e aei??thaaii? oaeaeeiae??, aei??y?ii
oaeaee?noue ia?iaee caieo?a o nenoai? SQL Server 7.0 oa
Microsoft Access 97.

Uia script ni?eeiaany nenoaiith Access aac noia?a/aiue o?aaa
ci?ieoe ia?aiao?e ?aeaioeo?eaoe?? :

//var SQL_DataBase = “DSN=OTSt;UID=sa;PWD=;DATABASE=OTSt”

var SQL_DataBase = “DSN=OTStt;UID=;PWD=”

Io?eiai? ?acoeueoaoe i?eaaaeaii o oaaeeoe? :

Oano ? SQL Server 7.0 Access 97

1 2,673 1,81

2 7,781 5,603

3 7,356 5,211

4 8,239 7,54

5 0,903 0,494

6 0,345 0,231

7 0,390 0,287

8 11,207 7,11

9 3,843 2,53

10 0,655 0,507

11 11,469 9,816

12 0,3 0,285

13 0,31 0,22

14 55,62 34,324

sse aeaeii c ?acoeueoao?a i?iaaaeaiiiai aei??thaaiiy caieoe ia
eieaeuei?e aac? aeaieo Access ii?aoeueiaothoueny cia/ii oaeaeoa
i?ae ia na?aa??.

Aiae?coth/e caieoe 2 ? 3, 4 ? 5, 6 ? 7 aa/eii, ui ia?iaea
aeaiaio?a ??cieo oei?a o iaeiaeiaeo caieoao ia? ??ciee /an.

Oae iai?eeeaae ni?ooaaoe on?o aeaiaio?a ca cia/aiiyi o
noiaa/eeo “String” ii?aoeueiao?oueny iia?euei?oa i?ae o noiaa/eeo
” Number”- i?e/eia o ?ici??o aeaiaio?a oeeo oei?a.

Oaae naia i?e ia?iaoe? caieo?a 4 ? 5 i?e noioaaii?
aeaiaio?a noiaa/eea ” Number” ca aeaiaioaie noiaa/ee?a “ String ”
? ” Random”.

Noiaa/ee “String ” caa??aa? cia/aiiy oeio String ? noiaa/ee
”Random”

caa??aa? cia/aiiy oeio Integer, aeaiaioe oei?a iathoue ??ciee
?ici?? ? ia?iaeythoueny c ??ciith oaeaee?noth.

?icaeyaeath/e oaeaee?noue ia?iaee iiiaeei aeiaio?a cacia/eii, ui
/ee a?eueoa aeaiaio?a ia?iaey? na?aa? o aac? aeaieo oei
a?eueoa /ano ia oea eaea. Oae iai?eeeaae caieo 10 ia iiooe o
aac? aeaieo aeaiaioa oeio String – ‘User50000’ ccaeia? iaaaaaoi
iaioa /ano i?ae iiooe aeaiaio?a, ui iaioa ‘User50000’. Oaeeo
aeaiaio?a i?eaeecii 50 oeny/ ? ?o iiooe caeia? aeineoue aeiaaee
/an. Iiooe aeaiaio?a, ui a?eueoa ‘User10000’ caeia? o na?aa?a ua
a?eueoee /an.

Caieoe 12,13 aecia/athoue /an caianaiiy aei aace iiaiai ?yaeea
? aeeo/aiiy ?yaeea c aace aeaieo.

I?iaiaey/e iaaaaeai? aeine?aeaeaiiy ca ?iaioith na?aa?a ie
io?eio?ii iiaio oa?aeoa?enoeeo eiai ?iaioe.

Aeei?enoa?ii iaaaaeai? aeua i?ia?aii? aeiaeaoee ? i?iaaaeaii
aei??e ia ?ioeo SQL-na?aa?ao. Ii??aiy?ii oaeaeeino? ?iaioe SQL
Server 7.0 ? Oracle 8 :

Oano ? SQL Server 7.0 Oracle 8

1 2,673 2,71

2 7,781 8,06

3 7,356 8,09

4 8,239 8,75

5 0,903 1,041

6 0,345 0,4

7 0,390 0,432

8 11,207 11,917

9 3,843 4,05

10 0,655 0,78

11 11,469 12,021

12 0,3 0,295

13 0,31 0,291

14 55,62 43,134

sse aeaeii c ?acoeueoao?a SQL Server 7.0 i?aoeth? oaeaeoa ca
Oracle 8 i?e ia?iaoe? aea??ie, a i?e anoaaoe? ? aeeo/aii?
aeaiaio?a o Oracle e?ao? ?acoeueoaoe. Oea iiaeia iiynieoe
??ciith aoaeiaith yaea? ia?iaee caieo?a.

I?iaaaeaii oae?ae cai??e ? aeey SQL na?aa?a Informix.

Oano ? SQL Server 7.0 Informix

1 2,673 2,11

2 7,781 6,932

3 7,356 7,138

4 8,239 7,934

5 0,903 0,856

6 0,345 0,456

7 0,390 0,471

8 11,207 13,04

9 3,843 4,41

10 0,655 0,748

11 11,469 12,814

12 0,3 0,315

13 0,31 0,31

14 55,62 51,48

Ii ?acoeueoai aeaeii, ui SQL Server 7.0 i?aoeth? iia?euei?oa
ca Informix i?e ia?iaoe? i?inoeo caieo?a, a i?e iiooeo ?
ii??aiyii? aeaiaio?a i?aoeth? oaeaeoa. Ia caieoao ii anoaaoe? ?
aeeo/aii? aeaiaio?a o Informix ? SQL Server 7.0 iaeaea iaeiaeia?
?acoeueoaoe.

Oaeei /eiii ie aeinyaee iaoe aeaiii? ?iaioe – iiaoaeoaaee
i?ia?aii? aeiaeaoee, yeeie ciiaee aecia/eoe oa?aeoa?enoeee
i?aoeacaeaoiino? ??cieo na?aa?ieo aac aeaieo.

AENIIAIE

A ?acoeueoao? i?iaaaeaiii? ?iaioe aoei ?icaeyiooi ??ci?
oaeoi?e, ui aieeaathoue ia oaeaee?noue ?iaioe nenoaie SQL Server
7.0.

Aoee iaienai? aea? i?ia?aie, ui aeathoue ciiao aei??thaaoe
oaeae-e?noue ia?iaee caieo?a aaaaoi??aiaaith na?aa?iith nenoaiith
Microsoft SQL Server 7.0 ? oei naiei aeathoue iiaeeea?noue
aeine?aeaeoaaoe aoaeoeai?noue iano?ieee ia?aiao??a nenoaie,
aeathoue ciiao ioe?ieoe iioeiaeuei?noue iiaoaeiae aace aeaieo,
iioeiaeuei?noue aeei?enoaiiy ?iaeaen?a, i?aaee, iaiaaeaiue,
aoaeoeai?noue ?iaioe c o?aicaeoe?yie.

Aoee ?icaeyioo? neeuei? ? neaae? aiee oaoiieia?e ?iaioe c
i?ia?aiieie aeiaeaoeaie – DB-Library oa ODBC c DAO.

sse i?eeeaae ?iaioe i?ia?aiieo aeiaeaoe?a io?eiai? aeai? i?i
oaeaeeiae?th nenoai aac aeaieo SQL Server 7.0 oa Microsoft Access
97.

Ii??aiyi? ?acoeueoaoe canoinoaaiiy i?ia?aiieo aeiaeaoe?a o
nenoaiao SQL-na?aa??a oaeeo ye Oracle oa Informix c oaeaee?noth
?iaioe Microsoft SQL Server 7.0.

Aeei?enoiaoth/e iaienai? script-e i?ia?ai?noe ? ?ic?iaieee
nenoai aac aeaieo oeio ee??io/na?aa? iiaeooue aecia/aoe
oa?aeoa?enoeee noai?aieo ieie nenoai c oe?eeth aiae?co ?
oaeineiiaeaiiy.

NIENIE AEEI?ENOAII? E?OA?AOO?E :

“Aeei?enoaiiy Microsoft SQL Server 7.0” Noaoai A?ieii

aeae. Iineaa 1999 ?.

“ Teach Yourself Oracle 8 In 21 Days” Cary N. Prague

“ Nae?aou Access 97” Oeeueyi Aii ecae.Aeeaeaeoeea 1997?.

“ Oaoiieia?y Java” Aeaei Aaaa? aeae. “BHV” 1996 ?.

AEo?iae “PC World” ? 3,7,8 ca 97 ?., ? 1,9 ca 98 ?.

www.techrepublic.com

PAGE 15

Нашли опечатку? Выделите и нажмите CTRL+Enter

Похожие документы
Обсуждение

Ответить

Курсовые, Дипломы, Рефераты на заказ в кратчайшие сроки
Заказать реферат!
UkrReferat.com. Всі права захищені. 2000-2020