PClabs Survey, Part I: Administration (resend)
От | The Hermit Hacker |
---|---|
Тема | PClabs Survey, Part I: Administration (resend) |
Дата | |
Msg-id | Pine.BSF.4.21.0001311740440.480-100000@thelab.hub.org обсуждение исходный текст |
Список | pgsql-hackers |
Missed part of this one in my cut-n-paste :( Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org ================= PCLabs is doing a survey of RDBMSs, and has requested that we answer the following survey. As one file, its over 250 lines long, so I'm breaking into multiple parts, to make the 'thread' smaller. Some of this is obvious, but would rather make sure then risk feeding mis-information :) In this one, they talk about 'graphical tools', so I'm CC'ng pgsql-interfaces@postgresql.org, in the hopes that both Constantin(pgaccess) and Dave (PgAdmin) will jump into the thread and answer those questions... ========== Administration - graphical tools for - database administration - installing the database server - creatingand managing databases - creating and managing disk devices - creating and managing users - creating and managing indicies - creating and managing stored procedures - backup and restore operations - creating and managing replication links - Web publishing - database diagramming tools - viewing and entering data into database tables -submitting SQL commands and viewing results - send a message to all logged-in database users - databaseperforformance tuning - configuring server engine options - viewing the SQL commandscurrently executing - detecting resource-intensive queries - killing selected queries - graphing overall server engine statistics - single statement graphical execution plandisplay - SQL rewrite suggestions for a single SQL statement - index suggestions for a singleSQL statement - index suggestions for overall server (based on actual usage) - pre-calculation(summary table) suggestions (based on actual usage) - baselining and then tracking server performanceover time - administration tools can be run from a 4.x Web browser - data file import and export tools - for ASCII text files - for native format database data files - databasedata 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 - 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) - can set permissions on a table orview - 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 =========================== Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
В списке pgsql-hackers по дате отправления:
Предыдущее
От: The Hermit HackerДата:
Сообщение: PCLabs Survey, Part VIII: Data Warehousing and Reporting