• Enterprise meta layer for IT
  • Browser presentation of evolving schemas
  • Project team witness to database change
  • GDPR search tool
  • SOX API for COBIT reporting
  • Defend data breach
 
 
Get closer to your current, and evolving databases.
Introducing the DBA's Transparency Platform

We are IT Managers

We are still getting system failures caused by database schema changes. Our post-mortem reviews often conclude that the error was caused by a database change that "fell through the cracks".
Our DBAs have far too many schemas and database environments to keep everybody in sync with their changes, especially when their changes themselves have changes. There has got to be a DBA tool that does a better job at documenting and distributing schema changes to project staff.
Read more...

We are DBAs

Part of our job is to keep project teams informed of schema changes for application patches and upgrades. When we have many schemas, many database environments and many project teams, the task becomes formidable to say the least. Ideally, our documentation should always be in sync with our DDL scripts which themselves are usually having changes.
There should be a DBA tool that automates this task. We must find a way to stop doing this by hand.
Read more...

We are Programmers

Most of us have two modes of coding - one that creates job satisfaction and one that creates job frustration. We "love" to code when we are writing from scratch and developing a new solution. This is the creative process. The second mode of coding we call “grunt-work”, or those situations when we are chasing down some bug or performance issue. This is the inverse of creativity, especially when we find the root cause to be a schema change that we were not made aware of.
There must be some way to guarantee the process of keeping programmers up-to-date with the DBA's create, alter and drop operations on tables, views, indexes and constraints.
Read more...

We are Compliance Analysts

We need schema change documentation that is always in sync with DBA DDL operations. This should include before and after definitions of the creates, alters and drops on tables, views, indexes and constraints.
We should never have to depend on compile errors to figure out what changes were made during a patch or an upgrade.
Read more...
Reduce Risks and Costs
Net Change vs. All Change
Accelerate Compliance
Role Narratives
How it Works

Disrupting high software costs...

  • Project team access to thorough technical reviews of planned, deployed and histoic database changes accross the enterprise.

  • Rich web browser UI for project teams to Search, sort and compare current and changed database object definitions for object types that programmers care most about - tables, views, indexes and constraints.

  • Automatic email alerts to object create, alter and drop operations - without using database triggers and without connecting to the schemas that are being tracked.

  • Push back on new costs, slash traditional costs. Awesome new tools for systems research and impact analysis.

  • This software is available and there are two ways to use it right now. Use the live demo (AWS) on this website, or download your trial copy and be up and running in about an hour in your organization.

Watch Demo Video
Use Live Demo
Free Trial

Report "net" change, meaningful change.

  • In a single day, the DBA drops and re-creates a table 10 times until it fits the requirement. Should we keep track of all these changes? No! What we should do is keep track of net change... Schematrack's relational algebra captures the table definition at the end of the day minus the table definition at the beginning of the day. Net change means we can ignore most changes and it means we can provide useful presentations with before and after definitions that can be used accross IT initiatives. This is achieved with Schematrack’s periodic meta-harvest job for an unlimited number of schemas selected by the DBA.

  • What if a schema has 650 views to end the day and 600 views at the beginning of the day? Meta-harvest records Views Created(50). Reverse the equation for Views Dropped and add more detail to the equation for Views Altered.

  • All content is derived from system views - Schematrack never connects to schemas that are being tracked.

  • When DBAs provide this kind of transparency, they up their game. Likewise for project teams.

Watch Demo
Use Live Demo
View Sample Email

Tools for governance

  • GDPR search tool for structured meta data - "Show me all tables and views for PROD schemas with the name containing ACCOUNT that have a column name containing SOCIAL_SECURITY", etc.

  • SOX API for COBIT reporting - stored procedures fit your favorite reporting tools.

Watch Demo
Use Live Demo
View Sample Email

Section 4 stuff

SchemaTrack automates the periodic capture and persist of database object definitions for static and fluid RDBMS schemas. This content is the source for web application research, notification and governance tools that keep IT project teams compliant and up-to-date with their databases.

SchemaTrack invokes queries on system views without using triggers or agents. The full-stack software starts with batch job “meta-harvest” and ends with user and administration web applications. SchemaTrack can be installed on-premise or in the cloud.

Software Overview

SchemaTrack automates the periodic capture and persist of database object definitions for static and fluid RDBMS schemas. This content is the source for web application research, notification and governance tools that keep IT project teams compliant and up-to-date with their databases.

SchemaTrack invokes queries on system views without using triggers or agents. The full-stack software starts with batch job “meta-harvest” and ends with user and administration web applications. SchemaTrack can be installed on-premise or in the cloud.

Meta-Harvest

Meta-harvest is the iterative routine that records current and changed schema object definitions for object types that programmers care most about - tables, views, indexes, constraints, etc. Current definitions are objects found by the most recent meta-harvest whereas changed definitions are the creates, alters and drops occurring between meta-harvests. Meta-harvest loops through local and remote system views to determine this information for an unlimited number of schemas selected by the DBA.

SchemaTrack UI

SchemaTrack Web applications are browser software written in HTML/CSS/javascript with an ASP.net application service built on the MVC framework. All data access follow Controller API calls to stored procedures that are native to each RDBMS. These queries pull content from SchemaTrack’s own data layer (schema) and do not connect to the schemas that are being tracked. UI pages allow project teams to “watch” their schemas evolve via email alerts, drill-down search, sort and compare features as well as useful counts and summary links. Content is organized by RDBMS, schema, environment and "change-group". This automation guarantees that management, compliance analysts and programming staff get the best understanding of their schemas and are never again uninformed or "surprised" by database changes.

Change-Group

Change-group is SchemaTrack's lowest level grouping tag that mirrors release code or version number of the schema's front-end application. Typical values might be 1.0, V2.15.0.1, Rel2, etc.

Change-groups are declared by the DBA to organize schema changes with application upgrades and patches. Additionally, adhoc change-groups can be used with descriptive names such as "Refresh from PROD", "Hot fix for SalesReport error", etc. In all cases the schema’s evolution is made clear with change-groups sequenced in the way that changes are occurring.

About Meta-Harvest

To understand how SchemaTrack works requires some familiarity with meta-harvest and how/when it runs. The DBA can run it manually from the UI and can set it to run automatically via meta-harvest's schedule interval setting. The interval defines when and how often meta-harvest will run. Typically, meta-harvest interval is set to run nightly though it can be configured to whatever interval is needed. For example, for a schema in the DEV environment, meta-harvest might be set to run nightly which will consolidate the DBA’s daily changes, whereas the same schema in PROD might be set to run hourly or every minute to provide quicker notification of database changes.

Meta-harvest employs relational algebra to compress and simplify each schema’s evolution. To illustrate, suppose a simple schema has three tables, tbl1, tbl2 and tbl3. After some time, the DBA creates a new table, tbl4. This DBA runs DDL scripts throughout the day until he/she is satisfied that tbl4 is complete. The following morning, the only database changes that project teams will care about are that tbl1, tbl2 and tbl3 are still there and were not changed, and there is a new table, tbl4. Regardless of what DDL ran the previous day, meta-harvest will report net change as Tables Created (1). To achieve net change without compromising performance, meta-harvest’s nightly run captured the four tables in the schema, subtracted the three tables from the previous meta-harvest and recorded the difference as Tables Created. Reversing the equation provides Tables Dropped, and adding more detail to the equation provides Tables Altered. Though very simple, this example does illustrate how SchemaTrack determines most types of change for each of the schema object types.

 
 
 
 
 
Schematrack Pricing
60-Day Trial
Standard
Professional
Enterprise
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Software for all RDBMS *
$0
 
$379
/schema
SchemaTrack Sales
(888) 405-5110
SchemaTrack Sales
(888) 405-5110
 
 
 
 
 
 
 
 
 
 
Schema maximum
unlimited
10 schemas
100 schemas
unlimited
 
 
 
 
 
 
 
 
 
 
Technical support
60 days
1 year
1 year
1 year
 
 
 
 
 
 
 
 
 
 
Software upgrades
60 days
1 year
1 year
1 year
 
 
 
 
 
 
 
 
 
 
Cloud option - installation, deployment, monitor
$0
T&M contract
T&M contract
T&M contract
and maintenance **
 
 
 
 
 
 
 
 
 
 
 
 
 
 
* Annual license includes unlimited user seats. On-prem or cloud software is for Oracle, SQL Server, or both (similar to the live demo on this site). DB2 will be available soon.
** For cloud option details, please call SchemaTrack Sales, (888) 405-5110.
SchemaTrack Home
Watch Demo Video
Use Live Demo
Download Free Trial
 
 
 
 
Select RDBMSs
Standard
Professional
Enterprise
 
1 to 5 schemas
6 to 50 schemas
unlimited schemas
 
 
 
 
 
 
 
 
Oracle **
 
 
 
 
 
 
 
 
SQL Server **
 
 
 
 
 
 
 
 
DB2 (coming soon) **
 
 
 
 
 
 
Total:
$0.00
 
 
 
Paypal Invoice
** Annual license includes unlimited user seats. Customer renewal decision made each year.
SchemaTrack Home
Watch Demo Video
Use Live Demo
Download Free Trial
Videos Section, Under construction
SchemaTrack will be released in 2nd qtr. 2019
Free 60-day trial - inform your project teams...
Get ready to be happy. Today.
First Name *
Last Name *
Company *
Address Line 1 *
Address Line 2 *
Address Line 3
Phone Number *
Email *
Plan to deploy Schematrack for:
Reduce Risks and Costs
Reduce database maintenance costs, programmer research and impact analysis costs.
Gain Insight
Guarantee your project teams the ability to stay current with historical, planned and deployed database changes.
Stay Comprehensive
Automation to organize schema development - a single format for all RDBMS’s, all Schemas and all environments.
Stay Compliant
SOX API for COBIT reporting. GDPR search tool on structured meta data.
Defend Database Breach
Guaranteed alert to DDL injection breach.
Submit Registration
`
Learn more DB2 Section, Under construction
Contact Section, Under construction
 
SchemaTrack
Live Demo
Project User
DBA