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

> -----Original Message-----
> From: The Hermit Hacker [mailto:scrappy(at)hub(dot)org]
> Sent: 31 January 2000 21:42
> To: pgsql-hackers(at)postgreSQL(dot)org
> Cc: pgsql-interfaces(at)postgreSQL(dot)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