Key concepts and terms
Some key concepts and terms are discussed in this section that you need to understand before you use IntelliMagic Vision.
Table 1 lists the key database terms in this document.
Term | Definition |
---|---|
DBA | The person responsible for installing, configuring, and administering databases in your environment. |
Instance | A database instance is an installed copy of the database software. Although it is possible to have multiple instances on your computer, you will most likely work with a single database instance. An instance can be either a default instance or a named instance, which impacts how to connect to database. |
Database |
A database is a collection of related data. The database stores the data in tables. These tables are grouped in schemas for further separation of data. IntelliMagic Vision typically uses a single database, where each IntelliMagic Vision project uses a dedicated schema within that database.
Tip: Use a single database for IntelliMagic Vision. It is recommended to
have only a single schema per database.
|
Schema |
A schema is a way for the database to logically separate sets of data. There always is a default schema. IntelliMagic Vision typically uses a single database, where each IntelliMagic Vision project uses a dedicated schema within that database. If two or more projects are using the same schema in the same database, it will access and modify each other's data. Note: IntelliMagic Vision can create other schemas. You must have the
privileges to create the other schemas.
|
Machine | The hostname of the Windows machine where the database is installed. |
Port | The TCP/IP port that SQL Server uses to communicate. |