Explorer and Analyzer

While there are many tools available in the market that can explore a database, when it comes to analyzing a large database with thousands of table-field combinations and validating the results of queries done through front-end reporting, such tools come up short. Encrypting information for field-level Protected Health Information (PHI)/confidential data is a much-needed feature that is simply not available in the best of tools.

Explorer & Analyzer is a tool that CTech has developed that enables users to retrieve detailed database information pertaining to tables and fields. The tool also lets the users create joins between various tables and extract information in the form of reports from the database. This tool can be utilized for exploring any relational database such as Epic Clarity®, GE Centricity®, AllScripts® and more. The tool works for SQL Server® or Oracle® databases.

This tool has many features including the following:

  • The capability to rapidly narrow the tables and fields by typing keywords.
  • Information on the size of the tables in terms of rows and Kilobytes.
  • Integration with the Data Dictionary.
  • Visual Query Building capabilities.
  • PHI Management Module that can selectively encrypt/decrypt field-level information.
  • User Management Module that can assign Basic to Advanced privilege levels.
  • Inbuilt text file viewer that can view files as large as 5GB.
  • Rapid access, analysis, reporting and governance capabilities built into one tool.

This utility has been built on Microsoft .NET platform C#, SQL and with extra utility tools (Active Query Builder and DevExpress control) which give attractive user-interface with smoothness to the tool. C# has been used to create Windows client applications, XML Web services, distributed components, client-server applications, database applications, and much, much more. Visual C# provides an advanced code editor, convenient user interface designers, integrated debugger, and many other tools which make it easier to develop applications based on the C# language and the .NET Framework. SQL has been used to communicate with a database. It is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Active Query Builder is a Visual SQL Query Building component that allows end-users to build complex SQL queries via an intuitive interface. It also has an excellent SQL Parser to analyze and modify SQL queries programmatically and take full control over the user queries.

.NET includes the SQL Text Editor with code completion and syntax highlighting to suit the needs of experienced query writers. Active Query Builder offers a powerful means to tune the presentation of the database schema to simplify complex database structure for the end-users. DevExpress Control is a modern and flexible application framework that allows creating powerful line-of-business applications that simultaneously target Windows and the Web. XAF's scaffolding of the database and UI allows you to concentrate on business rules without the many distractions and tedious tasks normally associated with Windows and Web development. XAF's modular design facilitates a plug-and-play approach to common business requirements such as security and reporting.

Scroll to Top