(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
Author: SSWUG Research
Report on Oracle Text Index Sizes
(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
Optimize Oracle Data Access
(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
Take a Load Off: Archive Inactive Data
(Bryan F. Smith and Thomas A. Vogel) A data explosion threatens to bog down, fill up, slow, and generally complicate DBMSs. Archiving data that’s rarely accessed lets businesses hold on to the data they need while keeping DB2 performing at top speed. With databases growing at an exponential rate,
Insert on DB2 Linked Table Fails with Invalid Precision Error
When you are using the Host Integration Server 2000 ODBC Provider for DB2, if you try to use a linked DB2 table on an OS/390 Mainframe system from Microsoft Access, you may receive the following error: ODBC–insert on a linked table ‘MY_CODES’ failed [Microsoft][ODBC DB2 Driver] Invalid precisio
Getting Started with DB2 XML Extender for iSeries
(Marie Wilson and Sue Kelling) IBM’s eServer Business Solution Test (BST) team designs, implements, evaluates, and deploys customer-like scenarios. The team consists of iSeries developers in the Rochester laboratory who design scenarios that demonstrate how iSeries technology can be used to build e-
Practical Data Warehousing in Oracle
(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
DAL Comparison Part 2
(Eric Landes) This article gives some ideas of how to use a widely available open source DAL. Besides the standard ideas of how to actually use LLBLGen, I’ll go over how to modify this in another part of the series. Data Access Layer (DAL) generators can cut time down when building your applic
Doing XPath and XSLT with Style!
(James G. Britt and Teun Duynstee)Professional Visual Basic 6 XML shows the VB community how to take advantage of XML technology and the available (free-to-use) implementations. The flexible and standards-based data description that XML provides can be used in a myriad of places where VB programmers
Advanced OOP: Declarative Programming and Mini-Languages
(David Mertz) This article extends my discussion of advanced programming, but strays into an area that is not exclusively object oriented. What we are interested in for this installment is ways of writing programs that are declarative rather than imperative. In many cases, simply notating facts is m