RE: [INTERFACES] PClabs Survey, Part I: Administration (resend)

> -----Original Message-----
> From: The Hermit Hacker [mailto:scrappy@hub.org]
> Sent: 31 January 2000 21:42
> To: pgsql-hackers@postgreSQL.org
> Cc: pgsql-interfaces@postgreSQL.org
> Subject: [INTERFACES] PClabs Survey, Part I: Administration (resend)

Items marked with a * are available in pgAdmin.

> Administration
> - graphical tools for
>         - database administration
>                 - installing the database server
>*                - creating and managing databases
>                 - creating and managing disk devices
>*                - creating and managing users
>*                - creating and managing indicies
>* (functions)    - creating and managing stored procedures
>                 - backup and restore operations
>                 - creating and managing replication links
>                 - Web publishing
>                 - database diagramming tools
>* (+Editting)    - viewing and entering data into database tables
>*                - submitting SQL commands and viewing results
>                 - send a message to all logged-in database users
>         - database perforformance tuning
>                 - configuring server engine options
>                 - viewing the SQL commands currently executing
>                 - detecting resource-intensive queries
>                 - killing selected queries  
>                 - graphing overall server engine statistics
>                 - single statement graphical execution plan display
>                 - SQL rewrite suggestions for a single SQL statement
>                 - index suggestions for a single SQL statement
>                 - index suggestions for overall server (based 
> on actual usage)
>                 - pre-calculation (summary table) suggestions 
> (based on actual usage)
>                 - baselining and then tracking server 
> performance over time
> - administration tools can be run from a 4.x Web browser
> - data file import and export tools
>*            - for ASCII text files
>* (via ODBC) - for native format database data files
>             - database data files can be directly moved from one 
>               database to another
> 
> - scripting support
>         - tools have command-line access
>         - can reverse-engineer database objects to a SQL script
>         - can reverse-engineer database data to a SQL script
>         - languages supplied for command scripting

True reverse engineering is not available, however tracking of changes and
generation of upgrade scripts from logs is available.

> - security
>         - security audit log of administrator and user activity
>*        - can set security by user or by group
>         - can set password qualification rules (minimum 
> length, non-repeatabilitity)
>* (not view) - set permissions on a table or view
>             - can set permissions on a particular column
>             - can set permissions on a particular row
> - job scheduler
>         - by time
>         - by event
> - Web publishing
>         - static Web publishing (one time)
>         - static Web publishing (scheduled)
>         - dynamic Web publishing
>         - Web users can modify query
> - documentation
>         - supply online versions of manuals
>         - manuals globally searchable