Difference between revisions of "Creating Indices at the VO Level"
From Gcube Wiki
(→Creating a Full Text and a Forward Index for a collection with two views) |
(→Creating a Full Text and a Forward Index for a collection with two views) |
||
| Line 494: | Line 494: | ||
Then we will create the generic resources for the Forward Index. We will present a simple case here and we will use only the ES payload to create the Forward Rowsets. The following Rowset XSLT extracts the "title" and "creator" fields from the ES payload: | Then we will create the generic resources for the Forward Index. We will present a simple case here and we will use only the ES payload to create the Forward Rowsets. The following Rowset XSLT extracts the "title" and "creator" fields from the ES payload: | ||
| + | |||
| + | Name := BrokerXSLT_es_anylanguage_to_fwRowset_anylanguage_title_creator | ||
| + | |||
| + | SecondaryType := MetadataBrokerXSLT | ||
| + | |||
| + | Description := XSLT to transform from es schema to forward rowset schema including the 'title' and 'creator' fields (suitable for feeding the forward index). | ||
| + | |||
| + | Body := | ||
<source lang="xml"> | <source lang="xml"> | ||
| − | + | <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
<xsl:output xmlns:xsl="http://www.w3.org/1999/XSL/Transform" indent="yes" method="xml" omit-xml-declaration="yes" /> | <xsl:output xmlns:xsl="http://www.w3.org/1999/XSL/Transform" indent="yes" method="xml" omit-xml-declaration="yes" /> | ||
| Line 591: | Line 577: | ||
</xsl:stylesheet> | </xsl:stylesheet> | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
</source> | </source> | ||
In this example "title" and "creator" will have string values, so we just need to create a generic resource for string-string key-value pairs: | In this example "title" and "creator" will have string values, so we just need to create a generic resource for string-string key-value pairs: | ||
| + | Name := IndexType_fwd_string_string | ||
| + | |||
| + | SecondaryType := ForwardIndexType | ||
| + | |||
| + | Description := Definition of the index type 'string_string' for the forward index | ||
| + | |||
| + | Body := | ||
<source lang="xml"> | <source lang="xml"> | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<field-list> | <field-list> | ||
| Line 644: | Line 609: | ||
</field-list> | </field-list> | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
</source> | </source> | ||
In case we had a field that would have a single date value in the format 'yyyy-MM-dd' for each document, we would also have to create a generic resource for a string-date key-value pair like the following one: | In case we had a field that would have a single date value in the format 'yyyy-MM-dd' for each document, we would also have to create a generic resource for a string-date key-value pair like the following one: | ||
| + | Name := IndexType_fwd_esDate_string | ||
| + | |||
| + | SecondaryType := ForwardIndexType | ||
| + | |||
| + | Description := Definition of the index type 'date_string' for the forward index (suitable for es schema indexing) | ||
| + | |||
| + | Body := | ||
<source lang="xml"> | <source lang="xml"> | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<field-list> | <field-list> | ||
| Line 698: | Line 642: | ||
</field-list> | </field-list> | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
</source> | </source> | ||
Revision as of 18:32, 11 November 2011
Indexing Procedure
The Indexing procedure refers to the creation of indices for the collections imported in a Virtual Organization. It consists of three steps:
- Creation of the Rowset XSLT generic resources, that transform collection data into data that can be fed to an Index.
- Creation of the Index type generic resources, that define the Index configuration.
- Definition of an IRBootstrapper job that will perform the steps required to create the Indices.
In the first two steps we create generic resources for the Rowset XSLTs and Index Types through the Resource Management portlet . You can find detailed descriptions for the Rowset data (the output of the Rowset XSLT transformation) in the following sections:
You can find detailed descriptions for the Index Type definition here:
For the third step, a definition of an IRBootstrapper job is required. You can find the details for defining such a job in the IR Bootstrapper section. To complete the Index creation, the administrator must go to the IRBootstrapper and run the job. The two examples that follow will clarify the three steps.
Creating a Full Text and a Forward Index for a collection with two views
In this example we will create a Full Text and a Forward Index for a collection that has one view for the data in ES schema and one view for the data in DC schema. First of all let's create a generic resource for the Full Text Rowset XSLT for the collection data in ES schema:
Name := BrokerXSLT_es_anylanguage_to_ftRowset_anylanguage
SecondaryType := MetadataBrokerXSLT
Description := XSLT to transform from es schema to full text index rowset schema
Body :=
<xsl:stylesheet xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" indent="yes" method="xml" omit-xml-declaration="yes" />
<xsl:template xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" match="/">
<ROWSET xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:apply-templates xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="//esObject" />
</ROWSET>
</xsl:template>
<xsl:template xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" match="//esObject">
<ROW xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<FIELD xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="title">
<xsl:value-of xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="title" />
</FIELD>
<FIELD xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="description">
<xsl:value-of xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="description" />
</FIELD>
<FIELD xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="purpose">
<xsl:value-of xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="purpose" />
</FIELD>
<xsl:for-each xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="provenance/creator">
<FIELD xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="creator">
<xsl:value-of xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="." />
</FIELD>
</xsl:for-each>
<xsl:for-each xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="descKeys/keyword">
<FIELD xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="keyword">
<xsl:value-of xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="." />
</FIELD>
</xsl:for-each>
<FIELD xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="date">
<xsl:value-of xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="timeFrame/end" />
</FIELD>
<FIELD xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="suppInfo">
<xsl:value-of xmlns:dc="http://dublincore.org/documents/dcmi-terms/" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="suppInfo" />
</FIELD>
</ROW>
</xsl:template>
</xsl:stylesheet>Note that this XSLT extracts a number of fields from the collection payload. In the same fashion we create the Full Text Rowset XSLT for the DC schema:
Name := BrokerXSLT_dc_anylanguage_to_ftRowset_anylanguage
SecondaryType := MetadataBrokerXSLT
Description := XSLT to transform from DC schema to FTS rowset schema (suitable for feeding the full text index).
Body :=
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:output xmlns:xsl="http://www.w3.org/1999/XSL/Transform" indent="yes" method="xml" omit-xml-declaration="yes" /> <xsl:template xmlns:xsl="http://www.w3.org/1999/XSL/Transform" match="/"> <ROWSET xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <ROW xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <FIELD xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="description.abstract"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="//*[local-name()='description.abstract']" /> </FIELD> <xsl:for-each xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="//*[local-name()='subject']"> <xsl:if xmlns:xsl="http://www.w3.org/1999/XSL/Transform" test="normalize-space(.)"> <FIELD xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="subject"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="normalize-space(.)" /> </FIELD> </xsl:if> </xsl:for-each> <FIELD xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="type"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="//*[local-name()='type']" /> </FIELD> <FIELD xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="identifier"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="//*[local-name()='identifier']" /> </FIELD> <FIELD xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="language"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="//*[local-name()='language']" /> </FIELD> <FIELD xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="publisher"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="//*[local-name()='publisher']" /> </FIELD> <FIELD xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="contributor"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="//*[local-name()='contributor']" /> </FIELD> <FIELD xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="source"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="//*[local-name()='source']" /> </FIELD> </ROW> </ROWSET> </xsl:template> </xsl:stylesheet>
Additionally we must create the corresponding Full Text Index Type for the fields extracted from the ES and DC payload:
Name := IndexType_ft_es_dc_2.0
SecondaryType := FullTextIndexType
Description := Definition of the fulltext index type for the 'es' + 'dc' schema
Body :=
<index-type name="default"> <field-list sort-xnear-stop-word-threshold="2E8"> <field name="title"> <index>yes</index> <store>yes</store> <return>yes</return> <tokenize>yes</tokenize> <sort>no</sort> <boost>1.0</boost> </field> <field name="description"> <index>yes</index> <store>yes</store> <return>yes</return> <tokenize>yes</tokenize> <sort>no</sort> <boost>1.0</boost> </field> <field name="purpose"> <index>yes</index> <store>yes</store> <return>yes</return> <tokenize>yes</tokenize> <sort>no</sort> <boost>1.0</boost> </field> <field name="creator"> <index>yes</index> <store>yes</store> <return>yes</return> <tokenize>yes</tokenize> <sort>no</sort> <boost>1.0</boost> </field> <field name="keyword"> <index>yes</index> <store>yes</store> <return>yes</return> <tokenize>yes</tokenize> <sort>no</sort> <boost>1.0</boost> </field> <field name="date"> <index>yes</index> <store>yes</store> <return>yes</return> <tokenize>yes</tokenize> <sort>no</sort> <boost>1.0</boost> </field> <field name="suppInfo"> <index>yes</index> <store>yes</store> <return>yes</return> <tokenize>yes</tokenize> <sort>no</sort> <boost>1.0</boost> </field> <field name="description.abstract"> <index>yes</index> <store>yes</store> <return>yes</return> <tokenize>yes</tokenize> <sort>no</sort> <boost>1.0</boost> </field> <field name="subject"> <index>yes</index> <store>yes</store> <return>yes</return> <tokenize>yes</tokenize> <sort>no</sort> <boost>1.0</boost> </field> <field name="type"> <index>yes</index> <store>yes</store> <return>yes</return> <tokenize>yes</tokenize> <sort>no</sort> <boost>1.0</boost> </field> <field name="identifier"> <index>yes</index> <store>yes</store> <return>yes</return> <tokenize>yes</tokenize> <sort>no</sort> <boost>1.0</boost> </field> <field name="language"> <index>yes</index> <store>yes</store> <return>yes</return> <tokenize>yes</tokenize> <sort>no</sort> <boost>1.0</boost> </field> <field name="publisher"> <index>yes</index> <store>yes</store> <return>yes</return> <tokenize>yes</tokenize> <sort>no</sort> <boost>1.0</boost> </field> <field name="contributor"> <index>yes</index> <store>yes</store> <return>yes</return> <tokenize>yes</tokenize> <sort>no</sort> <boost>1.0</boost> </field> <field name="source"> <index>yes</index> <store>yes</store> <return>yes</return> <tokenize>yes</tokenize> <sort>no</sort> <boost>1.0</boost> </field> <field name="gDocCollectionID"> <index>yes</index> <store>yes</store> <return>yes</return> <tokenize>yes</tokenize> <sort>no</sort> <boost>1.0</boost> </field> <field name="gDocCollectionLang"> <index>yes</index> <store>yes</store> <return>yes</return> <tokenize>yes</tokenize> <sort>no</sort> <boost>1.0</boost> </field> </field-list> </index-type>
Note, in the Index Type above, that we also need to define the default "gDocCollectionID" and "gDocCollectionLang" fields, although there are not referenced in the XSLTs(the are automatically added by the DTS ). Then we will create the generic resources for the Forward Index. We will present a simple case here and we will use only the ES payload to create the Forward Rowsets. The following Rowset XSLT extracts the "title" and "creator" fields from the ES payload:
Name := BrokerXSLT_es_anylanguage_to_fwRowset_anylanguage_title_creator
SecondaryType := MetadataBrokerXSLT
Description := XSLT to transform from es schema to forward rowset schema including the 'title' and 'creator' fields (suitable for feeding the forward index).
Body :=
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:output xmlns:xsl="http://www.w3.org/1999/XSL/Transform" indent="yes" method="xml" omit-xml-declaration="yes" /> <xsl:variable xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="keys"> <key xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <keyName xmlns:xsl="http://www.w3.org/1999/XSL/Transform">title</keyName> <keyXPath xmlns:xsl="http://www.w3.org/1999/XSL/Transform">//title</keyXPath> </key> <key xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <keyName xmlns:xsl="http://www.w3.org/1999/XSL/Transform">creator</keyName> <keyXPath xmlns:xsl="http://www.w3.org/1999/XSL/Transform">//creator</keyXPath> </key> </xsl:variable> <xsl:template xmlns:xsl="http://www.w3.org/1999/XSL/Transform" match="/"> <xsl:element xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="ROWSET"> <xsl:element xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="INSERT"> <xsl:element xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="TUPLE"> <xsl:element xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="VALUE"> <xsl:for-each xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="//title"> <xsl:if xmlns:xsl="http://www.w3.org/1999/XSL/Transform" test="normalize-space(.)"> <FIELD xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="title"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="normalize-space(.)" /> </FIELD> </xsl:if> </xsl:for-each> <xsl:for-each xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="//creator"> <xsl:if xmlns:xsl="http://www.w3.org/1999/XSL/Transform" test="normalize-space(.)"> <FIELD xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="creator"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="normalize-space(.)" /> </FIELD> </xsl:if> </xsl:for-each> </xsl:element> </xsl:element> </xsl:element> </xsl:element> </xsl:template> </xsl:stylesheet>
In this example "title" and "creator" will have string values, so we just need to create a generic resource for string-string key-value pairs:
Name := IndexType_fwd_string_string
SecondaryType := ForwardIndexType
Description := Definition of the index type 'string_string' for the forward index
Body :=
<field-list> <field name="key"> <type>string</type> <sort>ascending</sort> </field> <field name="value"> <type>string</type> </field> </field-list>
In case we had a field that would have a single date value in the format 'yyyy-MM-dd' for each document, we would also have to create a generic resource for a string-date key-value pair like the following one:
Name := IndexType_fwd_esDate_string
SecondaryType := ForwardIndexType
Description := Definition of the index type 'date_string' for the forward index (suitable for es schema indexing)
Body :=
<field-list> <field name="key"> <type>date</type> <format>yyyy-MM-dd</format> <sort>ascending</sort> </field> <field name="value"> <type>string</type> </field> </field-list>
Finally we would have to append to the IRBootStrapper configuration generic resource the following job that would create the Full Text and Forward Index:
<job jobtype="IndexCollection" name="IndexEsDcCollection"> <initialization> <assign to="%IndexCollection.input.ColName" value="European Environment Agency: Topic Reports" /> <assign to="%Create_MC_ft_index.FullTextIndexGenerationTask.IndexTypeID" value="ft_es_dc_2.0" /> <assign to="%Create_MC_ft_index.FullTextIndexGenerationTask.TransformationXSLTID" value="$BrokerXSLT_wrapperFT" /> <assign to="%Create_MC_ft_index.FullTextIndexGenerationTask.Views" value="[ 5ec68209-41f1-4c1c-9359-ff055a38d981, 55404922-12ee-4808-9cc7-ac1ab38c4a2e ]" /> <assign to="%Create_MC_ft_index.FullTextIndexGenerationTask.ViewsXSLTSIDs" value="[ $BrokerXSLT_es_anylanguage_to_ftRowset_anylanguage, $BrokerXSLT_dc_anylanguage_to_ftRowset_anylanguage ]" /> <assign to="%Create_MC_ft_index.FullTextIndexGenerationTask.IdOfIndexManagerToAppend" userInputLabel="ID of FT index management resource to append" value="%userInput" /> <assign to="%Create_MC_fwd_index.ForwardIndexGenerationTask.TransformationXSLTID" value="$BrokerXSLT_wrapperFWD" /> <assign to="%Create_MC_fwd_index.ForwardIndexGenerationTask.IndexedKeyNames" value="[ ObjectID, gDocCollectionID, gDocCollectionLang, title, creator ]" /> <assign to="%Create_MC_fwd_index.ForwardIndexGenerationTask.IndexedKeyTypes" value="[ fwd_string_string, fwd_string_string, fwd_string_string, fwd_string_string, fwd_string_string ]" /> <assign to="%Create_MC_fwd_index.ForwardIndexGenerationTask.Views" value="[ 5ec68209-41f1-4c1c-9359-ff055a38d981 ]" /> <assign to="%Create_MC_fwd_index.ForwardIndexGenerationTask.ViewsXSLTSIDs" value="[ $BrokerXSLT_es_anylanguage_to_fwRowset_anylanguage_title_creator ]" /> <assign to="%Create_MC_fwd_index.ForwardIndexGenerationTask.IdOfIndexManagerToAppend" userInputLabel="ID of FWD index management resource to append" value="%userInput" /> </initialization> </job>
where the jobtype is defined in the corresponding section of the IRBootstrapper configuration:
<jobtype description="Creates the required FT-FWD indices for a collection." name="IndexCollection"> <input type="GCUBECollection" /> <jobDefinition> <sequential> <sequential> <assign to="%Create_MC_ft_index.input" value="%IndexCollection.input" /> <assign to="%Create_MC_ft_index.output.IndexedCollectionID" value="%Create_MC_ft_index.input.ColID" /> <assign to="%Create_MC_ft_index.FullTextIndexGenerationTask.NumberOfLookups" value="2" /> <task name="Create_MC_ft_index" tasktype="FullTextIndexGenerationTask" /> </sequential> <sequential> <assign to="%Create_MC_fwd_index.input" value="%IndexCollection.input" /> <assign to="%Create_MC_fwd_index.output.IndexedCollectionID" value="%Create_MC_fwd_index.input.ColID" /> <assign to="%Create_MC_fwd_index.ForwardIndexGenerationTask.NumberOfLookups" value="2" /> <task name="Create_MC_fwd_index" tasktype="ForwardIndexGenerationTask" /> </sequential> </sequential> </jobDefinition> </jobtype>
Note in the IRBootstrapper job, that for the Forward Index we additionally define the default fields ObjectID, gDocCollectionID and gDocCollectionLang which are all of string-string type.
Creating a Geo-Spatial Index for a collection with ES payload
Just as before we need to create the generic resource for the Geo Rowset XSLT:
<Resource version="0.4.x"> <ID>5d99ba40-f372-11dd-8807-8f9f04747f1a</ID> <Type>GenericResource</Type> <Scopes> <Scope>/d4science.research-infrastructures.eu/Ecosystem</Scope> </Scopes> <Profile> <SecondaryType>MetadataBrokerXSLT</SecondaryType> <Name>BrokerXSLT_es_anylanguage_to_geoRowset_anylanguage</Name> <Description>XSLT to transform from ES schema to geo index rowset schema</Description> <Body> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:output xmlns:xsl="http://www.w3.org/1999/XSL/Transform" indent="yes" method="xml" /> <xsl:variable xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="zeroDate" select="'00000000T000000Z'" /> <xsl:template xmlns:xsl="http://www.w3.org/1999/XSL/Transform" match="/"> <ROWSET xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:apply-templates xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="//esObject" /> </ROWSET> </xsl:template> <xsl:template xmlns:xsl="http://www.w3.org/1999/XSL/Transform" match="//esObject"> <xsl:variable xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="flag"> <xsl:choose xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:when xmlns:xsl="http://www.w3.org/1999/XSL/Transform" test="location/westBL[.!='']"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="'true'" /> </xsl:when> <xsl:otherwise xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="'false'" /> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="id" select="generate-id()" /> <xsl:variable xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="dateTimeStringBegin" select="timeFrame/begin" /> <xsl:variable xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="dateTimeStringEnd" select="timeFrame/end" /> <xsl:variable xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="beginDateEmpty" select="($dateTimeStringBegin=$zeroDate) or ($dateTimeStringBegin='unavailable') or (not(normalize-space($dateTimeStringBegin)))" /> <xsl:variable xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="endDateEmpty" select="($dateTimeStringEnd=$zeroDate) or ($dateTimeStringEnd='unavailable') or (not(normalize-space($dateTimeStringEnd)))" /> <xsl:choose xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:when xmlns:xsl="http://www.w3.org/1999/XSL/Transform" test="$flag='true'"> <xsl:variable xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="startField"> <xsl:choose xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:when xmlns:xsl="http://www.w3.org/1999/XSL/Transform" test="$beginDateEmpty='true'"> <xsl:choose xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:when xmlns:xsl="http://www.w3.org/1999/XSL/Transform" test="$endDateEmpty='true'"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="$zeroDate" /> </xsl:when> <xsl:otherwise xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="concat(substring($dateTimeStringEnd,1,4), '-', substring($dateTimeStringEnd,5,2), '-', substring($dateTimeStringEnd,7,2))" /> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="concat(substring($dateTimeStringBegin,1,4), '-', substring($dateTimeStringBegin,5,2), '-', substring($dateTimeStringBegin,7,2))" /> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="endField"> <xsl:choose xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:when xmlns:xsl="http://www.w3.org/1999/XSL/Transform" test="$endDateEmpty='true'"> <xsl:choose xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:when xmlns:xsl="http://www.w3.org/1999/XSL/Transform" test="$beginDateEmpty='true'"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="$zeroDate" /> </xsl:when> <xsl:otherwise xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="concat(substring($dateTimeStringBegin,1,4), '-', substring($dateTimeStringBegin,5,2), '-', substring($dateTimeStringBegin,7,2))" /> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="concat(substring($dateTimeStringEnd,1,4), '-', substring($dateTimeStringEnd,5,2), '-', substring($dateTimeStringEnd,7,2))" /> </xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:choose xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:when xmlns:xsl="http://www.w3.org/1999/XSL/Transform" test="location/southBL[.!='']"> <xsl:variable xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="x1" select="location/westBL" /> <xsl:variable xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="y1" select="location/southBL" /> <xsl:variable xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="x2" select="location/eastBL" /> <xsl:variable xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="y2" select="location/northBL" /> <ROW xmlns:xsl="http://www.w3.org/1999/XSL/Transform" id="{$id}" x1="{$x1}" x2="{$x2}" y1="{$y1}" y2="{$y2}"> <FIELD xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="StartTime"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="$startField" /> </FIELD> <FIELD xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="EndTime"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="$endField" /> </FIELD> </ROW> </xsl:when> <xsl:otherwise xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <ROW xmlns:xsl="http://www.w3.org/1999/XSL/Transform" /> </xsl:otherwise> </xsl:choose> </xsl:when> <xsl:otherwise xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:choose xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:when xmlns:xsl="http://www.w3.org/1999/XSL/Transform" test="location/centerLat[.!=''] and location/centerLon[.!='']"> <xsl:variable xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="cLat" select="location/centerLat" /> <xsl:variable xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="cLon" select="location/centerLon" /> <ROW xmlns:xsl="http://www.w3.org/1999/XSL/Transform" id="{$id}" x1="{$cLon}" y1="{$cLat}"> <FIELD xmlns:xsl="http://www.w3.org/1999/XSL/Transform" name="TimeStamp"> <xsl:choose xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:when xmlns:xsl="http://www.w3.org/1999/XSL/Transform" test="$endDateEmpty='true'"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="$zeroDate" /> </xsl:when> <xsl:otherwise xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:value-of xmlns:xsl="http://www.w3.org/1999/XSL/Transform" select="$dateTimeStringEnd" /> </xsl:otherwise> </xsl:choose> </FIELD> </ROW> </xsl:when> <xsl:otherwise xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <ROW xmlns:xsl="http://www.w3.org/1999/XSL/Transform" /> </xsl:otherwise> </xsl:choose> </xsl:otherwise> </xsl:choose> </xsl:template> </xsl:stylesheet> </Body> </Profile> </Resource>
Then we create the generic resource for the Geo Index Type:
<Resource version="0.4.x"> <ID>db1abec0-f371-11dd-8807-8f9f04747f1a</ID> <Type>GenericResource</Type> <Scopes> <Scope>/d4science.research-infrastructures.eu/Ecosystem</Scope> </Scopes> <Profile> <SecondaryType>GeoIndexType</SecondaryType> <Name>IndexType_geo_span_1.0</Name> <Description>Definition of the geo span index type</Description> <Body> <index-profile name="default2-geo"> <field-list> <field name="StartTime"> <type>date</type> <return>yes</return> </field> <field name="EndTime"> <type>date</type> <return>yes</return> </field> <field name="TimeStamp"> <type>date</type> <return>yes</return> </field> </field-list> </index-profile> </Body> </Profile> </Resource>
And finally we append the following job(and the jobtype in the corresponding section if it is not already there) in the IRBootstrapper configuration generic resource:
<job jobtype="GeoIndexMetadataCollection" name="IndexGeoCollection"> <initialization> <assign to="%GeoIndexMetadataCollection.input.SchemaName" value="es" /> <assign to="%GeoIndexMetadataCollection.input.SchemaURI" value="http://es.xsd" /> <assign to="%Create_MC_geo_index.GeoIndexGenerationTask.IndexTypeID" value="geo_span_1.0" /> <assign to="%Create_MC_geo_index.GeoIndexGenerationTask.EsToGeoXSLTID" value="$BrokerXSLT_es_anylanguage_to_geoRowset_anylanguage" /> <assign to="%Create_MC_geo_index.GeoIndexGenerationTask.IdOfIndexManagerToAppend" userInputLabel="ID of index management resource to append" value="%userInput" /> </initialization> </job> <jobtype description="Creates a geo index for a metadata view." name="GeoIndexMetadataCollection"> <input type="MetadataCollection" /> <jobDefinition> <sequential> <sequential> <assign to="%Create_MC_geo_index.input" value="%GeoIndexMetadataCollection.input" /> <assign to="%Create_MC_geo_index.output.IndexedCollectionID" value="%Create_MC_geo_index.input.ColID" /> <assign to="%Create_MC_geo_index.GeoIndexGenerationTask.NumberOfLookups" value="2" /> <task name="Create_MC_geo_index" tasktype="GeoIndexGenerationTask" /> </sequential> </sequential> </jobDefinition> </jobtype>
