Databases
Get flash to fully experience Pearltrees
Need to learn SQL Server development? This package does not contain the database, only the tools to manage SQL Server instances, including LocalDB, SQL Express, SQL Azure, etc. Use this if you already have the database and only need the management tools. SQL Server Express LocalDB (MSI installer) Need to embed SQL Server Express into an application? New to the Express family, LocalDB is a lightweight version of Express that has all its programmability features yet runs in user mode and has a fast, zero-configuration installation and short list of pre-requisites.
SQL Server 2008 R2 Express - Overview
Welcome | The Data Warehousing Information Center
In existence since 1995, this site is a collection of one practitioner’s essays. Most of the essays focus on timeless aspects of the subject. The aim is to give you a taste of the good and (unlike most web sites) the bad in data warehousing and business intelligence.
TDWI
Chicago, Il // May 6 - 11, 2012 At the TDWI World Conference in Chicago, we’ll provide essential BI/DW courses and go beyond to discuss evolving technologies such as Hadoop, MapReduce, big data analytics, and social media. We’ll also cover the important topics people are working on today, including data quality, data governance, ETL, and agile development.
OLAP Software and Education Wiki - OLAP
Welcome to OLAP.com. If you are interested in contributing to this wiki, we welcome your participation. Please email us with a brief description what you would like to contribute and your area of expertise. What is OLAP? OLAP is an acronym for On Line Analytical Processing.XML From the Inside Out -- XML development, XML resources, XML specifications
News The agile upside of XML Frankfurt TOC presenters Anna von Veh, a consultant at Say Books, and Mike McNamara, managing director at Araman Consulting Ltd & Outsell-Gilbane UK Affiliate, discuss xml workflows, the (sorry) state of ebook design, and how books and the web will evolve.… read more Jenn Webb XML Schema development approaches The way that people approach developing schemas has evolved over the years: each new approach grows out of problems with the status quo (see Hegelian dialectic) but enriches rather than supplants. I thought I would take a little walk through...… read more Rick Jelliffe ETL and Publishing I have for a few years been trying to come up with a good definition of publishing workflows: as an architectural pattern.
XML representation of a relational database
A relational database consists of a set of tables, where each table is a set of records . A record in turn is a set of fields and each field is a pair field-name/field-value . All records in a particular table have the same number of fields with the same field-names. This article describes an application of (a simple subset of) XML that can be used to represent such a database. The relational data-model also defines certain constraints on the tables and defines operations on them.
Native XML Database
What is an XML Schema? Some of you may already know this, others don’t. So before I’m going to share some more technical information about XML Schemas in subsequent blog posts, I better get some of the basics out of the way first. When you process and manage information in XML format, you can choose to use an XML Schema with your XML documents.
Data-centric model : In a data-centric model where data is stored in a relational database or similar repository; one may want to extract data from a database as XML, store XML into a database or both. For situations where one only needs to extract XML from the database one may use a middleware application or component that retrieves data from the database and returns it as XML. Middleware components that transform relational data to XML and back vary widely in the functionality they provide and how they provide it. For instance, Microsoft's ADO.NET provides XML integration to such a degree that results from queries on XML documents or SQL databases can be accessed identically via the same API.
XML & Databases
This paper gives a high-level overview of how to use XML with databases. It describes how the differences between data-centric and document-centric documents affect their usage with databases, how XML is commonly used with relational databases, and what native XML databases are and when to use them. NOTE: Although the information discussed in this paper is (mostly) up-to-date, the idea that the world of XML and databases can be seen through the data-centric/document-centric divide is somewhat dated. At the time this paper was originally written (1999), it was a convenient metaphor for introducing native XML databases, which were then not widely understood, even in the database community. However, it was always somewhat unrealistic, as many XML documents are not strictly data-centric or document-centric, but somewhere in between.
XML and Databases
Better Together: Pentaho tightly couples data integration with business analytics in a modern platform that brings together IT and business users to easily access, visualize and explore all data that impacts business results
Open Source Business Intelligence - Open Source Reporting, ETL & Data Integration and OLAP | Pentaho
The Data Administration Newsletter: Articles by Joe Celko
In this column, Joe Celko tells us that Intelligent Design depends on the concept of “Irreducible Complexity,” which says that some things are so complex that they could not have evolved and therefore have to have been created all at once. Joe Celko emphasizes that the bottom line is that there is no voting system that satisfies simple criteria for fairness. Consensus is a nice goal, and we can certainly aim for it on a project team. But there is no magic.© 2012, Oracle Corporation and/or its affiliates
MySQL :: The world's most popular open source database
The PostgreSQL Global Development Group announces updates for all active branches of the PostgreSQL object-relational database system, including versions 9.1.3, 9.0.7, 8.4.11 and 8.3.18. These releases fix a number of bugs, including multiple security related bugs.