RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


Satisfy Your Users with Views

This 10-Minute Solution describes two ways of giving end users direct access to query a database using views.




Building the Right Environment to Support AI, Machine Learning and Deep Learning

t is very common to encounter situations where users need to query a database directly. Even though you've created 100 reports in a given application, there will always be the need for that 101st report you didn't create. Allowing users to write their own reports poses several challenges, however.

For starters, your data model can be quite complicated. How can you simplify your users' view of the data so that they can understand it well enough to obtain the information they need? Additionally, you need to protect users from seeing sensitive information that they are not authorized to see.

In this 10-Minute Solution I will cover some of the basics of views and show you how to use them to solve thee two issues I raised above. My examples are based on the sample pubs database that works with SQL Server 7 and SQL Server 2000.

How do you allow users to query your database directly without confusing them with the data model or compromising sensitive data?

Use views to allow users to access data directly:

  • Views allow users to query complex data models easily.

  • Views allow you to filter information so that sensitive data remains hidden.

Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date