پایگاه داده اینفورمیکس چیست؟ راهنمای مدیر پایگاه داده اینفورمیکس: چگونه پایگاه داده اینفورمیکس را درک کنیم (اینفورمیکس ۱۰۱)

1. Theoretical basis. 6 1.1. The concept of a database server. 6 1.1.1 Main functions of the DBMS 7 Managing the memory buffers 8 Transaction management 9 Journalism 11 Database languages 14 1.1.2 Typical organization of modern DBMS 16 1.2 The concept of client-server architecture. 18 2. Theoretical Foundations of Informix database server OnLine v.7.X 20 Informix 2.1 database server. 20 2.1.1 Description Informix products 21 2.1.2 Typical configurations 22 2.2 The architecture of the database server Informix OnLine v.7.X 24 2.2.1. Dynamic scalable architecture 25 2.2.1.1 Streams 26 2.2.1.2 Virtual Processors 27 2.2.1.3 Planning streams 28 2.2.1.4 Separation flows between virtual processors. 29 2.2.1.5 Saving memory and other resources 30 2.2.2 The organization of shared memory 31 2.2.3 Organization of exchange operations with disks 32 2.2.3.1 Managing disk storage 33 2.2.3.2 asynchronous IO 34 2.2.3.3 Read-Ahead 35 2.2.4 Support for the fragmentation of the tables and indexes 36 2.2.5 Parallel query processing 39 2.2.5.1 What is the basis PDQ technology 40 2.2.5.2 Iterators 41 2.2.5.3 Application Examples concurrency 44 2.2.5.4 Balance between OLTP and DSS-applications 45 2.2.6 Optimizer query cost 47 2.2.7 Means of reliability 48 2.2.7.1. Mirroring disk areas 49 2.2.7.2 Duplication 50 2.2.7.3 Rapid recovery when the system is turned on 52 2.2.7.4 Backup and recovery 53 2.2.8 Dynamic administration 55 2.2.8.1 System Monitoring Interface 56 2.2.8.2 DB / Cockpit Utility 57 2.2.8.3 OnPerf Utility 58 2.2.8.4 Utility parallel loading 59 2.2.9.1 Client-Server Interaction 60 2.2.9.2 Data Location Transparency 61 2.2.9.3 Distributed databases and protocol the two-phase commit transactions 62 recovery procedure 64 optimization transactions 65 Resolution deadlock 66 2.2.10 Support National Language 67 2.2.11 Means C2 Security 68 2.3 Additional components of Informix to perform specific tasks. 69 2.3.1 Informix-Enterprise Gateway 7.1 69 2.3.2 Technology and components EDA / SQL 70 2.3.2.1 EDA API / SQL 71 2.3.2.2 EDA / Link 72 2.3.2.3 EDA / SQL Server 73 2.3.2.4 EDA / Data Drivers 74 2.3.3 Features Enterprise Gateway 75 2.3.3.1 Transparent access to read and write 76 2.3.3.2 Distributed compound 77 2.3.3.3 Configuring the Enterprise Gateway 78 2.3.3.4 Safety 79 2.3.4 Library interface Informix-OnLine DS server transaction manager: Informix-TP / XA and Informix-TP / TOOLKIT 80 2.4 Conclusion 81