|
 |
 |
 |
 |
The Data Management & Warehousing Knowledge Base provides information and techniques about the design, build and implementation of data warehousing solutions that we as a company use and hope that you will also find useful.
- How Data Works
-
How business store and manage their data can have critical effect on data quality and consistency as well as performance and development times. This paper examines how data works and explores techniques exploited from understanding how data works
Updated:
- Continuous Data Quality Process Wallchart
-
A wallchart outlining the process required to develop continuous data quality within an organisation is available for download
Updated:
- Data Warehouse Documentation Roadmap
-
All projects need documentation and many companies provide templates as part of a methodology. This document describes the templates, tools and source documents used by Data Management & Warehousing. It serves two purposes:
* For projects using other methodologies or creating their own set of documents to use as a checklist. This allows the project to ensure that the documentation covers the essential areas for describing the data warehouse.
* To demonstrate our approach to our clients by describing the templates and deliverables that are produced.
Updated:
- Data Warehouse Governance
-
An organisation that is embarking on a data warehousing project is undertaking a long-term development and maintenance programme of a computer system. This system will be critical to the organisation and cost a significant amount of money, therefore control of the system is vital. Governance defines the model the organisation will use to ensure optimal use and re-use of the data warehouse and enforcement of corporate policies (e.g. business design, technical design, and application security) and ultimately derive value for money.
Updated:
- Overview Architecture for Enterprise Data Warehouses
-
This is the first of a series of papers published by Data Management & Warehousing to look at the implementation of Enterprise Data Warehouse solutions in large organisations using a design pattern approach. A design pattern provides a generic approach, rather than a specific solution. It describes the steps that architecture, design and build teams will have to go through in order to implement a data warehouse successfully within their business
Updated:
- Job scheduling - fixed and relative timing
-
This article looks at the relatve merits of two types of processing schedule, once based on a fixed times (similar to 'cron' on a unix system) and onebased on relative times (similar to 'at' on a unix system)
Updated:
- Data Transformation - Procedural and Non-Procedural Solutions
-
This paper looks at a somewhat awkward data transformation, and at solutions written in SQL and in a procedural language. It describes some techniques which can be used to develop the solution in both languages. It also compares the solutions in terms of ease of development, performance and cost of maintenance.
Updated:
Category: Data Warehousing
More Feeds
|
 |
 |
 |
 |
|
|
|
|
- The Operational Data Store - Thursday's Child
- Perhaps the sparsity of attention paid to the operational data store (ODS) stems from the fact that the architectural structure of the ODS is a lot more free-form than other parts of the information
infrastructure.
- Enterprise Data Management and its Tight Coupling with Data Warehousing and Business Intelligence
- In this article, Ajay Bhargava highlights the important trend of tighter coupling between enterprise data management (EDM) and data warehousing/business intelligence. He also lays out some critical
components of an EDM strategy.
- Are Relational Database Systems Keeping Up with the Information Processing Needs of Companies?
- To satisfy increasing information volumes, a variety of new database techniques are appearing on the market. Does this mean that after over a quarter century of development, relational database
systems are reaching the end of their useful lives?
- Web 2.0 and Social Media: Two Worlds, Two Dress Codes, No Answers
- It is really unknown how social media and Web 2.0 can help your business, but it is a phenomenon that cannot be ignored.
- The Changing Face of Business Intelligence
- Dave Wells predicts that the next evolution of business intelligence will happen soon, it will happen quickly, and it will expose and overcome the self-delusion that is part of business analytics
today.
- Products and Architecture
- An architecture for information for a company is hard to define because it has so many facets. Bill Inmon describes some of the elements an architecture would surely include.
- More on Master Data Management and Cross-Selling
- Effective customer profiling depends on a unified view of the customer characteristics collected via each one of an organization’s sales channels. Master data management provides a framework
for unifying that view and enabling a comprehensive profiling process in preparation for the next phase, which includes collaborative filtering and market basket analysis.
- The Sweet 16: Emerging Best Practices in Data Governance, Part 2
- In this issue of the Jill Dyché Data Governance newsletter, Jill’s colleague Michael Lombard continues to describe a set of 16 data governance best practices. In this issue, he
introduces the category of “operational” best practices.
- New Rules for Performance Management, Part 3
- This article, the conclusion of a three-part series, examines specific features to look for when selecting a business performance management financial consolidation and reporting solution.
- How the New Obama Administration Might Impact Business Performance Management
- The 2008 election was a campaign of change for both the executive and legislative branches of the U.S. government; now it is up to performance management professionals to find a way support that
change from a software and systems perspective.
- Portals Must Evolve to Capture New Customers in the Web 2.0 World
- What is the role of portals in an era of Web 2.0? It’s more important than ever that companies deliver the right information, in the right format, at the right time to their customers,
preferably before they know they even need it.
- Enterprise Decision Management and Decision Intelligence
- James Taylor explains how organizations that adopt decision intelligence and enterprise decision management can become decision-centric organizations.
- Motivations for Building the Data Warehouse
- Bill Inmon provides a review of the factors that motivate organizations to build corporate data warehouses.
- Data Warehousing Roundup
- In this article, Lou Agosta explores more trends in data warehousing, focusing on Aster Data Systems, SGI and Dataupia. Lou also looks at entry-level database alternatives for those who don’t
want to get involved in data management.
- Ten Tips for Aligning Business and Business Intelligence
- Maureen Clarry provides tips to help to create alignment between business and business intelligence/data warehousing initiatives.
Category: Uncategorized
More Feeds
|
|
|
|
|
|
|
|
|
|
Who's Online
There are currently 7 guest(s) and 0 member(s) online. You are an Anonymous user. You can register for free by clicking hereNo Members are currently logged in.
Your IP address :
38.103.63.60
Your country is : Unknown 
|
|
|
|
|
|
