| |   Skin:   
      User: Not logged in 
Newsletter Signup
XSLT Library
Latest XML Blogs
Featured Examples
Featured Articles
Book Chapters
Training Courses
Sign In
My Profile
My Articles
My Examples
My Favorites
My Resources
Add a Resource
About Me
My Blog
HeadGeek Articles
Talking Portfolio
World Trip Pics

Prev Next
1 2 3 4 5 6 7 8
Portable Database Functions
Want to write a rock-solid, dependable application, but in record time? Code efficiency is the key! This article provides useful tools and ideas to speed up your database interactions in ASP, as well as a best-practice you just might be convinced to adapt for your database-driven applications.

Type: Database  #Views: 261  Category: Article    

Qoppa Datamorph
To this end, we have created DataMorph, an intuitive, easy to use data conversion tool that provides powerful conversion functions for the most common data interchange formats.

Type: Database  #Views: 382  Category: Tool    

DataPower: FAQ
DataPower supplies enterprises with intelligent XML-aware network infrastructure to address the performance, security and management problems associated with XML.

Type: Database  #Views: 140  Category: FAQ    

Databases and Query Languages
Databases are one of the most useful of business programs available. They are perfect for all sorts of data storage and retrieval, for example, employee records, inventory control, client marketing, logistics, equipment records and more.

Type: Database  #Views: 171  Category: Article    

Comparison of object and relational concepts
A comparison of relational and object model techniques is shown in the following table

Type: Database  #Views: 254  Category: Resource    

Comparison of object and relational terminology
This figure presents a comparison of some basic terms used in relational and object technology...

Type: Database  #Views: 245  Category: Resource    

Inheritance in database
Inheritance in the object model is a means of defining one class in terms of another. This is common usage for most of us. For example, a conifer is a type of tree. There are certain characteristics that are true for all trees, yet there are specific characteristics for conifers.

Type: Database  #Views: 274  Category: Resource    

Encapsulation in a database
Encapsulation is the object model concept of including processing or behavior with the object instances defined by the class. Encapsulation allows code and data to be packaged together. The definition of methods for a class is an integral part of encapsulation. A method is programming code that performs the behavior an object instance can exhibit. Calculating the age of a person would be an example of such behavior.

Type: Database  #Views: 304  Category: Resource    

Data Abstraction
Data abstraction is the process of distilling data down to its essentials. In an object schema, the abstract data model is implemented as a graph. The following figure shows such a graph structure for a genealogical database. For more information on data abstraction, see the items under "more detail" below.

Type: Database  #Views: 286  Category: Resource    

Object or instance locking
Instance locking locks a single relational tuple in an RDBMS or a single object in an ODBMS. This type of concurrency control is illustrated below.

Type: Database  #Views: 260  Category: Resource    

Class or table locking
Class or table locking means that all instances of either a class or table are locked, as is illustrated below. This shows one form of concurrency control. Note the circle at the lower left. It represents all instances of a class, regardless of the page where they are stored.

Type: Database  #Views: 259  Category: Resource    

Cluster locking
Cluster locking or container locking for concurrency control is illustrated in the figure below. In this form of locking, all data clustered together (on a page or multiple pages) will be locked simultaneously. This applies only to clusters of objects in ODBMSs. Note that in this example, the cluster of objects spans portions of three pages.

Type: Database  #Views: 273  Category: Resource    

Page locking
Page locking (or page-level locking) concurrency control is shown in the figure below. In this situation, all the data on a specific page are locked. A page is a common unit of storage in computer systems and is used by all types of DBMSs. In this figure, each rectangle represents a page. Locking for objects is on the left and page locking for relational tuples is on the right. If the concept of pages is new to you, just think of a page as a unit of space on the disk where multiple data instances are stored.

Type: Database  #Views: 261  Category: Resource    

Concurrency control and locking
Concurrency control and locking is the mechanism used by DBMSs for the sharing of data. Atomicity, consistency, and isolation are achieved through concurrency control and locking.

Type: Database  #Views: 250  Category: Resource    

Maintaining updates of committed transactions is critical. These updates must never be lost. The ACID property of durability addresses this need. Durability refers to the ability of the system to recover committed transaction updates if either the system or the storage media fails. Features to consider for durability:

Type: Database  #Views: 207  Category: Resource    

The isolation portion of the ACID properties is needed when there are concurrent transactions. Concurrent transactions are transactions that occur at the same time, such as shared multiple users accessing shared objects. This situation is illustrated at the top of the figure as activities occurring over time. The safeguards used by a DBMS to prevent conflicts between concurrent transactions are a concept referred to as isolation.

Type: Database  #Views: 209  Category: Resource    

Consistency is the ACID property that ensures that any changes to values in an instance are consistent with changes to other values in the same instance. A consistency constraint is a predicate on data which server as a precondition, post-condition, and transformation condition on any transaction.

Type: Database  #Views: 263  Category: Resource    

The phrase "all or nothing" succinctly describes the first ACID property of atomicity. When an update occurs to a database, either all or none of the update becomes available to anyone beyond the user or application performing the update. This update to the database is called a transaction and it either commits or aborts. This means that only a fragment of the update cannot be placed into the database, should a problem occur with either the hardware or the software involved. Features to consider for atomicity:

Type: Database  #Views: 338  Category: Resource    

ACID properties
ACID properties are an important concept for databases. The acronym stands for Atomicity, Consistency, Isolation, and Durability.

Type: Database  #Views: 257  Category: Resource    

Lack of impedance mismatch
Object DBMSs allow you to store objects directly without any mapping to different data structures. Relational DBMSs require mapping from objects to tables. This mapping to different data structures is called "impedance mismatch." The figure below shows direct storage at the left and impedance mismatch at the right.

Type: Database  #Views: 239  Category: Resource    

Prev Next
1 2 3 4 5 6 7 8

Fans of "The Office"
Dwight Bobbleheads are here!
  “It's me! I'm the bobblehead! Yes!”

Advertise on XMLPitstop

Advertise on XMLPitstop

EggHead Cafe
Web Servicee development
Buy text ads here!
desktop online backup
Color Laser Printer
Dior sunglasses
Skype vs. sipcall
VoIP Internettelefonie
Buy text ads here!

Interested in Text ads?
2,219 Total Members
34 members(last 30 days)
5 members(last 7 days)
0 members(today)

1,609 Total Discussions
14 Posts(last 30 days)
0 Posts(last 7 days)
0 Posts(today)

17,106 Total Blog Posts
1,771 Blogs(last 30 days)
235 Blogs(last 7 days)
0 Blogs(today)

8,699 Newsgroup Posts
0 Posts(last 30 days)
0 Posts(last 7 days)
0 Posts(today)

13,785 Total Resources
4 Resources(last 30 days)
0 Resources(last 7 days)
0 Resources(today)


David Silverlight's| 2801 Florida Ave #225|Miami, FL 33133|Ph:305-447-1139