A scalable database system from Apteco
Want to learn more about the Apteco Marketing Suite™ system architecture?
If your IT team is looking into implementing an Apteco software solution, or you’re an Apteco implementation partner, here is some technical information about how data queries are processed by the FastStats® WebService.
The Apteco FastStats® application architecture
The Apteco FastStats® application architecture is a scalable database system, designed to be fast, resilient and secure as information is accessed and manipulated by your marketing team. The process of data access is outlined below.
An Apteco FastStats® user presses the execute button to access data within the Apteco FastStats® application.
An xml message is then sent online from the user’s PC to the listening FastStats® WebService.
The query is received by the FastStats® WebService and checked to ensure that the user is connected to the server and has valid logon credentials.
Once security checks are complete, the message/query is forwarded to the SQL Control Database. An audit trail records details of the user’s activities, ensuring that the system is being used responsibly. The database server also decides which FastStats® service will complete the user’s request.
As the data operations complete, they are sent back to the user via the WebService.
Although the process is quite complex, data queries complete incredibly quickly, delivering important marketing data in a timely fashion.
WebService implementation guidance
When deploying the FastStats® WebService, the following design guidelines need to be considered:
- The FastStats® WebService should sit outside the partner’s and client’s private network.
- The SQL Control Database, FastStats® Service and FastStats® Database should all reside within the Private Network. The Private Network can be located at either the partner or the client data centre.
- FastStats® has its own proprietary database store. It is our method of storing data more efficiently for querying and analysis, helping to make it faster than a standard SQL database.
- The Source data shown in the diagram can be taken from a variety of sources such as an SQL database, Oracle, BB2, Postgres, flat file and CSV delimited file.
- Once you deploy the FastStats® Database, it will sit on the Production Server where you can carry out work for clients, or on your own data to improve your marketing campaign success.
The FastStats® application architecture is designed to provide security and resilience without placing additional resource demands on your infrastructure. Industry standard technologies improve speed and efficiency, giving your team the data they need, when they need it.
Looking for more information? Our demos and case studies could inspire you with ideas for using the Apteco Marketing Suite™ in your business. Or perhaps you’re ready to choose a partner? If you have any questions, or just want to chat, please get in touch by phone or email. Our experienced team will offer advice tailored to your challenges.