Лабораторная работа №8 / Лабораторная работа №8
.pdf11
Cache Direct Access - ,
.
|
|
||
. |
|
|
|
|
|
, |
|
|
Cache |
|
.
Cache SQL - ,
SQL. Cache SQL SQL 92. ,
.
Cache .
Cache
.
Cache Objects - ,
Java, Visual C++, VB ActiveX-
, PowerBuilder Delphi. Cache
ODMG (
– Object Database Management Group).
Cache (
), .
|
|
- |
||
|
, |
|
|
|
|
|
, |
( |
) ( ). Cache,
, -
( Rational Rose)
, (Java, C++, Delphi, VB). Cache
, ,
12
. ,
.
, Cache
, , |
SQL. |
, DDL- |
|
, Cache
, .
,
.
. Cache ,
. ,
-
(VB, Delphi, C++),
–
(Seagate Info, Cognos, Business Objects).
|
|
|
|
|
, |
|
|
||
, SQL, |
|
|
||
. |
|
1-2 .
ResultSet
ResultSet – ,
Cache ObjectScript, Java ActiveX
, .
13
Cache ObjectScript ResultSet
%ResultSet.
ResultSet
.
. ResultSet
:
1.ResultSet %New().
QueryIsValid().
2.: ,
GetParamCount(); GetParamName(Position) –
. Execute() .
3.Next() .
, ; (
) .
Data(Columname). ,
.
5..
:
üResultSet;
üClose().
, – –
SQL – .
14
1.CachePatient. .
1.
1 – .
2. , . 2-4.
2 – .
15
3 – .
4 – SQL ( Patient).
COS.
. 5.
16
5 – COS.
3. Patient:
üFIO – ;
üDOB - ;
üHalf - ( );
üGrowth – ;
üWeight – ;
üDiagnosis – ;
üState – ( ).
,
. 6. , . 7-9.
6 – .
17
7 – .
8 – (%String – ).
%Date –
, %Integer – , .
18
9 – ( – ,
).
10 – (MaxLen –
– 100 ).
– .
19
11 – .
:
20
4.(Ctrl+F7). ,
, , .
5..
CSP – .
12 – CSP – .
6.« » « ».
.