DatabaseJournal.com Staff

[From Oracle Corp.] MUMBAI, 03-APR-2008 11:00 PM The Board of Directors of i-flex solutions Ltd. at its meeting held today in Mumbai, approved a proposal to change the name of i-flex solutions Ltd. to Oracle Financial Services Limited, subject to regulatory and shareholder approvals. The proposed new name reflects the company’s close strategic and operational […]

[From Oracle Corp.] Oracle today announced the immediate availability of Oracle Application Access Controls Governor Release 8, a key component of the Oracle Governance, Risk, and Compliance (GRC) applications suite and the latest release of Oracle’s comprehensive application access control solution that enables compliance, audit and security officers to automatically enforce authorization policies across Oracle […]

Understanding DB2: Learning Visually with Examples, 2nd Edition Authors: Raul F. Chong, Xiaomei Wang, Michael Dang, Dwaine R. SnowPublisher: IBM Press Pub Date: December 29, 2007 Print ISBN-10: 0131580183 Buy this book Chapter 1: Introduction to DB2 DATABASE 2 (DB2) for Linux, UNIX, and Windows is a data server developed by IBM. Version 9.5, available […]

I developed this script because I couldn’t find a good tool to determine if our company’s custom applications’ stored procedures and views were going to be SQLS2K-compatible. It does a brute-force text search of syscomments for syntax that may be unsupported/deprecated in SQLS2K such as: unsupported config options, unsupported sp’s, unsupported systables, etc. The script […]

[From Developer.com] In this article, I will analyze different ways to organize data in a database. In my examples, I will be utilizing Oracle, but any other relational database would suffice. There are both advantages and disadvantages to these methods of relational database data organization and I will distinguish between them. However, I will leave […]

by JP Vijaykumar It is beyond the scope of this document to present all the scenarios that mark an index as unusable and how to validate unusable indexes. Instead, we are going to see what happens to an index when it becomes unusable. Before proceeding further, let‘s discuss what an index is. An index on […]

>>Script Language and Platform: OracleA commonly occuring error is the archiver error that occurs due to the archive dump destination being full. Another error is inability to write info in an audit file, which causes the user session to terminate. All of these problems are common for a DBA. Hence, the only way out is […]

[From InfoWorld] For years now there’s been a constant war between MS supporters and Oracle supporters. Oracle has these features, SQL Server has these features, etc. But that’s not really where the real importance lies. Sure, functionality is a part of it because your DB should be able to do what you need it to […]

Garry Robinson is the editor of www.vb123.com and the Access Unlimited Newsletter. He wrote a book on Microsoft Access Protection and Security and has written many articles for the Smart Access Magazine. Amongst Garry’s online contributions is an Access 2007 Security paper for MSDN at http://msdn2.microsoft.com/en-us/library/bb421308.aspx. Recently Garry has taken up the challenges of connecting […]

[From Oracle Corp.] Oracle today contributed the XQilla XQuery engine code, an embeddable XQuery engine for developers building XML-based applications, under the open source Apache 2.0 license. For applications requiring XQuery and an XML document repository, Oracle has also integrated XQilla XQuery engine within Oracle Berkeley DB XML, an embeddable, open source XML database. The […]

DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep, 6th EditionAuthors: George Baklarz, Paul C. ZikopoulosPublisher: IBM Press Pub Date: November 19, 2007 Print ISBN-10: 0-13-185514-X Buy this book This chapter is an excerpt from the book, DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep, […]

[From internetnews.com] It’s no longer just a .NET or Java world when it comes to production-quality development frameworks — PHP is edging its way into developers’ affections. Now, the technology’s backers are planning further efforts to expand on its successes. The article continues at http://www.internetnews.com/dev-news/article.php/3734371/Zend+PHP+Framework+Builds+on+BigName+Support.htm