DB LUMINOUS™

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.

DB Luminous Data Governance Management

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.

pexels-fauxels-3184287
pexels-mikael-blomkvist-6476590

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

Features

FAQ

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).
DB Luminous (DBL) is designed to be used on multiple platforms. DB Luminous is independent of the platform of the application and the database. Currently DBLuminous has the ability to support major databases that include Oracle, MS SQL, Postgres, MySQL, Sybase and DB2. However, DB Luminous requires .NET framework and SQL database to host the metadata.
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.

About Us

Primoris Systems is a global network of highly-skilled, diverse and multi-levelled company. We are among the very few players in the global IT industry providing customer centric services and solutions.