2004 UC Proceedings Abstract
 Evaluating SDELOB and SDEBINARY Storage Mechanisms in ArcSDE Track: Database Design, Automation, and Management Author(s): Brad Gellerstedt, Mark Harley When using ArcSDE with an Oracle database, the default compressed binary storage mechanism for geometry types is SDEBINARY, which uses the LONG RAW datatype in Oracle. However, this geometry storage option has some limitations. For example, Oracle replication cannot handle LONG RAW datatypes. Additionally, Oracle may desupport the use of LONG RAW in some future release. An alternative is to use the SDELOB mechanism, which uses BLOB datatypes in Oracle. However, are there any performance implications for converting to SDELOB? What other considerations should be addressed? This paper presents the results of an evaluation, benchmarking the SDELOB and SDEBINARY types. Recommendations are presented on the suitability of each method for specific situations. Brad Gellerstedt Geographic Data Technology, Inc. 11 Lafayette St Lebanon , NH 03766 US Phone: 603-643-0330 Fax: 603-653-0249 E-mail: brad_gellerstedt@gdt1.com Mark Harley Geographic Data Technology, Inc. 11 Lafayette St Lebanon , NH 03766 US Phone: 603-643-0330 Fax: 603-653-0249 E-mail: mark_harley@gdt1.com |
|||||
