Applications are made up of business logic, interaction with other systems, user interfaces ... and persistence. Most of the data that our applications manipulate has to be stored in databases, retrieved, and analyzed. Databases are important: they store business data, act as a central point between applications, and process data through triggers or stored procedures. Persistent data is everywhere, and most of the time it uses relational databases as the underlying persistence engine. Relational databases store data in tables made of rows and columns. Data is identified by primary keys, which are special columns with uniqueness constraints and, sometimes, indexes. The relationships between tables use foreign keys and join tables with integrity constraints.
KeywordsRelational Database Main Class Structure Query Language Entity Manager Enterprise Information System
Unable to display preview. Download preview PDF.