The railway industry requires a tool to efficiently generate designs for new and updated signalling systems. Efficiencies can be gained by ensuring that the tool integrates fully with other data and toolsets and also by automating many of the manual layout and design calculations that are required.
The existing CAD tool was extended such that it maintains a coherent model of the railway layout rather than simply a collection of drawing primitives such as lines and arcs as is the case with a basic CAD drawing tool. The signalling engineers can then edit the railway design using a number of visualisations and generate the documentation and specialised exports needed to review and implement changes to the rail network.
The application is run within the context of Bentley Microstation which is used to provide the core CAD drawing capability. The core technologies are .Net 4.0, C#, Hibernate, Spring.
The project adopted Agile / Scrum based methods. A system of continuous integration was applied using Hudson. A process of Test Driven Development (TDD) was followed using the NUnit framework
The client wanted to create value from their recruitment database by selling customised market intelligence to Businesses in the recruitment sector. To do this they required a means to create reports based on complex selection criteria, with multiple output formats and operating over such large data sets (10s millions of rows) that performance is a key issue.
Realogic implemented an online reporting application with
The solution used different query structures dynamically selected depending on the request to optimise the performance of the sql query underpinning the report. Realogic accommodated multiple variants of output format by dynamically formatting a core report definition so enabling many types of output with minimal maintenance overhead.
Technically speaking the system uses .net 4.0, SQL Server reporting services (SSRS), ASP, AJAX, XML edit of the Report Definition Language (RDL) format reports.
The client bases their business on large volumes of data collected from the web and imported to their central database on a periodic basis. Their earlier mechanisms were unable to cater with a number of complexities in the incoming stream or adapt easily to new forms of data, as such it threatened their ability to maintain the core stream of data needed to drive their business.
Realogic created of a Windows Forms application to manage bulk import from text based sources. This provides customised and user configurable transformations of the input stream, specialised logging and error handling.
Technically this is a standard MS Windows Forms application running the import action on a separate thread so as to control what is generally a long running activity. Use of MS Entity Framework facilitates easy configuration with different data sources
The client’s business is the provision of business intelligence and the nature of this is under constant review as they develop their market position. Consequently, the database from which they work needs to be continuously adapted optimised and processes automated.
At the level of the database Realogic added new features as specified at a business level, investigated performance issues and proposed improvements, formalised routine activities into repeatable procedures.
Technically this has required SQL Server execution plans, creation of indexes, optimisation of data types, rationalisation of functionality into stored procedures and SQLfunctions, paying attention to activity and resource usage (CPU, disk IO, disk space, locks etc)
The client’s business requires that they collect attendance records from membership systems running in a variety of customer sites. They processes the attendance data and sell predictions based on this back to their customers. The client required an adaptable, reliable program running with minimal footprint that installable and configurable on a wide range of MS Windows customer sites.
Realogic implemented a MS Windows Service and a Win Forms application that is deployable in a wide variety of situations, ranging from membership systems using a full relational database such as sql server through to a basic file based system using say MS Access.
The structure the product means that new types of membership system can be added to the list of supported systems with minimal programming.
Technically implemented with Dot Net 2.0 with a separate controller application and service communication via a Remoting style interface.
A client responsible for the upkeep of a property portfolio needed a way to better assess the state of the property and the action needed and taken to keep it in good order. The existing paper based system was too informal and made it too easy for faults to remain unmanaged, difficult to control costs and audit the quality of staff and contractors.
Realogic implemented an online application that provided a map style view of the property under management, with the ability to zoom into individual rooms and pick features that required attention. Once an issue was identified in this way a manager could assign the problem to staff or contractors and staff could then use the same interface to report on their progress.
Technically the system was implemented using Silverlight making use of custom user controls. Realogic created a web service to connect to a central SQL Server database.
The client wanted to demonstrate advanced capability in terms of online requirement management tools, such as DOORS a widely used tool with a relatively old-fashioned user interface.
Realogic implemented a substantial part of an online interface with a rich graphical interface that helps the user visualise the complex interlinked nature requirements data.
Technically the implementation was based on Silverlight that uses a web service that allowed connection to a variety of data sources.
The client ran a batch based production process using multiple spreadsheets to plan batched manufacturing runs. The operation was initially fine but as their business expanded the spreadsheets became unmanageable. An easy to use system was required that captured all the specific details of their business in a structured, reliable way.
Realogic implemented a Win Forms application was created that recorded all the relevant manufacturing detail such as customers, orders, production runs, machinery and added in calculations required to size up each batch run.
A client prepared quotes for systems made from many of its stock parts, the cost of each component had to be looked up individually and manually added. The process was tedious and prone to error, it also lacked any way to systematically monitor and follow up accounts.
The company does have comprehensive pricing detail in a legacy AS400 based system so an online quotation system was based around this. Account managers are able to pick stock items that make up a quote, apply discounting, set terms and conditions, generate the quote and log progress through to sale and commission.
Technically the system was implemented with ASP .Net 2.0 / C# / ODBC / AS400
The client was subcontracted to supply a substantial governmental system in the form of an online application to manage welfare payments. The client required assistance gathering and documenting requirements and then turning these into a functional system.
Realogic gathered and documented the business requirements at the start of the project. These were determined during a series of intensive but structured sessions with all those having a stake in the project.
Realogic subsequently wrote the functional specification that detailed the whole user interface and was the reference for the whole project implementation. Subsequently realogic was responsible for much of the web server and business object server code and test, designing many of the features used in the system’s framework.
Technically the system was implemented with a SQL Server database and separate web and business object servers both written with VB / .Net2.0.
A finance sector client wanted to test a potential new market opportunity brought about by changes to the regulatory framework in the US. Their objective was to create a product that provided all the documentation and evidence that financial institutions need to comply with these regulations.
Realogic was responsible for the development of the business object layer and delivered a reliable and adaptable system in a timely manner. Realogic also offered analytical input that was used to shape the whole product.
Technically the system made use of VC++, COM/DCOM/ATL, NT Services and OLEDB to connect to either a SQL Server or Oracle database option.
The client was commissioned to create a major command and control system for the public sector but had run into implementation and quality problems towards the end of the project. This was adversely affecting their reputation and ability to sign off the project.
Realogic resolved numerous bugs in the existing system most of which were causing upset with the clients. At the same time undertook lots of small scale activities to improve the overall maintainability of the current code base.
The system consisted of Visual C++ / MFC-based NT clients connected to a SUN UNIX server. The server used C / PLSQL and an Oracle database.