Loading
Object Relational Mapping (ORM) Using NHibernate - Part 1 of 8
To establish the ideas of Object Relational Mapping Internals, Nhibernate fundamentals, Intemediate and Advanced coding concepts using NHibernate more clearly (for me and hopefully to readers).
Oracle database 11g and Microsoft SQL Server 2008
In this article, I want to cover the new features in Oracle 11g and SQL Server 2008 database systems which are two important players always fighting for the top spot in this important market segment of the IT industry. By analyzing these two giants, we can see the trends in the database systems. It’s remarkable to say that I will analyze these database systems from the developer perspective.
Insert Operation In MongoDB Using Robo3T
In this article, we will learn how to insert data in MongoDB using Robo 3T. We will learn from basics because I have written this article focusing on the beginners. We will also learn how we can setup MongoDB environment, with an example using console application.
GUI Tools For MongoDB
In this article, you will learn about GUI Tools in MongoDB. there are several third party tools that provide a GUI interface for MongoDB. Some important GUI tools are discussed here.
What Is The Difference Between DBMS And RDBMS?
DBMS (Database Management System) and RDBMS (Relational Database Management System) are both software systems used to manage and organize databases. The main difference between the two lies in the way they handle data and the relationships between data. A DBMS is a software application that allows users to interact with databases, providing an interface to create, retrieve, update, and delete data. RDBMS is a specific type of DBMS that manages databases based on the relational data model.
Introduction To MongoDB
MongoDB is a popular and widely-used NoSQL (non-relational) database management system designed to handle large volumes of unstructured or semi-structured data. It falls under the category of document-oriented databases, which means it stores data in flexible, JSON-like documents rather than traditional rows and columns found in relational databases.
Object Relational Mapping (ORM) Using NHibernate - Part 3 of 8
Firstly in part 1 of this article series, it had been shown that in ORM, while mapping a one-to-one association between objects to their corresponding tables, the primary key of one table is posted as a foreign key of the other table. But in ORM, mapping a one-to-many association is done differently
Properties of Transaction in Database
In a database context, a transaction refers to a sequence of one or more database operations that are treated as a single unit of work. Transactions are essential for maintaining data integrity, consistency, and reliability in a database management system. Here are some key properties of a transaction:
Oracle: JDBC (Java Database Connectivity)
JDBC (Java database connectivity) is the specification of the standard application programming interface that provides a standard library for accessing relational databases like MS-Access, Oracle or Sybase.
PL/SQL Control Statements in Oracle
PL/SQL control statements are used to manage the flow of execution in Oracle's PL/SQL programming language. They enable developers to make decisions, iterate through data, and perform specific actions based on conditions. These statements include IF-THEN-ELSE for conditional execution, CASE for multi-way branching, LOOP, WHILE for iterative processes, and FOR for looping through a range of values. These control statements are essential for creating structured and efficient programs in Oracle databases.
Database Computer/1012 Overview And Features
The Database Computer/1012 is a cutting-edge and sophisticated database management system that offers robust solutions for efficiently storing, organizing, and retrieving data. With advanced features and capabilities, this database system streamlines data operations and provides optimal performance for various applications. This overview explores the Database Computer/1012 and highlights its key features, making it an essential tool for modern data management needs.
What Is The Difference Between Relational And Non-Relational Database
Relational databases and non-relational databases, also known as NoSQL databases, represent two fundamentally different approaches to storing and organizing data. Understanding the key differences between these two types of databases is essential for making informed decisions when choosing the most suitable database solution for specific use cases.
Decoding Database Sharding: A Comprehensive Overview
Database sharding is a technique used to horizontally partition large databases into smaller, more manageable pieces called "shards." Each shard contains a subset of the data, and together they form the complete dataset. Sharding is employed to distribute the database load across multiple servers, allowing for improved performance and scalability. This overview provides insights into the concept of database sharding and its significance in handling massive amounts of data efficiently.
Database Machine Taxonomy
In the traditional approach of database system, the data is used to be stored in secondary storage devices. Due to this, the ability to perform any arithmetical or logical computing operation is limited to the central processor and the data has to be moved to the main memory from the secondary storage devices, attached to the central processor.
Guid vs. Sequential Integers: A Great Debate in Database Design
Explore the debate between Guids and sequential integers as primary keys in relational databases, weighing the pros and cons for optimal design choices.
Designing and implementing a Data Warehouse: Part 3
This is the third article of a series of articles that I want to write in order to share my knowledge and experience in this subject matter. In this part and the next one, we will see how to implement the technical solution for a data warehouse.
Connection Strings for All Databases
Learn how to obtain database connection strings using UDL files and Visual Studio data sources, with an example of connecting to Oracle using ADO.NET.
Adding Chart Control to SSRS Reports
In this article, I will discuss how to add chart controls to reports defined in SSRS. To work with this, I will use a sample report which I showcased in my article Basics of SSRS.
MongoDB CRUD Operations Using C#
MongoDB CRUD operations using C# refer to performing Create, Read, Update, and Delete operations on MongoDB databases using the C# programming language. By using the MongoDB C# driver, developers can seamlessly integrate MongoDB with their C# applications and perform CRUD operations efficiently, making MongoDB an excellent choice for NoSQL database operations in C# projects.
Cursors and Alternative to the Cursors in SQL Server
In SQL Server, cursors are database objects that allow you to iterate over a result set (query result) one row at a time, processing each row as needed. Cursors are often used when you need to perform complex row-by-row processing or when dealing with situations where set-based operations are not practical or efficient.
Designing and implementing a Data Warehouse: Part 2
This is the second article of a series of articles that I want to write in order to share my knowledge and experience in this subject matter.
Encryption of Stored Procedures in SQL Server
The encryption of stored procedures in SQL Server is a security feature that enables developers to protect the sensitive business logic implemented within the database. By using the WITH ENCRYPTION option, developers can obfuscate the actual T-SQL code, making it challenging for unauthorized users to access and understand the logic behind the stored procedures. This feature enhances data privacy, ensures compliance with regulatory requirements, and deters potential reverse engineering attempts, safeguarding the intellectual property of the application. While encrypted stored procedures cannot be decrypted directly from the system tables, it is essential to manage keys securely and employ effective version control practices to maintain and update the protected procedures efficiently. Overall, encrypting stored procedures is a valuable strategy to secure critical business logic and strengthen the overall security posture of SQL Server databases.
Introduction to Mongo Database: Part 1
Discover MongoDB's power as a high-performance, scalable, and open-source document database. Explore its features, such as no schema, automatic scaling, high availability, and more.
SQL Server & EF7: Using datetime vs datetime2 Data Type
Showing problems with limited accuracy of SqlServer data type “datetime” in .NET7 EF7 environment
What are the Most Popular Relational Databases (2023)
Relational database management systems are the most popular form of database management systems (DBMS) that includes Oracle, SQL Server, MySQL, and DB2. Here is a list of the most popular RDBMS in the world.
Understanding Database Management Systems
In this article, you will learn about Database Management systems.
Difference Between NoSQL And SQL
In this article, you will learn about the difference between NoSQL and SQL.
How Is SQL Is Different Than NoSQL
Most people think data is just a piece of information, but in actuality, data is a piece of information organized in form of relevant information, tables, rows, columns, and indexes to make it easier to retrieve any information.
