Oracle XE Limitations (CPU, RAM, Data Limits)

Posted on Nov 1, 2010 in Technical Tips | 0 comments

I was trying to make a choice today between selecting MySQL and Oracle XE for a BI project. I didn’t know the limitations off-hand and was surprised I had to start digging through Oracle docs to find it. Here they are for your convenience.

MySQL and SQL Server – Oracle CONNECT BY PRIOR for Recursive, Hierarchical Data

Posted on Feb 24, 2010 in Technical Tips | 0 comments

Recursive queries are something I have used many, many times over the years to build dynamic, n-tiered hierarchies. Oracle’s CONNECT BY PRIOR is awesome.

Does anyone know if this is possible in SQL Server or MySQL?

From what I understand, stored procedures would need to be used in MySQL and SQL Server to accomplish what Oracle does in one SQL statement with CONNECT BY PRIOR. I need to dig into the other databases a bit further to verify, but I am interested in any elegant solutions people have come up with if you would like to share.

Convert INT to BOOLEAN in a SQL SELECT for Multi-Tiered Sorting

Posted on Jun 7, 2009 in Technical Tips | 1 comment

We have a family tree. Some people have children, while others do not. We want to sort results by alphabetically listing individuals with children in an initial group, and then those without children in a second group — also alphabetically. Let’s assume there is not an isParent column (nor the equivalent) on the table, but there is a way to determine how many children each individual has.

Data Validation and Cleansing – Technology, a New “Mouse Trap”

Posted on Jan 19, 2009 in Case Studies, Industry Trends | 0 comments

You lie in wait, looking for your prey, it approaches, and looks around. You spring the trap and
find the spoils of war…the dreaded %20

Ok, maybe not all that exciting, but it brings up an important problem in data conversion and in
application development projects. Namely the importance of input data trapping and input
validation.

Staging Data with MySQL, CSVed, and XAMPP

Posted on Jun 6, 2008 in Technical Tips | 0 comments

The Task: Take and load, using MySQL, a flatfile of over 450 colums and over 145,000 rows of data and put it into a staging table.

The Conditions: The data may not be altered prior to the staging load, or in the staging load. Only when the data is loaded from staging to the final tables may it be altered.