in-memory caching - Result Caching Cache

Task/Problem Description:

We are working on reporting tool. the purpose of the tool is simply visualising the data from underlying database. Although the basic functionality work; the challenges we face is when the query is executed multiple times it's slows down the performance.

What we plan to achieve is below

1. A Query executed from frontend reporting layer; the query will be bring the results from underlying database (postgresql)

2. The query results should be cached in memory layer (should be a open source technology)

3. When the same query is executed again the data should be fetched from result set cache rather than getting data from database

4. If the underlying data changed in database than result set should purge and new data should be fetched from database and cached in-memory; meaning the data in cache should be consistant with database

5. Should be able to filter from query results.

6. The cached results should never exceed the memory.

7. There should be a time out for every cached query so that we can clear the cache periodically.

8. We need to have an option to either cache the query or not

9. Any suggestions or improvements are welcome

What we provide is:

1) We will be providing a commons library we built for you to know the kind of object you would be receiving from the Application layer.

2) An developer environment (Amazon Workspace) with all the necessary tools installed

Please refer to the attachment


Tags: Engineering, Java
Bid on this Job!

 

Here are some random jobs:

I need a virtual assistant.. Expert in Wordpress, woocommerce and photoshop works

I am starting a project in wordpress+woocommerce. I need someone to Edit the theme and some customizations. Also i will need some graphic works done. Apply only if you are good at the mentioned requirements. Wp-Bakery Visual edition is the plugin you will have...Read Full Description

Assistente de Suporte ao Cliente

Olá!Tudo bem?Precisamos de pessoas para trabalhar em nosso setor de atendimento ao cliente. Nosso objetivo é responder todas as dúvidas dos clientes com rapidez e agilidade. Temos um sistema de chat onde os clientes enviam todas as dúvidas e precisamos res...Read Full Description

Take some photos - Mexico City

I need photographers who are already going or have been to some public street event. I need photos of the people who are in the event (the public, not the artists), preferably doing special things, like enjoyning themselves, partying, celebrating moments. I do...Read Full Description

Create Lyric Video for dance track

We need a Lyric Video produced for a 3 minute dance music track. Please quote us a price and send show reels or examples of your previous work. Thanks....Read Full Description

Create Space Formating

I want to have a 260 page word document w/ cover formatted properly for Create Space....Read Full Description

Translation Editing Work form Ukrainian, Mongolian, Nepali, Karen, Thai, Khmer to English Language

I would like to hire Translators from Ukrainian, Mongolian, Nepali, Karen, Thai, Khmer to English language.We are looking for a translators to translate Ukrainian, Mongolian, Nepali, Karen (Karenic), Thai, Khmer (Cambodian) video interview into fluent English ...Read Full Description

Assistente Administrativo

Olá!Tudo bem?Precisamos de pessoas para trabalhar em nosso setor de administrativo. A pessoa deverá ter conhecimento em pacote office a partir do intermediário. Ótima escrita, pois será preciso responder e-mails, digitação de documentos, etc.Mais detalh...Read Full Description

To test workability of payment systems, which are present on our site for Japanese market

Task description:We need to test weekly whether different payment systems, which are present on our site, work correctly for money deposit and withdrawal. Such testing will help to ensure that our users don't have any problems with payments.Payment Method...Read Full Description

To test workability of payment systems, which are present on our site for Kenyan market

Task description:We need to test weekly whether different payment systems, which are present on our site, work correctly for money deposit and withdrawal. Such testing will help to ensure that our users don't have any problems with payments.Payment Method...Read Full Description

Python3/c++ simple program

Fall Semester:Create a program that reads data from [url removed, login to view] and builds parallel arrays for the plant items, with each array containing the plant's full name, zone, light, and price, respectively. Availability will be ignored. After re...Read Full Description

Python Graphs

Create some functions for Python Graphs...Read Full Description

Research writing

Game Theory for Stock Market Selling Price Optimization5 pagesDue in 5 hours...Read Full Description

memory foam layer 3d

memory foam layer for our mattress....Read Full Description

Home Rendering Needed

I need to render inside and outside...Read Full Description

Je propose un PLC OMRON CJ1M - open to bidding

I am looking for a programmer who specialises in Arduino and or Plcs to develop a prototype or full design with a very economic controller for a machinery we produce. Plc/Arduino1/Run ultrasonic distance sensor to report and display the level of a waste bin. ...Read Full Description

Reddit theme

I need reddit theme for football clubstylesheet (css)...Read Full Description

 

© 2005 - 2017 getFreeLancer.com
190943 contracts/jobs/projects currently available in our database.