Brief
Real Estate Transactions Browser is a Web application with rich GUI (Java-applet) that provides the user (real estate agent, loan manager of the bank, broker) with capabilities to build complicated queries for selling/buying operations over properties of different types (commercial houses, industrial properties, small houses, agricultural properties) and get query results on the map. The user can browse details of each selected transaction, export results to Excel or to PDF (in form of a printable report). Data exported to Excel is handled additionally with statistical macro to add value in form of diagrams and different totals/averages. Real Estate Transactions Browser also supplies the user with marketing information (4 classes of marketing zones, yield/rental prices dynamics).
Mapping capabilities of Real Estate Transactions Browser are based on set of vector background maps stored locally on the application server. Release 6.1 has been integrated with a third-party map data provider. Real Estate Transactions Browser via SOAP-based API can extract raster maps and add them on top of background map. This feature allows to get detailed/specialized map (satellite, roads, woods and so on) for rural areas of the country.
Real Estate Transactions Browser is managed by flexible and powerful security system. Application administrator has control over every application feature not only on available/not available level. The administrator can limit geography of data available for the user (on municipality level). There is also a possibility to limit access time for the user either by number of requests or by calendar.
Architecture
Real Estate Transactions Browser is a 3 tiers application:
- Rich Java client
- ASPX (.Net) middleware
- MapXtreme 2008 .Net map engine with set of background maps, MS-SQL Server 2005 with application database (data access is wrapped up by stored procedures API).
The major challenges in the porting project:
- Data types mismatch between third-party components and the core system.
- Data misalignment in application to ODBC binding.
- Data inconsistencies while using external mediators.
- Platform specific implementation caused by 64 bit specifics for Windows and Unix platforms
The following approaches were used to overcome these challenges:
- Creating interface subsystems isolating component specific interfaces from direct usage.
- Using conditional logic for accounting differences in data model for Windows and Unix platforms.
- Using Data Serialization code that supports same output format on both platforms.
Brief
Allows wireless network engineers to see a status of their network aggregated to markets and drillable to an individual cell or even a handset/call. It displays key performance indicators in various dashboards, reports and puts cells shaded by selected KPI on a geographic map. It provides Web UI to access the dashboards/reports/map layers.
User navigation along any axis of interest (such as network hierarchy or time) is handled instantly by displaying the requested data in no longer than 5 seconds.
Architecture
- ETL gathers data from heterogeneous data sources – ASCII or Excel files, database tables of various RDBMS.
- Data transformation routine stores data in Oracle data warehouse in a uniform way
- Aggregations are applied to raw data in order to pre-calculate key performance indicators and store them in the form ready to be presented to end users
- Microsoft SQL Server Analysis Services are used as OLAP engine. Multiple OLAP cubes are built upon data warehouse and used for instant access to any slice of data.
- Microsoft SQL Server Reporting Services are used to present requested data in tabular or chart forms.
- Oracle MapViewer component of Oracle Application Server is used to plot spatial information about wireless or customer-related artifacts on geographic map.
Breif
This application provides functionality for collecting all farming-related information (spatial field boundaries, soils types, satellite images, harvest data) in historical aspects to be used for further analysis and preparing data for variable fertilizing and seeding, offers an intuitive user interface for browsing the data from temporal and spatial perspective.
Architecture
It is a desktop application with a relational database and a spatial engine, featured with a customizable object model and customizable/configurable views.
