SQL

Relational Database 101 {2}

by Kathy S
For those students who have no prior experience or knowledge of database design, this is a great read for you. The author of the article explains the introductory terms and information about how data is organized and represented in a Relational Database. The following are the basics one needs to know. In a relational database, data is stored in a two-dimensional matrix (table) and within the table there are multiple columns and rows. Relational Database Management System (RDBMS) software is used to give ability to users to read and manipulate data. The RDBMS relies on SQL (Structured Query Language) constructs and keywords to access the tables and data that is contained within the tables’ columns and rows. It clarifies that each table in a relational database contains information about a single type of data and has a unique name that is distinct from all other tables in that schema (a grouping of objects/tables that serve a similar business function). The author points out the key to good relations. The primary key is very important; it is a column that ensures uniqueness for every row in a table. The author then explains how a relational database connects (relates) tables and organizes information across multiple tables. The foreign key is an important connector that identifies a column or set of columns in one table that refers to a column or set of columns in another table. The author then states that the key to understanding relational databases is knowledge of data normalization and table relationships. The objective of normalization is to eliminate redundancy and thereby avoid future problems with data manipulation. There are 5 most commonly accepted normal forms, but many programmers, analysts, and designers do not normalize beyond the 3rd normal form,  although experienced database designers may. The author goes on to talk about what 1st, 2nd, and 3rd normal forms look like. Lastly, the article mentions how SQL fits in. SQL helps to create new data, delete old data, modify existing data, and retrieve data from a relational database. read more...

mySQL, NoSQL, and now NewSQL? {4}

by Eric C
In today’s fast paced world with data growing at an exponential rate, a database must be scalable and perform well with today’s demands in storing data. SQL databases have been around for decades and the basic architecture wasn’t created with scalability in mind. Apparently there have been new advances in database technology and it includes instances of NoSQL and NewSQL. Michael Stonebraker is a seasoned database creator who is now a chief technology officer for VoltDB, explained the benefits of using “NewSQL” to better benefit today’s demands for database performance. Stonebraker stated that traditional SQL systems have many limitations and that includes performance. SQL databases are also not scalable onto more than one server. If one were to make an SQL database scale onto more servers for better performance, it would be very complicated to manage. NoSQL was indeed created to improve on scalability and is increasing in popularity; it also has its own limitations as well. The main problem with NoSQL is that it cannot perform complicated mathematical queries. However with NewSQL, it improves on all of the issues with SQL and NewSQL, making it a more efficient database system that can process requests faster and can scale to more than one server. According to Joab Jackson, the author of the article entitled “’NewSQL’ Could Combine the Best of SQL and NoSQL” from PCWorld, using NewSQL “can execute transactions 45 times faster than a typical relational database system” and “can scale across 39 servers, and handle up to 1.6 million transactions per second across 300 CPU cores” (Jackson). read more...

An approach of learning database modeling {2}

by Phuong H
In the article “The Essential Skills of Data Modeling,” the author mentions that “the purpose of database modeling is to capture reality” therefore, it is more important for designer to understand the business concept rather than focusing on designing the model. It is because they can have a really nice database model but the important is can it be used to answer a business question, like the author stated “a model that fails to represent reality is likely to fail at some point because a client’s question cannot be converted to SQL” (Watson, 2006). Furthermore, the way you represent the model is not important the key is that the model can capture the reality (Watson, 2006).  The author also mentions a few errors that student usually make when they learning about database modeling: “not recognizing that an attribute is an entity, failing to generalize several entities as a single entity, not reading relationship both way, ignoring exceptions that result in a failure to represent reality” (Watson, 2006). The author proposed that integrating SQL while teaching database modeling will help the student learn better because they can see how SQL related to database modeling. read more...

Sessions What is it {6}

by Michael M
When we were doing the project this past week I heard a bit about sessions and I really did not get what it was all about so that is what I am going to do my article abut this week so I can learn a little more about what session is and what it is all about. Session is kind of like a cookie but is actually not stored on the users browser like a cookie would do. A cookie can keep a lot of information such as user name and password so when you use session it does not keep the information. It is like a token it alles access and passing of information while the user has the browser open. But once you close the browser you will lose the session and will have to re log in when you come back to the site because your information is not stored on the computer. read more...

SQL Databases: Oracle9i Database {1}

by Jonathan N
This Article written by an Anonymous person on Pcmag.com  talks about the different databases and which one he believes takes the so called “Blue Ribbon” as the overall winner. He emphatically mentioned that Oracle9i prevailed thanks to its superior feature set, reliability, and performance. He mentioned how Oracle9i offers the most advanced management and performance tools, and how it topped the other products on our throughputs tests.  However the downfall of Oracle9i  is that it is much pricier than the its competitors. It also mentions that it is less proprietary. read more...

Help with SQL :) {2}

by Abel R
My article is called Easing into SQL and it talks about how tedious writing code can be. The article mentions common mistakes such as logic errors and typos and it also mentions how you can create most basic statements in the query design grid using Microsoft Access. When using Access you can produce an equivalent SQL statement for every query, and you can use this to your advantage. You can click the View button and choose SQL View and Access will display the query’s equivalent SQL statement. This can be very useful if you;re having trouble with SQL statements and don’t feel like producing it from scratch. read more...

Amazon Web Services Announces New ASP.Net Services For Developers Worldwide {Comments Off on Amazon Web Services Announces New ASP.Net Services For Developers Worldwide}

by Toan T
This article simply talks about what Amazon has recently announced about their implementation of a new service for Windows developers along with the launch of their new database services for Microsoft SQL Server and ASP.Net support of their proprietary cloud service known as Elastic Beanstalk. Amazon RDS purpose is to remove the complexity of deploying and managing databases and makes it much more simple and easier for developers to set up and operate relational databases by only managing administration tasks because developers can now just upload their application and Elastic Beanstalk will automatically handles the deployment operations. Elastic Beanstalk is also built upon ISS 7.5 software stack so existing ASP.Net applications can easily be deployed with very minimal changes in the code which saves time and money. Elastic Beanstalk is free for everyone which other premium features that customers can choose pay for it if they need to. It is also very easy to get started, AWS simply has it own toolkit that will work with Visual Studio or AWS Management Console. read more...

What to do With Too Much Data {2}

by Tyler K

In the article, the author discusses how the modern database often extends beyond a few hundred entities; modern day companies regularly are wading through terabytes of information, trying to drag useful & meaningful context out of massive loads of information. Several massive problems are brought up – searching through the data is tedious and yields irrelevant results, metadata could vary in the usefulness and the context might not be comprehended by others, attributes could mean the same thing but be sorted separately (ex: Mac, Macintosh, Apple Computer, iMac could all be different ways to describe the same product), and it is very difficult to standardize the data and determine who regulates and incorporates the standardization – and if it’s even worth the time to do so. Thus, the solution offered is simple – relax the standard. Let there be a little differentiation, and create unified product descriptions that can catch multiple ways of describing the same object, determine responsibilities for who is going to ensure data integrity. Even then, there is no hard solution, and the conclusion is that there must be a future implementation of database management systems that can form patterns and relationships with data, have well-documented information on where data is originating from, and develop a system to understand how much is being lost by inaccuracies in the data. read more...

Windows Phone 7 Cloud Usage {2}

by Michael V
The journal writes about how the current applications of the Windows Phone 7 is expanding in terms of applications being developed for it, to the point where cloud usage enables great advantages when used as a database for the application. Through the use of cloud services, users can store and access data off their phones, which have limited amounts of data storage capacity due to the focus on mobility. Because nearly all smart phones have access to the internet at all times, they can off put the strain of storing data onto foreign servers, and applications are quickly being developed to take advantage of this new necessity for Windows Phone 7 users. In order to create a proper application that allows users to transfer and access their data through a database, developers are currently using SQL as part of their architecture to support the large number of users that their app will bring. Data travels from the phone, to a Load Balancer, to a Web Service, to SQL Database Passive, to SAN, and vice versa. Windows Phone 7 developers will utilize SQL Azure as their primary database because of the lack of necessity to worry about the infrastructure. read more...

SQL Injection Attacks {4}

by Abel R
SQL injection is a technique to attack a database through a website. SQL injection attacks are when an attacker attempts to or succeeds in inserting their own code into a pre-existing query (e.g. a product search). The aim is to get the application to perform an action that is unexpected and usually of benefit to the attacker(Morgan 2006). read more...