The MySQL 5.0 Archive Storage Engine

2010-03-12 in DBA, Data Warehouse, MySQL by face | No comments

DBAs facing the problem of corporate data explosion have an excellent new tool to help them in the MySQL 5.0 Archive storage engine. Whether it’s a data warehousing, data archiving, or data auditing situation, MySQL Archive tables can be just what the doctor ordered when it comes to maintaining large amounts of standard or sensitive information, while keeping storage costs at a bare-bones minimum.

via MySQL :: The MySQL 5.0 Archive Storage Engine.

Should probably investigate using ARCHIVE storage for the multi-year history tables

Linked list – Google Patent Search

2010-03-04 in Miscellaneous by face | No comments

A computerized list is provided with auxiliary pointers for traversing the list in different sequences. One or more auxiliary pointers enable a fast, sequential traversal of the list with a minimum of computational time. Such lists may be used in any application where lists may be reordered for…

Inventor: Ming-Jen Wang

Assignee: LSI Logic Corporation

Primary Examiner: John Breene

Secondary Examiner: Cheryl Lewis

via Linked list – Google Patent Search.

Do I have to pay royalties for my homework in 1979?

Three ETL Compromises to Avoid

2010-03-02 in BI, Data Warehouse by face | No comments

Whether you are developing a new dimensional data warehouse or replacing an existing environment, the ETL (extract, transform, load) implementation effort is inevitably on the critical path. Difficult data sources, unclear requirements, data quality problems, changing scope, and other unforeseen problems often conspire to put the squeeze on the ETL development team. It simply may not be possible to fully deliver on the project team’s original commitments; compromises will need to be made. In the end, these compromises, if not carefully considered, may create long-term headaches.

via IntelligentEnterprise : Kimball University: Three ETL Compromises to Avoid (printable version).

MySQL replication recovery

2010-02-27 in DBA, MySQL, Replication by face | No comments

MySQL replication can stop if slave fails to execute SQL statement from the binary log. From that moment, slave prints last error and waits for replication recovery. If master has consistent snapshot, then is only necessary to re-point slave to the new master position. It can be done with change master to or sql_slave_skip_counter.

via MySQL replication recovery.

Applying binary logs without adding to the binary log

2010-02-26 in DBA, MySQL by face | No comments

However, sometimes you want to apply binary logs to a MySQL instance, without having those changes applied to the binary logs themselves. One option is to restart the server binary logging disabled, and after the load is finished, restart the server with binary logging re-enabled. This is not always possible nor desirable, so there’s a better way, that works in at least versions 4.1 and up

via Applying binary logs without adding to the binary log | The Pythian Blog.

SET SESSION sql_log_bin=0;

mysql –xml and some XSLT

2010-01-30 in MySQL by face | No comments

Somebody asked in Freenode the other day how to get their data out of MySQL into a specific XML format.

Both mysqldump and the mysql client have –xml options. The output from the cli looks like this:

via A Little Noise » Blog Archive » mysql’s –xml and some XSLT.

Tags:

A Form of Madness – Dive Into HTML5

2010-01-30 in General by face | No comments

Everybody knows about web forms, right? Make a <form>, a few <input type=”text”> elements, maybe an <input type=”password”>, finish it off with an <input type=”submit”> button, and you’re done.

via A Form of Madness – Dive Into HTML5.

Tags:

Run IT as a business — why thats a train wreck waiting to happen

2010-01-18 in Discussion Items, General, Practice by face | No comments

“If you board the wrong train, its no use running along the corridor in the other direction,” said famed World War II German resistance fighter Dietrich Bonhoeffer. We in IT boarded the wrong train a long time ago. Its the “standard model” of information technology organizations — the familiar litany that says CIOs should run IT as a business [1], meeting the requirements of its internal customers. This refrain has been endorsed by our holy trinity, too: analyst firms, most consultancies, and ITIL.

via Run IT as a business — why thats a train wreck waiting to happen.

Practical Steps for Designing a Dimensional Model

2009-12-22 in Data Warehouse by face | No comments

What does it take to develop a robust dimensional model? Here&apos;s how to get from requirements-gathering to final approval in a process that will ferret out the good, bad and ugly realities of your source data and help you avoid surprises, delays and cost overruns.

via IntelligentEnterprise : Kimball University: Practical Steps for Designing a Dimensional Model (printable version).

Tags:

Slowly Changing Dimensions Are Not Always as Easy as 1, 2, 3

2009-12-22 in Data Warehouse by face | No comments

How do you deal with changing dimensions? Hybrid approaches fill gaps left by the three fundamental techniques

via IntelligentEnterprise : Slowly Changing Dimensions Are Not Always as Easy as 1, 2, 3 (printable version).

Tags:

« Older entries