What is SAP ASE (SAP Adaptive Server Enterprise)?
How does SAP ASE work?
Relational systems, unsurprisingly, use the relationships between data to organize and retrieve information. This is represented by tables, where entries in a row share a relationship and the entries in a column share a different relationship. Which is either obvious, or a why-did-I-never-think-of-it-that-way-before revelation, depending on how much time you've spent thinking about tables.
The information in these tables is further linked from one table to another using keys. Keys denote which columns in one table relate to the columns in another table. In this way, complex data relationships can be mapped and navigated by the DBMS.