The ongoing operation, in particular the creation of users (or groups), must be considered as part of the system design. User provisioning, in the ITSO working example portal based document management system, consists of registering a user entity in both WebSphere Portal and DB2 Content Manager.
Other News
Simplify Business Logic with PHP DataObjects
(Darryl Patterson) Working with a database is an everyday exercise for web developers these days. From simple form processing to large-scale web applications, we almost always need a database. After working on a few projects, it doesn’t take very long to realize that the same four simple databas
‘For-Each’ of My Own
(Miguel A. Castro) One of the coolest things I like about the .NET Framework is the way collections are designed and handled. On the surface, you simply see many types of collections, stored in the System.Collections namespace. In fact, there is another namespace directly under this one called Syste
Archiving as a Cure for Database Crashes
(Drew Robb) Letting a database grow without action can lead to disaster. Transactional performance can suffer to the point where people are screaming about access rates or their queries timing out. And if you do run out of disk space, your whole system could crash.
SQL Server 2000 Security – Part 14 – Conclusion – Pre- and Post- Installation Recommendations
(Marcin Policht) It is time to gather remaining pieces of information dealing to the SQL Server 2000 Security, concluding at the same time our series dedicated to this subject. We will review them in the context of pre- and post- SQL Server 2000 installation tasks. Some of the topics discussed h
Writing Secure Transact-SQL
(Bart Duncan) There are plenty of good sources of information about how to deploy SQL Server in a secure fashion. However, these resources are often targeted at database administrators tasked with securing already developed applications. In addition, there is a rich body of information that discusse
Working XML: The Eclipse task list
(Benoît Marchal) After more than a year, the author returns to the XM (XSLT Make) project. He reports on changes with the Eclipse platform and embarks on a major update that will integrate XM more tightly with Eclipse. As a starting point, he looks into a simple interface enhancement that is often r
Using DB2 plug-ins for Eclipse with Apache Derby
(Susan L. Cline) The IBM DB2 Universal Database (UDB) plug-ins for Eclipse give Cloudscape™ and Derby users the ability to connect to, browse and create database objects. In this article learn how to use this Eclipse-based tool as well as trouble-shoot connection problems.
Using Oracle Database Transactions in .NET
(Jason Price) In this article, you will learn how to use database transactions in Visual Basic .NET (VB.NET) and Visual C# .NET (C#). Specifically, you will explore database transactions, use OracleTransaction objects in .NET programs, and learn how to set a transaction savepoint. All the scripts an
Analyzing Data Storage – Ten SHOWCONTIG Queries
(Joseph Sack) DBCC SHOWCONTIG allows you to report on fragmentation information for the data and indexes of a specified table. If neither an index nor table is specified, DBCC SHOWCONTIG will report on all tables within the database. You can capture this output by adding “WITH TABLERESULTS” to t