I’m preparing a chapter that describes our research at Santa Clara University. While reading, I found a paper with a [nowadays] funny comment about the search engine infrastructure of Alta Vista.
Continue reading
Regardless of whether you are working on a traditional or big data project, business intelligence analytics or transactional systems, new or legacy systems – data is at the heart of what we do and therefore data modeling is a critical success factor of any development effort. Improve you data modeling skills this year at DMZ!
Over the Christmas season and New Year break, I have been working on my blog www.dwhwiki.info.
Continue reading
A list of country codes, especially interesting for data warehousing projects:
Continue reading
To load a Microsoft Access MDB file into a PostgreSQL database there are two steps necessary which are presented in this article.
Continue reading
#DWH #BI #Automotive
In my last article, I focused on Vehicle Identification Numbers (VINs), about their structure and how to verify them in a data warehouse setting. This article focuses on an implementation of a VIN Validator for Microsoft SQL Server. The validator implements all the checks discussed in the earlier article. The downloadable source code can be found at the end of this article.
Continue reading
Just found a nice and free documentation generator for MySQL:
Platform Independent: http://www.mysqlwiki.info/wp-content/uploads/2011/04/MySqlWiki-jar.zip
Windows: http://www.mysqlwiki.info/wp-content/uploads/2011/04/MySqlWiki.exe
In order to provide a full-text search index on Adobe PDF documents, there are several options available.
Continue reading
#Architecture #Datamodeling
CA ERwin supports three types of logical relationships between entities:
This article explains these three relationship types in more detail in the following sections.
Continue reading
Ever wondered which file types are supported by Microsoft SQL Server 2012 full text search? This article gives a complete list.
