(Formerly known as XTOSS: The XML Team Open Sports Schema.)
The goal of SportsDB is to spur development of applications that can make use of a database schema designed from the top-down to be accommodating for data published by multiple sources, covering myriad sports, and cross-referencing many different types of content. The schema builds upon 5 years of work by XML Team Solutions in supplying tools that parse SportsML, load it into databases, execute queries, and format the results. Typical applications that could make use of this standard include:
SportsDB has been designed to model "Sports Reality" as effectively as possible in a relational database context. The schema inherits from the open SportsML standard, adopting its vocabularies and core approach toward commonalities among the sports. It is capable of supporting queries for the most intense of sports data applications, yet is simple enough for use by those with minimal database experience. Finally, SportsDB enables streamlined coding techniques, where possible, through adoption of naming standards accessible to many popular model-view-controller publishing software frameworks.
The SportsCaster Web Service is a companion to SportsDB, and has also been released under GNU General Public License. SportsCaster allows you to create web pages by writing custom URLs, rather than by writing custom SQL queries. See the link at left for details. SportsCaster can be used in conjunction with the SportsMLT Conversion Library for finer control over content renditions.
Not many changes with SportsDB 23 -- most notably, includes an abstract_blob field to correspond to SportsDB 22's sportsml_blob field. Now users have the choice of storing SportsML files on the file system, or directly in the database.
We skipped a public release of Build 21, so no need to be alarmed. Build 22 includes such advances as expanded general stats and ice-hockey capabilities, a new rankings table, and more.
The latest build for SportsCaster now includes support for SQL Server, and also includes a nifty debug-mode that prints out all SQL Queries employed (available when asking for HTML renditions of content).
As a companion to SportsDB, the SportsCaster Web Service has been released under GNU General Public License. SportsCaster is a PHP framework for querying your database. It allows you to create web pages by writing custom URLs, rather than by writing custom SQL queries.
As a companion to SportsCaster, the SportsMLT Conversion Package has also been released under GNU GPL. SportsMLT is an XSLT conversion library for SportsML, which of course can get stored within SportsDB, or generated by SportsDB query results.
While both SportsCaster and SportsMLT have been in use by many sports websites as earlier iterations, these first GNU GPL releases should be considered "beta." Your comments and involvement are welcome.
Improvements include generic action-tables (for sports with no specific action tables), expanded tennis stats, additional fields useful for storing Olympics results, and other minor adjustments.
Improvements include new play-by-play tables for soccer, adjusted standings tables, and new tables for awards and records.
Improvements include play-by-play tables for ice hockey, a better person_phases table, and impoved indexing for display_names.
Improvements include better pitch-by-pitch storage for baseball, and expanded weather details.