Point in Time Recovery for SQL Server
Source: OLAP/BI/IM stuff [link]
Point in Time Recovery: “Every once in a while, an event might happen that corrupts a database. We have all made a stupid mistake at least once that has trashed a database. When this happens what do you do? If you do not have a database backup, then you had better own up to the problem you caused and tell your boss that you screwed up. If you do have at least a complete database backup then you most likely will be able to recover the corrupted database, up to the point that you corrupted the data. This article will discuss how to use a point in time restore to recover your databases. “
Know who your customers are – part 1
Source: Pete-s random notes [link]
Consider a supermarket data warehouse – you know what was sold, where it was sold and when it was sold, we can even identify what else the customer bought in the same basket. But do we really know who the customer was? Identifying retail customers at point of sale has always been problematic, other business sectors have less difficulty identifying customers; banks have account numbers, Telcos
Burton Group: Three Major Stumbling Blocks Derailing SOA News - WebServices.Org
Source: OLAP/BI/IM stuff [link]
SQL 2005 Web Training: Effectively Designing a Scalable and Reliable Database: Session 5 of 10: New Features in Indexing and Index Maintenance
Source: OLAP/BI/IM stuff [link]
Software ofimatico gratuito para los Madrileños

Hoy anuncian en la contraportada de Expansión que Sun Microsystems dona al ayuntamiento de Madrid licencias de software ofimático por valor de 540 €. En concreto el ayuntamiento distribuirá 3 millones de copias de la suite StarOffice 7 de Sun tanto a particulares como a empresas con el único requisito de registrarse. El precio de StarOffice ya era una pequeña fracción del Microsoft Office (75$ para un particular o 25 usuarios por 1.500 € para una empresa), pero seguro que muchos se animarán a probarlo.
Yo ya me había instalado OpenOffice que es la suite basada en el código abierto de StarOffice. No lo he usado a fondo, pero abre y graba xls, ppt, doc, etc, sin cambios extraños. Respecto a las funcionalidades, la interfase es lógicamente distinta, pero he intentado operaciones básicas sin mucho esfuerzo. OpenOffice es gratuito y se diferencia de su hermano StarOffice que este último incluye herramientas administrativas y base de datos. OpenOffice incluye un manipulador de base de datos, pero no base de datos. Ahora se puede usar mySQL (y por supuesto otras de pago) y en la próxima versión incluirá HSQL como motor. Las pantallas de OpenOffice son tan atractivas como estas: Calc (Excel), Write (Word), Impress (Powerpoint), Base (Access) y Draw (Paint?).
La pregunta es ¿cuanto tiempo tardarán las grandes empresas en ahorrarse esta partida de gasto? Me comentaba hace unos días el director de organización y sistemas de una multinacionalque decidió sustituir el Microsoft Office por OpenOffice en todos los pc’s después de la última subida de precios de Microsoft y que los usuarios se han acostumbrado y no han tenido mayores problemas. Y los particulares, ¿empezarán a comprar ordenadores sin Office?
Oracle?s Next-Gen ETL Tool?More Details
Source: BI this week [link]
With a new knowledge encapsulation feature and improved scheduling and security, OWB Paris looks like the real deal
Salient’s Margin Minder Max: Real-Time P&L Insight
Source: BI this week [link]
Salient promises real-time visibility into profit and loss from virtually any domain perspective
IBM Announces Linux-powered Data Warehousing Bundles
Source: BI this week [link]
If IBM?s new Linux-powered bundles look and sound like data warehousing appliances, are they, in fact, data warehousing appliances?
DBAs Bar Door Against Big Bad .Net Wolf
Source: OLAP/BI/IM stuff [link]
Business Intelligence for the Mid-Market
Source: ITPapers.com - Recent Business Intelligence / Data Warehousing White Papers [link]
As a leader in a growing organization, you know the competitive pressure isn’t easing up anytime soon. And with fewer resources than your larger competitors, you have to act smarter, move faster, and make better business decisions without the benefit of armies of analysts and consultants. With this environment in mind, more and more mid-sized organizations are turning to business intelligence (BI) to help them gain a competitive edge in the marketplace. Small start-up companies with a few employees, mid-cap organizations publicly traded, and state and local government agencies are making better use of the information within their organization by using business intelligence.
Solutions for State and Local Government
Source: ITPapers.com - Recent Business Intelligence / Data Warehousing White Papers [link]
Today’s government agencies are faced with more challenges than ever before. There is the challenge to respond to both constituents and employees; the challenge to meet and maintain regulatory requirements; the challenge to be accountable to taxpayers; and the challenge to manage financials while retaining a highly skilled workforce. Implementing technology solutions for state and local government requires a deep knowledge of not only the challenges you face but also the solutions you need. Empower Solutions’ government experience puts them in a unique position allowing us to bring to you tried and true government solutions.
Beyond BI: Building Intelligence Into Your Operational Decisions
Source: ITPapers.com - Recent Business Intelligence / Data Warehousing White Papers [link]
Organizations that are looking to extend the success they have enjoyed with business intelligence are the best candidates to go to the next level, and embed more intelligence into high-volume operational decisions. This discipline which is called Enterprise Decision Management, differs from traditional BI in that it is focused on execution of decisions and actions rather than reporting. EDM uses business rules management systems and predictive analytics to automate and improve decisions for greater precision, consistency and agility. Adding EDM to BI extends the value of analytics-driven insights, allowing businesses to make smarter strategic, tactical and operational decisions.
Business Objects and MapInfo: Location Intelligence Component
Source: ITPapers.com - Recent Business Intelligence / Data Warehousing White Papers [link]
The MapInfo Location Intelligence Component, a way of supplementing business intelligence (BI) with location, is a powerful solution for analysts in both business and government. Because MapInfo and Business Objects technologies embrace open standards and proven server architecture, the Location Component extends power from analysts to the entire organization. Combining two 100% Java technologies, MapInfo MapXtreme and BusinessObjects InfoView, in a 3-tier architecture, provides speed, security and ease of use.
Agencies Make Better Grant Management Decisions With BI
Source: ITPapers.com - Recent Business Intelligence / Data Warehousing White Papers [link]
Two recent federal mandates placed grant management under increased scrutiny. The Federal Financial Assistance Management Improvement Act of 1999 and the President’s Management Agenda (PMA) require agencies to improve performance and demonstrate the effectiveness of federal grant programs in delivering on services to the public. To meet these demands, grant managers must have the ability to monitor and measure the effectiveness of awarded projects to achieve results. They need tools that can track progress throughout all phases of the award process, providing them with better insight into the complete lifecycle of an award. This insight must be correlated with information about grant-program effectiveness as demonstrated by the accomplishment of outcome-based performance measures.
¿Por qué las empresas adquieren herramientas de BI de diferente fabricantes?

Tras el siempre breve paréntesis vacacional durante el cual he podido desenganchar gracias al retraso que pueblos tan bonitos como Comillas en Cantabria tienen en la asignatura de acceso a la sociedad de la información, me lanzo con entusiasmo a leer los centenares de artículos atrasados. Me encuentro con éste que incide otra vez sobre el viejo tema de si es mejor un paquete integrado o usar distintas herramientas de distintos fabricantes para cada necesidad (best of breed). El artículo es sobre el informe de Data Warehousing Institute titulado “Enterprise Business Intelligence: Strategies and Technologies for Deploying BI on an Enterprise Scale” en el que incide en los beneficios de estandarizar y consolidar las herramientas de BI. Los encuestados para el informe, tienen 3.2 proveedores de BI de media y comentan que las principales razones para la compra de múltiples herramientas de BI son “diferentes requerimientos de los usuarios (54%), autonomía para compras de los departamentos (42%), y falta de funcionalidad en un único vendedor (41%)”.
Leaving on a Jet Plane: Why You Already Know More than You Realize about XML and Web Services Security
Source: OLAP/BI/IM stuff [link]
Jumpstart into Business Intelligence: Implementing BI on a Budget
Source: OLAP/BI/IM stuff [link]
Your first initiative should be visible but not over-ambitious. It shouldn’t take more than six months to complete - and that should also limit the cost of your first deployment. When identifying your first BI initiative, follow these basic principles:
Small beginnings are usually best. Focus your first project on getting your BI infrastructure established and satisfying one specific business need, such as sales reporting. With one phase of implementation completed, the next phases can follow a similar - or precisely tailored approach; and this is much easier than attempting several first-time BI initiatives simultaneously or building a ‘big-bang’ implementation.”
Validation of dimensions
Source: Pete-s random notes [link]
If you have an Oracle data warehouse and are using materialized views for aggregations then Oracle dimension objects would have almost certainly been defined. These objects describe the hierarchical, attribute and join relationships for dimensions and together with database constraints enable the query rewrite mechanism to successfully rewrite queries that navigate dimensional hierarchies.
Drillthrough in AS2005
Source: Chris Webb's BI Blog [link]
![]()

New Book
Source: Pete-s random notes [link]
I see that Digital Press is about to publish a book on Oracle Data Warehouse Tuning for 10g. I hope to pick up a copy of Gavin Powell’s book soon (even though it is not out in the UK for a couple of months) and maybe review it here.
The contents list looks interesting - if only because it is similar to the one I was thinking of for my proposed book ![]()
But being positive, it also means I was