8

Fields, Records, and Tables

Molecules

In this chapter, we will look at field and record structures. These are directly related to database topics and object modeling, since the fields and records are normally written to an RDBMS as an alternative to saving things in a file. Objects are constructed from the RDBMS or serialized file data.

We won’t be delving too deeply into database design, since that has been amply covered in other books. We will look deeply enough to uncover some potential pitfalls though.

Record Structures

Understanding different kinds of record-structured files and data helps to select the right storage mechanisms when we build databases into the workflow process. You may need to translate the data from TSV to an SQL format. ...

Get Developing Quality Metadata 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.