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.

Table 1. Database terms
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.