Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Help needed to design database for online ticket booking Expand / Collapse
Author
Message
Posted Friday, May 3, 2013 12:35 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, August 14, 2014 4:48 AM
Points: 76, Visits: 346

I have to create local database and remote database.
i want to update database when ever the changes comes(update both database)..

example:
in online ticket booking , user can book ticket on web and in cinema theater itself.
whenever the user book a seat , need to update both databases.


please suggest some ideas for this problem??
my idea to keeping local and remote database may be wrong .


please help me to find out a solution??????????????????????
Post #1449062
Posted Friday, May 3, 2013 3:21 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:18 PM
Points: 2,951, Visits: 2,967
Hi,

Why do you need two databases? What is the advantage of having two databases?
Having one database with a good backup strategy is enough. This is in use at quite big systems.

Regards
IgorMi




Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1449096
Posted Friday, May 3, 2013 5:33 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, August 14, 2014 4:48 AM
Points: 76, Visits: 346
k. thnkx
Post #1449143
Posted Friday, May 3, 2013 5:40 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, August 14, 2014 4:48 AM
Points: 76, Visits: 346
if we use desktop application and web application for ticket booking,

how the database will update:
in booking ticket using web and desktop application concurrently..?????
Post #1449147
Posted Friday, May 3, 2013 5:48 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:34 PM
Points: 12,916, Visits: 32,077
have the desktop application e use some web services you will need to create whichreturn available tickets and another to book tickets.

maybe an additional web service so you can see what has already been booked foir admin purposes.

That way everything is centralized at one location(the web database), but can be extended to a desktop applicaiton, and then a iphone app, and then an android app,blackberry,kindle etc.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1449150
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse