Hello:
DuraCloud comes with durareport and it provides a variety of metrics
for a repository that includes information based on mimetypes and size.
I've located a number of ITQL queries that provide some basic counts for
Fedora. I'm wondering if anyone in the community has developed
reporting/metrics tools for Fedora?
What methods are people using to determine the bytes occupied by a
collection of objects for instance? Are you able to provide a breakdown
by pid namespace, by internal/managed datastreams, etc.?
In some cases we are using du against the filesystem and then parsing
those results for the amount of space objects might occupy. I've added
some of the ITQL queries I've discovered/modified below, but would be
interested in any SQL queries that people run against their Fedora
database as well. I don't see how to query bytes-based information using
ITQL.
I'd be interested in how others gather/report metrics for their
repositories.
Thanks,
Donald
===== some sample ITQL queries from the community
This returns a count (you need to select count from the response list
dropdown) of digital objects that have the islandora:pageCModel content
model modified since 2011-01-01. This started with an example from
Steven Bayliss.
select $object from <#ri>
where $object <info:fedora/fedora-system:def/model#hasModel>
<info:fedora/islandora:pageCModel>
and $object <info:fedora/fedora-system:def/view#lastModifiedDate>
$modified
and $modified
<mulgara:after>'2011-01-01T00:00:00.000Z'^^<http://www.w3.org/2001/XMLSchema#dateTime>
in <#xsd>
======
This returns a total number of objects within the repository. Also
courtesy of Steve B.
select count ( select $subject $predicate $object from <#ri> where
$subject
$predicate $object and $subject <fedora-model:hasModel>
<info:fedora/fedora-system:FedoraObject-3.0> ) from <#ri> where
$subject
$predicate $object;
======
This returns a list of content models and the number of active objects
for each cmodel.
soure:
https://techknowhow.library.emory.edu/blogs/rsutton/2010/04/06/fedora-risearch-query-get-object-totals-cmodel
select $cmodel
count(select $item from <#ri>
where $item <info:fedora/fedora-system:def/model#hasModel> $cmodel
and $item <info:fedora/fedora-system:def/model#state>
<fedora-model:Active>)
from <#ri>
where $item <info:fedora/fedora-system:def/model#hasModel> $cmodel
having $k0 <http://mulgara.org/mulgara#occursMoreThan>
'0.0'^^<http://www.w3.org/2001/XMLSchema#double> ;
======
This returns a count of the mimetypes represented within your
repository ... still thinking about this one.
select $mimetypes
count(select $item from <#ri>
where $item <info:fedora/fedora-system:def/view#mimeType> $mimetypes
and $item <info:fedora/fedora-system:def/model#state>
<fedora-model:Active>)
from <#ri> where $item <info:fedora/fedora-system:def/view#mimeType>
$mimetypes
------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________
Fedora-commons-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
