internet monitor internet monitor buy statlook internet monitor internet monitor
surveillance software
surveillance software
screen capture
remote desktop
internet monitor
productivity improvement
spector pro
surveillance software
-- previous chapter -- -- table of contents -- -- next chapter --
Database

The database is the most important part of uplook software. It stores all settings for network, user and software configuration. All data sent from monitor software is also stored in the database.

Using build-in functions you can perform the following operations for a database:

The Default database engine in uplook is Microsoft Jet (Access).

However, in the extended version of uplook you can use also Microsoft SQL Server 2000 or Microsoft Desktop Engine (MSDE). In the table below parameters of several database engines have been compared.

  Microsoft Jet
(Access)
Microsoft SQL Server
  Enterprise Edition Standard Edition Workgroup Edition Personal Edition Express Edition MSDE
Maximum number of processors   32 4 2 2 1 2
Maximum size of used memory   64 GB 2 GB 2 GB 2 GB 1 GB 2 GB
Maximum size of database 2 GB 1 048 516 TB 1 048 516 TB 1 048 516 TB 2 GB 4 GB 2 GB
Maximum number of objects 32 768 2 147 483 647
Maximum number of table columns 255 1024
Maximum size of one table 1 GB limited by disk size
Maximum number of indexes 32 250
Maximum number of columns in one index 10 16
Maximum number of tables in a query 32 256
Maximum number of columns in SELECT query 255 4096
Maximum number of nested queries 50 32
Maximum number of linked relations 32 253
Maximum size of SQL queries 64 000 B 65 536 B * packet size (default: 4 KB)

 

-- previous chapter -- -- table of contents -- -- next chapter --
surveillance software