Database Design and Development

Music Reviews Out the Door? {2}

by Monica G
Music Reviews Out the Door?

Summary:

Published music reviews are becoming more and more obsolete. People are no longer buying the magazines that publish these reviews, even though the music industry continues to expand. Corporations like Google and Yahoo Music, have allowed the listeners to become the critics through such websites like YouTube. So the need for third parties to review a specific song is becoming something of the past. Therefore, magazines like Jazz Journalists Association, NewMusicBox, and others, are pleading for help. Washington even held a convention to address the matter called “Critical Condition:  The Future of Music Journalism.” At this said conference, the author was serving on the panel addressing the issue; it was then that the potential answer to the crisis surfaced. What if the same devices we use to listen to music become the home to these said reviews? That is to say, a central area for music reviews would be implemented along with the music it is reviewing, in essence a database. For example, an application like Pandora would allow the user to choose an artist and a review would display about the song playing along with reviews about the artist and the other relevant songs. That is not to say that approaches like this have not already been done, such as Pitchfork, and Rhapsody, but there are massive amounts of information still not attached to these programs.  If the information was all in the same database, then another advantage surfaces, advertisements. If the listener is already looking at the application or website playing the song then advertisements can stream around them. Therefore, leading to the possibility of greater revenue results and higher amounts of exposure. read more...

ERP and the users’ view {Comments Off on ERP and the users’ view}

by Stephen O
Summary:

All of us use an ERP. Whether you knowingly use it, use it in disdain, or unknowingly do so. If you are a student at California State Polytechnic University, Pomona you are familiar with Bronco Direct. It is the software that we use to add/drop classes, search for classes, check holds, register for tests, and see when your financial aid disbursement is. Most college campuses have an ERP System, in fact, Mount San Antonio Community College switched just a couple years back to their own My.Mtsac ERP software. Now before I go any further ERP stands for Enterprise resource planning.  It is the software that is used for many business functions such as  Finance/Accounting, Human Resource management, supply chain management, project management, customer relationship management, data services, and access control. “. They evolved from standard inventory control packages to material requirements planning (MRP) and manufacturing resource planning. Enterprise resource planning (ERP) is now considered to be the price of entry for running a business.” (Yu-Min, 2006) I know if you are like me you cringe when it comes time to register for classes, and Bronco Direct otherwise known as Peoplesoft, is down.  ERPs can be complicated, complex, and expensive to install and there has to be some way of evaluating to see if an ERP system is even necessary and once it is installed, just how successful such a system might be. In Taiwan, they used 264 people and subjected them to a newly installed ERP system. “The results suggest a ten-item instrument to measure three components of ultimate-user satisfaction in an ERP environment: ERP project team and service, ERP product, and user knowledge and involvement. This study has conducted a rigorous scale development procedure to establish a reliable and valid instrument for measuring ERP ultimate-user satisfaction.” (Yu-Min, 2006) Through this study they established a valid way to measure ERP Ultimate-user Satisfaction. read more...

Footprint Database used catch criminals! {2}

by Stephen O
Summary:
What comes to mind when you think of databases? You would normally think about a collection of your personal information that you may or may not have given out freely. Combine that with the crime solving and what comes to mind now? Shows like NCSI and CSI and its many spinoff should be first in your thoughts. Crime solving units around the world use databases on offenders to keep track of finger prints, blood type, and DNA. However has it ever crossed your mind…that your foot print could also end up in some national database? If you are like the rest of us this has not yet crossed your mind. The United Kingdom stores the imprints of thousands of shoe types and imprints from “suspects” left at crime scenes. The database was created by The Forensic Science Service and locates matches between shoe prints and crimes, much like DNA databases work here in America. While using footprints to solve crimes is not exactly new, a database allows Scotland yard to solve those tough to solve cases faster. read more...

Google and Its Books {1}

by Joey L
Summary:

This article is relates how digitization of print media is becoming one of the largest infringements in history.  One of the most notable digital infringements is Google’s Books project.  Google Books has become an easy access for anyone to find reference to millions of books and magazines.   Many of these books are claimed to be illegally scanned by Google, which then hands their database of books to HathiTrust, a partnership of universities and libraries.   A few groups of writer unions have filed a lawsuit with Google asserting that Google Books is publishing copyrighted works without the author’s authorization.   Currently, about 7 million books from Google are claimed to be illegally scanned.   Because these scans are unauthorized, the writers are seeking to withdrawn all illegally scanned books from Google’s database.  Google is currently offering the authors to either sign a contract and giving them their share or remove their book from their database.  If the authors do not contact Google, the books will become available to the public.   The lawsuit is still active as of September 15, 2011 and hopefully, Google and the writer unions will reach an agreement soon. read more...

Databases and Medicine? {Comments Off on Databases and Medicine?}

by Caezar M
Summary:

After the natural disaster known as “Hurricane Katrina” an effort was made to relieve the victims. This effort did not come in the form of monetary relief, food, supplies or shelter, however these were relief efforts as well. This specific effort came in the form of databases, but what use do hurricane survivors have of databases. What these databases provided was a comprehensive prescription history for the last three months prior to the hurricane making landfall. The linking of these databases offerd a single point of entry to doctors in relief tents who could then compile histories of patient prescriptions and aid in getting their prescriptions refilled. This service contained information for over 800K individuals affected by the hurricane. Even though this is just a test it is expected to be a success. Hopefully because of this test a move can be made toward making electronic healthcare a reality. read more...

Social Network Face Book and Its Data Warehouse {Comments Off on Social Network Face Book and Its Data Warehouse}

by Tuyen H

         This article talks about MapReduce (MR) platform with parallel data access. MapReduce is introduced by Google in 2004 for supporting multiple accesses of data. It has been written in many languages such as C++, C#, Java, and even PHP. Famous Social Network Face Book built its massive data warehouse by using the MapReduce technology. The authors also compare the MapReduce technology with database management system (DBMS) “MapReduce complements DBMSs since databases are not designed for extract transform- load tasks, a MapReduce specialty.” Indeed, the combination of MR and DBMS create a powerful of database system. This combination allows big companies to build their database warehouse where they store a lot of information. For example, Face Book store more than 800 million users’ data and information. Google’s data warehouse stores more than 850 TB for supporting user searching. Finally, the authors mention that those technologies are not competition but complementary. 
        This article mentions data warehouse and database technologies such as MapReduce (MR) and database management system (DBMS). Those technologies are really helpful because they allow people to build massive data warehouses. For instance, Google’s data warehouse like a world library; it support business and study around the world. It also likes the world knowledge. In my work place, every time we have questions we “ask” Google. In school, when I research I also “ask’ Google.
        As you know the Jasmine Revolution happened with support of social network like Face Book and Twister. If there are not any database technologies such as MR and DBMS, there is not Face Book or Twister. Therefore, the Jasmine Revolution will not happen.  Data warehouse also use to store much important information that supports government, organization, and education. Imagine that, if the government does not have the database, how can it work? The IRS cannot collect tax. The DMV cannot manage vehicles and so on. I think data warehouse is really helpful, and both RM and DBMS are revolution of the database technology. read more...

What you “Need” to know about “The Cloud” {1}

by Caezar M
Summary:

When you think about “The Cloud” you probobly see an omni system that is everywhere and nowhere at once. You probobly think that once in “The Cloud” your data aimlessly bounces arround the world waiting to be accessed, by anyone, and not just yourself. It is an interesting fact that only part of this is true.  The term “Cloud” is an over simplification for the idea of the infinite complexity of the internet, “The Cloud” = The Internet. The idea that “The Cloud” is a dispertion of computing resources is true and false at the same time. Large data centers and server farms make up “The Cloud,” data centers have physical and geographical locations but their locations are irrelevant to us as long as the services rendered are accessable anywhere the user is. what we probobly do not put too much thought into is the value of the information we put into these data centers and how it relates to our privacy. Since data centers are “somewhere” this emans they are subject to someone’s laws and regulation. what this means for the user is that any intellectual property can be subject to a subopena and disclosed without your knowledge. Cloud service providers work hard to protect your privacy but it is far from secured. Without worldwide laws governing data centers the use of “The Cloud” will not reach its full potential. read more...

The “One and Only” Disease-Causing Gene Database {1}

by Monica G
The “One and Only” Disease-Causing Gene Database

We live in a society where information is everything. Everyday we expose ourselves to large amounts of data. Therefore it is easy to say that the people that have all this information have power.The power to change the world. But what if this information could potentially save lives? Should that factor make it free? The human genome is exactly this. It was started over decades ago to map out every single gene, then to identify the disease-causing mutations. The process is still underway, but many of sequences that cause Alzheimer’s or Parkinson’s have been identified. So then the question becomes, why hasn’t this information been made available to the public? One reason being is that the data is not all in one place. Because different clinicians collect data around the world, it seems more logical for it to be stored somewhere accessible to them. But this makes it nearly impossible for other scientists to share all their research. Another reason being that data is big business, databases like Human Gene Mutation Database, require subscribers to pay a fee to access all the information. Other databases like Online Mendelian Inheritance in Man, were started so long ago that much of the information is still in writing, therefore the online version lacks a lot of the substance required. For all these reasons, it would be much easier to have all the information stored in one place. Luckily, some countries like China have taken the initiative to do just this. read more...

Open Source Database for Small Company {1}

by Tuyen H

 

While Eclipse is very successful for Java Development, MySQL and PostgreSQL are very populating open source Databases.We cannot compare with brand name like Oracle, Microsoft, or IBM, but MySQL and PostgreSQL are very reasonable for small business.  If your data is less than a terabyte, both MySQL and PostgreSQL definitely can handle it. However, if your data is really big, you better think of Oracle, DB2, and Microsoft enterprise RDBMSes. Open source database is less secure than brand name database, so you have to keep in mind that “how safe is my data”  (Gravelle, 2011). read more...

Data Mining in Social Media {1}

by Joe C
Summary:

This article talks about data mining in social media, in which companies such as Facebook or Twitter are able to gather data from their users through the information, posts, and other activities the users provide. This type of information gathering is emerging to become a great source of information on upcoming trends and opportunities, however the data has to be harvested and analyzed correctly. While there is a great deal of information, the amount of useful/relevant information compared to irrelevant noise is as little as 20%. Being this way, these companies have to utilize highly advanced artificial intelligence to sift through the noise and retrieve only the useful information. As technology advances, these AI systems are able to perform tasks such as match newly created profiles to old preexisting users in the database to form a more complete profile of a possible customer. This is very useful as it acts like a real-time automatically updating CRM system. read more...