Recent Posts

Pages: 1 2 [3]
21
General Discussion / Relational Algebra
« Last post by Kotty on October 09, 2014, 02:35:36 am »
Relational algebra

Relational algebra is a procedural query language, which takes instances of relations as input and yields instances of relations as output. It uses operators to perform queries. An operator can be either unary or binary. They accept relations as their input and yields relations as their output. Relational algebra is performed recursively on a relation and intermediate results are also considered relations.

Fundamental operations of Relational algebra:

    Select

    Project

    Union

    Set different

    Cartesian product

    Rename
22
General Discussion / Database tuning
« Last post by Kotty on October 08, 2014, 03:44:46 am »
Database tuning describes a group of activities used to optimize and homogenize the performance of a database. It usually overlaps with query tuning, but refers to design of the database files, selection of the database management system (DBMS) application, and configuration of the database's environment (operating system, CPU, etc.).

Database tuning aims to maximize use of system resources to perform work as efficiently and rapidly as possible. Most systems are designed to manage their use of system resources, but there is still much room to improve their efficiency by customizing their settings and configuration for the database and the DBMS.


Regards,
Packers and Movers in Chennai Listing
23
General Discussion / Welcome to CreateaForum.com
« Last post by Create A Forum on October 08, 2014, 11:50:20 am »
Welcome to Create A Forum!

We hope you enjoy using your forum. If you have any problems, please feel free to visit http://support.createaforum.com to ask us for assistance.

Thanks!
Create A Forum
Pages: 1 2 [3]