Database Design and Development

Database Performance Innovations {1}

by Kevin S
This week I read the journal article called “Revolutionize Database Performance”. This article focuses on 7 innovations that the author feels will revolutionize data warehousing. These 7 innovations are important because RDBMS platforms, which had worked well in the past, have struggled since they were not designed to query against the large amount of data that businesses have today. The seven innovations he discusses include: column store architecture, aggressive compression, multiple sort orders, automatic database design, recovery by query, concurrent data loading and querying, and standards-based appliances. According the author, adopting new approaches to RDBMS design will allow detailed searches to be processed 50 or 100 times faster and at a fraction of the cost. read more...

Big Data and Language: How do they relate? {Comments Off on Big Data and Language: How do they relate?}

by Asim K
In an interview between WIRED.com and Martin Wattenberg, a mathmatician and computer scientist at IBM’s Watson Research Center in Cambridge, Wattenberg expresses the importance of “Big Data”. Wattenberg specializes in large texual data sets, meaning that he focuses on terabytes of language. Wired.com peruses Wattenberg’s brain in inquiring why is he so captivated by reading such data sets – Wattenberg points out the importance of language. Language is one of humanity’s core mediums in which we are able to read, explore, and encode our identity as human beings, much like the blog post I’m typing right now. For example, one may have a database in the petabytes of words, literature, books, and yet we can see that even twelve words from voltaire, and example given by Wattenberg, can hold a lifetime of experience. And so when there are petabytes upon petabytes of information to analyze, Wattenberg has created a visual representation of everyone’s favorite quick-information website: Wikipedia. The visual representation assigns a color to each word in the dictionary and then maps out the usage amount of each word – this helps Wattenberg analyze data easily. read more...

Cloud computing the new big companies business? {3}

by Claudia J
The article that I read about was about the fact that Oracle announced the launch of their new IaaS cloud computing service. The company’s CEO Larry Ellison affirmed that the company will have a new cloud infrastructure service during the company’s earnings call. This new service is said that will allow the customers the access to a secure virtualized computer power hosted in an Oracle data center. This new service will also bring other business to Oracle since this new product will also allow them to sell customers software to build “identical services” in their own data centers. All these new products are mainly created to allow them, the customers, to move workloads back and forth between their private clouds and them. read more...

Disecting Relationships {5}

by Kevin S
It’s becoming clear that Entity-Relationship models can be just as complicated as Human-Relationships. Fortunately, the journal “Improving Database Design through the Analysis of Relationships” is here to shine some light on the subject. This journal quickly covers all of the basics and dives into a detailed study of relationships. They cover such sticky situations which are often not divulged deeply in textbooks such as high degree relationships, derived relationships, and several more. The four aspects they use as a guide to analyzing a relationship are as follows: read more...

DATA TRIGGERS {1}

by Claudia J
The article that I read was about the good and bad things about MySQL triggers features. The article first explains the reader that triggers is a named database object that is associated with a table that becomes active when an event occurs for the table. Programmers use triggers as a way to perform checks on the values that are being inserted into a table. It ensures that the data complies with the standards that the fields have set such as calculations on values that involve an update on the data being added to the database. The triggers can be set to activate before or after an inset, deletion, or update has been done in a table.  All the information of the database triggers are stores in a triggers table called INFORMATION_SCHEMA database. read more...

Big Data and Credit {1}

by Sam T
This article, “Big Data for the Poor” presents that lenders are now able to better determine borrowers credit score. ZestCash aimed to move past the 40 year old system of how lenders determined a borrowers credit score by looking at many other variables such as, the area the borrower lived in to giving up a prepaid cell phone. Many borrowers are poor in data because they have not established long enough credit history or work records. read more...

Predicting Missing Data {3}

by Kevin S
It may be difficult to translate data in databases which are missing values into useful information. In the article “Prior Knowledge: A Predictive Database For Developers”, Alex Williams discusses how the Prior Knowledge company has decided to tackle blank data. They have released a new Veritable API which, in short, looks at the stored data and intelligently predicts and fills in any blank areas. The hope is that this new technology will allow database developers deploy new applications which can predict the values of these blanks and help turn their data into useful information. read more...

Cloud Computing and Businesses {2}

by Sam T

(Howstuffworks.com)

This article presents five points for businesses to invest in cloud computing. The first point is the lower cost of ownership. Instead of maintaining an onsite server, the businesses’ data will be stored somewhere else. Other reasons are the dependability of the companies providing cloud computing services, scalability to meet the increasing demand of data from employees and customers, and mobility of the data. By having the “company’s data streaming from the cloud”, the company’s workforce can work anywhere from their house to their office. The last reason is how cloud computing providers will upgrade their technology any chance they get for fear of losing the company’s business to another cloud computing providers. This means the speed businesses will be able to access their data will usually be second to none. read more...

AIM, Better way to Search! {1}

by Kaushal S
We all have used search engines numerous times to quench our thirst of curiosity didn’t matter if it was about a specific search or a vague subject. Let’s take Google for an instance; whenever there is a new search entered in seconds it provides the user with millions and millions results about the topic but never with specified results. The article that I picked talks about an Abstract Informational model for minimizing data overload for the user. it helps gather data which is required by the user and compares with database and provides in less steps as possible. It also talks about how easy and user friendly it becomes by providing an overall view of the data. It also provides an option of either pulling up specific information or a lot upon user’s command. read more...