February 28/Class Notes- Database

R.D.M.S

structured query and language SQL

RDMS speaks SQL – its another language

each database contains a table

Column = Field
Row = Record

Field names cannot have spaces.

Most common DATA TYPES:

PRIMARY KEY: generates unique # for records.

Primary Key type is almost always INT

Varchar : Most is 30 characters, if want more use TEXT

Class Notes/ February 14

leafs are one side

pages are double sided ( thesis were all leafs…)

subdivisions( pg 19)

subject headings (pg 13)

topical subdivisions : subfield x

geographic subdivision : subfield z

chronological subdivision: subfield y

form subdivision : subfield v

authorities (some subdivisions)

photographer ontario toronto

$aPhotographers$zOntario$zToronto

lc classification – google

http://www.loc.gov/catdir/cpso/lcco/

photography is TR. ( in the document as well..)

CF : means “confer” in latin – compare or contrast

TR 6

TR 21

Classification

subfield a

150 field

TR 147

arranged by main entry

$aTR147$b.H33 2008 andrea hackman

if its a consonant ( h )

expansion

MARC con’t./Class Notes February 07/08

publication

260 ## $a New York:

$b Chelsea House,

$c 1986.

300 Physical description

300 ## $a 139 p. ;

$b ill. ;

$c 24 cm.

300 $avi, 200p. :$b

300 $a150p.

300 $a200, [5] p.

600 Subjects

what is this work about? 100 by author

600 subject

it is about photographic process, what not.

650 authority file

Authority

1XX – 100 – 50 valid forms of the heading

Bibliographic

100 – author

4XX

photographers (may subd geog) subdivision

hd labor

tr techonology ( ours)

bt : broader term

nt: narrower term

photographic dosimetry ( bold – valid)

uf- used form

use – use

week 4/Class notes: MARC Records AACR2

When I was looking at the Marc documents, I got lost.(readings e-serve) But this class made me how to look at it and understand it. I am more clear now. I am going to try to read it again and try to make some Marc records.

Copy cataloguing – original cataloguing

AACR2(anglo american cataloguing rules) is going to be become RDA – resource description and access.

relationships and items ( RDA)

the 2 tools are very different.

in print loof leaf and also online – AACR2

access points

form of access points

find one name and find the form of that name ( if the personA changes their name)

in cataloguging there are 8 areas of description : IFLA

• international
• standard
• book
• description

what am i cataloguing?

a book – part of a series – just one or all of them – create one marc record for all of them.

1. Consider , monograph series?

2. Title page, colophon – chief source

3. if you don’t have a chief source – you have to supply one.

you would put the title you have chosen in brackets.

[rock climbing for dummies]

4. Punctuation

… i left some stuff out here. list the first one (author) and don’t put the others.

marc is the way we enter the information in code form so the catalague can read it.

245 title statement (marc)

(nr) not repeatable (r) repeatable

indicator 1

indicator 2

what is the difference between statement of responsibility and the author

statement of responsibility: what is stated on the title page – by robert burley

copy what you see, transcribed

the author: established form of the name – controlled form of the name

every marc field has 2 indicators.

indicator 2 :

t h e and space = 4

a n = 3

a =2

Access points:

indicator 1:

Main entry – 100,110

type up the full description

personal author 100

corporate 110

Added entry – short typing up

700, 710, 711

coauthors 700

corporate body 710

conference 711

600 subject

editors dont get main entry

indicator 1 :

0 -no 100 field in the record – no author

1 – 100 is in the record – yes author

245 10 $a Pixel preservation:

$b observations on the current collecting.. /

$c by Siobhan Creem.

first word of a sentence gets capitalized and proper names.

Practise:

245 10 $aPicture taking and picture making

245 10 $aKodak pocket guide to video

245 14 $aThe pentax gallery catalogue of camera collection

LC catalogue

htttp://catalog.loc.gov

you need to add 520 or a 505 (table of contents)

http://www.loc.gov/marc/

lc – no dashes, replace them with 0s

040 $aCaOTR

$beng

$cCaOTR

$dCaOTR

EDITORS GO IN 700 ( NOT 100)

245 INDICATOR 1 :

1- DISPLAY THE TITLE ENTRY (index)

3 – NO DISPLAY i dont want people to see this

Intro to Imaging: Part 2: Workflow

I am still in the reading process of the second half of our readings. So far, everything (the process of imaging) is told very simply so it is easier to understand it. I think I need more information on Metadata which we will be learning later …

Important subjects:

Why Digitize?

Project Planning

Selecting Scanners

Image Capture

Selecting a Metadata Schema

Delivery

Security Policies and Procedures

Long-Term Management and Preservation

Again, it is good to learn the terms – and look them up from the glossary.

Thanks.

Introduction to Imaging Part 1

Introduction to imaging
By Howard Besser Edited by Sally Hubbard with Deborah Lenert

I found these articles very helpful. First of all, I wasn’t very familiar with the language and it really helped me to understand the language of imaging. I learned many longer versions of terms like Jpeg, Tiff, Http.. etc. which was great! I think this was a well-written introduction which simplified and directly touched on the main points about imaging. I am still in the air about some stuff but I think overall things make more sense in my head now. I printed the glossary as well which was very helpful…

Part :1

The Digital Image Defined

Standards

Metadata

The Image

Networks, System Architecture, and Storage

When I use the internet, softwares or computers, I tend not to think about the theory. You just do it. The depth to imaging is so clever and mathematical, mostly everything makes sense.. I did one of my papers on Policies Governing The Selection and Presentation of Collections on the World Wide Web and at so many points I was so confused and the information I was reading was above my head… With this information, it was good to return to the basics and of course with something that is written recent too…

I am glad that we are reading this. Thanks.

helloo!

helloo nice to meet ya!@! looking forward to this class….