DB Luminous™ Data Governance Management
DB Luminous™ is a web-based metadata repository that provides Business, Technical and Compliance leaders a uniform approach to effective data dictionary management. It provides organizations with the capability to plan a perfect data integration, data quality, data governance and other data management challenges and ensuring security of Data, all from a single interface.
A Web-based solution
DB Luminous is a web-based solution that analyzes the database schema as building blocks of functional data elements in addition to analyzing data relationships. DBLuminous manages these elements as Unique Data Element™ (UDE). UDE simplifies the complex modeling and normalization techniques that typically create layers of complexity for non- technology Stakeholders. The Unique Data Element methodology gives immense flexibility for Functional, Technical and Compliance Users to defuse all of the inherent complicated database data definition relationships.
Using UDE we strategically created multiple options to utilize building blocks of data to understand the functional operation of Enterprise applications, identify gaps in meeting Governance, Risk and Compliance (GRC) requirements and show anomalies in data element construction. The UDE methodology can be used to identify the proper dimensionality for dimensional modeling. Since we have consolidated the relational construct, it is easy to identify the dimensions required to analyze the relevant data.
Tactically, DB Luminous provides numerous ways to manage single or multiple database instances. Some of the options include Metadata change tracking, Impact analysis, Mismatch analysis, Redundancy analysis, Schema audit and Schema compare.
DB Luminous uses auto-alerts to provide active monitoring and proactive database management, resulting in better database control. With built-in access control, DB Luminous securely supports separation of duty for different user groups. DB Luminous tracks and records every change that affects data elements.
Companies managing data GRC requirements, supporting multiple life cycles of ERP, BI, Data Warehouse, CRM, Portal and Social Media needs across different Database environments with separate Change Management systems may discover significant value in using DB Luminous to create a Corporate Data Dictionary repository.
Benefits of DB Luminous
- Dashboard/Report Analysis
- Illuminous
- Comparative Analysis
- Audit
- Control
DB Luminous is complemented by a comprehensive dashboard that provides the user with the ability to instantly view the environment’s intrinsic details. The dashboard reveals a status of all data dictionary processes.
The initial stage involves a collaborative effort among the Stakeholders to define the data dictionary according to the company’s data Governance policy. The process involves closely working with users when building the information repository.
The comparative analysis feature is built to draw out the differences that exist between two databases and also ones that exist within a single data dictionary database.
The audit feature provides information about the changes taken place within the database/schema. The feature is also capable in locating the root cause if utilized effectively.
The control feature helps in identifying the role and access of users using the data dictionary.
Features of DB Luminous
- Data Development
- Metadata Management
- Data Quality Management
- Data Security Management
- Document & Content Management
- Data Warehousing & Business Intelligence Management
- Knowledge on modules & related tables
- Knowledge reference on dependent objects
- Overall information flow
- Functional analysis
- CRUD analysis
- Overall information flow
- Functional analysis
- Impact analysis
- Interface information
- Impact analysis
- Mismatch analysis
- Entity relationship diagram
- CRUD analysis
- Conceptual view
- Expose anomalies
- Entity relationship diagram
- Establish DQ process
- Establishing standards for database assets
- Schema audit and audit alerts
- Release management
- Database monitoring
- Easy maintenance of data assets
- Gap analysis on enhancements
- Less worry on team attrition and training
- New resources
- Submission of IT audit reports before time
Frequently Asked Questions
Microsoft .Net Framework 2.0 SP2 & above, SQL Native Client and MS SQL 2005 & above for Client version. Microsoft .Net Framework 3.5, IIS 5.1 (or) IIS 6.0 and Browsers like Firefox 3.0.7 or Internet Explorer 7.0 (Preferred).
Yes, DB Luminous can be configured to an application having multiple schema / database or databases from different applications. For example, if an ERP has separate databases for each of its domains such as Production, Sales, Accounts, and Purchase etc. then all of it can be configured under one application. DB Luminous will identify this as a single “schema set “. Extending the schema set concept, a schema set can be maintained for a database from multiple environments such as Development, Testing, and Production. This technique is very efficient for migrations and monitoring database across environments for consistency.
The limit to the number of database is based on the licenses purchased (DB Luminous is licensed for number of databases) and there are no limitations to the number of databases that can be configured as long the required licenses are available. However, there is a soft limit of 99 databases for a group to allow usability of the organization.
Yes. Reporting is the key component of DB Luminous. There are number of pre-formatted reports available as part of out of the box tool implementation. The latest information about the metadata will be available at runtime. Further, DB Luminous comes with a reporting engine, which can also be used to create additional reports similar to BI tools.
DB Luminous only stores the information about the metadata and does not retain the actual data content within a Database.
DB Luminous is designed to function without affecting the performance of the database and is not intrusive. DB Luminous connects to the application database, only on demand, to collect, track metadata and other statistics as required. DBLuminous does not use any sniffers that are triggers that cause performance degradation of the database.
Identifying the elements from disparate sources is the key aspect in designing an effective Data Warehouse. The performance and the effectiveness of the data warehouse depend on carefully choosing these elements to form the dimensions required for the data warehouse. Further, understanding the unique elements that have similar functional implications / meaning across multiple data sources are challenging in complex warehouse architecture. Building a metadata repository using DB Luminous (DBL) will provide the required knowledge of various databases and its elements. The Unique Data Element (UDE), Functional grouping features of DBL will allow you to group and analyze the elements of similar construct. These handy features significantly reduce time in creating a data warehouse. DBL is also useful as DW evolves to cater the constant requests from users to enrich the data. With DBL, it is easy to identify the source and granularity to enhance DW as needed.