denormalization - Automatic denormalizing by query -


i wonder if it's possible create logic automatically creates denormalized table , it's data (and maintains it) specific sql-like query.

given system user can maintain data model , data. data stored in "relational" tables, tables used user maintain data. if wants display data on webpage has write query (sql) automatically turn denormalized table , kept up-to-date when updating/deleting relational data.

let's got query this:

select t1.a, t1.b t1 t1.c = 1

the logic automatically create denormalized table copy of needed data according query. it's view (i wonder if views more performant approach). whenever query (give name) needed business logic replaced simple query on new table.

any update in t1 search queries t1 involved , update denormalized data automatically, performance win update rows infected (in example 1 row). that's point i'm not sure if it's achievable in automatic way. example query simple, if there queries joins, aggregation or sub queries?

does approach exist in nosql world , maybe can share experience it?

i know whether creating 1 table per query conflict best practises when using nosql databases.

i have idea how solve simple queries finding involved entity primary key when updating data , run query on specific entity again (so joins updated, too). aggregation , sub queries don't know how determine denormalized table's entity involved.


Comments

Post a Comment

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

i've set bento/ubuntu-16.04 vagrant box using php 5.6, , getting following error quite few times when try , run shell script: "uncaught reflection exception: class domdocument not exist". i've tried adding following top of script (not together), each no success: "sudo apt-get install php5.6-xml", "sudo apt-get install php5-xml", "sudo apt-get install php-dom" i've tried resetting server "sudo service apache2 restart". does have suggestions?
Read more

vue.js - Create hooks for automated testing -

Image
qa guys complained can't automate frontend testing. because our html looks same outside. lazy hack did this <template> <div :role="$options.name"> ... </div> </template> <script> export default { name: 'vmcomponentname' } </script> which takes name script , applies html. in browser get: <div role="vmcomponentname"> ... </div> line :role="$options.name" goes in every component. is there dry er solutions? please share. additional details i'll explain in details looking for. imagine have vmusercreate form creates user. test case can create user . to automatically test without role, have use following selector: .wrapper > .wrapper > .wrapper > .submit-button the test extremely brittle (will break lot). if use roles can use [role="vmusercreateform"] .submit-button selector. many folds less brittle. so basically, i'm ...
Read more

Add new key value to json node in java -

i have json file : { "id":1, "name":"abc", "addressdetails": { "city":"newyork" } } i wanted add 1 more key-value ("pincode" : "414141") node 'addressdetails'. i tried using : objectmapper mapper = new objectmapper(); jsonnode root = mapper.readtree(new file("d://test.json")); objectnode node = mapper.createobjectnode(); node.with("addressdetails").put("pincode", "414141"); but it's not getting added, there way can ? you can try you should modify file path objectmapper mapper = new objectmapper(); objectnode nodes = mapper.readvalue(new file("d:\\test.txt"), objectnode.class); nodes.with("addressdetails").put("pincode", "414141"); mapper.writer().writevalue(new file("d:\\test.txt"), nodes);
Read more