3/17
The SQL-92 standard unknowingly and without planning introduced the capability to perform full hierarchical data processing with its introduction of the LEFT Outer Join operation. This natural hierarchical processing capability will be explained in this article.
3/15
There is no silver bullet in the database world. Which database to choose depends on who you are, what you are trying to achieve, how much data you want to store, which OS/Language platform you use for applications, your budget, whether you need a data warehouse, a BI or decision supporting system on top of it, etc.
2/17
XQuery and SQL/XML standard are processors for XML. SQL/XML
was designed to try to match the capabilities of XQuery as closely as possible and XQuery was designed not only to support XML, but also to support relational processing. Read on to learn why this may have a negative influence on their capabilities.
2/02
Simple DB is a database web service offered by Amazon.com. This
article introduces the Simple DB service itself as well as the concepts
needed to work with it.
10/28
One of the issues that companies are facing in their operations is database migration to new hardware, or a different operating system platform, or even a new database vendor. This article describes the overall process.
9/11
Join Steve Callan as he shares several ways to get your hands on E-Business Suite.
7/03
Database consolidation can have a huge impact on IT budgets by lowering hardware and database license costs. But the perils are numerous.
6/20
If you are looking to outsource some of your database operations, here are a few things to consider.
7/02
Interviews with customers and vendors of open source and commercial databases provide a look at various aspects of what open source databases are offering today at a high level and how they stack up against their commercial counterparts from a business perspective.
3/06
You are probably still pumping data in and out of a database, just as we all
did a decade or more ago. That makes it all the more surprising that
mistakes are still being made that date back to the good old days of Windows
95 and before.
8/16
Jon Oltsik has spent some time lately speaking to database vendors and third-party security vendors about database security tools. Read on to see what he's learned so far.
3/08
Ian Gilfillan examines variety of open source database solutions.
4/21
As companies accumulate increasing volumes of enterprise data,
managing, accessing and storing this information cost effectively is one of the most critical IT challenges. As a result, the trend toward Information Lifecycle Management (ILM) is giving rise to a class of solutions designed to help companies meet these goals, and database archiving is a critical component in any ILM implementation.
12/18
Since the building of data warehouses began, the perceived wisdom has been to maintain a separation between the data warehouse and the company's operational systems. Today, while this 'separatist' thinking still dominates among many data warehousing professionals, the approach is being questioned. Evolving wisdom is to consider alternatives to the implementation of a traditional warehouse solution, where operational systems are capable of living in harmony with the data warehouse.
12/08
Snapbridge Software reveals its patent-pending technology for real-time integration of large amounts of data from multi-data sources.
