Introducing the Steel Wheels sample database
As you were told in the first chapter, there is a Pentaho Demo that includes data for a fictional store named Steel Wheels and you can download it from the Internet. This data is stored in a database that is going be the starting point for you to learn how to work with databases in PDI. Before beginning to work on databases, let's briefly introduce the Steel Wheels database along with some database definitions.
Note
In this book, we will learn about relational databases. You should know that there are several database genres other than relational (big data, document, graph, and more). Not all databases are row/columnar like the relational ones.
A relational database is a collection of items stored in tables. Typically, all items stored in a table belong to a particular type of data. The following table lists some of the tables in the Steel Wheels database:
|
Table |
Content |
|---|---|
|
|
Steel Wheels' customers |
|
|
Steel Wheels... |
