|
Webix is a Web-based OLAP tool, that provides all the necessary functionality for effective and rapid development of customer-specific information system.
This software allows to build business applications on basis of customer's data stored in his relational database, creating and managing OLAP objects right in browser. Meta-information is getting stored in its own meta-model, and is ready-to-use for users, also just from browser. Developer doesn't require any experience in programming to easily and fast develop their custom applications in this system.
Webix consists of as set of modules:
- Metamodel - internal meta-model implemented according to classic OLAP design, including dimensions with nodes, datacubes with periods and other OLAP objects.
- Analyzer - a module that allows users to easily browse, search, collect and compare data.
- Reporter - makes creation of reports over user's data fast and comfortable (reporting is based on XML/XSL/XSLT server-side, including FPO for creation of reports in PDF).
- DataBrowser - a data explorer tool allowing user access to its data and data model from Web, what helps to create OLAP objects on basis of relational databases.
- Transformer - a highly useful engine allowing different types of modification of data stored in relational database and providing ANSI-92 SQL standard compliant interface to them. Such transformations, as rotation, copy, and many others are just simple expressions in Webix Transformer module.
- Designer - provides all necessary functionality for definition and management of Webix (OLAP) objects, and all of this - from Web-browser.
- Administrator - has all necessary administration activities, such as logging, session-management, security, users and user groups administration.
- Cooperator - collaboration tool that can be very helpful in multi-user environment, the tool implements most of usually required support and notification mechanisms.
Webix is an unique Web-based data warehousing solution, which combines usage of 'old' data warehousing techniques and modern, latest technology achievements - Web, Java, JDBC, XML/XSL.
The unique detail that distinguish Webix from classic OLAP-based system, is that nodes aren't necessarily stored in the internal metamodel, but can be also left in the customer's database, if necessary. If these fields are indexed in the external datamodel and no specific conditions in queries running over these fiels are required, the application runs with the same performance, but obviously doesn't require a periodical import of these nodes into OLAP metamodel.
Used tools and technologies:
User Interface: HTML, DHTML, XML/XSL, JavaScript and Java applets
Server-side: servlets, Jasper, JDBC, Apache Xalan and Xerces
Web-servers: Apache 1.3 (with mod_jserv/TomCat), IBM WebSphere, Netscape Enterprise Server 3.5
Database: Oracle 8, Informix 7, MS Access 97
OS: Windows NT/2000 Server, Linux RedHat, Solaris 7
Time spent:
12 developers were working 28 months = 336 man-months.
|
