Skip to main content

IBM Academic Initiative > Products & technologies > 

Information Management Software

Software resources for the academic community



Getting Started Learn Teach Connect
  Program Path
  What's new
  Program scope

Introduction to IBM Data Studio and pureQuery

Based on open source Eclipse technology, IBM Data Studio provides DB2 and Informix Dynamic Server (IDS) users with the ability to develop database applications quickly. IBM Data Studio is a comprehensive solution for querying (SQL and XQuery) DB2 and IDS servers, managing databases, and developing application stored procedures using Java, SQL PL, and building high performance Java applications using the new pureQuery technology. Get started with IBM Data Studio and pureQuery and bridge the Java and database divide.

IBM Data Studio gives DB2 V9.5 database developers the ability to develop database application objects that access data in a number of data servers and replaces IBM DB2 Developer Workbench (DWB). Get an introduction to the Eclipse user interface and basic data development tasks.

   
Part 1: Get started with IBM Data Studio, Version 1.1.0 and Eclipse

pureQuery gives database application developers an easy, GUI-based means to significantly increase productivity in both the design and implementation phases.

   
pureQuery: IBM's new paradigm for writing Java database applications
 

Learn how this new set of tools makes it easy to design, develop, deploy, and manage your IDS applications. Get started with Web services development using the latest methodology, and also learn how you can simulate a Web service response by converting it to presentable HTML format.

   
Web service development and deployment with Informix Dynamic Server and IBM Data Studio
   

Develop Ruby on Rails applications with DB2

The Ruby language and the Rails framework is becoming increasingly popular in developing web applications. Ruby on Rails facilitates good programming practices and allows for Web application development in the shortest amount of time. Learning this new and exciting technology will be important to faculty and students in the years to come.

The emergence of the Ruby language, coupled with the powerful Rails framework, provides a myriad of opportunities for Web solutions development. With the introduction of the IBM_DB adapter and driver, Rails applications can now interact seamlessly with IBM data servers.

Faculty interested in learning more about this technology can download the Starter Toolkit for DB2® on Rails. This is a conveniently-packaged set of products and technologies which provides a Ruby on Rails ready environment using DB2 Express-C as the backend database. Install this package and save time. You will not need to download source code, obtain compilers, and find a relational database to use; everything is included in the package.

Download now:

Starter Toolkit for DB2 on Rails

Read these articles to help get you started:

Part 1: Getting started with DB2 and Ruby on Rails
Part 2: DB2 and pureXML with Ruby on Rails
Part 3: Testing with DB2 and Ruby on Rails


More good reading
Comparing XML and relational storage: A best practices guide.
This paper outlines both the advantages and the limitations of XML. With various cases and scenarios, it teaches the reader how to choose between XML and relational storage.

IBM Systems Journal - Celebrating 10 Years of XML
The Extensible Markup Language (XML) is an open standard for creating markup languages that describe the structure of data. Since work began on XML 10 years ago, its uses have proliferated at a rapid pace, making it the predominant mechanism for electronic data interchange between information systems. An introductory paper in this issue of the Journal puts the XML phenomenon in its technical and cultural contexts. Then, 12 additional papers address a range of XML-related topics: core XML technologies, connecting business to data, connecting data to applications, mapping technologies, and connecting business to business with Web services. (Order No. G321-0161-00)

Introducing DB2 9: Application development enhancements
This article provides an overview of the new enhancements for developers in IBM DB2 9 for LUW, which include: a new Developer Workbench, deeper integration with .NET environments, rich support for XML and SOA environments, new drivers and adapters for PHP and Ruby on Rails, and new application samples. This article provides an overview of these enhancements.


Information Management software - Integrating data and content

Related links
Information Management software  
Information Management zone on developerWorks