RevX Data Access Layer (DAL)

Secure access to data, redact sensitive fields, and encrypt data which is highly confidential on Oracle, SQL Server, mySQL, DB2, or Access.

RevX Data Access Layer The data access layer provided by the RevX framework delivers unprecedented flexibility in managing data. The DAL currently supports Oracle, SQL Server, mySQL, DB2, and Access.

The database structure and data access layer are comprehensively documented and your staff will receive training on it's use and overall organization.

The DAL is responsible for brokering all requests made by way of a plugin. Developers won't write any SQL to accomplish data related operations. As a result, the underlying data and it's relationships are completely uncoupled from the code base allowing for extreme flexibility traditionally absent in most solutions today.

The meta data which defines the physical structure of the database is expressed using XML and is loaded by the DAL at startup. The DAL-XML definition will automatically reconcile any discrepancies found in the target schema (automatic table, index, PK, FK, unique's, ..., creation). Upon successfully loading the XML, the DAL will operate as a facade for all Query, Insert, Update, and Delete operations. The DAL will prepare and execute the SQL on behalf of any plugin.

FEATURE SPOTLIGHT

  • Connection Pooling - The RevX DAL has incorporated a connection pool management layer designed to optimize the use of connections to the database. This approach allows the DAL to leverage some of the more advanced features of the RevX SDP which include locking, transaction control, caching, and connection spanning to allow for queries across multiple connections.

  • Transaction Management - above and beyond traditional transaction management, the RevX DAL will earmark a connection to signify it has participated

  • SQL Brokering - the DAL will execute all SQL queries on behalf of plugin's requesting access to data. No more renegade queries to over take your DB server.

  • Security - the RevX Security Manager implements a number of security constructs around data access which have been built into the DAL. Every field in the database can be flagged as read-write, read-only, write-only, and protected. A field can be scoped at the group or individual login level.

  • Syndication - as part of the virtualization model, also known as Syndication, the DAL will ensure any given login is only allowed to query data which belongs to the business units the login is authorized to access. In contrast to most schemes (query for all and remove what's not authorized), the DAL will ensure that even a rouge plugin "trying" to circumvent the model won't access data outside of it's configured view.

  • Encryption - data is encrypted/decrypted on the fly by the DAL using configuration data. The cipher, keys, and chosen data elements are all configurable within the SDP framework.

  • Caching - Data elements defined within the DAL-XML can be flagged as CACHED items which means the contents of the entire table will be loaded up into memory upon initialization. Should a change in data occur, the cache is reloaded a snapshot notification is sent out to all other participating servers in the SDP resulting in a reload across the entire fabric of servers.



Click HERE to contact a RevX Sales Representative for a demo!