Pages

Sunday 4 March 2012

SQL Commands:


http://study-material-database-programming.blogspot.in/







SQL commands are instructions used to communicate with the database to perform specific task that work with data. SQL commands can be used not only for searching the database but also to perform various other functions like, for example, you can create tables, add data to tables, or modify data, drop the table, set permissions for users. SQL commands are grouped into four major categories depending on their functionality:



Data Definition Language (DDL) - These SQL commands are used for creating, modifying, and dropping the structure of database objects. The commands are CREATE, ALTER, DROP, RENAME, and TRUNCATE.
Data Manipulation Language (DML) - These SQL commands are used for storing, retrieving, modifying, and deleting data. These commands are SELECT, INSERT, UPDATE, and DELETE.



Transaction Control Language (TCL) - These SQL commands are used for managing changes affecting the data. These commands are COMMIT, ROLLBACK, and SAVEPOINT.
Data Control Language (DCL) - These SQL commands are used for providing security to database objects. These commands are GRANT and REVOKE.



Regards,

Ruchika Mandore  [ MCA ] 
Software Engineer
AeroSoft Corp

On Line Assistence  :
Gtalk                    :   ruchika.aerosoft@gmail.com
Y! Messenger             :   ruchika.aerosoft@yahoo.com
Rediff Bol               :   ruchika.aerosoft@rediffmail.com
MSN                      :   ruchika.aerosoft@hotmail.com


On Line Assistence  :
Gtalk                    :   ruchika.aerosoft@gmail.com
Y! Messenger             :   ruchika.aerosoft@yahoo.com
Rediff Bol               :   ruchika.aerosoft@rediffmail.com
MSN                      :   ruchika.aerosoft@hotmail.com

learn online marketing, at http://internationalschoolofinternetmarketing.com Also learn online advertising, learn email marketing, learn search engine marketing, learn affiliatemarketing, learn seo,
 s:  | 

SEARCH JOBS MAKE FRIENDS, HAVE FUN


http://aerosoftseo.com/SEOjobs/ SEO Jobs & Careers - Search Engine Marketing Job Site Jobs In Search advertise Search Engine related Job and Career Vacancies o
 1 attachment: 

Friday 2 March 2012

Introduction to the Oracle Database


http://study-material-database-programming.blogspot.in/






Oracle Database Architecture


An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

Oracle Database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. Enterprise grid computing creates large pools of industry-standard, modular storage and servers. With this architecture, each new system can be rapidly provisioned from the pool of components. There is no need for peak workloads, because capacity can be easily added or reallocated from the resource pools as needed.

The database has logical structures and physical structures. Because the physical and logical structures are separate, the physical storage of data can be managed without affecting the access to logical storage structures.





Overview of Oracle Grid Architecture


Grid computing is a new IT architecture that produces more resilient and lower cost enterprise information systems. With grid computing, groups of independent, modular hardware and software components can be connected and rejoined on demand to meet the changing needs of businesses.

The grid style of computing aims to solve some common problems with enterprise IT: the problem of application silos that lead to under utilized, dedicated hardware resources, the problem of monolithic, unwieldy systems that are expensive to maintain and difficult to change, and the problem of fragmented and disintegrated information that cannot be fully exploited by the enterprise as a whole.

Benefits of Grid Computing Compared to other models of computing, IT systems designed and implemented in the grid style deliver higher quality of service, lower cost, and greater flexibility. Higher quality of service results from having no single point of failure, a robust security infrastructure, and centralized, policy-driven management. Lower costs derive from increasing the utilization of resources and dramatically reducing management and maintenance costs. Rather than dedicating a stack of software and hardware to a specific task, all resources are pooled and allocated on demand, thus eliminating under utilized capacity and redundant capabilities. Grid computing also enables the use of smaller individual hardware components, thus reducing the cost of each individual component and providing more flexibility to devote resources in accordance with changing needs.




Oracle Database Application Development


SQL and PL/SQL form the core of Oracle's application development stack. Not only do most enterprise back-ends run SQL, but Web applications accessing databases do so using SQL (wrappered by Java classes as JDBC), Enterprise Application Integration applications generate XML from SQL queries, and content-repositories are built on top of SQL tables. It is a simple, widely understood, unified data model. It is used standalone in many applications, but it is also invoked directly from Java (JDBC), Oracle Call Interface (OCI), Oracle C++ Call Interface (OCCI), or XSU (XML SQL Utility). Stored packages, procedures, and triggers can all be written in PL/SQL or in Java.



Regards,

Ruchika Mandore  [ MCA ] 
Software Engineer
AeroSoft Corp

On Line Assistence  :
Gtalk                    :   ruchika.aerosoft@gmail.com
Y! Messenger             :   ruchika.aerosoft@yahoo.com
Rediff Bol               :   ruchika.aerosoft@rediffmail.com
MSN                      :   ruchika.aerosoft@hotmail.com

optical disk,
magnetic disk,
optical disk drive,
optical disk cartridge,
optical disk apparatus,
optical disk device,
optical disk recording,
optical disk manufacturing,
microfilm,

Thursday 1 March 2012

What is Cardinality


http://study-material-database-programming.blogspot.in/







Cardinality is the term used in database relations to denote the occurrences of data on either side of the relation. In the common data architecture, cardinality is documented with data integrity but not with data structure.

There are several types of cardinality defining relationships between occurrences of entities on two sides of the line of relationships.

The Link Cardinality is a 0:0 relationship and defined as one side does not need the other to exists. For example, in a person and parking space relationship, it denotes that I do not need to have a person to have a parking space and I don’t need a parking space to have a person either. It also denotes that a person can only occupy one parking space. This relation need to have one entity nominated to become the dominant table and use programs or triggers to limit the number of related records stored inside the other table in the relation.

The Sub-type Cardinality is a 1:0 relationship and defined as having one optional side only. An example would be a person and programmer relation. This is a 1:0 relation meaning that a person can be a programmer but a programmer must always be a person. The mandatory side of the relation, in the case the programmer side, is dominant in the relationship. Triggers and programs are again used in the controlling the database.

The Physical Segment Cardinality is 1:1 relationship and it is demonstrated that both sides of the relationship are mandatory. Example may be a person and DNA patters. This relationship show that a person must only have one set of DNA patterns while the DNA patters as dictated by nature can only be applied on one person.

The Possession Cardinality is a 0:M relation (zero to many) relationship on both sides. For example, a person may own no phone or maybe plenty of phones but a phone may have no owner but has a potential to be owned by a person. In database implementation, a nullable foreign key column in the phone table is used to reference the person in its table.

The Child Cardinality is a 1:M mandatory relationship and is one of the most common relationships used most databases. An example would be a person table and membership table relationship. This relationship denotes that a person can be a member or not but a person can also be a member of many organizations. The foreign key in the membership table has to be mandatory and not null.

The Characteristic Cardinality is a 0:M relationship which is mandatory on both sides. An example would be a person and name table relationship. This denotes that a person should have at least one name but may also many names. The database implantation for this cardinality involves a nullable foreign key in the name table to the person table.

The Paradox Cardinality is 1:M relationship which is mandatory to one side. An example would be a person table and citizenship table relationship. The Paradox is similar to the Physical Cardinality. A person must have a citizenship and citizenship must have a person. But in this case, a person may have multiple citizenships.



Regards,

Ruchika Mandore  [ MCA ] 
Software Engineer
AeroSoft Corp

On Line Assistence  :
Gtalk                    :   ruchika.aerosoft@gmail.com
Y! Messenger             :   ruchika.aerosoft@yahoo.com
Rediff Bol               :   ruchika.aerosoft@rediffmail.com
MSN                      :   ruchika.aerosoft@hotmail.com



to International School of Internet Marketing
http://internationalschoolofinternetmarketing.com/

SEO JOBS