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.
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!
A list of country codes, especially interesting for data warehousing projects:
To load a Microsoft Access MDB file into a PostgreSQL database there are two steps necessary which are presented in this article.
#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.
Just found a nice and free documentation generator for MySQL:
Platform Independent: http://www.mysqlwiki.info/wp-content/uploads/2011/04/MySqlWiki-jar.zip
In order to provide a full-text search index on Adobe PDF documents, there are several options available.
CA ERwin supports three types of logical relationships between entities:
- Identifying relationships
- Many-to-many relationships
- Non-identifying relationships
This article explains these three relationship types in more detail in the following sections.
Ever wondered which file types are supported by Microsoft SQL Server 2012 full text search? This article gives a complete list.