Innovative solution for the port and migration of complex database systems the knowledge of your company or certain departments is in MS ACCESS 97/2000, DBASE, or DB2 databases? Users appreciate the individual surface but complain increasingly a steadily worsening Performance.Die data security is no longer and the risk rises? The task of a database system is basics in managing a large amount of data. It includes user / access rights, and a user interface, the data define, enter, manipulate and evaluate to. Migration refers to the transfer and replacement of a legacy database system. A successful migration must? safe/reliable operation guarantee. Recently Goop, Barcelona Spain sought to clarify these questions. so little/many make changes, such as the compromise between complexity, risk and improve it admits. as little/much change the old UI, as the compromise between familiarity and optimization allows. large Incorporate flexibility to facilitate future amendments to? maximise the benefits of modern technologies and methods.
Challenge in management and industry have been realized since the beginning of the electronic data processing (EDP) countless databases, developed over the years, or partially ported to a newer technology. Nevertheless many companies and departments use always is still outdated daily”databases. The reasons for this are in the stored knowledge as also the individualized solution finding. The problems are manifold:? decreasing performance,? high maintenance and operating costs and? high risk. Solution old database can be ported quickly, poor effort and future-proof thanks to Java technology (JBoss & Hibernate), standard modules (E.g.
users/rights management) as well as freely customizable interface. Applications?Ideal for users who quickly and effort arm porting a legacy database system on a future-proof technology / migrate? Ideal for medium to large old database with more than one user access and more complex forms and reports. Functionality?Java 3-layers IT future-proof architecture using JBoss and standard technologies?Database independence using Hibernate?Use existing standard modules such as user, rights management, document management, address – order management / customizable. 100% traceability / traceability of all interactions with Envers. Free customizable user interface using XML engine (layout design, mandatory fields, tab order, etc.)?Usable GUI elements (input / selection fields tab, tables, tree elements, and so on) are visually very similar to the base surfaces like E.g. MS ACCESS. Finished data manipulators (free text search, create new/change/delete data). ?-Definable user actions (actions) within a mask. Workflow management to the design of business processes?Free customizable pressure / exportable (PDF, MS Word, etc.) Database evaluations through fully integrated iReport. Multilingual,. Multi-client-capable technology hardware requirement:?Server: > 2 GHz CPU, > 4 GB RAM, > 200 MB Disk.Win 2003/08, MAC OS, and LINUX?Client: > 2 GHz CPU, > 2 GB RAM, > 150 MB disk. Win 7/XP SP3, WIN CE, LINUX, IE/Firefox browser with Javaplugin?Database: MS SQL Server, ORACLE, PostgreSQL, MySQL, Sybase, HP NonStop, DB2, and many more (Hibernate). Use?User assimilation?Traceability?Ability to change?Economy?Future viability?Performance?Flexibility?Ausfallriskio?Migration time?Migrationsriskio?Resilience?Maintenance costs?Cost of migration?Life-cycle costs? Dr.-ing. Joachim Berlak (software4production GmbH) Lichtenstrasse mountain 8-85748 Garching b. Munchen phone: 089/5484242-0 fax: 089/5484242-9 Vazaninistr. 7-85567 Grafing b. Munchen Tel: 08092/300394-0 fax: 08092/300393-9