. , , ,

,,,

— ,

1 .

. , X , Y , , . , .

 - . :

  1. .

  2. .

  3. ( ).

  4. .

  5. ( ). , . ( ). 2. :

  1. , .. ( ), . , , , , .

  2. .

  3. .

, , . . , . .

  1. -

  1. -

, . . :

  • ,

  • , ,

  • ,



2 .

() , -, .

, , , -. , , .. . 3- -:

  • ;

  • ;

  • ;

  • ;

  • .

Delphi. , :

DCOM , . Windows NT Server Windows 2000 Server

MTS ( Microsoft)- COM, .

DCOM, MTS :

  • , , ;

  • , , ;

  • , ; , .

+ ( ) Microsoft Windows2000 MTS COM.

TCP/IP ( / ) , .

CORBA ( - ( ) ) , .

SOAP ( ) Web- XML HTTP.

, .

Delphi , DataSnap .

3 -.

, , .

.

- , , , .

- , .

() , . (, . .).

() .

, :

1) , .

2) , .

3) , , .

. (, , ). -.

: . , , . , -, . , .

. :

, ;

. " - ".

"-", . .

. , - , , .

,



1 . .

:

t = n+ l,n + 2,..., n+i,... ,

i = 1,2,... - ,

( ) . , . . , , , , , , .

, K(i), i - ; . .

. ( , ; , .). , .

. ( , ; , , , .), .

. , R-( R 0 1, ; , R 1; ) 1. Microsoft Excel R- .

- , , , . 95%. , , .

2 Delphi.

, : ( ), .

.

:

- Class Object Pascal.

- Component (Class) Delphi.

- Control ( ) , , , Windows.

OC Windows. , Windows (Standart, Addition, Win32).

.

, .

.

VCL.

Tlist , .

Tstring .

Tcanvas, Tgraphic, Tgraphicobject, Tpicture

Tpersistent .

.

, .

- ,

- .

Tcomponent :

  1. Name: TcomponentName , .

  2. Tag: LongInt: - .

  3. Owner: Tcomponent () , .

3 , ,

(CPU, . Central Processing Unit) , , , .

:

- ; ; ; ; ( 8 512 ); .

. , , . - , .

Intel - 8088, 80286, 80386SX, 80386, 80486 Pentium1-4, Athlon, Duron, Celeron, Cyrix, AMD . - , .

- , () . (). , , , .

, - . 1965 ., , .

.

. . . . -.

, , . . .

, . . . , .

4-, 4 . . 70 . 8- . IBM 16- . Intel 80386, 32-, , 16- . Intel 64-, , 64- .

, .

, . , . .

, , . , Pentium III-IV, AMD Athlon , , , .

- , , , .

- , . - . - . - , - , . Pentium II-III-IV Celeron , , , - .

, AMD Intel , .


1 ( -).

. . .

- ( ) . : 0 1. , , , .. . , , .

( -) :

 - ;

P ;

N .

N,

(1 - ) , ;

(1 - ) N , N .

N

(19)  . . , . . () , F . .

2 . . .

, . . . , () . ,

. . , . , . , . , .

. . .

. . , . . , . .

. , : , ' . . (marshalling).

, . , . . .

, . . , (monikers). . . , . . , .

, , , .

. -, , . "I". . -, (Globally Unique IDentifier, GUID), , . IID (Interface Identifier).

. .

lUnknown. , .

Queryinterface , IID . , Null.

IUnknown . , . , . , . , , , . AddRef lunknown. Release lunknown. . .

3 : .

- (Cache Memory) , , RAM.

- DRAM ( Wait State). RAM (), . -. - SRAM, 5-20 . .. , , , ( 512 ). , PC 386. DRAM - SRAM. - .

- (L2 Cache Level 2 Cache ) ( Pentium Pro, L2 Cache ). SRAM i80386, -. 2 . - (L1 Cache Level 1 Cache ) ( i80486 i80386) 8, 16, 32 . - : 1. WT ( ), , , . . .

2. WB . , , , , (dirty), , . ( ) (clean), . . , , WT.

-: (direct-mapped cache), (fully associative cache) - - (set-associative cache).

1. , , , . , = - , - , .

2. . . . 3. - , . , . , , . . , -.

1 . .

, , ( - 1 , 1 ). ( ), . + = , . :

  1. ,

  2. - , . , .

, . S n L ( l, r ) P S - ; n - ; L ;  - ; ( l, r ) ; P .

3 :

  2. :

  3. - ,

:

  1. . .

  2. : , , , , . () + + . = + +

, , , , , , . , , . , . , , . , , 1 , . , . , , . , . . . , , , . , , 1- ( , , - - 1 , 1 ) .

  1. , , (2 : ).

, , , .

. . . , , , , . . , , , , . , , . - , .

2 Automation. .

OLE (Automation) , .


COM Automation

IUnKnow

IDispatch

, , --- .

, , , .

, .

Idispatch .

Invoke. Function Invoke (DispId: integer; Const Iid: TGId; Locale ID: integer; Flags: word; var params; var Result, ExceptInfo, ArgErr: Point):Integer;

, DispId , , .

LocaleId Id.

Flags . .

Params TdispParams .

VarResult OLEVariant .

Exceptinfo , DispEException.

ArgErr , .


3 .

-, . - . ( 1- ) .

y = y(x) (1) (. 1- . -)

y = a + bx (2)( , .. 1- , b ).

( (2)) : = a + bx + e, e , .

:

  1. .

  2. .

.

. X=(x1, x2, ..., xn), f=f(x1, x2, ..., xn) () , x1, x2, ..., xn g1(x1, x2, ..., xn)=0, ... , gn(x1, x2, ..., xn)=0.

, .

F=f(x1, x2, ..., xn)+1g1+2g2+...+mgm, 1, 2, ..., m .

F. x*1, x*2, ..., x*n *1, *2, ..., *m, () () .

Microsoft Excel . , . , (. ).

*1, *2, ..., *m x*1, x*2, ..., x*n , .

(1) - , -

. x () .

() , . , .

. , . , , . .

n- .

( )

1 .

. , X , Y , , .

, .  - .


:

  1. .

  2. .

  3. ( ).

  4. .

  5. ( ).

, . ( ).

:

  1. . , , , , .

  2. .

  3. .

, , . .

: , , , , , , ; , ;


2 .

. :

- ;

- ;

- ;

- .

, .. .

.

, , :

1) , , .

2) . , " ".

3) , , . , , n-.

4) ,, ( ), ..

, .. .

5) , ( ). , : . , .

3 : , , , .

VCL. . , , - , .

- . , , . , , 2 , . TEvent 2 (Set Event Reset Event).

- . , . , .

( , , , .) , , 2 :

  1. .

  2. , . , -.

, , , . .

. , , . , . , , .

:

    • Proc.Suspend

    • Proc.Terminate

    • Execute ( )

    • Resume , true suspend;

    • Destroy ;

    • WaitFor , .

    • FreeOnTrminate true, .

    • Synchronize protected, .. Tthread, - VCL , . VCL

Constructor create creat Suspended , =true, , Resume. false .

1 . .

: X Y, Y X, X Y. (X -> Y) . . :

  1. , , -> .

  2. , A -> B, -> .

  3. , A -> B B -> C, A -> C.

( ).

:

  1. , .

  2. XY , Y X. .. X+ZY, XY, ZY.

XY , Z, XZ ZY ZX. , . , . ( S#, P#) -> S#. .

2 : , , , .

, . . , , .

:

  • - , ;

  • - , , .

- , , , .

Intel 80x86 256 , :

, (faults), , , . .

(, 8087/80287). (NMI) (INTR). NMI , , , .

- (I) 8259. -, INTR. I , .

. INT. MS-DOS 20 3FH. BIOS, , IBM PC , . .

. , , ( ), (CS) (IP) . 8- , , .

, INT. , , .

3 . .

:

  1. . - .

  2. , .

  3. , PS ( ), , , .

.

  1. WS 16.

  2. .

  3. VCL (. -- - ) VCL .

, . . , . , . , () , , Windows 95 Windows NT .

. , MS Office . Word , ; Excel . , /. , .

.

, , . , , , .

, , , , .

, , . .

  1. , 2 .

  2. , , .

1 .

.

- , , . . . (, , , , .. , ). , . ,

: 1) (,,,,) (), , . . 2) , (,, F,G,C,D,E). . , , , , , . .

: . , , . , . , . . , . . (, , , , .. , ). , . , . , .

2 OLE DB. ADO.

, , (Universal Data Access, UDA), :

Microsoft Open DataBase Connectivity, ODBC;

OLE DB;

Microsoft ActiveX Data Objects, ADO. (Object Linking and Embedding DataBase ) (Component Object Model -- ). (, , , rtf- . .). OLE DB , , . -, , .

, OLE DB-, OLE DB - . OLE DB-, OLE DB- OLE DB- -.

OLE DB ODBC. OLE DB- ODBC-. , OLE DB ODBC, , ODBC.

ADO - icrosoft ctive (ctive Data bject D). D , . D mmn bjt del (), , , Visual ++, Visual Basic, Visual Basic for Applications (V), VBScript JavaScript. D , Active Server Page icrosoft.

ADO , , (DataBase Access Engine), , 9, : onnection. , . ommand. , . Rrdset. , . Field. , . rmeter. , . rrt. , D. rrr. .

ADO Delphi (TADOConnection, TADODataSet, TADOTable, TADOQuery,TADOStoredProc TADOCommand), ( - data store), Microsoft.

, ADO ADO Delphi. ADO ConnectionString . TADOConnection, ADO . :

*.udl;

.

/ Microsoft Data Link Windows. *.udl C:\Program Files\Common\ SYSTEM\ole db\Data Links, Delphi OLE DB. udl- ( 10) . (Provider) . Visual FoxPro Microsoft OLE DB Provider ODBC Drivers, ODBC User DSN, . , .

3 . . .

( ). , , , , . , ( ) (TP monitor), :

  1. COMMIT () ;

  2. RALLBACK () .

ACID

  1. . ( );. ( ).. . , , , , .. , , . , , (). , , . COMMIT RALLBACK. , (, ) , , . . . , , , , , , , , . - . , - . , : . . .

(READ COMMITTED), (REPEATABLE READ) (SERIALIZABLE). SERIALIZABLE, , , . : SERIALIZABLE> REPEATABLE READ> READ COMMITTED> READ UNCOMMITTED.

( ), . , , . , :

  • . , T1 , 2 , 1 . 2 , , ( 1 ).

  • . , 1 , 2 , 1 . 1 .

. , T1 , . , T2 , . T1 , . . , .


1 .

, . , (, ..) , , . . , , , . . . 6, - . : , . - - . , , . . , - . F=11+22+..66, 1..6 - . 1..6 1 .. . ..1..6. 1..6 . : 11+66≤., 11..66≤ ., 11..66≤. . IIE. , , , () (). .. () 0, . =0. . . 0 .. () . . ,

(F13 ). . . ( ). ., , ʻ. , .. ʻ . . - . . , .

2 .

, . SQL (Structured Query Language). SQL , , , . , , (, , ), .. . SQL.

, , . , f : R=f(R1, R2, R3Rn)

, .. , :

- : , , ,

: , , ,

A B , A B, , , A, B, .

: A UNION B SELECT * FROM A UNION SELECT * FROM B;

A B , A B, , , A B. A INTERSECT B SELECT * FROM A INTERSECT SELECT * FROM B;

A B , A B, , , A B.

A MINUS B SQL:SELECT * FROM A EXCEPT SELECT * FROM B

. , , , , , t, , t , , b, . , .

A TIMES B

SELECT A.1, A.2, , B.1, B.2, FROM A, B;

SELECT A.1, A.2, , B.1, B.2, FROM A CROSS JOIN B;

(, ) A C , A, , , C . C , A () .

C , - ( ..), X Y- A . - (-) -, -.

:

A WHERE C,

A WHERE X@Y

SQL: SELECT * FROM A WHERE c;

A X,YZ, A, (X,YZ ) , (x,yz ), , A X x, Y y, , Z z.

:

A[X,YZ]

SELECT DISTINCT X, Y, , Z FROM A;

, , .

: , - (-) , - ,

. .

8. A B C

(A TIMES B) WHERE C

C , A B () .

, . A B , .

3 . .

, .

:

.

Exception (. )

Delphi Exceptions

Exception

TObjection

|

Exception

|_Eabaut ( )

|_EInOutError( )

|_EIndError( )


, , 0, , . D5 . Exception. . . Raise. Raise, . SysUtils . 2 :

  1. try

{ }

finally

{ }

end;

  1. try

{-------------}

except

{ }

end.

try try end. / try finally finally. finally , try - finally . - , - . 1- finally , except . ONdo. ON c Do. OnDo . try . 1 2 . except - , , . ON Do - else:

---

try

-----

except On EoutOfMemory

do Shomessage(‘ ’)

On EoutOfResources

do showmessage( )

else showmessage(‘ ’) end; ---. E . Try except On E:EmyException do showmessage(E.message) end. , do. showmessage(E.message) - E.message. on..do Raise. :EmyException=class(Exception) public ErrorNumber:integer; constructor create(Const Msg:string;ErrorNum:integer) end. begin inherited create(Msg) ErrorNumber:=ErrorNum;end; Raise EmyException.Create().

1 .

, , , , . , .. . :

- .

, .

- .

, , - . (relation) + + . (normal form), . , () , () . ( ): .

, , . . . 1) , , (, , ). , , . . 2) (, . ). . 3) , . 4) , , . . , . ( ). , , :

  1. : .

  2. : .

. : , .

. : (.. ). , (.. ), . , . : . () (). , , . : , , . . , : ; .

  1. . - . . , :

- . : X Y, Y X, X Y. (X -> Y) . . :

  1. , , -> . 2 , A -> B, -> .

3 , A -> B B -> C, A -> C.

2 . .

, , .

. ( , ; , .). , . , , , .

. ( , ; , , , .), .

. , R-( R 0 1, ; , R 1; ) 1. Microsoft Excel R- .

3 OLAP- .

, OLAP-.

OLAP- , (, , ) , OLAP-.

, OLAP-. , OLAP- SQL-, GROUP BY, , .

, OLAP- ( StatSoft SPSS) . , Microsoft Excel 2000. OLAP- - .

, , OLAP- (, , DecisionCube Borland Delphi Borland C++Builder).

OLAP- , , ( ) , , . OLAP-, , .

( !) OLAP- , , , .

OLAP-, , , OLAP-.

. .

OLAP- OLAP- : , , , , .

, , OLAP-, , Oracle Express Server, Microsoft SQL Server 2000.

OLAP- ( , Microsoft Excel 2000 .) OLAP-, , . , OLAP- .

1 - .

- . , , . , . , , .. / . , , / . . :

.: . , , , . . . , , . , () (). :

1,2,n . -. Y , . Y= f(x1,x2xn). -.

2 OLAP-. .

:

  • , () ; () OLTP- (On-Line Transaction Processing); - , , - () Decision Support Systems (DSS), OLAP-

OLAP- , . OLAP- , (Data Warehouse). , , , , . , , , . . , ( ), . (fact table) (dimension tables). . , , . . : , . (, ); , . (, ) , . ; , . (, ) (, , , ); , . .

, , , , /. , , , . , OLAP-. , . . . ( ) , , ( ) . , , , , . . ; , , , , . , , . , . , . , , , . .

: , () (On-Line Transaction Processing, OLTP-), (); , (Decision Support Systems, DSS), ().

.

, . (On-Line Analytical Processing, OLAP-), . Delphi , . , , , , (). TDecisionQuery, SQL - Select.

TdecisionCube - . - DataSet. TdecisionGrid . TdecisionGraph , - .

3 .

. , X , Y , , . , .

 - . :

  1. .

  2. .

  3. ( ).

  4. .

  5. ( ). , . ( ). 2. :

  1. , .. ( ), . , , , , .

  2. .

  3. .

, , . . , . .

  1. -

  1. -

, . . :

  • ,

  • , ,

  • ,



.


1 . .

- , , . .

- (, 2 , ).

. . 1 , 2-, 3-, n-n-. , , -.

-

-

, - R, :

R , R ;

;

;

.

-

-

- .

, , . , , . :

;

;

.

- , . ( ). .

-, , -, . 1: 1 . 2: 2, 1 . 3: 3, 2 . 3 , . -: , 3 . 4: . - R . 4, R, -> , R . 5: . 4, 5 , . - R . 4, - , - R .

2 OLE.

, OLE- (automation) . , , . , , . GUID (Global Unique Identifier), . - dispatch object. -, , , IDispatch, .

Delphi

function CreateOleObject (const ClassName:string):IDispatch.

. , . , , Word, Delphi :

uses ComObj;

var WD: Variant;

WD:=CreateOleObject(‘Word.Application.8’);

, , . , , , .

Delphi :

  1. File | Open;

  2. -

Type Library (*.tlb, *.dll, *.ocx, *.exe, *.olb)

  1. . , Word Excel :

Excel - c:\Program Files\ Microsoft Office\Office\excel8.olb

Word - c:\Program Files\ Microsoft Office\Office\msword8.olb

3 : ISA, EISA, PCI, AGP.

. -.

, .

(ISA, EISA, MCA, VLB, PCI, AGP).

, .

, () :

( )

(, ) , .

EISA, ISA, PCI, AGP.

ISA (Industry Standard Architecture) ( IBM/PC) 4,7 , . ( PC/AT) 36- . 8,33 .

32- i80836 ISA . . 5 / ( 16,7 /). . , ISA 32- ISA. EISA (Extended ISA) , ISA. EISA () ISA. EISA 32- , EISA, ISA ( EISA , () ). EISA 33,3 /c 8,33 .

PCI (Peripheral Component Interconnect). . 66 64 528 /.

. Intel Pentium. PCI ISA/EISA. PCI (Host Bridge). PCI, . PCI (4 ). , PCI .

PCI: . , ( ).

AGP (Advanced Graphic Port) . , . , (). PCI.

AGP , PCI. :

- ( 256 );

- 66 532 /.

USB (Universal Serial Bus) 90- (Compaq, DEC, IBM, Intel, Microsoft .) ISA PCI . (hab ), . , - . , ISA PCI. 1,5 /.

1. .

. :

  1. ;

  2. ;

:

  1. , ;

  2. , , ;

  3. (, .);

  4. ;

  5. , ;

  6. ;

- ( - ).

.

  1. ,

  4. - , -

  5. -

:

  2. , ,

  3. ,

, . , (). ( ) .


2. .

- , .. . , - . , , .

ŷt /( , . , ε=yt-ŷt (t=1, 2. ...,n) : , , , .


3. - .


- - , , , . - :

1. , , .

2. .

3. . -. , - . - :

, ; ; .

. (Object Pascal), .

:

  • ;

  • ;

  • , .

() ( ) .

() ( ).

, , , (), () .

( ) .

. , Component .

, , Object .

(inheritance) - , . , , . , (hierarchical classification). .

- , , “ ”. , , .

(polymorphism) ( polymorphos) - , , . , - , . .

.. - ()

VFP6/0 . Visual Basic, Java . Windows .

DELPHI . Object Pascal.

class.

- ( + + ) .

, .



1 . .

- , . , .

. :

  2. , . .

  3. . , .

  4. , . , .

  5. . .

  6. , ( ) . , , ∞.

2 , : , , .

, , , , -. , , , - .

:



,


:

, , , (, , ..). , .

: ., , .

:

:


, , . .

: ( ; ), ( , .)

:

1. ,

  2. ,

  3. ,

, , .

: , , .


, .

, .


3 . DDE.

. , , .

TClipBoard --- ClipBoard --- ClipBrd

.

CopyToClipBoard CutToClipBoard 255 .

(cf_BitMap, cf_MeFilePict,...) Tgraphic, TbitMap, Tpicture, TmetaFile .

ClipBoard - , . Clear.

ClipBoard : Function EmptyClipBoard: boolean;

DDE (Dinamic Data Exchange) . . .

. (SetLink) (Conversations) (Topic) (Item). , , , . (Item) Item . Item OnChange.

DDE :

TDDEServerConv , .

TDDEClientConv , : . .

TDDEClientItem

TDDEServerItem Item , .

TDDEServerConv. Name , . , . OnOpenOnClose.

1 - -.

- , .. . , , . - , . - . , , . . , - -. (). , , , . , . - , , , .

:

  • ;

  • ;

  • ;

  • ;

  • .

- , . . , . -

-

- () . , . , - . - . :

, ( );

, , ;

, ;

, , , , ;

, , , , .

- :

, (, , Delphi, );

SQL .

-, . .

2 .

- .

.

:

  • ( ).

  • .

, ( , ). ( . -) =0+1t+a2t^2 (t1, t2- ). , . -, . - .

. ; ; , .. , , ; .


3 . .


- . . 6 . - - - - . ( 6 , ). . ( , ) . , , . - . . , :

  • ,


:

  • . ( , , ) .

  • . (6 -, ANSI, IDEF0/1), (6 OMG), -- , (, - . SQL ), (, Microsoft ODBC).

  • . - , -, , .

. , :

  • ORAcle CDM (custom development method) .

  • ISO/IEC 12207:1995-08-01 . .

1 . .

:

- ;

- ;

, ;

- ;

- .

, . , , , , . , .

: . , , . . - , : : () ; ;


2 .

- , , . .

- - -. . , , , . - .

3 Delphi. .

, Delphi, :

  • - ;

  • - (Rapid Application Development, RAD);

  • ;

  • ;

  • /.

, , (Universal Data Access, UDA), :

  • Microsoft Open DataBase Connectivity, ODBC;

  • OLE DB;

  • Microsoft ActiveX Data Objects, ADO.

(Borland DataBase Engine, BDE).

ODBC, OLE DB ADO . BDE Borland, (Paradox, Delphi/C++Builder).

ODBC, , ANSI ISO, .

OLE DB ADO UDA, , , , , .

1.

.

-, :

  • DataSet- (), ;

  • DataSource- , ;

  • DataControl- , , .

-, , , - (Date Module) ), ( , ) .




1 .

. , X , Y , , . , .

 - . :

  1. .

  2. .

  3. ( ).

  4. .

  5. ( ). , . ( ). 2. :

  1. , .. ( ), . , , , , .

  2. .

  3. .

, , . . , . .

  1. -

  1. -

, . . :

  • ,

  • , ,

  • ,


2

. : , , .

( ). , ., , . FoxPro, Paradox, dBase, Access.

.. ( SQL-) . SQL Server, InterBase ..

. , . . - .

. . . , . . , , , . .

: , . ., , . , . -, , , , . , .

3 Visual FoxPro


Create . (Database Designer) . :

Fields ;

Indexes ;

Table , .

, . , , .

Display , . Caption (, Browse, ..)


Field validation . , . Rule : _ > 0 .and. _ < 1000. Message ( ) . , , Default value. , , , DATETIME(). . Expression Builder (. 2), , Visual FoxPro 5.0 (, , , ), ( ).

Map field type to classes , . .

Field comment , .

Insert Delete .

Indexes . .


, , , ( ). , , , ( Del).


1 .

. :

  • .

( ) ( -). Delphi, , MIDAS.

. “” (, ) , , , , .

, . ( ) .

:

  • ,

  • .

Delphi MIDAS(Multi-tier distributed application services ). Midas , .

- (Remote Data Broker) .

- - (Business Objects Broker) c Borland OLEnterprise .

- (Constraints Broker) , , .

Delphi :

  • DCOM (Distributed Component Object Model ) , Microsoft;

  • MTS (Microsoft Transaction Server MS) DCOM (, , ), ;

  • CORBA (Common Object Broker Architecture ) DCOM .

, , . :

RemoteDataModule DCOM, TCP/IP.

MTSDataModule TCorbaDataModule MTS CORBA . - (TDataBase, TTable, TQuery, TStoredProc). , , .

TDataSetProvider. . , TCientDataSet TXXXConnection.

2 .

- , .. . , - . , , .

ŷt /( , . , ε=yt-ŷt (t=1, 2. ...,n) : , , , .

3 Visual FoxPro.

3.0 VFP , -, , .

- , . → .

1. . .

.-. . (- -) . , . , .

, - -, .

. , , , . .

, . / , - .

, . ( .VCX).

1)

2)

3) / .

4) .

5) .

(Checkbox, Combobox)

VFP .-. , 3 :

1)

2)

3)

1 .

. - - ( ). - (, ..), . . . - . ( , , , ..). , . λ - , , ( ).

, (b>1) =1, , .

.

. , .

. , , , . .

D. . d, .

- :

1

1.1 a>1, =-1; =0

1.2 =1, =∆t; =1


2

3


- 2 max min 0 .

, .

3.2 , , d, . (d>0) (b≤1), ∆τ. =1, .

, . . . , , G, , , . , ..

.

2

, . , . - .

- . . - , .

- , . , .

.


3 . .

:

,

. . , .. , .

. .

:

:

, . . : .

, , .

.. , .

. .

, .

.. :

.

. , , .. . , .

: - cascade ( );

- restrict ( , ); - ignore ( ). update, delete, insert, insert restrict ignore. .. . , , , . , .

1 . . -. .

, . , . . , . .

, “ ” , .. , . T R, T t R. . . , , . . , . : Range of R is x1, x2, ,xn T xi(i=1,2,,n) , . xi Ri(i=1,2,,n), R1,R2,,Rn / , T . (WFF) . WFF WFF.

    1. : . ( , ).

    2. : EXIXSTS FORALL.

EXIXSTS x, WFF . FORALL x WFF .

() + + . = + +


2 .

. OLD NEW - , . .

. , , . , . .

: DECLARE VARIABLE < > < >; : CREATE PROCEDURE FULL_ADR (TOVARCHIK VARCHAR(20))

RETURNS (GOROD_ADRES VARCHAR(40)) AS DECLARE VARIABLE NAIDEN_POKUPATEL VARCHAR(20); DECLARE VARIABLE MAX_KOLVO INTEGER; BEGIN END

BEGIN... END, -, , -, .

, :

= " "; , BEGIN... END.

. :

= ; , , , , , . : OUT_TOVAR = UPPER(TOVAR);

IF. . . THEN. . . ELSE , Object Pascal:

IF (<>) THEN < 1> [ELSE < 2>]

, , 1, - 2. Object Pascal .

SELECT . SELECT INTO : [, ...] , , SELECT ( , SELECT).

SELECT KOLVO AVG_KOLVO SUM_KOLVO, , . KOLVO , TOVAR IN_TOVAR ( ).

SELECT AVG(KOLVO), SUM(KOLVO) FROM RASHOD WHERE TOVAR = :INJTOVAR INTO :AVG_KOLVO, :SUM_KOLVO;

FOR SELECT ...DO : FOR < SELECT> DO

< >; SELECT , INTO.

FOR SELECT. . . DO . SELECT, , DO. SUSPEND (. ), .

, INJTOVAR. CREATE PROCEDURE RASHOD_TOVARA(IN_TOVAR VARCHAR(20)) RETURNS (OUT_DAT DATE, OUT_POKUP VARCHAR(20), OUT_KOLVO INTEGER) AS BEGIN FOR SELECT DAT_RASH, POKUP, KOLVO FROM RASHOD WHERE TOVAR = :INJTOVAR INTO :OUT_DAT, :OUT_POKUP, :OUT_KOLVO DO SUSPEND; END

FOR SELECT. .. DO . SELECT, , , TOVAR , IN_TOVAR. ( OUT_DAT, OUTJPOKUP, OUT_KOLVO). . , DO. SUSPEND. .

, . SELECT, : SELECT MAX_KOLVO FROM FIND_MAX_KOLVO("") WHILE ... DO WHILE (<>) DO < >

: ; , . , .

SUM_0_N, 0 , N. WHILE...DO.

CREATE PROCEDURE SUM_0_N (N INTEGER) RETURNS(S INTEGER) AS DECLARE VARIABLE TMP INTEGER; BEGIN S = 0; TMP = 1; WHILE (TMP <= N) DO BEGIN S = S + TMP; TMP = TMP + 1; END; END

3 . .

. . . .

:

Local View

Remove View

View

View

. , , .

, .

VFP , . , .

1 .

-, . - . ( 1- ) .

y = y(x) (1) (. 1- . -)

y = a + bx (2)( , .. 1- , b ).

( (2)) : = a + bx + e, e , .

:

  1. .

  2. .

.

. X=(x1, x2, ..., xn), f=f(x1, x2, ..., xn) () , x1, x2, ..., xn g1(x1, x2, ..., xn)=0,... , gn(x1, x2, ..., xn)=0.

, .

F=f(x1, x2, ..., xn)+1g1+2g2+...+mgm, 1, 2, ..., m .

F. x*1, x*2, ..., x*n *1, *2, ..., *m, () () .

Microsoft Excel . , . , (. ).

*1, *2, ..., *m x*1, x*2, ..., x*n , .

(1) - , -

. x () .

() , . , .

. , . , , . .

n- . ( )

2 : .


. , .

. , - , -. , , . , , .

. . . , . , , , . , , , . . , . , , .


3 .


, , : , , , , , , .

:

- (, )

/

, -

( )

. (sql, V.F.P)

( , , , , )

2- :

;

.

1 , .

3.1 b>1, b=b-1 y=0

3.2 (b≤1)∩d>0, b=∆τi ; y=1; d=d-1

3.3 (b≤1)∩d=0, b=0 y=1


. . . - - ( ). - (, ..), . . . - . ( , , , ..). , . λ - , , ( ). . μ - ( ). N - . , μ /. - , . , , . :

- λ

- μ

: i i-1 Si-1 .

(2)

,

(3)

:

(4)

.

1.1 a>1, =-1 =0

1.2 =1, =∆t =1


(5)


2 .

. :

  • .

( ) ( -). Delphi, , MIDAS.

. “” (, ) , , , , .

, . ( ) .

: , , , , .

Delphi MIDAS(Multi-tier distributed application services ). Midas , .

- (Remote Data Broker) .

- - (Business Objects Broker) c Borland OLEnterprise .

- (Constraints Broker) , , .

Delphi :

  • DCOM (Distributed Component Object Model ) , Microsoft;

  • MTS (Microsoft Transaction Server MS) DCOM (, , ), ;

  • CORBA (Common Object Broker Architecture ) DCOM .

, , . :

RemoteDataModule DCOM, TCP/IP.

MTSDataModule TCorbaDataModule MTS CORBA . - (TDataBase, TTable, TQuery, TStoredProc). , , .

TDataSetProvider. . , TCientDataSet TXXXConnection.

3 . , Visual FoxPro.


.

1



TN Prim

TN Regul



:

) ER ;

) Local View

2 DataSession.

. .

, , , ( ). , , , ( Del).

1 .

  1. , .

  2. .

  3. , , .

  4. - .

  5. , .. . .

  6. .

  7. .

  8. ,

  9. . ( ).

  10. , . .

  11. , . . , .

  13. ,


2

() , -, .

, , , -. , , .. . 3- -:

  • ;

  • ;

  • ;

  • ;

  • .

Delphi. , :

DCOM , . Windows NT Server Windows 2000 Server

MTS ( Microsoft)- COM, .

DCOM, MTS :

  • , , ;

  • , , ;

  • , ; , .

+ ( ) Microsoft Windows2000 MTS COM.

TCP/IP ( / ) , .

CORBA ( - ( ) ) , .

SOAP ( ) Web- XML HTTP.

, .

Delphi , DataSnap .

3 Visual FoxPro

Visual FoxPro , - DBase SQL, . .

- - , , , .

.-. . (- -) .

, . , .

-

Createobject ( [, 1, 2,]). , , . , Display Objects, : ( ) With Endwith Mouse Click, Double Click, MouseMove, DragDrop

, . SQL. SQL - . SQL:

SQL .

. SQL , .

SQL, .

. SQL .qpr.

DO .QPR. SQL , SQL , : SQL .

*.

*.

*

* -

. Select SQL . , , , . Select SQL .

1 .

  1. (); 2. ; 3. ; 4. ; 5. (IB, Microsoft SQL, Sybase SQL, Oracle); 6. (EPR Enterprise resource planning ) : ; ; ; . 7.:

  1. (BDE Borland Database Engineering )

, (BDE) Delphi-, SQL- BDE.

2. ( , BDE . )

. (BDE) Delphi-, SQL- BDE.

3. (2- ). . , . BDE .

4. 3- ()( : , , BDE, - Internet Explorer). . (BDE). Delphi-, SQL-, .

- PS ( ) PL ( ) - , . , . .

- . , PL, BL DL , .

: , .

- - , . - , SQL , . - , , , . , , SQL .

- 3 :

- , PS PL ;

- , BL DL DS;

- , DS FS ( ).

2 .

, .

3 , .

- .

(terminator) .

(hub).

. , . ,


3


( ) . (, , ). . : , , . . , . , , . - : =0+11+nn, , 0 - , ( , , ..) 1..n 1..n. .0n. , - .

1 , ,

. , . - . - . , , . : 2- , . , ( - - ) , -, - :

- , - ;

- , , , . , . , . . , , . . , :

1) , :

- -

- .

2) .

3) - .

4) 5-7

5) .

6) :

- . 9, 9 . . . .


” ” (, - ) . .

- , .

, , - , .

2

SQL. , .. , SQL. , SELECT.

, , :

- . ;

- : , , ;

- : , , ;

- : , , ;

- , SQL. , .

3 Visual FoxPro


VFP , .



.

. DBF DBC. . DBC. - . DBC . :

- / .

- ., , .

-

- QPR .

. DBF , , - , . . . . :

- . . . . . - .

. . . , .

. VFP OLE autom. . . . DBC. SQL . . new, . . .. VFP , :

1. . . SQL (. .) . , .

2. . . . . . / .

3. , , .

4. .

1 .

.

. . - . . . . , , , . : (, , ); ( , , , ); ( ); .

. , . ( ).

:

  1. . . , , . , . : - ; - ; - ; - .

  2. : ; - .

  3. . - (). : , , . , . . , . , . . , , , , , .

  4. . .

- , , , . : ; ; , ; ; , , ; ; ; ; .

- , , .

- . , .

  1. . ( , , ).

(, ).

2 .

4 λ- , , ( ). μ- , (- ). . N- . . μ . - , . , , , . 2 : , λ , . μ. - . . S0- , , , S1- , , , S2- 2 , SN - N , , , SN+1|- N+1 , , , SN+M N+ , , . , . , , .


, : ,


- . , =M0P0+M1P1+...+MnPn Mn - S0Sn. . =1- . (/) 0=λ (/) = *. () W:=/. ( )

WS=WM+1/μ. =N0P0+N1P1+...+NnPn ZN=N-TN. S=+Z

3 SQL.

, . SQL. SQL - . SQL:

SQL .

. SQL , .

SQL, .

. SQL .qpr.

DO .QPR. SQL , SQL , : SQL .

---- ---- ---- ----*. -----*.

*

* -

. Select SQL . , , , . Select SQL .

1 . .

:

t = n+ l,n + 2,..., n+i,... ,

i = 1,2,... - ,

( ) . , . . , , , , , , .

, K(i), i - ; . .

. ( , ; , .). , .

. ( , ; , , , .), .

. , R-( R 0 1, ; , R 1; ) 1. Microsoft Excel R- .

- , , , . 95%. , , .

2 . .

- , ( ), , .

:

1.

2. , , .

, , . , . , , . , .

, . : , . , , , . , .

- , ( ), . , , . . .

, . ( /, ), , , .


3 - Visual FoxPro


Createobject ( [, 1, 2,]). , , . , Display Objects, : ( ) With Endwith Mouse Click, Double Click, MouseMove, DragDrop

1 . .

, , , . , , ( ) - . , .

(), (), , . , , , . , , , .

() , , . , , , .

, . , .

, . .

, , , ( ), , , ( ), ( ).

2 Automation. .

OLE (Automation) , .



, , --- .

, , , .

, .

Idispatch .

Invoke. Function Invoke (DispId: integer; Const Iid: TGId; Locale ID: integer; Flags: word; var params; var Result, ExceptInfo, ArgErr: Point):Integer;

, DispId , , .

LocaleId Id.

Flags . .

Params TdispParams .

VarResult OLEVariant .

Exceptinfo , DispEException.

ArgErr , .

3 .


. :

;

;

;

, , ;

, , ( ). , . , : ;

;

.

:

;

;

.

: " - ". . . , .

:

;

();


1 ( -).

. . .

- ( ) . : 0 1. , , , .. . , , .

( -) :

 - ;

P ;

N .

N,

(1 - ) , ;

(1 - ) N , N .

N

(19)  . . , . . () , F . .

2 . , , .

, -. . . : ; ; ; -.

. , .. . - .

. . , . , ( , ..): - .

, . . .

. , , . , , . ; ; .

, ,

. . , . .

. , . . . . . , .

. . , . . , . : . : : , , , , . : ; .

: . . : .

: , .

: , .

: . , .

.

, . : , 4- .

, ;

, ; , ; , . , , .

2 , : , , .

, , , , -. , , , - .

:



,


:

, , , (, , ..). , .

: ., , .

:

:


, , . .

: ( ; ), ( , .)

:

1. ,

  2. ,

  3. ,

, , .

: , , .


, .

, .



1 .

, , . 1-n , , . , , . . ( ) , (, , ).

, . , .

.

=(, ), b=(bx,by), + b = =(, )

= + bx ; = + by

, ..

+ b= b + = c

. . , , .

∙ b=|a||b|cosφ

φ


b

. =(, ), b=(bx,by). , .

∙ b = bx + by

- , . .

.

:

  • ( ).

  • .

, ( , ). ( . -) =0+1t+a2t^2 (t1, t2- ). , . -, . - .

. ; ; , .. , , ; .

2 SQL .

, , , , , , , .

,

, , , , , Pascal. DLL, . .

, :

  1. SQL;

  2. .

:

  1. ;

  2. ; ( declare external function < >)

  3. SQL;


3 dbExspress.


. Dbexppress :

  1. SQL,

  2. , .

  3. - dbexpress

:

  2. SQL

  3. => , , .

  4. dbexpress SQL .. ()Oracle ->() dbexpora.dll->(. ) Oci.dll

ISQLConnection.

1) ISQLDriver 2)ISQLConnection 3) ISQLCommand 4)ISQLCursor

SQLConnection - DBExpress

SQLDataSet - SQL , .

DataSetProvider - SQLDataSet SQL

ClientDataSet ( - PacketRecords -1). ApplyUpdates.

SQLClientDataSet - (SQLDataSet, , ClientDataSet ), .

1 .

( ). ( , , ..).

- , . () .

R , (0, 1). r R, (0, 1).

R, , , R*, . R R* , .


. , :

  1. (0, 1) Or n : Δ1(0;p1), Δ2(p1; p1+p2), , Δn(p1+p2++ pn-1;1);

  2. (, ) rj;

r Δi, xi.

Microsoft Excel.


2 .

, .

3 , .

- .

(terminator) .

(hub).

. , . , .


3 . Visual FoxPro.

. .

I .

II .

III .

IV . -

V .

- . Active.Propery [=Valne] form -. Active Form.Method Active Form.Poperty[=Setting] property - Method. Control . Controls (nIndex).Property [=Expression] . Key Preview [=lExpr] Keypress , , Keypress , , F ( ). Keypress . Release Type . 0 , 1 , 2 .

Show Tips [=lExpr] - . , . F . . Tool Tip Text [= cExpr] .

MDI . . CDI . , . .

1) Show window = 0 MDI form = . . - , Show window = 1. . , . MDI. - MDI = Microsoft, . - .

2) Show window = 0 desktop = T. - . - .

3) Show window = 2. windows . - , .

1

- , () .

, , .

, . , a b, .

2 : Ethernet, Arcnet .

Ethernet - . , Ethernet , 5 , Ethernet - 50 .

Ethernet, . Ethernet - , Ethernet Network, Xerox 1975 .

Ethernet DIX IEEE 802.3, , .

IEEE 802.3 10Base-5, 10Base-2, 10Base-T, 10Base-FL, 10Base-FB

Ethernet .

  • 10Base-5 - 0,5 , . 50 . - 500 ( ).

  • 10Base-2 - 0,25 , . 50 . - 185 ( ).

  • 10Base-T - (Unshielded Twisted Pair, UTP). . - 100 .

  • 10Base-F - - . 10Base-T. - FOIRL ( 1000 ), 10Base-FL ( 2000 ), 10Base-FB ( 2000 ).

10 -10/
Base - 10 ( , , Broadband - ). .

Token Ring, Ethernet, , , . , , Ethernet, , . , (token).

Token Ring - 4 16 /. , , . Token Ring, 16 /, 4 /.

Token Ring , Ethernet. . Token Ring , - - . , . , .

Token Ring - . MSAU , MSAU Ring In (RI) Ring Out (RO) .

- 4 /, 16 /. , , (lobe cable), , , - (trunk cable). Token Ring : STP Type I, UTP Type 3, UTP Type 6, - .

3 .

, , - . , . , , . , , , , .

3 :

- ;

- , .;

- , .

1 .

, . , , . . - , .

- . , , , .

.

.

. . : :

. , , .


, , , .. , . , . : , : ,

: ,

, , . , , .

() (). .

, , , . : , , (, (), (), )

. , .. ; , .. , .. .

2 .

- , .. . , - . , , .

ŷt /( , . , ε=yt-ŷt (t=1, 2. ...,n) : , , , .


3 : , , , .


VCL. . , , - , .

- . , , . , , 2 , . TEvent 2 (Set Event Reset Event).

- . , . , .

( , , , .) , , 2 :

  1. .

  2. , . , -.

, , , . .

. , , . , . , , .

:

    • Proc.Suspend

    • Proc.Terminate

    • Execute ( )

    • Resume , true suspend;

    • Destroy ;

    • WaitFor , .

    • FreeOnTrminate true, .

    • Synchronize protected, .. Tthread, - VCL , . VCL

    • Constructor create creat Suspended , =true, , Resume. false .

1

. , X , Y , , . , .

 - . :

  1. .

  2. .

  3. ( ).

  4. .

  5. ( ). , . ( ). 2. :

  1. , .. ( ), . , , , , .

  2. .

  3. .

, , . . , . .

  1. -

  1. -

, . . :

  • ,

  • , ,

  • ,


2 .


4 λ- , , ( ). μ- , (- ). . N- . . μ . - , . , , , . 2 : , λ , . μ. - . . S0- , , , S1- , , , S2- 2 , SN - N , , , SN+1|- N+1 , , , SN+M N+ , , . , . , , .

, : ,





- . , =M0P0+M1P1+...+MnPn Mn - S0Sn. . =1- . (/) 0=λ (/) = *. () W:=/. ( )

WS=WM+1/μ. =N0P0+N1P1+...+NnPn ZN=N-TN. S=+Z.


3 OLAP-

OLAP- , . OLAP- , (Data Warehouse). , , , , . , , , . . , ( ), . (fact table) (dimension tables). . , , . . : , . (, ); , . (, ) , . ; , . (, ) (, , , ); , . (, ).

: , () (On-Line Transaction Processing, OLTP-), (); , (Decision Support Systems, DSS), ().

.

, . (On-Line Analytical Processing, OLAP-), .

Delphi. . - .

Delphi , . , , , , (). TDecisionQuery, SQL - Select. :

Select ; ; GroupBy .

Select P.Gorod, R.Pocup, T.Type_tovar, R.Tovar, R.Mes,

Sum(R.Kol * T.Zena), AVG(R.Kolvo * T.Zena) from

“Rashod.db” R, “Tovar.db”T, ”Pocup.db” P

Where R.Tovar = T.Tovar and R.Pocup = P.Pocup

GroupBy P.Gorod, R.Pocup, T.Type_tovar, R.Tovar, R,Mes

TdecisionCube - . - DataSet.

TdecisionGrid .

TdecisionGraph , - .

1 .

, . , , . . - , .

- . , , , .

.

.

. . : :

. , , .


, , , .. , . , . : , : ,

: ,

, , . , , .

() (). .

, , , . : , , (, (), (), )

. , .. ; , .. , .. .

2 .

, . , , - . . , (). . . .

:

1. - , - . , .. , - , - . . .

2. - - . - , - . . .

3. - . - . . , .

4. (). . , .. .

.

, , .

.

, - . , .

- , . . , .. .

. , . . . , - . , . . : " ", ; " ", " ", " ", . .

3 SQL.

, . SQL. SQL - . SQL:

SQL .

. SQL , .

SQL, .

. SQL .qpr.

DO .QPR. SQL , SQL , : SQL .

*.

*.

*

* -

. Select SQL . , , , . Select SQL .

1

. :

  1. ;

  2. ;

:

  1. , ;

  2. , , ;

  3. (, .);

  4. ;

  5. , ;

  6. ;

- ( - ).

.

  1. ,

  4. - , -

  5. -

:

  2. , ,

  3. ,

, . , (). ( ) .


2

- , .. . , - . , , .

ŷt /( , . , ε=yt-ŷt (t=1, 2. ...,n) : , , , .


3 +.

, , , .

.- + , , + , :

    2. .

    4. (- )

1. (DTC distributed transaction coordinator )

  1. (MSTExplorer)- , , +.

  2. MTS- .

  3. MTS.exe , Just-in-time.

  1. : Run Time

  2. MTSExplorer-

+, 3- . , . + . , .

, , , MTSExplorer.

+ Delphi

+ IObjectControl IObjectContext. . 1 1 . . . TMTSAutoObject. :

-

-

-

:

Proc SetComplete

SetAbort

NewTransaction Objection. / .


1 . .

, , , . , , ( ) - . , .

(), (), , . , , , . , , , .

() , , . , , , .

, . , .

, . .

, , , ( ), , , ( ), ( ).

2 , , , - .

, -. . . : ; ; ; -.

, .. . .

.

, . , ( , ..): .

, . . .

. .

-

-

: , , , , , , . .

, , . , , . : ; ; . - , . ( ). .

1970. , . . . , . - , -. , , . , , ( ). , , . . , . . . . . , , .

3 .


1 , , . , . , , .

2 , , .. :

- , ;

- , .

3 , . .

, ..

, :

;

- ;

- ;

- ;

- ;

- ;

- ;

- ;

- ;

- ;

- .

1 .

, , . , . , . . , . .

, “ ” , .. , . T R, T t R. . . , , . . , . : Range of R is x1, x2, ,xn T xi(i=1,2,,n) , . xi Ri(i=1,2,,n), R1,R2,,Rn / , T . (WFF) . WFF WFF.

    1. : . ( , ).

    2. : EXIXSTS FORALL.

  1. . , , (, ). , , . , , , , , ; , , , . , , ; , . , , , ( . ). , , , , . . , , , :

  • ;

  • .

, .

, , , t, . , , , t, . , , , t, . , , . . , , , , , t, , t , , b, . , . , , 2 . , , . , , .

EXIXSTS x, WFF . FORALL x WFF .

2 .


4 λ- , , ( ). μ- , (- ). . N- . . μ . - , . , , , . 2 : , λ , . μ. - . . S0- , , , S1- , , , S2- 2 , SN - N , , , SN+1|- N+1 , , , SN+M N+ , , . , . , , .

, : ,





- . , =M0P0+M1P1+...+MnPn Mn - S0Sn. . =1- . (/) 0=λ (/) = *. () W:=/. ( )

WS=WM+1/μ. =N0P0+N1P1+...+NnPn ZN=N-TN. S=+Z.


3 .

, . .. .

:

.

.

1 : , .

, , , , .

, - , , . .

:

- (, , ).

, "" , , ( , ).

- { , ( , )}. "" - . , 4-. , ( , , , ).

, , - { , }, , . "" ( , ). , "" , .. , "" . , - .

- , . , , "-" "-", , - . , . , .

. -. -. . : . .

, , - -; . " ", " .

- , .

, ( ) , .


2

() , , . , .

:

; ; -; - -; () .

1

(. floppy disk), , , .

, , . , / .
. (), . . , . 512 .

: 3,5 (89 ), 1,44 , 80, 18.

(. floppy-disk drive), , 360 -1. , . . .

, 3 . Nano2 .

2.

(. HDD Hard Disk Drive) , , . .

, , . - , . , . 1,1 , . , 0,5 .

: 10 100 . ( ) 7200 /, 9 , 60 /. , . ( 2 ), . .

3. -

CD-ROM (ompact Disk Read-Only Memory - , ).

CD-ROM 12 1,2 , , .

( ) ( ), , . (2,54 ) 16 . CD 780 . .

CD-ROM , . C CD-ROM , , . , - , , . , . .

CD-ROM CD-ROM (. 2.9), CD-ROM . .

CD-ROM. , CD. D-ROM DVD. , CD, 17 , .. 20 CD-ROM. , , , , .

4.

CD-R (Compact Disk Recordable) , -, 650 . CD-R . , . , , , . CD-R, , .

- - D-MO (Compact Disk Magneto Optical) (. 2.10). D-MO . 128 2,6 . . , .

WARM (Write And Read Many times), .


3 .

:

  1. ( -);

  2. : ;

  3. ;

  4. , , .

- (, ) , (, ()). , .

, , . , , . , , . .

:

  • 蠗 , ;

  • 蠗 , - .

-:

    • ( );

    • ;

    • .

:

  • , ( );

  • -, , () .

, . . ER.

1 .

2 , .

(, ), , , , ( ). - :

0 ,

1 .

. . 19.2.2.




n- . 19.2.3. 0 ;

1 , 2 . ,


3 : , EMS, UMA, HMA, XMS.

3 :

  1. CMA 00000 h-9FFFF h. (640). DOS , RAM=.

  2. UMA 0000 h-FFFFF h, =384 . . , BIOS, . .

  3. () 100000 h. . 100000 h-10FFFF h ( , HMA) , . HIMEM.SYS DOS .

, 1 . Extended Memory.

EMS DOS- 4 16 . , UMA, . , , .

XMS DOS- . HYMEM.SYS.

, HMA , , .

1 .

.

" ". . , , .

I .

: - , . : ; ; .

.

2 Windows. .

Windows

, , , ( Create) (Events) ( Run). Delphi , Windows 95.

, : , , , Windows , (Messages) . Windows , , . , - wm_MouseMove; - wm_Create wm_Move; - wm_LButtonDown, wm_RButtonDown; - wm_Char (, - cn_KeyDown ( ), cn_KeyUp() cn_Char ( )). , , . . , . :

  • ;

  • ( );

  • .

  • , , :

  • ( );

  • ;

, (, , , ).

, :

, , (Sender);

- ;

;

.

Delphi Windows, .

. , .

, , , , , , . , . Delphi , , . Event->:<>=> . Sender: TObject, . . 5 :

1. - , . , , , , KeyPreview . OnKeyPress. , , (Alt+,Shift+ ..), OnKeyDown, OnKeyUp. , , , : VK_F1, VK_Enter,VK_Home

2. - , , , . OnClick ( ), OnDblClick.

OnMouseDown, OnMouseUp, OnMouseMove x,y:integer .

RunTime (Drag&Drop). :1)OnDragOver- , . 2) OnDragDrop . , DragMode - Automatic.

3., , : OnCreate (1 ); OnPaint ; OnResize ; OnShow (OnHide); OnActivate (OnDeactivate) ; OnOpen (OnClose)

4. , OnChange TEdit? TDataSource ..

5. , : OnEnter - ;OnExit .

3 , .


. . . - - ( ). - (, ..), . . . - . ( , , , ..). , . λ - , , ( ). . μ - ( ).


N - . , μ /. - , . , , . :

- λ

- μ

: i i-1 Si-1 .

(2)

,

(3)

:

(4)

.

3.1 b>1, b=b-1 y=0

3.2 (b≤1)∩d>0, b=∆τi ; y=1; d=d-1

3.3 (b≤1)∩d=0, b=0 y=1


1.1 a>1, =-1 =0

1.2 =1, =∆t =1


(5)



linear programming. programming - , . , linear programming , , . , , : , , .

, , . : , m .

. : ; ; ; ; , ; ; , . , , 75% . , , . . , . , .

(, , ).

. , , .

() , : X1 , X2 , Xn , :

A1 1X1 + A1 2X2 + + A1 nXn = B1;

A2 1X1 + A2 2X2 + + A2 nXn = B2;

Am 1X1 + Am 2X2 + + Am nXn = Bm;

Xj ≥ 0, j=1,,n

:

E = C1X1 + C2X2 + + CnXn  max

, , .. :

Bj ≥ 0, j=1,,n

, . : - ; - ; - - ; - , .

() f(x1,x2,,xn) ,

f gi n , bi . () , . , . . , . , , . .

n- .

Uk Uk+1

Uk DUk, , ..

Uk+1=Uk+DUk (1)

, .. Uk

DUk=f(Uk) (2)

, (1) Uk, (2) Uk

Uk+1=Uk+f(Uk) (3)

DUk Uk,

DUK=f(Uk) ,Uk-1...,Uk-2 (4)

Uk+1=Uk+f(Uk),Uk-1...,Uk-2 (5)

, (5) , .. .

, - . .

R(U) 3- :

1.

2.

3. .

.

( )

( ), f, g1...gm, h1..., hk . (1)-(3) (4)-(5) ( (2) (5)).

, , .

1 . .

 

 

 

! , , , .
. , :