Question

What are the Advantages and Disadvantages of Single Row Functions.

Answer 1

Single Row Functions:

Single Row function is a type of function which we use in DBMS. Generally these type of functions are used for data manipulation. Single Row Functions work on each row and returns records by query. To return records we need to provide arguments. These arguments may be variable, attribute or expression.

Sungle Row Functions Categorized as :

• Character functions: These functions accepts input as Character and returns both character and integer•
• Number functions: These functions accepts Integer as input and return numeric values •
• Date functions: Works on date datatype
• Conversion functions: These functions convers one type of datatype to another.

Advantages:

• To retrieve data of each record(row).
• Returns atomic result.
• These functions can be nested
• We can retrive different type of datatypes.
• To manipulate data items.
• We can provide more than one argument.
  

Disadvantages:

• The only disadvantage is Denormalization of Database

Denormalization: In DBMS,Denormalization is a technique which is used to optimize the data. In this technique, we add redundant data to the tables. Denormalization avoids joins in a relational tables. Single Row Functions retrieves single record information from Denormalized table.