- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Mithlesh Upadhyay has Published 47 Articles
![Mithlesh Upadhyay](https://www.tutorialspoint.com/assets/profiles/655330/profile/60_3996324-1684216489.jpg)
Mithlesh Upadhyay
2K+ Views
MySQL Recursive CTE allows users to write queries that involve recursive operations. Recursive CTE is an expression that is defined recursively. It is useful in hierarchical data, graph traversals, data aggregation, and data reporting. In this article, we will discuss Recursive CTE with its syntax and examples. Introduction Common Table ... Read More
![Mithlesh Upadhyay](https://www.tutorialspoint.com/assets/profiles/655330/profile/60_3996324-1684216489.jpg)
Mithlesh Upadhyay
845 Views
Neo4j database is one of the most popular choices in graph databases. One of the reasons for this is its powerful query language, Cypher. Neo4j has developed its own query language called Cypher, which differs from SQL in that it operates on nodes rather than tables, rows, and columns. Its ... Read More
![Mithlesh Upadhyay](https://www.tutorialspoint.com/assets/profiles/655330/profile/60_3996324-1684216489.jpg)
Mithlesh Upadhyay
30K+ Views
Normalization is a process of organizing data in a database to reduce redundancy and improve data consistency. Primary keys are really important in organizing information in a database. They help to make sure that every row in a table has a unique identification so that nothing gets mixed up or ... Read More
![Mithlesh Upadhyay](https://www.tutorialspoint.com/assets/profiles/655330/profile/60_3996324-1684216489.jpg)
Mithlesh Upadhyay
4K+ Views
An architecture pattern is a way of organizing data in a logical and structured manner. So, it can be stored and accessed efficiently. NoSQL databases are different from traditional relational databases. Because Tables are not used to store data in it. It uses document-oriented, key-value or graph formats. It makes ... Read More
![Mithlesh Upadhyay](https://www.tutorialspoint.com/assets/profiles/655330/profile/60_3996324-1684216489.jpg)
Mithlesh Upadhyay
3K+ Views
In database management systems (DBMS), super keys are an essential concept used to identify unique records in a table. A super key is a set of one or more than one attribute that can uniquely identify a record in a table. In this article, we will explore the number of ... Read More
![Mithlesh Upadhyay](https://www.tutorialspoint.com/assets/profiles/655330/profile/60_3996324-1684216489.jpg)
Mithlesh Upadhyay
1K+ Views
You should consider the needs of the applications during designing a database. Object databases offer a unique approach to database design that can be beneficial in certain situations. In this article, we will discuss the conceptual design of object databases. Object database design Object-Oriented Model is process of representing real-world ... Read More
![Mithlesh Upadhyay](https://www.tutorialspoint.com/assets/profiles/655330/profile/60_3996324-1684216489.jpg)
Mithlesh Upadhyay
2K+ Views
DBMS supports object-oriented data. It ensures direct correspondence between real-world objects and their representations in the database. This correspondence ensures that objects retain their integrity and identity. It enables easy identification and manipulation. Object Data Management System (ODMS) assigns unique identity to each independent object stored in the database. This ... Read More
![Mithlesh Upadhyay](https://www.tutorialspoint.com/assets/profiles/655330/profile/60_3996324-1684216489.jpg)
Mithlesh Upadhyay
1K+ Views
In DBMS, there are object-relational features that combine elements of object databases with SQL. SQL language is used for relational databases, and it has evolved over time. In the latest standard called SQL:2008, object features have been incorporated, although not all commercial DBMSs have implemented these features yet. Object-relational model ... Read More
![Mithlesh Upadhyay](https://www.tutorialspoint.com/assets/profiles/655330/profile/60_3996324-1684216489.jpg)
Mithlesh Upadhyay
4K+ Views
Offset-Fetch is feature in MS SQL Server. It helps to retrieve subset of rows from result set. It consists of two components: OFFSET and FETCH. The OFFSET clause specifies the number of rows to skip from the beginning of the result set. FETCH clause determines the number of rows to ... Read More
![Mithlesh Upadhyay](https://www.tutorialspoint.com/assets/profiles/655330/profile/60_3996324-1684216489.jpg)
Mithlesh Upadhyay
664 Views
OLAP (Online Analytical Processing) is data processing technique. It is used to query and analyze data. It analyze data in real time from multiple sources. In 1993, EF Codd introduced 12 rules for the relational database model for OLAP systems. These rules are known as "Codd’s rules". These rules serve ... Read More