Home About Us Services Portfolio Contact Us












 
Programming @ Sanfranciscobay.com
 


DATABASE PORTFOLIO

UniDoc, 2003
Detailed description.

Windows 98/ME/2000/XP
Borland C++ Builder 5.0
Borland Interbase, SQL
OLE, COM

This system was designed for automation of enterprise document circulation and gathering of interim data flows. It can be used for daily data gathering from different sensors and counters (for electricity, water etc.), information from which flows discretely with certain time intervals. The main purpose of the program is to process database of figures, which take on different values in time, forming time series. The values are collected with the aid of basic documents, which are then entered by users. The possibility of distant parallel work of several users from different enterprise departments is also provided here. Outright integration with MS Excel allows to use all possibilities of formatting in order to create any forms of documents and reports, which can be necessary in specific situations.

Flexible system of settings allows to subdivide the enterprise into departments and then into objects. This allows to present the infrastructure in a more feasible manner. Each object can have any quantity of figures, values for which are defined in documents.

Documents are created based on preliminarily designed templates. Such a template is an MS Excel file, where each value cell has a stated object, figure, type of value (data, figure value) or time period. To create a pattern faster, additional options of copying, cloning and special cell insertions with automatic time domain alterations were developed. Besides that, a possibility of operating with lines and columns of values as well as spreadsheet pages was created. Template information is stored in the database and is used for document design.

Besides primary data input there is an option of summarizing information through reports. Templates can also be created for report design. It is possible to use different functions (sum, average, maximal and minimal value etc.) to obtain supplementary summary information.

This application functions based on a «client-server» principle. It is possible to use several data servers if considerable territorial sparseness is peculiar to the enterprise. Special mechanism of data synchronization between the main and local servers was developed for this. The mechanism allows to continue work if connection was interrupted, and copy the changes while taking time series dynamics into account.

     Role user work is provided to protect the input information. Permissions to use certain system functions are set for each user. A user can create his own menu of frequently used documents to simplify his work.

 

View some Examples of our work ... and read our Client Testimonials.

Contact us for a free quote, we'll respond within 24 hours.

Phone: (415) 992-9642

Contact Form





© 1996 Sanfranciscobay.com Internet Services. All Rights Reserved.