Database » History » Version 9

Marcus Pearce, 2014-06-03 06:47 PM

1 2 Jeremy Gow
h1. Database management
2 1 Jeremy Gow
3 9 Marcus Pearce
Having [[Installation]|Installed and started IDyOM] and connected to a database, you can examine, read and edit its contents.  
4 6 Jeremy Gow
{{>toc}}
5 1 Jeremy Gow
6 6 Jeremy Gow
h2. Describing the database  
7 6 Jeremy Gow
8 4 Jeremy Gow
A quick way of listing the database contents is:
9 4 Jeremy Gow
10 1 Jeremy Gow
<pre>
11 8 Marcus Pearce
CL-USER> (mtp-admin:describe-database)
12 5 Jeremy Gow
0    Songs and ballads from Nova Scotia, Canada.
13 5 Jeremy Gow
1    Chorale melodies harmonised by J.S. Bach.
14 5 Jeremy Gow
2    Chorale soprano melodies harmonised by J.S. Bach.
15 5 Jeremy Gow
3    Alsatian folk songs from the Essen Folk Song Collection.
16 4 Jeremy Gow
...
17 4 Jeremy Gow
</pre>
18 1 Jeremy Gow
19 8 Marcus Pearce
Datasets can be examine in more detail using the verbose option in <code>describe-database</code> and <code>describe-dataset</code>:
20 4 Jeremy Gow
<pre>
21 8 Marcus Pearce
CL-USER> (mtp-admin:describe-database :verbose t)
22 1 Jeremy Gow
23 1 Jeremy Gow
 Songs and ballads from Nova Scotia, Canada.
24 1 Jeremy Gow
 -----------------------------------------------------------------------------
25 1 Jeremy Gow
 ID         No. Compositions     No. events           Mean events/composition
26 1 Jeremy Gow
 0          152                  8552                 56.263157           
27 1 Jeremy Gow
 -----------------------------------------------------------------------------
28 1 Jeremy Gow
29 1 Jeremy Gow
 Chorale melodies harmonised by J.S. Bach.
30 1 Jeremy Gow
 -----------------------------------------------------------------------------
31 1 Jeremy Gow
 ID         No. Compositions     No. events           Mean events/composition
32 1 Jeremy Gow
 1          185                  9227                 49.875675           
33 1 Jeremy Gow
 -----------------------------------------------------------------------------
34 1 Jeremy Gow
35 1 Jeremy Gow
 Chorale soprano melodies harmonised by J.S. Bach.
36 1 Jeremy Gow
 -----------------------------------------------------------------------------
37 1 Jeremy Gow
 ID         No. Compositions     No. events           Mean events/composition
38 1 Jeremy Gow
 2          100                  4693                 46.93               
39 1 Jeremy Gow
 -----------------------------------------------------------------------------
40 1 Jeremy Gow
41 1 Jeremy Gow
 Alsatian folk songs from the Essen Folk Song Collection.
42 1 Jeremy Gow
 -----------------------------------------------------------------------------
43 1 Jeremy Gow
 ID         No. Compositions     No. events           Mean events/composition
44 1 Jeremy Gow
 3          91                   4496                 49.406593           
45 1 Jeremy Gow
 -----------------------------------------------------------------------------
46 1 Jeremy Gow
47 1 Jeremy Gow
... 
48 1 Jeremy Gow
49 8 Marcus Pearce
 Pop melodies used in a segmentation experiment with Daniel Muellensiefen.
50 1 Jeremy Gow
 -----------------------------------------------------------------------------
51 1 Jeremy Gow
 ID         No. Compositions     No. events           Mean events/composition
52 1 Jeremy Gow
 29         15                   1265                 84.333336           
53 1 Jeremy Gow
 -----------------------------------------------------------------------------
54 1 Jeremy Gow
55 1 Jeremy Gow
 Hymn melodies from Hymns Ancient and Modern.
56 1 Jeremy Gow
 -----------------------------------------------------------------------------
57 1 Jeremy Gow
 ID         No. Compositions     No. events           Mean events/composition
58 1 Jeremy Gow
 30         120                  4280                 35.666668           
59 1 Jeremy Gow
 -----------------------------------------------------------------------------
60 1 Jeremy Gow
(0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30)
61 1 Jeremy Gow
</pre> 
62 1 Jeremy Gow
63 1 Jeremy Gow
<pre> 
64 1 Jeremy Gow
CL-USER> (mtp-admin:describe-dataset 0 :verbose t)
65 1 Jeremy Gow
66 1 Jeremy Gow
 Songs and ballads from Nova Scotia, Canada.
67 1 Jeremy Gow
 -----------------------------------------------------------------------------
68 1 Jeremy Gow
 ID         No. Compositions     No. events           Mean events/composition
69 1 Jeremy Gow
 0          152                  8552                 56.263157           
70 1 Jeremy Gow
 -----------------------------------------------------------------------------
71 1 Jeremy Gow
 CPITCH (26):     (54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
72 1 Jeremy Gow
                   72 73 74 75 76 77 79 81)
73 1 Jeremy Gow
 MPITCH (17):     (31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47)
74 1 Jeremy Gow
 ACCIDENTAL (3):  (-1 0 1)
75 1 Jeremy Gow
 DUR (14):        (3 4 6 8 12 16 18 24 36 48 60 72 96 120)
76 1 Jeremy Gow
 DELTAST (7):     (0 12 24 36 48 60 72)
77 1 Jeremy Gow
 BIOI (17):       (1 3 4 6 8 12 16 18 24 30 36 48 60 72 84 96 120)
78 1 Jeremy Gow
 KEYSIG (9):      (-4 -3 -2 -1 0 1 2 3 4)
79 1 Jeremy Gow
 MODE (2):        (0 9)
80 1 Jeremy Gow
 BARLENGTH (7):   (36 48 72 96 120 144 168)
81 1 Jeremy Gow
 PULSES (6):      (2 3 4 5 6 7)
82 1 Jeremy Gow
 PHRASE (3):      (-1 0 1)
83 1 Jeremy Gow
 DYN (1):         (NIL)
84 1 Jeremy Gow
 TEMPO (19):      (52 54 60 64 76 80 82 84 92 96 100 108 110 112 120 132
85 1 Jeremy Gow
                   144 152 172)
86 1 Jeremy Gow
 VOICE (1):       (1)
87 1 Jeremy Gow
 -----------------------------------------------------------------------------NIL
88 1 Jeremy Gow
CL-USER> 
89 1 Jeremy Gow
90 1 Jeremy Gow
</pre> 
91 1 Jeremy Gow
92 1 Jeremy Gow
93 6 Jeremy Gow
h2. Importing data  
94 1 Jeremy Gow
95 1 Jeremy Gow
Before you can do this you will need to import some data. Methods exist for **kern files and midi files.
96 1 Jeremy Gow
97 1 Jeremy Gow
<pre> 
98 1 Jeremy Gow
CL-USER> (mtp-admin:import-data :krn "/home/mas01mtp/research/data/kern/shanxi237/" "A test dataset" 31)
99 1 Jeremy Gow
Inserting data into database: dataset 31.
100 1 Jeremy Gow
NIL
101 1 Jeremy Gow
CL-USER> (mtp-admin:describe-dataset 31)
102 1 Jeremy Gow
103 1 Jeremy Gow
 A test dataset
104 1 Jeremy Gow
 -----------------------------------------------------------------------------
105 1 Jeremy Gow
 ID         No. Compositions     No. events           Mean events/composition
106 1 Jeremy Gow
 31         237                  11056                46.649788           
107 1 Jeremy Gow
 -----------------------------------------------------------------------------NIL
108 1 Jeremy Gow
CL-USER> 
109 1 Jeremy Gow
</pre>
110 1 Jeremy Gow
111 1 Jeremy Gow
<pre> 
112 8 Marcus Pearce
CL-USER> (mtp-admin:import-data :mid "/home/marcusp/research/data/midi/Witchcraft/" "Melodies used in an experiment by de Noojier et al. (2008)" 32)
113 1 Jeremy Gow
114 1 Jeremy Gow
Inserting data into database: dataset 32.NIL
115 1 Jeremy Gow
CL-USER> (mtp-admin:describe-dataset 32)
116 1 Jeremy Gow
117 1 Jeremy Gow
 Melodies used in de Noojier et al. (2008)
118 1 Jeremy Gow
 -----------------------------------------------------------------------------
119 1 Jeremy Gow
 ID         No. Compositions     No. events           Mean events/composition
120 1 Jeremy Gow
 32         10                   313                  31.3                
121 1 Jeremy Gow
 -----------------------------------------------------------------------------
122 1 Jeremy Gow
</pre> 
123 1 Jeremy Gow
124 6 Jeremy Gow
h2. Exporting data  
125 1 Jeremy Gow
126 1 Jeremy Gow
<pre>
127 1 Jeremy Gow
CL-USER> (mtp-admin:export-data (mtp-admin:get-composition 31 0) :mid "/tmp/")
128 1 Jeremy Gow
NIL
129 1 Jeremy Gow
</pre> 
130 1 Jeremy Gow
131 1 Jeremy Gow
Produces a midi file.
132 1 Jeremy Gow
133 1 Jeremy Gow
<pre>
134 1 Jeremy Gow
CL-USER> (mtp-admin:export-data (mtp-admin:get-composition 31 0) :lisp "/tmp/")
135 1 Jeremy Gow
NIL
136 1 Jeremy Gow
</pre> 
137 1 Jeremy Gow
138 1 Jeremy Gow
Produces a lisp readable representation of the dataset.
139 1 Jeremy Gow
140 1 Jeremy Gow
<pre>
141 1 Jeremy Gow
CL-USER> (mtp-admin:export-data (mtp-admin:get-composition 31 0) :ly "/tmp/")
142 1 Jeremy Gow
NIL
143 1 Jeremy Gow
</pre> 
144 1 Jeremy Gow
145 1 Jeremy Gow
Produces a lilypond file.
146 1 Jeremy Gow
147 1 Jeremy Gow
<pre>
148 1 Jeremy Gow
CL-USER> (mtp-admin:export-data (mtp-admin:get-composition 31 0) :pdf "/tmp/")
149 1 Jeremy Gow
NIL
150 1 Jeremy Gow
</pre> 
151 1 Jeremy Gow
152 1 Jeremy Gow
Produces a pdf score (via lilypond).
153 1 Jeremy Gow
154 1 Jeremy Gow
h2. Deleting a dataset  
155 1 Jeremy Gow
156 1 Jeremy Gow
<pre>
157 1 Jeremy Gow
CL-USER> (mtp-admin:delete-dataset 735)
158 1 Jeremy Gow
</pre>
159 1 Jeremy Gow
160 1 Jeremy Gow
deletes dataset 735 from the database.