DatabaseJournal.com Staff

by Paul C. Zikopoulos and Roman B. Melnyk This article outlines range-clustered table (RCT) support in the IBM DB2 Universal Database (DB2 UDB) products as of Version 8.1.4. RCTs represent a new table type that is supported through the ORGANIZE BY KEY SEQUENCE clause on the CREATE TABLE statement. This new feature can dramatically improve […]

>>Script Language and Platform: Oracle This script is useful for when you want to create a user with a random password. Author: Vedi Hartono #!/usr/bin/ksh SID=$1 echo $SID export ORACLE_SID=${SID} echo “userid (password will be generated)” read userid set -A M 0 1 2 3 4 5 6 7 8 9 A B C D […]

[From SQL Server Magazine] Database professionals are familiar with ADO and SQL, but most of us have had little exposure to Active Directory (AD) programming. Active Directory Service Interface (ADSI) is like ODBC in that it’s an open-programming API. But instead of communicating with every major database management system (DBMS), ADSI helps you access and […]

[From ONLamp.com] Once you’ve built several MySQL databases, you’ll learn some shortcuts to database design. Many databases are very similar. When creating new databases, developers often build the same basic tables with only slightly different names and some adjustments to columns. Rather than starting from scratch when putting together a new database, developers will sometimes […]

by Paul C. Zikopoulos and Roman B. Melnyk Today’s databases (and especially data warehouses) have become so large, and their query workloads have become so complex, that it is often impractical and even unnecessary to retrieve all of the data that may be relevant to a particular query. Rather than use all of the data […]

By Tom Copeland Everyone wants their database-backed web application to run faster on the same hardware – if a software tweak can postpone a hardware upgrade for a year, it’s usually well worth it. One way to improve performance is to examine how the application is interacting with the database, and see if there is […]

>>Script Language and Platform: MS SQL Server 7.0/2000 This simple select statement could present you (1) All the user defined stored procedures in the current database (2) Stored procedure’s dependencies; stored procedure’s related objects (tables, views) (3) Actions on the tables or view when executing the stored procedure – Select, Insert, Update and Delete Author: […]

This function splits a string by a specified delimiter and returns the separated values as a table or array. The default separator is the pipe (|) symbol. Author: R. Rasu /****** Object: User Defined Function dbo.fn_SplitIn2Rows Script Date: 8/10/2002 6:43:52 PM ******/ CREATE FUNCTION fn_SplitIn2Rows ( @PInStrSource varchar(8000) = NULL, @pInChrSeparator char(1) = ‘|’ ) […]

[From internetnews.com] The government’s lawsuit to block Oracle’s (Quote, Chart) acquisition plans is focused on the impact on the top-tier market, but the judge in the case raised concerns Wednesday about how smaller niche companies would be affected as well. U.S. District Court Judge Vaughn R. Walker said he was concerned about the connection between […]

by Roman B. Melnyk and Paul C. Zikopoulos Today’s efficient businesses strive to balance the cost savings of a just-in-time (JIT) inventory system with the potential for lost sales resulting from stock-out situations. A common database design for a JIT procurement system is to have a “master” table that contains up-to-date information about a particular […]

>>Script Language and Platform: Oracle This is a very handy utility (9i only) which let you query the alert log file from an sql tool (sqlplus/toad /oem …). It’s a generic one (unix,windows,vms) , and it’s very simple to install . (install which dba owner). Author: Amihay Gonen GRANT CREATE ANY DIRECTORY TO …; DECLARE […]

by Paul C. Zikopoulos and Roman B. Melnyk If you are an experienced database administrator (DBA) you likely use a mix of graphical user interface (GUI) tools and the IBM® DB2® Universal Database™ (DB2 UDB) command line processor (DB2 CLP) to accomplish your day-to-day tasks. In some cases, the difference between using a GUI or […]