(Anjali Betawadkar-Norwood, Eileen Lin and Ioana Ursu) Data federation gives you a way to integrate the diverse data in your enterprise. This first article in a 2-part series introduces you to federated data concepts and discusses design and configuration considerations for WebSphere Information
Other News
IBM DB2 Universal Database Local Privilege Escalation Vulnerability
A vulnerability was identified in IBM DB2 Universal Database, which could be exploited by local attackers to obtain elevated privileges. This flaw is due to an error when verifying the privilege level of users, which could be exploited by malicious users, with “SELECT” privilege, to insert, update o
Working with the SQL Profiler
(Steven Warren) In SQL Server 2000, the SQL Profiler can help you diagnose and fix SQL Server performance issues. This tool lets you trace events and play back the results, which can help you determine application and/or query problems, such as long-running queries or ineffective indexes. Let’s
Writing CLR Stored Procedures in C# – Returning Data (Part 2)
(graz) In Part 1 I covered a simple stored procedure that printed the current date. In this article I’ll cover writing a stored procedure to return a recordset back to the client. In the process we’ll learn a little bit more about .NET and C# including the SqlConnection, SqlCommand and SqlDataReader
IBM’s Cloudscape Versus Microsoft’s SQL Server 2005 Express
(Roger Smith) When IBM shook up the database market by donating its Cloudscape commercial Java database to the open-source community last year, Microsoft’s response was to introduce a free Express Edition of its latest SQL Server 2005 DBMS.
Introducing SKOS
(Peter Mikhalenko) SKOS (Simple Knowledge Organization System), recently introduced by the W3C, is a model for expressing knowledge organization systems in a machine-understandable way, within the framework of the Semantic Web. The SKOS Core Vocabulary is an RDF (Resource Description Framework) appl
MySQL expert: DBA dos and don’ts
(Jan Stafford) Pinpointing performance bottlenecks is a problem on any database — proprietary or open source, said veteran database administrator (DBA), database book author and MySQL executive Robin Schumacher. In this interview, he identifies the biggest hassles that DBAs face and the advantages
Understand how .NET can talk to OCI
(Scott Stephens) .NET Framework applications are rapidly gaining popularity, especially due to .NET’s support of languages such as Visual C++, Visual Basic, and C#, as well as environments such as ASP.NET.
Domain Objects Persistence Pattern for .NET
(Iqbal M. Khan) Domain objects in an application represent the core data and business validation rules relating to it. And, domain objects are usually central to the entire application and used by most subsystems. Therefore, their good design is critical for a good application design that is robust,
Database Interaction with PL/SQL, Nested Tables
(Jagadish Chatarji) This series has been focusing on database interactions with Oracle PL/SQL. Having just covered OBJECT TYPE in Oracle and both SQL and PL/SQL ways of working with OBJECTs in the last article, we will now learn about using NESTED TABLE with OBJECT TYPES from both SQL and PL/SQL poi