G
Guest
I'm going to be using SQL Server (thanks for that advice) for a distributed
application and I'd appreciate any advice on architecture.
The application is similar to a membership management system at a multi-site
chain -- like a fitness center chain.
Tasks include:
- Add new member - from any site or over the web
- Edit member
- Sign in/confirm member - at a location (enter ID, confirm photo)
- Reporting
- Etc.
Simplest approach would be 2-tier client server and be done with it.
However, it would be nice to be able to provide some data caching at the
sites, so we can do some basic tasks if the network goes down -- like sign in
a member.
And I can see some benefit to having the client apps isolated from the
database itself in case we ever want to move away from SQL Server, although
that's not a central design goal.
Any suggestions or experiences that might steer me to one solution or
another? Candidates include:
1. 2-tier client/server
2. middle tier on the server accessed with .net remoting
3. middle tier distributed at the sites that includes some data caching
4. distributed database using replication when network is online
5. others I'm not thinking of
Thanks for any war stories / advice!
kc
application and I'd appreciate any advice on architecture.
The application is similar to a membership management system at a multi-site
chain -- like a fitness center chain.
Tasks include:
- Add new member - from any site or over the web
- Edit member
- Sign in/confirm member - at a location (enter ID, confirm photo)
- Reporting
- Etc.
Simplest approach would be 2-tier client server and be done with it.
However, it would be nice to be able to provide some data caching at the
sites, so we can do some basic tasks if the network goes down -- like sign in
a member.
And I can see some benefit to having the client apps isolated from the
database itself in case we ever want to move away from SQL Server, although
that's not a central design goal.
Any suggestions or experiences that might steer me to one solution or
another? Candidates include:
1. 2-tier client/server
2. middle tier on the server accessed with .net remoting
3. middle tier distributed at the sites that includes some data caching
4. distributed database using replication when network is online
5. others I'm not thinking of
Thanks for any war stories / advice!
kc