Chapter
Apr 26, 2012
The Application of Database Techniques in the Integrated Vessel Information Service System
Authors: Zheping Shao [email protected], Cunbao Tang [email protected], Jiacai Pan, and Xianbiao JiAuthor Affiliations
Publication: ICTE 2011
Abstract
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.
Get full access to this article
View all available purchase options and get full access to this chapter.
Information & Authors
Information
Published In
Copyright
© 2011 American Society of Civil Engineers.
History
Published online: Apr 26, 2012
Permissions
Request permissions for this article.
ASCE Technical Topics:
- Automatic identification systems
- Business management
- Client relationships
- Computing in civil engineering
- Connections (structural)
- Data collection
- Databases
- Detection methods
- Engineering fundamentals
- Freight transportation
- Information systems
- Information Technology (IT)
- Infrastructure
- Integrated systems
- Methodology (by type)
- Practice and Profession
- Research methods (by type)
- Structural engineering
- Structural members
- Structural systems
- Systems engineering
- Systems management
- Transportation engineering
Authors
Affiliations
Jimei University, No.1 Jiageng Road, Jimei, XIAMEN, China, 361021.E-mail: [email protected]
Guangzhou Maritime College, No.101 3rd Hongshan Road, Huangpu, Guangzhou, China, 510725.E-mail: [email protected]
Jiacai Pan
Jimei University, No.1 Jiageng Road, Jimei, XIAMEN, China, 361021
Xianbiao Ji
Jimei University, No.1 Jiageng Road, Jimei, XIAMEN, China, 361021
Metrics & Citations
Metrics
Citations
Download citation
If you have the appropriate software installed, you can download article citation data to the citation manager of your choice. Simply select your manager software from the list below and click Download.
View Options
Get Access
Access content
Please select your options to get access
Log in/Register
Log in via your institution (Shibboleth)
ASCE Members:
Please log in to see member pricing
Purchase
Save for later Item saved, go to cart Information on ASCE Library Cards
ASCE Library Cards let you download journal articles, proceedings papers, and available book chapters across the entire ASCE Library platform. ASCE Library Cards remain active for 24 months or until all downloads are used. Note: This content will be debited as one download at time of checkout.
Terms of Use: ASCE Library Cards are for individual, personal use only. Reselling, republishing, or forwarding the materials to libraries or reading rooms is prohibited.
Terms of Use: ASCE Library Cards are for individual, personal use only. Reselling, republishing, or forwarding the materials to libraries or reading rooms is prohibited.
Get Access
Access content
Please select your options to get access
Log in/Register
Log in via your institution (Shibboleth)
ASCE Members:
Please log in to see member pricing
Purchase
Save for later Item saved, go to cart Information on ASCE Library Cards
ASCE Library Cards let you download journal articles, proceedings papers, and available book chapters across the entire ASCE Library platform. ASCE Library Cards remain active for 24 months or until all downloads are used. Note: This content will be debited as one download at time of checkout.
Terms of Use: ASCE Library Cards are for individual, personal use only. Reselling, republishing, or forwarding the materials to libraries or reading rooms is prohibited.
Terms of Use: ASCE Library Cards are for individual, personal use only. Reselling, republishing, or forwarding the materials to libraries or reading rooms is prohibited.