|Implement SQL passthrough with solidDB and DB2 for Linux, UNIX, and Windows
SQL passthrough is a feature in solidDB Universal Cache that allows the application to access data from both the front-end and back-end databases using a single connection. You can configure this feature as the default, or enable it at runtime for a single transaction or for a session. This article describes both ways of configuring and using SQL passthrough.
|09 Dec 2010|
|The Beginning of the Next Decade of IBM Informix
The story behind Informix 11.7, the new possibilities it brings, and what it will mean in the years to come.
|03 Nov 2010|
|IBM technology in the financial markets front office, Part 1: Overview of a financial markets front office integration blueprint
This article is the first in a series that explores how IBM middleware capabilities can be integrated to address the technical requirements of the financial markets front office. The front office requirements necessitate the need for specialized software that can handle high volumes of data at extremely high speeds. This article series describes an algorithmic trading scenario that was implemented as part of an IBM Software Group incubation project. This first article provides a high-level overview of an integration blueprint that was produced within the project. This blueprint illustrates how the components in the scenario interconnect. Future articles will drill deeper into the technical details around the integration of the various products in the blueprint and how the products were used in the scenario.
|06 May 2010|
|Introducing IBM solidDB High Availability and Transparent Connectivity
IBM solidDB is a high performance in-memory database offering that is optimized for speed and availability. This article focuses specifically on the availability capability by introducing you to the solidDB High Availability (HA) and Transparent Connectivity (TC) features. The article discusses the benefits that these features provide, and how they impact performance. It also shows you how to configure the features, describes a test application, and points you to a demonstration video.
|25 Mar 2010|
|solidDB and the secrets of speed
A look at the technical secrets inside IBM solidDB
|22 Jan 2010|
|Using OpenJPA with IBM solidDB V6.3 on WebSphere Application Server V7
The Java Persistence API (JPA) is part of the Enterprise JavaBean (EJB) 3.0 specification. JPA can be used by both Java Standard Edition (Java SE) and Java Enterprise Edition (Java EE) applications. IBM solidDB is an in-memory relational database with speeds up to 10 times faster than conventional databases. solidDB supports the Java Database Connectivity (JDBC) 2.0 specification. Many Java SE and Java EE applications can leverage the performance benefits of an in-memory database using JDBC. This article shows how you can leverage those benefits using OpenJPA with solidDB V6.3 on IBM WebSphere Application Server V7.0.
|24 Jun 2009|
|Comparing IBM DB2 and IBM solidDB SQL procedures, Part
2: Compare conditional statements, looping statements, error handling, and
returning results sets in SQL procedures
Have you ever wondered how IBM DB2(R) and IBM solidDB(R) procedures differ? This article series of comparisons spells out the differences very clearly. In this Part 2, learn the differences between conditional statements, looping statements, error handling, returning results sets, and miscellaneous other functions. Many examples and side-by-side comparisons help you to understand the differences.
|04 Jun 2009|
|Comparing IBM DB2 and IBM solidDB SQL procedures, Part 1: Compare structures, parameters, variables, assignments, procedure bodies,
cursors, and dynamic SQL statements
Have you ever wondered how IBM DB2(R) and IBM solidDB(R) procedures differ? This article series of comparisons spells out the differences very clearly. In this Part 1, learn the differences between the structures, parameters, variables, assignments, procedure bodies, cursors, and dynamic SQL. Many examples and side-by-side comparisons help you to understand the differences.
|21 May 2009|
|Application logging using solidDB, WebSphere Message Broker, and DB2
Because of its flexibility and its presence in many application environments, XML is becoming the preferred log format. In this article, you'll learn how to easily set up an application logging environment by bringing the XML features of WebSphere and DB2 together. We first introduce a simple application logging scenario, then show how to use solidDB for caching and decoupling the application from the logging infrastructure. WebSphere Message Queue and WebSphere Message Broker will be used to reliably move the log messages from the application to DB2, where they can be stored and queried using the pureXML functionality. To normalize different message formats, WebSphere Message Broker will also be used to transform log files to other XML formats prior to storing them into DB2.
|07 May 2009|
|Introduction to IBM solidDB Universal Cache 6.3, Part
2: IBM solidDB Universal Cache setup
In Part 2 of this two-part series, set up IBM solidDB Universal Cache with DB2 for Linux, Unix and Windows to accelerate access to data. Learn about system and environment requirements, as well as the ways to acquire IBM solidDB Universal Cache code. Learn also how to install, configure, and use the IBM solidDB Universal Cache solution.
|04 May 2009|
|Accelerate access to critical data using IBM solidDB Universal Cache
IBM solidDB Universal Cache is in-memory caching software for use with traditional disk-based relational databases. It promises extreme speed, adaptability, and robustness. Explore these promises and follow a sample use case for the first - extreme speed.
|12 Mar 2009|
|Introduction to IBM solidDB Universal Cache 6.3, Part
1: Get started with solidDB Universal Cache 6.3
In Part 1 of this two-part series, get an introduction to the IBM solidDB Universal Cache solution and its component parts, and learn about the basic system requirements and the architecture of a solution. Get started with the IBM solidDB Universal Cache solution and an IBM DB2 for Linux, UNIX, and Windows back-end database. Part 2 of this series provides you with the basic knowledge to install and set up IBM solidDB with DB2 for LUW.
|12 Feb 2009|
|Building dynamic Web page applications using PHP and IBM solidDB
Learn how to use PHP with IBM solidDB to build a dynamic Web page application. IBM solidDB is an in-memory database that features extremely fast transaction speeds for queries of even the largest databases. PHP is a scripting language that has become a widely used platform for Web applications. This article shows you how to use PHP to connect to a solidDB database and perform basic operations such as retrieve, update, and delete. You can use these steps as a foundation for building rich Web applications that harness the power of solidDB.
|22 Jan 2009|