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 03, 2013 12:35 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, November 18, 2013 11:46 PM
Points: 72, Visits: 316

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 03, 2013 3:21 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:18 PM
Points: 2,729, Visits: 2,649
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
Post #1449096
Posted Friday, May 03, 2013 5:33 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, November 18, 2013 11:46 PM
Points: 72, Visits: 316
k. thnkx
Post #1449143
Posted Friday, May 03, 2013 5:40 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, November 18, 2013 11:46 PM
Points: 72, Visits: 316
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 03, 2013 5:48 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:39 PM
Points: 12,749, Visits: 31,114
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