[tracker/rss-enclosures] Added some indices for query performance
- From: Roberto Guido <rguido src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [tracker/rss-enclosures] Added some indices for query performance
- Date: Mon, 3 May 2010 00:38:16 +0000 (UTC)
commit cf54e0c8ef7cb501e65b0658a343faaec8aa3d34
Author: Mikael Ottela <mikael ottela ixonos com>
Date: Wed Apr 14 09:28:47 2010 +0300
Added some indices for query performance
data/ontologies/30-nie.ontology | 5 ++++-
data/ontologies/38-nmm.ontology | 10 ++++++----
data/ontologies/40-mlo.ontology | 7 ++++---
data/ontologies/Indices.list | 13 +++++++++++++
4 files changed, 27 insertions(+), 8 deletions(-)
---
diff --git a/data/ontologies/30-nie.ontology b/data/ontologies/30-nie.ontology
index 6f9f33a..5729a19 100644
--- a/data/ontologies/30-nie.ontology
+++ b/data/ontologies/30-nie.ontology
@@ -45,7 +45,10 @@ nie:subject a rdf:Property ;
rdfs:subPropertyOf dc:subject ;
nrl:maxCardinality 1 ;
rdfs:domain nie:InformationElement ;
- rdfs:range xsd:string .
+ rdfs:range xsd:string ;
+ tracker:fulltextIndexed true ;
+ tracker:fulltextNoLimit true ;
+ tracker:weight 5 .
nie:mimeType a rdf:Property ;
rdfs:label "Mime Type" ;
diff --git a/data/ontologies/38-nmm.ontology b/data/ontologies/38-nmm.ontology
index 79c6be0..4e7e74a 100644
--- a/data/ontologies/38-nmm.ontology
+++ b/data/ontologies/38-nmm.ontology
@@ -13,7 +13,7 @@
nmm: a tracker:Namespace, tracker:Ontology ;
tracker:prefix "nmm" ;
- nao:lastModified "2010-02-16T11:00:00Z" .
+ nao:lastModified "2010-04-09T00:00:50Z" .
nmm:MusicPiece a rdfs:Class ;
rdfs:label "Music" ;
@@ -63,8 +63,9 @@ nmm:musicAlbum a rdf:Property ;
nrl:maxCardinality 1 ;
rdfs:domain nmm:MusicPiece ;
rdfs:range nmm:MusicAlbum ;
- tracker:weight 6 ;
- tracker:writeback true .
+ tracker:writeback true ;
+ tracker:indexed true ;
+ tracker:weight 6 .
# Cardinality could be > 1 if we create one for album collections
nmm:albumArtist a rdf:Property ;
@@ -90,7 +91,8 @@ nmm:performer a rdf:Property ;
rdfs:domain nmm:MusicPiece ;
rdfs:range nmm:Artist ;
tracker:weight 4 ;
- tracker:writeback true .
+ tracker:writeback true ;
+ tracker:indexed true .
nmm:length a rdf:Property ;
rdfs:label "Length" ;
diff --git a/data/ontologies/40-mlo.ontology b/data/ontologies/40-mlo.ontology
index 5e1c4d5..a77aa05 100644
--- a/data/ontologies/40-mlo.ontology
+++ b/data/ontologies/40-mlo.ontology
@@ -131,13 +131,13 @@ mlo:bbNorthWest a rdf:Property ;
rdfs:label "North west corner";
rdfs:comment "North west corner of a bounding box. The GeoPoint is interpreted in 2D";
rdfs:domain mlo:GeoBoundingBox ;
- rdfs:range mlo:GeoPoint .
+ rdfs:range mlo:GeoPoint .
mlo:bbSouthEast a rdf:Property ;
rdfs:label "South east corner";
rdfs:comment "South east corner of a bounding box. The GeoPoint is interpreted in 2D";
rdfs:domain mlo:GeoBoundingBox ;
- rdfs:range mlo:GeoPoint .
+ rdfs:range mlo:GeoPoint .
# Properties of Route
mlo:startTime a rdf:Property ;
@@ -170,6 +170,7 @@ mlo:location a rdf:Property ;
rdfs:label "Property linking something to a location" ;
rdfs:comment "This can be subclassed to add semantics" ;
rdfs:domain nie:InformationElement ;
+ tracker:indexed true ;
rdfs:range mlo:GeoLocation .
# Properties of GeoLocation
@@ -229,7 +230,7 @@ mlo:poiLocation a rdf:Property ;
rdfs:range mlo:GeoPoint .
###############################################
-# Predefined categories coming from Symbian
+# Predefined categories coming from Symbian
# - move to a different file?
###############################################
diff --git a/data/ontologies/Indices.list b/data/ontologies/Indices.list
index bbff39d..ccabf5d 100644
--- a/data/ontologies/Indices.list
+++ b/data/ontologies/Indices.list
@@ -53,3 +53,16 @@
* maemo:localPhoneNumber:
- For matching against the local part of the phone number
+
+38-nmm:
+* nmm:musicAlbum:
+ - Used for retrieving songs on an album.
+ - Used in cases where fts:match is done against the album as well as the song
+
+* nmm:performer:
+ - Used for retrieving songs by a performer.
+ - Used in cases where fts:match is done against the performer as well as the song.
+
+40-mlo:
+* mlo:location:
+ - Used for retrieving all content in some specific location
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]