Improving join-performance of SQL databases
Cheatsheet on Relational Database Design
A relational database is a type of database that organizes data into structured tables, also known as relations. These tables consist of rows (records) and columns (fields).
Some key points to know about Relational Database Design
1 - SQL
SQL is the standard programming language used to interact with rela... See more
We have developed a tool for testing Oracle database performance. The tool connects to a database, executes a set of SELECT statements, and records their execution times. It can also execute queries in parallel by using a connection pool of multiple connections, thus simulating a real-life workload on a database. Performance test runs can be schedu
... See moreRittman Mead • Oracle Database Performance Testing the Easy Way
SQL is also easy to generate for many common analytical algorithms that have fairly simple scoring logic. Linear regression, logistic regression, and decision trees are examples that fall into this category. Analytic tools will often translate the logic from a model into SQL for the user.
Bill Franks • Taming The Big Data Tidal Wave: Finding Opportunities in Huge Data Streams with Advanced Analytics (Wiley and SAS Business Series)
First, if and when you need to merge two databases that now have the same Primary Key ID values for the same table, your screwed. You have to come up with a scheme to change the ID’s, maybe adding 10,000 to each ID, what if you have more than 10,000 rows? The you also have to update all children records, maybe not that easy if you have constraints ... See more
Tom Jay • Stop using Integer ID’s in your Database
The first generation of data products, such as CDDB, were essentially a single database. More recent products, such as LinkedIn’s Skills database, are composites: