When we make decisions about products for In data storage environments, the DBMS (database management system) is the most important. Even though it is not the most expensive component, DBMS must be chosen carefully and with an active view of marketing issues and messages.
Photo credits: bowie15
The organization will create a culture around DBMS. Staff will be hired and trained to support you. It will become the main driver for the selection of hardware and other software, the organization's staff will attend to the user groups and interact with them using the DBMS.
If the data warehouse is successful, it will become a very large database and problems can become exponentially more difficult than with smaller databases. Some consequences of making an inappropriate selection of a DBMS son:
- Data quality becomes a major risk factor for the data warehouse.
- Poor query performance results in reduced usage.
- User trust erodes.
- Software costs, hardware and consulting increase.
- Inability to obtain real-time data.
- Inability to adapt to future data storage needs.
Criteria for a Data Warehouse DBMS Selection
The selection of the DBMS for the data warehouse is critical and, therefore, focus only on technology capable of supporting both immediate and future business needs.. In the Data Warehouse DBMS selection procedure, must be met 7 criteria:
- Scalability: It is necessary to look for consistency in the response behavior in relation to the growth of the database. At the same time, in terms of performance, it must be ensured that it is scalable for the number of simultaneous users and the complexity of their queries.
- Can: the DBMS it should be able to support complex decisions in a multi-user mixed workload environment. Dynamic prioritization, conditional parallelism and causes of variations in implemented parallelism, or the maturity of the optimizer to support each type of query with good performance are some of the things you should check before selecting.
- Availability: a good selection of DBMS supports mission-critical business applications with minimal downtime. In the decision process, You will also need to understand the system downtime requirements and any issues that may deny or degrade service to end users., as updates, batch loading times, maintenance interruptions or serious performance problems. of the system.
- management: the ideal option is to find the answer that provides a single point of control for system administration. An extra seeks to guarantee minimal support tasks that require the intervention of a database administrator.
- Cost: Decidedly, the final choice will depend on the budget, although, as a general rule, always recommended focus on alternatives that ensure a lower total cost of ownership for a period of several years in terms of hardware, software and services
- Scalability: the best option is the one that provides a flexible database design and system architecture that can adapt to the pace of ever-evolving business requirements, leveraging existing investment in hardware and applications.
- Interoperability: Integrated access to the web, internal networks and corporate services would be some of the characteristics that should be paid attention to finish outlining the ideal destination of the investment in DBMS.
Are you clear on how to select this key component for your data warehouse??