DatabaseJournal.com Staff

[From pgAdmin] The pgAdmin Development Team are pleased to announce the release of pgAdmin 1.6.3, the Open Source graphical PostgreSQL administration tool for Windows, Linux, FreeBSD , Mac OS X and Solaris, now available for download in source and a variety of binary formats. The article continues at http://www.pgadmin.org/news.php

[From Embarcadero Technologies] San Francisco – July 24, 2007 – Embarcadero Technologies, Inc. today introduced Change Manager 4.0 with a complete set of schema, data and configuration tools that enable database professionals to better manage database changes. Using Change Manager 4.0, database administrators (DBAs) and developers can quickly identify changes when migrating databases, diagnosing database […]

by JP Vijaykumar I love carpentry. My favorite TV shows include "THIS OLD HOUSE" and "THE NEW YANKEE WORKSHOP". I can make wooden rotating tables. But how can you rotate RDBMS tables? We had a specific requirement to rotate a table and present the one to many relation between two tables as one to one […]

[From McObject LLC] The Perst all-Java open source, object-oriented database also adds multi-version concurrency control (MVCC) for fine grain locking, and simplifies index maintenance McObject announced that the newest release of the Perst open source, object-oriented pure Java embedded database system supports integration with the widely used open source, all-Java Apache Lucene information retrieval library, […]

[From FileMaker, Inc.] SANTA CLARA, CA – July 10, 2007 – FileMaker announces the immediate availability of FileMaker Pro 9, (http://www.filemaker.com/fm9_announce_pr ) a major new version of the desktop database for Windows and Mac OS. The new FileMaker 9 product line, which the company called its most dramatic new offering in years with over 30 […]

[From SQL Server Central] Recently, a project required that after downloading data from AS/400 tables to load a data warehouse, a table in AS/400 be updated with the time stamp to indicate when the load process started and when it completed. These time stamps are then used by the nightly AS/400 process to determine the […]

Alex Polishchuk and Michael Procopio Wouldn’t it great to have a database to store all your data, not have to pay for the software licensing and get a low annual support cost per machine not per CPU, or users, or company revenue? Absolutely perfect! Better yet, such things do exist, they are called Open Source […]

[From CRM Today] Oracle today announced the general availability of Oracle’s Demantra 7.1.1, expanding on its industry leading demand management functionality Oracle obtained through its acquisition of Demantra. With Release 7.1.1, Demantra also becomes part of the Advanced Planning solution within the Oracle(r) E-Business Suite and Oracle’s JD Edwards EnterpriseOne, giving companies the ability to […]

by JP Vijaykumar On a regular basis, I create multiple userids in Oracle databases. Every userid requires the execution of three sql statements: 01 create user … identified by … account unlock password expire; 02 grant create session to …; 03 grant role_name to …; Every time I create a group of new users, I […]

>>Script Language and Platform: SQL Server This script creates the view User_Table_Index_Details which gives you full information about indexes created on a user table in the database. Author: Anand Mahednra Download Script: detail_ut.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these […]

Special Edition Using Microsoft Office Access 2007Roger JenningsMay 1, 2007, 1488 pages ISBN10: 0-7897-3597-0Publisher: QueBuy this book This excerpt from “Special Edition Using Microsoft Office Access 2007” discusses Moving from Spreadsheets to Databases, Defining the Structure of Relational Databases, Maintaining Data Integrity and Accuracy and more. In this chapter Moving from Spreadsheets to Databases Reliving […]

>>Script Language and Platform: PlSql / Oracle This script creates a procedure in which table names may be passed to create an AFTER UPDATE audit trigger for the table. INSTRUCTIONS 1.Run this procedure in a plsql editor 2.Set ServerOutPut on 3.Call the procedure with a valid table name 4.Copy and paste the output in an […]