About

Posts by :

Sarbanes-Oxley, A Bad Thing? {5}

The author talks about the negative impact that the Sarbanes-Oxley Act of 2002 made on small firms. Dvorak starts out using Yahoo! as an example to explain why he believes “Sarbanes-Oxley sucks” (Dvorak).  He believes that if SOX became a law during the time that Yahoo! went public, Yahoo! would never have done so. Dvorak [...]

What to Expect in Data Warehousing {2}

Data warehouses play a critical role in corporation/institutions. They allow users to quickly retrieve data to be used for data mining or for data analysis tools. The results that they get from these tools are then used to support business decisions that would be made. The authors of the article designed a case study that [...]

Using XQuery to Retrieve Data {3}

XML is widely used in the web because it could be used to store all types of data. XQuery has become a language used to perform XML queries as it has the ability process XML data. Before the queries can happen, an XQuery Implementation needs to be applied. The XQuery Implementation must meet the following [...]

Anonymous and Apple {3}

Anyone can be a victim of a hack attack. Apple became victim to an attack by the hacker group known as Anonymous. The attack did not affect customer data, but instead targeted the server that Apple uses to process the data of their technical support follow ups. Results of the attack “revealed 27 internal Apple [...]

SQL: Attacks and Ways to Defend {6}

Internet, communications, and computer network technology has been growing at a very fast rate. With the use of SQL in web applications, databases and operating systems have been the target of SQL attacks.  Applications on the server-side use SQL statements to perform patchwork for the database. This makes it possible for an attacker to submit [...]

4th Step: Implementation Design {4}

In database analysis and design, there are three major steps that are followed: conceptual design, logical design, and physical design. The author of the article explains that there is a need to extend and include a fourth step: implementation design. This step would come in after the logical design and before the physical design. The [...]

How to Design a Better Database {4}

The authors of this article discussed how physical database design is under-studied because database administrators have to maintain databases on a daily basis. The idea is to design databases that could adjust themselves to the characteristics of applications, such as indexing definitions or automatically gathering information from SQL workloads. The authors explain that self-tuning logical [...]

Using ER Models for RFID {8}

In this article, the author talks about how RFIDs (Radio Frequency Identification) uses Entity-Relation models to manage its data. With the use of RFIDs, it allows objects to automatically collect information so it makes things easier and more efficient for those who use it. The data for the RFIDs changes frequently and it requires the [...]

Understand the Data in Data Modeling {4}

In the article that I read, it said that when you start working on data modeling you’re eventually working on something that will lead to database design. Before data modeling become popular, some people saw data administration and information groups as obstacles because it slowed down development. However, companies soon came to the conclusion that [...]

Using SQL in Database {5}

This article discusses how Structured Query Language (SQL) is used for databases. Within the database, there are tables where the information or data are being stored. With the use of SQL, it allows users to manipulate the tables, which in turn, could manipulate the data. SQL has been established by the American National Standards Institute [...]