databases

Web Based Database Application Development {1}

by Allen D
Database technology has evolved to a much popular scale in every sector of our economy for the past decade. The technology’s major roles of organizing, storing, and retrieving data have been the forefront of information management.  As society shifted towards Web 2.0, the rapid development of the internet has taken over the once popular functions of the database management system. Why? The Web allows users to easily share and access information through its hypertext interface. For this reason, network maintenance of traditional database has been stripped of its utility. Thus, developers today focus on building web-based DBMS applications. The journal, “Supporting Web-Based Database Application Development”, by Quan Xia, Ling Feng, and Hongjun Lu, talks about a application used about a decade ago called jdWeb. read more...

A New Way to Model Your Data {3}

by Katheryn T
In the article I read, it spoke about often intimidating size of most databases. There is an urgency in the article to make sure the user has a grasp of what there is to work with and to make it easier. In order to help the user, a 3-D model has been designed. It is designed to help give a visual perspective to the user. This will help the user to understand the specific database at hand. With a method like this, it would be very useful for beginners. The model is composed of the top view, the front view, and data flow modeling. All of this gives the 3-D view.  The article explains about how rows and columns are distinguished and how the relationships between each entity are identified.  The top view looks much like an entity relationship diagram. The front view enables the user to compare the different tables and their sizes. Data flow on this type of data modeling is heavily relied upon colors and contrasting. Dotted lined between tables with a diamond in between signify a many to many relationship.  The whole purpose of 3-D data modeling is to use the screen to actually aid the user in their perception of the database. read more...

Improving Databases and Datacenters {Comments Off on Improving Databases and Datacenters}

by Anthony T
The article is about the current trends in IT and how they relate to databases management. The author mentions the growth of e commerce and how companies are deciding to use the cloud to meet those needs. A problem which datacenter managers face is doing more with less funding. The author suggest advanced request distribution as a solution for datacenter managers. What this is basically is a process which sends request to certain resources which are best fitted to execute them. This technique is being used in the web and application layer of the application architecture. In terms of the data layer, advanced distribution techniques are used primarily on transaction processing done over the web. The authors go on to outline their proposed cost cutting technique. Their strategy basically assigns requests among a cluster of “off the shelf databases”. The steps of their process consists of developing a logical approach and architecture, develping a working model, and evaluation of artifacts. read more...

Four Reasons to Consider FileMaker 12 {Comments Off on Four Reasons to Consider FileMaker 12}

by Jonathan N
This article talks about the software FileMaker 12, which is a database program that will help drive your business. The new FileMaker 12 guarantees that the average user will enjoy their software much more than their competitor, because of the sleek user friendly design. They state in the article that their software is comparable to a hot Ferrari rather than a old Ford Pinto. The Filemaker12 is designed to  look great on multiple platforms. The article states 4 main features the software does that makes it one of the best database programs. The first feature states that Filemaker 12 comes with 16 starter solutions or templates such as inventory, project management, contacts etc. that make it easy for you to just plug in your personal info. So for the average user that is incapable of gifted graphic design skills does not need to worry about it because the software has templates ready to go. The second feature that Filemaker 12 offers is embedded multimedia. Embedded multimedia enables you to drag and drop multimedia content in your database with much ease. The third feature is Faster Performance. They have introduced a 64 bit version of the FileMaker Server which has the capabilities of addressing more memory and can process large database.  The fourth and final feature is the iOS Apps. They have made their software have Apple iphones and IPad capabilities because mobility is the essence of the new modern technological advanced world. read more...

ASP.NET V.S. JSP which gives a better MVC implementation {2}

by Salvador A
One of the major problems with a growing World wide web is the number of users and second the number of request being sent out by all of those users. To solve this problem their is a type of “website” implementation called MVC, which stands for The Model View Controller, design pattern. This type of design pattern aims to split up basic HTML into separate modules that each perform a specific task and create an overall better and faster web experience. By separating the modules, they are able to isolate the user interface logic from the business logic. The point here is that you no longer have  to perform major test when changing some user UI, instead since they are isolated from each other you will know that a change in one will not affect the other, thus you do not have to spend resources back tracking possible errors. The data provided showed that a MVC implementation in ASP.NET was better, the main point behind ASP.NET being better was that it is loosely implemented and thus made it easier for any programmer to implement the MVC. While JSP was also a direct implementation of MVC its major flaw was that it was difficult for programmers to implement. read more...

Banking’s Big Three Sued Over Mortgage Databases {3}

by Steven C
Last Friday, February 3, New York Attorney General Eric Schneiderman sued banking’s Big Three– J.P. Morgan Chase, Bank of America, and Wells Fargo, for the use of an electronic mortgage database that took part in the nation’s mortgage crisis. According to the article these companies performed  illegal and deceptive practices through this database, called the Mortgage Electronic Registration System or MERS,  which contained false documents used in foreclosure proceedings. Schneiderman said that the MERS was created by mortgage companies in order to evade recording fees, to avoid needing to publicly record mortgage transfers, and to help them rapidly sell mortgages to gain more profits. This helped these companies save 2 billion dollars in mortgage recording fees. read more...

Normalization, Confusion among Textbooks {2}

by Kevin Q
The peer reviewed journal I chose was about normalization in general and how some textbooks may have different reasons for normalizing. Carpenter goes on to discuss “E.F. Codd, the acknowledged father of relational database and normalization.” Codd’s normalization is attaching attributes to primary keys like we have discussed in class. Carpenter then mentions Hoffer et al books and their goals of normalization. They are: “(1) Minimize data redundancy, (2) Simplify the enforcement of rerential integrity constraints, (3) Make it eaier to maintain data, and (4) Provide a better design that is an improvise representation of the real world and a stronger basis for future growth.” Carpenter agrees that these goals are great overall but feels that the real goal of normalization should be “to produce correctyl structured relations.” He believes that the clarity on the subject of normalization would help students be able to grasp the concept more easilt and clear up confusion. Carpenter says that not all data redundancies should be eliminated as some, though rare, are essential in some cases. Carpenter then moves onto the subject of what level of normalization are we supposed to reach and how even textbooks can’t give a unified answer or statement. read more...

iTunes Match Plays on All Apple’s Devices {1}

by Jintien C
This article is about iTunes Match. After iTunes Match beta finished testing, Apple is almost ready to launch its iTunes Match. This service will have a flat rate fee of $24.99 charge per year. Apple’s iTunes Match uses its own cloud server to store music files. iTunes Match will first match Apple’s cloud databases when a user upload a music. The music gets uploaded only when it’s not found. iTunes Match also promises that every music plays in 256kbps no matter original format is. Basically once you have iTunes Match, you will be able to access your music libraries from any Apple’s products that you own. read more...