Distributed database management systems
Download
1 / 35

Distributed Database Management Systems - PowerPoint PPT Presentation


  • 82 Views
  • Uploaded on

Distributed Database Management Systems. Lecture 24. Distributed Database Management Systems. Virtual University of Pakistan. Fragmentation. We know there are different types, we start with the simplest one and that is the PHF

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Distributed Database Management Systems ' - zachery-holden


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Distributed database management systems1

Distributed Database Management Systems

Virtual University of Pakistan






  • As before we register our servers and now at our Enterprise Manager we can see two instances of SS

  • At each of the three sites we define one database named BANK and also one relation, normal base table, however, for the fragmentations to be disjoint (a correctness requirement) we place a check on each table at three sites, how….





  • QTA is C50001 to C99999 functioning of the system, we apply a check on the tables

  • So we apply the check on both tables/fragments accordingly, although they can be applied while creating the table, we can also apply them later, like




Example data in pesh
Example Data in PESH populated, start running applications on them, and data enters the table, and the checks ensure the entry of proper data in each table. Now, the tables are being populated


Example Data at QTA populated, start running applications on them, and data enters the table, and the checks ensure the entry of proper data in each table. Now, the tables are being populated


  • Next thing is to create a global view for the global access/queries, for this we have to link the servers with each other, this is required

  • You have already registered both the servers, now to link them

  • You can link them using Enterprise Manager or alternatively through SQL, we do here using SQL


  • Connect Pesh using Query Analyzer access/queries, for this we have to link the servers with each other, this is required

  • Then execute the stored procedure sp_addlinkedserver

  • The syntax is


  • sp_addlinkedserver access/queries, for this we have to link the servers with each other, this is required

    @server = ‘QTA',

    @srvproduct = '',

    @provider = 'sqloledb', @datasrc = ‘mysystem\QTA‘

  • You will get two messages, if successful, like ‘1 row added’ and ‘1 row added’




  • Create view custG as access/queries, for this we have to link the servers with each other, this is required

    select * from custPesh

    Union All

    select * from QTA.bank.dbo.custQTA

  • Likewise, we have to apply same command at QTA

  • Create view custG as

    select * from custQta

    Union All

    select * from PESH.bank.dbo.custPesh






  • All this is transparent from the user, that is, the distribution of data

  • Global user gets the feeling, as if all the users’ data is placed on a single place

  • For the administrative purposes they can perform analytical types of queries on this global view, like


Thanks
Thanks distribution of data


ad