Normalization is a design technique that is widely used as a guide in designing relational databases. Normalization is essentially a two step process that puts data into tabular form by removing repeating groups and then removes duplicated data from the relational tables.
Author: SSWUG Research
Get more data comparison options in MySQL with operators you may not know
(Melonfire) It’s likely that if you’ve performed a SELECT or UPDATE query in the recent past, you’ve made use of one or more of MySQL’s comparison operators in constraining your query’s output. Comparison is an integral part of most SELECT queries, and MySQL comes with numerous functions for this; a
Getting the difference between two sets of like data
(Louis Davidson) A question came up on the forums the other day that a person wanted to compare two tables of data. Doing this is pretty easy using several techniques: –Using EXCEPT –Using NOT EXISTS –Using a FULL OUTER JOIN
Mastering Enterprise BI: Time Intelligence Pt. I
(William Pearson) As I stated in my article Introduction to SQL Server 2000 Analysis Services: Handling Time Dimensions, it is a rare thing to encounter an instance of an OLAP cube that does not require a Time dimension. Throughout years of business intelligence consulting, I have only witnessed thi
Using BACKUP and RESTORE in SQL Server — Full Backups
(graz) This article covers the basics of full backup backups and restores in SQL Server. The examples are from SQL Server 2005 however it applies to SQL Server 2000 and SQL Server 2005. This is a very basic article covering full database backups, database restores and the simple and full recovery mo
Modifying execution context in SQL Server 2005
(Tim Chapman) Execution context is the identity for which SQL Server permits actions to occur by a user. For example, typically when you log in to SQL Server, the login account is checked for certain permissions. Some of these permissions include the ability to log in to the server, the ability for
Process an XSL-FO Document
(Anghel Leonard) Sometimes you need to process an XSL-FO document that is the result of an XSLT transformation. Actually, the XSL-FO document doesn’t exist, it is just a stream of SAX events.
Oracle up to their same old deceptive tricks
(Chris Eaton) Oracle recently published a report that claims they are easier to use compared to DB2 or SQL Server. What a joke. After reading the IBM response it’s pretty clear that this report is even worse then previous studies Oracle commissioned. It’s also clear from the IBM response that Oracle
Build an Ajax application using Google Web Toolkit, Apache Derby, and Eclipse, Part 3: Communication
(Noel Rappin) In the last two articles in this series, you’ve discovered how to create a simple Web application using the Google Web Toolkit (GWT) and the Apache Derby relational database. Part 1 focused on using GWT to build the front end for a pizza delivery system called Slicr. In Part 2, you got
The Business Benefits of DB2 9
This paper, authored by analyst Philip Howard of Bloor Research, examines the major new features of DB2 9 not only in business terms but with an explanation of how the various technologies work, and where they differ from that of IBM’s competitors in order to understand how these business benefits a