Key data concept – data relationships

Let's quickly review what we learned so far:

  • We covered how data tables are structured
  • We discussed how data tables differ from spreadsheet workbooks
  • We know how to load a datafile into Spotfire

Now, we're going to explore one of the most powerful aspects of data tables: linking or relating the information in two or more different tables. Building structural links between data tables is at the heart of the relational database model that underpins well-known databases, such as Oracle and Microsoft SQL Server. Spotfire is not a relational database as such, but it uses relational principles and provides some table relationship functionality.

If you think back to our discussion of rows and columns, you should be able ...

Get TIBCO Spotfire – A Comprehensive Primer now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.