chapter 1-3 nagekeken

9 files changed, 264 insertions, 299 deletions

diff --git a/Report/2ID45-Report.aux b/Report/2ID45-Report.aux
index 189f113..6262ec1 100644
--- a/Report/2ID45-Report.aux
+++ b/Report/2ID45-Report.aux
@@ -1,4 +1,5 @@
 \relax 

+\@input{toc.aux}

 \@input{Chapter1.aux}

 \@input{Chapter2.aux}

 \@input{Chapter3.aux}

diff --git a/Report/2ID45-Report.log b/Report/2ID45-Report.log
index 84230ee..0897612 100644
--- a/Report/2ID45-Report.log
+++ b/Report/2ID45-Report.log
@@ -1,4 +1,4 @@
-This is pdfTeX, Version 3.141592-1.40.4 (MiKTeX 2.7) (preloaded format=pdflatex 2008.4.2)  26 MAY 2008 22:16

+This is pdfTeX, Version 3.141592-1.40.4 (MiKTeX 2.7) (preloaded format=pdflatex 2008.4.2)  26 MAY 2008 23:33

 entering extended mode

 **D:/My*Documents/TUe/2id45/Report/2ID45-Report.tex

 ("D:/My Documents/TUe/2id45/Report/2ID45-Report.tex"

@@ -133,8 +133,9 @@ Package: color 2005/11/14 v1.0j Standard LaTeX Color (DPC)
 File: color.cfg 2007/01/18 v1.5 color configuration of teTeX/TeXLive

 )

 Package color Info: Driver file: pdftex.def on input line 130.

-) (2ID45-Report.aux (Chapter1.aux) (Chapter2.aux) (Chapter3.aux) (Chapter4.aux)

- (Chapter5.aux))

+) (2ID45-Report.aux (toc.aux) (Chapter1.aux) (Chapter2.aux) (Chapter3.aux) (Cha

+pter4.aux)

+(Chapter5.aux))

 LaTeX Font Info:    Checking defaults for OML/cmm/m/it on input line 8.

 LaTeX Font Info:    ... okay on input line 8.

 LaTeX Font Info:    Checking defaults for T1/cmr/m/n on input line 8.

@@ -147,8 +148,7 @@ LaTeX Font Info:    Checking defaults for OMX/cmex/m/n on input line 8.
 LaTeX Font Info:    ... okay on input line 8.

 LaTeX Font Info:    Checking defaults for U/cmr/m/n on input line 8.

 LaTeX Font Info:    ... okay on input line 8.

-

-("C:\Program Files\MiKTeX 2.7\tex\context\base\supp-pdf.tex"

+ ("C:\Program Files\MiKTeX 2.7\tex\context\base\supp-pdf.tex"

 [Loading MPS to PDF converter (version 2006.09.02).]

 \scratchcounter=\count103

 \scratchdimen=\dimen114

@@ -171,101 +171,153 @@ File: umsb.fd 2002/01/19 v2.2g AMS font definitions
 ) [1

 

 {C:/Documents and Settings/s052058/Local Settings/Application Data/MiKTeX/2.7/p

-dftex/config/pdftex.map}] (Chapter1.tex

+dftex/config/pdftex.map}] (toc.tex (2ID45-Report.toc)

+\tf@toc=\write4

+) [2

+

+] (Chapter1.tex

 Missing character: There is no ” in font cmr12!

 Missing character: There is no ” in font cmr12!

 

-Underfull \hbox (badness 10000) in paragraph at lines 2--3

+Underfull \hbox (badness 10000) in paragraph at lines 3--4

 

  []

 

 

-Underfull \hbox (badness 10000) in paragraph at lines 4--5

+Underfull \hbox (badness 10000) in paragraph at lines 5--6

 

  []

 

 

-Underfull \hbox (badness 10000) in paragraph at lines 6--7

+Underfull \hbox (badness 10000) in paragraph at lines 7--8

 

  []

 

-) [2

+

+Underfull \hbox (badness 10000) in paragraph at lines 9--10

+

+ []

+

+) [3

+

 

 ] (Chapter2.tex

-Underfull \hbox (badness 10000) in paragraph at lines 6--27

+Underfull \hbox (badness 10000) in paragraph at lines 7--8

 

  []

 

 

-Underfull \hbox (badness 10000) in paragraph at lines 6--27

+Underfull \hbox (badness 10000) in paragraph at lines 9--10

 

  []

 

 

-Underfull \hbox (badness 10000) in paragraph at lines 29--37

+Underfull \hbox (badness 10000) in paragraph at lines 11--12

 

  []

 

-LaTeX Font Info:    Try loading font information for OMS+cmr on input line 38.

+

+Underfull \hbox (badness 10000) in paragraph at lines 17--18

+

+ []

+

+LaTeX Font Info:    Try loading font information for OMS+cmr on input line 22.

 ("C:\Program Files\MiKTeX 2.7\tex\latex\base\omscmr.fd"

 File: omscmr.fd 1999/05/25 v2.5h Standard LaTeX font definitions

 )

 LaTeX Font Info:    Font shape `OMS/cmr/m/n' in size <12> not available

-(Font)              Font shape `OMS/cmsy/m/n' tried instead on input line 38.

- [3

+(Font)              Font shape `OMS/cmsy/m/n' tried instead on input line 22.

+ [4

 

 

 ]

-<DiagramPottepeiFinal.png, id=15, 568.1225pt x 495.8525pt>

+<DiagramPottepeiFinal.png, id=18, 568.1225pt x 495.8525pt>

 File: DiagramPottepeiFinal.png Graphic file (type png)

 

 <use DiagramPottepeiFinal.png>

-Overfull \hbox (35.93774pt too wide) in paragraph at lines 63--63

+Overfull \hbox (36.79134pt too wide) in paragraph at lines 40--40

  [] 

  []

 

-[4]) [5 <DiagramPottepeiFinal.png (PNG copy)>] (Chapter3.tex

-Underfull \hbox (badness 10000) in paragraph at lines 36--44

+[5]) [6 <DiagramPottepeiFinal.png (PNG copy)>] (Chapter3.tex

+Underfull \hbox (badness 10000) in paragraph at lines 10--11

 

  []

 

-[6

 

+Underfull \hbox (badness 10000) in paragraph at lines 12--13

+

+ []

 

-] <LiquorType.png, id=26, 203.76125pt x 198.7425pt>

+

+Underfull \hbox (badness 10000) in paragraph at lines 16--17

+

+ []

+

+[7

+

+

+] <LiquorType.png, id=30, 203.76125pt x 198.7425pt>

 File: LiquorType.png Graphic file (type png)

  <use LiquorType.png>

-Underfull \hbox (badness 10000) in paragraph at lines 66--74

+Underfull \hbox (badness 10000) in paragraph at lines 36--37

 

  []

 

-<NewsCategory.png, id=27, 523.9575pt x 198.7425pt>

+<NewsCategory.png, id=31, 523.9575pt x 198.7425pt>

 File: NewsCategory.png Graphic file (type png)

  <use NewsCategory.png>

-Overfull \hbox (2.93257pt too wide) in paragraph at lines 75--75

+Overfull \hbox (2.93257pt too wide) in paragraph at lines 49--49

  [] 

  []

 

-[7 <LiquorType.png (PNG copy)>] [8 <NewsCategory.png (PNG copy)>]

-<DB.png, id=35, 924.45375pt x 554.07pt>

+[8 <LiquorType.png (PNG copy)>]

+Overfull \hbox (79.30023pt too wide) in paragraph at lines 68--68

+[]      \OT1/cmtt/m/n/12 <intern>index.php?link=news&amp;title=Op_restaurant_me

+t_je_eigen_wijn?[] 

+ []

+

+

+Overfull \hbox (85.47523pt too wide) in paragraph at lines 70--70

+[]      \OT1/cmtt/m/n/12 <description>BYO (Bring your own) ontstond in de Engel

+stalige landen...[] 

+ []

+

+[9 <NewsCategory.png (PNG copy)>] <DB.png, id=38, 924.45375pt x 386.44376pt>

 File: DB.png Graphic file (type png)

- <use DB.png> [9] [10 <DB.png (PNG copy)>] <rssfeeds.png, id=42, 444.66125pt x 

-301.125pt>

+

+<use DB.png>

+Overfull \hbox (65.24408pt too wide) in paragraph at lines 95--95

+ [] 

+ []

+

+[10 <DB.png (PNG copy)>] <rssfeeds.png, id=42, 444.66125pt x 301.125pt>

 File: rssfeeds.png Graphic file (type png)

- <use rssfeeds.png>

-Underfull \hbox (badness 10000) in paragraph at lines 199--204

+

+<use rssfeeds.png> [11]

+Underfull \hbox (badness 10000) in paragraph at lines 136--137

 

  []

 

-[11 <rssfeeds.png (PNG copy)>] [12]

-Overfull \hbox (42.25021pt too wide) in paragraph at lines 288--288

+[12 <rssfeeds.png (PNG copy)>]

+Underfull \hbox (badness 10000) in paragraph at lines 177--178

+

+ []

+

+[13]

+Overfull \hbox (42.25021pt too wide) in paragraph at lines 206--206

 []      \OT1/cmtt/m/n/12 <guid>http://www.goedkoopbier.nl/nieuws/Heineken_Trom_

 Pet</guid>[] 

  []

 

-[13] <RSS.png, id=56, 683.55376pt x 473.77pt>

+[14]

+Underfull \hbox (badness 10000) in paragraph at lines 237--238

+

+ []

+

+<RSS.png, id=59, 683.55376pt x 473.77pt>

 File: RSS.png Graphic file (type png)

- <use RSS.png> [14]) [15 <RSS.png (PNG copy)>] (Chapter4.tex

+ <use RSS.png> [15]) [16 <RSS.png (PNG copy)>] (Chapter4.tex

 Underfull \hbox (badness 10000) in paragraph at lines 3--4

 

  []

@@ -280,37 +332,52 @@ Underfull \hbox (badness 10000) in paragraph at lines 29--30
 

  []

 

-[16

+[17

 

 

 ])

-Underfull \hbox (badness 10000) in paragraph at lines 51--21

+Underfull \hbox (badness 10000) in paragraph at lines 51--22

+

+ []

+

+[18] (Chapter5.tex

+Underfull \hbox (badness 10000) in paragraph at lines 3--4

+

+ []

+

+

+Underfull \hbox (badness 10000) in paragraph at lines 5--6

+

+ []

+

+

+Underfull \hbox (badness 10000) in paragraph at lines 7--8

 

  []

 

-[17] (Chapter5.tex) [18

+) [19

 

 

-] (2ID45-Report.aux (Chapter1.aux) (Chapter2.aux)

-(Chapter3.aux) (Chapter4.aux) (Chapter5.aux)) ) 

+] (2ID45-Report.aux (toc.aux) (Chapter1.aux) (Chapter2.aux) (Chapter3.aux) (Cha

+pter4.aux) (Chapter5.aux)) ) 

 Here is how much of TeX's memory you used:

- 1773 strings out of 95282

- 20887 string characters out of 1183317

- 73767 words of memory out of 1500000

- 4932 multiletter control sequences out of 110000

+ 1784 strings out of 95282

+ 20974 string characters out of 1183317

+ 74023 words of memory out of 1500000

+ 4933 multiletter control sequences out of 110000

  13981 words of font info for 53 fonts, out of 1200000 for 2000

  54 hyphenation exceptions out of 8191

- 27i,6n,22p,424b,259s stack positions out of 5000i,500n,10000p,200000b,5000s

-<C:/Program Files/MiKTeX 2.7/fon

-ts/type1/bluesky/cm/cmbx12.pfb><C:/Program Files/MiKTeX 2.7/fonts/type1/bluesky

-/cm/cmmi12.pfb><C:/Program Files/MiKTeX 2.7/fonts/type1/bluesky/cm/cmr12.pfb><C

-:/Program Files/MiKTeX 2.7/fonts/type1/bluesky/cm/cmr17.pfb><C:/Program Files/M

-iKTeX 2.7/fonts/type1/bluesky/cm/cmsl12.pfb><C:/Program Files/MiKTeX 2.7/fonts/

-type1/bluesky/cm/cmsy10.pfb><C:/Program Files/MiKTeX 2.7/fonts/type1/bluesky/cm

-/cmti12.pfb><C:/Program Files/MiKTeX 2.7/fonts/type1/bluesky/cm/cmtt12.pfb>

-Output written on 2ID45-Report.pdf (18 pages, 260469 bytes).

+ 27i,6n,22p,649b,257s stack positions out of 5000i,500n,10000p,200000b,5000s

+<C:/Program Files/MiKTeX 2.7/fonts/type1/bluesky/cm

+/cmbx12.pfb><C:/Program Files/MiKTeX 2.7/fonts/type1/bluesky/cm/cmmi12.pfb><C:/

+Program Files/MiKTeX 2.7/fonts/type1/bluesky/cm/cmr12.pfb><C:/Program Files/MiK

+TeX 2.7/fonts/type1/bluesky/cm/cmr17.pfb><C:/Program Files/MiKTeX 2.7/fonts/typ

+e1/bluesky/cm/cmsl12.pfb><C:/Program Files/MiKTeX 2.7/fonts/type1/bluesky/cm/cm

+sy10.pfb><C:/Program Files/MiKTeX 2.7/fonts/type1/bluesky/cm/cmti12.pfb><C:/Pro

+gram Files/MiKTeX 2.7/fonts/type1/bluesky/cm/cmtt12.pfb>

+Output written on 2ID45-Report.pdf (19 pages, 254068 bytes).

 PDF statistics:

- 98 PDF objects out of 1000 (max. 8388607)

+ 102 PDF objects out of 1000 (max. 8388607)

  0 named destinations out of 1000 (max. 131072)

  31 words of extra memory for PDF output out of 10000 (max. 10000000)

 

diff --git a/Report/2ID45-Report.tex b/Report/2ID45-Report.tex
index b03e11c..6fa4ac4 100644
--- a/Report/2ID45-Report.tex
+++ b/Report/2ID45-Report.tex
@@ -15,6 +15,7 @@
 %no paragraph indentation

 \parindent=0in

 

+\include{toc}

 \include{Chapter1}

 \include{Chapter2}

 \include{Chapter3}

diff --git a/Report/Chapter1.tex b/Report/Chapter1.tex
index e25ecdf..64fa3ce 100644
--- a/Report/Chapter1.tex
+++ b/Report/Chapter1.tex
@@ -1,14 +1,11 @@
 \section{Introduction}

-For the master course Advanced Databases (2ID45), we have chosen to create

-a liquor database. The project is called ”Pottepei” which is Flemish

-(Brussels) for a drunk. To access the database a web interface, which can be found at "http://pottepei.schinagl.nl", was made available. \\

 

-This document will discus the inside view of the project. The general description of the project can be found in chapter 2. Also in this chapter, a description of what the website does and an overview of the techniques that were used to complete the project. \\

+For the master course Advanced Databases (2ID45), we have chosen to create a liquor database. The project is called ”Pottepei” which is Flemish (Brussels) for a someone who like a beer or two. To access the database, a web interface which can be found at "http://pottepei.schinagl.nl", was made available. \\

 

-In the next chapters we will go further into details about the

-techniques we used. In chapter 3 we will discuss all the XML aspects

-of the project, discuss the XML files used, how they are laid out and their purpose. \\

+This document will discus the inside view of the project. The general description of the project can be found in chapter 2. A description of what the website is all about and an overview of the techniques that were used to complete the project are also in this chapter. \\

 

-In chapter 4 we will explain which query's were used to achieve some goals. Some query's will be given and explained. \\

+In the next chapters we will go further into details about the techniques we used. In chapter 3 we will discuss all the XML aspects of the project, discuss the XML files used, how they are laid out and their purpose. \\

 

-Finally we will finish chapter 5 with a conclusion. \\

+In chapter 4 we will explain which query's were used to achieve some of the goals of the application. Some of the query's will be given and explained. \\

+

+Finally we will finish with the conclusion in chapter 5.
\ No newline at end of file
diff --git a/Report/Chapter2.tex b/Report/Chapter2.tex
index fb3a9f7..d3e2d25 100644
--- a/Report/Chapter2.tex
+++ b/Report/Chapter2.tex
@@ -1,63 +1,42 @@
 \section{General Project Description}

 

-In this chapter we will give a general description of the project. What

-does it do and how is it done? We also give an overview of the used

-techniques. At the end of this section a figure with a representation of the project and the techniques is given.

+In this chapter we will give a general description of the project. What does it do and how is it done? We also give an overview of the used techniques. At the end of this section a figure with a representation of the project and the techniques is given.

 

 \subsection{The project}

-We have made a liquor database which is accessible via a web interface.

-The main purposes of the web site is to gather information and put it

-to a database. The information can be attained in two ways. One way is to

-manually insert the information, the other way is to add a remote RSS feed

-to the website. The website will take the information from the RSS

-feed en put it into our own database. We have first chosen three standard

-RSS feeds, but decided during implementation to bind the RSS feeds

-dynamically. \\ One can bind and un-bind RSS feeds to the website. Therefore the site can contain many more and other

-information than liquor only, just by connecting other RSS feeds. We

-started this project as one with a liquor database, so for the

-project liquor is used as initial information. \\

-

-Another functionality of the website is a search engine. It is possible to

-search through various messages with given keywords. The title, message content or both are searchable. You can

-specify in which news category or which liquor type you want to search. This can also be used as a filter on it. \\

-

-It is also possible to subscribe to a RSS feed of our own. This RSS feed contains the last twenty entries. \\

+

+We have made a liquor database which is accessible via a web interface. The main purposes of the web site is to gather information and put it into a database. The information can be attained in two ways. One way is to manually insert the information, the other way is to add a remote RSS feed to the website. The website will take the information from the RSS feed en put it into our own database. We have first chosen three standard RSS feeds, but decided during implementation to bind the RSS feeds dynamically. \\

+

+One can bind and un-bind RSS feeds to the website. Therefore the site can contain many more and other information than liquor only, just by connecting other RSS feeds. We started this project as one with a liquor database, so for the project, liquor and cocktails are used as initial information. \\

+

+Another functionality of the website is a search engine. It is possible to search through various messages with given keywords. The title, message content or both are searchable. You can specify in which news category or which liquor type you want to search. This can also be used as a filter. \\

+

+It is also possible to subscribe to a RSS feed of our own. This RSS feed contains the last twenty entries of the entire database.

 

 \subsection{Overview of the used techniques}

-At the beginning of the project there were given four technologies.

-From these four, the project had to contain at least two. We have chosen

-to use all four of the technologies, but during the implementation

-we had decided to drop the XSLT part. The reason for that is that we

-had to little knowledge of XSLT to find a good problem which we could

-solve by using XSLT. \\

+

+At the beginning of the project there were given four technologies. From these four, the project had to contain at least two. We have chosen to use all four of the technologies, but during the implementation we had decided to drop the XSLT part. The reason for that is that we had to little knowledge of XSLT to find a good problem which we could solve by using XSLT. \\

 

 The following technologies are used for the project:

+

 \begin{itemize}

-  \item \textbf{XML/ XML schemes}: This is being used to gather and

-  store the information.

-  \item \textbf{XQuery/XPath}: This is being used to save the information rightly and to search for

-  information.

-  \item \textbf{Web interface}: This is being used to access the

-  information.

+  \item \textbf{XML / XML schemes}: This is being used to gather and store the information.

+  \item \textbf{XQuery / XPath}: This is being used to save the information correctly and to search for data.

+  \item \textbf{Web interface}: This is being used to access the information.

 \end{itemize}

+

 To support the technologies we used the following techniques:

+

 \begin{itemize}

   \item \textbf{RSS}: This is being used to gather information from other websites. We use it also to deliver information.

-  \item \textbf{PHP}: This is used to built the website.

-  \item \textbf{Simple XML for PHP}: This is a PHP module which gives the opportunity to work with XML statements. This is used to built the outgoing RSS Feed.

+  \item \textbf{PHP}: This is used to built the website (along with HTML).

+  \item \textbf{Simple XML for PHP}: This is a PHP module which gives the programmer the opportunity to work with XML and XPath statements. This is for instance used to built the outgoing RSS Feed.

 \end{itemize}

 

 \subsection{Representation of the project}

-In the figure below you see a representation of our project. The

-website with the XML database is the central of the project. The

-website has a PHP script which will be run six times per day. First the

-script gets the RSS binding from the database, then it obtains the

-information from the RSS feeds and puts these into database. A user

-can interact with the site (search information or inserts new

-information). The website transforms the user interactions to

-Xquery/Xpath, so it can interact with the database. A user can also

-get an RSS feed from our website.

+

+In the figure one the next page you can see a representation of our project. The website with the XML database is the center of the project. The website has a PHP script which will be run six times per day. First the script gets the RSS binding from the database, then it obtains the information from the RSS feeds and puts these into database. A user can interact with the site (search information or inserts new information). The website transforms the user interactions to Xquery/Xpath, so it can interact with the database. A user can also get an RSS feed from our website.

+

 \begin {center}

-  \includegraphics[width=149.7mm]{DiagramPottepeiFinal.png} \\

-  Representation of the project

+  \includegraphics[width=150.0mm]{DiagramPottepeiFinal.png} \\

+  Fig 1. Representation of the project

 \end {center}

diff --git a/Report/Chapter3.aux b/Report/Chapter3.aux
index c8e48ef..96739f5 100644
--- a/Report/Chapter3.aux
+++ b/Report/Chapter3.aux
@@ -1,16 +1,16 @@
 \relax 

-\@writefile{toc}{\contentsline {section}{\numberline {3}XML}{6}}

-\@writefile{toc}{\contentsline {subsection}{\numberline {3.1}Database XML}{6}}

-\@writefile{toc}{\contentsline {subsubsection}{\numberline {3.1.1}LiquorTypes.xml}{6}}

-\@writefile{toc}{\contentsline {subsubsection}{\numberline {3.1.2}NewsCategories.xml}{7}}

-\@writefile{toc}{\contentsline {subsubsection}{\numberline {3.1.3}DB.xml}{8}}

-\@writefile{toc}{\contentsline {subsubsection}{\numberline {3.1.4}rssfeeds.xml}{10}}

-\@writefile{toc}{\contentsline {subsection}{\numberline {3.2}RSS-Feeds}{11}}

-\@writefile{toc}{\contentsline {subsubsection}{\numberline {3.2.1}Incomming RSS-feed}{11}}

-\@writefile{toc}{\contentsline {subsubsection}{\numberline {3.2.2}Outgoing RSS-feed}{12}}

-\@writefile{toc}{\contentsline {subsubsection}{\numberline {3.2.3}The construction of a RSS feed}{13}}

+\@writefile{toc}{\contentsline {section}{\numberline {3}XML}{7}}

+\@writefile{toc}{\contentsline {subsection}{\numberline {3.1}Database XML}{7}}

+\@writefile{toc}{\contentsline {subsubsection}{\numberline {3.1.1}LiquorTypes.xml}{7}}

+\@writefile{toc}{\contentsline {subsubsection}{\numberline {3.1.2}NewsCategories.xml}{8}}

+\@writefile{toc}{\contentsline {subsubsection}{\numberline {3.1.3}DB.xml}{9}}

+\@writefile{toc}{\contentsline {subsubsection}{\numberline {3.1.4}rssfeeds.xml}{11}}

+\@writefile{toc}{\contentsline {subsection}{\numberline {3.2}RSS-Feeds}{12}}

+\@writefile{toc}{\contentsline {subsubsection}{\numberline {3.2.1}Incoming RSS-feed}{12}}

+\@writefile{toc}{\contentsline {subsubsection}{\numberline {3.2.2}Outgoing RSS-feed}{13}}

+\@writefile{toc}{\contentsline {subsubsection}{\numberline {3.2.3}The construction of an RSS feed}{14}}

 \@setckpt{Chapter3}{

-\setcounter{page}{16}

+\setcounter{page}{17}

 \setcounter{equation}{0}

 \setcounter{enumi}{5}

 \setcounter{enumii}{0}

diff --git a/Report/Chapter3.tex b/Report/Chapter3.tex
index 54f2e57..c0b3cbc 100644
--- a/Report/Chapter3.tex
+++ b/Report/Chapter3.tex
@@ -1,28 +1,20 @@
 \section{XML}

-There are two kinds of XML files used for the website. The main

-information will be stored in the Database XML, this file will be

-supported by three other XML files. The information in the Database

-XML will be increased by two methods. You can enter information

-manually, or the information will be imported from other sites via

-RSS-feeds. An RSS is the second kind XML file. This is a standard XML

-file. The website will also offer information via an RSS feed.

-

-In this section you can read how the XML files are build.

+

+There are two kinds of XML files used for the website. The main information will be stored in the Database XML, this file will be supported by three other XML files. The size of the XML database will be increased by two methods. You can enter information manually or the information will be imported from other sites via

+RSS-feeds. An RSS is the second kind XML file. This is a standardized XML file. The website will also offer information via this RSS feed.

+

+In this section you can read how the XML files are build up.

+

 \subsection{Database XML}

-All the information for the website is stored in four Database XML

-files. One file contains the main information about all the liquor.

-Two files contains grouping information of the liquor. And there is

-one file which contains technical information for the incoming RSS

-feeds. In this section we will discussed the four files. This will be

-done by a description, (a part of) the file and a XML tree. We

-started with grouping the two information files. Note: The

-information in the XML files is the information, or a part of the

-information, which the files contains at the moment this report is

-written. Some files can be extended with information, because of the

-dynamicallity of the website. \\

-

-\subsubsection{LiquorTypes.xml} In this file we will store the different

-kind of liquor, for which we have data in the database. Below a snippet of the XML-file.

+

+All the information for the website is stored in four Database XML files. One file contains the main information about all the liquor. Two files contains grouping information of the liquor. Finally there is one file which contains technical information for the incoming RSS feeds. In this section we will discussed the four files. This will be done by a description, (a part of) the file and an XML tree. We started with grouping the two information files. \\

+ 

+\textbf{Note}: The information in the given XML file snippets is the actual data (or a part of it) which the files contain at the moment this report is written. Some files can be extended with information because of the dynamic nature of the website. \\

+

+\subsubsection{LiquorTypes.xml}

+

+In this file we will store the different kinds of liquor for which we have data in the database. Every type has its own ID on which the items relate to. The name of the LiquorTypes are also being used by the search engine of the site. Below you see the XML file about the liquor types: \\

+

 \begin{verbatim}

 <LiquorTypes>

   <LiquorType ID="1"><Name>General</Name></LiquorType>

@@ -31,28 +23,18 @@ kind of liquor, for which we have data in the database. Below a snippet of the X
   <LiquorType ID="4"><Name>Cocktail</Name></LiquorType>

 </LiquorTypes>

 \end{verbatim}

-Every type has its own ID on which the items are related to. The name

-of the LiquorTypes are also being used by the search engine of the

-site. Below you see a the XML file about the liquor types: \\

-

-On figure below it can be seen that the Data tree of the LiquorTypes XML-file. For

-all elements in the XML there will be only one shown completed. If

-there can be more elements, which are the same as their siblings,

-they are shown dotted (without their descendants).

+

+On the figure below the data tree of the LiquorTypes XML-file is shown. For all elements in the XML file there will be only one shown completely. If there can be more elements, which are the same as their siblings, they are shown dotted (without their descendants).

+

 \begin {center}

   \includegraphics[width=53.7mm]{LiquorType.png} \\

-  Data tree of LiquorType.xml

+  Fig 2. Data tree of LiquorType.xml

 \end {center}

 

+\subsubsection{NewsCategories.xml}

 

+In this file we will store the different categories the items belong to. It is very similar to the LiquorTypes XML. Every category had its own ID on which the items relate to. The name of the LiquorTypes are also being used by the search engine of the site. Below a snippet of the XML-file about the NewsCategories can be seen: \\

 

-

-

-

-\subsubsection{NewsCategories.xml}

-In this file we will store the different categories the items are from.

-It is very similar to the LiquorTypes XML-file. Below you see the

-XML-file.

 \begin{verbatim}

 <NewsCategories>

   <NewsCategory ID="1"><Name>News</Name></NewsCategory>

@@ -61,28 +43,17 @@ XML-file.
 </NewsCategories>

 \end{verbatim}

 

-Every category had its own ID on which the items are related to. The

-name of the LiquorTypes are also being used by the search engine of

-the site. Below a snippet of the XML-file about the NewsCategories can be seen: \\

+On figure below you can see the data tree of the NewsCategories XML-file. All elements in the XML will be shown completely. If there can be more elements, which are the same as their siblings, they are shown dotted (without their descendants).

 

-On figure below you'll see the Data tree of the NewsCategories XML-file.

-All elements in the XML will be shown completed. If there can be more

-elements, which are the same as their siblings, they are shown

-dotted (without their descendants).

 \begin {center}

   \includegraphics[width=138.1mm]{NewsCategory.png} \\

-  Data tree of NewsCategories.xml

+  Fig 3. Data tree of NewsCategories.xml

 \end {center}

 

+\subsubsection{DB.xml}

 

+In this file we will store the main information of the website. Below you see a snippet of the XML-file.

 

-

-

-

-

-\subsubsection{DB.xml}

-In this file we will store the main information of the website. Below

-you see a snippet of the XML-file.

 \begin{verbatim}

 <db>

   <items>

@@ -94,62 +65,41 @@ you see a snippet of the XML-file.
             -restaurant-met-je-eigen-wijn.htm

       </guid>

       <title>Op restaurant met je eigen wijn?</title>

-      <intern>index.php?link=news&amp;title=Op_restaurant_

-              met_je_eigen_wijn?

+      <intern>index.php?link=news&amp;title=Op_restaurant_met_je_eigen_wijn?

       </intern>

-      <description>BYO (Bring your own) ontstond in de Engel

-                   stalige landen. In Australi&euml; is het

-                   zelfs de regel vanwege de torenhoge taksen

-                    op wijn verkocht door restaurants. Dus

-                    brengen de mensen hun eigen wijn mee en

-                    betalen enkel een 'kurkrecht' om die op

-                    restaurant te kunnen drinken. Het kurkr

-                    echt is een soort vergoeding voor de se

-                    rvice (sommelier, afwas) ...

+      <description>BYO (Bring your own) ontstond in de Engelstalige landen...

       </description>

     </item>

 

-...

+    ...

 

   </items>

 </db>

 \end{verbatim}

-The site contains many news messages, these news messages are stored

-in the item elements, which is a child of the items element. The

-following elements are part of the item element:

+

+The site contains many news messages which are stored in the "item" elements, a child of the "items" element. The following elements are part of the item element:

+

 \begin{itemize}

-\item \underline{LiquorTypeID}: This is the ID of the LiquerType of

-the news message. A news message can contain one or more

-LiquerTypeID's.

-\item \underline{NewsCategoryID}: This is the ID of the NewsCategory of

-the news message. A news message can contain one or more

-NewsCategoryID's.

-\item \underline{pubDate}: This is the date when the news messages

-are written. (If the incoming RSS feeds does not contain a date, then

-the pubDate will be the date on which the news messages is added to

-the site)

-\item \underline{guid}: This is the link of the original news

-messages on the original site.

-\item \underline{title}: This is the title of the news messages.

-\item \underline{intern}: This is the link of the news messages on the site. If this link is followed, the news messages is shown on the site.

-\item \underline{description}: This is the news messages.

+  \item \underline{LiquorTypeID}: This is the ID of the LiquerType of the news message. A news message can contain one or more LiquerTypeID's.

+  \item \underline{NewsCategoryID}: This is the ID of the NewsCategory of the news message. A news message can contain one or more NewsCategoryID's.

+  \item \underline{pubDate}: This is the date when the news messages are written. (If the incoming RSS feeds does not contain a date, then the pubDate will be the date on which the news messages is added to the site)

+  \item \underline{guid}: This is the link of the original news messages on the original site.

+  \item \underline{title}: This is the title of the news messages.

+  \item \underline{intern}: This is the link of the news messages on the site. If this link is followed, the news messages is shown on the site.

+  \item \underline{description}: This is the news messages.

 \end{itemize}

-On figure below the Data tree of the DB XML-file can be seen. For all

-elements in the XML-file there will be only one shown completed. If there

-can be more elements, which are the same as their siblings, they are

-showed dotted (without their descendants).

+

+On figure below the data tree of the database XML-file can be seen. For all elements in the XML-file there will be only one shown completely. If there can be more elements, which are the same as their siblings, they are showed dotted (without their descendants).

 

 \begin {center}

-  \includegraphics[width=\textwidth]{DB.png} \\

-  Data tree of DB.xml

+  \includegraphics[width=160.0mm]{DB.png} \\

+  Fig 4. Data tree of DB.xml

 \end {center}

 

+\subsubsection{rssfeeds.xml}

 

+In this file we will store the RSS binding information for the incoming RSS feed, so the website knows from which RSS the information must be taken from and how it must be stored. Below you can see a part of the XML-file.

 

-

-\subsubsection{rssfeeds.xml}

-In this file we will store the RSS binding information for the incoming

-RSS feed, so the website knows from which rss the information must be taken and how that it must be stored. Below you can see a part of the XML-file.

 \begin{verbatim}

 <IncomingRSSFeedBindings>

   <RSSFeed ID="1">

@@ -159,70 +109,50 @@ RSS feed, so the website knows from which rss the information must be taken and
     <NewsCategoryID>2</NewsCategoryID>

   </RSSFeed>

 

-...

+  ...

 

 </IncomingRSSFeedBindings>

+

 \end{verbatim}

-The following elements are part of the RSS Feed element:

+

+The following elements are part of the RSSFeed element:

+

 \begin{itemize}

-\item \underline{Name}: This is the name of the RSS feed. This is

-used to show the RSS feeds bindings on the site.

-\item \underline{Url}: This is the URL of the RSS feed. From this,

-the website gathers the information.

-\item \underline{LiquorTypeID}: This is the ID for the liquor type,

-which will be bound to all the incoming messages from the RSS feed.

-\item \underline{NewsCategoryID}: This is the ID for the News Category,

-which will be bound to all the incoming messages from the RSS feed.

+  \item \underline{Name}: This is the name of the RSS feed. This is used to show the RSS feeds bindings on the site.

+  \item \underline{Url}: This is the URL of the RSS feed. From this, the website gathers the information.

+  \item \underline{LiquorTypeID}: This is the ID for the liquor type, which will be bound to all the incoming messages from the RSS feed.

+  \item \underline{NewsCategoryID}: This is the ID for the News Category, which will be bound to all the incoming messages from the RSS feed.

 \end{itemize}

 

-On the figure below you will see the Data tree of the DB XML-file. For all

-elements in the XML there will be only one shown completed. If there

-can be more elements, which are the same as their siblings, they are

-shown dotted (without their descendants).

+On the figure below you will see the Data tree of the DB XML-file. For all elements in the XML there will be only one shown completed. If there can be more elements, which are the same as their siblings, they are shown dotted (without their descendants).

 

 \begin {center}

   \includegraphics[width=117.2mm]{rssfeeds.png} \\

-  Data tree of rssfeed.xml

+  Fig 5. Data tree of rss.xml

 \end {center}

 

+\subsection{RSS-Feeds}

 

+To gather information or deliver information the site uses RSS-Feeds. These are standard kinds of XML-files. First we describe the types of RSS feeds the website uses and then how a RSS-feed looks like. \\

 

-

-

-

-

-\subsection{RSS-Feeds}

-To gather information or deliver information the site uses RSS-Feeds.

-This are standard kinds of XML-files. First we describe the types of

-RSS feeds the website uses, then how a RSS-Feed looks like.

-\\\\

 The website uses two types of RSS feeds:

 

+\subsubsection{Incoming RSS-feed}

 

-\subsubsection{Incomming RSS-feed}

-This is the RSS-Feed from which the website takes its information.

-There are several incoming RSS feeds and for each, the website does

-the same procedures to add the information into the database. This is

-done six times a day, by running a PHP script. The following procedures

-will be done for every RSS feed:

-\begin{enumerate}

-\item Take an RSS feed and read the information from it.

-\item Check for every item if the item is already in the

-database. This is done by a title check. More information about this

-can be read in chapter 4. If the item is already in the database continue

-with point 4.

-\item Add the item to the DB.xml and go on with the next item of RSS Feed

-\item The news item is already there, so check if the LiquorTypeID and NewsCategoryID is

-the same. If it is the same, go on with the next item of RSS Feed.

-\item The news item is already there, but it has different LiquorTypeID's or NewsCategoryID's, so add the new LiquorTypeID or NewsCategoryID to the item and go on with the next item of RSS Feed.

+This is the RSS-Feed from which the website takes its information. There are several incoming RSS feeds and for each one the website does the same procedures to add the information into the database. This is done six times a day by running a PHP script. The following procedures will be done for every RSS feed known to Pottepei:

 

+\begin{enumerate}

+  \item Take an RSS feed and read the information from it.

+  \item Check for every item if the item is already in the database. This is done by a title check. More information about this can be read in chapter 4. If the item is already in the database continue with point 4.

+  \item Add the item to the DB.xml and go on with the next item of RSS Feed

+  \item The news item is already there, so check if the LiquorTypeID and NewsCategoryID is the same. If it is the same, go on with the next item of RSS Feed.

+  \item The news item is already there, but it has different LiquorTypeID's or NewsCategoryID's, so add the new LiquorTypeID or NewsCategoryID to the item and go on with the next item of RSS Feed.

 \end{enumerate}

+

 \subsubsection{Outgoing RSS-feed}

-The website also has an outgoing RSS-Feed. In this feed the latest

-twenty news messages from the database will be put into an RSS feed.

-The latest twenty news messages are gained from the DB xml via an XPath Query.

-This information is put via XML php statements into the

-RSS Feed. A part of the XML php statements can be read below.

+

+The website also has an outgoing RSS-Feed. In this feed the latest twenty news messages from the database will be put into an RSS feed. The latest twenty news messages are gained from the DB xml via an XPath Query. This information is put via XML php statements into the RSS Feed. A part of the XML php statements can be read below.

+

 \begin{verbatim}

   // create doctype

   $dom = new DOMDocument("1.0");

@@ -243,31 +173,24 @@ RSS Feed. A part of the XML php statements can be read below.
   $text = $dom->createTextNode("Pottepei RSS feed");

   $title->appendChild($text);

 \end{verbatim}

-This part of the code generates first a XML document with version

-\textit{"1.0"}. Then it creates a root element, in this case called

-\textit{"rss"}. The root gets also the attribute named

-\textit{"version"} with the value \textit{"2.0"}. The statement

-\textit{"\$dom-$>$formatOutput"} makes the output file readable.

-\\After that the code creates a channel element and add it as a child

-of the root element. Then a title element will be created and added to

-the channel element as a child. This title element will contain the

-text \textit{"Pottepei RSS feed"}. This is the way that the whole

-RSS-feed will be build. Below is a part of the XML file which this

-part of the code generates.

+

+This part of the code first generates an XML document with version \textit{"1.0"} and then creates a root element, in this case called \textit{"rss"}. The root gets also an attribute named \textit{"version"} with the value \textit{"2.0"}. The statement \textit{"\$dom-$>$formatOutput"} makes the output file readable. \\

+

+After that the code creates a channel element and add it as a child of the root element. Then a title element will be created and added to the channel element as a child. This title element will contain the text \textit{"Pottepei RSS feed"}. This is the way that the whole RSS-feed will be build. Below is a part of the XML file which this part of the code generates.

+

 \begin{verbatim}

 <?xml version="1.0"?>

   <rss version="2.0">

     <channel>

       <title>Pottepei RSS feed</title>

 \end{verbatim}

+

 This code will be automatically executed every day.

 

+\subsubsection{The construction of an RSS feed}

 

+An RSS feed has a standard constructions. We use the RSS version 2.0. There is much information which you can store in an RSS feed. We use some of those. Below you can see a part of our RSS feed file:

 

-\subsubsection{The construction of a RSS feed}

-An RSS feed has a standard constructions. We use the RSS version 2.0.

-There is much information which you can store in a RSS feed. We use

-some of those. Below you can see a part of our RSS feed file:

 \begin{verbatim}

 <?xml version="1.0"?>

 <rss version="2.0">

@@ -287,41 +210,37 @@ some of those. Below you can see a part of our RSS feed file:
       </description>

     </item>

 

-...

+    ...

 

   </channel>

 </rss>

+

 \end{verbatim}

+

 This file got the following elements:

+

 \begin{itemize}

-\item \underline{rss}: This is the standard element which says that

-the XML file is an RSS feed. The attribute \underline{version} says

-which RSS version the document is.

-\item \underline{channel}: This a standard RSS element

-\item \underline{title}: This is the title of the RSS feed

-\item \underline{link}: This is the link of the website

-\item \underline{description}: This will give a description of the

-RSS feed.

-\item \underline{language}: This will give the language of the RSS

-feed.

-\item \underline{pubDate}: When the RSS feed is published.

-\item \underline{item}: This contains the information of one news

-massage \subitem \underline{pubDate}: The date of the news item

-\subitem \underline{guid}: The link where the news massage can be

-found \subitem \underline{title}: The title of the news massage

- \subitem \underline{description}: The news massage itself.

+  \item \underline{rss}: This is the standard element which says that the XML file is an RSS feed. The attribute \underline{version} says which RSS version the document is.

+  \item \underline{channel}: This a standard RSS element

+  \item \underline{title}: This is the title of the RSS feed

+  \item \underline{link}: This is the link of the website

+  \item \underline{description}: This will give a description of the RSS feed.

+  \item \underline{language}: This will give the language of the RSS feed.

+  \item \underline{pubDate}: When the RSS feed is published.

+  \item \underline{item}: This contains the information of one news massage

+    \subitem \underline{pubDate}: The date of the news item

+    \subitem \underline{guid}: The link where the news massage can be found

+    \subitem \underline{title}: The title of the news massage

+    \subitem \underline{description}: The news massage itself.

 \end{itemize}

 

-These are also the elements we use from the incoming RSS feeds. Note:

-From the initial RSS feeds, the feed from www.cocktailz.nl, does not

-have a pubDate, so we take the day on which the website imports the

-news massage as pubDate.

+These are also the elements we use from the incoming RSS feeds.\\

+ 

+\textbf{Note}: From the initial RSS feeds, the feed from www.cocktailz.nl, does not have a pubDate. In this special case we take the day on which the website imports the news massage as pubDate.

+

+On the figure below you will see the data tree of the RSS-feed XML. For all elements in the XML there will be only one shown completely. If there can be more elements, which are the same as their siblings, they are shown dotted (without their descendants).

 

-On the figure below you will see the Data tree of the RSS-feed XML. For all

-elements in the XML there will be only one shown completed. If there

-can be more elements, which are the same as their siblings, they are

-shown dotted (without their descendants).

 \begin {center}

   \includegraphics[width=\textwidth]{RSS.png} \\

-  Data tree of RSS.xml

+  Fig 6. Data tree of rss.xml

 \end {center}

diff --git a/Report/DB.png b/Report/DB.png
index de1e80d..24f01bc 100644
--- a/Report/DB.png
+++ b/Report/DB.png
diff --git a/Report/toc.tex b/Report/toc.tex
new file mode 100644
index 0000000..f39cb6c
--- /dev/null
+++ b/Report/toc.tex
@@ -0,0 +1 @@
+\tableofcontents