Categories

See More
Popular Forum

MBA (4887) B.Tech (1769) Engineering (1486) Class 12 (1030) Study Abroad (1004) Computer Science and Engineering (988) Business Management Studies (865) BBA (846) Diploma (746) CAT (651) B.Com (648) B.Sc (643) JEE Mains (618) Mechanical Engineering (574) Exam (525) India (462) Career (452) All Time Q&A (439) Mass Communication (427) BCA (417) Science (384) Computers & IT (Non-Engg) (383) Medicine & Health Sciences (381) Hotel Management (373) Civil Engineering (353) MCA (349) Tuteehub Top Questions (348) Distance (340) Colleges in India (334)
See More

how to use cache technology solve complex sql data

General Tech Technology & Software

Max. 2000 characters
Replies

usr_profile.png

User

( 3 months ago )

i have some common sql,and frequent use the result of sql,and add some other condition to select.i need to cache the result. i try to put sql result in redis,but the key cannot adopt the requirement,i don't recognize sql relation through key. table

for example i want to put the order table which all type = 2 put in cache,and then i use the result filter all department_id =4. the key redis cannot fill it. this example is simple,in requirement,it can be complex sql with some table join result. what cache technology can solve this problem?

usr_profile.png

User

( 3 months ago )

As you indicate, there is a mismatch between a relational database and a key-value store (or cache).

The usual way to overcome the mismatch is to de-normalize your data. That is cache specific results which can then be retrieved with a single key lookup.

So, from your example, you would cache the result of the select AND the filter in one cache key-value.

Of course, doing this on data that is written then raises the problem of consistency.

Welcome to the fun!

what's your interest


forum_ban8_5d8c5fd7cf6f7.gif