(Lisa Vaas) The message was, characteristically, all-Oracle: Consolidate, ditch the special-purpose data warehouses, and move to a version of Oracle Corp.’s Database 10g and Oracle BI (Business Intelligence) 10g that feature unified OLAP and relational (SQL) data engines and infrastructure, hooking
Community
Text User Interface For DB2 UDB Administration
Text User Interface for DB2 UDB Administration is a lightweight, text-based DBA solution for fast, efficient, and effortless database maintenance, convenient access to critical system information, and simplified use of DB2 support tools. This technology can be used remotely through any terminal emul
Data Conversion between Microsoft Access and MySQL
(DMSoft Technologies) The importance and widespread use of the Internet has changed the information-processing world. Many enterprises in the world publish their information on-line as they need to access, process and exchange large amounts of information primarily through the World Wide Web.
Introducing XML canonical form
(Uche Ogbuji) XML is careful to separate details of a file or other data source, bit-by-bit, from the abstract model of an XML document. This can be an inconvenience when comparing two XML documents for equality — either directly (for instance, as part of a test suite) or by comparing digital signa
Using Parent Package Variables in Package Configurations
(Allan Mitchell) Package configurations are now the prescribed way of being able to set values within your package from an outside source. One of the options for the source is Parent Package Variable. The name is perhaps a little misleading so this article is meant to guide you through this slight c
Breaking Type Barriers with UDTs in SQL Server 2005
(Thiru Thangarathinam) The integration of the common language runtime (CLR) into Microsoft SQL Server2005 gives developers much more flexibility than ever before. This new feature lets you author stored procedures, triggers, and user defined functions and types using managed languages such as VB.NET
Information Patterns Basics, Part 1
(Fons Pieters) Business intelligence is still the domain of craftsmanship. It is the BI specialist that designs and builds the BI solution based on the requirements of the business. If the BI solution does not match the expectations of the business, it is the specialist that has failed. This line be
Predictable Oracle applications tuning, part 3
(David Welch) Part 1 of this tip debated some common beliefs about apps tuning and offered an approach to efficient project management. Part 2 touched on the specifics of v$sqlarea view, Statspack, index counts, CPU and user involvement. This concluding part covers memory, data dictionary fragmentat
Reading From Databases (Sample Chapter)
(Chris Ullman) Understanding some basics about databases is crucial to using data in your pages. You don’t need to be a database expert, but there are certain things you will need to know in order to work with data in .NET. For a start, you need to understand how data is stored. All types of dat
Oracle plots ECM push
(Martin Veitch) Oracle will use its OpenWorld conference in San Francisco to detail plans to move into enterprise content management (ECM) and extend deeper into business intelligence.