Archive for the ‘databases’ category

Analytic Trends and Autonomy

May 4th, 2013 Leave a comment
Analytic Trends and Autonomy

One of the emerging ideas in Big Data handling is one of merging self-learning machines with autonomous analysis to create a sort of Star Trek computer for trends analysis and event-driven architectures. The possibilities are growing daily as technology improves and Big Data gets bigger. It may be possible for such learning machines to eventually formulate their own hypothesis regarding the data and present new ideas to business leaders on their own or even be authorized to act on their findings automatically. Currently, it’s possible to leverage information discovery in such a way as to detect relationships between what… View full post »

Big Data Overview Course: Why Everyone Should Take It

March 11th, 2013 Leave a comment
Big Data Overview Course: Why Everyone Should Take It

Google. Facebook. Github. Twitter. LinkedIn. Microsoft. Any of these names sound familiar to you? I’d imagine they do: they’re some of the many big names in the technology and web industry today, and they all share one very important thing in common: they’re processing terabytes, sometimes even petabytes, of data a day. This means they need a reliable, robust, and scalable network architecture that can meet the growing demand they have for data processing each day: a network architecture that includes services and software like NoSQL, Hadoop, BigTable, and MapReduce. Each one of these tools is a very specialized software solution designed… View full post »

Introduction to Graph Databases

August 23rd, 2012 Leave a comment 1 comment
Introduction to Graph Databases

Have you heard about Graph Databases? They are a new way of storing data that helps to show relationships between things or people instead of the traditional style of a relational database. These relationships are given a level of importance and can be used to determine other relationships that your items might have. This introduction should give you an overview of what they are about, things to look out for and since there are several ways that you can use graph databases in your application or site development, a jumping-off point to begin learning more about how… View full post »

MySQL Replication

August 19th, 2011 Leave a comment
MySQL Replication

You’ve finally done it: your MySQL database has gotten so large that it simply isn’t working on one machine anymore. You’ve tweaked it, you’ve optimized it, you’ve gotten it to the point where your system simply can’t read fast enough to accommodate the number of reads. Is it time to move to a NoSQL solution? Possibly, but even then, you’ll need a temporary solution to keep your site running smoothly during the transition phase! It’s time to add more MySQL servers to help handle the load. It’s time to use Replication! Replication is a great way to increase the amount of… View full post »

PHP & MySQL Best Practices for Rock-Solid Applications

March 11th, 2011 Leave a comment 2 comments
PHP & MySQL Best Practices for Rock-Solid Applications

PHP and MySQL are often the preferred technologies for building web applications because they allow you to build robust web applications very rapidly. This rapid development, however, sometimes leads to code that is hard to maintain, doesn’t scale well or performs poorly. Fortunately, there are a few things that you can do early in your application development cycle that will keep your application from developing problems. Follow these PHP/MySQL best practices to build rock-solid applications. Also, keep in mind in general that a bit of extra time invested upfront in keeping your code easily maintainable will save… View full post »

PostgreSQL 9.0 Offers Many New Features

December 10th, 2010 Leave a comment
PostgreSQL 9.0 Offers Many New Features

I’ve always loved PostgreSQL. It is my database of choice these days and I use it with both CakePHP and with the Django framework for Python. PostgreSQL has always had a very robust feature set and was one of the first truly ACID compliant open source databases. With the recent release of version 9, PostgreSQL has added a slew of requested features that truly put it above the rest. The biggest new feature in Postgres 9.0 is streaming replication. As many have noted, third party solutions for this have existed for some time but now there is… View full post »

Data Mining with MySQL – Finding Value in Numbers

July 24th, 2010 Leave a comment 1 comment
Data Mining with MySQL - Finding Value in Numbers

When it comes to full scale database analysis, many servers have integrated software packages such as SSIS for Microsoft and dedicated business intelligence tools from SAP, SAS and other forms. Analyzing data with open source technology however requires a bit more work when it comes to implementing an end to end Business Intelligence (BI) tool. While there are a variety of ways to export MySQL data into software packages that can handle modeling, it is important to understand how the process works and the technology required. How MySQL can work with PMML Working with broad patterns and intuition on raw database technology… View full post »

Optimizing MySQL Queries

May 28th, 2010 Leave a comment
Optimizing MySQL Queries

MySQL is a very capable database server. It powers numerous web sites and applications and is so widely used that it was etched as the “M” in LAMP platform. One of the reasons MySQL has become so popular is that it can be extremely fast, particularly in cases where data is primarily being read such as web sites. Even with all its strengths, it is possible for a developer to right a bad query that slows down the database or for the volume of data to reach a point where a normally speedy query becomes quite slow…. View full post »

MySQL Caching Techniques

April 5th, 2010 Leave a comment
MySQL Caching Techniques

MySQL is an incredibly powerful and robust database which is why it powers so many web sites and web applications today. However, even the best database often needs additional help to keep up with the high volume demands of popular sites or web applications. MySQL is no exception. One way that many developers squeeze additional performance from MySQL is through caching in order to reduce the number of queries hitting the database. There are a number of techniques for caching MySQL queries. Cache Types File-based Cache The simplest system for MySQL caching is a file based system. In… View full post »

Secure Your Database

March 12th, 2010 Leave a comment
Secure Your Database

What must one do to protect the company’s biggest asset – its data? That’s a frequently asked question today that has no right or wrong answer! The solution is based on a number of different variables, such as, what is your database vendor, what is the purpose of your database, does your database store credit card information, who manages your database, and others. Obviously, there is no single approach to securing your database. However, these are the general best practices utilized in he industry to protect a database system. Stay Up-to-date Be proactive in staying up-to-date on all current vulnerabilities related to the… View full post »

Understanding Database Vulnerabilities

March 11th, 2010 Leave a comment
Understanding Database Vulnerabilities

Database is one of the most integral components of any system, and keeping data both secure and accessible is a demanding task every business is facing today. One of the more recent trends in enterprise security has been the movement away from protecting the perimeter of the network to protecting data at its source. Today’s corporate environment must provide access to data not only to its employees, but also to partners and customers located on separate networks, potentially thousands of miles away. In order to protect the database system, one must first understand its vulnerabilities. In general, database… View full post »