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
Category Archives: Databases
Data Modeling Zone 2013
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!
Week in Review
Over the Christmas season and New Year break, I have been working on my blog www.dwhwiki.info.
Continue reading
ISO 3166 Country Codes for #DWH #BI
A list of country codes, especially interesting for data warehousing projects:
Continue reading
Importing Microsoft Access MDB into @PostgreSQL on #Linux #postgres
To load a Microsoft Access MDB file into a PostgreSQL database there are two steps necessary which are presented in this article.
Continue reading
Vehicle Identification Number (VIN) Validator for #SQLServer
#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
#MySQL Documentation Generator
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
#Adobe PDF IFilter for #SQLServer Full Text Search (FTS)
In order to provide a full-text search index on Adobe PDF documents, there are several options available.
Continue reading
Relationship Types of CA #ERwin
#Architecture #Datamodeling
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.
Continue reading
Supported File Formats for #SQLServer Full Text Search (IFilter)
Ever wondered which file types are supported by Microsoft SQL Server 2012 full text search? This article gives a complete list.