published paper for db performance strategies?

I am looking for some published paper regarding database performance
tunning performance strategies. This is for academic purpose so it
needs not to be any commerical database specific. It will be even
better if the paper has some kind of methods to quantify/measure
performance. Has anyone come across with any interesting paper about
this?

Thanks,
ewong>>>>> "Ed" == Ed Wong <ewong@.mail.com> writes:

Ed> I am looking for some published paper regarding database
Ed> performance tunning performance strategies. This is for
Ed> academic purpose so it needs not to be any commerical database

I would start with the various Wisconsin benchmarks. Go to the webpage
of the University of Wisconsin database group.

--
Pip-pip
Sailesh
http://www.cs.berkeley.edu/~sailesh|||Have a look at the Oracle docs, particularly the Oracle 9i Performance
Tuning Guide (http://tahiti.oracle.com).

HTH,
Brian

Ed Wong wrote:
> I am looking for some published paper regarding database performance
> tunning performance strategies. This is for academic purpose so it
> needs not to be any commerical database specific. It will be even
> better if the paper has some kind of methods to quantify/measure
> performance. Has anyone come across with any interesting paper about
> this?
> Thanks,
> ewong

--
================================================== =================

Brian Peasland
dba@.remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.

"I can give it to you cheap, quick, and good. Now pick two out of
the three"

Public Role

In BOL (regarding the Public Role) it states, as one of its functions:
"Captures all default permissions for users in a database."
How does one assign default permissions for a user?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200511/1
Every user in a database has, by default, the permissions granted to the
public role. So, you grant permissions to the user by granting permissions to
the public role. But ...
From BOL "A user receives the union of all the permissions granted, denied,
or revoked on an object, with any denied permissions taking precedence over
the same permissions granted or revoked at another level".
Ben Nevarez
"Robert R via droptable.com" wrote:

> In BOL (regarding the Public Role) it states, as one of its functions:
> "Captures all default permissions for users in a database."
> How does one assign default permissions for a user?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200511/1
>
|||Ben explained how all users inherit permissions from the public rile. I'd
like to add that you might consider using user-defined roles instead of
public so that you can more granularly control security. Personally, I only
use the public role for default system catalog permissions.
Hope this helps.
Dan Guzman
SQL Server MVP
"Robert R via droptable.com" <u3288@.uwe> wrote in message
news:5775935dde74c@.uwe...
> In BOL (regarding the Public Role) it states, as one of its functions:
> "Captures all default permissions for users in a database."
> How does one assign default permissions for a user?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200511/1

Public Role

In BOL (regarding the Public Role) it states, as one of its functions:
"Captures all default permissions for users in a database."
How does one assign default permissions for a user?
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200511/1Every user in a database has, by default, the permissions granted to the
public role. So, you grant permissions to the user by granting permissions t
o
the public role. But ...
From BOL "A user receives the union of all the permissions granted, denied,
or revoked on an object, with any denied permissions taking precedence over
the same permissions granted or revoked at another level".
Ben Nevarez
"Robert R via droptable.com" wrote:

> In BOL (regarding the Public Role) it states, as one of its functions:
> "Captures all default permissions for users in a database."
> How does one assign default permissions for a user?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200511/1
>|||Ben explained how all users inherit permissions from the public rile. I'd
like to add that you might consider using user-defined roles instead of
public so that you can more granularly control security. Personally, I only
use the public role for default system catalog permissions.
Hope this helps.
Dan Guzman
SQL Server MVP
"Robert R via droptable.com" <u3288@.uwe> wrote in message
news:5775935dde74c@.uwe...
> In BOL (regarding the Public Role) it states, as one of its functions:
> "Captures all default permissions for users in a database."
> How does one assign default permissions for a user?
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200511/1

Public Role

In BOL (regarding the Public Role) it states, as one of its functions:
"Captures all default permissions for users in a database."
How does one assign default permissions for a user?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200511/1Every user in a database has, by default, the permissions granted to the
public role. So, you grant permissions to the user by granting permissions to
the public role. But ...
From BOL "A user receives the union of all the permissions granted, denied,
or revoked on an object, with any denied permissions taking precedence over
the same permissions granted or revoked at another level".
Ben Nevarez
"Robert R via SQLMonster.com" wrote:
> In BOL (regarding the Public Role) it states, as one of its functions:
> "Captures all default permissions for users in a database."
> How does one assign default permissions for a user?
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200511/1
>|||Ben explained how all users inherit permissions from the public rile. I'd
like to add that you might consider using user-defined roles instead of
public so that you can more granularly control security. Personally, I only
use the public role for default system catalog permissions.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Robert R via SQLMonster.com" <u3288@.uwe> wrote in message
news:5775935dde74c@.uwe...
> In BOL (regarding the Public Role) it states, as one of its functions:
> "Captures all default permissions for users in a database."
> How does one assign default permissions for a user?
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200511/1