Flexible Database Design

Tech-Archive recommends: Fix windows errors by optimizing your registry

Greetings. I'm working on designing a database that provides a great deal of
flexibility in that it stores calls to .NET classes and SQL procedures. Was
curious if any of you had any ideas or experience you'd like to share.

The system has to be able to handle a number of different types of jobs.
Each job could have a number of different processes which may include
printing reports, sending emails, updating tables, etc. I want to be able to
have it so that each time a new job with a completely different set of
processes is required, new deployments of the system aren't required (or if
they are they are minor), only updates to database are needed. Rather, some
sort of template would be created that would allow administrators to
configure the jobs and their processes and details behind the jobs would be
stored in the database architecture.

What I'm thinking is having a series of tables that may look something like
this. One is a template table that identifies the high level parts related
to a job. Then a process table which is related to a given template. This
would include each different process a job may go through (i.e. print report
A, send email, print report B). Related to the process table would be a
table or tables that include the procedures or reference to code that would
be fired off specific to the current process being run for that job.

I don't think I will have problems conceptualizing any sql that may be
executed as a result of a given process. However, certain aspects will have
to be written in C#.

Finally, do any of you have ideas or have worked where you store references
to a .NET class within a table. So when a certain process is reached the .
NET class is called?

I was told that this isn't terribly uncommon and I think the person who told
me said it was called a pipeline or routing architecture but haven't had much
luck finding any information.

Any direction or high level ideas would be apprecaited.

Thanks.

--
Message posted via http://www.sqlmonster.com

.

Relevant Pages

  • Re: Mail merge data base problems
    ... I opened the .dot file, located the database. ... >> I can technically do anything to the template as long ... >See if that opens without problems. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Installer and Security
    ... you have to import the template into a security database before you ... I think SECEDIT will also import the template to a database too, ... unless you find and run the ADMINPAK.MSI file to install the extra MMCs]. ...
    (microsoft.public.win2000.security)
  • RE: Removing Blank Lines
    ... I have a setup for data clean up that you might find interesting. ... template database with a template table named tblCleanUp. ... and then import a template make-table query from ...
    (microsoft.public.access.formscoding)
  • Re: Control Word userform from Access
    ... The userform is controlled by a document registration database that uses ... linked to any replys or reports to keep them all together electronically. ... The registration is controlled from Word using the normal.dot template to ...
    (microsoft.public.word.vba.userforms)
  • Re: Control Word userform from Access
    ... > Word to supply custom templates of reports, letters, faxes etc for our ... As you can imagine this is a massive database. ... > create four charts, then on to a custom Word template ... >>before you called the userform and then, in the Initializeevent for the ...
    (microsoft.public.word.vba.userforms)