IDERA

Making Time Using Temporal Data

SQL is the first programming language with temporal data types. The SQL-92 standard added temporal data to the language, acknowledging most of what...

Normalization Heuristics

Heuristics and normalization are the goals of all databases. Heuristics refers to a trial-and-error method of problem-solving used when an...

All Skewed Up

Data can be skewed by its nature. How can you tell if you have skewed data in your database? And if you do, how do you handle it when writing...

Relational Division

Dr. Codd’s original relational algebra had eight basic operations. Since relational database management systems are based on set theory, the...