Posts

Showing posts from April, 2015

Database View vs Materialized View & How to refresh Materialized Views

View reduces the complexity of queries is a virtual table, created using Create View command is computed each time it is used or accessed => Slow Performance, No storage required updates in tables reflect immediately in the View (and vice versa), however, view created using DISTINCT, Group By etc. cant be updated Materialized View is a physical, precomputed copy of the data => Fast access, storage required Changes in original tables are not reflected in materialized views Must be updated via triggers, or "REFRESH" instruction in view creation statement See more:  https://techdifferences.com/difference-between-view-and-materialized-view.html How to refresh Materialized Views CREATE MATERIALIZED VIEW my_view_1    TABLESPACE ...    REFRESH FAST NEXT sysdate + 7    AS SELECT * FROM ...; "The statement does not include a START WITH parameter, so Oracle Database determines the first automatic refresh time by evaluating the NEXT value using the current

SOA, ESB, Microservices in 2015

nice article about soa, esb & microservices: "If you’re working in software architecture or development, there’s one phrase you will have heard repeated over and over for the last six months and that is “Microservices”. What are microservices, and why is everyone so excited by them? To understand this, let’s rewind the clock five years and take a look at the buzzword that everyone was using in 2010 – Service Oriented Architecture ..." https://www.voxxed.com/blog/2015/04/soa-principles-worked-for-ancient-greeks-so-why-did-they-fail-for-you/