Browsing articles in "Performance"
Apr
10
2012

What are Database Indexes?

Index Example

The database index is defined as a database structure whose primary function is to make the operations on a database table faster. Creating a database index requires one or a number of columns on a table for faster accessing of records in a database. Database indexes only occupy a small part of the disk memory since they only contain important key fields and discard the other fields within the table. This way, the index can be stored even though the database holds a large number [...]

Apr
8
2012

What is a Distributed Database?

Distributed Database

One of the exemplary models of database management systems is the distributed database. Distributed database is the database that is under the command of a central database management system in which certain storage tools are not installed in a single CPU. The distributed database is installed in multiple computers located in the same location or these computers are located in different locations but under interconnected computers. In a distributed database, data are shared through partition fragments, and these fragments can be produced. Moreover, distributed database [...]

Jan
11
2012

Database Optimization

Concentric Database

In the fast-paced world of the internet, you need to keep yourself updated, so it’s important to keep your database maintained to make sure that your system performs well. In the World Wide Web, there are about hundreds of competitors, so it’s important to keep your website in top shape. Apart from database management, web owners should also use database optimization to boost the performance of their systems. Database optimization is becoming more and more of a challenge nowadays, especially when systems software changes constantly. [...]

Jan
10
2012

Database Performance

Database Performance

With the way information are created, transferred and consumed nowadays, it is not unimaginable the pains a company puts into their IT infrastructure. Every day you hear people investing in applications, software, physical servers and other IT-related stuff. And if you’re into HR or finance, you’ll know how much money goes out of the company in terms of consultancy services and payroll. Such steps, however, don’t make database performance management revolutionary because attempts to improve starts not with an initiative but with a distress call [...]

Advertisements