多用户数据应用程序架构 [英] Multi-User Data App Architecture
问题描述
我正在努力将我的应用程序从单个用户转换为
多用户。目前的架构是MSDE数据后端
（很快转换到SQLExpress，但尚未完成）。每个用户直接连接数据库
- 连接字符串加密存储在本地
文件中，所有设置等都存储在数据库中。问题是它似乎很快就会出现可扩展性和安全性问题。另一个问题是有一些文件，如图像文件，
存储在本地文件系统中，存储在数据库中的是文件的
路径。例如，如果UserA将图像添加到记录中，那么
UserB打开该记录，他们将无法看到图像，因为文件实际上是
在UserA的机器上。任何方向都可以通过这个方式获得赞赏。
" Matt Fielder" < mf **************** @ nospam.nospamwrote在
新闻：O0 ************** @ TK2MSFTNGP04.phx.gbl：
任何方向都可以使用
。
查看n层架构。特别是web服务和.NET
远程处理。
另一个问题是有一些文件，如图像文件，
< blockquote class =post_quotes>
存储在本地文件系统中，存储在数据库中的是该文件的
路径。例如，如果UserA将图像添加到记录中，那么
UserB打开该记录，他们将无法看到图像，因为文件实际上是
在UserA的机器上。任何方向都可以通过这个方式获得赞赏。
我会将图像和您拥有的任何其他二进制文件存储在数据库中
本身而不仅仅是指向其文件位置的指针。这很容易
足以将二进制文件直接写入图像字段类型并读取
它退出。
Web服务并不是一个真正的选择，因为我不想在服务器上要求IIS
。我已经开始关注远程处理 - 似乎可能是
的方式。
我知道告诉我关于远程处理的信息。 FAR太宽泛了一个问题...但是我会赞赏人们对我可以去看看我的
拥有的任何建议。其他人发现的任何书籍，网站或其他资源
特别有用吗？ （这是一个广泛的主题，并且一些资源用于不同的
科目比其他科目更好）
垃圾邮件捕手 < sp ********** @ rogers.comwrote in message
news：Xn ******************** **************@127.0.0。 1 ...
" Matt Fielder" < mf **************** @ nospam.nospamwrote在
新闻：O0 ************** @ TK2MSFTNGP04.phx.gbl：
>任何方向都可以通过这个方式获得赞赏。
查看n层架构。特别是web serviecs和.NET
远程处理。
I''m working on converting my application from a single user, to a
multi-user. The current architecture is with an MSDE data back end
(switching to SQLExpress soon, but not quite yet). Each user connects to
the database directly - the connection string is stored encrypted in a local
file, and all settings etc. are stored in the database. The problem is it
seems that this could rapidly run into problems with scalability and
security. The other issue is there are some files such as image files that
are stored in the local file system and what is stored in the database is a
path to the file. For example, if UserA add an image to a record, then
UserB opens that record, they won''t be able to see the image as the file is
actually on UserA''s machine. Any direction in where to go with this would
be appreciated.
"Matt Fielder" <mf****************@nospam.nospamwrote in
news:O0**************@TK2MSFTNGP04.phx.gbl:
Any direction in where to go with this would
be appreciated.
Look into n-tier architecture. In particular web serviecs and .NET
remoting.
The other issue is there are some files such as image files thatare stored in the local file system and what is stored in the database is a
path to the file. For example, if UserA add an image to a record, then
UserB opens that record, they won''t be able to see the image as the file is
actually on UserA''s machine. Any direction in where to go with this would
be appreciated.I''d store the images and any other binaries you have in the database
itself rather than just a pointer to its file location. It''s easy
enough to write the binary straight into an image field type and read
it back out.
Web services isn''t really an option as I don''t want to have to require IIS
on servers. I''ve started looking at remoting - seems like that might be the
way to go.
I know that "tell me about remoting" is FAR too broad of a question... but I
would appreciate any suggestions people have for where I can go look on my
own. Any books, websites or other resources that others have found
particularly useful? (it''s a broad topic, and some resources for different
subjects are alwasy better than others)
"Spam Catcher" <sp**********@rogers.comwrote in message
news:Xn**********************************@127.0.0. 1..."Matt Fielder" <mf****************@nospam.nospamwrote in
news:O0**************@TK2MSFTNGP04.phx.gbl:
>Any direction in where to go with this would
be appreciated.
Look into n-tier architecture. In particular web serviecs and .NET
remoting.
这篇关于多用户数据应用程序架构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
