« August 2010 | Main | October 2010 »

September 10, 2010

pdf uploads to DSPACE last year

Number of pdf files uploaded since 2009-09-10:
UDC: 5754
AgEcon: 5844
Total: 11,598

sql used
select count(name)   from ItemsByDateAccessioned, item2bundle, bundle2bitstream, bitstream  where item2bundle.item_id = itemsbydateaccessioned.item_id and item2bundle.bundle_id = bundle2bitstream.bundle_id and bitstream.bitstream_id = bundle2bitstream.bitstream_id and bitstream.name ~ '^.*pdf$' and ItemsByDateAccessioned.date_accessioned > '2009-09-10'::DATE ; 

September 3, 2010

Tables populated by Node Relationships Module

Tables populated by Relationships module .jpg

September 1, 2010

Distinct values for language in AgEcon

Type of language metadata fields in DSPACE

 metadata_field_id | metadata_schema_id |   element   |         qualifier         
-------------------+--------------------+-------------+---------------------------
                37 |                  1 | language    | 
                38 |                  1 | language    | iso

language field (metadata_field_id = 37)

Total count:
sql: select count( text_value) from metadatavalue where metadata_field_id=37;
Count: 27538

Distinct values
sql: select DISTINCT text_value from metadatavalue where metadata_field_id=37 ;

Afrikaans
Chinese
Danish
Dutch
English
French
German
Hungarian
Japanese
Spanish
(10 rows)

language iso field (metadata_field_id = 38)

Total count:
sql: select count( text_value) from metadatavalue where metadata_field_id=38;
Count: 41971
select DISTINCT text_value from metadatavalue where metadata_field_id=38 ;
af
da
de
Dutch
en
en_US
es
fr
French
it
nl
other
sp
SP
Spanish
zh
(16 rows)
Clearly some non-iso values have slipped in.