Đã Hủy

In-memory caching - Java, Java Spring

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. (Please find attachment for the high level architecture)

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; We don't prefer REDIS or Other commercial software for Caching.

Usecase how it should:

1. USER1 runs the query for the first time from Application Layer (example select * from emp; (100 records))

2. Application layer checks in caching layer if the query data exist; if not than goes to database and cache the data in caching layer and results sent to Application layer

3. USER2 runs a query (select * from emp where dept_no=10) returns 15 records

This query should get the data from the cache rather than database : FILTERING

4. Database updates with new inserts now we have 18 records for dept 10

5. User3 runs the same query the data should be fetched from database replace the old cache with new caching data.

6. Once the data is in Cache any user running the same query should get data from Cache rather than database unless the underlying database records changes.

Kỹ năng: J2EE, Java, MySQL, PHP, Kiến trúc phần mềm

Xem thêm: integrate spring java project, write files spring java struts2 outwrite, spring java jsf booking sql, spring java jsf booking database, create erp spring java, sms spring java, spring java social, spring java file upload, spring java upload file, spring java freelance developers, datepicker spring java, upload download file sql server spring java, role spring java spring hibernate project, spring java social network, gis spring java

Về Bên Thuê:
( 10 nhận xét ) London, United Kingdom

Mã Dự Án: #15841051

9 freelancer đang chào giá trung bình $252 cho công việc này

$160 USD trong 3 ngày
(261 Đánh Giá)
7.0
lazermann

Hi! My name is Ihor, I will be glad to help you with your task. I have strong experience in Java and Android development for 3+ years. Feel free to contact me any time so we can discuss details. Relevant Skills and Thêm

$144 USD trong 10 ngày
(11 Đánh Giá)
5.1
anuragiitk

I am an IITK graduate and I have 11 years of experience in software development. I have 100% completion rate and I have finished projects with the highest level of customer satisfaction. Relevant Skills and Experience Thêm

$116 USD trong 10 ngày
(22 Đánh Giá)
5.5
proglogix2

Hi, i am a full stack mobile & web dev having similar technical skills & experience & have already worked on a similar project before so can do this Ref : [url removed, login to view] Relevant Skills a Thêm

$195 USD trong 10 ngày
(0 Đánh Giá)
0.0
techwiz2

Hi, i am a full stack mobile & web dev having similar technical skills & experience & have already worked on a similar project before so can do this Ref : [url removed, login to view] Relevant Skills a Thêm

$188 USD trong 10 ngày
(0 Đánh Giá)
0.0
sutarkiran01

I have been doing in memory caching in my all projects for data once database call is done and using data from cache. If any database update trigger called then updating cache as well.

$84 USD trong 3 ngày
(0 Đánh Giá)
0.0
rajumutyala

I have great experience in caching frameworks by using Java,J2EE,SPRING,EJB with all databases. And interested to take this up and deliver quality product in time. Hope you accept my proposal . Relevant Skills a Thêm

$194 USD trong 10 ngày
(0 Đánh Giá)
0.0
tblome

Hi, I'm a professional Senior Java Software Developer with about 15 years of experience in IT. My suggestion would be as follows: - have a look at DB to see if we can improve query performance - use a free cachin Thêm

$200 USD trong 10 ngày
(0 Đánh Giá)
0.0
$988 USD trong 10 ngày
(0 Đánh Giá)
0.0