X hits on this document

446 views

0 shares

1 downloads

0 comments

96 / 142

Chapter 15. XML and MySQL About XML and MySQL

MySQL is a relational database application, pure and simple. Billed as "The World's Most Popular Open Source Database" MySQL certainly has a wide support in the Internet community. Many people think MySQL can't be very good because it is free, especially Oracle database administrators. True, it does not have all the features of Oracle, nor does it require a specially trained person to keep it up and running. A part of the LAMP suite, MySQL compiles easily on a multitude of platforms. It comes as a pre-compiled binary for Windows. It has been used to manage millions of records and gigabytes of data. Fast and ro- bust, it supports the majority of people's relational database needs. With version 4.0 it supports proced- ures and triggers, features long desired by people who wanted "a real relational database application". For the purposes of this workbook, the simple XML functionality introduced in 4.0 is more important.

Installing and running a stand alone MySQL server on a Windows computer is relative easy:

  • 1.

    download the distribution

  • 2.

    unpack it into its own directory

  • 3.

    run the Setup application using the default settings

  • 4.

    open a command prompt

  • 5.

    start the server ( c:\mysql\bin\mysqld --standalone )

Installing MySQL on a Unix/Linux host is a bit more involved but pretty much follows the normal open source distribution method:

1.

download

2.

unzip

3.

untar

4.

./configure

5.

make

6.

sudo make install

7.

set up the server's root password

8.

initialize the server's necessary databases

Exercise - Transform MODS to SQL

In this exercise you will transform a file containing MODS records into an SQL file.

1.

Open xml-data/mods/single/catalog.xml in your Web browser or text editor. Notice how it a set of MODS records with human-readable element names denoting bibliograhic fields.

88

Document info
Document views446
Page views452
Page last viewedThu Dec 08 20:47:37 UTC 2016
Pages142
Paragraphs3126
Words34660

Comments