UDSP incorporates the powerful Oracle^® Asset Database 10g, which provides exceptional scalability and high performance. This data warehouse is the is recognized industry leader in scalability.

It is specifically designed to handle large amounts of data for the frequent, complex queries inherent in utility decision support. It also accommodates constantly growing data volumes, accessing applications, and users — so it can expand as your operations change.

Oracle^® Asset Database 10G is runs on a wide range of hardware and operating systems. It supports all major Unix platforms, including Linux^®, Microsoft^®, and others, such as OS/390 mainframes. With this database, utilities can upgrade hardware and operating systems without changing trusted applications. This helps protect your software investment ensure consistent performance.

View an animated demo of the Oracle^® Asset Database with the Topology Data Engine.

Advantages of Oracle^® Asset Database

• Superior concurrency. In multi-user environments, concurrency control helps ensure that data updates made by one user do not compromise those made by other users. The Oracle^® Asset Database implementation of multi-version read consistency provides consistent, accurate results. It is designed to prevent the most frequent problems in multi-user environments, such as uncommitted reads, non-repeatable reads, and phantom reads.



• Powerful indexing. Using indexes can dramatically increase the speed of data retrieval. The Oracle^® Asset Database supports the industry’s widest range of indexing schemes, including standard B-Tree indexing and index-organized tables, as well as static bitmap indexes and bitmap join indexes, both of which deliver critical advantages in performance for data warehousing.



• Flexible partitioning. Partitioning helps break up large tables and indexes into smaller, more manageable pieces. Oracle^® Asset Database supports a complete line of partitioning options and combinations to maximize performance in real-world online transaction processing (OLTP) applications.



• Parallel execution. This significantly improves performance for operations that involve large volumes of data. Specifically, it helps reduce response time for data-intensive operations in large databases associated with decision support. Oracle^® Asset Database executes insert, update, delete, and merge statements in parallel when accessing partitioned and non-partitioned database objects.



• Clustering. Clusters are groups of connected independent servers that work in unison as a single system. Clusters allow applications to scale beyond the limits of a single server. Only Oracle^® Asset Database supports clustered configurations for maximum scalability on demand.