Home Databases Database Management System (DBMS)
Questions:Ask|Latest


 
 

Share on Google+Share on Google+

Database Management System (DBMS)

Advertisement
A Database Management System is also know as DBMS. These days RDBMS are used to store Gigabytes of data for banking, E-commerce, web portals and many such applications. In this section we will learn about RDBMS such as MySQL, Oracle etc.

Database Management System (DBMS)

A Database Management System (DBMS) sometimes called a database manager or database system is a set of computer programs that controls the creation, organization, maintenance, and retrieval of data from the database stored in a computer. It allows the individuals or entities to easily access and use the data from database. An excellent database system helps the end users to easily access and use the data and also stores the new data in a systematic way. It knows better the actual physical location of the data.

A DBMS is a system software package that ensures the integrity and security of the data. The most typical DBMS is a relational database management system (RDBMS). A newer kind of DBMS is the object-oriented database management system (ODBMS). The DBMS are categorized according to their data types and structure. It accepts the request for the data from an application program and instructs the operating system to transfer the appropriate data to the end user. A standard user and program interface is the Structured Query Language (SQL).

Database Tutorials:

There are many Data Base Management System like MySQL, PostgreSQL, Microsoft Access, SQL Server, FileMaker, Oracle, RDBMS, dBASE, Clipper, FoxPro and many more that work independently and freely but also allow other database systems to be integrated with them. For this DBMS software comes with an Open Database Connectivity (ODBC) driver ensuring the databases to be integrated with it.

A DBMS includes four main parts: modeling language, data structure, database query language, and transaction mechanisms Modeling language.

Modeling Language: A data modeling language to define the schema (the overall structure of the database) of each database hosted in the DBMS, according to the DBMS database model. The schema specifies data, data relationships, data semantics, and consistency constraints on the data. The four most common types of models are the:

  • Hierarchical model
  • Network model
  • Relational model
  • Object model

The optimal structure depends on the natural organization of the application's data, and on the application's requirements that include transaction rate (speed), reliability, maintainability, scalability, and cost.

Data Structures: Data structures which includes fields, records, files and objects optimized to deal with very large amounts of data stored on a permanent data storage device like hard disks, CDs, DVDs, Tape etc.

Database Query Language: Using the Database Query Language (DQL) users can formulate requests and generate reports. It also controls the security of the database. The DQL and the report writer allows users to interactively interrogate the database, analyze its data and update it according to the users privileges on data. For accessing and using personal records there is a need of password to retrieve the individual records among the bunch of records. For Example: the individual records of each employee in a factory.

Transaction mechanisms modeling language: The transaction mechanism modeling language ensures about data integrity despite concurrent user accesses and faults. It maintains the integrity of the data in the database by not allowing more than one user to update the same record at the same time. The unique index constraints prevent to retrieve the duplicate records like no two customers with the same customer numbers (key fields) can be entered into the database.

The Latest Trend

Among several types of DBMS, Relational Database Management System (RDBMS) and Object-oriented Database Management System (OODBMS) are the most commonly used DBMS software.

The RDBMS is a Database Management System (DBMS) based on the relational model in which data is stored in the form of tables and the relationship among the data is also stored in the form of tables. It was introduced by E. F. Codd, which is the most popular commercial and open source databases now days. The most popular RDBMS is:

OODBMS: Object-Oriented Database Management System (OODBMS) in short Object Database Management System (ODBMS) is a database management system (DBMS) that supports the modeling and creation of data as objects. It includes some kind of support for classes of objects and the inheritance of class properties and methods by subclasses and their objects. An ODBMS must satisfy two conditions: it should be an object-oriented programming language and a DBMS too.

OODBMS extends the object programming language with transparently persistent data, concurrency control, data recovery, associative queries, and other database capabilities.
At present it is on its development stage and used in Java and other Object Oriented programming language.

Earlier it was introduced to replace the RDBMS due to its better performance and scalability but the inclusion of object-oriented features in RDBMS and the origin of Object-relational mappers (ORMs) made it enough powerful to defend its persistence. The higher switching cost also played a vital role to defend the existence of RDBMS. Now it is being used as a complement, not a replacement for relational databases.

Now it is being used in embedded persistence solutions in devices, on clients, in packaged software, in real-time control systems, and to power websites. The open source community has created a new wave of enthusiasm that's now fueling the rapid growth of ODBMS installations.

The most commonly DBMS are:

  • SQL
  • MySQL
  • SQLite
  • PostgreSQL
  • Microsoft Access
  • SQL Server
  • FileMaker
  • DB2
  • Oracle
  • Firebied
  • DBASE
  • Clipper
  • FoxPro
  • MongoDB
Advertisements

Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: October 9, 2006

Ask Questions?    Discuss: Database Management System (DBMS)  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
ramji meghwal
May 24, 2011
java and vb,internet,data structure

i want to know answer the question thanks
chveeranna
June 2, 2011
Sql Server

i need sql server tutorial
Nasiru ope
June 25, 2011
Research

What data are you likely to collect when you fail to anticipate the strategies for your data
zama
June 27, 2011
Laptop need

I am a student of IT at majuba colledge in newcastle, but its impossible to study without a computer at home
meenakshi.H.N
June 29, 2011
Pro C

do SQL server support embedding sql into C HLL? how to work on emkbedded SQL using C & Oracle
Tanakala Srikant
June 29, 2011
DBMS

I need a online trainer at Oracle Database,SQ L.
shere mitesh
June 29, 2011
feedback

this website is amazing... thanks a lot....
Abhishek
June 29, 2011
transport management system programming in java

plz mention
Abhishek
June 29, 2011
transport management system programming in java

plz mention program
Fanni
June 15, 2013
iEVfaoJohWsCT

Whoa, things just got a whole lot esaier.
Marnie
June 15, 2013
TuUZUiQlDCCXbc

Why does this have to be the ONLY relabile source? Oh well, gj!
Aamirkhan
August 23, 2011
to create a .war file of jsp file

Hi! i want to create a .war file of my temp.jsp file..how to do that..is there any way to do that in net beans..reply me as soon as possible..
senthilkumar.j
August 23, 2011
COOMENT

GOOD
Irais
June 12, 2013
JgisEOVRNAjgkAamaAK

Heck yeah this is ecaxlty what I needed.
D.VIKRAM
August 29, 2011
core java

what is the garbage collectoin
Assem
June 13, 2013
bjsXCBWccaxrkY

Which Career is Better?None of the careers you lisetd is better than the other because you will find professionals thriving and succeeding in all of them.The idea of choosing a career because you think that it is better than the other is a subjective way of making a choosing a career.An alternative, perhaps better method is to realize that while one career is good for someone, it may not be good for you.In other words, it is the YOU in that makes the difference. It is actually better to ask the question this way:1. Which Career Is Better For ME ?2. Where can I make a difference?In answering the first question:Which career is better for me, you will have to make a list of your goals, dreams, passions, interests, abilities, likes, dislikes, strengths, weaknesses use that to evaluate your opportunities and threats.Again, I say it is the YOU that makes the difference. You have to look at your own goals, dreams, ambitions, financial needs, etc.Here are a few questions that you can answer that will help you make a better decision:1. Is making a lot of money important to you? If yes, which of these careers will help you earn a lot of money.2. Can you afford a career that requires you to spend 4 years in and incur college debt? A few careers require a masters degree or an expensive and long college education.3. How good are you at the skills required for those careers in comparison to others? Answering this question means that you have to make an inventory of the skills required in each career and then evaluate how your skills compares to others. E.g. as a Technical Writer, documentation and writing skills will be the primary skills you must practice and / or enjoyBy using more objective criteria like those mentioned in this post, you would be able to evaluate which career is better for you.Let me know if this answers your question or if you need more help VN:F [1.9.22_1171](1 vote cast) -8Was this answer helpful?
donald
June 6, 2013
php

Advance php
k.srinubaburoy
September 3, 2011
very good

i have mo number of latest information.
Anil Kumar Singh
September 7, 2011
sql

i hv little knowledge about the sql. so want to know more about it....please help me...
ABC
September 12, 2011
Good

very good site for learning..............
Farid Ahmad Fayeez
September 13, 2011
Access database construction/management

I am searching an institute that could provide me Access training where I can learn the following topics: - how to create/develop a database - data analysis - data cleaning - data modeling - data security - data warehouse and - data mining Also there will be some topics that I forget to write you. thanks.
Basavaraj Patil
September 23, 2011
Plz reply answers for this query..

1. Develop a database application to demonstrate storing and retrieving of BLOB and CLOB objects. 2. Develop a database application to demonstrate the representation of multivalued attributes, and the use of nested tables to represent complex objects. Write suitable queries to demonstrate their use. 3. Design and develop a suitable Student Database application. One of the attributes to me maintained is the attendance of a student in each subject for which he/she has enrolled. Using TRIGGERS, write active rules to do the following: a. Whenever the attendance is updated, check if the attendance is less than 85%; if so, notify the Head of the Department concerned. b. Whenever, the marks in an Internal Assessment Test are entered, check if the marks are less than 40%; if so, notify the Head of the Department concerned. 4. Design, develop, and execute a program in a language of your choice to implement any one algorithm for mining association rules. Run the program against any large database available in the public domain and discuss the results.
Amit tripathi
September 26, 2011
sql Server

Hai..
MITHUN KUMAR
October 5, 2011
c++

c++
satya prakash
January 30, 2013
dbms

Design and develop a suitable Student Database application. One of the attributes to me maintained is the attendance of a student in each subject for which he/she has enrolled. Using TRIGGERS, write active rules to do the following: a. Whenever the attendance is updated, check if the attendance is less than 85%; if so, notify the Head of the Department concerned. b. Whenever, the marks in an Internal Assessment Test are entered, check if the marks are less than 40%; if so, notify the Head of the Department concerned.
Ramesh
October 18, 2011
DBMS

On the bases of oracle is there any courses available for certification?Please answer me.
vamsi
November 8, 2011
steps to create Procedures & functions in ASP.NET

Need Description............
rabia
November 9, 2011
asp.net

know about how to do post button coding on discussion forum.
rupesh kumar
November 18, 2011
bank project

we need exe file of bank in vb
hussain
November 25, 2011
database

what is the syntax for the query "Select customer names having account but not loan" the tables are 1. account 2. branch 3.loan 4.customer with relationships: customer-account: 1-M customer-loan: 1-M branch-loan: 1-M branch-account: 1-M
Noviea
March 5, 2013
bQflLuCHsTZzd

had less than one MEGAbyte of memory. No hard disk, just two 360 kB fopply disk drives and 128K of RAM. I just got saddled with a data-mining project that will process tens of gigabytes of data in a networked environment. My analysis tools can use SQL to access the data. This book was the first thing I insisted on. (Kind of embarassing for a senior person to be seen carrying a thick yellow and black book with the word DUMMIES on it )This has proven to be an excellent starting point. I know plenty about computers and programming. I vaguely remember the essentials of relational databases (for those who don't, basic information is in the book, it should be enough to get started, even if you are absolutely ignorant!) Taylor packaged enough of the right information that I could read his book over the weekend and dive into the planning stages of our project on Monday sounding like I knew a thing or two. The book charts a course from the most basic elements of databases to modestly complicated database and query materials. The author discusses common pitfalls and useful strategies. This book isn't enough, by itself, to turn somebody into a database wonk, but it's a great starting point.I got a bit annoyed by some of the cute material used to make the subject seem less threatening, but that filler doesn't take up too much space and is easily skipped. Also, the book is overly Microsoft centered the author uses Windows applications as examples and champions Microsofts ODBC. A section about using SQL in a Unix/Linux environment should have been included (access from shell scripts, PERL, etc?). A solid four-star introduction to SQL and database technology in a Microsoft world.(If you'd like to discuss this book or review in more detail, please click on the about me link above and drop me some email. Thanks!)
Ekayzm
March 6, 2013
ELqLnMkcgIqwQG

hey there and thank you for your information â?? Iâ??ve cnrtaiely picked up anything new from right here. I did however expertise several technical issues using this site, since I experienced to reload the web site a lot of times previous to I could get it to load properly. I had been wondering if your hosting is OK? Not that I'm complaining, but sluggish loading instances times will sometimes affect your placement in google and could damage your quality score if ads and marketing with Adwords. Anyway I am adding this RSS to my e-mail and could look out for much more of your respective intriguing content. Ensure that you update this again very soon..
madhu
December 16, 2011
DBMS

what is the type of an image in database?
anu
December 21, 2011
fsd

need 2 improve
mulugeta
December 21, 2011
Data base

I have no word to express your uploaded handout so that be continue to upload news things and modified thanks a lot Your sensory D/r Mulugeta Assefa Bye bye
Frankie
March 6, 2013
nkoNdHjKhItWqGVeA

Too many compliments too little space, tkahns!
Janine
March 6, 2013
EEhqnpjAtrgrDKOXN

Wow! Great to find a post with such a clear mssegae!
Precious
March 6, 2013
UJukhlTzsYdWfDoRA

Your awnser was just what I needed. It's made my day!
Philip
March 6, 2013
aACrYKBdtEIpQS

I would have thought that if a given optuut gap can tolerate a budget deficit of say 10% without making inflation accelerate, its better for this 10% deficit to be split 9% on targeted spending (with a proven multiplier effect) and only 1% on bond interest (which goes to capital owners and so has a low multiplier), instead of 7% vs 3%. In other words, if a govt pays out a lower amount of sovereign interest, it has more room to pay for more useful things.
Goldy Rawat
December 26, 2011
regarding RDBMS

I like this website. its very helpful for us... Thankx
smitha
January 14, 2013
storing and retrieving the data

when we do a project we create html pages such as registration forms etc,but my question is where do we store this data and how do we invoke this data(retrieve). when is xml used and when is jdbc connection used?
ujwala
January 13, 2012
dbms

wants more advance knowledge in dbase
Mosnat Ahmed Nayeem
January 12, 2013
everything about DBMS

I like it
kuldeep
January 18, 2013
i am looking for database course

hello
MD.ASIF ANSARI
January 26, 2012
To know about the java

I want to connection with java and updating,deleting,viewing and many more.
valarmathi
February 2, 2012
project

i will do my project in database.please help
md saifee
February 3, 2012
D B M S inqury

D B M S me mai kiya use kar sakta hun .hai kiya
yogesh ukale
January 10, 2013
Database connectivity in c language

How to create database connectivity in language? Please, send me Answare....
Hernan
January 19, 2013
tLuKgsedaM

Just want to say your article is as aosnutding. The clearness in your post is simply nice and i could assume you are an expert on this subject. Fine with your permission allow me to grab your feed to keep up to date with forthcoming post. Thanks a million and please continue the gratifying work.
Amira
January 19, 2013
gTYlLFvtMdNkGb

Very nice post. I just stumbled upon your webolg and wished to say that I've truly enjoyed surfing around your blog posts. In any case Iâ??ll be subscribing to your feed and I hope you write again very soon!
kish
February 17, 2012
kique

DECLARE QUERY VARCHAR2(32767); FIN_QUERY VARCHAR2(32767); CURSOR C IS (select distinct PORTFOLIO from MPE_TEST1); CURSOR C2 IS SELECT DISTINCT PORTFOLIO_LEVEL, PORTFOLIO FROM MPE_TEST1 ORDER BY PORTFOLIO_LEVEL; TYPE ARRAY IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER; PORTFOLIO_LEVEL ARRAY; IDX NUMBER :=1; BEGIN QUERY := 'SELECT '; for R IN C LOOP IDX := 1; FOR R2 IN C2 LOOP IF(R2.PORTFOLIO = R.PORTFOLIO) THEN PORTFOLIO_LEVEL(IDX) := R2.PORTFOLIO_LEVEL; IDX := IDX + 1; END IF; END LOOP; QUERY := QUERY || 'CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(1) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_SALE_ASS_C, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(1) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_SALES_ASS_EXP_DT, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(2) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_SALE_MST_C, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(2) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_SALE_MST_EXP_DT, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(3) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_SALE_PROF_C, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(3) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_SALE_PROF_EXP_DT, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(4) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_TECH_ASS_C, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(4) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_TECH_ASS_EXP_DT, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(5) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_TECH_MST_C, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(5) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_TECH_MST_EXP_DT, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(6) ||''' THEN COUNT ELSE 0 END as '||R.PORTFOLIO||'_TECH_PROF_C, CASE WHEN f.PORTFOLIO_LEVEL ='''||PORTFOLIO_LEVEL(6) ||''' THEN END_DATE END as '||R.PORTFOLIO||'_TECH_PROF_EXP_DT,'; END LOOP; QUERY := SUBSTRING(QUERY,0,LENGTH(QUERY)-1); QUERY := QUERY || ' FROM MPE_TEST1 F '; --DBMS_OUTPUT.PUT_LINE('QUERY--'||QUERY); FIN_QUERY := 'select '; FOR R IN C LOOP FIN_QUERY := FIN_QUERY || '(case when '||R.PORTFOLIO||'_TECH_ASS_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL ASSOCIATE'') then ''Elite Specialist, Specialist, Authorized'' when '||R.PORTFOLIO||'_TECH_ASS_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL ASSOCIATE'') then ''Specialist, Authorized'' when '||R.PORTFOLIO||'_TECH_ASS_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL ASSOCIATE'') then ''Authorized'' else ''Authorized'' end) '||R.PORTFOLIO||'_TA_LEVEL, (case when '||R.PORTFOLIO||'_SALE_ASS_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES ASSOCIATE'') then ''Elite Specialist, Specialist, Authorized'' when '||R.PORTFOLIO||'_SALE_ASS_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES ASSOCIATE'') then ''Specialist, Authorized'' when '||R.PORTFOLIO||'_SALE_ASS_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES ASSOCIATE'') then ''Authorized'' else ''Authorized'' end) '||R.PORTFOLIO||'_SA_LEVEL, (case when '||R.PORTFOLIO||'_TECH_MST_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL MASTER'') then ''Elite Specialist, Specialist, Authorized'' when '||R.PORTFOLIO||'_TECH_MST_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL MASTER'') then ''Specialist, Authorized'' when '||R.PORTFOLIO||'_TECH_MST_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL MASTER'') then ''Authorized'' else ''Authorized'' end) '||R.PORTFOLIO||'_TM_LEVEL, (case when '||R.PORTFOLIO||'_SALE_MST_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES MASTER'') then ''Elite Specialist, Specialist, Authorized'' when '||R.PORTFOLIO||'_SALE_MST_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES MASTER'') then ''Specialist, Authorized'' when '||R.PORTFOLIO||'_SALE_MST_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES MASTER'') then ''Authorized'' else ''Authorized'' end) '||R.PORTFOLIO||'_SM_LEVEL, (case when '||R.PORTFOLIO||'_TECH_PROF_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL P'') then ''Elite Specialist, Specialist, Authorized'' when '||R.PORTFOLIO||'_TECH_PROF_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL P'') then ''Specialist, Authorized'' when '||R.PORTFOLIO||'_TECH_PROF_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''TECHNICAL P'') then ''Authorized'' else ''Authorized'' end) '||R.PORTFOLIO||'_TP_LEVEL, (case when '||R.PORTFOLIO||'_SALE_PROF_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''ELITE SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES P'') then ''Elite Specialist, Specialist, Authorized'' when '||R.PORTFOLIO||'_SALE_PROF_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''SPECIALIST'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES P'') then ''Specialist, Authorized'' when '||R.PORTFOLIO||'_SALE_PROF_C >= (select PGM_RQMT_DET_TARGET from DIM_MPE_SF_PGM_RQMT_DET where PGM_LVL_RQMT_SPEC_LEVEL =''AUTHORIZED'' and PGM_LVL_RQMT_TECH='''||R.PORTFOLIO||''' and PGM_RQMT_DET_CRITERIA=''SALES P'') then ''Authorized'' else ''Authorized'' end) '||R.PORTFOLIO||'_SP_LEVEL, '; END LOOP; FIN_QUERY := FIN_QUERY || ' i.* from (' || QUERY; FIN_QUERY := FIN_QUERY || ') I '; DBMS_OUTPUT.PUT_LINE(FIN_QUERY); EXECUTE IMMEDIATE FIN_QUERY; END;
gopal
February 19, 2012
oracle project

i want to do project wth oracle having DB2 frontend. can somebody help me or suggest me something
sumit agarwal
February 23, 2012
simple question

sir/madam please send some dbms mcq question. (sumit agarwal)
zag
February 27, 2012
aprication

Interseting tut
malini
March 3, 2012
need answer

i want coding for online voting system ...i want to finish my project within a week
sumera zulfiqar
March 16, 2012
database

plz provide me a project on bank management system
shruti
March 18, 2012
related to database

How to inser pdfs into database?
saeed
March 22, 2012
sql

Can i help me about diffrences of kinds of Sql?
rasha
April 3, 2012
project

write code i have five tables i want to build them html form and link between them database and php then make query between them ,,,,,,,,,, Table of suppliers Source no, resource name, Address mobile ,Tel , e-mail ,,,,,,,,,,,, Customers table Customer no , Customer name , Address ,mobile, Tel , e-mail ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Sales table Sales invoice no , History , Statement, Item Goods number ,number price ,color ,payment, Delivery date , notes ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Table purchases Purchase invoice ,number, Date , Number of purchase number, statement, item ,Price , color, payment Delivery date, notes ,,,,,,,,,,,,,,,,,,,,,,,, Bucket table Goods number ,Payment invoice, number, Purchases Invoice number, statement, item ,number, Cost price ,Selling price , color Date of entry of the goods ,status ,,,,,,,,,,,,,,,,,,,
manoj singh
April 3, 2012
JTable Connectivity with MSAccess

I want to access Table contents in JTable in java swing.. plz help me and provide source code for that
adava
April 23, 2012
computer science

I am an fresh men in IT area . need someone give me some help. Thanks
ravi
April 10, 2012
JDBC MSACCESS

How to insert dynamically values into a table using JDBC MSACCESS This COde is not working for me COuld you please tell me the error in this code import java.sql.*; import java.util.*; public class DBDemo3 // DBDemoInsert { public static void main(String[ ] args) throws Exception { String url = "jdbc:odbc:mydsn"; Properties p = new Properties(); p.put("user", "sa"); p.put("password","dss"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection( url, p ); String insertCommand = "INSERT INTO employee VALUES(" + args[0] + ",'" + args[1] + "'," + args[2] + ")"; Statement stmt = con.createStatement(); int count = stmt.executeUpdate(insertCommand); System.out.println(count + " row(s) inserted"); con.close(); } }
sugamber
April 17, 2012
jdbc

import java.io.*; import java.sql.*; import java.util.*; class database { public static void main(String...a)throws IOException { try{ Class.forName("com.mysql.jdbc.Driver"); Connection conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/ashish","root","sugamber"); Statement st=conn.createStatement(); Scanner sc=new Scanner(System.in); String user_name=sc.next(); String password=sc.next(); ResultSet rs=st.executeQuery("SELECT * from user_master where login_name='"+user_name+"', password='"+password+"' "); if(rs.next()) { if(rs.getString("user_type").equals("admin")) { System.out.println("Welcome Admin"); } else { System.out.println("Sorry u r not admin"); } } else { System.out.println("Invalid User"); } } catch(Exception e) { System.out.println(e); } }} this is the code and i want connect with MYSQL database than i found java.lang.classnoyfoundexception <com.mysql.jdbc.driver> how to solve this problem? plz help me
rajesh
April 28, 2012
SQL

In OODBMS can sql implemented, is it possible?
shovon
May 5, 2012
CSE

no comment
Anarkali
May 27, 2012
Lollll

Thanks
tanya
May 28, 2012
DB2

I want the full explainatory tutorials of DB2.
shobhakant
June 8, 2012
dbms

i think better.
rachita
June 9, 2012
dbms & rdms

difrance between Dbms & Rdms
Venkatesh
June 11, 2012
Sir,

It's very good to open one site for us to learn
manelyn
June 19, 2012
database management system

collection of related records
bharath
June 21, 2012
DBMS

how can we use this dbms software in IT industries?
switchcon
July 3, 2012
registered

i want to post
Satyanarayana Goud
July 7, 2012
About DBMS

VERY IMPRESSIVE WAY OF EXPLANATION,IF DIAGRAMATIC REPRESENTATION IS THERE IT WILL BE MORE INFORMATIVE TO REMEMBER
rahul singh
July 11, 2012
how insert the value in the data in data base

iwants to answer in detail 1
sandip
July 17, 2012
pl sql pdf book

nice
abhishek gaur
July 26, 2012
SQLITE query formation

create table DATA (IMAGE_ID ,IMAGETimestamp, IMAGEFilePath ); create table FRAME(FrameID,VideoStartTime, VideoEndTime,VideoFile path); here the Image id is primary key and frame ID is foreign key i want to join the tables in such a way that FrameID did not come in the joined table as the entries of the Imageid and frame id are same i applied the query by left outer join but it is huge can someone help to reduce the size... select DATA.Img_ID,DATA.Img_Type,DATA.Img_FilePath,DATA.Img_TimeStamp,DATA.Img_Lat,DATA.Img_long,DATA.Img_Country,DATA.Img_City,DATA.Img_Landmark, DATA.MPEG7FILEPATH,DATA.Img_Title,DATA.Img_Creator,DATA.Img_Description,DATA.Img_Keyword,DATA.Img_Genre,DATA.Img_Rate,DATA.Img_Copyright, FRAME.VIDEOSTARTTIME,FRAME.VIDEOENDTIME,FRAME.VIDEOFILEPATH from DATA left join FRAME on DATA.Img_ID=FRAME.FRAMEID;
Jane
July 27, 2012
mysql code to do this.

Can you please give a way forward to accomplish this: You are provided with a database backup to aid you in performing a data import for a hospital. The backup contains a single table that will act as your extract/source data. Required: Create a normalized database that will capture the details for the patients and NOKs(next of kins). N.B. Only one address and telephone table respectively should cater for both NOK and Patient addresses and phone records respectively. All fields must be mapped into the database structure you i create. The following fields are lookup fields and so should be thus implemented; sex,title,maritalstatus,religion,ethnicity,noktitle,nokrelationship Visibility of system status should be implemented and the messages should not be verbose (make them brief and to the point)
GOODLUCK YOBANA
August 14, 2012
Database Corruption

What could be done when the database is corrupt?
balwinder kaur
August 15, 2012
database

how to perform normalization
arunkumar
August 15, 2012
sql/plsql

depth of sql/plsql
gaurav sharma
August 25, 2012
dbms

what is the mdi form
Ravisankar
December 27, 2012
DB design for Fkrepresent multiple tables

Customer ,sites,books and authors each is individual entity but every entity has the notes entity is one many relation ship so how i need to design the table at database side.
kesego lesaso
September 3, 2012
database

examples of database
Subha prasana jena
September 4, 2012
history of bioinformatics

i am the student of North orisa univesity in bioinformatics. s
vicks
September 10, 2012
about talent

u r very talented
Ashir
September 14, 2012
differences between DBMS and SQL

pls sent me the answer in my email pls
sajid uddin
December 13, 2012
SQL

hey, I want the PLSQL tutorial covering all the concepts.. with appropiate examples.
Manish Dixit
September 20, 2012
Best Databse with Java on Windows & plateform.

Sir, I have to work on many projects at the same time and each have some database. I even now could not found a very much suitable database with all appropriate drivers that can be used with java development and can be deployed also onto the client side. There are many types of problems I face, sometimes Database server could not start, somewhere required drivers cound not be found, some other time null values could not be inserted into a connected database table. In short I am very much exhusted when I am working on different project at the same time. I think You are getting my point and thankfull very much to You if you can provide a guidance and suggest the best compatible database with java on every windows OS. Yours, Manish Dixit
Divya Dhage
September 21, 2012
insertion..!

What is DataBase insertion..?
george fernandas
September 30, 2012
jsp

how to write a jsp program for student registration form and retrieve the value from the database
george fernandas
September 30, 2012
jsp

how to write jsp program to create student information in randomly.using random button
Rajendra singh
October 3, 2012
dbms

any ask qution
SURESH
October 4, 2012
DATA BASE EMPLOYMENT

IT VERY FOR THIS FEILDS
chandra shekhar parmar
October 13, 2012
java with dbms

sir, i have a problem in jsp i want to write a code in jsp and the code of submit form(submit button) and code of insert data i want to write in same page but my program is not working.... why this is happing???
rijwan
October 15, 2012
c

nice
Twesh srivastava
October 26, 2012
DBMS

u give us a huge knowldge but its need some clarifies ofr every topic so if u do that we will helpful... thanku..
Bagna
October 26, 2012
meWJTVyzKlKMNNoWC

On added point to mention here is that with Access teabls you can store up to 255 fields not that I would recommend this as it can affect performance. The file size can grow to 2GB should you need the space.With MS Access queries, the capacity of the number of fields is the same but they can be combined from up to 32 teabls with 16 joins a heavy duty query!
Lingani Petros
October 26, 2012
database management

i need steeps on desining database and exrcises on and its terminology, guide on how to make quiery,form and reports.
Lingani Petros
October 26, 2012
database management

i need steps on desining database and guide on making quiery,form and reports
naqib wazir
November 11, 2012
database

u have explained the term dbms very well
kush kumar
May 8, 2013
explain database

for examnple class.forName DriverManager.getConnection con.createStatement(); st.executeUpdate com.mysql.jdbc.Driver Connection con; PreparedStatement ps; Result set please explain this ... please send my email or give me url .. thanks...
prudhvi
May 9, 2013
objective c

its nice to follow
Mimosa
June 15, 2013
RXMBMCYxuirdk

You got to push it-this esesntail info that is!
Karess
June 15, 2013
hgWZWaXEAo

Me dull. You smart. That's just what I nedeed.
irfan khan
June 16, 2013
data base management system

this is my favourite subject
Sony Appi
July 29, 2013
DBMS

It is my favorite subject in computer course... I want some more information about SQL and database management... Thanking you....
atul rajput
September 26, 2013
to know about programs

i want to know all details of programs by step by step solving method
akila
October 1, 2013
datastructures

i want source code for hill climbing algorithm using java using steepest ascent method and primary dual method
Emil
October 8, 2013
copro1

i want to know more about java programming!
lara mae pabilane
October 13, 2013
how to connect java to a database using netbeans

how??
k.thilagavathi
December 11, 2013
about database

how to insert the value using database connection with jsp bean class
parthi
October 24, 2013
bsc computer science DBMS Book

bsc computer science DBMS Book
DMCA.com