使用as400数据库中的当前系统制作一个几乎电子商务网站的最佳方法是什么？
我有一个 as400 系统，用于存储有关我们文章的所有信息，例如价格、可用性、代码、描述等。随着商品的销售，可用性会更频繁地发生变化，但所有这些都发生在 as400 系统中。
现在我需要创建一个包含所有文章的在线商店，但我只能访问数据库。
我的问题：
最好每天复制文章状态并放在另一个数据库（mysql）上以在网络服务器上使用，或者最好在网络服务器之间建立链接（*）和数据库？
( * ) 网络服务器不能与 as400 工作在同一服务器上
I have an as400 system that stores all information about our articles, like price, availability, code, description and so on. The availability use to change more often as things get sold, but all this happens into the as400 system.
Now I would need to make an online store with all the articles, but I only have access to the database.
My question:
Is better to make a copy of the articles state every day and put on another database (mysql) to use on a web server, or is better to make a link ( * ) between the webserver and the database?
( * ) The webserver can't be on the same server where as400 works
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
始终链接到 DB2，MySQL for IBM i 已停产，最后一个版本是 < a href="http://olex.openlogic.com/packages/mysql/5.0.67" rel="nofollow">5.0.67
您可以使用 Zend_Cache 或其他技术来提高缓存常见结果的性能。
Link to DB2 always, MySQL for IBM i is discontinued, the last version is 5.0.67
You can improve performance caching common results with Zend_Cache or other techniques.
目前，请忽略您的数据库服务器是 i 上的 DB2 这一事实。如果数据库位于 SQL Server 上，您会做什么？甲骨文？ MySQL？答案可能是外部因素（例如 24 x 7 可用性或希望将整个数据库计算机排除在 DMZ 之外）比数据库平台本身更重要。
i 上的 DB2 具有与其他数据库相同的功能。存储过程、ODBC/JDBC 访问——它实际上与其他数据库没有什么不同。无论您是选择提取所需的数据元素还是直接实时访问数据库，我都建议您让 DB2 程序员为您制作一些存储过程。
For the moment, ignore the fact that your database server is DB2 on i. What would you do if the database were on SQL Server? Oracle? MySQL? The answer is probably that external factors like 24 x 7 availability or the desire to keep the full database machine out of the DMZ are more important than the database platform itself.
DB2 on i has the same facilities every other database has. Stored procedures, ODBC/JDBC access - it's really not that different from other databases. No matter whether you choose to extract the data elements you need or to directly access the database in real time, I would advise you to ask the DB2 programmers to make you some stored procedures.
如果您想要实时访问您的可用性，您应该使用某种远程连接到您的 i，以便您可以动态更新可用性。根据您的网络和 Web 服务器的设置方式，您可以进行直接数据库连接或使用 Web 服务。设置时请记住安全性。
另一种选择可能是定期自动更新网络数据库。定期将根据您的预期交通量而定。我可能每天会进行多次更新，这样就不会有人过度订购您的库存。
另一个挑战是用订单更新后端数据库。这应该使用与提取数据相同的方法。
If you want live access to your availability, you should use some sort of remote connection to your i so you can dynamically update the availability. Depending on how your network and web server is setup, you can do direct DB connection or use a web service. Just remember security while setting this up.
Another option may be automatic updates to the web database on a regular basis. Regular would be based on your expected traffic volume. I would probably do more than one update a day so you don't have people over-ordering what you have in stock.
The other challenge is updating your back-end database with the orders. That should use the same method as you use to pull the data.