Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles by karthikeya Boyini
Page 60 of 142
Why SHOW DBS does not show my databases in MongoDB?
The SHOW DBS command in MongoDB will not display a database until that database contains at least one collection with documents. MongoDB only allocates disk space for databases that actually contain data, which is why empty databases remain invisible in the database list. Syntax show dbs; // OR show databases; Example: Creating a Database Let's create a database named "web" and see why it doesn't appear in the database list ? use web; switched to db web Now let's check all databases ? show dbs; ...
Read MoreOne-to-Many Relationship Model
In a "class roster" database, a teacher may teach zero or more classes, while a class is taught by one (and only one) teacher. In a "company" database, a manager manages zero or more employees, while an employee is managed by one (and only one) manager. In a "product sales" database, a customer may place many orders, while an order is placed by one particular customer. This kind of relationship is known as one-to-many. Why One-to-Many Cannot Be Represented in a Single Table If we begin with a table called Teachers and try to store classes taught, we ...
Read MoreCloud Databases
A cloud database is a database that has been optimized or built for a virtualized environment, deployed in a hybrid cloud, public cloud, or private cloud. Cloud databases offer the ability to pay for storage capacity and bandwidth on a per-user basis, provide scalability on demand, and deliver high availability. They also give enterprises the opportunity to support business applications in a software-as-a-service (SaaS) deployment. Cloud Database DB DB DB ...
Read MoreOperational Database
An operational database is a system designed to store information related to the day-to-day operations of an enterprise. Functional lines like marketing, employee relations, customer service, inventory management, and sales require such databases to maintain current and frequently accessed data. Operational databases are also known as OLTP (Online Transaction Processing) systems because they handle real-time transactions and support the ongoing operations of a business. Key Characteristics Real-time processing − Handle immediate transaction processing. High concurrency − Support multiple users accessing data simultaneously. Data integrity − Maintain ACID properties for reliable transactions. Normalized structure − Reduce data ...
Read MoreCommercial Database
A Commercial Database is a paid database service designed for users who need access to large volumes of specialized information. These databases are subject-specific, containing vast amounts of curated data that individual organizations cannot afford to collect and maintain on their own. Access is provided through commercial links or subscription plans. Commercial Database Access Model Commercial Database Paid Access ...
Read MorePersonal database
A Personal Database is a small, single-user database that is stored and managed on a personal computer. The data is collected and used by an individual or a small group of people, typically within the same department of an organization. Personal databases are designed for simplicity and ease of use, making them ideal for managing personal information, small projects, or departmental data without the complexity of enterprise-level systems. Characteristics Personal databases have several key characteristics that distinguish them from larger database systems − Single-user − Designed for one user or a small group at a time. Small size − ...
Read MoreUse decimal in where clause in SAP ABAP
When working with decimal values in SAP ABAP WHERE clauses, you might encounter issues if you try to use locale-specific decimal separators. ABAP does not support user-specific regional settings for decimal notation in SQL queries. You must always use the standard dot (.) as the decimal separator instead of comma (, ) or other regional separators. Using Decimal Values in WHERE Clause The correct syntax requires using a dot (.) as the decimal separator, regardless of your system's regional settings. Here's the proper approach − SELECT ...
Read MoreIntegrating JSession in a Web-Service in SAP
Integrating JSession in a SAP web service requires proper configuration of the SOAP manager transaction to maintain session state across HTTP calls. Configuring SOAP Manager Transaction You need to configure the soap manager transaction with the following steps − First, specify the proxy that you have created in the configuration Specify the port number for the web service endpoint Set the access path from transport settings to define the URL pattern Using cl_http_client for Session Management The SAP system makes use ...
Read MoreInvoke a Web service from AJAX in SAP application
Invoking web services from AJAX in SAP applications follows the same principles as other web technologies like .NET. The main difference lies in how you obtain the service details and configure the connection. You need to send a POST or GET request to the intended service using the appropriate URL endpoint. Getting the Service URL and Details To get the service URL, you need to work with the ABAP developer who is responsible for exposing the web service. They will provide you with the WSDL (Web Services Description Language) file that contains all the necessary details about ...
Read MoreIdentify required fields for an MB01 transaction in SAP
The MB01 transaction in SAP is used for goods receipts and material movements. To identify the required fields for this transaction, you can leverage your SAP system access to find the proper documentation and field requirements. Using SE37 Transaction for BAPI Documentation Since you have access to the SAP system, the solution lies within. Specify the transaction SE37 and mention the BAPI call that you have identified. It will navigate you to proper documentation of the call. The SE37 transaction is the Function Builder in SAP, which allows you to view and ...
Read More