Managed Database Architecture

Managed Database Architecture
calac41
This article describes the operation of managed databases and is intended for IT architects.
In this article:
Interoperable with Database Tools
As with existing databases, you can use familiar database tools to change your schema.
If you change the schema, you must reload the schema.
For more information about how to reload the schema, see Database Administration.
Schema Creation
When you create a new database (schema),
CA Live API Creator
 creates a schema with a randomized user, schema, and password. You can change these, depending on your database (for example, you cannot rename MySQL schemas).
If you change the user, schema, or password, you must reload the schema.
For more information about how to reload the schema, see Database Administration.
Table Creation
The tables that you create include the 
ident
and
Name
columns and a sample row. The
ident
column is an autonum (identity) column. The
Name
column is a text field.
For more information about how to create tables, see Manage Tables in Managed Databases.
Field Creation
Fields represent the columns in your database. The term field is used to connote the mental model of a physical screen, rather than an abstract database notion. Accordingly, API Creator maps field types to column types, particularized for the target database type.
You can determine the fields using Data Explorer or using API Creator.
For more information about how to determine fields using Data Explorer, see Manage Tables in Managed Databases.