Sales-n-Stats technology

Return to Introduction  Previous page  Next page

System architecture and components

From the technological point of view, Sales-n-Stats system consists of Java® application that runs on your local computer and PHP script that runs on your web server. We selected Java and PHP as key technologies for this product to ensure truly cross-platform compatibility: Java applications can be run on almost any desktop system and PHP is installed on every web hosting. Sales-n-Stats is not a server side script but software that runs on your computer with full-fledged graphical user interface.

From the functional point of view there are three main components in the system of Sales-n-Stats: Data Collector, Data Center and Operator Terminal.

 

Sales-n-Stats Live edition structure.
Sales-n-Stats Live edition structure.

 

Data Collector is a compact PHP script installed at the hosting where your website is located. Through a JavaScript tracker built into your site it gathers different kinds of visitors' data (notes, emails, URLs, etc) and transfers it to Data Center. Data Collector has its own database which enables it to accumulate information about the visitors' actions on the site if Data Center is down for some time. That means you do not have to keep Data Center on all the time. The data is accumulated in Data Collector database even if the Internet connection is broken. All information accumulated in Data Collector goes to Data Center as soon as it becomes available.

Data Center is a centralized warehouse for storing and processing data received from Data Collector. Data Center is the heart of the Sales-n-Stats system, the most complicated data processing routines are done here. It converts raw data coming form Data Collector into highly structured information like visits and actions so it could be visualized on Site Monitor or used in reports. Data Center also manages all communication streams and takes care of receiving and queuing calls. Industry standard SQL databases are used as a data warehouse for storing visitors' data. Currently MySQL and Hypersonic SQL server are supported. In Enterprise version Data Center is available as a standalone application. In Live edition Data Center is combined with Operator Terminal.

 


Operator Terminal

Operator Terminal

 

Operator Terminal is an integrated workplace for an operator (manager, web master, analyst, or administrator) which is implemented as a Java application and is free from the typical weaknesses of a web interface. Operator's Terminal features a graphical representation of the website and provides a set of tools for analyzing the website activity and efficient communication with the visitors. Live edition of Sales-n-Stats is a single user version in which only one user with administrator/operator privileges can use the Operator's Terminal at any moment in time. Enterprise edition features multiple Operator Terminals connected to Data Center through the network using client-server technology. Separate Operator's Terminals with access to the resources of one common Data Center provide efficient collaboration environment in which several operators can work simultaneously communicating with each other and redistributing tasks according to the sphere of competence of each operator.

Technologies involved

Java (J2SE) is used as a platform for Data Center and the Operator's Terminal.
Data is stored and processed with an SQL database.
Client-side ActiveX/Java Applet organizes the process of communication with the visitors on the site.
PHP ensures effective integration with a website.