As the modern database continues to grow, its inherent feature set expands alongside it. More solutions allow remote DBAs and internal teams alike to solve business problems tied to cutting costs and improving efficiencies. However, with these solutions comes increased complexity surrounding database administration, and it falls on the shoulders of DBAs to understand and leverage the industry’s evolving technologies.
RDX is pleased to announce the launch of our MongoDB NoSQL database service offering. NoSQL architectures have been gaining an increasing amount of attention from the IT community. Many organizations now consider NoSQL offerings to be standard infrastructure choices for new database-driven application implementations.
When we compare relational and NoSQL Systems, one of the critical analyses we have to perform is data access mechanisms. As we’ll learn over the next few articles of this series on data access, the SQL language used by relational database management systems is much more feature rich and powerful than its NoSQL counterpart. This statement isn’t intended to sway readers to relational systems, it is just the author’s evaluation of both systems’ access languages.
Designing, building and maintaining highly available (HA) architectures is the key to providing end users with 24x7 access to mission-critical applications. From the financial services sector to higher education, organizations require their databases be online and readily accessible. When these critical applications become unresponsive or performance is hindered, the resulting downtime can have extreme consequences. With the potential for legal penalties, bad press, loss of customer goodwill and other repercussions looming, DBAs must constantly focus on ensuring their systems are highly available, quickly recoverable and protected from natural or human-induced disasters.
As the modern database continues to evolve and take on a more strategic role in business, the complexities associated with managing these environments grows as well. For database administrators, this changing landscape forces them to continuously adapt and grow alongside the database engine to properly design, support, and secure an enterprise’s critical data stores. Their in-depth knowledge of the infrastructures so crucial to operations make DBAs an integral part of not only day-to-day functions, but business decisions aimed at reducing operation costs, improving margins, and more.
Welcome back to part 2 of MDX Code Development for Beginners. In part 1, we looked directly at the basic SELECT FROM clause in T-SQL and converted it to the SELECT ON COLUMNS ON ROWS FROM which is the equivalent in MDX. In part 2 we will be looking into the different BASIC filters that can be introduce into the SELECT statement in comparison to T-SQL “WHERE” clauses.