Difference between revisions of "Database activity"

Jump to: navigation, search
(How to use the database activity module moved to Building Database)
(Automatically linking database entries, Example databases, Creative uses, See also moved to Using Database)
Line 12: Line 12:
* [[Using Database]]
* [[Using Database]]
* [[Database FAQ]]
* [[Database FAQ]]
==Automatically linking database entries==
If the [[Database auto-linking filter]] is enabled, any entries in a database will be automatically linked to where the concept words and/or phrases appear within the same course. This includes forum postings, internal resources, week summaries etc.
Note: If you do not want particular text to be linked (in a forum posting, say) then you should add <nolink> and </nolink> tags around the text. Alternatively the filter can be disabled for a particular activity.
== Example databases ==
Moodle.org has three good examples of the database module in action:
* [http://moodle.org/mod/data/view.php?id=6140 Moodle Buzz], a database of the titles, authors and web links to news articles mentioning Moodle
* [http://moodle.org/mod/data/view.php?d=26 Themes], a database with screenshots, download links and user comments about Moodle [[Themes|themes]]
* [http://moodle.org/mod/data/view.php?d=13 Modules and plugins], a database containing a variety of web links (download, documentation, discussion) and info (maintainer, module type, requirements) about the modular components of Moodle, including those created by third parties.
== Creative uses ==
You could use the database module to:
* allow collaboration on building a collection of web links/books/journal references related to a particular subject
* display student created photos/posters/websites/poems for peer comment and review
* gather comments and votes on a shortlist of potential logos/mascot names/project ideas
* provide a [http://moodle.org/mod/forum/discuss.php?d=52699 student file storage area]
* maintain a log of what was done in a face-to-face class each day, so that absent students can get caught up themselves.  [http://moodle.org/mod/forum/discuss.php?d=115047 Example]
== See also ==
* [[Glossary module]], which performs a similar though more specialised, text-based role
* [[Using Moodle book]] Chapter 12: Databases
* [http://moodle.org/mod/data/view.php?id=7303 Database for Databases]
* Using Moodle [http://moodle.org/mod/forum/view.php?id=3505 Database activity module forum]
* [http://treadwell.cce.cornell.edu/moodle_doc/database_moodle/index.html Screencast introducing the Database Module and walking through creating a database]
* [http://moodle.org/mod/data/view.php?rid=2424 Tracking Students' Reading with the Moodle Database Module] presentation
Using Moodle forum discussions:
* [http://moodle.org/mod/forum/discuss.php?d=72260 Database Module: Each learner Private DB?]
* [http://moodle.org/mod/forum/discuss.php?d=84487 Database for Dummies please!]
* [http://moodle.org/mod/forum/discuss.php?d=89117 Restricting access to database content by user?]
* [http://moodle.org/mod/forum/discuss.php?d=139137 How to use the database activity module?]

Revision as of 15:10, 23 September 2011

This page really needs improving. Please see the page comments for suggestions of what to include, then remove this template when you're done.

The database activity module allows the teacher and/or students to build, display and search a bank of record entries about any conceivable topic. The format and structure of these entries can be almost unlimited, including images, files, URLs, numbers and text amongst other things.

This module will create one table per instance, but you may create as many instances you need. The records can be linked to other tables and all resources in the course, if you allow autolink in a name field, but you cannot build a SQL query.

The table is not created in the SQL database, it is just stored there in lines of other SQL tables (mdl_data*).