Skip navigation.

Chris Foot

Syndicate content
Remote DBA Experts Blog
Updated: 15 hours 51 min ago

Database manufacturers include JSON in latest provisions

Tue, 2014-09-09 10:13

JavaScript Object Notation has been lauded as one of the most easy-to-understand programming languages available, and has been a boon to professionals managing Web-based data. 

Database administration services and Web developers alike favor the language when handling complex information, because it's easy for people to read and write, noted. Programmers are often fans of its affiliations with conventions found in C, C++, Java, JavaScript, Python and other code versions. JSON is constructed on two foundations:

  • A list of name/value pairs, which is known in other languages as an object
  • An organized list of values, also called an array

Why add JSON support to databases? 
Unstructured data, a type of information that is ubiquitous in the current Digital Age, needs to be stored in documents, which is exactly how JSON manages data. Many NoSQL databases such as MongoDB, Couchbase and Hadoop abide by this protocol, which has made it a favorite among Web developers, InfoWorld noted. 

In order to compete with such architectures, software giant Oracle added a JSON support to the company's Oracle 12c databases, which were outlined at the NoSQL Now conference in San Jose, California last month. This is a break from the conventional relational database management system architecture, but it's presented as an alternative to PostgreSQL, which has been regarded as the open source alternative to Oracle. 

Is it a valid option? 
Still, DBA services may advise their clients to keep using Oracle 12c for tabular data and conventional NoSQL solutions for semi-structured information. InfoWorld acknowledged how the latter contingency abides by a "scale out" protocol as opposed to a "scale up" approach. 

Scaling out enables NoSQL solutions to leverage commodity servers as a way to enhance performance as opposed to bulking up a massive database server. In addition, the way a document-based database allocates information makes companies highly resistant to failure because the data is distributed across multiple servers. 

When will the day come? 
InfoWorld classified modern databases into three types: 

  • RDBMS, which handle structured data
  • NoSQL, which manage semi-structured information
  • Hadoop, which organizes unstructured data

The source proposed an interesting situation, that all three systems be synchronized into a single solution. JSON could potentially provide a structure for just such a database, but it's unknown whether Oracle, IBM or another tech company would be able to successfully develop it (the profits for said enterprise would be huge).

Yet, it's more likely those in the open source community would manufacture a database capable of seamlessly handling structured, semi-structured and unstructured data. Just look at how monumental Hadoop has been. 

The post Database manufacturers include JSON in latest provisions appeared first on Remote DBA Experts.

Getting the Whole DB2 package, Additional Services Series Pt. 8 [VIDEO]

Mon, 2014-09-08 14:09


Need to give your databases a boost?

Hi, welcome back to RDX! If your organization's handling large, data-intensive workloads, IBM's DB2 for Linux, Unix and Windows is an attractive alternative.

RDX has worked with DB2 since the beginning, and our DB2 solutions are architected to provide a superior level of DB2 database support. From day-to-day operations to strategic decision making, our DB2 solutions arm customers with the experience, skillsets and best practices required to maximize their critical DB2 environments.

RDX also provides support for IBM’s IMS product set which offers the availability, protection, performance and scalability companies need to process online transactions.

Thanks for watching, and be sure to refer to our company resume for more information on our DB2 and IMS services!

The post Getting the Whole DB2 package, Additional Services Series Pt. 8 [VIDEO] appeared first on Remote DBA Experts.

How REST marries unstructured and structured data

Fri, 2014-09-05 10:19

In regard to big data, the majority of the information produced by enterprises and consumers alike is unstructured, meaning architectures such as MongoDB and Hadoop must be utilized.

This has created a schism between structured and unstructured data. Combining the two requires database administration professionals to query relational and non-relational architectures disparately so that analysis tools can consider the information simultaneously.

Representational state transfer application programming interfaces offer somewhat of a solution to this problem. For those who are unfamiliar with the technology, REST and API are two separate infrastructures. According to TechTarget, the former operates over HTTP to read specific websites containing Extensible Markup Language (XML) files. In turn, APIs provide a set of protocols and tools for building software applications.

Therefore, it can be deduced that REST APIs are utilized to develop programs capable of reading information on Web pages, but how does this impact a DBA’s ability to combine and process both unstructured and structured data?

First, it’s important to scrutinize what REST is typically used for. TechTarget noted the architecture is used to provide functionality to social networking channels, mobile applications and business process automation. On the surface level, it would appear skillful database experts would program REST APIs to segregate information the same way Hadoop does and organize them into relational databases, but given the availability of the open source project, doing so isn’t necessarily practical.

A shot of Espresso 
One startup in Silicon Valley claims to have found a solution to this conundrum. Database Trends and Applications noted Espresso Logic created a new program that combines big data and SQL information into one cohesive REST API for fabricating the backbone of Web and mobile software.

The REST API provides professionals with real-time access to MongoDB and SQL databases and eliminates the need to replicate data across sources. Security and business logic, two essentials in today’s IT economy, are included as a part of the package.

“This is our attempt to allow companies to join this data together in a common API. People can do that manually but it takes a very long time. This is basically point and click in most cases, and in some cases writing just a few lines of JavaScript code is all it takes,” said Espresso Logic CEO R. Paul Singh, as quoted by the source.

For analysis’s sake, developers could use Espresso Logic’s solution to aggregate and process information much faster than they could before.

The post How REST marries unstructured and structured data appeared first on Remote DBA Experts.

Throw Away Out-of-the-Box Monitoring Solutions, Additional Services Series Pt. 7 [VIDEO]

Fri, 2014-09-05 08:24


Welcome to RDX. Today, we're going to talk about how we deploy our non-database server monitoring program. What's a non-DB server? The machines that run your enterprise applications, handle network connections and perform other critical functions.

When customizing server monitoring solutions, we follow a five-step process:

One: Understand each customer’s unique monitoring needs
Two: Identify critical monitoring parameters
Three: Develop thresholds, goals and objectives
Four: Develop and document monitoring, remediation and escalation procedures
Five: Monitor and adjust the strategy as necessary

RDX dedicates an entire team who are responsible for creating, implementing and enhancing a strategic blueprint for the proactive monitoring and trouble-shooting methods required to prevent availability and performance problems before they occur.

Companies employing RDX to support their environments do not have to spend the additional monies required to create a proactive monitoring environment.

Thanks for watching!

The post Throw Away Out-of-the-Box Monitoring Solutions, Additional Services Series Pt. 7 [VIDEO] appeared first on Remote DBA Experts.

Access Your Data Sources by Opening the GoldenGate: Additional Services Series Pt. 6 [VIDEO]

Wed, 2014-09-03 12:01


In order to analyze your data in real-time, you need an architecture that operates at the same pace.

Hi and welcome to RDX! If you're using multiple database systems to store your information, you know how much of a pain it is to combine all that data.

For this reason, RDX offers expertise and support for GoldenGate. GoldenGate provides data capture, replication, transformations and authorization between heterogeneous sources.

This means information stored in PostgreSQL, IBM DB2, and several other systems can be seamlessly aggregated in a single instance. Capturing and delivering data has never been easier!

Thanks for watching! Be sure to join us next time.

The post Access Your Data Sources by Opening the GoldenGate: Additional Services Series Pt. 6 [VIDEO] appeared first on Remote DBA Experts.