In order to use materialized views, the Oracle DBA must set special initialization parameters and grant special authority to the users of materialized views. You ...

The beauty and joy of a relational database is the concept of relational closure—everything is a table. Beyond the eponymous table, query results are also “tables.” Any query serves as a table to be ...

All these flexible characteristics give customers little impetus to change database software in addition to the significant switching costs involved, in our view, even when new data architecture ...

Why is there such pervasive abuse and misuse of database views today? Views are a helpful tool in building a business intelligence environment, yet many organizations establish practices that not only ...