Partitioning with Oracle Database 12 c

Oracle Partitioning with Oracle Database 12c

Partitioning in Oracle Database 11g Release 2

Managing XML Data to optimize Performance into Object-Relational Databases

This paper propose some possibilities for manage XML data in order to optimize performance into object-relational databases. It is detailed the possibility of storing XML data into such databases, using for exemplification an Oracle database and there are tested some optimizing techniques of the queries over XMLType tables, like indexing and partitioning tables.

Statistics Collection in Oracle Spatial and Graph: Fast Histogram Construction for Complex Geometry Objects

Oracle Spatial and Graph is a geographic information system (GIS) which provides users the ability to store spatial data alongside conventional data in Oracle. As a result of the coexistence of spatial and other data, we observe a trend towards users performing increasingly complex queries which involve spatial as well as non-spatial predicates. Accurate selectivity values, especially for queri...

Study on 3D Simulation Optimization for Digital Basin of Large-Scale Landform

-For the need of digital basin 3D simulation, the paper proposes a visualization optimization method for large-scale landform and flow pattern. Based on call of landform data partitioning organization and dynamic processing of visual regional data, for the present situation of commonly using ADO(ActiveX Data Objects) developing interface to realize the operation for database, OCI (Oracle Call I...