DAP Relational Database Server II - Revision history

Ndp: Removing all content from page

2009-04-27T22:45:54Z

Removing all content from page

← Older revision		Revision as of 22:45, 27 April 2009
Line 1:		Line 1:
	In order to provide support for a [http://www.opengeospatial.org/standards/sos Sensor Observation Service (SOS)] implementation Hyrax will need a handler that allows it to access data in a Relational Database Management System (RDBMS). (This requirement stems from the observation that many of our stake holders store their in situ measurement data in RDBMSs)

	~~It is anticipated RDBMS handler will have a much broader application than just SOS related data sets.~~


	~~== Use Cases ==~~
	~~# [[Add the RDH handler to the BES]]~~
	~~# [[Configure DRDS-II to use ODBC introspection to build catalog of database holdings]]~~
	~~# [[Configure DRDS-II to use a local configuration to build catalog of database holdings]]~~

	~~== Definitions ==~~

	~~; row set~~
	: A ''row set'' is an object which encapsulates a set of [http://en.wikipedia.org/wiki/Row_(database) rows]. [http://en.wikipedia.org/wiki/Database_table Database tables] are ''row sets''. A database ''[http://en.wikipedia.org/wiki/View_(database) view]'' is a ''row set''. [http://en.wikipedia.org/wiki/SQL_query SQL queries] return ''row sets''. [http://en.wikipedia.org/wiki/Join_(SQL) SQL JOIN] operations take ''row sets'' as input and produce ''row sets''.

	~~== Background ==~~

	In the past a Java servlet called the DODS Relational Database Server (DRDS) was used to provide DAP access to RDBMS holdings. However this older implementation has a number of shortcomings that preclude it's direct use in our current server architecture:
	* No longer supported.
	* Uses the Java DAP implementation
	* Not a BES module
	* Significant memory limitations
	* Difficult to configure/localize


	~~==== Data Model Resolution ====~~

	~~The DAP data type Sequence is the natural structural/behavioral synonym to a ''row set''. The collection of tables and views in an RDBMS can thus be represented as a collection of DAP Sequences.~~

	~~== Design ==~~

	Current design is that we not matter the internal structure of the database the operator will create a view (or use existing tables) and the DRDS-1II will query against that view to produce a row set that will be served as a Sequence.

	~~=== Data model ===~~

	The DDX/DDS/DAS documents will be generated by introspection of the database. We may wish to use a configuration mechanism to identify which table and/or views that are meant to be served, or to instruct the server to serve all of the tables and/or views that it can discover using introspection.

	~~== Deliverables ==~~


	~~== Period of use ==~~

Ndp: /* Use Cases */

2009-04-27T22:45:26Z

Use Cases

← Older revision		Revision as of 22:45, 27 April 2009
Line 5:		Line 5:

	== Use Cases ==		== Use Cases ==
	# [[Add the ~~DRDS-II~~ handler to the BES]]		# [[Add the RDH handler to the BES]]
	# [[Configure DRDS-II to use ODBC introspection to build catalog of database holdings]]		# [[Configure DRDS-II to use ODBC introspection to build catalog of database holdings]]
	# [[Configure DRDS-II to use a local configuration to build catalog of database holdings]]		# [[Configure DRDS-II to use a local configuration to build catalog of database holdings]]


	== Definitions ==		== Definitions ==

Ndp: /* Data Model Resolution */

2009-04-27T21:41:29Z

Data Model Resolution

← Older revision		Revision as of 21:41, 27 April 2009
Line 25:		Line 25:


	=== Data Model Resolution ===		==== Data Model Resolution ====

	The DAP data type Sequence is the natural structural/behavioral synonym to a ''row set''. The collection of tables and views in an RDBMS can thus be represented as a collection of DAP Sequences.		The DAP data type Sequence is the natural structural/behavioral synonym to a ''row set''. The collection of tables and views in an RDBMS can thus be represented as a collection of DAP Sequences.

Ndp: /* Data Model Resolution */

2009-04-27T21:41:10Z

Data Model Resolution

← Older revision		Revision as of 21:41, 27 April 2009
Line 27:		Line 27:
	=== Data Model Resolution ===		=== Data Model Resolution ===

	The DAP data type Sequence is the natural structural/behavioral synonym to a ''row set''		The DAP data type Sequence is the natural structural/behavioral synonym to a ''row set''. The collection of tables and views in an RDBMS can thus be represented as a collection of DAP Sequences.

	== Design ==		== Design ==

Ndp: /* Background */

2009-04-27T21:39:30Z

Background

← Older revision		Revision as of 21:39, 27 April 2009
Line 25:		Line 25:


			=== Data Model Resolution ===

			The DAP data type Sequence is the natural structural/behavioral synonym to a ''row set''

	== Design ==		== Design ==

Ndp: /* Design */

2009-04-27T21:37:31Z

Design

← Older revision		Revision as of 21:37, 27 April 2009
Line 29:		Line 29:

	Current design is that we not matter the internal structure of the database the operator will create a view (or use existing tables) and the DRDS-1II will query against that view to produce a row set that will be served as a Sequence.		Current design is that we not matter the internal structure of the database the operator will create a view (or use existing tables) and the DRDS-1II will query against that view to produce a row set that will be served as a Sequence.

			=== Data model ===

	The DDX/DDS/DAS documents will be generated by introspection of the database. We may wish to use a configuration mechanism to identify which table and/or views that are meant to be served, or to instruct the server to serve all of the tables and/or views that it can discover using introspection.		The DDX/DDS/DAS documents will be generated by introspection of the database. We may wish to use a configuration mechanism to identify which table and/or views that are meant to be served, or to instruct the server to serve all of the tables and/or views that it can discover using introspection.

Ndp: /* Definitions */

2009-04-27T21:22:31Z

Definitions

← Older revision		Revision as of 21:22, 27 April 2009
Line 13:		Line 13:

	; row set		; row set
	: A ''row set'' is an object which encapsulates a set of [http://en.wikipedia.org/wiki/Row_(database) rows]. [http://en.wikipedia.org/wiki/Database_table Database tables] are ''row sets''. A database ''[http://en.wikipedia.org/wiki/View_(database) view]'' is a ''row set''. [http://en.wikipedia.org/wiki/SQL_query SQL queries] return ''row sets''. [http://en.wikipedia.org/wiki/Join_(SQL) SQL JOIN] operations take ''row sets'' as input and produce ''row sets''. ~~See also: http://en.wikipedia.org/wiki/Result_set~~		: A ''row set'' is an object which encapsulates a set of [http://en.wikipedia.org/wiki/Row_(database) rows]. [http://en.wikipedia.org/wiki/Database_table Database tables] are ''row sets''. A database ''[http://en.wikipedia.org/wiki/View_(database) view]'' is a ''row set''. [http://en.wikipedia.org/wiki/SQL_query SQL queries] return ''row sets''. [http://en.wikipedia.org/wiki/Join_(SQL) SQL JOIN] operations take ''row sets'' as input and produce ''row sets''.

	== Background ==		== Background ==

Ndp: /* Definitions */

2009-04-27T21:22:07Z

Definitions

← Older revision		Revision as of 21:22, 27 April 2009
Line 13:		Line 13:

	; row set		; row set
	: A ''row set'' is an object which encapsulates a set of [http://en.wikipedia.org/wiki/Row_(database) rows]. [http://en.wikipedia.org/wiki/Database_table Database tables] are ''row sets''. A database ''[http://en.wikipedia.org/wiki/View_(database) view]'' is a ''row set''. [http://en.wikipedia.org/wiki/SQL_query SQL queries] return ''row sets''. [http://en.wikipedia.org/wiki/Join_(SQL) SQL JOIN] operations take ''row sets'' as input and produce ''row sets''.		: A ''row set'' is an object which encapsulates a set of [http://en.wikipedia.org/wiki/Row_(database) rows]. [http://en.wikipedia.org/wiki/Database_table Database tables] are ''row sets''. A database ''[http://en.wikipedia.org/wiki/View_(database) view]'' is a ''row set''. [http://en.wikipedia.org/wiki/SQL_query SQL queries] return ''row sets''. [http://en.wikipedia.org/wiki/Join_(SQL) SQL JOIN] operations take ''row sets'' as input and produce ''row sets''. See also: http://en.wikipedia.org/wiki/Result_set

	== Background ==		== Background ==

Ndp: /* Definitions */

2009-04-27T21:21:06Z

Definitions

← Older revision		Revision as of 21:21, 27 April 2009
Line 13:		Line 13:

	; row set		; row set
	: A ''row set'' is an object which encapsulates a set of rows. [http://en.wikipedia.org/wiki/Database_table Database tables] are ''row sets''. A database ''[http://en.wikipedia.org/wiki/View_(database) view]'' is a ''row set''. [http://en.wikipedia.org/wiki/SQL_query SQL queries] return ''row sets''. [http://en.wikipedia.org/wiki/Join_(SQL) SQL JOIN] operations take ''row sets'' as input and produce ''row sets''.		: A ''row set'' is an object which encapsulates a set of [http://en.wikipedia.org/wiki/Row_(database) rows]. [http://en.wikipedia.org/wiki/Database_table Database tables] are ''row sets''. A database ''[http://en.wikipedia.org/wiki/View_(database) view]'' is a ''row set''. [http://en.wikipedia.org/wiki/SQL_query SQL queries] return ''row sets''. [http://en.wikipedia.org/wiki/Join_(SQL) SQL JOIN] operations take ''row sets'' as input and produce ''row sets''.

	== Background ==		== Background ==

Ndp: /* Definitions */

2009-04-27T21:20:33Z

Definitions

← Older revision		Revision as of 21:20, 27 April 2009
Line 13:		Line 13:

	; row set		; row set
	: A ''row set'' is an object which encapsulates a set of rows. Database tables are ''row sets''. A database ''view'' is a ''row set''. SQL queries return ''row sets''. SQL JOIN operations take ''row sets'' as input and produce ''row sets''.		: A ''row set'' is an object which encapsulates a set of rows. [http://en.wikipedia.org/wiki/Database_table Database tables] are ''row sets''. A database ''[http://en.wikipedia.org/wiki/View_(database) view]'' is a ''row set''. [http://en.wikipedia.org/wiki/SQL_query SQL queries] return ''row sets''. [http://en.wikipedia.org/wiki/Join_(SQL) SQL JOIN] operations take ''row sets'' as input and produce ''row sets''.

	== Background ==		== Background ==