The Application of Database Techniques in the Integrated Vessel Information Service System

Integrated Vessel Information Service System (IVISS) was a database system which collected and processed AIS (Automatic Identification System) information, and provided information service to clients. AIS information database was the core of the whole system. Large volume of data, the requirement of hard real-time capability, parallel access and wide physical distribution were features of the system, which gave some difficulties to efficient operations of database. In the paper, several database techniques were studied, including mainly data partitions, indexes, transactions and locks, procedures and functions, replications, and implied to IVISS based on features of AIS information database using SQL Server 2005 as a tool. Comprehensive applications of these techniques improved the whole performance of database, obviously increased the connection number and access rate, and also can provided good guides for other development of large database.