[tracker] Added some indices for query performance



commit eb261d6dbbec08227ce81d2fd965782f5503cf1d
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]