Model database in implementation level



During this time of rapid change and advancement, a new type of system appeared. Called client/server development because processing is split between client computers and a database server, this new breed of application was a radical change from mainframe-based application programming. Among the many advantages of this type of architecture are
  • Reduced maintenance costs
  • Reduced network load processing occurs on database server or client computer
  • Multiple operating systems that can inter operate as long as they share a common network protocol
  • Improved data integrity owing to centralized data location
Oracle Corporation released the first commercial RDBMS that used SQL. Although the original versions were developed for VAX/VMS systems, Oracle was one of the first vendors to release a DOS version of its RDBMS. (Oracle is now available on more than 70 platforms.) In the mid-1980s Sybase released its RDBMS, SQL Server. With client libraries for database access, support for stored procedures (discussed on Day 14, "Dynamic Uses of SQL"), and interchangeability with various networks, SQL Server became a successful product, particularly in client/server environments. One of the strongest points for both of these SQL Server powerful database systems is their scalability across platforms. C language code (combined with SQL) written for Oracle on a PC is virtually identical to its counterpart written for an Oracle database running on a VAX system.  SQL is the de facto standard language used to manipulate and retrieve data from these relational databases. SQL enables a programmer or database administrator to do the following:
  • Modify a database's structure
  • Change system security settings
  • Add user permissions on databases or tables
  • Query a database for information
  • Update the contents of a database
In putting into practice Client/Server figure, Bernard H. Boar classifies client/server computing as follows:
Client/server computing is a processing model in which a single application is partitioned between multiple processors (front-end and back-end) and the processors cooperate (transparent to the end user) to complete the processing as a single unified task. Implementing Client/Server Computing A client/server bond product ties the processors together to provide a single system image (illusion). Shareable resources are positioned as requestor clients that access authorized services. The architecture is endlessly recursive; in turn, servers can become clients and request services of other servers on the network, and so on and so on. This type of application development requires an entirely new set of programming skills. User interface programming is now written for graphical user interfaces, whether it be MS Windows, IBM OS/2, Apple Macintosh, or the UNIX X-Window system. Using SQL and a network connection, the application can interface to a database residing on a remote server. The increased power of personal computer hardware enables critical database information to be stored on a relatively inexpensive standalone server. In addition, this server can be replaced later with little or no change to the client applications.





Comments

Post a Comment

Popular posts from this blog

Irin, a mother of silent ocean

Image
A mother behind the deep sea and the ocean Walking past in the silent world of beauty and heaven,  She knows her work in motion and hurdles; Never hesitating through the rains and the clouds  In moving behind the shadow and perils of earth.  She remains happy by her unusual courage; To speak the truth in capsize haze and relies To switch the darkened cloud of the storm.  She walks past all along in the glowing streams  Underneath the big shades of the banyan tree As if the mother of all the child In the earth And the beams of light not under coercive strength. What she sees and explores in front of her  She is moving in her way to have bliss  Upon the supplication she always does.  She becomes remorse and dilapidated  when She hears the destitute of a motherless baby Her sorrows knows no bounds As if her heart always renders to restore the life of the child.  She is second to none to roll her tears  When sadness, pains and death stirs her.  L
Read more

Home, my sweet home

Home, My Sweet home There is no denying the fact that when our time comes to die, we should  not behave  like those whose hearts are filled with fear of death, so that when their time comes they weep and pray for a little more time to live their lives over again in a different way.  We should sing our death song, and die like a hero going home. The palpable image that comes to our cognizance when the expression ‘Home’ is perceived is of an edifice, chalet or a bed-sitter. A home cannot be just defined by a structure with a collection of rooms inside, for some it can also be their smartphones or even their refugee camp. According to Melody Bettie,” Gratitude unlocks the fullness of life. It turns what we have into enough, and more. It turns denial into acceptance, chaos to order, confusion to clarity. It can turn a meal into a feast, a house into a home, a stranger into a friend”.   A home is customarily distinct and comforting for any person but for realism of pedagogy, childr
Read more

Hooks Law and its application

Hooke's Law Hooke's Law states that, for certain elastic materials, force is proportional to extension, when a sample is stretched. This means that the extension of the sample increases linearly with the amount of force applied. Materials that obey Hooke's law are called Hookean Materials. Springs behave like Hookean Materials.Hooke's law can be written as  F = kx , where  F  is Force,  x  is extension, and k  is the Stiffness Constant of the sample. The stiffness constant describes the stiffness of a material, and is measured in Nm -1  (or Kgs -2 ). F = kx Hooke's law can be demonstrated with the use of Force-Extension graphs. However, no sample follows Hooke's law indefinitely, and there comes a point, called the Limit of Proportionality, where there is no longer a linear relationship between force and extension. After yet more force is applied, the Elastic Limit will be reached. This means that the sample will no longer return to its o
Read more