没有合适的资源?快使用搜索试试~ 我知道了~
Informix_Application_Development_Getting_Started.pdf
需积分: 10 1 下载量 68 浏览量
2019-07-07
10:26:01
上传
评论
收藏 2.19MB PDF 举报
温馨提示
试读
72页
Informix_Application_Development_Getting_Started.pdf
资源推荐
资源详情
资源评论
Informix Dynamic Server Application Development:
Getting Started
Learn how to start developing state of the art applications using Informix Dynamic Server (IDS) as the
database. This book includes an introduction to IDS, how to install it and the client drivers, and basic
information about developing applications using IDS with Java, PHP, Ruby on Rails, and.NET.
Jacques Roy
Information Management Technical Product Manager
IBM Software Group
2
Informix Dynamic Server Application Development: Getting Started
Table of contents
Chapter 1: Introduction to IDS.......................................................................................... 5
IDS Architecture.......................................................................................................................5
User Connections.................................................................................................................... 6
Authentication.......................................................................................................................... 6
User Requests Processing...................................................................................................... 6
IDS Administration................................................................................................................... 6
IDS Capabilities....................................................................................................................... 7
Sysdbopen and Sysdbclose Procedures................................................................................ 7
User-Defined Types................................................................................................................. 8
User-Defined Routines............................................................................................................. 8
User-Defined Aggregates........................................................................................................ 10
Virtual Index/Table Interface.................................................................................................... 10
DataBlades.............................................................................................................................. 10
Reference Material...................................................................................................................11
Chapter 2: Installing IDS....................................................................................................12
IDS Virtual Appliance............................................................................................................... 12
Getting IDS...............................................................................................................................13
Installing IDS............................................................................................................................ 13
Server Setup...................................................................................................................... 17
Setting up the environment................................................................................................ 18
Bringing up the Database Server.......................................................................................18
Shutting Down the Database Server.................................................................................. 19
Automate Run Level Script................................................................................................ 19
Adding Space to the Database Server.............................................................................. 20
Adding a dbspace.......................................................................................................20
Adding an sbspace..................................................................................................... 21
Creating a Database in the Server.....................................................................................21
Reference Material............................................................................................................. 22
Chapter 3: Installing a stand-alone client.......................................................................... 23
Choosing a Software Development Kit.................................................................................... 23
IBM Data Server Client....................................................................................................... 23
Data Server client Installation............................................................................................. 24
Setting up the Environment for Development.......................................................................... 25
Informix Client SDK..................................................................................................................26
Getting Informix Client SDK................................................................................................27
Informix Client SDK Installation.......................................................................................... 27
3
Setting Up the Environment for Development......................................................................... 28
Setting up on Windows................................................................................................28
Setting up on Unix-Type machines..............................................................................30
Reference Material.................................................................................................................. 31
Chapter 4: The Java Environment......................................................................................32
JDBC and IDS..........................................................................................................................32
Obtaining and Installing the Data Server Driver...................................................................... 32
Obtaining and Installing the Informix Driver.............................................................................34
Trying the Drivers..................................................................................................................... 36
More on the IBM Data Server Driver........................................................................................ 35
More on the Informix JDBC Driver........................................................................................... 36
Using a DataSource to Connect to IDS................................................................................... 36
Type Mapping.......................................................................................................................... 36
Using an Application Server.................................................................................................... 37
Development Tools.................................................................................................................. 40
Reference Material.................................................................................................................. 41
Chapter 5: Informix and PHP............................................................................................. 42
Picking a driver........................................................................................................................ 42
Installing the Informix-Specific Driver...................................................................................... 42
Using OAT as your Web Server.......................................................................................... 42
Installing the PDO_INFORMIX driver.................................................................................. 44
Trying the PDO_INFORMIX Driver...................................................................................... 47
Installing the IBM Data Server Driver....................................................................................... 48
Zend Core for IBM.............................................................................................................. 48
Installing the Driver in an Existing Installation.................................................................... 49
Using the Binary Driver................................................................................................ 49
Installing the Driver from Source................................................................................. 50
Trying the PDO_IBM driver................................................................................................. 50
Reference Material...................................................................................................................51
Chapter 6: Ruby and Rails.................................................................................................52
Drivers Choices....................................................................................................................... 52
Getting the IBM Data Server Driver......................................................................................... 52
Installing the IBM Data Server Driver....................................................................................... 52
Testing the IBM Data Server Driver Connectivity..................................................................... 53
Getting the Informix Driver....................................................................................................... 55
Installing the Informix Drivers.................................................................................................. 55
Testing the Informix Driver....................................................................................................... 56
Reference Material...................................................................................................................57
4
Chapter 7: .NET Environment............................................................................................ 58
Drivers for .NET........................................................................................................................ 58
IBM Data Server .NET Provider................................................................................................ 58
Connecting to IDS.............................................................................................................. 59
Informix .NET Provider............................................................................................................. 62
Reference Material...................................................................................................................64
Database Administration Basics........................................................................................ 65
The Open Admin Tool for IDS (OAT)........................................................................................ 65
Starting and Stopping IDS....................................................................................................... 65
Checking the Server Status..................................................................................................... 65
Basic Understanding of Logs.................................................................................................. 67
Loading and Unloading Data.................................................................................................. 68
Reference Materials................................................................................................................ 70
5
1
Introduction to IDS
It is possible to find introductions to Informix
®
Dynamic Server (IDS) in many books and articles. This
introduction is different because it focuses on what a developer should know about IDS. It assumes basic
knowledge of relational database systems and the SQL language.
IDS Architecture
IDS is based on a multi-threaded, client-server architecture. This means that an IDS database server
can support a large number of client connections that request access to data. Figure 1-1 illustrates the
architecture.
Figure 1: IDS Architecture Diagram
The IDS database server environment includes shared memory, disk storage and virtual processors
(VPs). There are several type of VPs that execute specific tasks such as general SQL queries processing
(CPU), physical and logical log processing (PIO and LIO), network connection processing (Net), and
so on. These virtual processors are represented as processes in UNIX-type systems, and threads in
the Windows
®
environment. This means that in UNIX
®
-type systems you will see a number of processes
starting where in Windows, you’ll only see one process. In all cases, the program executed is called
oninit.
IDS’s virtual processors communicate between them using shared memory structures. Of course, shared
memory is also used to buffer database data to speed up processing.
剩余71页未读,继续阅读
资源评论
locftest
- 粉丝: 1
- 资源: 21
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功