• Home
• org.aksw.jena-sparql-api
• jena-sparql-api-resources
• 3.11.0-1
• source code
• cache-schema-pgsql.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

org.aksw.jena_sparql_api.cache.cache-schema-pgsql.sql Maven / Gradle / Ivy

-- Empty - schema currently gets generated by hibernate

CREATE TABLE IF NOT EXISTS "query_cache"(
    "id" VARCHAR(33) PRIMARY KEY, -- ID is usually an MD5 hash of the query string
    "query_string" text, -- The query string is kept for reference
    "data" text, -- The result set
    "hit_count" int NOT NULL, -- Counter for how ofter the cache entry was hit
    "time_of_insertion" TIMESTAMP,
    "time_of_expiration" TIMESTAMP
);


CREATE INDEX IF NOT EXISTS "idx_query_cache_time_of_expiration" ON "query_cache"("time_of_expiration");
CREATE INDEX IF NOT EXISTS "idx_query_cache_hit_count" ON "query_cache"("hit_count");