Database topic map - Revision history

Akivela at 19:28, 12 July 2012

2012-07-12T19:28:23Z

Akivela: /* See also */

2009-10-30T10:25:52Z

‎See also

Akivela at 07:18, 21 May 2009

2009-05-21T07:18:40Z

Akivela: /* Exporting topic map as SQL */

2008-10-30T17:04:51Z

‎Exporting topic map as SQL

Akivela: /* Restoring database topic map */

2008-10-30T17:04:35Z

‎Restoring database topic map

Olli: /* Initializing database tables for the topic map */

2008-09-11T08:03:24Z

‎Initializing database tables for the topic map

Akivela at 16:55, 28 August 2008

2008-08-28T16:55:36Z

Akivela: /* Restoring database topic map */

2008-07-26T12:10:49Z

‎Restoring database topic map

Akivela: /* Initializing database tables for the topic map */

2008-07-26T12:06:37Z

‎Initializing database tables for the topic map

Akivela: /* Initializing database tables for the topic map */

2008-07-26T12:06:17Z

‎Initializing database tables for the topic map

@@ Line 4: / Line 4: @@
 * Usually database topic map initialization requires some external actions to be taken in order to configure the database for Wandora.
 * Database topic map can be managed with database's own tools.
-* Database may locate in network computer. This means that Wandora uses a network connection (JDBC) to connect the database.
+* Database may locate in a network computer. This means that Wandora uses a network connection (JDBC) to connect the database.
 * Multiple users may use same database topic map simultaneusly. Wandora's database topic map implementation is '''not''' thread safe. You will encounter problems sooner or later if you allow multiple users to edit database topic map simultaneusly. However, database topic map can be successfully '''read''' by multiple users without problems.
 * Database topic map is substantially slower than memory topic map. If database is not local but somewhere on the net, expect the database topic map to be even slower.

@@ Line 90: / Line 90: @@
 * [[Linked topic map]]
 * [[Query topic map]]
-* [[Remote topic map]]
+<!-- * [[Remote topic map]] -->

← Older revision		Revision as of 07:18, 21 May 2009
Line 1:		Line 1:
−	If memory stored topic map turns out to be insufficient for your topic map, due to a topic map size for example, you can use Wandora's database topic map implementation. Database topic map stores all data into an SQL database enabling essentially unlimited topic map sizes. However, using database storage option has implicit consequences	+	If memory stored topic map turns out to be insufficient for your topic map, due to topic map size for example, you can use Wandora's database topic map implementation. Database topic map stores all data into an SQL database enabling essentially unlimited topic map sizes. However, using database storage option has implicit consequences

	* Database topic map exists usually between Wandora use sessions and Wandora only connects to the database using provided username and password. Depending on the provided use rights the user may have only '''read''' rights to the database topic map.		* Database topic map exists usually between Wandora use sessions and Wandora only connects to the database using provided username and password. Depending on the provided use rights the user may have only '''read''' rights to the database topic map.

← Older revision		Revision as of 17:04, 30 October 2008
Line 77:		Line 77:

	Wandora has a special export feature used to convert topic maps directly to SQL clauses suitable for Wandora's database topic map model. This feature can speed up the database topic map creation time significantly. See [[SQL Dump Export]] for more details about exporting any topic map to SQL clauses.		Wandora has a special export feature used to convert topic maps directly to SQL clauses suitable for Wandora's database topic map model. This feature can speed up the database topic map creation time significantly. See [[SQL Dump Export]] for more details about exporting any topic map to SQL clauses.
−

	== Restoring database topic map ==		== Restoring database topic map ==

← Older revision		Revision as of 17:04, 30 October 2008
Line 73:		Line 73:

	[[Image:Database.gif\|center]]		[[Image:Database.gif\|center]]
		+
		+	== Exporting topic map as SQL ==
		+
		+	Wandora has a special export feature used to convert topic maps directly to SQL clauses suitable for Wandora's database topic map model. This feature can speed up the database topic map creation time significantly. See [[SQL Dump Export]] for more details about exporting any topic map to SQL clauses.
		+

	== Restoring database topic map ==		== Restoring database topic map ==

@@ Line 51: / Line 51: @@
 == Initializing database tables for the topic map ==
-Database connection can be established to an existing or a new database. If you are configuring fresh database you probably want to create tables for the database. Wandora does not contain tool to create fresh database. You have to use database's native tools. SQL files to create database locate in '''conf/database''' folder. There is separate creation file for '''MySQL''', '''Microsoft SQL Server''', '''HSQL''', and generic SQL database. Detailed database initialization steps are beyond the scope of this chapter but in case of MySQL the steps are
+Database connection can be established to an existing or a new database. If you are configuring fresh database you probably want to create tables for the database. Wandora does not contain tool to create fresh database. You have to use database's native tools. SQL files to create database are located in '''resources/conf/database''' folder. There are separate creation files for '''MySQL''', '''Microsoft SQL Server''', '''HSQL''', and generic SQL database. Detailed database initialization steps are beyond the scope of this chapter but in case of MySQL the steps are
 Log in the MySQL server with
@@ Line 69: / Line 69: @@
    grant all on mytopicmap.* to "username"@"%" identified by "password";
-And the database is ready to be used as a layer in Wandora. Wandora database contains 8 different database tables.  Below is an illustration of database structure. Image is also available in EPS and DIA formats within the Wandora application package and '''conf/database''' folder.
+And the database is ready to be used as a layer in Wandora. Wandora database contains 8 different database tables.  Below is an illustration of database structure. Image is also available in EPS and DIA formats within the Wandora application package in '''resources/conf/database''' folder.

← Older revision		Revision as of 16:55, 28 August 2008
Line 1:		Line 1:
−	If memory stored topic map turns out to be insufficient for your topic map, due to a topic map size for example, you can use Wandora's database topic map implementation. Database topic map stores all data into an SQL database enabling essentially unlimited topic map sizes. However, database storage option has implicit consequences	+	If memory stored topic map turns out to be insufficient for your topic map, due to a topic map size for example, you can use Wandora's database topic map implementation. Database topic map stores all data into an SQL database enabling essentially unlimited topic map sizes. However, using database storage option has implicit consequences

	* Database topic map exists usually between Wandora use sessions and Wandora only connects to the database using provided username and password. Depending on the provided use rights the user may have only '''read''' rights to the database topic map.		* Database topic map exists usually between Wandora use sessions and Wandora only connects to the database using provided username and password. Depending on the provided use rights the user may have only '''read''' rights to the database topic map.

← Older revision		Revision as of 12:10, 26 July 2008
Line 79:		Line 79:

	Note also that Wandora features '''Database extractor''' tool used to transform any SQL database into a topic map. Do not mix up '''SQL topic map import...''' and '''Database extractor'''. First is used to restore Wandora topic map database dumps as the latter is used to transform SQL databases to topic maps.		Note also that Wandora features '''Database extractor''' tool used to transform any SQL database into a topic map. Do not mix up '''SQL topic map import...''' and '''Database extractor'''. First is used to restore Wandora topic map database dumps as the latter is used to transform SQL databases to topic maps.
		+
		+	== See also ==
		+
		+	* [[Layered topic map]]
		+	* [[Memory topic map]]
		+	* [[Linked topic map]]
		+	* [[Query topic map]]
		+	* [[Remote topic map]]