efficiency

Design and Performance of Databases {Comments Off on Design and Performance of Databases}

by Eric C
When it comes to building databases, performance is perhaps the top priority for database engineers. Speed and efficiency is the key when it comes to gathering information using queries for end users. There are various ways to improve the efficiency of databases and that includes the incorporation of vertical and horizontal partitioning. In a peer reviewed article written by Agrawal, Narasayya, and Yang, entitled “Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design,” the authors discuss how vertical and horizontal partitioning can both improve the performance and manageability of databases. Horizontal partitioning takes the rows of tables that have common values and puts them together into one or more tables. Vertical partitioning is the same concept, except using the columns of several tables. Furthermore, there are two main methods of partitioning, as mentioned in the article: hash and range. Hash involves the distribution of rows evenly across different tables with the use of a hash key. Range involves the partition of minimum and maximum values of data in many columns. In order to make the database easier to manage with these methods, it is required to have the indexes and tables aligned. An index is aligned when the index uses the same partitioning technique as the tables. However, achieving such tasks is complex and therefore the physical design is very important. For example, there are many ways to horizontally and vertically partition a database, as well as the alignment and as a result, choosing the correct design is critical. If such designs are not implemented correctly, that database could perform slower or even cause lockups when running queries. Once correctly implemented, the database can receive an improvement of up to 20% in running queries. read more...

Amazon makes efficiency a web developer’s friend {2}

by Ermie C
This article is exactly what it says because Amazon has given resources for web developers that make it easier for them to create their web applications for their Amazon account.  It’s called Amazon Web Services or AWS, and it allows Javascript, jQuery, ASP.NET, PHP, and Java.  The platform is called Elastic Beanstalk and uses the Windows Server 2008 R2 AMI(Amazon Machine Image).  They mention, “Elastic Beanstalk then automatically takes care of deployment details such as capacity provisioning, load balancing, auto-scaling and application health monitoring, according to the company.”  This means that everything will be taken care of, as their applications are uploaded into the Amazon cloud. read more...

JSON in application efficiency {3}

by Han C
Jim Keeting writes about Javascript Object Notation, JSON, and about how modern web applications are geared torwards efficiency. At first there was Asynchronous Javascript and XML or AJAX for short but there is always a demand for more efficiency. Since then web developers have been trying to get the maximum amount of performance for the code they write. JSON is a result that originated from a coder by the name of Douglas Crockford, a senior Javascript architect at Yahoo. Crockford intended it to be a lightweight data-interchange format which meant that it would inheret the use of name and order values. This is why it has some similarities to programming languages. JSON’s purpose is to provide “a way to store information in an organized, easy-t0-access way” that was human and machine readable. JSON achieves this because it is an open source, text based exchange format that can operate independent from any programming language. This is why so many web application developers are switching over. Another thing that many coders did not was constraint. For example, using XML included the tedious task of having to write parses and having to assign variables using DOM APIs. With JSON you can generate or retrieve data easier with fewer, less complex, and  code. JSON can let you build smaller, faster, and more interactive applications for not just desktop audiences but also for phone and tablets. read more...

How The SQL Basics Equal Performance {2}

by Ermie C
This article is very informative of how to improve performance on how to use SQL server. The main thing that is presented is poorly coded SQL statements is how databases are slowed down and efficiency is not maximized. Although, it is impossible to create the perfect statements there are many ways to create an easier database structure. With all elements of doing a skill, the things people forget that are the most critical part of a skill are the basics. When people have the basics down, then implementation of new ideas and skills for databases can be easily created. The main types of code that is used in the basics of SQL are “WHERE”, “SELECT”, and “FROM”. These create the foundation of how certain types of information is organized and selected within a database. However, following the rules is the main purpose of why this article was written. To improved the performance of a database, is to start thinking in a relational manner. This means that when implementing a database, it must been seen as comparing tables of data as if they were files. To be able to filter and choose the types of data that must be extracted for use in the business world. There are also mistakes made in the SQL world. The author states that SQL statementes shouldn’t be “asking for what you already know” (Mullins). I believe this means that finding data shouldn’t be hard coded at tailored for a specific piece of data, but to create a SQL statement that could be used for any part of the data. Finally, the author encourages continuous updates on the database. We can all agree that databases are only good for the content they hold and its integrity. Following the rules and simplifying SQL statements will make the life expectancy of a database longer and more efficient, but if these rules are not met, then what is the purpose of having an efficient database without performance. read more...