home

Articles

Blog

Books

Tools

Links

FAQ Page


iGuard



From the publisher website or publicity

Manages Application Users, Protects Systems - Automatically

Business intelligence and data warehouse applications are subject to unpredictable usage from growing numbers of people, all seeking quick access to better data. Unknowingly and inevitably, these users issue inappropriate, unauthorized, or "runaway" reports and queries that deliver inaccurate results, breach data privacy/governance policies or degrade performance of the entire system.

In response, Teleran offers iGuard, a patented predictive user governance and database protection facility, designed for use with business intelligence, data warehouse, corporate reporting, CRM and other enterprise applications. iGuard prevents a wide range of user problems commonly associated with application use. It protects the database from inappropriate and wasteful queries, improves overall system performance, enforces compliance and corporate governance policies and increases user productivity.

The Data Warehousing Institute

"The Data Warehousing Institute sponsors the annual Pioneering Product Award to recognize innovative solutions that will most likely revolutionize the practice of data warehousing. Teleran’s iGuard was the clear winner, having met TDWI’s evaluation criteria of innovation, usefulness, value, impact and uniqueness." - Steven Crofts, Senior Vice President, TDWI


 *Enforces data privacy policies at database object & row level
 *Prevents problem queries before they waste time & resources
 *Improves query performance & prevents user errors
 *Simulates & maintains service levels automatically
 *Point, click, test & apply query policies with policy wizard

Enforces Data Security/Integrity Policies at Database Object & Row Level

Driven by data privacy, security, and integrity regulations such as the Sarbanes-Oxley Act (SOX), the Gramm-Leach-Bliley Act (GLBA), and the Health Insurance Portability and Accountability Act (HIPAA), implementing and enforcing effective data security and privacy policies are more important than ever.

Database and application level approaches to enforcing data security are often inadequate and administratively costly. Database access controls are resource intensive, degrading application performance and increasing administrative overhead. Increasingly organizations authenticate and authorize users at the application level, and do not pass user IDs to the database. Without a means of identifying individual users, database access controls are rendered useless. On the other hand, building access controls into each and every application becomes prohibitively expensive and difficult to maintain as the number of applications grow across organizations.

Delivering a cost effective and centrally managed approach to enforcing data security and privacy policies becomes essential. iGuard Access Policies act as a database "firewall", managing access to specified schemas, tables, columns and rows by user, user group, role or application. iGuard works in conjunction with most single sign-on and application specific authorization and authentication programs and products. It delivers a consistent layer of security policy enforcement independent of application and databases.

Prevents Problem Queries Before They Waste Time & Resources

Acting as a "filter", iGuard screens each query as it travels on the TCP-IP network between any SQL-generating application and the backend databases. Unlike database governors, iGuard’s pre-emptive user governance facility functions outside of the database, examining and preventing user queries before they reach the database and impact valuable system resources and waste users' time and productivity.

iGuard Policies can prevent different kinds of user problems including inappropriate, unauthorized or inaccurate reports and queries. Information requests that violate an active iGuard Policy are either prevented or flagged for later analysis and a Teleran Automated Helpdesk message is automatically sent to user guiding them to improve the efficiency or effectiveness of their queries.

Merrill Lynch

"As our user community grows, iGuard policies have enabled us to guide and support more people at a reduced cost, maximizing the business value of our applications." - Joe Pomerantz, first vice president

Improves Query Performance & Prevents User Errors

Inevitably user errors occur as new data is added, or new users come on-line and are unfamiliar with the applications or the database. With iGuard Customizable Policies selected from the Policy Library you can prevent performance degrading query errors. And, using the iGuard "point and shoot" Policy Wizard, you can tailor policies to address query and reporting issues unique to your users, applications and databases. Here are several examples:


 *Do not do a SELECT from the claims table without a REGION code (Example: Regional claims analysts should never query claims history for the entire country)
 *Do not permit a join between TABLE A and B without column A (Queries issued without an indexed column are too resource intensive)
 *During the day shift, do not permit unqualified access to TABLE A and TABLE B, but permit such access during the evening and night. (Maintain peak period performance by deferring long-running queries to later shifts)
 *Do not join a fact table to itself (Prevents Cartesian join or "runaway" queries)
 *Do not allow a SELECT * from a fact table without a WHERE clause (Prevents unconstrained queries from consuming significant system resources)

Customizable Policies can also prevent user errors that generate inaccurate or misleading results. Here are some examples: 


 *Do not join two fact tables to each other without qualifiers (Prevents incorrect results)
 *Do not join TABLES A and B (Prevents a "Chasm Trap", a many-to- one-to-many join that results in incorrect answers)

Simulates & Maintains Service Levels Automatically

iGuard Performance Policies prevent queries that are predicted to run over a specified elapsed time or result set threshold before they reach the database. These policies are automatically created via Service Level Manager, a patented inductive learning process. An off-line process, Discovery produces and recommends new iGuard performance policies based on historical patterns of user behavior and system performance. 

As user patterns and system resources change, Service Level Manager Policies adapt to ensure that performance and services level expectations are met. Service Level Manager Policies can be placed in Test Mode for service level simulation before making them active.

Intelligent Enterprise

"Teleran’s system is an unmatched tool for dynamic query management. It provides analysis information, structural recommendations, and proactive query controls previously only dreamt of." - Martin Rennhackkamp

Point, Click, Test & Apply Query Policies with Policy Wizard

iGuard automatically maintains an awareness of the entire BI environment, including users, applications, query content, and back-end data structures. As a result, with iGuard's Policy Wizard you can simply point, click, and enforce policies that can be applied to any users, groups or applications to prevent user errors, enhance system performance and increase data level security.

All iGuard Policies can be placed in Test, Advise or Active modes. In Test or "simulation" Mode Policies do not block queries, but the system records and reports on which queries would have been acted upon, and how in-test policies could improve performance, accuracy or data security. Active Mode allows Policies to block queries when violated and simultaneously send the Automated Helpdesk message back to the user. 

In Advise Mode queries are not blocked, but users receive Automated Helpdesk messages associated with specific policies that will guide them in best query practices or remind them of the application, data usage or privacy policies in place.

Keywords
application management
BI
business intelligence
corporate reporting
CRM
data integrity
data protection
data security
data warehouse
database governance
database integrity
database performance
database protection
database security
database tuning
GLBA
HIPAA
privacy policy
query analysis
query management
query performance
query rules
resource management
Sarbanes-Oxley
Sarbanes-Oxley and data
Sarbanes-Oxley and databases
service levels
SOX and databases
system performance


Related Articles
SEC Proposes Years Exemption on 404
PortAuthority Goes Global
Sarbanes-Oxley Debacle
Republican Attack on Sarbanes-Oxley
COX - Sooner Rather than Later on SOX Reform
Centive CRM Award

Other tools that may interest you by area:-

Database tools

SQL Server tools

Security tools

Internet Security tools

IT Management tools

Vendor: Teleran


See our Sarbanes-Oxley compliance, load testing and Financial Glossary pages.
Articles   Books   FAQ Page   home   Jobs   Links   Reviews Page   Tools  
Booklist   books   Measurement   Testing   Tools