|
|
|
|
|
 Rexson Impress has been providing many advantages over its competition and utilises the MSDE version of Microsoft SQL database - the world’s fastest, most robust database. The use of such a database gives our customers advanced control of material handling and storage, while our software’s fast and highly developed tracking and recording functions ensures an unrivalled level of quality control. Microsoft SQL Server has been developed to handle Gigabytes of data, by many users, over WAN, LAN and the internet - so you can be sure it's capable of meeting your requirements! |
MS Access or similar databases, as used by our competitors, are only 'desktop' file server applications, not full 'client/server' systems like SQL. As such their Access based systems are prone to data corruption, hang-ups and speed degredation - especially in high data or multi-user network applications. The speed and reliability of Rexson Impress/SQL also makes realistically possible, for the first time, effective operation of 'satellite' systems from 'motherplants' over WANs and the Internet.
Unlike SQL, Access based ink management software means each client reads and writes directly to the raw data tables. If a client machine crashes while writing data this will usually cause the back-end management database to also crash and become corrupt. The same thing will occur if the network fails, has a glitch or temporarily becomes overloaded. This problem becomes more apparent with Access as the amount of data or the number of users increases.
With SQL Server the clients do not talk directly with the tables but with an intelligent data manager on the server. This in turn reads and writes data from and to the tables. If a client machine crashes, or the network hiccups, this will not affect the underlying tables; instead the data manager realises that the transaction has not been completed and does not commit the partially transmitted data to the database. This means therefore that the Rexson Impress database continues to run without problem.
|
What does all this mean to me ?
 Rexson Impress means ....
 No Crashes
No Corruption
Fast File & Report Processing
Safe Multi-user Customer Networking
Easy & Stable ERP & MRP System Interfacing
The SQL client/server system also maintains an automatic 'transaction log'. If a backup has to be restored the transaction log can be run and should restore all completed transactions up to the time of the crash.
The SQL client/server software itself is designed for mission critical systems and is orders of magnitude more reliable than an Access/Jet file server system (see bulletin below).
In Microsoft's own words.... |
"Microsoft Jet (Access database engine) is a file-sharing database system. A file-sharing database is one in which all the processing of the file takes place at the client. When a file-sharing database, such as Microsoft Jet, is used in a multiuser environment, multiple client processes are using file read, write, and locking operations on the same shared file across a network. If, for any reason, a process cannot be completed, the file can be left in an incomplete or a corrupted state. Two examples of when a process may not be completed is when a client is terminated unexpectedly or when a network connection to a server is dropped.
Microsoft Jet is not intended to be used with high-stress, high-concurrency, 24x7 server applications, such as Web, commerce, transactional, and messaging servers. For these type of applications, the best solution is to switch to a true client/server-based database system such as Microsoft Data Engine (MSDE) or Microsoft SQL Server. When you use Microsoft Jet in high-stress applications such as Microsoft Internet Information Server (IIS), customers have reported database corruption, stability issues such as IIS crashing or locking up, and also a sudden and persistent failure of the driver to connect to a valid database that requires re-starting the IIS service."
Microsoft article Q300216
|
|
|
 Click for a comparison between
Microsoft SQL Server and Microsoft Access |
|
|
|
