Design Thoughts - Booking application

We are currently looking into the development of an application for booking
resources and are researching the available options for recording and
tracking these bookings.
The possibilities we have presently for managing and tracking bookings are:
a) Store bookings in SQL db and code the calendar functionality, showing
existing bookings & availability
b) Interface with Exchange
c) Utilise a 3rd party product
As there may be 1000s of resources that users can book online, such as a
video library, I am not sure of the feasibility of the Exchange option
however I am open to all suggestions.
ThanksMurphy
I think due to where you have posted this you will mostly
get recommendations to use SQL Server.
It's probably down to size and performance. If you are
only going to have from a few hundred pieces of data to at
most a few thousand, then you don't need the power of a
database like SQL Server. Something like Access, Excell or
Lotus Notes can do the job (Don't really know about
exchange, but probably that too). If your data gets into
10,000's, 100,000's and millions of items of data then you
need to consider a 'full' strength database, like SQL
Server.
Hope this helps
John|||Thanks John,
So your advice would be to use a db to store booking information and then
code to ensure resources are not double booked etc
"John Bandettini" <anonymous@.discussions.microsoft.com> wrote in message
news:052601c3acec$d72f81a0$a401280a@.phx.gbl...
> Murphy
> I think due to where you have posted this you will mostly
> get recommendations to use SQL Server.
> It's probably down to size and performance. If you are
> only going to have from a few hundred pieces of data to at
> most a few thousand, then you don't need the power of a
> database like SQL Server. Something like Access, Excell or
> Lotus Notes can do the job (Don't really know about
> exchange, but probably that too). If your data gets into
> 10,000's, 100,000's and millions of items of data then you
> need to consider a 'full' strength database, like SQL
> Server.
> Hope this helps
> John|||Murphy
If you use a product like SQL Server you can use unique
indexes or constraints to not allow duplicate bookings to
be made. When you try to enter duplicate information you
will not be able to.
Regards
John|||RE/
>The possibilities we have presently for managing and tracking bookings are:
>a) Store bookings in SQL db and code the calendar functionality, showing
>existing bookings & availability
>b) Interface with Exchange
>c) Utilise a 3rd party product
>As there may be 1000s of resources that users can book online, such as a
>video library, I am not sure of the feasibility of the Exchange option
>however I am open to all suggestions.
Sounds like a bread-and-butter application...I'd expect to find lots of 3rd
party products available that would do 80% of what you want for 10% the cost of
writing an app.
--
PeteCresswell|||Now that sounds very promising...
Any suggestions on where I could start looking ?
"(Pete Cresswell)" <x@.y.z> wrote in message
news:cnpirvsn6btc53kqmmffi23ef41e1d3iko@.4ax.com...
> RE/
> >The possibilities we have presently for managing and tracking bookings
are:
> >a) Store bookings in SQL db and code the calendar functionality, showing
> >existing bookings & availability
> >b) Interface with Exchange
> >c) Utilise a 3rd party product
> >
> >As there may be 1000s of resources that users can book online, such as a
> >video library, I am not sure of the feasibility of the Exchange option
> >however I am open to all suggestions.
> Sounds like a bread-and-butter application...I'd expect to find lots of
3rd
> party products available that would do 80% of what you want for 10% the
cost of
> writing an app.
> --
> PeteCresswell|||"Murphy" <murphy@.murphy.com> wrote in message:
> Now that sounds very promising...
> Any suggestions on where I could start looking ?
http://www.swinc.com/erm for example.
--
Cheers,
Siegfried Weber|||Or if you need something that you can customize, but without the excellent
support that the swinc one comes with, take a look at
http://autoaccept-sink.sourceforge.net/.
- Dave
"Siegfried Weber" <siegfriedcw@.notmail.com> wrote in message
news:%239igEpZrDHA.2592@.TK2MSFTNGP10.phx.gbl...
> "Murphy" <murphy@.murphy.com> wrote in message:
> >
> > Now that sounds very promising...
> > Any suggestions on where I could start looking ?
> http://www.swinc.com/erm for example.
> --
> Cheers,
> Siegfried Weber
>|||Piling on... :)
Dave's right - his version offers more ability to get under the hood.
Depending on what the needed functionality is, we might be interested in
adding it to ERM, or might be willing to add it as a custom feature to ERM
as well.
--
========================================ERM (Exchange Resource Manager) Released
http://www.swinc.com/erm
========================================
"Dave Mills [MVP]" <dave@.dontSPAMme-exchange-mail.org> wrote in message
news:uLwrfBfrDHA.512@.tk2msftngp13.phx.gbl...
> Or if you need something that you can customize, but without the excellent
> support that the swinc one comes with, take a look at
> http://autoaccept-sink.sourceforge.net/.
> - Dave
> "Siegfried Weber" <siegfriedcw@.notmail.com> wrote in message
> news:%239igEpZrDHA.2592@.TK2MSFTNGP10.phx.gbl...
> > "Murphy" <murphy@.murphy.com> wrote in message:
> > >
> > > Now that sounds very promising...
> > > Any suggestions on where I could start looking ?
> >
> > http://www.swinc.com/erm for example.
> >
> > --
> > Cheers,
> >
> > Siegfried Weber
> >
>