answersLogoWhite

0

What else can I help you with?

Continue Learning about Computer Science

What is procedural data manipulation languages?

Procedural Data Manipulation Languages (DML) are programming languages used to perform operations on data within a database. Unlike declarative languages, which specify what data to retrieve or manipulate, procedural DML focuses on how to accomplish these tasks through a series of commands or procedures. Examples include SQL procedural extensions like PL/SQL and T-SQL, which allow for control structures, loops, and variables to manage data effectively. This approach enables developers to write complex logic and automate data manipulation tasks within their applications.


What technological advances made posibble the age of exploration?

trade played an important part in growth of exploration because it helped them get places faster and know the rite route.


What is database Give example?

A navigational database is a type of database in which records or objects are found primarily by following references from other objects. Navigational interfaces are usually procedural, though some modern systems like XPath can be considered to be simultaneously navigational and declarative.Navigational access is traditionally associated with the network model and hierarchical model of database interfaces, and some have even acquired set-oriented features.[1]Navigational techniques use "pointers" and "paths" to navigate among data records (also known as "nodes"). This is in contrast to the relational model (implemented in relational databases), which strives to use "declarative" or logic programming techniques in which you ask the system for what you want instead of how to navigate to it.For example, to give directions to a house, the navigational approach would resemble something like, "Get on highway 25 for 8 miles, turn onto Horse Road, left at the red barn, then stop at the 3rd house down the road"; whereas, the declarative approach would resemble, "Visit the green house(s) within the following coordinates...."Hierarchical models are also considered navigational because one "goes" up (to parent), down (to leaves), and there are "paths", such as the familiar file/folder paths in hierarchical file systems. In general, navigational systems will use combinations of paths and prepositions such as "next", "previous", "first", "last", "up", "down", "owner", etc."Paths" are often formed by concatenation of node names or node addresses. Example:Sample database nodes: A labeled graph on 6 vertices and 7 edges. (Numbers are used for illustration purposes only. In practice more meaningful names are often used. Other potential attributes are not shown.)Node6.Node4.Node5.Node1OrNode6/Node4/Node5/Node1 If there is no link between given nodes, then an error condition is usually triggered with a message such as "Invalid Path". The path "Node6.Node2.Node1" would be invalid in most systems because there is no direct link between Node 6 and Node 2.The usage of the term "navigational" allegedly is derived from a statement by Charles Bachman in which he describes the "programmer as navigator" while accessing his favored type of database. [1]Except for hierarchical file systems (which some consider a form of database), navigational techniques fell out of favor by the 1980s. However, object oriented programming and XML have kindled a renewed, but controversial interest in navigational techniques.Critics of navigational techniques view them as "unstructured spaghetti messes", and liken them to the "goto" of pre-structured programming. In other words, they are allegedly to data organization what goto's were to behavior flow. In this view, relational techniques provide improved discipline and consistency to data organization and usage because of its roots in set theory and predicate calculus.Some also suggest that navigational database engines are easier to build and take up less memory (RAM) than relational equivalents. However, the existence of relational or relational-based products of the late 1980s that possessed small engines (by today's standards) because they didn't use SQL suggest this is not necessarily the case. Whatever the reason, navigational techniques are still the preferred way to handle smaller-scale structures.A current example of navigational structuring can be found in the Document Object Model (DOM) often used in web browsers and closely associated with JavaScript. The DOM "engine" is essentially a light-weight navigational database. The World Wide Web itself and Wikipedia could potentially be considered forms of navigational databases, though they focus on human-readable text rather than data (on a large scale, the Web is a network model and on smaller or local scales, such as domain and URL partitioning, it uses hierarchies). In contrast, the Linked Data facet of the Semantic Web is specifically concerned with network-scale machine-readable data, and follows precisely the 'follow your nose' paradigm implied by the navigational idea.[edit]See alsoRelational databaseObject databaseNetwork databaseCODASYL[edit]References^ Błażewicz, Jacek; Królikowski, Zbyszko; Morzy, Tadeusz (2003). Handbook on Data Management in Information Systems. Springer. pp. 18. ISBN 3-540-43893-9.View page ratingsRate this pageWhat's this?TrustworthyObjectiveCompleteWell-writtenI am highly knowledgeable about this topic (optional)Submit ratingsCategories:Data managementTypes of databasesCreate accountLog inArticleTalkReadEditView historyMain pageContentsFeatured contentCurrent eventsRandom articleDonate to WikipediaInteractionHelpAbout WikipediaCommunity portalRecent changesContact WikipediaToolboxPrint/exportLanguagesBahasa Melayu日本語This page was last modified on 14 June 2012


What are the advantages of wpf?

Tight multimedia integration - to use 3-D graphics, video, speech, and rich document viewing in Windows 32 or Windows Forms applications, you would need to learn several independent technologies and blend them together without much built-in support. WPF applications allow you to use all these features with a consistent programming model.Resolution independence - WPF lets you shrink or enlarge elements on the screen, independent of the screen's resolution. It uses vector graphics to make your applications resolution-independent.Hardware acceleration - WPF is built on top of Direct3D, which offloads work to graphics processing units (GPUs) instead of central processor units (CPUs). This provides WPF applications with the benefit of hardware acceleration, permitting smoother graphics and enhanced performance.Declarative programming - WPF uses Extensible Application Markup Language (XAML) declarative programming to define the layout of application objects and to represent 3-D models, among other things. This allows graphic designers to directly contribute to the look and feel of WPF applications.Rich composition and customization - WPF controls are easily customizable. You need not write any code to customize controls in very unique ways. WPF also lets you create skins for applications that have radically different looks.Easy deployment - WPF provides options for deploying traditional Windows applications (using Windows Installer or ClickOnce) . This feature is not unique to WPF, but is still an important component of the technology.Culturally aware controls - static text in controls and the return data for the String function are modified according to the culture and language specified by the end user's operating system.


What is the difference between sql and pl-sql?

Platform dependency-The primary difference is with respect to platform dependency, SQL is basically limited to the Windows platform where as Oracle is operable on multiple platforms such as Windows, UNIX and Linux etc. This multi-platform compatibility of Oracle makes it a universal enterprise solution, which makes it mandatory for the Oracle DBA to be acquainted with the different platforms where as the Sql DBA just needs to be familiar with the windows platform..Clustering technology-Oracle is significantly ahead of its opponent when it comes to clustering technology, Oracle makes use of RAC technology which enables two instances to act on the same data in active-active configurations.Locking and concurrency -Oracle had a multi-version consistency model which means that "readers don't block writers and writers don't block readers." Sql on the other hand has a very simple locking mechanism which follows the rule that "writers block readers and readers block writers."File system-Oracle includes IFS (Internet File System), Java integration, SQL is more of a pure database.Replication -SQL Server provides a far more simple and flexible system for replication and synchronizing of data when compared to Oracle, it involves a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency.Administration-SQL server GUI is simple and easy to work with where as the Oracle server is not very user friendly as most of it command line is based.by....... Sankar

Related Questions

What is the difference between Procedural DMLs and Declarative DMLs.?

Procedural DMLs (Data Manipulation Languages) allow users to specify how to perform operations on data, providing control over the execution process through programming constructs like loops and conditionals. In contrast, Declarative DMLs focus on what data to retrieve or manipulate without detailing how to achieve it, allowing the database management system to determine the best execution plan. Essentially, procedural DMLs require explicit instructions for processing, while declarative DMLs emphasize the desired outcome. Examples include SQL as a declarative language, and PL/SQL as a procedural extension of SQL.


What is the difference between Procedural DMLs and Declarative DMLs?

Procedural DMLs (Data Manipulation Languages) require the user to specify a sequence of operations to manipulate data, allowing for more control and flexibility in how tasks are executed. In contrast, Declarative DMLs focus on what data to retrieve or manipulate without detailing the steps to achieve it, making them generally easier to use. Examples include SQL for Declarative DMLs, while Procedural DMLs can include languages like PL/SQL or T-SQL. The choice between them often depends on the complexity of the operations and the level of control needed by the developer.


WHAT ARE Declarative DMLs?

Declarative Data Manipulation Languages (DMLs) are programming languages that allow users to specify what data to manipulate without detailing how to perform the operations. They focus on the desired outcome rather than the procedure, enabling simpler and more intuitive data interactions. SQL (Structured Query Language) is a prime example, where users can execute commands like SELECT, INSERT, UPDATE, and DELETE to manage data in relational databases. This contrasts with imperative DMLs, which require detailed procedural steps to achieve the same results.


What Is the difference between procedural and nonprocedural DMLs?

One has non informs of it


Ouch that hurts is this declarative interrogative imperative or exclamatory?

EXCLAMATORY!


What is a declarative language?

Declarative language is language that states something. A declarative statement always ends with a period.


What is the symbol for declarative?

The symbol for declarative is usually a period or full stop (.), indicating the end of a declarative sentence.


Can you give me a declarative sentence?

I can give you many declarative sentences.(declarative) The dog walked down the street.(declarative) The cat puts socks in the dog bowl.(declarative) It is hard to do a toddler's hair. The curtains fell down.


What punctuation mark is placed after a declarative sentence?

declarative


Is he has ten finger and ten toes an declarative?

It is a declarative.


How careless of you to forget the soap is that a declarative sentence?

Yes, that is a declarative sentence. It makes a statement or expresses an opinion without posing a question or giving a command.


How is a declarative sentence punctuated?

A declarative sentence is ended with a period.