Posts

Showing posts with the label Optimizer

SQL Database

What is SQL Database? In simple database is collection of objects which stores a specific set of structured data. Let us consider an example of Facebook. It needs to store, manipulate, and present data related to members, their friends, member activities, messages, advertisements, and a lot more. These all information is stored in different tables and collection of these tables are kept at one place.   How to CREATE SQL Database? To create a new database in a SQL server use CREATE DATABASE statement. Syntax: CREATE DATABASE DATABASENAME   How to ALTER existing SQL Database? If we want to change the database name or file locations or collations etc. then we use ALTER DATABASE statement. Syntax: ALTER DATABASE { database_name   | CURRENT }   {    MODIFY NAME = new_database_name      | COLLATE collation_name     | < file_and_filegroup_options >     | SET < option_spec ...
Post a Comment
Read more

SQL Architecture

Image
   SQL Architecture When you are executing an SQL command for any RDBMS , the system determines the best way to carry out your request and SQL engine figures out how to interpret the task. There are various components included in this process. Query Dispatcher Optimization Engines Classic Query Engine SQL Query Engine, etc.   A classic query engine handles all the non-SQL queries, but a SQL query engine won't handle logical files.   A simple diagram showing the SQL Architecture −   Query Language Processor In a relational database system the query processor is the module responsible for executing database queries. The query processor receives input queries in the form of SQL text, parses and optimizes them, and completes their execution by employing specific data access methods and database operator implementations. The query processor communicates with the storage engine, which reads and writes data from the disk, manages records, controls concurrency,...
Post a Comment
Read more