The Financial Data Problem

• Compare
• As per the Web
• The Real Financials
• Google is worse
• Thousands of CFA's and PhD's all go to the same schools, purchase the same tools connect to the same database and try to outperform each other
• Institutional Databases have about 2K "fields"
• XBRL base taxonomies have over 12K "tags"

You can currently view "full financials" via Openvest Primary Financials

XBRL

• XML as done by the AICPA
• The X in XBRL means eXtensible (and the really mean it)
• VERY complex
• Discoverable Taxonomy Set (DTS) for a typical filings expands to include 20-40 XML files (only one with data)
• Uses XLink and Linkbases
• SEC Mandate

  XBRL is what a corporate financial statement would be like
  if it were created by a mutant, alien accountant
  bitten by a radioactive XML spider.

  • Could be widely abailable via edgar by Q3 '08
  • SEC Mandate
• Openvest tools were developed for the Consumers of financial data

RDF

• Your Relational Databases were OK ... cira the turn of the century
• Every value in a relational table is a row, column value "triple"
• Every value in an rdf triplestore is a subject, predicate object "triple"
• All the databases on the web or not can be turned into one large database space
• Graph databases are best when:
• You data is highly linked (e.g. foreign key relationships, and/or url's)
• You have a table where a row has the field names for an extensible schema
• You never want to modify your schema again (and again)
• you are not sure what to put in and what to keep out

RDFAlchemy a new ORM

Object Relational Mappers (ORM's) for SQL
• Java: Hibernate, iBatis, Cayenne ...
• Python: SQLAlchemy, Elixir
• Ruby: Active Record

RDFAlchemy is to Triple Stores
as
SQLAlchemy is to Relational Databases

RDFAlchemy

RDFAlchemy is the easy way to access your rdf triples.

Openvest XBRL SPARQL Endpoint

Live Endpoint available at:
http://www.openvest.com:8080/openrdf-sesame/repositories/Portfolio

SPARQL is to triple stores
as
SQL is to relational databases

• Sesame Workbench (Portfolio endpoint)
• Tabulator