Skip to main content

Skip over site navigation to main content

developerWorks  >   Information Management  >   Technical library  >  

Technical library view  RSS for Information Management

 developerWorks
 Related links:    Redbooks  |  Forums  |  Support knowledge base

Filter your search and/or enter a keyword. If you don't filter your search or enter a keyword, the search results will default to all results.
 
 
 
 
  1 - 30 of 30 results    Hide Summaries
Title   Date  

Table that contains the results that meet the search criteria.

Use Optim software to manage privatized test data from design to deployment
With Optim(TM) Development Studio 2.2, built-in integration with Optim Test Data Management enables developers and database administrators to use copy-and-paste function to generate an Optim Test Data Management request. The request can then be used for the efficient creation of a consistent, right-sized, referentially intact subset of data for testing. This methodology also enables you to enforce data privacy standards that were originally defined in the data model that used InfoSphere(TM) Data Architect. Developers can see which columns are private to ensure that the generated script enforces the requirement to include the Optim Data Privacy option for de-identifying private data. This article offers an end-to-end example scenario depicting a data architect, a database administrator, and a developer completing the steps needed for the solution. 		15 Oct 2009  
 
Developing with PL/SQL in IBM Data Studio 2.2 and Optim Development Studio 2.2
This article describes how you can use IBM Data Studio 2.2 and Optim Development Studio 2.2 to develop routines that use Oracle PL/SQL. It shows you how to create, edit, deploy, and debug PL/SQL packages, procedures, and functions for the following databases: DB2 for Linux, UNIX, and Windows Version 9.7, Oracle 10g, and Oracle 11g. 		20 Aug 2009  
 
Database version control with IBM Optim Database Administrator V2.2
Have you ever wondered when the database was changed? With Optim Database Administrator (previously known as DB2 Change Management Expert), wonder no more! IBM Optim Database Administrator (ODA) helps you keep track of changes, work seamlessly with other team members, reverse or undo changes, and audit any changes that were made to your database. This article describes a scenario where the DBA organization uses ODA along with the Eclipse Team project to enhance their collaboration and ensure a consistent audit path. Learn about connecting to a library control system and saving change management projects, models, and scripts in library control, as well as auditing the changes. Also, discover how to retrieve from library control, and use a change management script to undo the change. 		30 Jul 2009  
 
Using common connections with Optim solutions
Creating database connections requires users to provide specific information, including the database vendor, version, and URL information. In version 2.1, Data Studio Developer and Administrator introduced a simple and efficient way to manage database connections, allowing users to easily store and retrieve connection parameters for multiple databases. With the 2.2 release (in which these products have been renamed to Optim(TM)), there have been additional usability improvements. Support for common connections has also been added to InfoSphere(TM) Data Architect 7.5.2. This article describes how to use common connections for greater efficiency in managing database connection information. 		16 Jul 2009  
 
Data Web Services on DB2 for z/OS, Part 2: Integrate z/OS data sets using user-defined functions
Learn by example how to create an external user-defined function (UDF) on DB2 for z/OS that can read z/OS Unix System Services (USS) files and z/OS data sets. You can then use existing SQL built-in functions and your own UDFs to perform data manipulation on the information stored in the data sets and files. You can also expose these "file-reading" SQL statements as IBM Data Web Services, which results in the data sets and files being available to Web service operations. 		09 Jul 2009  
 
Using IBM Database Encryption Expert to protect your sensitive data
IBM Database Encryption Expert provides features to encrypt and control access to data written to file systems and database backup images. Beginning with Version 1.1 Fix Pack 3, the product supports both DB2 and Informix Dynamic Server (IDS). This article describes some of the key features and mechanisms of Encryption Expert and shows you how to use them. 		02 Jul 2009  
 
De-identify flat files using Optim Data Privacy Solution and InfoSphere Federation Server
With the current environment of data sensitivity, there is a need to mask data not only in the traditional relational databases, but also in flat files that could be part of a testing scenario. Customers continue to need to send files to vendors, off-shore testers, and even internal testers, and the data in those files could be subject to regulations. In this article, learn how to de-identify private data in flat files by using IBM InfoSphere Federation Server to create a relational table (nickname) for data in flat files and then applying data privacy algorithms using IBM Optim Data Privacy Solution. 		02 Jul 2009  
 
Extend IBM InfoSphere Data Architect to meet your specific data modeling and integration requirements, Part 2: Build customized reports and validation rules with IDA
IBM InfoSphere Data Architect (IDA) (formerly Rational Data Architect) is gaining momentum as a comprehensive tool that helps organizations promote a thorough understanding of their enterprise information architecture. As more people use IDA, there's an increasing need for some customers to extend IDA to meet their unique data modeling and integration requirements. This two-part series shows you how to extend IDA's models, properties view, model reports and validation rules. In Part 1, you learned how to programmatically traverse and modify IDA models and how to add and display custom properties. In Part 2, learn how to generate customized reports and how to add your own validation rules for IDA models. [2009 Jul 02: This article was updated to reflect that the GUI for BIRT report customization has been changed for performance improvement. This is shown in the section that describes how to generate customized model reports using BIRT.--Ed.] 		02 Jul 2009  
 
SQL Tuning: Not just for hardcore DBAs anymore
A look at how IBM Optim Query Tuner for Linux, UNIX, and Windows helps developers create efficient queries and build tuning skills 		30 Jun 2009  
 
Extend IBM InfoSphere Data Architect to meet your specific data modeling and integration requirements, Part 1: Modifying IDA models and customizing properties
IBM InfoSphere Data Architect (IDA) (formerly Rational Data Architect) is gaining momentum as a comprehensive tool that helps organizations promote a thorough understanding of their enterprise information architecture. As more people use IDA, there's an increasing need for some customers to extend IDA to meet their unique data modeling and integration requirements. This two-part series shows you how to extend IDA's models, properties view, model reports and validation rules. In Part 1, learn how to programmatically traverse and modify IDA models and how to add and display custom properties. [IDA Version 7.5 has adapted Data Tools Project (DTP) to replace Web Tools Project (WTP). Because IDA uses the SQL model defined in DTP as the basis of its metamodels, the section "Programmatically traverse and modify RDA logical data model and physical data model," as well as the sample code provided with the article, were updated.--Ed.] 		25 Jun 2009  
 
What's new and cool in Optim Development Studio 2.2
Optim(TM) Development Studio, previously known as Data Studio Developer, takes new strides towards realizing IBM's Integrated Data Management vision. This article explains how developers, architects, and database administrators (DBAs) can collaborate in new and productive ways in heterogeneous database environments with Oracle and IBM databases. Learn how you can fast track the performance of your applications even more using Optim Development Studio and pureQuery. 		18 Jun 2009  
 
Integrated Data Management: Managing data across its lifecycle
IBM is consolidating many of its Data Studio offerings under the Optim name. The Optim portfolio will focus on realizing integrated data management with innovative delivery of application-aware solutions for managing data and data-driven applications across the lifecycle, from requirements to retirement. This overview article explains both the vision and reality of Integrated Data Management and how you -- whether a data architect, developer or tester, DBA, or data steward -- can use IBM solutions today to respond quickly to emerging opportunities, improve quality of service, mitigate risk, and reduce costs. 		02 Jun 2009  
 
Access Optim archive file data using Cognos
IBM Optim Data Growth Solution can help keep data volumes under control so that critical business applications can continue to perform well. It can also help businesses maintain appropriate data for audit purposes at lower cost. Business intelligence users, however, may need access to information that has been archived. Optim Data Growth Solution, through Optim Open Data Manager, provides universal access to that archived data. In this article, follow the necessary steps to set up connectivity to data that has been archived by Optim Data Growth Solution so that Cognos users can report on that archived data. 		21 May 2009  
 
Optimize Enterprise Generation Language (EGL) applications using pureQuery and Data Studio Developer
This article describes how pureQuery and Data Studio Developer can be used to optimize data access for DB2 LUW and z/OS with EGL Java applications. The article shows how EGL and Data Studio Developer can be installed in a shell-sharing mode, and then how pureQuery can be used with the EGL Java generated code to convert dynamic statements to static statements for the DB2 versions, change captured SQL statements with better performing SQL statements,reduce SQL Injection risk, and look at execution times for the different SQL statements in special views provided in DataStudio. 		08 May 2009  
 
Data Web Services on DB2 for z/OS, Part 1: Unlock business functions using DB2 for z/OS stored procedures and Data Web Services
Is your organization using or planning to use DB2 for z/OS stored procedures to provide business functions? Have you ever wondered how to reuse stored procedures without programming effort in Web services? If so, this article will be of interest to you. 		07 May 2009  
 
Data Studio Administrator, Part 1: Integrating Data Studio Administrator and Rational Data Architect
This article highlights the integration between Data Studio Administrator (previously known as DB2 Change Management Expert) and Rational Data Architect. You'll learn about the common look and feel, the strengths of each product, and the benefits of combining them together. It includes step-by-step instructions and a sample that illustrates the touch points between these two tools. [2009 Apr 17: Added note about Rational Data Architect changing product name to InfoSphere Data Architect. --Ed.] 		17 Apr 2009  
 
Use IBM Rational Data Architect to model your Oracle databases
Find out why IBM Rational Data Architect is gaining momentum as a database modeling tool that is optimized for IBM databases, yet also provides functionality to model other major database vendors such as Oracle. Look at alternatives to Oracle Designer, and see how keeping up with Oracle's major enhancements is setting RDA apart from the rest of the data modeling tools. [2009 Apr 17: Added note about Rational Data Architect changing product name to InfoSphere Data Architect. --Ed.] 		17 Apr 2009  
 
Integrate WebSphere Business Modeler and Rational Data Architect
Get an overview of IBM Rational Data Architect and IBM WebSphere Business Modeler. Step through three scenarios for integrating business process and data modeling using Rational Data Architect and WebSphere Business Modeler, and find recommendations and best practices along the way. [2009 Apr 17: Added note about Rational Data Architect changing product name to InfoSphere Data Architect. --Ed.] 		17 Apr 2009  
 
Integrating Rational Software Architect with Rational Data Architect
Model-driven software development generally starts with either application modeling or data modeling. Application modeling and data modeling, however, are closely related to, and complement, one another. IBM has recognized the importance of integrating application modeling with data modeling in model-driven software development, and has developed the Unified Modeling Language (UML)-to-Logical Data Model (LDM) and the LDM-to-UML transformations. These transformations integrate application modeling using Rational Software Architect (RSA) and data modeling using Rational Data Architect (RDA). This article provides a quick overview of RSA and RDA, outlines the high-level steps in three RSA-RDA integration scenarios, and discusses the UML-to-LDM and the LDM-to-UML transformations and the UML Logical Data Model Profile. [2009 Apr 17: Added note about Rational Data Architect changing product name to InfoSphere Data Architect. --Ed.] 		17 Apr 2009  
 
Data migration and change management using Data Studio Administrator V2.1
IBM Data Studio Administrator for DB2 for Linux, UNIX, and Windows provides DBAs with powerful ways to manage and control complex changes made to their databases, while preserving the underlying data. In Version 2.1, it's even easier to do this using new copy and paste capabilities for migration. In this article, follow along with a DBA who uses Data Studio Administrator to manage changes made to a production database table by copying the objects and data to a test system, making the desired changes, then propagating the changes back into the live database environment. 		16 Apr 2009  
 
Oops! Restoring your database with Data Studio Administrator
As a DBA, it is crucial that you perform regularly scheduled database system backups as part of your backup and recovery strategy. In the event of an application or hardware failure, you can use these backups to restore your database. This article follows a day in the life scenario for a DBA named Erik, who works at a fictitious company. On this particular day, problems arise when Erik discovers that bad application logic has deleted rows from multiple tables of the company's GOSALES database. However, because Erik used Data Studio Administrator 2.1 to back up the database, he is able to restore the database to its original state. 		02 Apr 2009  
 
Migrating from CA ERwin to InfoSphere Data Architect
If you've had experience with CA ERwin Data Modeler and now are starting to learn InfoSphere(TM) Data Architect, this paper will speed up your model migration process and ease your learning process of the new environment. You will learn the differences between the two design environments, and you'll also learn a set of best practices for using features of InfoSphere Data Architect that will put you on the fast track of working productively in InfoSphere Data Architect. 		02 Apr 2009  
 
More pureQuery Performance: Now with .NET applications accessing DB2 for z/OS
26 Mar 2009  
 
Understanding leads to trust: Sharing a common vocabulary across InfoSphere Foundation Tools
Developing trust in enterprise information assets requires organizations to develop and share a common understanding of business vocabulary. This is one of the central objectives of InfoSphere Foundation Tools. Business analysts can create, manage, and share an enterprise vocabulary and classification system using IBM InfoSphere(TM) Business Glossary. Using InfoSphere Data Architect (previously known as Rational(R) Data Architect), data modelers use those definitions in existing or new data models to ensure alignment across business and IT. Data modelers can extend the definitions with information about the mapping of those concepts to the physical databases so that business users can identify appropriate data sources for ad-hoc queries or reports. Those definitions can also become the basis for IBM Information Server to load warehouses, consolidate databases for mergers, or establish and manage master data. In this article, you will see how easily you can share metadata between InfoSphere Business Glossary, InfoSphere Data Architect, and IBM Information Server. 		12 Feb 2009  
 
What's new in IBM Data Studio Administrator 2.1
IBM Data Studio Administrator 2.1 enhances DBA productivity by simplifying day-to-day database administration tasks. Focusing on accuracy, and thereby reducing risk, Data Studio Administrator streamlines database changes and migrations by automatically generating change commands. This reduces disruption caused by incorrect DDL, mis-coded system commands, or missing dependencies. Data Studio Administrator also simplifies DB2 object management by giving DBAs the ability to stop and start DB2 instances, run common commands and utilities, and navigate quickly to database objects within a single tool. 		12 Feb 2009  
 
Understand IBM Data Studio Version 2 software packaging
This article provides a brief overview of the functionality and packaging of some of the key Data Studio products from the IBM integrated data management portfolio. The portfolio includes Data Studio Developer and Data Studio pureQuery Runtime, Data Studio Administrator, DB2 High Performance Unload, InfoSphere; Data Architect, DB2 Performance Expert and DB2 Performance Expert Extended Insight Feature, and DB2 Optimization Expert for z/OS. 		05 Feb 2009  
 
Instant Information: Stream Computing
Talk about low latency. IBM's new InfoSphere Streams technology lets companies analyze data in motion, bringing results in milliseconds. 		02 Jan 2009  
 
Integrated Data Management: Data Parenting in the Digital Age
Managing data's care and feeding from before its birth through its planned destruction crosses departments and roles. IBM's vision for an integrated suite of technologies to handle each life-cycle stage promises to simplify the undertaking for everyone involved. 		23 Dec 2008  
 
Shell sharing between Data Studio, Rational Data Architect, Rational Software Architect, and Rational Application Developer
Share the same Eclipse installation between different IBM software development products, such as Data Studio, RDA, RSA, and RAD. 		13 Nov 2008  
 
The information perspective of SOA design, Part 4: The value of applying the canonical modeling pattern in SOA
Discover the approach and value of canonical modeling in SOA design. See how the canonical data models can be aligned in SOA with canonical message models. In this fourth article in the "Information Aspect of SOA Related Design" series, learn about the concept's underlying data and message modeling regardless of the technology and tool choices. A future article in this series describes how various IBM software products can be used to implement the concepts described here. 		01 Oct 2008  
 
  1 - 30 of 30 results    Hide Summaries
Not finding what you're looking for? Suggest Content