1Transact provides the ability to manage long transactions in an underlying data storage technology such as an Oracle or PostgreSQL (Postgres) database. It provides a user interface (UI), a web services REST and SOAP API, and database SQL APIs to manage long transactions and checkpoints.
The service guarantees data integrity throughout the entire lifecycle of the job, whilst allowing more than one person to edit data in the same region.
1Transact can collaborate with 1Exchange to isolate extraction and submission from other users, 1Workflow to support full automation of the job lifecycle, and 1Integrate to support incremental change in product generation.
On an Oracle database, 1Transact makes use of the Oracle Workspace Manager SQL API provided by Oracle. On Postgres, the SQL API is provided by 1Transact and installed as part of the installation process.
Features
- Shield your users from other concurrent database changes
- Ensure that your production data is in an always-publishable and validated state
- Utilise scalable Oracle Workspace Manager technology
- Organise complex work programmes using hierarchies of workspaces (parent – child)
- Maximise your data access through optimistic locking (users can extract the same features in multiple jobs)
- Detect conflicts automatically (updates to the same feature by more than one user)
- Optionally resolve simple conflicts automatically, only alerting users to true attribute or geometric conflicts
- Allow users to resolve individual conflicts allowing them to nominate data from the current job, the conflicting job, the original data or a combination of these
- Merge groups of edits in a simple, atomic ‘all or nothing’ operation to guarantee edit integrity
Benefits
- Increase productivity by enabling users to edit data in jobs that are in close proximity to each other or in the same area without blocking or conflicting with each other
- Increase product release frequency because the data is ‘product-ready’ at all times
- Reduce risk by moving data to the live database in a single step, guaranteeing that the system can be recovered to a consistent state
- Increase productivity by allowing 1Workflow to automate the management of Oracle Workspaces
