Technical methods for direct access to ArcSDE vector feature model in RDBMS

Author

Zhou, Longting ; Li, Zhihong ; Li, Qingqing ; Xu, Weili

Author_Institution

Key Lab. of Geogr. Inf. Sci., East China Normal Univ., Shanghai, China

fYear

2011

fDate

24-26 June 2011

Firstpage

1

Lastpage

5

Abstract

In this paper, we focus on the storage schema, encoding/decoding and data compression algorithm of ArcSDE vector feature models in Relation Database Management System (RDBMS). Further, Based on ODBC database accessing techniques, we discuss systematically and implement method for direct access to the ArcSDE vector feature data which is stored in SQL Server 2000 RDBMS with the C++ programming language. Simultaneously the performance and efficiency of the direct-access technique is also analyzed and compared with ArcSDE API. The research indicates that the methods we proposed are practical and the performance is as good as the performance of ArcSDE API.

Keywords

data compression; decoding; encoding; relational databases; storage management; ArcSDE vector feature model; C++ programming language; ODBC database accessing techniques; RDBMS; SQL Server 2000; data compression; decoding; encoding; relation database management system; storage schema; Business; Data models; Encoding; Relational databases; Servers; Spatial databases; ArcSDE; ODBC; RDBMS; direct access; vector feature model;

fLanguage

English

Publisher

ieee

Conference_Titel

Geoinformatics, 2011 19th International Conference on

Conference_Location

Shanghai

ISSN

2161-024X

Print_ISBN

978-1-61284-849-5

Type

conf

DOI

10.1109/GeoInformatics.2011.5980853

Filename

5980853