1 / 11

CVSQL 2

CVSQL 2. The Revenge of the SQL. The present. Read-only access to CVS repository logs Language is a subset of SQL XML interface for returning results Built-in network server JDBC driver. The future. Cleaner client-server design Improved SQL support Support for different log files

ross-osborn
Download Presentation

CVSQL 2

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CVSQL 2 The Revenge of the SQL

  2. The present • Read-only access to CVS repository logs • Language is a subset of SQL • XML interface for returning results • Built-in network server • JDBC driver

  3. The future • Cleaner client-server design • Improved SQL support • Support for different log files • Web service • Improved JDBC driver • Distributed Awareness • Security

  4. JDBC Driver • Improve Existing Code • Eliminating hardcoded values • ”1.0” in DatabaseMetaData, “<resp>” in CVSQLAPI, etc • Create more useful errors and exceptions(CVSQLAPI, DatabaseMetaData, etc) • Some messages do not reflect an incorrect method • Some messages are not useful • Improve socket connection handling in CVLSQLAPI • Support for transparent socket reconnection • Better state reporting (socket is really connected?)

  5. JDBC Driver (cont'd) • Improve Existing Code (cont'd) • Improve robustness in CVSQL Server <-> JDBC Connection protocol parsing • Fail gracefully with corrupt or incorrect data • Reduce memory consumption • Add Metadata Support • List database tables and column types • Retrieve ResultSet table information (?) • Rework logging and debugging • Configurable log files (simple), Log4J (flexible),Elimination from Driver (proper?)

  6. Distributed Awarness • Palantir http://www.ics.uci.edu/~asarma/Palantir/ • Non-intrusively break the workspace isolation • Provide real-time awarness to configuration management systems • Possible integration with CVSQL?

  7. CVSQL Core • Backend modularity • Each module provides support for one log file format • Reworked CVS log files support • Client-server design • Proper separation of client and server • Client is “dummy” and only knows how to send the query to the server and how to get the results back • Security • Better handling of users and passwords

  8. CVSQL Core (cont’d) • Improved SQL support • select from multiple tables (JOIN) • new aggregate operators • SQL engine rework • decoupling of parsing from execution • removing hardcoded values • Web Services • Client-server communication using standard XML-RPC protocol

  9. The people

  10. The work

  11. Questions? • Will my vacuum cleaner continue to work with the new CVSQL? • Yes ;-) Although we will make many changes to the system, we will ensure that it stays backwards compatible wherever possible (e.g. existing cvs table columns) • Any more questions? Thank you CVSQL 2 Team

More Related