Applications of Database Development to Gene Ontology

by Michael V
The Gene Ontology database is essentially a tool that those involved in the field of molecular and cellular biology utilize in order to both obtain information as well as share it amongst peers in an open community. The database located at http://www.geneontology.org/ contains an organized structure of genetic vocabulary, classifications, and information for those involved with genetic research to access. Not only does the database contain the information in a well organized manner, it is easily customized for an individuals needs through searches and multiple display formats for ease of the user. It also supports changes and additions to the database easily, as the members of the Gene Ontology Consortium continuously expand and update the genetic vocabulary. In essence the Gene Ontology projects represents the best efforts of people around the world to merge their collective information about genetic vocabulary with a well structured database that will standardize the formats that the data is shared in. The database itself is made from MySQL database that allows it to be easily worked with by programmers from everywhere in the world. read more...

Read more

Amazon Relational Database Services (Amazon RDS)

by Miguel V
The article I chose, Amazon Web Services Announces New Managed Services for Windows Developers Worldwide, talks about Amazon annoucing a new managed services for windows developers with the launch Amazon RDS for Microsoft SQL Server and ASP.NET called AWS Elastic Beanstalk. Business can use “Amazon RDS to offload the operational responsibilities of their MySQL and Oracle database.” The article also talks about AWS Elastic Beanstalk which gives developers “an even easier way to quickly deploy and manage their Java, PHP and ASP.NET applications in the AWS Cloud.” AWS works by having the user upload their application and it will automatically handle the deployment details of capacity provisioning, load balancing, auto-scaling, and application health monitoring. read more...

Read more

MySQL gets an upgrade from Oracle

by Ermie C
The one thing that has become in a business is the importance of databases. We understand how everything is and how it flows, however, the ease to make the SQL statements can get kind of hairy. For Oracle, they have launched this new version MySQL Cluster. This new feature is actually going to be open source and is a lot easier to use. The two new features that are provided are combing the best of both worlds of NoSQL and SQL databases. ” It can rival the fast key value operations of NoSQL, while still offering the ability to do complex queries of a regular SQL databases” is how they they described it. With the open source, it can prove to be a advantage in the sense that anything is possible for this type of SQL, however, this upgrade can prove fatal for potential hackers who can get the code of how databases are filled. The main feature that is going to be great is the Memcached API. This is because this will make searches and performances go faster and as mentioned Facebook uses this software. This will make the input of data a lot easier. read more...

Read more

The Future of MySQL

by Miguel V
The article I chose to talk about this week was “eWEEK Labs Ponders MySQL’s Fate Under Oracle.” In this article the author Jeff Cogswell gives his ideas on the future of MySQL, by factoring in sound business sense as well as history, now that Oracle has bought it for $1 Billion. With 11 million installations, MySQL has proven to demonstrate just how valuable the software can be proving that it is not just some “small, run-of-the-mill Open-source Package.” MySQL has become a serious competitor to Oracle’s database products especially even more now “in the down economy, with cash-strapped businesses increasingly looking to free and open-source software.” The article then looks at the history of Oracle’s pasted acquisition deals, for example, “in early 2007, Oracle acquired Hyperion, a maker of business intelligence products.” Jeff noticed that Hyperion software was integrated into Oracle’s overall product set while remaining largely intact. In general Oracle’s “acquired companies’ products did not go away but were integrated into Oracle’s existing product lines.” He wraps up the article by saying that “It’s very possible that the name will change, but, based on previous Oracle acquisitions, it’s doubtful that MySQL will disappear.” read more...

Read more

Anonymous Hacks Apple Server

by Jonathan N
This Article talks about how one of Apples servers were hacked into by a group named Anonymous. The group Anonymous broke into one of Apples less important servers which is used to process technical support follow-up surveys. The hack ended up revealing only 27 customer Apple User name and Passwords. Apple has made it clear that no personal customer data has been retrieved from the attack. Anonymous posted on their twitter account that they should not need to worry because they are busy hacking elsewhere. However, Apple immediately took the affected server offline just incase of any more risk. Lulzec, which is a former hacker group used a similar style of hack with the user name and password dump of the mysql database on the Apple machine. Lulzsec used SQL injections to pilfer information from Sony Pictures  and PBS, as well as the website of the Mosman Council in Sydney, Australia. Lulzec has made former claims that it has broken into Apples ICloud server by claiming, “After mapping their internal network and thoroughly pillaging all of their servers, we grabbed all their source code and database passwords, which we proceeded to shift silently back to our storage deck.” Apple has yet to make a comment on either attacks. read more...

Read more

Tips in using MySQL in AWS

by Jim J
The next generation of storing data is in cloud computing. Amazon cloud offers these kinds of services few things can be done to overcome most of the performance issues. Amazon uses elastic book storage (EBS) which appropriates network resources to its users and which has performance that varies depending on availability; this is their greatest weakness. Ways to mitigate this is taking advantage of the cache in browsers, objects, queries, and data. Many MySQL settings can be tuned for performance benefits such as increasing buffer sizes and even things like using a high-performance file system like XFS. In addition to performance benefits, DBA’s need to ensure data redundancy taking use of multiple data centers spread across the globe so as to have options for when a server goes down; recovery is equally important where DBA’s need to automate getting their servers back up and running. Some companies like Netflix even run programs that randomly take out servers during the day so as to test out their ability to stay on-line. read more...

Read more

MySQL Will Have Two Conferences In 2012

by David A
Oracle has announced on Thursday that the open-source database management system MySQL will have user-focused event conference Sept. 29 and 30 in San Francisco. In addition Percona will also hold an event next Tuesday in Santa Clara known as the Percona Live MySQL Conference. This is great news for users and developers of the application, because O’Reilly which hosted the last two annual events had decided not to host anymore. Percona’s event will be jam packed with technical presentations, review of user case studies and will have Marten Mickos the CEO of MySQL as the key note speaker. Oracle’s event will provide technology road maps and a chance to talk with Oracle engineers working on MySQL. Both conferences are going to be great, but many believe that most companies will pay to send their administrators to only one, so it would be nice to have Oracle and Percona combine and provide a joint event in the future. Yet, it is nice to see that MySQL is getting so much attention. read more...

Read more

Oracle, Keeping MySQL Users Happy

by Jongwoo Y
In 2010, Oracle went through with the buyout of Sun Microsystems, a company that was very popular for their open source applications such as MySQL and OpenOffice, for 7.3 billion dollars. During that time, MySQL users were outraged at the fact that Oracle would now have control over their open source products, especially since at the time, Oracle seemed to be hostile towards the idea of OpenSource technology (Pallato, 2011). However, contrary to popular belief, Oracle has actually treated their newly acquired product as a completely different line and have continuously updated their newly obtained OpenSource database management tool just as diligently as their own Oracle Database Management system. The biggest news that has come out recently is that Oracle has released an update for MySQL 5.5 that gives users of that program the same access to the 24/7 online technical support environment as the Oracle database (Pallato, 2012). This is huge because users of the free database software are able to receive the same professional support that many fortune 500 companies receive from Oracle. Oracle has taken a huge step forward with this new development in their customer service area due to the fact that thousands of users of MySQL are thrilled with the decision that Oracle has made. Though many people did not like the fact that Oracle had taken over their open source database application, Oracle is slowly, but surely showing these users that it was a step in the right direction. read more...

Read more

Joomla incorporates MySQL

by Ermie C
This article is about how the new edition of Joomla has now made it possible to use Microsoft SQL Server, PostGreSQL, and MySQL.  This multi-database support has become a great plus for business owners that use Joomla for their websites.  There won’t be as much hassle by being limited to just one database structure.  This is because the creators have only made previous Joomla versions to only incorporate MySQL.  However, with the new integration of multi-database functions, the use of PHP could allow Joomla to connect with the new database tools.  There’s a couple of new things they added also; the ability to incorporate a search engine function and something called stemming where it assumes the word that is being searched.   Then there is also auto completion.  In a nutshell, they have made the interface for Joomla, a lot more user friendly and this is what will attract new customers and keep the long lasting consumers of 1.6 million websites. read more...

Read more

SQL Server Alternative

by Jorge R
The main focus of my article is to explain the advantages from moving from SQL Server to MYSQL. The author starts by stating that he worked as a SQL Server DBA, and at the time there was no other program that matched Microsoft’s user friendly interface. As timed progressed he found MYSQL to be a database that could match SQL Server ease of use, reliability and performance. One of the benefits of using MYSQL is the running the program in a multitude of operating systems, with low computer resources and hardrive space. Another advantage of using MSQL is the use of storage engines. This allows the DBA to have a flexibility to have transactional tables, main memory, and compressed data. A point expressed by the article is the companies using MYSQL such as Google, Yahoo, and Facebook. Their performance and scalability is above and beyond their competitors. There are wide arrays of monitoring and tuning tools packed into MYSQL; they are trying to make their products as user friendly to use. The article states that there are multiple ways to transition into MYSQL. A method is to use a program made to convert SQL Server data into MYSQL data.  One of the most attractive features of MYSQL is the low costs. read more...

Read more

Not so Sweet for Team Meat

by Kevin Q
 

My article is on an event that took place last December. It involves a Video Game Developer know as Team Meat and their PC version of the game Super Meat Boy. Super Meat Boy is a single player game that tests peoples platforming skills(think Mario Brothers on Crack) and allows users to compete and place on leader boards for best times and earn achievements for completing insanely hard levels. Last December a user reportedly tried to notify Team Meat that their MySQL servers were not secure via Twitter. The users concerns were brushed off by Team Meat saying, “Trust me. It’s fine. I’ve done this stuff for awhile now.” Later that day their game was attacked by the users known as Anonymous. Leader boards became unstable, people couldn’t upload their data to the Team Meat SQL servers, and worst of all levels had their title names changed to write out not so nice sentences to the developer Team Meat. One sentence read across multiple levels reads, “This is why you don’t connect to a remote MySQL Database in your game.” Team Meat still tried to brush this event off as not being a security hole, but the fact that other paying users were strongly affected by this shows bad professionalism on their part. read more...

Read more