Database programming, of course, is not trivial. In this course we will try to bring closer some of the techniques, problems and solutions to database programming with Delphi along with all the secrets it hides from us. Before we move on to using various data components/tools in Delphi we should first see some of the concepts of database design and try to build a simple database.
Before we start interacting with databases using Delphi, it is a good idea to get a feel what modern databases are about. When you think of a word database you should generally think of any type of data stored inside a computer - even a SomeFile.pas file (code to some Delphi unit) is some kind of database. Another type of database is a Word document or a simple .ini file. To access an .ini file we generally use routines and techniques for typed or untyped files.
Building a modern database application requires us to think of data in a relational way. The basic idea behind the relational model is that a database consists of a series of tables (or relations) that can be manipulated using operations that return tables or so-called views. Simply put, a database is best described as a collection of related data. A database may include many different tables. Tables are like grids where columns are called fields and rows are called ... rows.
To fully address the concepts of database design and relational model we would need an extra online course. For a great overview check out the Fundamentals of Relational Database Design.
Was this article helpful?