User:Jimbley

Thank you for all the work! In light of said fact, you've been deputised as a wiki sysop. Feel the power!! --CityK 02:02, 5 May 2009 (CEST)

Semantics

I've started to rough-out the details that we will want to collect about devices. This is only a start: support for the many additional broadcast formats will be added later. In addition some of the info here refers to technologies that are yet to be released (e.g. USB3, PCI-E v.3 etc.). As per usual, I initially envisaged an easy data model, but more ideas came to me about how we could implement other features. The basic idea behind my modelling is that data is not duplicated at all and that there are very few (if any) null values. No point reserving memory for empty fields!! I've sketched bits of this in hSQL, because that's what's native to OpenOffice, but I'm not quite there with the model yet. I've also had a few ideas for some handy queries. I'll add these in a bit. As always, comments, suggestions and general abuse are always welcome!!

Device Attributes

• Manufacturer
• Pictures
• Name
• Release date
• Device version
• Interface:
  • USB v.1.1/2.0/3.0
  • PCI v.2.0/1/2/3, v.3.0
  • Mini PCI
  • CardBus
  • CompactPCI
  • PCI-E v.1.0/1, v.2.0, v.3.0
  • IEEE 1394-1995/1394a-2000, 1394b-2002, 1394-2008,1394c-2006
  • PCMCIA v.1,2,3,4
  • ExpressCard/34/54, v.2.0
• Features
  • Analog Format Support
    • NTSC-M/-J
    • PAL-B/G/D/K/I/M/Nc/N/L
    • SECAM
  • Digital Format Support
    • ATSC
    • DVB-T
    • DVB-S
    • DVB-C
    • ISDB-T
  • Radio Support
  • Remote Control
• Support of above features in:
  • Kernel
  • Tree
  • Branch
  • Experimental
  • External
• Level of support for each feature:
  • Fully supported
  • Mainly supported
  • Support unknown
  • Partial Support
  • Unsupported