Table update operations

From semantic-mediawiki.org
Jump to: navigation, search

When installing or updating Semantic MediaWiki, an administrator will see an activity report detailing related database schema and table operations.

Schema validation

The database schema is validated and checked against the requirements defined in TableSchemaManager and if necessary, the TableBuilder will initiate a change of related fields or indices.

Selected storage engine is "SMWSQLStore3" (or an extension thereof)

Setting up standard database configuration for SMW ...

Checking table smw_object_ids ...
   Table already exists, checking structure ...
   ... field smw_id is fine.
   ... field smw_namespace is fine.
   ... field smw_title is fine.
   ... field smw_iw is fine.
   ... field smw_subobject is fine.
   ... field smw_sortkey is fine.
   ... field smw_sort is fine.
   ... field smw_proptable_hash is fine.
   ... done.
Checking index structures for table smw_object_ids ...
   ... index smw_id is fine.
   ... index smw_id,smw_sortkey is fine.
   ... index smw_iw is fine.
   ... index smw_iw,smw_id is fine.
   ... index smw_title,smw_namespace,smw_iw,smw_subobject is fine.
   ... index smw_sortkey is fine.
   ... index smw_id,smw_sort is fine.
   ... index smw_sort,smw_id,smw_iw is fine.
   ... removing index smw_namespace,smw_sortkey,smw_iw ...done.
   ... done.

Table optimization

The optimization step was added1 to allow for individual wp:RDBMS back-ends to carry out table specific optimization that can improve the execution plan of queries.

Database initialized completed.

Running table optimization.
   Table smw_object_ids ...
   ... analyze, optimize done.
   Table smw_concept_cache ...
   ... analyze, optimize done.
   Table smw_query_links ...
   ... analyze, optimize done.
   Table smw_ft_search ...

The runtime of the optimization depends on the size of existing tables and the RDBMS system used.

Import

The automatic import2 of data structures is executed after the standard tasks has been completed to deploy information during the installation process before any user interaction takes place.

Optimization completed.

Import of vocabulary.json ...
   ... skipping MediaWiki:Smw import skos, already exists ...
   ... skipping MediaWiki:Smw import foaf, already exists ...
   ... skipping MediaWiki:Smw import owl, already exists ...
   ... skipping Property:Foaf:knows, already exists ...
   ... skipping Property:Foaf:name, already exists ...
   ... skipping Property:Foaf:homepage, already exists ...
   ... skipping Property:Owl:differentFrom, already exists ...
   ... done.

Import processing completed.

See also


References

  1. ^  Semantic MediaWiki: GitHub pull request gh:smw:2516
  2. ^  Semantic MediaWiki: GitHub pull request #2289