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… Click to view full post.
Archive for the ‘databases’ category
Optimizing MySQL Queries
May 28th, 2010 Leave a commentMySQL 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…. Click to view full post.
PHP Interview Questions and Tips
April 24th, 2010 Leave a comment 1 commentSo you’ve been slinging resumes for a while and now you have an interview for an awesome PHP job. While part of the interview will be the typical job interview, you should also be prepared for a technical interview. Technical interviews are often given to determine how well you truly know the technologies with which you’ll be working. There are numerous books and articles to help you prepare for the job interview portion but very little has been said on preparing for a PHP technical interview. General PHP Questions The first type of questions you’ll be asking in a… Click to view full post.
MySQL Caching Techniques
April 5th, 2010 Leave a commentMySQL 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… Click to view full post.
Secure Your Database
March 12th, 2010 Leave a commentWhat 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… Click to view full post.
Understanding Database Vulnerabilities
March 11th, 2010 Leave a commentDatabase 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… Click to view full post.
PHP & MySQL Best Practices for Rock-Solid Applications
March 1st, 2010 Leave a commentPHP 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… Click to view full post.
