How Are Schemas Used in the Landmark Database?

Schemas separate the data for each product line and data area in Infor Lawson System Foundation and Landmark.

Landmark implements database schema at the SQL level, by placing an additional name space onto the tables. For example, instead of one employee table in the database, the configuration can be schema1.employee table and schema2.employee tables, both in one database. This avoids distributed transactions (XA or two-phase commits).

Since the same database connections are used for transactions in both environments, ACID transactions are maintained. Lawson used this implementation as it allows data updates in non-distributed transactions when the schema is specified in the dictionary (using the dataarea.xml file).