Database Design and Development

What is the Cloud? {2}

by Nelson T
In an article that I have read from PC Magazine Online, cloud computing is the next big thing coming to consumers and businesses. Cloud computing allows people to have complete access to their personal data as well as data from other users as well. This is called Personal Cloud Computing. An example of one of the many benefits of the personal cloud is automatic sync. If a user searches for music using their mobile device, purchases a piece of music from their favorite artist, the mp3 file downloads not only on their mobile device but also downloads automatically to their home computer and other devices that are linked that cloud account. Other items include the user’s address book, email and documents.  Having access to the cloud is fairly cheap and this is attracts business. Businesses can use the cloud to do some serious data mining on the fly. Having access to information coming from their users. A way that a cloud can be distinguished is from key attributes such as it being from a third party vendor that is usually off site, accessed over the internet, minimal IT knowledge are a few attributes. Cloud computing is very useful for a connected consumer and for the success of a business. As an owner of an Apple iPhone, I am a user of their cloud service named iCloud. I find this service to be very useful. Just like my example from earlier, anything i do on my mobile smartphone is sync automatically to cloud servers and then pushed to my laptop and other devices that are connected to the iCloud service. I have personally realized the benefits of this service and its been great since the start. I rely on it almost everyday to make sure I get what i need from anywhere I am connected. read more...

CA Technologies supports ERwin Modeling Tool using Cloud Database {1}

by Davina V
CA Technologies, in an effort to make data integration easier for businesses resting in “on- premise and cloud systems”, has added support for Mricosoft’s SQL Azure cloud database to its CA ERwin data modeling tools. Sadly the author lowers the quality of the article by advertising the new ERwin 8.2 slightly in the article. This article also mentions the potential growth of the use of cloud databases in businesses by quoting Donna Burbank. The quote said that “about 10 to  15 percent of businesses are using cloud databases to day, about 75 percent are interesting in their potential use” (Whiting, 1012). read more...

Scalable Database Service {1}

by Mike Y
Amazon Web Service (AWS) launched a NoSQL database that scales up or down depending on the customers needs. Traditional databases were not as flexible with scalability. The AWS allows the managing and scaling of databases for web apps where normally it would be difficult and costly to do so. DynamoDB is a new database service which stores data on Solid State Drives and is used internally at read more...

Seven common Data Modeling mistakes to watch out for {3}

by Kevin Q
The article briefly describes the benefits of data modeling and how it helps a company and its projects. It then immediately jumps into the seven common mistakes that occur. The First mistake is thinking that the data model is a final structure. This kind of thinking is incorrect, since the data model should be thought of more as a version that can be updated due to new changes. The second mistake is have data models invisible. Data models should be easy to access, be clear and understandable and organized so that it can be used. Having an invisible model defeats the whole purpose of data modeling. The third mistake is assuming business users can read data models. Whether it is assumed by the data model creators or the employees, all that is needed is training to be able to understand the models. It’s important that everyone be able to read and understand the models so that they can make business decisions with helpful information. The fourth mistake is thinking that data models are only used for databases. Data models can go beyond databases to explain and show physical procedures that take place in a company. This can be really helpful in showing the nature of a certain area within the company, so that a well-informed decision can be made. The fith mistake thinking of the data model only as an early deliverable. The data model should be thorough and used as a guide when entering the implementation phase and not just a early deliverable. The sixth mistake creating and overall bland data model. By creating a more colorful and somewhat exciting data model with plenty of comments and guides to help the users, you can keep people engaged and impressed. The seventh mistake think of the data model as your own and not the company’s. They should be available and shared to everyone within the company for viewing, otherwise they will not help the company if only you or a small group of people are the only ones allowed to view it. read more...

Green Servers {1}

by Mike Y

The software development life cycle (SDLC) that is known focuses on the software and the system itsself and does not take into account of environmental factors normally associated with SDLC. Huang states that recycling at the end of the SDLC is not enough to negate the environmental impact. He include how IT has helped the environment by making it easier for the public to find out about conservation, reduced usage of traditional media (paper, CDs, etc), and fuel savings from teleconferencing. Huang states one of the reasons systems are not efficient is because of the speed of the technological progress and is more concerned with success than efficiency. An environmentally friendly SDLC should minized the use of energy, consumables (ink, paper), transportation of people and goods, maximize recyclables and renewables, durable and flexible, and transferable to be used by others. read more...

Political Fragmentation on the Internet {1}

by Davina V
An interesting article I just read was about how people usually read news on the internet. The authors talk about how the news that a person reads usually centers around and supports their belief. Because that is happening, the article is talking about how they are coming up with ways to challenge the information without being so overwhelming, so that they would have information that “they would like to have access to but might not otherwise get” using information technology. They talk about using three different methods: “One is to provide only high-quality challenging items. A second is to provide challenging information only in the context of specific topics of interest. The third is to reduce the cognitive dissonance associated with challenging information by making it easy for people to access counterarguments that support their views whenever they are exposed to these challenges”. read more...

“Big Data,” the next possible step in Business and Sciences. {1}

by Kevin Q
The article describes how “big data,” which is large amounts of data that is being collected today and in the future, are becoming the norm with most large companies and scientific researches. A panel at a Silicon Valley event that occurred about a month back in December of 2011 discussed how “big data” is entering the early stage of its life like e-commerce did in the past. They explained that it could change the way data is handled and create new companies that could excel in handling big data. Large companies are collecting enormous amounts of data and the trend shows that it is only going to increase. “Data growth is already faster than both Moore’s Law and … network growth,” said Anand Rajaraman, senior vice president of Walmart Global E-Commerce (Lawson, 2011) Big Data would help scientific research tremendously, especially if it requires large amounts of data, increasing the computing speeds of crunching data. In an example they gave, they could reduce a computing process with huge amounts of data from 27 hours to one minute. They began discussing that the industry needs to plan and prepare for this change if they want it to go over smoothly. read more...

Database Efficiency {1}

by Mike Y

           Cloud computing is becoming increasingly popular. Platforms as a service (PaaS) can rent resources from infrastructure-as-a-service (IaaS) to have level of service required without investing too much or too little. The article concentrates on multitenant databases where a service will try to reduce costs by grouping tenants. This can be achieved by using SmartSLA to efficiently manage data. The research team evaluates SmartSLA by comparing it to the TPC-W benchmark. The tests show that SmartSLA “can provide intelligent service differentiation according to factors such as variable workloads, SLA (service level agreement) levels, resource costs, and deliver improved profit margins.”            Databases must be managed with limited resources to keep costs low while keeping services fast all while maintaining the integrity of the data. This is important today because an increasing amount of information is stored online. Instead of keeping photos locally, many people will upload it to sites such as Facebook or Flickr where it can be shared and accessed from anywhere. If the data is not managed efficiently, the photos can be lost or inaccessible and will lead to an unprofitable business (and enraged customers). In a world where a site can have millions of connections a day, even the slightest increase in efficiency will quickly add up.            There are services that rely on cloud computing such as Google’s services (calendar, documents, photos etc.), Google’s Cr-48 laptop, and OnLive gaming service. As cloud computing increases, so will the amount of data that will have to be transferred. I believe intermittent or slow connectivity and data loss will be eventually be completely unacceptable as technology advances and its use becomes more widespread. In addition to being fast and reliable, databases must also be secure so that private information is not compromised. Another important factor to consider is if the system will scale well with an increasing amount of users. Source: Xiong, P. (2011). Performance prediction for concurrent database workloads. Intelligent Management of Virtualized Resources for Database Systems in Cloud Environment, 11(16), 87-98. doi: 10.1109/ICDE.2011.5767928

The all “new” Database Firewall {Comments Off on The all “new” Database Firewall}

by Stephen O
It slices, it dices, it makes healthy meals in thirty minutes flat, unclogs drains with ease, and will fold your laundry! Okay maybe it does none of that, but what it does do is offer a small peace of mind when it comes to Database protection.  This year was known as the Year of the hacker, with hacking stealing the headlines away from shark attacks, missing children, and celebrity rehab news (Thankfully). People have known about hackers for ages, but this last summer hacker groups such as Anonymous and LOLZSEC made everyone feel a little less safe. Sony was a focus of several attacks, and millions of people were affected by one attack alone. The Spree of hacking brought the hacking problem into the public eye. What is even more freighting is how easy it is. read more...

Databases turn the tide on Graffiti! {Comments Off on Databases turn the tide on Graffiti!}

by Stephen O
Graffiti, it dots the landscape in just about every city and neighborhood. In most cases, it is an eyesore, blight upon the urban landscape. Every day the cities spend millions on cleaning it up, only for to happen again, and again. To this end cities are fighting back…with databases!  Several cities have started to fight back with databases. Los Angeles launched its own database this year called TAGRS to combat a ten million dollar a year problem. City of Santa Clarita has a Graffiti task force, which was created back in 2006 and since then has caught 1,000 taggers since the creation of their database. read more...