Databases are another fundamental concept of Composable Architecture Platform. In Composable Architecture Platform terminology, a database is anything that can be connected to via a JDBC driver.
JDBC drivers are connectivity modules for the Java language.
The term database refers to a system that is capable of storing data in a structured relational manner.
Alongside databases, there are a couple of terms that are important, which are listed below (Tables through Keys).
Tables are the name of the individual file within the database where a given set of data is stored. Sample table names are CUSTOMERS and ACCOUNTS. Some Composable Architecture Platform rules have the ability to create tables or read/write data to them.
A schema is a way to segment a database into multiple entities i.e. there can be two schemas on the same database containing the same table names. For example, there can be a PRODUCTION schema that contains an ACCOUNTS table as well as a TEST schema that contains an ACCOUNTS table.
Rows and columns refer to the individual elements inside a table. For example, like a spreadsheet where all of the columns have a name.
Typically, all tables have keys that map to one or more columns in the table. In most cases tables have unique keys, which is enforced at the database level.