Whitepaper

If you cruise SQL programming newsgroups, you will eventually find a post for what is called EAV (“Entity-Attribute-Value”) tables. It is a very common schema design error for programmers who started with an OO, work with NoSQL (attribute, value) pairs or a loosely typed programming language.

Cardinality has nothing to do with song birds or Catholic church officials. It is a term from set theory that deals with the size of a set. Originally, Georg Cantor invented the term, so that he could talk about infinite sets like integers, real numbers, irrationals, power sets and so forth.

Pick any two positive integers. Add them and get a third number. Then use the last two numbers and do it again. And again, for a long time. Finally, take the ratio of the last two numbers. Without any other information I am sure that ratio will be ~1.618033988749894848204586834. This is called the Golden Ratio or φ, and it works out to (1 + √5)/2. It occurs as a law of nature. Nobody programmed it, per-arranged it or used a magic trick on you.

Sybase ASE DBAs have always tackled complex tasks amidst shifting priorities, and pressures only continue to mount. This paper outlines trends impacting Sybase ASE DBAs and teaches techniques critical to streamline and automate database management.

As a DB2 DBA, you are expected to keep key database systems available and optimized for high performance. This paper details techniques to streamline and automate the management of critical areas required for high database performance and availability -- regardless of the database type or version.

A new year brings with it a new set of business challenges as wellas fresh opportunity for forward-thinking companies to navigate anincreasingly complex data management landscape.