Processes
Projects
The List of Projects in E-nvoy ITServices are:
1. 1. IVRS
2. 2. HSQLDB
IVRS (Interactive Voice Response System)
IVRS is a computer telephone technology which gives information to the customers any time from any where with a telephone call.
IVR System provides access to computer database through normal telephones. A user can access a remote computer database by dialing a specified IVR system number and obtain the required information by dialing the specified digits as informed by the computer i.e., when a customer dials the IVR system number the voice system answers the call and prompts the instructions via a spoken menu which is a prerecorded voice. Customer has to press the number which was prompted inthe instructions to have the required information and at any time can opt for transfer to Operator incase the customer requires an additional information other than the service listed in the menu.
The desired information can be recorded and stored in the PC using a microphone, which will be informed to the user on dialing the specified number.
With the IVR system customers can avail service of 24/7. Business would be benefited by the Increase Customer Service Levels, Automated access to the Information, Reduce Operation cost, Increase Employee productivity, Reduce operation cost. We are in Process of implementing this product in Government Sectors aswell....
Industries that are benefited from the IVR system are:
Government Offices:
All the government departments which have the information concern to the public and the information to be shared with the people can use the IVRS for the better service to the people. At the same time the different government schemes and policies available for the people can also be known by the people. Sectors in
Government Benifited by this Product are:
Municipal Corporations Revenue Department Finance Department Railway Department Defence Department Sericulture Departments Agriculture Department Public Sectors
Educational Institutes:
Universities, Colleges, Schools can use the IVRS for the announcement of the Examination Schedules, Results and any information which is related to the students and the institution. In the Schools and colleges even the Students attendance, performance details can be directly sent to the parents and the Fees remainders can be sent with the outbound calls.
Health Care Services:
All the Hospital, Nursing Service details can be provided to the patients. The patients can know the availability of the doctors who are specialized in the concern fields. Scheduling an Appointment with the doctor, knowing the Status of the Pathological test reports, requesting for a nursing service at home and even the cancellation of the appointment can be done. The patients can be intimated with the change of appointment schedules with the doctor thorough the IVRS.
Transportation Services:
Services like Time Schedules of the Flight, Train, Bus services to the different destination and the availability of the seats, price and the status of the reservation can be availed with the IVRS.
Financial Services:
Services like Telephone Banking, Stock trading/quotes, Mutual funds, Credit cards Information can be possible with the IVRS.
Communication Media
All the Mass Communication Media like News Paper, Television Channels, Weeklies etc., can use the IVRS for the purpose of Information dissemination to the people. Public surveys and the polls can be conducted. The Latest/ Breaking News can be broadcasted to the subscribers. At the same time common man can use the IVRS for knowing the information required.
Call Center Service
In the Call Center Industry IVRS has become an important part for the purpose of Employee Screening, Customer Satisfaction Surveys, Client Survey/Questionnaire administration, Data Collection required for the better customer service.
Consumer Support/Service
All the Industries which have the Customer Support/Service can use the IVRS for the Customer satisfaction surveys and General Customer Information.
HSQLDB
HSQLDB is the leading SQL relational database engine written in Java. It has a JDBC driver and supports a rich subset of ANSI-92 SQL (BNF tree format) plus SQL 99 and 2003 enhancements. It offers a small (less than 100k in one version for applets), fast database engine which offers both in-memory and disk-based tables and supports embedded and server modes.
Features
#100% Java
#A full RDBMS (Relational Database Management System), with the Object capabilities of Java
#Switchable source code to support JDK 1.1.x, 1.2.x, 1.3.x, 1.4.x and above
Super fast startup and SELECT, INSERT, DELETE and UPDATE operations
* Standard SQL (Structured Query Language) syntax
* Inner and outer joins, SELECT queries as correlations in joins
* Scalar (single value) SELECTS, correlated subqueries including IN, EXISTS, ANY, ALL
* Views, Temp tables and sequences
* Primary key, unique and check constraints on single or multiple columns
* Indexes on single or multiple columns
* ORDER BY, GROUP BY and HAVING
* COUNT, SUM, MIN, MAX, AVG and statistical aggregate functions (also in expressions and function arguments)
* Full support for SQL expressions such as CASE .. WHEN .. ELSE .. , NULLIF etc.
* SQL standard autoincrement column support plus sequences
* Transaction COMMIT, ROLLBACK and SAVEPOINT support
* Referential Integrity (foreign keys) with full cascading options (delete, update, set null, set default)
* Multiple schemata per database
* Java stored procedures and functions
* Triggers
* Database security with passwords, user rights and roles with GRANT and REVOKE
* Extensive set of ALTER TABLE commands allowing change of column type
* In-memory tables for fastest operation
* Disk based tables for large data sets
* Text tables with external file data sources such as CSV files
* In-memory (like applets), embedded (into Java applications) and Client-Server operating modes
* Three client server protocols: HSQL, HTTP and HSQL-BER - can run as an HTTP web server - all with SSL option
* Can be used in applets, read-only media (CD), inside jars, webstart and embedded applications
* Multiple databases per JVM
* Disk tables (CACHED TABLE) up to 8GB and text tables up to 2GB each
* Size of each string and binary data item only limited by memory
* Full support for PreparedStatement objects to speed up query processing
* 95% JDBC interface support with batch statement and scrollable ResultSet functionality
* All JDBC 1 data types supported, plus 'Object' , Boolean, Blob and Clob
* Full JDBC 2 DatabaseMetaData and ResultSetMetaData support
* Database dump as SQL script with or without data
* Powerful and compact java command line and GUI tools for database management