Difference between revisions of "Benchmark Datasets"

From Schema Evolution
Jump to: navigation, search
 
(35 intermediate revisions by 3 users not shown)
Line 1: Line 1:
This page contains a brief summary of a dataset of schema evolution histories that is being collected to the goal of creating a benchmark for schema evolution. [Schema_Evolution_Benchmark] reports a detailed analysis of the MediaWiki case study, while in the following tables we list and report information for the other system under analysis.
+
This page contains a brief summary of a dataset of schema evolution histories that is being collected to the goal of creating a benchmark for schema evolution. [[Schema_Evolution_Benchmark]] reports a detailed analysis of the MediaWiki case study, while in the following tables we list and report information for the other system under analysis.
  
 
<!--########################################################TABLE 1############################################# -->
 
<!--########################################################TABLE 1############################################# -->
Line 25: Line 25:
 
<!--| CMS and Wiki -->
 
<!--| CMS and Wiki -->
 
| MediaWiki [http://www.mediawiki.org/wiki/MediaWiki]
 
| MediaWiki [http://www.mediawiki.org/wiki/MediaWiki]
| MediaWiki is used by over 30.000 wiki websites around the world including Wikipedia the availability of DB data is impressive. In particular the Wikimedia Foundation releases the entire Wikipedia DB dump bi-weekly. The user can experience with small data-set for some non-popular language (<10Mb) or work on the entire English Wikipedia *enwiki* or even install the entire dataset > 700Gb. [http://yellowstone.cs.ucla.edu/schema-evolution/index.php/Benchmark_Extension Read More..]
+
| MediaWiki is used by over 30,000 wiki websites around the world including Wikipedia the availability of DB data is impressive. In particular the Wikimedia Foundation releases the entire Wikipedia DB dump bi-weekly. The user can experience with small data-set for some non-popular language (<10Mb) or work on the entire English Wikipedia *enwiki* or even install the entire dataset > 700Gb. [http://yellowstone.cs.ucla.edu/schema-evolution/index.php/Benchmark_Extension Read More..]
| 194
+
| 323
| 6 years.
+
| 8.9 years.
| 11,407 rank as per alexa.org on 08/05/2009. Powers wikipedia, ranked 7th on alexa.org.
+
| Ranked 5782 and 1,469,996 downloads from sourceforge on 09/10/09. Powers wikipedia, ranked 6th on alexa.org on 05/25/2012.
 
| MySQL
 
| MySQL
| [http://svn.wikimedia.org/svnroot/mediawiki/trunk/phase3/maintenance/tables.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/mediawiki-schema-23052008.tar.gz Schemas.tar.gz]<br>
+
| [http://svn.wikimedia.org/svnroot/mediawiki/trunk/phase3/maintenance/tables.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/mediawiki_2012_schema.zip Schemas]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite/statistics/ham_mediawikiStat/ham_mediawikisummary.html  Statistics]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/smos/Wikipedia_SMOs.zip  SMO]
[http://yellowstone.cs.ucla.edu/demo/toolsuite/statistics/ham_mediawikiStat/ham_mediawikisummary.html  Statistics]<br>
+
  
 
|- style="background: #F2F2F2;" valign="top"
 
|- style="background: #F2F2F2;" valign="top"
Line 39: Line 38:
 
| Joomla! is an award-winning Content Management System (CMS) that will help you build websites and other powerful online applications. Best of all, Joomla! is an open source solution that is freely available to everybody. [Read More...]  
 
| Joomla! is an award-winning Content Management System (CMS) that will help you build websites and other powerful online applications. Best of all, Joomla! is an open source solution that is freely available to everybody. [Read More...]  
 
| 46
 
| 46
| 4 years.
+
| 4.0 years.
| 720 rank as per alexa.org on 08/05/2009.
+
| Ranked 296 on alexa.org on 05/25/2012.
 
| MySQL
 
| MySQL
|[http://joomlacode.org/svn/joomla/development/releases/1.5/installation/sql/mysql/joomla.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/joomla_1.5-schema.tar.gz Schemas.tar.gz]<br> [Statistics]
+
|[http://joomlacode.org/svn/joomla/development/releases/1.5/installation/sql/mysql/joomla.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/joomla_1.5-schema.tar.gz Schemas]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/smos/Joomla_SMO.zip  SMO]
  
 
|- style="background: #F2F2F2;" valign="top"
 
|- style="background: #F2F2F2;" valign="top"
Line 50: Line 49:
 
| TikiWiki (Tiki) is your Groupware/CMS (Content Management System) solution.[Read More..]  
 
| TikiWiki (Tiki) is your Groupware/CMS (Content Management System) solution.[Read More..]  
 
| 152
 
| 152
| 7 years.
+
| 7.0 years.
| 41,620 rank as per alexa.org on 08/05/2009.
+
| Ranked 239 and 765,420 downloads from sourceforge on 09/09/09. Ranked  41,620 on alexa.org on 08/05/2009.
 
| MySQL
 
| MySQL
| [https://tikiwiki.svn.sourceforge.net/svnroot/tikiwiki/branches/1.10/db/tiki.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/tikiwiki-schema.tar.gz Schemas.tar.gz]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite/statistics/ham_tikiwikiStat/ham_tikiwikisummary.html Statistics]
+
| [https://tikiwiki.svn.sourceforge.net/svnroot/tikiwiki/branches/1.10/db/tiki.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/tiki_schemas.tar Schemas]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite/statistics/ham_tikiwikiStat/ham_tikiwikisummary.html Statistics]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/smos/Tiki_SMO.zip SMO]
  
 
|- style="background: #F2F2F2;" valign="top"
 
|- style="background: #F2F2F2;" valign="top"
Line 60: Line 59:
 
| phpwiki[http://phpwiki.sourceforge.net/]
 
| phpwiki[http://phpwiki.sourceforge.net/]
 
| It is a PHP WikiWikiWeb. A WikiWikiWeb is a web site where anyone can edit the pages through an HTML form. Linking is done automatically on the server side. All pages are stored in a database.[Read More...]  
 
| It is a PHP WikiWikiWeb. A WikiWikiWeb is a web site where anyone can edit the pages through an HTML form. Linking is done automatically on the server side. All pages are stored in a database.[Read More...]  
| 18
+
| 19
| 4.11 years.
+
| 7.2 years.
| rank as per alexa.org on 08/05/2009.
+
| Ranked 7,982 and 351,561 downloads from sourceforge on 09/09/09.
 
| MySQL
 
| MySQL
|[https://phpwiki.svn.sourceforge.net/svnroot/phpwiki/trunk/schemas/mysql-initialize.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite/statistics/ham_phpwikiStat/ham_phpwikisummary.html Statistics]
+
|[https://phpwiki.svn.sourceforge.net/svnroot/phpwiki/trunk/schemas/mysql-initialize.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/phpwiki_schema.tar Schemas]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite/statistics/ham_phpwikiStat/ham_phpwikisummary.html Statistics]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/smos/Php_SMO.zip SMO]
  
 
|- style="background: #F2F2F2;" valign="top"
 
|- style="background: #F2F2F2;" valign="top"
Line 71: Line 70:
 
| Deki Wiki 8.05[http://www.osalt.com/deki-wiki]
 
| Deki Wiki 8.05[http://www.osalt.com/deki-wiki]
 
| MindTouch Deki Wiki is the Web's most popular commercially supported wiki platform for creating content and mashups using a wiki interface. The free, open source application is an easy to use program for authoring, aggregating, organizing, and sharing almost any kind of content. Enterprises can build online communities and in-house Intranets, create collaborative applications, or add wiki capabilities to existing applications. Deki Wiki includes a state-of-the-art WYSIWYG editor, integration with the LDAP, and open source providers like WordPress, Joomla, Drupal, and Mambo. Deki Wiki is also a platform for building collaborative Web applications that access functionality or data from anywhere on the Internet. Its flexible architecture even allows wiki capabilities to be added to existing applications regardless of the underlying language or technology. [Read More...]  
 
| MindTouch Deki Wiki is the Web's most popular commercially supported wiki platform for creating content and mashups using a wiki interface. The free, open source application is an easy to use program for authoring, aggregating, organizing, and sharing almost any kind of content. Enterprises can build online communities and in-house Intranets, create collaborative applications, or add wiki capabilities to existing applications. Deki Wiki includes a state-of-the-art WYSIWYG editor, integration with the LDAP, and open source providers like WordPress, Joomla, Drupal, and Mambo. Deki Wiki is also a platform for building collaborative Web applications that access functionality or data from anywhere on the Internet. Its flexible architecture even allows wiki capabilities to be added to existing applications regardless of the underlying language or technology. [Read More...]  
| 11
+
| 16
| 1.11 years.
+
| 4.2 years.
| rank as per alexa.org on 08/05/2009.
+
| Ranked 28 and 490,905 downloads from sourceforge on 09/09/09.
 
| MySQL
 
| MySQL
|[https://dekiwiki.svn.sourceforge.net/svnroot/dekiwiki/deki/web/maintenance/tables.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite/statistics/ham_dekiwikiStat/ham_dekiwikisummary.html Statistics]
+
|[https://dekiwiki.svn.sourceforge.net/svnroot/dekiwiki/deki/web/maintenance/tables.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/deki_2012_schemas.zip  Schemas]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite/statistics/ham_dekiwikiStat/ham_dekiwikisummary.html Statistics]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/smos/Deki_SMO.zip SMO]
  
 
|- style="background: #F2F2F2;" valign="top"
 
|- style="background: #F2F2F2;" valign="top"
Line 83: Line 82:
 
| Nucleus offers you the building blocks you need to create a web presence. Whether you want to create a personal blog, a family page, or an online business site, Nucleus CMS can help you achieve your goals.[http://sourceforge.net/projects/nucleuscms/  Read More...]  
 
| Nucleus offers you the building blocks you need to create a web presence. Whether you want to create a personal blog, a family page, or an online business site, Nucleus CMS can help you achieve your goals.[http://sourceforge.net/projects/nucleuscms/  Read More...]  
 
| 51
 
| 51
| 6.7 years.
+
| 8.9 years.
| rank as per alexa.org on 08/05/2009.
+
| Ranked 54874 on alexa.org on 09/10/2009.
 
| MySQL
 
| MySQL
|[https://nucleuscms.svn.sourceforge.net/svnroot/nucleuscms/trunk/nucleus/install.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite/statistics/ham_nucleus2Stat/ham_nucleus2summary.html Statistics]
+
|[https://nucleuscms.svn.sourceforge.net/svnroot/nucleuscms/trunk/nucleus/install.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/nucl_schema_2012.tar  Schemas]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite/statistics/ham_nucleus2Stat/ham_nucleus2summary.html Statistics]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/smos/Nucl_SMO.zip SMO]
  
 
|- style="background: #F2F2F2;" valign="top"
 
|- style="background: #F2F2F2;" valign="top"
Line 93: Line 92:
 
| ATutor is an Open Source Web-based Learning Content Management System (LCMS/LMS) and social networking environment designed with accessibility and adaptability in mind. Administrators can install or update ATutor in minutes, develop custom themes to give ATutor a new look, and easily extend its functionality with feature modules. Educators can quickly assemble, package, and redistribute Web-based instructional content, easily import prepackaged content, and conduct their courses online. Students learn in an adaptive, social learning environment. [http://yellowstone.cs.ucla.edu/schema-evolution/index.php/Benchmark_Extension Read More..]
 
| ATutor is an Open Source Web-based Learning Content Management System (LCMS/LMS) and social networking environment designed with accessibility and adaptability in mind. Administrators can install or update ATutor in minutes, develop custom themes to give ATutor a new look, and easily extend its functionality with feature modules. Educators can quickly assemble, package, and redistribute Web-based instructional content, easily import prepackaged content, and conduct their courses online. Students learn in an adaptive, social learning environment. [http://yellowstone.cs.ucla.edu/schema-evolution/index.php/Benchmark_Extension Read More..]
 
| 216
 
| 216
| 5.7 years.
+
| 7.9 years.
| 117,088 rank as per alexa.org on 08/05/2009.
+
| Ranked 4939 and 294,931  downloads from sourceforge on 09/09/09. Ranked 117,088 on alexa.org on 08/05/2009.
 
| MySQL
 
| MySQL
| [http://atutorsvn.atrc.utoronto.ca/repos/atutor/trunk/docs/install/db/atutor_schema.sql SVN access]<br>
+
| [http://atutorsvn.atrc.utoronto.ca/repos/atutor/trunk/docs/install/db/atutor_schema.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/atutor_schema_2012.tar  Schemas]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite/statistics/atutorStat/ham_atutorsummary.html Statistics]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/smos/Autor_SMO.zip  SMO]
[http://yellowstone.cs.ucla.edu/demo/toolsuite/statistics/atutorStat/ham_atutorsummary.html Statistics]
+
  
 
|- style="background: #F2F2F2;" valign="top"
 
|- style="background: #F2F2F2;" valign="top"
Line 104: Line 102:
 
| XOOPS Dynamic Web CMS [http://www.xoops.org/]
 
| XOOPS Dynamic Web CMS [http://www.xoops.org/]
 
| XOOPS is a dynamic web content management system written in PHP for the MySQL database. Its object orientation makes it an ideal tool for developing small or large community websites, intra company and corporate portals, weblogs and much more.[Read More..]  
 
| XOOPS is a dynamic web content management system written in PHP for the MySQL database. Its object orientation makes it an ideal tool for developing small or large community websites, intra company and corporate portals, weblogs and much more.[Read More..]  
| 14
+
| 11
| 8 years.
+
| 3.5 years.
| 6,559,127 downloads from sourceforge on 05/22/2008. 23,555 rank as per alexa.org on 08/05/2009.
+
| Ranked 35 and 7,402,174 downloads from sourceforge on 09/10/2009. Ranked 23,555 on alexa.org on 08/05/2009.
 
| MySQL
 
| MySQL
| [https://xoops.svn.sourceforge.net/svnroot/xoops/XoopsCore/trunk/htdocs/install/sql/mysql.structure.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/xoops-schema.tar.gz Schemas.tar.gz]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite2/statistics/gur_xoopsStat/gur_xoopssummary.html Statistics]
+
| [https://xoops.svn.sourceforge.net/svnroot/xoops/XoopsCore/trunk/htdocs/install/sql/mysql.structure.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/xoops-schema.tar.gz Schemas]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite2/statistics/gur_xoopsStat/gur_xoopssummary.html Statistics]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/smos/Xoops_SMO.zip  SMO]
 
   
 
   
 
|- style="background: #F2F2F2;" valign="top"
 
|- style="background: #F2F2F2;" valign="top"
Line 116: Line 114:
 
| Coppermine is an easily set-up, fast, feature-rich photo gallery script with mySQL database, user management, private galleries, automatic thumbnail creation, ecard feature and a template system for easy customization to match the rest of a site.[Read More..]
 
| Coppermine is an easily set-up, fast, feature-rich photo gallery script with mySQL database, user management, private galleries, automatic thumbnail creation, ecard feature and a template system for easy customization to match the rest of a site.[Read More..]
 
| 36
 
| 36
| 2.5 years.
+
| 4.8 years.
| 4,681,872 downloads from sourceforge on 05/22/2008. 19,852 rank as per alexa.org on 08/05/2009.
+
| Ranked 261 and 5,653,224 downloads from sourceforge on 09/10/2009. Ranked 19,852 on alexa.org on 08/05/2009.
 
| MySQL
 
| MySQL
| [https://coppermine.svn.sourceforge.net/svnroot/coppermine/trunk/cpg1.5.x/sql/schema.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/coopermine-schema.tar.gz Schemas.tar.gz]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite2/statistics/gur_coppermineStat/gur_copperminesummary.html Statistics]
+
| [https://coppermine.svn.sourceforge.net/svnroot/coppermine/trunk/cpg1.5.x/sql/schema.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/coppermine_schema_2012.tar Schemas]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite2/statistics/gur_coppermineStat/gur_copperminesummary.html Statistics]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/smos/Copper_SMO.zip  SMO]
  
 
|- style="background: #F2F2F2;" valign="top"
 
|- style="background: #F2F2F2;" valign="top"
Line 127: Line 125:
 
| TYPO3 is an enterprise class Web CMS written in PHP/MySQL. It's designed to be extended with custom written backend modules and frontend libraries for special functionality. It has very powerful integration of image manipulation.[Read More..]
 
| TYPO3 is an enterprise class Web CMS written in PHP/MySQL. It's designed to be extended with custom written backend modules and frontend libraries for special functionality. It has very powerful integration of image manipulation.[Read More..]
 
| 39
 
| 39
| 4 years.
+
| 8.3 years.
| 3,277,323 downloads from sourceforge on 05/22/2008. 31,844 rank as per alexa.org on 08/05/2009.
+
| Ranked 1946 and 4,091,386downloads from sourceforge on 09/10/2009. Ranked 31,844 on alexa.org on 08/05/2009.
 
| MySQL
 
| MySQL
| [https://typo3.svn.sourceforge.net/svnroot/typo3/TYPO3core/trunk/t3lib/stddb/tables.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/typo3-schema.tar.gz Schemas.tar.gz]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite2/statistics/gur_typo3Stat/gur_typo3summary.html Statistics]
+
| [https://typo3.svn.sourceforge.net/svnroot/typo3/TYPO3core/trunk/t3lib/stddb/tables.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/typo_schema_2012.tar Schemas]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite2/statistics/gur_typo3Stat/gur_typo3summary.html Statistics]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/smos/Typo_SMO.zip  SMO]
 
|}
 
|}
  
Line 161: Line 159:
 
| KnowledgeTree® is open source document management software that connects people, processes, and ideas. Collaborate, securely store all your critical documents, address compliance challenges, and focus on providing a simple solution that works for your business. [http://sourceforge.net/projects/kt-dms/ Read More...]  
 
| KnowledgeTree® is open source document management software that connects people, processes, and ideas. Collaborate, securely store all your critical documents, address compliance challenges, and focus on providing a simple solution that works for your business. [http://sourceforge.net/projects/kt-dms/ Read More...]  
 
| 105
 
| 105
| 4 years.
+
| 6.3 years.
| rank as per alexa.org on 08/05/2009.
+
| Ranked 156,935 on alexa.org on 05/25/2012.
 
| MySQL
 
| MySQL
|[https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk/sql/mysql/install/structure.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite/statistics/ham_ktdmsStat/ham_ktdmssummary.html Statistics]
+
|[https://kt-dms.svn.sourceforge.net/svnroot/kt-dms/trunk/sql/mysql/install/structure.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/ktdms_2012_schemas.zip  Schemas]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite/statistics/ham_ktdmsStat/ham_ktdmssummary.html Statistics]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/smos/KtDMS_SMO.zip  SMO]
  
 
|- style="background: #CCF2F2;" valign="top"
 
|- style="background: #CCF2F2;" valign="top"
Line 172: Line 170:
 
| Slashcode is the site for All Things Slash. Slash is the source code and database that was originally used to create Slashdot, and has now been released under the GNU General Public License. It is a bona fide Open Source / Free Software project.[  Read More...]  
 
| Slashcode is the site for All Things Slash. Slash is the source code and database that was originally used to create Slashdot, and has now been released under the GNU General Public License. It is a bona fide Open Source / Free Software project.[  Read More...]  
 
| 256
 
| 256
| 8.10 years.
+
| 12.5 years.
| rank as per alexa.org on 08/05/2009.
+
| Ranked 5799 and 142,849 downloads from sourceforge on 09/09/09.
 
| MySQL
 
| MySQL
|[http://slashcode.cvs.sourceforge.net/viewvc/slashcode/slash/sql/mysql/slashschema_create.sql?view=log CVS access] <br>[http://yellowstone.cs.ucla.edu/demo/toolsuite/statistics/ham_slashcode2Stat/ham_slashcode2summary.html Statistics]
+
|[http://slashcode.cvs.sourceforge.net/viewvc/slashcode/slash/sql/mysql/slashschema_create.sql?view=log CVS access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/slash_schema_2012.tar  Schemas]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite/statistics/ham_slashcode2Stat/ham_slashcode2summary.html Statistics]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/smos/Slash_SMO.zip  SMO]
  
 
|- style="background: #CCF2F2;" valign="top"
 
|- style="background: #CCF2F2;" valign="top"
Line 183: Line 181:
 
| ZABBIX is an enterprise-class open source distributed monitoring solution.ZABBIX is software that monitors numerous parameters of a network and the health and integrity of servers. ZABBIX uses a flexible notification mechanism that allows users to configure e-mail based alerts for virtually any event. This allows a fast reaction to server problems. ZABBIX offers excellent reporting and data visualisation features based on the stored data. This makes ZABBIX ideal for capacity planning. [http://www.zabbix.com/downloads/ZABBIX%20Manual%20v1.6.pdf Read More...]  
 
| ZABBIX is an enterprise-class open source distributed monitoring solution.ZABBIX is software that monitors numerous parameters of a network and the health and integrity of servers. ZABBIX uses a flexible notification mechanism that allows users to configure e-mail based alerts for virtually any event. This allows a fast reaction to server problems. ZABBIX offers excellent reporting and data visualisation features based on the stored data. This makes ZABBIX ideal for capacity planning. [http://www.zabbix.com/downloads/ZABBIX%20Manual%20v1.6.pdf Read More...]  
 
| 196
 
| 196
| 8.3 years.
+
| 10.8 years.
| rank as per alexa.org on 08/05/2009.
+
| Ranked 398 and 511,389 downloads from sourceforge on 09/09/09.
 
| MySQL
 
| MySQL
|[http://zabbix.cvs.sourceforge.net/viewvc/zabbix/ CVS access]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite/statistics/ham_zabbixStat/ham_zabbixsummary.html Statistics]
+
|[http://zabbix.cvs.sourceforge.net/viewvc/zabbix/ CVS access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/zabbix_schema_2012.tar  Schemas]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite/statistics/ham_zabbixStat/ham_zabbixsummary.html Statistics]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/smos/Zabbix_SMO.zip  SMO]
  
 
|- style="background: #CCF2F2;" valign="top"
 
|- style="background: #CCF2F2;" valign="top"
Line 194: Line 192:
 
| e107 is a website system written in PHP and MySQL. It installs a completely dynamic website on your server allowing you complete control of your site from a secure and intuitive, yet powerful and flexible admin area. Coded within the XHTML 1.1 Standard.[Read More...]  
 
| e107 is a website system written in PHP and MySQL. It installs a completely dynamic website on your server allowing you complete control of your site from a secure and intuitive, yet powerful and flexible admin area. Coded within the XHTML 1.1 Standard.[Read More...]  
 
| 16
 
| 16
| 5.4 months.
+
| 8.5 years.
| rank as per alexa.org on 08/05/2009.
+
| Ranked 203 and 1,255,976 downloads from sourceforge on 09/09/09.
 
| MySQL
 
| MySQL
|[http://e107.cvs.sourceforge.net/viewvc/e107/e107/e107_admin/sql/core_sql.php CVS access]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite/statistics/ham_e107Stat/ham_e107summary.html Statistics]
+
|[http://e107.cvs.sourceforge.net/viewvc/e107/e107/e107_admin/sql/core_sql.php CVS access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/e107_schema_2012.tar  Schemas]<br>[http://yellowstone.cs.ucla.edu/demo/toolsuite/statistics/ham_e107Stat/ham_e107summary.html Statistics]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/smos/E107_SMO.zip  SMO]
 
[http://sourceforge.net/projects/e107/ On sourceforge]
 
[http://sourceforge.net/projects/e107/ On sourceforge]
  
Line 228: Line 226:
 
| Ensembl Genetic DB [http://www.ensembl.org]
 
| Ensembl Genetic DB [http://www.ensembl.org]
 
| The Ensembl project produces genome databases for vertebrates and other eukaryotic species, and makes this information freely available online. [Read More...]  
 
| The Ensembl project produces genome databases for vertebrates and other eukaryotic species, and makes this information freely available online. [Read More...]  
| 346
+
| 412
 
| 9.8 years.
 
| 9.8 years.
| 178,340 rank as per alexa.org on 08/05/2009.
+
| 178,340 on alexa.org on 08/05/2009.
 
| MySQL
 
| MySQL
| [http://cvs.sanger.ac.uk/cgi-bin/viewvc.cgi/ensembl/sql/?root=ensembl CVS access]<br>[http://svn.warelab.org/maize/ensembl/branches/release-3a.50/sql/ SVN access]<br>[http://www.ensembl.org/info/docs/api/index.html API Documentation]<br>[Statistics]
+
|  
 +
[http://cvs.sanger.ac.uk/cgi-bin/viewvc.cgi/ensembl/sql/?root=ensembl CVS access]<br>[http://svn.warelab.org/maize/ensembl/branches/release-3a.50/sql/ SVN access]<br>
 +
[http://yellowstone.cs.ucla.edu/schema-evolution/documents/Ensembl_Schema.zip  Schemas]
 +
[http://yellowstone.cs.ucla.edu/schema-evolution/smos/Ensembl_SMO.zip  SMO]
  
 
|- style="background: #FFCCFF;" valign="top"
 
|- style="background: #FFCCFF;" valign="top"
Line 239: Line 240:
 
| GrainGene [http://wheat.pw.usda.gov/GG2/index.shtml]
 
| GrainGene [http://wheat.pw.usda.gov/GG2/index.shtml]
 
| The GrainGenes 2.0 is a DB for Triticeae and Avena. [Read More...]  
 
| The GrainGenes 2.0 is a DB for Triticeae and Avena. [Read More...]  
 +
| 2
 
|  
 
|  
|
+
| 4,019 on alexa.org on 08/05/2009.
| 4,019 rank as per alexa.org on 08/05/2009.
+
 
| MySQL
 
| MySQL
| [http://wheat.pw.usda.gov/ggmigration/gg_schema_mysql/ Schema access]<br>[http://wheat.pw.usda.gov/cgi-bin/graingenes/sql.cgi?pre=0 SQL Interface]<br>[Statistics]
+
| [http://wheat.pw.usda.gov/ggmigration/gg_schema_mysql/ Schema access]<br>
 +
[http://wheat.pw.usda.gov/cgi-bin/graingenes/sql.cgi?pre=0 SQL Interface]<br>
  
 
|- style="background: #FFCCFF;" valign="top"
 
|- style="background: #FFCCFF;" valign="top"
Line 252: Line 254:
 
|  
 
|  
 
|  
 
|  
| *rank as per alexa.org on 08/05/2009.
+
| 16,723 on alexa.org on 08/05/2009.
 
| MySQL
 
| MySQL
|  
+
| [http://genome.ucsc.edu/cgi-bin/hgTables?command=start Schema access]<br>
 +
 
 
   
 
   
 
|- style="background: #FFCCFF;" valign="top"
 
|- style="background: #FFCCFF;" valign="top"
Line 263: Line 266:
 
| 46
 
| 46
 
| 6.6 years.
 
| 6.6 years.
| 11,740,689 rank as per alexa.org on 08/05/2009.
+
| Ranked 11,740,689 on alexa.org on 08/05/2009.
|
+
| MySQL
| [http://code.open-bio.org/svnweb/index.cgi/biosql/view/biosql-schema/trunk/sql/biosqldb-mysql.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/BioSQL-schema.zip Schema.zip]<br>[Statistics]
+
| [http://code.open-bio.org/svnweb/index.cgi/biosql/view/biosql-schema/trunk/sql/biosqldb-mysql.sql SVN access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/BioSQL-schema.zip Schema]<br>
 +
[http://yellowstone.cs.ucla.edu/schema-evolution/smos/Biosql_SMO.zip SMO]
  
 
|- style="background: #FFCCFF;" valign="top"
 
|- style="background: #FFCCFF;" valign="top"
Line 274: Line 278:
 
|  
 
|  
 
|
 
|
| 15,597,325 rank as per alexa.org on 08/05/2009.
+
| Ranked 15,597,325 on alexa.org on 08/05/2009.
 
|
 
|
| [https://www.cbil.upenn.edu/svn/gus/ SVN access]<br>[Statistics]
+
| [https://www.cbil.upenn.edu/svn/gus/ SVN access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/SchemaBrowserSA-1.0.zip Schema Browser]<br>
  
 
|- style="background: #FFCCFF;" valign="top"
 
|- style="background: #FFCCFF;" valign="top"
Line 285: Line 289:
 
|  
 
|  
 
|
 
|
| 525,882* rank as per alexa.org on 08/05/2009.
+
| on alexa.org on 08/05/2009.
 
|
 
|
| [http://smi-protege.stanford.edu/repos/cbio/ncbo/trunk/conf/ncbo_tables.sql SVN access]]<br>[Statistics]
+
| [https://bmir-gforge.stanford.edu/gf/project/bioportal/scmsvn/?action=browse&path=%2Ftrunk%2Fconf%2Fncbo_tables.sql&view=log SVN access]<br>[http://yellowstone.cs.ucla.edu/schema-evolution/documents/Ncbo_Schema.zip Schema]<br>
 +
[http://yellowstone.cs.ucla.edu/schema-evolution/smos/Ncbo_SMO.zip SMO]<br>
 +
 
  
 
|- style="background: #FFCCFF;" valign="top"
 
|- style="background: #FFCCFF;" valign="top"
Line 296: Line 302:
 
|  
 
|  
 
|  
 
|  
| 642,041 rank as per alexa.org on 08/05/2009.
+
| Ranked 642,041 on alexa.org on 08/05/2009.
 
|   
 
|   
 
| [http://sourceforge.net/projects/openemr/ On sourceforge]<br>[Statistics]
 
| [http://sourceforge.net/projects/openemr/ On sourceforge]<br>[Statistics]
Line 307: Line 313:
 
|  
 
|  
 
|  
 
|  
| *rank as per alexa.org on 08/05/2009
+
| Ranked on alexa.org on 08/05/2009
 
|
 
|
 
| [][]<br>[Statistics]
 
| [][]<br>[Statistics]
Line 340: Line 346:
 
| 6
 
| 6
 
|
 
|
| 5,115,481 rank as per alexa.org on 08/05/2009.
+
| Ranked 5,115,481 on alexa.org on 08/05/2009.
 
|
 
|
 
| [http://sadgw.lnl.infn.it:8000/cgi-cvs/gridCC/framework/installation/configuration/databases/mysql/mysqlRunNumber.sql?sortby=date&only_with_tag=MAIN CVS access][Statistics]
 
| [http://sadgw.lnl.infn.it:8000/cgi-cvs/gridCC/framework/installation/configuration/databases/mysql/mysqlRunNumber.sql?sortby=date&only_with_tag=MAIN CVS access][Statistics]
Line 351: Line 357:
 
| 77
 
| 77
 
| 2 years.
 
| 2 years.
| *rank as per alexa.org on 08/05/2009
+
| on alexa.org on 08/05/2009
 
| Oracle
 
| Oracle
 
| [http://atdaq-sw.cern.ch/cgi-bin/viewcvs-atlas.cgi/offline/Trigger/TrigConfiguration/TrigDb/share/sql/combined_schema.sql CVS access]<br>[Statistics]<br>[http://atlas-sw.cern.ch/cgi-bin/viewcvs-atlas.cgi/offline/MuonSpectrometer/MuonOracleScripts/MuonMatters/GENV.sql?revision=1.6&view=markup GENV]<br>[http://atlas-sw.cern.ch/cgi-bin/viewcvs-atlas.cgi/offline/Trigger/TrigConfiguration/TriggerTool/external/combined_schema.sql?view=log&pathrev=MAIN CVS access]<br>[http://atlas-sw.cern.ch/cgi-bin/viewcvs-atlas.cgi/offline/Database/RunLumi/RunLumiPrototype/ddl/Run_Lum_DB_1_tab.sql?view=log CVS access]
 
| [http://atdaq-sw.cern.ch/cgi-bin/viewcvs-atlas.cgi/offline/Trigger/TrigConfiguration/TrigDb/share/sql/combined_schema.sql CVS access]<br>[Statistics]<br>[http://atlas-sw.cern.ch/cgi-bin/viewcvs-atlas.cgi/offline/MuonSpectrometer/MuonOracleScripts/MuonMatters/GENV.sql?revision=1.6&view=markup GENV]<br>[http://atlas-sw.cern.ch/cgi-bin/viewcvs-atlas.cgi/offline/Trigger/TrigConfiguration/TriggerTool/external/combined_schema.sql?view=log&pathrev=MAIN CVS access]<br>[http://atlas-sw.cern.ch/cgi-bin/viewcvs-atlas.cgi/offline/Database/RunLumi/RunLumiPrototype/ddl/Run_Lum_DB_1_tab.sql?view=log CVS access]
Line 362: Line 368:
 
| 17
 
| 17
 
| 4 years.
 
| 4 years.
| rank as per alexa.org on 08/05/2009
+
| on alexa.org on 08/05/2009
 
| Oracle, MySQL
 
| Oracle, MySQL
 
| [http://jra1mw.cvs.cern.ch:8180/cgi-bin/jra1mw.cgi/org.glite.data.transfer-common/config/schema/oracle/oracle-schema.sql?view=log&pathrev=MAIN CVS access]<br>[http://jra1mw.cvs.cern.ch:8180/cgi-bin/jra1mw.cgi/org.glite.data.transfer-common/config/schema/mysql/mysql-schema.sql?view=log&pathrev=MAIN CVS access]<br>[Statistics]  
 
| [http://jra1mw.cvs.cern.ch:8180/cgi-bin/jra1mw.cgi/org.glite.data.transfer-common/config/schema/oracle/oracle-schema.sql?view=log&pathrev=MAIN CVS access]<br>[http://jra1mw.cvs.cern.ch:8180/cgi-bin/jra1mw.cgi/org.glite.data.transfer-common/config/schema/mysql/mysql-schema.sql?view=log&pathrev=MAIN CVS access]<br>[Statistics]  
Line 373: Line 379:
 
|SRM2-45<br> CASTOR-149
 
|SRM2-45<br> CASTOR-149
 
| 3 years.
 
| 3 years.
| rank as per alexa.org on 08/05/2009
+
| on alexa.org on 08/05/2009
 
| Oracle
 
| Oracle
 
|[http://isscvs.cern.ch/cgi-bin/cvsweb.cgi/SRM2/srm/db/srm_oracle_create.sql?cvsroot=castor CVS access]<br>[http://isscvs.cern.ch/cgi-bin/cvsweb.cgi/CASTOR2/castor/db/castor_oracle_create.sql?cvsroot=castor CVS access]<br> [Statistics]  
 
|[http://isscvs.cern.ch/cgi-bin/cvsweb.cgi/SRM2/srm/db/srm_oracle_create.sql?cvsroot=castor CVS access]<br>[http://isscvs.cern.ch/cgi-bin/cvsweb.cgi/CASTOR2/castor/db/castor_oracle_create.sql?cvsroot=castor CVS access]<br> [Statistics]  
Line 384: Line 390:
 
|Oracle - 17 <br> MySQL - 51
 
|Oracle - 17 <br> MySQL - 51
 
|
 
|
| rank as per alexa.org on 08/05/2009.
+
| on alexa.org on 08/05/2009.
 
| Oracle, MySQL
 
| Oracle, MySQL
 
| [http://isscvs.cern.ch/cgi-bin/viewcvs-all.cgi/dq2.binky.dao.oracle/config/db/schema-binky-oracle.sql?root=atlas-dq2&view=log CVS access (Oracle)] <br> [http://isscvs.cern.ch/cgi-bin/viewcvs-all.cgi/dq2.agents.dao.mysql/config/db/schema-mysql-5.x.sql?root=atlas-dq2&view=log CVS access (MySQL)] <br> [http://isscvs.cern.ch/cgi-bin/viewcvs-all.cgi/dq2.tracker.server.mysql/config/db/schema-tracker-mysql.sql?root=atlas-dq2&view=log Schema-tracker] <br> [Statistics]  
 
| [http://isscvs.cern.ch/cgi-bin/viewcvs-all.cgi/dq2.binky.dao.oracle/config/db/schema-binky-oracle.sql?root=atlas-dq2&view=log CVS access (Oracle)] <br> [http://isscvs.cern.ch/cgi-bin/viewcvs-all.cgi/dq2.agents.dao.mysql/config/db/schema-mysql-5.x.sql?root=atlas-dq2&view=log CVS access (MySQL)] <br> [http://isscvs.cern.ch/cgi-bin/viewcvs-all.cgi/dq2.tracker.server.mysql/config/db/schema-tracker-mysql.sql?root=atlas-dq2&view=log Schema-tracker] <br> [Statistics]  
Line 395: Line 401:
 
| WMS - 41 , Production Management System - 14
 
| WMS - 41 , Production Management System - 14
 
|
 
|
| rank as per alexa.org on 08/05/2009.
+
| on alexa.org on 08/05/2009.
 
| Oracle
 
| Oracle
 
| [http://isscvs.cern.ch/cgi-bin/viewcvs-all.cgi/DIRAC/python/DIRAC/WMS/DB/db-schema.sql?root=dirac&view=log CVS access]<br> [http://isscvs.cern.ch/cgi-bin/viewcvs-all.cgi/DIRAC3/DIRAC/ProductionManagementSystem/DB/ProductionDB.sql?root=dirac&view=log CVS access] <br> [Statistics]
 
| [http://isscvs.cern.ch/cgi-bin/viewcvs-all.cgi/DIRAC/python/DIRAC/WMS/DB/db-schema.sql?root=dirac&view=log CVS access]<br> [http://isscvs.cern.ch/cgi-bin/viewcvs-all.cgi/DIRAC3/DIRAC/ProductionManagementSystem/DB/ProductionDB.sql?root=dirac&view=log CVS access] <br> [Statistics]
Line 406: Line 412:
 
|  
 
|  
 
|
 
|
| rank as per alexa.org on 08/05/2009
+
| on alexa.org on 08/05/2009
 
| Oracle
 
| Oracle
 
| [http://isscvs.cern.ch:8180/cgi-bin/viewcvs-all.cgi/elfms/quattor/cdb2sql-ora/schemas/?root=elfms CVS access]<br> [Statistics]
 
| [http://isscvs.cern.ch:8180/cgi-bin/viewcvs-all.cgi/elfms/quattor/cdb2sql-ora/schemas/?root=elfms CVS access]<br> [Statistics]
Line 417: Line 423:
 
| Hydra-service - 5 and triDAS - 7  
 
| Hydra-service - 5 and triDAS - 7  
 
|
 
|
| rank as per alexa.org on 08/05/2009
+
| on alexa.org on 08/05/2009
 
| MySQL, Oracle
 
| MySQL, Oracle
 
| [http://glite.cvs.cern.ch:8180/cgi-bin/glite.cgi/org.glite.data.hydra-service/config/schema/mysql/mysql-schema.sql?view=log&pathrev=MAIN CVS access] <br> [http://isscvs.cern.ch/cgi-bin/viewcvs-all.cgi/TriDAS/ecal/ecalDB/sql/create_new_fe_daq_config.sql?root=tridas&view=log CVS access] <br> [Statistics]
 
| [http://glite.cvs.cern.ch:8180/cgi-bin/glite.cgi/org.glite.data.hydra-service/config/schema/mysql/mysql-schema.sql?view=log&pathrev=MAIN CVS access] <br> [http://isscvs.cern.ch/cgi-bin/viewcvs-all.cgi/TriDAS/ecal/ecalDB/sql/create_new_fe_daq_config.sql?root=tridas&view=log CVS access] <br> [Statistics]
  
 
|}
 
|}

Latest revision as of 21:51, 3 October 2012

This page contains a brief summary of a dataset of schema evolution histories that is being collected to the goal of creating a benchmark for schema evolution. Schema_Evolution_Benchmark reports a detailed analysis of the MediaWiki case study, while in the following tables we list and report information for the other system under analysis.


Open Source Web Information Systems
Name Description No. of Revisions Lifespan Popularity DBMS Further Information


MediaWiki [1] MediaWiki is used by over 30,000 wiki websites around the world including Wikipedia the availability of DB data is impressive. In particular the Wikimedia Foundation releases the entire Wikipedia DB dump bi-weekly. The user can experience with small data-set for some non-popular language (<10Mb) or work on the entire English Wikipedia *enwiki* or even install the entire dataset > 700Gb. Read More.. 323 8.9 years. Ranked 5782 and 1,469,996 downloads from sourceforge on 09/10/09. Powers wikipedia, ranked 6th on alexa.org on 05/25/2012. MySQL SVN access
Schemas
Statistics
SMO
Joomla! 1.5 [2] Joomla! is an award-winning Content Management System (CMS) that will help you build websites and other powerful online applications. Best of all, Joomla! is an open source solution that is freely available to everybody. [Read More...] 46 4.0 years. Ranked 296 on alexa.org on 05/25/2012. MySQL SVN access
Schemas
SMO
TikiWiki [3] TikiWiki (Tiki) is your Groupware/CMS (Content Management System) solution.[Read More..] 152 7.0 years. Ranked 239 and 765,420 downloads from sourceforge on 09/09/09. Ranked 41,620 on alexa.org on 08/05/2009. MySQL SVN access
Schemas
Statistics
SMO
phpwiki[4] It is a PHP WikiWikiWeb. A WikiWikiWeb is a web site where anyone can edit the pages through an HTML form. Linking is done automatically on the server side. All pages are stored in a database.[Read More...] 19 7.2 years. Ranked 7,982 and 351,561 downloads from sourceforge on 09/09/09. MySQL SVN access
Schemas
Statistics
SMO
Deki Wiki 8.05[5] MindTouch Deki Wiki is the Web's most popular commercially supported wiki platform for creating content and mashups using a wiki interface. The free, open source application is an easy to use program for authoring, aggregating, organizing, and sharing almost any kind of content. Enterprises can build online communities and in-house Intranets, create collaborative applications, or add wiki capabilities to existing applications. Deki Wiki includes a state-of-the-art WYSIWYG editor, integration with the LDAP, and open source providers like WordPress, Joomla, Drupal, and Mambo. Deki Wiki is also a platform for building collaborative Web applications that access functionality or data from anywhere on the Internet. Its flexible architecture even allows wiki capabilities to be added to existing applications regardless of the underlying language or technology. [Read More...] 16 4.2 years. Ranked 28 and 490,905 downloads from sourceforge on 09/09/09. MySQL SVN access
Schemas
Statistics
SMO
Nucleaus[6] Nucleus offers you the building blocks you need to create a web presence. Whether you want to create a personal blog, a family page, or an online business site, Nucleus CMS can help you achieve your goals.Read More... 51 8.9 years. Ranked 54874 on alexa.org on 09/10/2009. MySQL SVN access
Schemas
Statistics
SMO
ATutor [7] ATutor is an Open Source Web-based Learning Content Management System (LCMS/LMS) and social networking environment designed with accessibility and adaptability in mind. Administrators can install or update ATutor in minutes, develop custom themes to give ATutor a new look, and easily extend its functionality with feature modules. Educators can quickly assemble, package, and redistribute Web-based instructional content, easily import prepackaged content, and conduct their courses online. Students learn in an adaptive, social learning environment. Read More.. 216 7.9 years. Ranked 4939 and 294,931 downloads from sourceforge on 09/09/09. Ranked 117,088 on alexa.org on 08/05/2009. MySQL SVN access
Schemas
Statistics
SMO
XOOPS Dynamic Web CMS [8] XOOPS is a dynamic web content management system written in PHP for the MySQL database. Its object orientation makes it an ideal tool for developing small or large community websites, intra company and corporate portals, weblogs and much more.[Read More..] 11 3.5 years. Ranked 35 and 7,402,174 downloads from sourceforge on 09/10/2009. Ranked 23,555 on alexa.org on 08/05/2009. MySQL SVN access
Schemas
Statistics
SMO
Coppermine Photo Gallery [9] Coppermine is an easily set-up, fast, feature-rich photo gallery script with mySQL database, user management, private galleries, automatic thumbnail creation, ecard feature and a template system for easy customization to match the rest of a site.[Read More..] 36 4.8 years. Ranked 261 and 5,653,224 downloads from sourceforge on 09/10/2009. Ranked 19,852 on alexa.org on 08/05/2009. MySQL SVN access
Schemas
Statistics
SMO
TYPO3 Content Management Framework [10] TYPO3 is an enterprise class Web CMS written in PHP/MySQL. It's designed to be extended with custom written backend modules and frontend libraries for special functionality. It has very powerful integration of image manipulation.[Read More..] 39 8.3 years. Ranked 1946 and 4,091,386downloads from sourceforge on 09/10/2009. Ranked 31,844 on alexa.org on 08/05/2009. MySQL SVN access
Schemas
Statistics
SMO


Open Source Software
Name Description No. of Revisions Lifespan Popularity DBMS Further Information


KtDMS[11] KnowledgeTree® is open source document management software that connects people, processes, and ideas. Collaborate, securely store all your critical documents, address compliance challenges, and focus on providing a simple solution that works for your business. Read More... 105 6.3 years. Ranked 156,935 on alexa.org on 05/25/2012. MySQL SVN access
Schemas
Statistics
SMO
Slashcode[12] Slashcode is the site for All Things Slash. Slash is the source code and database that was originally used to create Slashdot, and has now been released under the GNU General Public License. It is a bona fide Open Source / Free Software project.[ Read More...] 256 12.5 years. Ranked 5799 and 142,849 downloads from sourceforge on 09/09/09. MySQL CVS access
Schemas
Statistics
SMO
Zabbix[13] ZABBIX is an enterprise-class open source distributed monitoring solution.ZABBIX is software that monitors numerous parameters of a network and the health and integrity of servers. ZABBIX uses a flexible notification mechanism that allows users to configure e-mail based alerts for virtually any event. This allows a fast reaction to server problems. ZABBIX offers excellent reporting and data visualisation features based on the stored data. This makes ZABBIX ideal for capacity planning. Read More... 196 10.8 years. Ranked 398 and 511,389 downloads from sourceforge on 09/09/09. MySQL CVS access
Schemas
Statistics
SMO
e107[14] e107 is a website system written in PHP and MySQL. It installs a completely dynamic website on your server allowing you complete control of your site from a secure and intuitive, yet powerful and flexible admin area. Coded within the XHTML 1.1 Standard.[Read More...] 16 8.5 years. Ranked 203 and 1,255,976 downloads from sourceforge on 09/09/09. MySQL CVS access
Schemas
Statistics
SMO

On sourceforge


Medicine/Biology Databases
Name Description No. of Revisions Lifespan Popularity DBMS Further Information


Ensembl Genetic DB [15] The Ensembl project produces genome databases for vertebrates and other eukaryotic species, and makes this information freely available online. [Read More...] 412 9.8 years. 178,340 on alexa.org on 08/05/2009. MySQL

CVS access
SVN access
Schemas SMO

GrainGene [16] The GrainGenes 2.0 is a DB for Triticeae and Avena. [Read More...] 2 4,019 on alexa.org on 08/05/2009. MySQL Schema access

SQL Interface

UCSC Genome Bioinformatics [17] The UCSC database is a MySQL based project. [Read More...] 16,723 on alexa.org on 08/05/2009. MySQL Schema access


BioSQL [18] BioSQL is a joint effort between the OBF projects (BioPerl, BioJava etc) to support a shared database schema for storing sequence data. In theory, you could load a GenBank file into the database with BioPerl, then using Biopython extract this from the database as a record object with featues - and get more or less the same thing as if you had loaded the GenBank file directly as a SeqRecord using SeqIO. [Read More...] 46 6.6 years. Ranked 11,740,689 on alexa.org on 08/05/2009. MySQL SVN access
Schema

SMO

GUS [19] The Genomics Unified Schema (GUS) is an extensive relational database schema and associated application framework designed to store, integrate, analyze and present functional genomics data. The GUS schema supports a wide range of data types including genomics, gene expression, transcript assemblies, proteomics and others. It emphasizes standards-based ontologies and strong-typing. [Read More...] Ranked 15,597,325 on alexa.org on 08/05/2009. SVN access
Schema Browser
NCBO [20] The National Center for Biomedical Ontology is a consortium of leading biologists, clinicians, informaticians, and ontologists who develop innovative technology and methods allowing scientists to create, disseminate, and manage biomedical information and knowledge in machine-processable form. [Read More...] on alexa.org on 08/05/2009. SVN access
Schema

SMO


Open EMR [21] OpenEMR is a free medical practice management, electronic medical records, prescription writing, and medical billing application. These programs are also referred to as electronic health records. OpenEMR is licensed under the General Gnu Public License (General GPL). It is a free open source replacement for medical applications such as Medical Manager, Health Pro, and Misys. [Read More...] Ranked 642,041 on alexa.org on 08/05/2009. On sourceforge
[Statistics]
Genomic DB Survey [22] Survey of almost 80 genomic databases. [Read More...] Ranked on alexa.org on 08/05/2009 [][]
[Statistics]


CERN Physics DBs
Name Description No. of Revisions Lifespan Popularity DBMS Further Information


GridCC [23] The GRIDCC is a three-year project funded by the European Commission. Its goal is integrating instruments and sensors with the traditional Grid resources. The GRIDCC middleware is being designed bearing in mind use cases from a very diverse set of applications, and as the result, the GRIDCC architecture provides access to the instruments in as generic a way as possible. GRIDCC is also developing an adaptable user interface and a mechanism for executing complex workflows in order to increase both the usability and the usefulness of the system. The new middleware is incorporated into significant applications that will allow the software validation in terms both of functionality and quality of service. The pilot application this paper focuses on is applying GRIDCC to support Remote Operations of the ELETTRA synchrotron radiation facility. We describe the results of implementing via GRIDCC complex workflows involved in the both routine operations and troubleshooting scenarios. In particular, the implementation of an orbit correction feedback shows the level of integration of instruments and traditional Grid resources which can be reached using the GRIDCC middleware. [Read More...] 6 Ranked 5,115,481 on alexa.org on 08/05/2009. CVS access[Statistics]
ATLAS (Trigger) [24] ATLAS is a particle physics experiment at the Large Hadron Collider at CERN. Starting in Spring 2009, the ATLAS detector will search for new discoveries in the head-on collisions of protons of extraordinarily high energy. ATLAS will learn about the basic forces that have shaped our universe since the beginning of time and that will determine its fate. Among the possible unknowns are the origin of mass, extra dimensions of space, microscopic black holes, and evidence for dark matter candidates in the universe.Trigger is one of the software in the ATLAS project.[Read More...] 77 2 years. on alexa.org on 08/05/2009 Oracle CVS access
[Statistics]
GENV
CVS access
CVS access
EGEE JRAI Middleware [25] The mandate of the is to provide a reference open source implementation of the foundation services that are application independent and need to be deployed at all sites connected to the infrastructure. On top this foundation, an open-ended set of application specific higher-level services that can be deployed on-demand at specific sites are provided directly by JRA1 or integrated from other sources and projects.Grid Foundation Middleware comprises all services that need to be deployed on a production Grid infrastructure in order to provide a consistent, dependable service. It can be regarded as the Middleware Infrastructure.[Read More...] 17 4 years. on alexa.org on 08/05/2009 Oracle, MySQL CVS access
CVS access
[Statistics]
CASTOR [26] CASTOR, stands for the CERN Advanced STORage manager, is a hierarchical storage management (HSM) system developed at CERN used to store physics production files and user files. Files can be stored, listed, retrieved and accessed in CASTOR using command line tools or applications built on top of the different data transfer protocols like RFIO (Remote File IO), ROOT libraries, GridFTP and XROOTD. CASTOR manages disk cache(s) and the data on tertiary storage or tapes. Currently (2007) there are some 109 million files and about 15 petabyte of data in CASTOR. [Read More...] SRM2-45
CASTOR-149
3 years. on alexa.org on 08/05/2009 Oracle CVS access
CVS access
[Statistics]
ATLAS(DQ2) [27] The ATLAS data management system (DQ2) is responsible for managing ATLAS data. DQ2 is designed to work with the full analysis tool-chain. [Read More...] Oracle - 17
MySQL - 51
on alexa.org on 08/05/2009. Oracle, MySQL CVS access (Oracle)
CVS access (MySQL)
Schema-tracker
[Statistics]
DRAC [Read More...] WMS - 41 , Production Management System - 14 on alexa.org on 08/05/2009. Oracle CVS access
CVS access
[Statistics]
ELFMS [28] ELFms (Extremely Large Fabric management system)is one of the CERN Webs and comprises of Quattor, Lemon and LEAF.[Read More...] on alexa.org on 08/05/2009 Oracle CVS access
[Statistics]
Other Hydra-service and triDAS [Read More...] Hydra-service - 5 and triDAS - 7 on alexa.org on 08/05/2009 MySQL, Oracle CVS access
CVS access
[Statistics]
Personal tools