Evolution of Florida Department of Transportation's Roadway Characteristics Inventory (RCI)
The Florida Department of Transportation's Roadway Characteristics Inventory (RCI) has evolved significantly since its inception in 1975, transitioning from a hierarchical IMS mainframe database to a web-based DB2 relational database in 2004. The RCI system now incorporates features for both Plannin
0 views • 10 slides
Evolution of Database Management Systems
The evolution of Database Management Systems (DBMS) began with file systems and punched cards in the 1950s, followed by hierarchical and network models in the 1960s and 1970s. The 1980s introduced relational databases like Ingres, Oracle, DB2, and Sybase. The 1990s saw the rise of object-oriented an
0 views • 31 slides
Achieving High Availability with DB2 HADR
Explore the concept of High Availability Disaster Recovery (HADR) in DB2, including its introduction in version 8.2, log-based replication, and its benefits for ensuring High Availability (HA) and Disaster Recovery (DR) at remote data centers. Learn about HADR's bundling with all DB2 versions (excep
0 views • 67 slides
Enhancements to DB2's Cost-Based Optimizer for XML Support
This paper discusses the acceptance of XML as a language for data interchange and the development of DB2 XML by IBM. It focuses on the extensions made to DB2's cost-based optimizer, emphasizing its support for XQuery as a query language. The paper also explores the largely declarative nature of XML
0 views • 20 slides