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 David Meador
Page 12 of 12
Spatial Databases
Spatial data is associated with geographic locations such as cities, towns etc. A spatial database is optimized to store and query data representing objects. These are the objects which are defined in a geometric space.Characteristics of Spatial DatabaseA spatial database system has the following characteristicsIt is a database systemIt offers spatial data types (SDTs) in its data model and query language.It supports spatial data types in its implementation, providing at least spatial indexing and efficient algorithms for spatial join.ExampleA road map is a visualization of geographic information. A road map is a 2-dimensional object which contains points, lines, and polygons ...
Read MoreDatabase Design Methodologies
Database Design Methodologies has phases to guide the designer for assistance. The Methodology has a structured approach to help in the design process.The following are the phases/ models −Conceptual PhaseThe Conceptual phase lets you know the entities and the relation between them. It describes the conceptual schema. The entities & relations are defined here.Logical PhaseLogical data model provides details about the data to the physical phase. The physical process gives ER Diagram, data dictionary, schema, etc that acts as a source for the physical design process.Physical PhaseThe physical database design allows the designer to decide on how the database will ...
Read MoreTypes of Entity Relationships in DBMS
Entity in DBMS can be a real-world object with an existence, For example, in a Company database, the entities can be Employees, Department, Project, etc. In a College database, the entities are Profession, Students, Result, Activities, etc.An entity is represented as a single rectangle, shown belowThe following are the entity relationships −One-to-One RelationshipUnder One-to-One (1:1) relationship, an instance of entity P is related to instance of entity Q and an instance of entity Q is related to instance of entity P.Let us see an example −A person can have only one passport, and a passport is assigned to a single person.One-to-Many RelationshipUnder ...
Read MoreHow to include multiple js files using jQuery $.getScript() method?
To use multiple js files, use the same getScript(), which is used to add a single js file. We’re having result.js file with the following code snippet −function CheckJS(){ alert("This is JavaScript - File1"); }We’re having result2.js file with the following code snippet −function CheckJS(){ alert("This is JavaScript – File2"); }ExampleHere's the code snippet to add multiple js files. Here, we will call the function in the above 2 js files − ...
Read MoreWhat is the difference between Ajax and jQuery-Ajax methods in jQuery?
Firstly, let’s go through what is Ajax and why it is used.AJAXAJAX stands for Asynchronous JavaScript and XML. AJAX is a new technique for creating better, faster, and more interactive web applications with the help of XML, HTML, CSS, and Java Script.It has the following points, which shows its importance.AJAX stands for Asynchronous JavaScript and XML. AJAX is a new technique for creating better, faster, and more interactive web applications with the help of XML, HTML, CSS, and Java Script.Ajax uses XHTML for content, CSS for presentation, along with Document Object Model and JavaScript for dynamic content display.With AJAX, when ...
Read MoreWhat is the difference between jQuery and AngularJS?
AngularJS is an open source web application framework. It was originally developed in 2009 by Misko Hevery and Adam Abrons. It is now maintained by Google. Its latest version is 1.4.3.The following are the features of AngularJS:AngularJS is a powerful JavaScript based development framework to create RICH Internet Application(RIA).AngularJS provides developers options to write client side application (using JavaScript) in a clean MVC(Model View Controller) way.Application written in AngularJS is cross-browser compliant. AngularJS automatically handles JavaScript code suitable for each browser.AngularJS is open source, completely free, and used by thousands of developers around the world. It is licensed under the ...
Read More