Database Design and Development

Data Mining Within E-Commerce {0}

By Gary C.

In e-commerce, data mining is critically essential in order to compete with the rapidly growing competition amongst retailers. E-commerce is the exchange of data within the online world in order to garner business transactions. There are patterns and trends within shoppers that are analyzed and broken down in order to determine strategies to identify a multitude of situations, such as from what customers may like based on a previously purchased product all the way to why customers tend to avoid a certain product. The amount of raw data that is transmitted through data mining is astounding and requires a tremendous amount of research in order to determine the most of every possible likely scenario.

read more...

NoSQL {Comments Off on NoSQL}

By Jose Y.

The vast amounts of information that our devices are gathering and generating has paved the way for big data. Companies like google that receive extreme amounts of data or tech startups that does not need a full blown database solution has pushed for a non relational type of implementation. There are differences in schema, cost and data models between both types of database.

read more...

Databases and Technology in Politics {Comments Off on Databases and Technology in Politics}

By Tony W.

With the onset of the information age, databases and various sorts of technology have been playing a large role in politics around the world and in the United States. Nearly All successful political campaigns are using data in a meaningful way. Being able to understand it and take advantage of it can be the key to winning an election.

read more...

Big Data and Medicine {Comments Off on Big Data and Medicine}

By Vamsi R.

Big data is paving the road for great technological changes in many industries and giving researchers a powerful tool to analyze and focus on any area of improvement in their company or industry. The medical industry is greatly benefitting from the role of big data in the recent years and it has the potential to change the way the entire field operates.
The role of big data in medicine has no limitations. Beyond improving profits, “Big data in healthcare is being used to predict epidemics, cure disease, improve the quality of life and avoid preventable deaths” (Marr). This is revolutionary as it gives medical professionals a powerful tool in accessing a situation and making well-informed decisions. Big data helps by “aggregating more and more information around aggregating more and more information around multiple scales for what constitutes a disease – from the DNA, proteins, and metabolites to cells, tissues, organs, organisms, and ecosystems” (Mckinsey). This lowers the possibility of making a medical error as organized information is available to help you make the best decision in a particular situation. It also helps researches find cures and preventions for diseases in a more efficient way as large information is readily available in an organized manner.
Big data could also mean an end to the scientific method and create a streamline source for medical answers. It is claimed that “so much information will be available at our fingertips in the future, that there will be almost no need for experiments. The answers are already out there” (Standen). Using a large pool of medical records in the database, a researcher can see if one attribute is a causation for another. This will help them gain further understanding in their research without undergoing the long process of obtaining research grants and conducting independent studies.
There are many companies and organizations that are making the shift to using big data in their operations. One of these companies is IBM which has “announced an acquisition that will enable its Watson platform to learn from stored medical images” (Nelson). IBM’s strategy is to “combine rich image analytics with deep learning” to “cross reference the images with clinical studies, health records, and other sources”(Nelson). Using big data to transform their industry and improve quality overall is exciting to see in all aspects. With a company as large as IBM utilizing big data for medicine, it will not be so wrong to assume that big data might be the future for all healthcare and medical companies.
Organizing large amounts of information can save immense time and costs to medical professionals. With the entrance of big data, many technological changes are being seen in the healthcare and medical research industries. These changes are proving to be beneficial in giving medical professionals a powerful tool in making high quality decisions and have the scope to revolutionize the way the industry operates a whole. Overall, big data is greatly changing the medical field and will only grow in use by medical professionals in the future.

read more...

How Cloud Computing Affects Security {Comments Off on How Cloud Computing Affects Security}

By Miranda O.

With big data becoming much larger, cloud computing has become the more favorable form to handle it. The fact that cloud computing is becoming far more mainstream these days also means that security risks are also increasing. Traditional forms of security such as firewalls will soon be obsolete with anti-malware and encryption taking over. Even load balancers will no longer be needed now that these features are already implemented in cloud infrastructure. The growth of cloud computing will see the fall of traditional security measures but the rise of new ones as it becomes much bigger.

read more...

SQL Injection {Comments Off on SQL Injection}

By Winston L.

Database is a brilliant invention in this age of technology. From the Database page on Wikiperdia, database has existed for 45 years since when first proposed by Edgar Codd in 1970, however, not until the computer hardware’s capability became strong enough to handle large data processing were the database concept and database management systems (DBMS) widely implemented. After the birth of Internet, the demand for a decent application to manage large database increased even higher, and it is partly because people have found that database can be used to utilize everything, from business to scientific research. Nowadays, there are many major DBMS, such as IBM DB2, MS SQL, MySQL, and Oracle. All of them are based on the standardized SQL language, and that makes them vulnerable to one simple but very dangerous attack on the database, the SQL Injection. In this blog, SQL Injection attack technique, its impact, its victims, and prevention solutions will be discussed.

read more...

How Database is implemented with the Elderly and Disabled {Comments Off on How Database is implemented with the Elderly and Disabled}

By Mitchell L.
Database is vastly growing and improving our way of living with keeping inventory counts for major businesses or helping doctors keep track of patients. While this is a significant impact on our modern ways of living, database is being used more to implement with the disabled and the elderly. Just like how the internet has to be compatible with all kinds of users from around the world, database for the future is definitely making an impact for all. In order to show the future designs of database affecting the disabled and elderly, there are three areas that will be discussed including teaching database to the visually impaired, using database to understand speech for people with special needs, and using database to work with elderly on improving their ways of living. Each of these topics are designs that should be implemented in the future of the world as we are growing.
Database modeling is quite a challenge to learn as a class subject, but one teacher managed to create a design to teach her visually impaired student. Her challenge was figuring a way to demonstrate the database modeling, so she decided to use a tactile method rather than an auditory one (Brookshire, 2006). The materials used were index cards representing the rectangles, plastic strips, a cardboard as a frame for the diagram, and pushpins to represent cardinality (Brookshire, 2006). Definitely this method allows people to understand how to create the relationship tables with entities and cardinalities. Just because a person has a disability, doesn’t mean the person cannot learn like normal students. At the end of the class, the student successfully demonstrated the method worked and was as equivalent with students not visually impaired.
Aside from using a different technique to help someone with a disability, database functionally is used to understand speech for people with special needs. Elderly and speech impaired people have a trouble with understanding speech related situations like knowing different emotions conveyed (Iida, Yasumura, Campbell 1998). The technique is creating a corpus of emotional speech that uses frequency from a user when they express their emotion and stores it in a database to recognize each person’s frequency pattern (Iida, Yasurmura, Campbell 1998). The frequency results were astonishing stating that sad: 40Hz, joy: 53 Hz, anger: 57 Hz and the pauses for sad were longer than joy and anger (Iida, Yasurmura, Campbell 1998). The higher it was showed more anger, the lower it was showed sadness and being just right was the way to measure joy. As a database, it will be able to remember this from the user intending to use this speech recognition for emotions. The user with any disability or elderly can now convey their emotions to their intended audience without having any miscommunications.
Database helps simplifies elderly because many people from the 20th century are becoming an aged society. Technology is becoming more advanced than ever even kids are able to understand how to use complicated devices, but the aging society is having more difficulty to learn how to use them. The process being used contains three key ingredients using perception, followed by recognition and then operation to create a system for adults to understand new devices (Ishimoto, Sawashima, Yoshioka 2002). The data being collected is the user’s life eyesight, sound, hearing ability, memory, attentiveness, finger size, skillfulness, and how easy it is to understand and then creating a way where the user can use the product in a simplified manner (Ishimoto, Sawashima, Yoshioka 2002). This data can be used to create devices that appeal to elderly with using the data interpreted and used in software to adjust devices toward all the individuals.
In conclusion there is a huge factor with database with the elderly and disabled. Database is useful amongst everyone and it provides useful methods for the people in need and it plays a role with how it is being taught to students too. By understanding every individual and their need, there can be a world where everyone can learn despite any handicap or age. There can be a world where there shouldn’t be any labels of any individual despite their condition with the use of database technology.

read more...

Small Businesses and the Right Type of Database Solution {Comments Off on Small Businesses and the Right Type of Database Solution}

By Christopher G

Over the summer I worked at a company named Industrial Powersource (IPS) as a business analyst intern. IPS specialized in selling forklift batteries and their respective chargers as well as their repeated maintenance. Their on location warehouse stores over two hundred batteries and chargers as well as over a thousand parts used to perform repairs and reconstruction. The problem they faced was how do they keep proper track of how many individual items they had and where their batteries and chargers are located. When looking for solutions they found databases scary and too technologically advanced for their needs. However, this is an ideology that many mom and pop type small business face and it keeps them “using Microsoft Word or Excel to log sales and customer information, when they really need simple databases.” (Dreier,2003). Implementing the right database solution is the most important decision any small business can make.

read more...

The Effects of Open Source software on Database Usage {Comments Off on The Effects of Open Source software on Database Usage}

By Benjamin B.

Open Source is becoming the fastest way for technology to evolve and change based on what the market and users want. The premise of Open Source is that the source code of an application is available online for contributors to add to or modify. There are moderators that manage each “fork” of the software to make sure that the software is moving in the direction that the community wants, and that the code being committed to the project is quality. Moreover, if someone wants to build a version of the software a different way, they can start modifying a copy or “fork” the project and do whatever they see fit.

read more...

Combating California’s Drought: Big Data {Comments Off on Combating California’s Drought: Big Data}

By Arturo D.

Given the recent spurts of rain and snow across California, its easy to forget that we are still in fact suffering from one of the worst droughts in almost 100 years. Recent winter wet seasons in the past few years have been the driest on record since 1895 and experts estimate that it will take a ridiculous amount of precipitation in order for our reservoirs and lakes to reach their normal levels (Thibodeau, 2014). The big difference-maker and new weapon against droughts that didn’t exist decades ago is improving technology in the form of smart sensors for monitoring water usage and the collection of water data to create better usage reports, discover leaks in physical infrastructures and understand what regions are affected by prolonged droughts the most in order to create better conservation goals.

read more...