However, the number of organizations storing other types of data,
such as images, is growing. Often, storage of these types of data is driven by a need
to provide remote users with access.
Spatial Option
The Spatial Option is also relevant in a data warehouse in which data is retrieved
based on proximity to certain locations. Spatial data includes some type of geographic
coordinates. Typically, companies use add-on products in conjunction with
Oracle??™s Spatial Option. An example of this option??™s use for data warehousing is a
marketing analysis application that determines the viability of retail outlets at various
locations.
XML
Oracle added native XML datatype support to the Oracle9i database, along with
XML and SQL interchangeability for searching. Oracle provided key technology in
the development of the XQuery standard, and began shipping a production version
of XQuery with Oracle Database 10g Release 2. XML database performance was
greatly improved in Oracle Database 11g through the introduction of binary XML.
Oracle estimates that binary XML offers performance gains of up to 15 times compared
to the XML LOBs that were previously available.
Pages:
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519