Client-server database system with transactional
support (including multi-statement transactions), multi-threaded server, and
support for large volumes. Many of these properties are provided by our use
of the SHORE V2.0 storage manager.
Standard relational query processing capability
through SQL queries (can run the TPC-D benchmark).
Multiple join algorithms are supported, with the
ability to add new algorithms. New algorithms are being developed.
Extensible implementations of query optimization
techniques like query rewrite and join ordering are provided.
A variety of cost-based optimizers are provided, and
new optimizers can be added.
Extensibility with complex data types. The data
types can define methods and aggregates which can be used within SQL
queries. Several sample data types (document, polygon, point, raster, date,
bytearray) are provided.
Optimizations of queries involving complex data
types -- this is the focus of our research activity. The system supports
Enhanced Abstract Data Types (E-ADTs) which expose optimization semantics
for methods.
B+ tree and R* tree indexing (with the ability to
add new indexes) over simple and complex expressions.
A variety of client libraries, including JDBC2.0 and
ODBC3.0 drivers as well as a Java library to build Web-based client applets,
and a C++ library for CGI-based Web applications. Extensible client-side
data types to match server-side E-ADTs.
Query processing analysis tool (QPDisp) showing
query plans, and results of query rewrite transformations.
Builds on Sparc/Solaris using gcc2.8.0 and gcc2.9.0.
Builds on WindowsNT 4.0 using MS DevStudio
6.0.
| Builds on Linux using egc.
| | | | | | | | | | | | |