Tech Review: Thursday, November 10, 2011

• 
  

http://en.wikipedia.org/wiki/Hibernate_(Java)

• an object-relational mapping (ORM) library for Java
• provides a object-oriented domain model mapping to a traditional relational database
• free GNU software
• http://en.wikipedia.org/wiki/NHibernate
• NHibernate for MS .NET

http://www.javaworld.com/javaworld/jw-10-2004/jw-1018-hibernate.html

• example program in Java

http://en.wikipedia.org/wiki/Red_Hat_Linux

• Red Hat Linux
• Discontinued in 2004

http://en.wikipedia.org/wiki/Red_Hat_Enterprise_Linux

• Read Hat Enterprise Linux (RHEL)
• Advance Platform (AS)
• Red Hat Enterprise Linux 3 (Taroon) Update 9, 2007
• outside of regular life cycle
• 2013-10-31 (End of Extended Life Cycle
• Red Hat Enterprise Linux 6 
• 2010-11-10
• 2017-11-30 (End of Regular Life Cycle)

Tech Review: Wednesday, November 2, 2011

https://www.google.com/search?q=deleting+an+object+in+java&hl=en&prmd=imvnsfd&source=lnms&tbm=isch&ei=xkexTuP-NM6utwfblfCoAg&sa=X&oi=mode_link&ct=mode&cd=2&ved=0CAkQ_AUoAQ&biw=1008&bih=724&sei=%20Q0ixTtq-OM-3twfYgdmMAg

• An implied way to delete object in Java
• set the object to null

http://www.javaworld.com/javaworld/javaqa/1999-08/01-qa-static2.html

• Two types of classes
• Top-level class
• cannot be declared static
• static class means top level class?
• Inner classes
• 4 types
• Anonymous
• special syntax with no name
• local
• created within a block
• Member class
• created within a class
• Nested top-level
• member class
• static modifier

http://www.postgresql.org

There is no "USE" close like in SQL.  From the pgAdmin Query Tool, you need to select the connection for the data base in the top middle of the Query Tool.

Grid Security Infrastructure (GSI)

http://www.globus.org/security/overview.html

public key cryptography

asymetric cryptography

DVN - DataVerse Network

From the iRODS workshop slides.

Deep Archive - ?

Seems to be related to compression or with age.

http://www.nytimes.com/2006/09/06/technology/06iht-google.2714045.html?_r=1

It could also be related to not being able to be cataloged with web spiders.

SHAMON - Sustaining Heritage Access Through Multivalent Archiving

http://ercim-news.ercim.eu/en80/special/shaman

This took a little work to find.  A search of SHAMAN get lost in all the WOW (World of Warcraft) results.

http://www.slideshare.net/DigitalPreservationEurope/shaman-project-hemmje-presentation

Slide show.

http://portal.acm.org/citation.cfm?id=1643899&dl=ACM&coll=DL&CFID=113636349&CFTOKEN=50532023

ACM article.

A digital archive preservation environment.

Kepler - an API for analyzing and modeling scientific data

https://kepler-project.org/users/faq

Supported by iRODS.

Data Base Design

This looks like a good general article on database design: http://www.databasejournal.com/features/mssql/article.php/

There is also an article in using stored procedures with error reporting: http://rwgarrison.com/rg/Writing/ErrorCheckingPart1.htm

This used in debugging.

This can be used in testing: http://www.tsqltest.org/

It is a simple, lightweight testing framework for Microsoft SQL Server. It is a free application.

This is a set of SQL procedure standards: http://rwgarrison.com/rg/DevStds/

All of the above articles where done by Rob Garrison.

OLE DB

OLE DB - Object Linking and Embedding, Database - an API designed by Microsoft for accessing different types of data stores in a uniform manner. (See http://en.wikipedia.org/wiki/OLE_DB)

ADO - ActiveX Data Object

ADO - ActiveX Data Object - a set of Component Object Model (COM) objects for accessing data sources. Provides a layer between programming languages and OLE DB. (See http://en.wikipedia.org/wiki/ActiveX_Data_Objects)

ODBC

ODBC - Open Database Connectivity - provides a standard software API method for using database management systems (DBMS). (See http://en.wikipedia.org/wiki/Open_Database_Connectivity)

Good General Database Link

Database General

A good site: http://www.dbazine.com

SQL Server File Extension (*.MDF)

The file extension for a SQL Server file is *.MDF.

DB Code Like Normal Code

Something could be done either within the DTS stuff or within the database.

Might be hard to see where something is being done.

General SQL 2000 Site

This site looks pretty good and has some nice detail:

http://www.functionx.com/sqlserver/

Data Transformation Services (SQL 2000)

This is a neat site that talks about the data transformation services (DTS):




http://www.sqldts.com/


This is also a nice tutorial:




One lone link. Click on picture :-)





In SQL 2005 DTS has becomes SQL Server Integrated Services (SSIS):




http://www.sqlis.com/

SQL Server Tutorial

This tutorial is found here: http://www.functionx.com/sqlserver/Lesson01.htm

Your start and stop the server using the SQL Server Service Manager. This is installed on my current machine.

Introduction

Can open database from Query Analyzer or Enterprise Manager.

SQL

SQL Server 'highly adheres' to the SQL standard. However, there are internal detail that may not apply to other databases.

the SQL command are run internally through an interpreter.

SQL is not case sensitive. It is tradition to write all SQL key words in uppercase.

What are the different way to bring up a SQL Query Analyzer?

1. From the start menu.
2. You can also get to from inside the Enterprise Manager

The issue of the semicolon seems to be a problem. It is not really used.

SQL Server uses the 'GO' statement for a set of statements to be processed.

Can easily create a database from SQL Analyzer using:

CREATE databasename;

I think I should use semicolons so that the SQL code is more portable.

Using SQL Analyzer for a simple query is quick and probably not as prone to crashing.

Collation Name - a collation is bit patterns that represent each character and rules by which the characters are sorted and compared.

When a SQL Server database is created it creates 20 tables that define things about the database.

The post fix for a SQL Server database file is 'MDF'.

The 'Compatibility Level' is the version of SQL Server under which the database was created. Database created in SLQ Server 2000 are 80. This value seem to correspond one-to-one with the version, version 8.0 is 80, and version 6.5 is 65, etc.

'GO' is a set SQL Server statements indicates the end of a batch of Transact-SQL statments. It is a utility command that requires no permissions so it can be executed by any user.

The 'USE' statement will change the database in the SQL Analyzer Query window.

Is DECLARE an SQL statement or just a Transact-SQL statement?

The SQL Server GUI in SQL Server Enterprise Manager has many similarities with ACCESS.

SQL Server has a whole bunch of store procedures:

sp_help
sp_rename
sp_who

SQL Server

The following is my notes from the tutorial found here:

http://www.functionx.com/sqlserver/Lesson01.htm

I have also gleaned some information from the wikipedia:

http://en.wikipedia.org/wiki/Microsoft_SQL_Server

The current version of SQL Server is "SQL Server 2005" and it version is 9.0 and its codename is Yukon.

Extract, transform, load (ETL): http://en.wikipedia.org/wiki/Extract%2C_transform%2C_load

Is one of the features added to SQL Server since 2000.

The next release is code named Katmai.

It look like the MicroSoft may have some interesting things coming up like: WinFS, SQL Server capabilities being integrated directly into Windows itself.

Window Future Storage (WinFS) - http://en.wikipedia.org/wiki/WinFS

Details of the Relational Algebra

Access's Query Design mode provides a graphical environment to create and edit queries.

Table schemes are added in the upper portion of the Query Design window.

The design grid is in the lower part of the window.

Access takes care of forming the appropriate join based on the relationship information shown in the upper portion of the window.

Access SQL is more powerful than the Access Query Design interface.

Query Languages and the Relational Algebra

Access SQL is a special form of standard SQL.

Query Languages

query - a request of the database, the response to which is a result table.

Queries permit me to extract the data from the database in meaningful forms.

Query languages can be based on algebraic expression or logical expressions.

base table - a table whose data are actually stored in the database.

view - a query expression that has been given a name, and is stored in the database. The expression is the view and not the result table.

virtual table - a view because it is an expression that results in a table.

Relational Algebra and Relational Calculus

relational algebra - the most common algebraic query language.

procedural - the expression describe an explicit procedure for returning the results. Relational algebra is a procedural language.

relational calculus - uses logic.

nonprocedural - expressions represent statements that describe conditions that must be met for a row to be in the result. Example is relational calculus.

Plan English:

Get the names and phone numbers for publishers who publish books costing under $20.00.

Relational Algebra:

projPubName,PubPhone(selPrice<20.00(BOOKS join PUBLISHERS))

Relational Calculus:

{(x,y) | PUBLISHERS(z,x,y) and BOOKS(a,b,z,c) and c < $20.00}