(Bob Beauchemin) You have two basic ways to improve data-access code performance in your database applications. The most straightforward way is to optimize the SQL statements that execute on the database server. A more subtle way, from a database client programming perspective, is to decrease the nu

(X. Jay Zhang) Oracle Text Index, formerly known as interMedia Index, is powerful for searching user specified text segments in a column or a document, and it is widely used in internet based applications like search engines or content management systems. An issue presented to a DBA, as usual, is to

(Nimesh Panchal)Design patterns are very useful to solve complex design problems if used properly. This article explains the basic concept of the Model View Controller (MVC) design pattern and also shows how closely .NET Framework can be used to implement the MVC design pattern with the one that ori

(Steve Callan) Who is the trigger-happy DBA? No, I do not mean the DBA who is pulling his hair out over a developer’s mistake (“I truncated all my tables. Why can’t you simply do a rollback for me?”), or the DBA fighting management’s insistence on using export as the primary backup and recovery stra

(Sergey Savouchkine) The relational database management system (RDBMS) is based on the relational model, which is simply represented through the relations of rows and columns in two-dimensional tables. Meanwhile, the object-oriented DBMS (ODBMS or OODBMS) offers everything needed for object represen

(Dave Aldridge) If there is one adjustment to make to an OLTP mindset when you start working with data warehouses that I would emphasize more than any other, then it is that your new Enemy Number One is the disk subsystem. Nothing will cripple a data warehouse more effectively than a failure to mana

Oracle and SQL Server databases use different date/time resolutions, which poses a problem when you compare times from the two databases: The times will rarely be equal. Solve this problem by allowing for a margin of error. Treat the dates and times as floating-point numbers and remember that each d

(Arup Nanda) Traditional Oracle Database auditing options let you track the actions users perform on objects at the macro level—for example, if you audit for SELECT statements on a table, you can track who selected data from the table. However, you don’t know what they selected. With data-manipu

Stefan Petry, Oracle’s senior director for product management in the systems management area, explains why and how Oracle Enterprise Manager has an expanded role in enterprise grid architecture.

Constraints are declarations of conditions about the database that must remain true. These include attributed-based, tuple-based, key, and referential integrity constraints. The system checks for the violation of the constraints on actions that may cause a violation, and aborts the action accordingl