(Steven Feuerstein) What is refactoring? Most PL/SQL developers stay very busy building applications. As a result, relatively few explore the wider world of software programming, in which the topic of refactoring is known.
Other News
DB2 UDB for iSeries Query Processing with Encoded Vector Indexes
(Kent Milligan) To ensure that delivery of information to data warehouse users is fast and efficient, a database management system (DBMS) requires an advanced query optimizer. When you ask your data warehouse to perform a report or query, the optimizer is responsible for determining the fastest and
Creating XML documents from SQL Tables
(John Coggeshall) If you aren’t really familiar with XML, you are probably wondering what it is exactly, and what all the fanfare is about. The best way to describe XML is to compare it to its counterpart, HTML. At a glance, XML and HTML share many similarities, but in reality serve two completely d
SQL Server Stored Procedures Administration
(Alexander Chigrik) A stored procedure is a precompiled collection of Transact-SQL statements stored under a name and processed as a unit that you can call from within another Transact-SQL statement or from the client applications. SQL Server ships with a number of stored procedures, which can be
Instance Background Processes Information
(Galina Petrenko) This script displays instance background process information. The script works when the database is MOUNTed or OPENed. (script)
DB2: IMPORTing and EXPORTing
Here are some quick and dirty instructions on how to import data that you have in a file into a DB2 table. Likewise, you can export the data from a DB2 table into a file. The DB2 commands, surprise, are named import and export, respectively. Yes, Virginia, there is a DB2 load command. It offers
XML Schema Tutorial
XML Schema is an XML based alternative to DTD. In our Schema tutorial, you will learn what an XML Schema is, how XML Schema will replace DTD, and how to use the XML Schema language in your applications.
Lock Basics
(Vinod Kumar) Understnading the various locking mechanism is one of the important aspects for developing Online Transaction Processing (OLTP) applications. Now before we get into how the locks are handled, Why Locks on first place? As any databse for that matter has to maintain the concurrency and c
Creating Tables in XML Schemas
You can create tables and columns in XML Schemas in order to validate that table representations in XML data contain valid structure as well as valid data types. In XML Schemas, tables can be constructed manually or automatically with the XML Designer depending on the availability of a data sourc
Advanced PHP and XML tutorial
A data model is like a blueprint of a house. It is important to get it right or it can lead to disaster. This are the parameters to be defined: –the data entities to be stored –the size of table columns –datatypes –which columns can have NULL value –constraints on certain data –relatio