My db-class.org notes - Revision history

Paul: /* Relational Algebra */

2011-10-23T15:40:32Z

Relational Algebra

← Older revision		Revision as of 10:40, 23 October 2011
Line 29:		Line 29:
	== Relational Algebra ==		== Relational Algebra ==

	[http://en.wikipedia.org/wiki/Relational_algebra Relational algebra] on ~~wikipedia~~		[http://en.wikipedia.org/wiki/Relational_algebra Relational algebra] on Wikipedia

			A commercially failed relational algebra database called [http://en.wikipedia.org/wiki/Business_System_12 Business System 12] on Wikipedia

			[http://en.wikipedia.org/wiki/Rel_%28DBMS%29 Rel] an open source relational database management system primarily used in teaching.

			[http://db.grussell.org/section010.html Relational Algebra] portion of a [http://db.grussell.org/index.html database eLearning site].

	== Other Useful links ==		== Other Useful links ==

2011-10-23T03:26:13Z

← Older revision		Revision as of 22:26, 22 October 2011
Line 26:		Line 26:

	[http://www.w3.org/TR/xmlschema-0/ XML Schemas]		[http://www.w3.org/TR/xmlschema-0/ XML Schemas]

			== Relational Algebra ==

			[http://en.wikipedia.org/wiki/Relational_algebra Relational algebra] on wikipedia

2011-10-18T20:21:45Z

2011-10-07T20:19:11Z

Kernow

← Older revision		Revision as of 15:19, 7 October 2011
Line 33:		Line 33:
	Optional, remove .zip file by using <code>rm -f "Kernow 1.7.2.zip"</code> command.		Optional, remove .zip file by using <code>rm -f "Kernow 1.7.2.zip"</code> command.

	Launch Kernow		'''Launch Kernow'''

	Navigate to directory where Kernow is located (or create symbolic link and use symbolic link). This command will launch a Kernow java window.		Navigate to directory where Kernow is located (or create symbolic link and use symbolic link). This command will launch a Kernow java window.

2011-10-07T20:14:42Z

MySQL

← Older revision		Revision as of 15:14, 7 October 2011
Line 70:		Line 70:
	Complete!</pre>		Complete!</pre>

	'''Enable MySQL at specific run levels (I did 3 & 5~~)'''~~		'''Enable MySQL at specific run levels'''

			Note: I did 3 & 5
	<pre>[ptay@robot logs]$ sudo chkconfig --level 35 mysqld on		<pre>[ptay@robot logs]$ sudo chkconfig --level 35 mysqld on
	[ptay@robot logs]$ chkconfig --list \| grep -i mysqld		[ptay@robot logs]$ chkconfig --list \| grep -i mysqld
Line 76:		Line 78:

	'''Start MySQL daemon (mysqld)'''		'''Start MySQL daemon (mysqld)'''

	As root		As root
	<pre>		<pre>
Line 88:		Line 91:

	'''Run MySQL secure installation script'''		'''Run MySQL secure installation script'''

	As root		As root
	<pre>[root@robot ~]# /usr/bin/mysql_secure_installation		<pre>[root@robot ~]# /usr/bin/mysql_secure_installation
Line 106:		Line 110:

	'''Test MySQL'''		'''Test MySQL'''

	As any user		As any user
	<pre>[root@robot ~]# mysql -u root -p		<pre>[root@robot ~]# mysql -u root -p

2011-10-07T20:13:01Z

xmllint

← Older revision		Revision as of 15:13, 7 October 2011
Line 12:		Line 12:
	<pre>[ptay@robot logs]$ xmllint --version		<pre>[ptay@robot logs]$ xmllint --version
	xmllint: using libxml version 20707		xmllint: using libxml version 20707
	compiled with: Threads Tree Output Push Reader Patterns Writer SAXv1 FTP HTTP DTDValid HTML Legacy C14N Catalog XPath XPointer XInclude Iconv ISO8859X Unicode Regexps Automata Expr Schemas Schematron Modules Debug Zlib		compiled with: Threads Tree Output Push Reader Patterns Writer SAXv1 FTP HTTP DTDValid HTML Legacy
			C14N Catalog XPath XPointer XInclude Iconv ISO8859X Unicode Regexps Automata Expr Schemas Schematron
			Modules Debug Zlib
	[ptay@robot logs]$</pre>		[ptay@robot logs]$</pre>

2011-10-07T20:12:38Z

Kernow

@@ Line 23: / Line 23: @@
 <pre>[ptay@robot Downloads]$ unzip "Kernow 1.7.2.zip"
 Archive:  Kernow 1.7.2.zip
-    creating: Kernow 1.7.2/
+    creating: Kernow 1.7.2
-   creating: Kernow 1.7.2/ant/
-  inflating: Kernow 1.7.2/ant/kernow_sample_buildfile.xml
+    //////////////omitting text/////////////////////
-   creating: Kernow 1.7.2/cache/
    inflating: Kernow 1.7.2/readme.txt</pre>

2011-10-07T20:11:56Z

Kernow

← Older revision		Revision as of 15:11, 7 October 2011
Line 18:		Line 18:

	'''Download Kernow'''		'''Download Kernow'''
	<pre>[ptay@robot Kernow]$ wget http://~~downloads.~~sourceforge.net/~~project~~/kernowforsaxon/Kernow/Kernow%201.7.2/Kernow%201.7.2.zip?~~r=http%3A%2F%2Fsourceforge.net%2Fprojects%2Fkernowforsaxon%2F&ts=1318016634&~~use_mirror=iweb</pre>		<pre>[ptay@robot Kernow]$ wget http://sourceforge.net/projects/kernowforsaxon/files/Kernow/Kernow%201.7.2/Kernow%201.7.2.zip/download?use_mirror=iweb</pre>

	'''Unzip Kernow file'''		'''Unzip Kernow file'''

2011-10-07T20:10:19Z

MySQL

@@ Line 81: / Line 81: @@
 <pre>[ptay@robot logs]$ sudo yum groupinstall "MySQL Database"
 [sudo] password for ptay:
-Dependencies Resolved
+//////////////omitting text/////////////////////
 Installed:

2011-10-07T20:09:22Z