Database

Using Object Oriented Programming in your Database Applications {1}

by Leonardo S
The article I chose for this week is titled “Effective Apply of Design Pattern in Database-Based Application Development” written by Hao Dai. The main purpose of the article is to give guidelines on creating database based applications that are fully optimized to run smoothly. The author suggests that using object-oriented programming effectively is a good way to give your application the structure it needs to be easily maintainable. One example of this is to keep your database interactions in one class in your program. Making sure your application follows this strict design pattern will make it much easier to understand for your and for others who need to read your code. The author says this will also improve the scalability of the whole application and it will reduce the coupling between software modules. read more...

Developing A Database-Backed Web Application {1}

by Kathy S
Database-backed applications generally use structured data where output via different parameters such as subject or material type is desired; enable searching of the data by various parameters; manage constantly changing data; and allow the reuse of information in different contexts and pages. The author of this article journal focused mainly on the important things to consider when building a database-backed web application. The long list is as follows: Planning (deciding what you want, get everybody on board, think big, start small), Define the System, Develop a Data Model, Define Interactions, Define the User Interface, Implement (select a hardware platform), Select a Data Management System, Select Development Tools, Coding, Production, Issues (Data backups, data integrity), Security and Communication. When it comes to planning it is important to identify the persons who will fill various roles in the project: Project coordinator, data users, designer, database administrator, developer/programmer, and testers. Also, Data modeling is considered the most critical part of the entire process and one that is too often overlooked according to the author. The designer will save a lot of time and avoid many problems and frustrations by focusing on proper data modeling before attempting implementation. The article goes into much more detail for each of the points listed. I’d recommend reading the entire journal article to understand the whole process. read more...

An Online SQL Database {2}

by Shigom H
ZohoDB is one the first online database next to ZabbleDB. It is becoming a popular database management tool, allowing users to create a database that supports any SQL format. So it doesn’t matter which format you are using to write your queries.(SQLServer, MYSQL, Oracle), ZohoDB is able to process it. However it only allows Select statements. Hopefully in the future ZohoDB will be able to handle more different type of queries. ZohoDB even offers visual queries to make it easier for users who are not accustomed to writing regular queries . ZohoDB has a similar structure to an excel spreadsheet and allows users to implement formulas into different columns and create pivot tables. One feature of ZohoDB is that  user created graphs and charts are given static URLs and can be embedded into other websites.  The article “Zoho DB Launched” by Richard MacManus covers more of these features in detail. read more...

New Software to Extend Database Virtualization {Comments Off on New Software to Extend Database Virtualization}

by Tseng H. K.
The article I read this week is “Delphix 3.0 Extends Database Virtualization Platform with Microsoft SQL Server and Oracle RAC Support” from PW Newswire on October 15, 2012. The author wrote this study to announce Delphix who is the leader in agile data management industry, has announced their new version of virtualization platform, Delphix3.0. With their lastest release, the company can virtualized almost 60% of the current relational database market. To brief learn about company Delphix, Delphix is a company that enables agile data management through their software, and delivers business application to their customers quickly at lowest costs. read more...

Client/Server Architecture on the Mobile Platform {1}

by Eric C
When it comes to creating mobile apps for smartphones, such as for Apple iOS or for Google’s Android, such apps need to be created based on the client/server architecture. Many of today’s apps require the use of internet or cellular data to access information requested by the users. Each command or query initiated by the user is then sent back to a web server, then to a database for processing, and finally the information is sent to the user. In an article written by Anthony Kosner from Forbes, he talks about how the speed of Siri and Google’s Voice Search relies on the client/server architecture. Apparently both Siri and Google’s Voice Search relies on a server architecture to send data back for processing. The way Siri works is by saving the spoken command to a compressed audio file and is sent to Apple’s servers for processing. From there, Apple’s servers do the major processing and the results are then sent back to the user a compressed zlib binary plist (simply a binary/text file). Google’s Voice Search uses a similar method as well. Since the requests are processed on the server, it is important for database designers to efficiency design the server and database to handle a plethora of requests. Not only does the performance is affected by the server, so is the type of cellular connections used on smartphones. As a result, the client/server architecture is a very important consideration when designing web-based databases. Speed and efficiency are what customers look for and if it’s not there, several competitor apps are available. read more...

A New Teaching Approach for Database Application Development {1}

by Garcello D
The article I decided to week’s blog about is titled “Centralized Project-Based teaching Approach in Database Application Development Training”, which was written by Gaoyan Zang on June 29 2010-July 1 2010. So based on the title the article is about a new teaching approach which has been proven by fact to stimulate the enthusiasm of students, improve learning efficiency, and to make performance evaluation more efficient and fair. The intro of the article basically explains how the information technology field is growing and how due to the fact that it’s growing we need fresh new talent to innovate in it. The problem is that this fresh new talent can come from fresh graduated students but the problem with that is that the companies do not hire fresh new students because they require real project experience. This teaching method is different from your average lecture or laboratory courses, it requires the students to complete a task in a certain amount of time without the distractions from any other courses, they have a specific goal they should meet and thus they are achieving targets by meeting those goals. The students will experience something very similar to future real work situations where they will be assigned a project task and will have to analyze the need, outline design and detailed design, to code, to test, to implement, and to do maintenance and so on. Although in the real world the distribution of these jobs would be more specific, the author beliefs it is best for the students to experience the entire package. read more...

Dozens of College Servers Breached by SQL Injection {2}

by Eric C
Not only is the design and performance of databases an important aspect in the way databases work, but also the security of a database. There are many types of attacks that can be done to a database and the most common is a SQL injection. In a news article from CNET, hackers were able to collect thousands of personal data of students from college databases worldwide through the use of SQL injections. More than fifty universities were affected, and some of the top name colleges include Harvard, Princeton, and Stanford. To make matters worse, some 140,000 records were posted online for all to download. The information includes usernames and passwords, addresses, phone numbers, and some payroll information regarding both students and faculty. The mastermind behind this data dump is apparently by a group called GhostShell, whose intent was not to reveal personal data, but was to “focus on higher education.” However, the group not only found personal data, but also discovered that malware were already injected in the first place, showing the security risks many of these database servers have. read more...

Database Security: Oracle or SQL? {Comments Off on Database Security: Oracle or SQL?}

by Asim K
In her 2010 article titled, “SQL Server Most Secure Database; Oracle Least Secure Database Since 2002”, Laura DiDio explores the security and vulnerability of the two leading database systems out: Oracle and SQL. Quite from the beginning, meaning the title, Laura explains how the SQL database is more secure than Oracle – and not just by a tiny margin. During an eight and a half year period, from 2002 to 2010, the NIST CVE (National Vulnerability Database) statistics recorded 321 security related issues for Oracle, the highest of any vendor. This was six times more than that reported of SQL server. DiDio explains that SQL’s unmatched security is not a fluke or luck of draw, it is rather a direct result of Microsoft’s investment in the Trustworthy Computing Initiative, an initiative launched by Microsoft in 2002 where they stopped code development across all product like the scrub the code base and make their products more reliable and secure. read more...

MySQL over Microsoft SQL Server {3}

by Shigom H
After several hours of reading Microsoft support articles on how to install Microsoft SQL Server 2008 on my machine, I finally got everything to work.  However, for the amount of time sacrificed I wanted to find some significant differences between MySQL and Microsoft SQL Server.  To my surprise, I found out that MySQL 5.1(150MB) is about the same size as Microsoft’s  .NET framework,  a necessary component in the installation of  Microsoft SQL Server 2008(2GB). A possibly bias article entitled “Why Move to MySQL from Microsoft SQL Server” written by one of MySQL’s director Robert Schamuer,  makes a strong case for MySQL. read more...