By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,678 Members | 1,144 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,678 IT Pros & Developers. It's quick & easy.

Looking for a generic DB-maintenance application

P: n/a
Hello,

I administrate a large number of Oracle databases for my company.

Some DBs are easily structured and the staff responsible for keeping
them updated are able to use an Oracle client (SQirreL, PLSQL/
Developer, or even MS Access as a client) to directly access Oracle
and update their tables (without messing around with integrity etc).

Other DBs are too complex in their structure or the staff responsible
for data updating are not able to handle with SQL and have no skills
in working directly on DB objects...

For the later case I wish I could offer them a foolprof'ed, user-
friendly web-based tool for updating data (enter new data; update
existing data; delete data).

I dream of a generic web-based DB-maintenance application which
enables to:
- configure your application by naming the tables, the relations
between them, the constrains, etc, and you get on the fly an
application that enables you to browse from master to slave table, to
move from record to record and from column to column and edit/delete/
insert data in/from/into them.
- perform checks (data type, domain constrains, etc) using the info
from the data dictionary.
- perform pre-defined plausibility checks.
- supports data capture helps like drop-down-lists for foreign keys,
check or radio buttons for flag-columns.
- etc etc etc.

This is something I would love to develop myself... if I only had the
time!

I wonder that (at least as far as I have been able to google around)
there is nothing like this on the market!

Best regards from Bonn, Julian
Nov 21 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi,

Oracle has a tool they call APEX (Oracle Application Express) that
provides a user-friendly RAD environment for building databases:

http://www.oracle.com/technology/pro...ess/index.html

In the web application space, there are applications such as
caspio.com and quickbase.com that allow users to create web-accessible
databases.

Regards,

John Peters

On Nov 21, 10:16 am, jimenezkra...@googlemail.com wrote:
Hello,

I administrate a large number of Oracle databases for my company.

Some DBs are easily structured and the staff responsible for keeping
them updated are able to use an Oracle client (SQirreL, PLSQL/
Developer, or even MS Access as a client) to directly access Oracle
and update their tables (without messing around with integrity etc).

Other DBs are too complex in their structure or the staff responsible
for data updating are not able to handle with SQL and have no skills
in working directly on DB objects...

For the later case I wish I could offer them a foolprof'ed, user-
friendly web-based tool for updating data (enter new data; update
existing data; delete data).

I dream of a generic web-based DB-maintenance application which
enables to:
- configure your application by naming the tables, the relations
between them, the constrains, etc, and you get on the fly an
application that enables you to browse from master to slave table, to
move from record to record and from column to column and edit/delete/
insert data in/from/into them.
- perform checks (data type, domain constrains, etc) using the info
from the data dictionary.
- perform pre-defined plausibility checks.
- supports data capture helps like drop-down-lists for foreign keys,
check or radio buttons for flag-columns.
- etc etc etc.

This is something I would love to develop myself... if I only had the
time!

I wonder that (at least as far as I have been able to google around)
there is nothing like this on the market!

Best regards from Bonn, Julian
Nov 24 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.