IBM® Informix® is a low-administration, easy-to-use, and embeddable database that is ideal for application development. It supports a wide range of development platforms, such as JavaTM, .NET, PHP, and web services, enabling developers to build database applications in the language of their choice. Informix is designed to handle RDBMS data and XML without modification and can be extended easily to handle new data sets. This IBM Redbooks® publication provides fundamentals of Informix application development. It covers the Informix Client installation and configuration for application development environments. It discusses the skills and techniques for building Informix applications with Java, ESQL/C, OLE DB, .NET, PHP, Ruby on Rails, DataBlade®, and Hibernate. The book uses code examples to demonstrate how to develop an Informix application with various drivers, APIs, and interfaces. It also provides application development troubleshooting and considerations for performance. This book is intended for developers who use IBM Informix for application development. Although some of the topics that we discuss are highly technical, the information in the book might also be helpful for managers or database administrators who are looking to better understand their Informix development environment.

The world is becoming more and more instrumented, interconnected, and intelligent in what IBM® terms a smarter planet, with more and more data being collected for analysis. In trade magazines, this trend is called big data. As part of this trend, the following types of time-based information are collected: Large data centers support a corporation or provide cloud services. These data centers need to collect temperature, humidity, and other types of information over time to optimize energy usage. Utility meters (referred to as smart meters) allow utility companies to collect information over a wireless network and to collect more data than ever before. IBM Informix® TimeSeries is optimized for the processing of time-based data and can provide the following benefits: Storage savings: Storage can be optimized when you know the characteristics of your time-based data. Informix TimeSeries often uses one third of the storage space that is required by a standard relational database. Query performance: Informix TimeSeries takes into consideration the type of data to optimize its organization on disk and eliminates the need for some large indexes and additional sorting. For these reasons and more, some queries can easily have an order of magnitude performance improvement compared to standard relational. Simpler queries: Informix TimeSeries includes a large set of specialized functions that allow you to better express the processing that you want to execute. It even provides a toolkit so that you can add proprietary algoritms to the library. This IBM Redbooks® publication is for people who want to implement a solution that revolves around time-based data. It gives you the information that you need to get started and be productive with Informix TimeSeries.

"PostgreSQL Developer's Handbook" provides a complete overview of the PostgreSQL database server and extensive coverage of its core features, including object orientation, PL/SQL, and the most important programming interfaces. The authors introduce the reader to the language and syntax of PostgreSQL and then move quickly into sophisticated programming topics.

The IBM® Midmarket Software Buying and Selling Guide is tailored specifically to help the management and IT staff of small and midsized businesses evaluate how the IBM midmarket portfolio can provide simple and cost-effective solutions to common business problems. Along with a midmarket customer focus, this IBM RedpaperTM publication is designed to help IBM teams and Business Partners be more effective in serving small and midsized businesses. We illustrate how IBM software for the midmarket can help businesses use the Web to reduce expenses, improve customer service, and expand into new markets. We cover the IBM software offering for the midmarket, which includes what the software does, the platforms it runs on, where to find more information, and how it can help your business become more profitable: - IBM Business Partners often keep a printed copy of this guide in their briefcases for software references - Customers can view this guide online and look up software-value messages and IBM product family offering comparisons - IBM Sales Representatives can print parts of this guide as "leave-behinds" for customers, to give them extra collateral on midmarket software of interest To make sure that you have the latest version of this guide, download it from this web address: http://www.redbooks.ibm.com/abstracts/redp3975.html?Open

This handbook provides an exhaustive, one-stop reference and a state-of-the-art description of geographic information and its use. This new, substantially updated edition presents a complete and rigorous overview of the fundamentals, methods and applications of the multidisciplinary field of geographic information systems. Designed to be a useful and readable desk reference book, but also prepared in various electronic formats, this title allows fast yet comprehensive review and easy retrieval of essential reliable key information. The Springer Handbook of Geographic Information is divided into three parts. Part A, Basics and Computer Science, provides an overview on the fundamentals, including descriptions of databases and encoding of geographic information. It also covers the underlying mathematical and statistics methods and modeling. A new chapter exemplifies the emerging use and analysis of big data in a geographic context. Part B offers rigorous descriptions of gathering, processing and coding of geographic information in a standardized way to allow interoperable use in a variety of systems; from traditional methods such as geodesy and surveying to state-of-the-art remote sensing and photogrammetry; from cartography to geospatial web services. Discussions on geosemantic interoperability and security of open distributed geospatial information systems complete the comprehensive coverage. The final part describes a wide array of applications in science, industry and society at large, such as agriculture, defense, transportation, energy and utilities, health and human services. The part is enhanced by new chapters on smart cities and building information modeling, as well as a complete overview of the currently available open-source geographic information systems. Using standardized international terminology, in accordance with ISO/TC 211 and INSPIRE, this handbook facilitates collaboration between different disciplines and is a must have for practitioners and new comers in industry and academia.

Throughout the history of the IT industry, integration has been an important part of most projects. Whether it is integration of transactions, data, or processes, each has challenges and associated patterns and antipatterns. In an age of mobile devices, social networks, and cloud services, and big data analytics, integration is more important than ever, but the scope of the challenge for IT projects has changed. Partner APIs, social networks, physical sensors and devices, all of these and more are important sources of capability or insight. It is no longer sufficient to integrate resources under control of the enterprise, because many important resources are in the ecosystem beyond enterprise boundaries. With this as the basic tenet, we address these questions: What are the current integration patterns that help enterprises become and remain competitive? How do you choose when to use which pattern? What is the topology for a "composable business"? And how do you accelerate the process of implementation through intelligent choice of supporting integration middleware? This IBM® Redbooks® publication guides integration practitioners and architects in choosing integration patterns and technologies.

As an everyday, hands-on developer's guide covering all database systems, this book is loaded with the programming tips and techniques for the reader's interest.

There have been more than 100,000 downloads of Oracle SQL Developer SQL and PL/SQL are the most popular development languages for the Oracle database

In this IBM® Redbooks® publication, we present guidelines for the development of highly efficient and scalable information integration applications with InfoSphereTM DataStage® (DS) parallel jobs. InfoSphere DataStage is at the core of IBM Information Server, providing components that yield a high degree of freedom. For any particular problem there might be multiple solutions, which tend to be influenced by personal preferences, background, and previous experience. All too often, those solutions yield less than optimal, and non-scalable, implementations. This book includes a comprehensive detailed description of the components available, and descriptions on how to use them to obtain scalable and efficient solutions, for both batch and real-time scenarios. The advice provided in this document is the result of the combined proven experience from a number of expert practitioners in the field of high performance information integration, evolved over several years. This book is intended for IT architects, Information Management specialists, and Information Integration specialists responsible for delivering cost-effective IBM InfoSphere DataStage performance on all platforms.

IBM® InfoSphere® Guardium® provides the simplest, most robust solution for data security and data privacy by assuring the integrity of trusted information in your data center. InfoSphere Guardium helps you reduce support costs by automating the entire compliance auditing process across heterogeneous environments. InfoSphere Guardium offers a flexible and scalable solution to support varying customer architecture requirements. This IBM Redbooks® publication provides a guide for deploying the Guardium solutions. This book also provides a roadmap process for implementing an InfoSphere Guardium solution that is based on years of experience and best practices that were collected from various Guardium experts. We describe planning, installation, configuration, monitoring, and administrating an InfoSphere Guardium environment. We also describe use cases and how InfoSphere Guardium integrates with other IBM products. The guidance can help you successfully deploy and manage an IBM InfoSphere Guardium system. This book is intended for the system administrators and support staff who are responsible for deploying or supporting an InfoSphere Guardium environment.