Showing posts with label Database Concept. Show all posts
Showing posts with label Database Concept. Show all posts

RDBMS (RATIONAL DATABASE SYSTEMS)

(RATIONAL DATABASE SYSTEMS)

Type the database used many in this time is type RDBMS ( Relational Database Management System).

Database with this type don't only solely function to saving data only, but take care of integrity of data.

Primary Key ( Unique Key)

In rational design database Primary Key is locking the proxy ( candidate key) to identified line (row) unique inlay tables

Foreign Key

In rational design database Foreign Key is locking reference from table which related.

Foreign key is field key owning the reference to primary key [at] other tables which related

Download PDF File

No comments:
Label:

Database Basic Concept

Database Basic Concept

A Database consist of some used tables to save a data,

For example: pregnant Database Shop some tables be like: master tables customer, tables of sale master, tables of goods master, sale detail tables, tables of receivable, etcetera.

Table

A tables is corps record and field.

  • Record is representation a intact data.

  • Field is the information in one record.

Front-End

Is a link [among/between] user with used database to data process to be kept. Data process work well from and to Database itself.

Front end can be created use some programming languages be like under this:

  • Visual Basic
  • Visual C++
  • Visual Foxpro
  • Java

Marginally front application end divided become 2 category, that is :

  1. Decision Support Front End Application which only presenting and print the taken away from information Database either through predefined or user defined query.
  2. Transaction Processing Front End Applications including ability to edit, to add, and vanish record from database. Application this type of differentiated to Traditional DBMS, non-traditional DBMS and client/server DBMS.

Back-End

Back-End are Database itself

Some DBMS to be made [by] a Backend is as follows:

  • Microsoft Access ( desktop database)
  • Microsoft SQL Server ( server database, that is the database support the mechanism client server)

Download PDF File

No comments:
Label:

Data Accessing Technology (ADO.NET)

Data Accessing Technology (ADO.NET)

ADO.NET ( ActiveX Data Object.NET)

Download PDF File

Component corps software the can be used by programmer for the data access of and data services.

Is part of Class library which is figured in with Microsoft.Net Framework

Commonly use to access and modify the on file data in Relational Database Systems, but can use also to access the non relational data source

Is evolution of technology ADO, but his change many and big, is so that considered to be by the new product.

Architecture ADO.NET consist of 2 punch line

  1. Data Provider

Provided access to data source be like : Ms. SQL SERVER or Oracle and OLEDB data provider

  1. Data Sets

Group of classes depict relational simple database in memory

Data Provider have a group of utility :

  • Connection : provide connection to communicate with the data source

  • Command : used to operate [at] data source be like reading, update, and deleting relational data

  • Parameter : formulate single parameter [at] Command. Example [of] : parameter [at] stored procedure

  • Data Adapter : Bridge for the delivery of data [among/between] data source and data object set

  • Data Reader : efficient [of] process of big result, one record in one time, provide record accessed in mode read-only, forward-only

Classes Data Set have the hierarchy :

  • Dataset : present Schema
    • DataTable
      • DataView
        • DataCoulomn : column information
        • DataRow : line information in tables
        • DataRowView : line information [at] DataView
      • DataRelation : relationship between tables
      • Constraint : formulate property Database

No comments:
Label:

Data Accessing Technology (ADO)

Data Accessing Technology (ADO)

ADO ( ActiveX Data Object)


ADO or ActiveX Data Object is accessing of the based on the technology ActiveX Data Object.

ADO is interface to OLEDB. ADO have most of all fitur owned by RDO. ADO add some future newly, be like: saving a recordset into a file, and object Recordset the self supporting ness, and others.

ADO consist of group top-level object :

  • Connection Object – connecting to database

  • Recordset Object – database corps record

  • Command Object – SQL command

  • Stream Object – Stream data of file text or page web

  • Error Object – Saving Error

  • Field Object – Database Field

  • Parameter Object – SQL PARAMETER

  • Property Object – Information [regarding/ hit] objects.

ADO component commonly use [at] high level language be like VBSCRIPT in environment ASP or Visual Basic

Delphi and C++ Builder besides product Microsoft also use ADO COMPONENT

No comments:
Label:

Data Accessing Technology (RDO)

Data Accessing Technology (RDO)

RDO ( Remote Data Object)

Download PDF File

RDO the name more familiar to DAAPI ( Data Access Application Programming Interface), woke up by the result development of merger DAO and ODBC API

Commonly use [at] Microsoft Visual Basic

Have the component :

  • Database Connection
  • Queries
  • Stored Procedures
  • Result Manipulation
  • Change Commits

Facilitate to make the application direct connection with ODBC without having to deal with ODBC API

No comments:
Label:

Data Accessing Technology (DAO)

Data Accessing Technology (DAO)

DAO ( Data Access Object)

Download PDF File

The interface commonly use to access the database [at] Microsoft Windows Systems

DAO recognized also with VT Objects made [at] November of 1992 with version of 3.5 able to access Jet engine and ODBC Data source including Ms. SQL SERVER and Enterprise DB Systems other

Design

DAO work by creating Object “ Workspace” where all database operations walk.

Workspace object reside in [at] session Database Engine larger ones object

There is 2 Type Database Engine [at] Microsoft :

  1. Jet propulsion DB ENGINE
  2. ODBC DIRECT DB ENGINE
No comments:
Label:

UNIVERSAL DATA ACCESS (OLEDB)

UNIVERSAL DATA ACCESS (OLEDB)

OLEDB (Object Linked and Embedded Database)

Download PDF File

OLEDB is Low Level Data Access Technology addressed to replace ODBC.

In OLEDB there are term OLEDB provider able to be compared to ODBC DRIVER [at] ODBC

OLEDB and ODBC is different technology in some cases is as follows:

  1. OLEDB is the technology base on COM.
  2. With OLEDB we can open connection to all Database, don't only limited to structured and ISAM database such as only can be done by ODBC, but OLEDB data access also able to on file in non structured database.

Download PDF File
No comments:
Label:

DSN (Data Source Name)

DSN

(Data Source Name)

Download PDF File


Connecting to Database use DSN to save used information to create connection to a[n database. In DSN on file [of] name ODBC driver to be used, name of computer taken as data center ( if we work with client server engine be like SQL server or Oracle), name or path from a database, timeout from connecting, and others

Through ODBC Driver Manager, we can create some types from DSN, that is:

  1. User DSN

DSN the on filename in system registry, and only can use by user in this time.

  1. System DSN

DSN kept in registry but DSN can use by all user.

  1. File DSN

DSN kept in file with file extension .dsn. file DSN can be copied easily to other computer. Therefore file DSN make the program installation phase become easier. The application we make have to know path from file DSN, therefore [at] program code, we have to provide path the intactness to file DSN., and we have to saving path the place for example in file INI.

Download PDF File

No comments:
Label:

UNIVERSAL DATA ACCESS (ODBC)

UNIVERSAL DATA ACCESS (ODBC)

ODBC

A open standard to connectivity between data bases machine.

This standard provide API able to be used to run and connecting an application with a data bases management system ( SMBD).

Designer ODBC make it with a purpose to [so that/ to be] ODBC free from usage of Programming Language selected, selected data bases management system, and selected operating system.

ODBC Component

  1. ODBC API : A group of function call, mistake codes and syntax SQL defining how do data in a DBMS accessed.
  2. Driver data bases ODBC : driver ( which in the form of dynamic link library) capable to process the function call ODBC to a DBMS.
  3. ODBC Driver Manager : ODBC Driver Manager : commissioned to load driver data bases ODBC required by application

Can be woke up to the specification of:

  1. “ Front-End” or “ client” desktop application, is also known as “ ODBC CLIENT”. This Application walking in computer user.
  2. ODBC DRIVER to “ Back-End” or “ Server” DBMS ( Database management Systems). Application DBMS this reside in [at] used computer to [be] depository [of] data to in accessing by some user

Application Server this [is] more ROBUST(faster, with central security and back up data) from [at] application client. ODBC DRIVER reside in [among/between] ODBC Client and DBMS.

Usage ODBC:

For usage ODBC required [by] 3 component :

  1. ODBC CLIENT : ODBC ENABLED front-end example [of] : Microsoft Access, Application which is woke up with Ms. Access, Application which is woke up with VB, Application which is woke up with C++ Win SDK+ODBC SDK, or the application woke up from vendor besides Microsoft.
  2. ODBC DRIVER : ODBC DRIVER to ODBC Server. The example : Ms. ODBC DRIVER pack, SQL Server ODBC, Informix ODBC, MySQL
  3. ODBC DBMS Server ( back-end) : DBMS server this can in accessing by ODBC Client with medium ODBC Driver

Example DBMS Server : SQL SERVER, Oracle, AS/400,Foxpro, Ms. Access, Mysql

No comments:
Label:
Subscribe to: Posts (Atom)