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 ...

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 ...

When Stephen Goldsmith was deputy mayor of New York City in 2010 and 2011, the city was working on processes to make data available to the public. “We have now gone from fulfilling that transparency ...

For manually entered holdings, you can now view gain/loss, cost per share, and total cost basis within the Portfolios tool in Investor. Add them to your views via the Data and Columns setting in the ...