Write a program to implement inverted file shown slider, PL-SQL Programming

Write a program to implement the inverted file shown in the slides (Simple Index file, LabelID file and Data file).  Use the Avail_List to point at the deleted Label IDs so that their spaces can be re-used for new records.  Insert the example data in the slides in the three files (see below).

Data file: 

Simple Index: 

LabelID file: 

Then, show the content of the files and the Avail_List after each of the operation:Add a new data record with a new composer name "Xxxx"and new label ID "XXX12345".Add a new data record with a new composer name "Bbbbb"and new label ID "BBB12345".Delete data record with key "DG139201".Delete data record with key "COL31809"Add a new data record with a new composer name "Hhhhh"and new label ID "HHH12345".

Draw a B-tree and show its content after every operation.  The nodes in the B-tree can store maximum of 4 keys and minimum 2 keys.  
Insert: A,G,F,B,K,D,H,M,Insert: J,Delete: A, D,Insert: E,S,I,R,X,Delete: M,Insert: A,C,D, Delete: S,Insert: L,N,T,U,Delete: R 

Posted Date: 3/22/2013 6:30:15 AM | Location : United States







Related Discussions:- Write a program to implement inverted file shown slider, Assignment Help, Ask Question on Write a program to implement inverted file shown slider, Get Answer, Expert's Help, Write a program to implement inverted file shown slider Discussions

Write discussion on Write a program to implement inverted file shown slider
Your posts are moderated
Related Questions
SQL Cursor   The Oracle implicitly opens a cursor to process each SQL statement not related with an explicit cursor. The PL/SQL refers to the most current implicit cursor as t

Example of DELETE - SQL As with UPDATE, a FOR PORTION OF clause can be specified if the target table has a defined period name, as illustrated in Example. Example: Deleting

Keyword and Parameter Description: label_name: This is an undeclared identifier which labels an executable statement or the PL/SQL block. You can use a GOTO statement to

Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

Logical Operators The logical operators AND, NOT, and OR follow the tri-state logic shown in table below. The AND and OR are binary operators; NOT is a unary operator.

Use the RETURNING Clause Frequently, the application requires information about the row affected by a SQL operation, for illustration, to produce a report or take a subsequent

Joining in SQL Joining IS_CALLED and IS_ENROLLED_ON in SQL SELECT * FROM IS_CALLED NATURAL JOIN IS_ENROLLED_ON This is an example of an SQL table expression. I have been

Identifiers You use identifiers to name the PL/SQL program items and units that include constants, variables, cursors, exceptions, cursor variables, subprograms, and packages.

Project Description: I am looking to change FullCalendar to add/delete sql server data when events are removed or dropped from Calendar. Events should only be included by dra

SQL outer join SELECT * FROM IS_CALLED NATURAL LEFT JOIN IS_ENROLLED_ON Note that adding LEFT to an invocation of CROSS JOIN has no effect unless the right-hand operand