When you run a query against a cube that contains calculated cells in Microsoft SQL Server 2000 Analysis Services, memory usage increases for the Msmdsrv.exe server process. The memory usage increase will vary depending on the number of calculated cells that are defined in the cube and the number of
Other News
Working with Master/Detail Data
(Steve Muench) This column ventures beyond the single-table examples of the past few columns to study the basics of working with data in two or more related tables. I’ll show you how to navigate the web of relationships in the data at runtime, how to join data from multiple tables, and how to presen
Ingres CTO fights back
(Jack Loftus) The head honcho of newly formed Ingres Corp. is defending the viability of his firm’s open source database management system in the face critics who say the product is falling into obscurity. (R)
Secure XML messaging with JMS, Part 1: Extending JMS to support XML authoring and processing
(Bilal Siddiqui) Java Message Service (JMS) is a Java language-based messaging API. XML provides a simple, human-readable data format for information exchange, and is a popular syntax for the formating of enterprise data. Therefore, integrating XML into JMS applications can provide significant advan
An Introduction to XQuery Expression in XML
Stylus Studio, a provider of XML development tools and components for advanced data integration, has announced the availability of a new XQuery tutorial entitled — “Blooming FLWOR: An Introduction to the XQuery FLWOR Expression”. Forget about those old-fashioned, costly online XQuery training semina
Microsoft to Standardize Office Formats
(Nate Mook) Microsoft said that it intends to submit its new Office Open XML file format to the European standards organization ECMA International. The move, which is backed by Apple, Intel and Toshiba, would create a technical committee that will ratify the format as an open standard.
Database Security and Patches – Part 2
(Steve Callan) Part 2 of this series covers the mechanics of installing a patch. Overall, installing a patch is quite easy, but depending upon the platform and version, the number of steps may be different. The base version used as the example is Oracle 9.2.0.1 (for Windows NT/2000/XP) – exactly wha
Use hardware to partition tables horizontally in SQL
(Arthur Fuller) When a table grows to millions or even billions of rows, performance can be a serious problem. The last thing you want to do is a table scan. Unfortunately, you can’t do some queries any other way.
Building Reports Based On Stored Procedures
(Bayer White) Usually developers like having full control over their reports but what happens if you have someone designated to build reports who does not quite know the backend schema. A good way to separate the building of the data for the report and the report design could be stored procedures. N
Oracle CRM for Higher Education
Educational institutions worldwide are undergoing fundamental shifts in how they operate and interact with their “customers”: students, alumni, donors, faculty, and staff. During the mid-1980s and the late 1990s, many colleges and universities began restructuring and re-engineering their operating