Home > Solutions > Project Diary > SQL, PL/SQL
Category Image SQL , Structured Query Language, is a database computer language designed for managing data in relational database management systems (RDBMS). Its scope includes data query and update, schema creation and modification, and data access control. It is the most widely used language for relational databases. The core of SQL is formed by a command language that allows you to retrieve, insert, update, and delete data, and perform management and administrative functions. SQL also includes a call-level interface (SQL/CLI) for accessing and managing data and databases remotely.
Procedural Language/Structured Query Language or simply PL/SQL represents the procedural extension language for SQL and the Oracle relational database. It is one of the three key languages embedded in Oracle Database together with SQL and Java. JavaServer Pages (JSP) is a Java technology that helps software developers serve dynamically generated web pages based on HTML, XML, or other document types.
Project Image Professional Software Associates, Inc. has performed development of several subsystems of a Computer Aided Dispatching system for freight railroads which allows planning and controlling movements of the trains. This system allows dispatchers to easily track and control the status of trains, tracks, and field units being dispatched.
Project Image
The purpose of this project was to update an inventory control system based on the Oracle tools including the Warehouse Management System (WMS) module. The goal for the project was to reduce the current number of inventory organizations from seventeen consisting of a main warehouse and satellite stores.
The new system combines these into two separate systems consisting of one system for Generation and the other for Transmission and Distribution. To improve the tracking and tracing of items within the inventory the system allows printing and applying barcodes to inventory items. To expedite the inventory cycle count process the use of barcode devices is included.
Public Sector | Industrial/Robotics | Data Management | Desktop | MS Project | Oracle | Custom Reporting | SQL, PL/SQL | Barcode printing/scanning
Project Image
The project aimed at performing implementation of a new product that determines user access rights on a Windows file system and providing a reporting interface to convey the results. The system includes a set of scanner services which scan a file system and active directory repository, all results go to the database on the server.
Web based user interface on SilverLight technology allows managing the system, generating reports and getting quick information on user rights for some particular object.
Data Management | Desktop | ASP.NET | C/C++ | C# | Mantis BTS | Microsoft Internet Information Services | Microsoft Visual Studio | Seapine TestTrack | Silverlight | SQL, PL/SQL | SVN | Testlog
Project Image
This computer telephony IVR system allows callers to access their mutual fund account information via an IVR system.
PSA designed and developed the IVR and Voice Mail system using Mediasoft IVS software development kit and Dialogic voice processing board. The IVR system allows a user to access account information and historical information. The voice mail system features are: allowing the caller to record voice messages, having a name associated with each mailbox, passwords protection of individual mailboxes, options to add new and delete old mailboxes. Custom features designed into the voice mail system were added to provide the caller with an option to listen, erase or re-record his just recorded message, recover deleted messages, include up to 9 personal greeting messages for every mailbox, message forwarding capability with or without comments attached, message notification and replaying feature, group boxes, message confirmation, directory search and a new User Tutorial.
Mobile and Telephony | Embedded | Microsoft Windows NT | Visual Basic | SQL, PL/SQL | Mediasoft IVS | Dialogic