System and method for loading commercial web sites

Abstract

A system and method in a network computer environment for loading data into a database using a browser are provided. One or more raw informational items are obtained from a data source. The raw informational items are temporarily stored and parsed. Informational items are written into a production data store which is accessible to end users of a network. The information in the production data store subsequently is validated against the raw informational items for accuracy and completeness.

Having thus described the invention, what is claimed is:  
     
         1 . A method in a network computing environment for loading data into a database using a browser, the method comprising: 
 obtaining one or more raw informational items from a data source;    creating a derived version of said raw informational items;    writing said derived version into a production data store; and    validating said derived version against said raw informational items.    
     
     
         2 . The method as recited in  claim 1 , wherein said creation of derived version includes temporarily storing and parsing said raw informational items.  
     
     
         3 . The method as recited in  claim 2 , wherein said raw informational items are temporarily stored in a first table prior to being parsed, and wherein said derived version of said raw informational items is temporarily stored in a second table.  
     
     
         4 . The method as recited in  claim 3 , wherein said validation includes comparing said first temporary storage table with said second temporary storage table.  
     
     
         5 . The method as recited in  claim 1 , wherein said production data store is one that is accessible to end users of the network.  
     
     
         6 . The method as recited in  claim 1 , wherein said data source exists at a vendor's location.  
     
     
         7 . The method as recited in  claim 1 , wherein said production data store includes at least one of a product table, a category table, a content table, a style table, a discount table, and a pricing table.  
     
     
         8 . A computer readable medium having computer executable instructions for performing the steps recited in  claim 1 .  
     
     
         9 . A computer system having a processor, a memory and an operating environment, the computer system operable to perform the steps recited in  claim 1 .  
     
     
         10 . A network computing environment for loading data into a database using a browser, the computing environment comprising: 
 a transferring component which transfers one or more raw informational items from a vendor's data source to an e-Store location;    a deriving component for creating a derived version of said one or more informational items; and    a validation component for validating said derived version against said raw informational items.    
     
     
         11 . The computing environment as recited in  claim 10 , further comprising a parsing component for parsing said one or more informational items into a plurality of data storage tables representing attributes of said one or more informational items.  
     
     
         12 . The computing environment as recited in  claim 11 , wherein said storage tables comprise at least one of a production table, a category table, a content table, a style table, a discount table and a pricing table.  
     
     
         13 . A method in a network computing environment for loading raw vendor data to an e-Store location, the method comprising: 
 transferring the vendor data from a vendor's location to an e-Store location;    storing said data in a temporary storage table;    creating a derived version of said raw vendor data;    loading said derived version into one or more operational data tables of the e-Store location; and    validating the data loaded into said operational database tables against said data stored in said temporary storage table.    
     
     
         14 . The method as recited in  claim 13 , further comprising parsing said data prior to creating said derived version.  
     
     
         15 . The method as recited in  claim 13 , wherein said temporary storage table is in a de-normalized table.  
     
     
         16 . The method as recited in  claim 15 , further comprising: 
 extracting data from said operational database tables to create a second de-normalized validation table; and    comparing said first de-normalized table with said second de-normalized table.    
     
     
         17 . The method as recited in  claim 13 , wherein said operational database tables includes at least one of a product table, a category table, a content table, a style table, a discount table, and a pricing table.  
     
     
         18 . A computer readable medium having computer executable instructions for performing the steps recited in  claim 17 .  
     
     
         19 . A computer system having a processor, a memory and an operating environment, the computer system operable to perform the steps recited in  claim 17 .  
     
     
         20 . A computer readable medium including a data structure for validating vendor data which has been loaded into an e-Store operational database, wherein the data structure comprises: 
 a first temporary storage table for storing vendor data that has been transferred from a vendor location;    one or more operational database tables for storing vendor information that has been parsed from said first temporary storage table; and    a second temporary storage table including vendor data extracted from said one or more operational database tables, wherein said second temporary storage table is adapted to be compared to said first temporary storage table.    
     
     
         21 . The computer readable medium as recited in  claim 20 , wherein said operational database tables include at least one of a product table, a category table, a content table, a style table, a discount table, and a pricing table.