Differences between revisions 18 and 19
Revision 18 as of 2008-08-12 16:47:04
Size: 1169
Editor: ?Christian''''''vonEssen
Comment:
Revision 19 as of 2008-08-12 21:21:36
Size: 1186
Comment:
Deletions are marked like this. Additions are marked like this.
Line 3: Line 3:
Ultimate Debian Database (UDD) for short is an effort to create a relational database to encode information about Debian items. Ultimate Debian Database (UDD) gathers a lot of data about various aspects of Debian in the same SQL database. It allows users to easily access and combine all this data.
Line 5: Line 5:
The ultimate goal is to support Quality Assurance of the Debian Project,
by
 1. Providing easy access to the available data
 2. Make often used relations of the data sources available via a web site
The data currently being imported includes:
 * Packages and Sources files, from Debian and Ubuntu
 * Bugs from the Debian BTS
 * Popularity contest
 * History of uploads
 * History of migrations to testing
 * Lintian
 * Orphaned packages
 * Carnivore
More data sources can easily be added (and will be in the near future).
Line 10: Line 16:
As for point 1, the database is currently hosted on a private, non-debian.org host. For Debian Developers, read-only access is available from master.debian.org using a guest account: '''psql -h sappho.ayous.org -U guest udd'''. If you want to work on the DB itself, contact the ayous.org admin team ((he|aba|zobel)@debian.org). Debian Developers and contributors can connect from either '''master.debian.org''' or '''alioth.debian.org''', using:
{{{psql -h udd.debian.net -U guest udd}}}
Line 12: Line 19:
As for point 2, see [ http://udd.debian.net ] Some example queries are available on [ http://udd.debian.net ].
Line 14: Line 21:
 * '''DB schema: [ http://svn.debian.org/viewsvn/collab-qa/udd/src/setup-db.sql?view=markup ]''' For more information, please contact us on #debian-qa or debian-qa@lists.debian.org.
Line 16: Line 23:
== Resources == UDD started as a Google Summer of Code project by Christian von Essen (Neronus), co-mentored by Lucas Nussbaum, Stefano Zacchiroli and Marc 'HE' Brockschmidt.
Line 18: Line 25:
 * [wiki:/HowToConnect Connection HowTo] == (Old?) Resources ==
Line 21: Line 29:

== Involved people ==


 * Lucas Nussbaum
 * Stefano Zacchiroli
 * Marc 'HE' Brockschmidt
 * Christian von Essen

Ultimate Debian Database

Ultimate Debian Database (UDD) gathers a lot of data about various aspects of Debian in the same SQL database. It allows users to easily access and combine all this data.

The data currently being imported includes:

  • Packages and Sources files, from Debian and Ubuntu
  • Bugs from the Debian BTS
  • Popularity contest
  • History of uploads
  • History of migrations to testing
  • Lintian
  • Orphaned packages
  • Carnivore

More data sources can easily be added (and will be in the near future).

Debian Developers and contributors can connect from either master.debian.org or alioth.debian.org, using: psql -h udd.debian.net -U guest udd

Some example queries are available on [ http://udd.debian.net ].

For more information, please contact us on #debian-qa or debian-qa@lists.debian.org.

UDD started as a Google Summer of Code project by Christian von Essen (Neronus), co-mentored by Lucas Nussbaum, Stefano Zacchiroli and Marc 'HE' Brockschmidt.

(Old?) Resources

  • [wiki:?/DataSources data sources] we want to be injected in the db

  • [wiki:/udd.debian.net wiki entry] on [ http://udd.debian.net ]