Method, system and apparatus for creating and accessing a hierarchical database in a format optimally suited to real estate listings
First Claim
1. A computer-implemented method of managing listing information, relating to at least one property, for a real estate database, the method comprising:
- at said property, entering property specific information into a portable computing device;
communicating said the property specific information from said portable computing device to a server computer system; and
adding, on said computer system, said property specific information as new records in a table having a plurality of records, each of said plurality of records including an address field and a descriptor; and
controlling the entry of said new records in said table so that said address fields for all of said plurality of records define a semantic hierarchy among said plurality of records in said table;
wherein;
said address field comprises a hierarchically ordered set of identifiers;
said controlling of said entry of said new records includes, for each said property;
providing a highest level record in said table, providing a plurality of records in said table semantically below said highest level record, each having said address field and said descriptor;
for each given record of said plurality of records other than ones having said highest level, the semantic meaning of said descriptor is based on a set of records in said table semantically above said given record; and
a particular record is a member of said set of records semantically above said given record when all of said identifiers of said particular record appear identically in the same positions in said address field of said given record but said given record has at least one identifier not appearing identically in the same position in said address field of said particular record.
4 Assignments
0 Petitions
Accused Products
Abstract
A computer-implemented data management method, encryption system and interactive computer program for managing real estate information in a hierarchical database are disclosed. Also, a method, system and program for cross referencing a hierarchical database with a relational database are disclosed. A computer program accesses an XML definitional document on a handheld computer for inputting data related to real estate listings in a hierarchically controlled format for a database. Real estate agents provide input of data to the database using the handheld, portable computer. A menu or picklist driven display provides logical selection of data input and address fields, and a validation step for checking errors or omissions in the data entry procedure for a given record. A single, central database table is managed for input and distribution of real estate listing information to subscribers to the database management system.
-
Citations
53 Claims
-
1. A computer-implemented method of managing listing information, relating to at least one property, for a real estate database, the method comprising:
-
at said property, entering property specific information into a portable computing device;
communicating said the property specific information from said portable computing device to a server computer system; and
adding, on said computer system, said property specific information as new records in a table having a plurality of records, each of said plurality of records including an address field and a descriptor; and
controlling the entry of said new records in said table so that said address fields for all of said plurality of records define a semantic hierarchy among said plurality of records in said table;
wherein;
said address field comprises a hierarchically ordered set of identifiers;
said controlling of said entry of said new records includes, for each said property;
providing a highest level record in said table, providing a plurality of records in said table semantically below said highest level record, each having said address field and said descriptor;
for each given record of said plurality of records other than ones having said highest level, the semantic meaning of said descriptor is based on a set of records in said table semantically above said given record; and
a particular record is a member of said set of records semantically above said given record when all of said identifiers of said particular record appear identically in the same positions in said address field of said given record but said given record has at least one identifier not appearing identically in the same position in said address field of said particular record. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16)
-
-
17. A computer-implemented method of cross referencing a relational database with a hierarchical database comprising the steps of:
-
creating a definitional document, said document containing a data dictionary assigning numeric address information consistent with the subject matter of the database;
loading a definitional document into a standard database format;
accessing data from the definitional document for a programming language; and
writing said data to a database table consistent with the definitions set forth in said definitional document. - View Dependent Claims (18, 19, 20, 21, 22)
-
-
23. A database management system characterized in that the entire database is in one table, and the table has sets of records relating to each entity, and the records have an address field made up of a hierarchically ordered set of identifiers.
-
24. A computer implemented method for creating, storing and managing real estate listing data records in a hierarchical database comprising the steps of:
-
providing at least one portable handheld computer device having a computer-readable interactive program installed thereon and executable by an operating system associated with said handheld computer device;
operating by at least one user said interactive program to create at least one record associated with one or more properties, said at least one record including a hierarchically arranged plurality of descriptors for describing one or more real estate entities;
providing a communications link between said handheld computer device and an intermediate computer storage device for downloading the records for storage on the intermediate computer storage device;
providing a computer network connecting said intermediate computer storage device to at least one central file server;
transferring said downloaded records from said intermediate computer storage device to said at least one central file server;
incorporating a plurality of said records into a cumulative, hierarchically organized file system; and
accessing said file system via said computer network according to a predefined set of user security codes for retrieval of at least a portion of said listing data sets for use in compiling and disseminating said listing data records in a plurality of formats adapted for marketing real estate entities.
-
-
25. A computer-implemented method for creating, storing and managing real estate listing data in a hierarchical database comprising the steps of:
-
providing at least one portable handheld computer device having a computer-readable interactive program installed thereon and executable with an operating system associated with said handheld computer device, said interactive program having a menu-driven format, with a plurality of main menu selections displayed, and a first said menu selection being to enter a new listing, a second said menu selection being to open an existing listing, and a third said menu selection being to delete a listing;
displaying a prompt to identify a new listing responsive to user'"'"'s selection to enter a new listing and, displaying a plurality of first level categories from which the user may select for entering into a listing data set;
displaying a plurality of second level categories if one of said first level categories is selected, and if an item is selected from second level categories, displaying at least one of third level categories to associate with the second level category;
displaying at least one subcategory to associate with the each preceding level category up to a fifth level category;
optionally repeating the selection steps as desired to collect a set of selections that comprise a substantially complete set of descriptors of an associated property listing; and
if the user selects open listing, the first level categories are displayed again, such that data associated with the listing already in the database can be supplemented or modified as the steps of a new listing are repeated;
if the user selects delete listing, displaying a complete picklist of listing records all the first level categories are displayed again, such that records may be selected for deletion;
at least one user operating said interactive program to create at least one set of said listing data associated with one or more properties, said at least one set of listing data including a hierarchically arranged plurality of descriptors for describing one or more real estate entities;
providing a communications link between said handheld computer device and an intermediate computer storage device for downloading the sets of data for storage on the intermediate computer storage device;
providing a computer network connecting said intermediate computer storage device to at least one central file server;
transferring said downloaded sets of listing data from said intermediate computer storage device to said at least one central file server;
incorporating a plurality of said sets of listing data into a cumulative, hierarchically organized file system; and
accessing said file system via said computer network according to a predefined set of user security codes for retrieval of at least a portion of said listing data sets for use in compiling and disseminating listing data records in a plurality of formats adapted for marketing real estate entities. - View Dependent Claims (26, 27)
-
-
28. A computer software application for creating data records associated with one or more real estate listings comprising:
-
an interactive program having a menu-driven format, with a plurality of main menu selections displayed, a first said menu selection being to enter a new listing, a second said menu selection being to open an existing listing, and a third said menu selection being to delete a listing;
displaying a prompt to identify a new listing responsive to user'"'"'s selection to enter a new listing and, displaying a plurality of first level categories from which the user may select for entering into a record;
a plurality of second level categories if one of said first level categories is selected, and if an item is selected from second level categories, at least one third level category to associate with one of the second level categories;
at least one subcategory to associate with the each higher level category up to a fifth level category;
each of said categories at every level being semantically associated with the next higher level;
means for repeating the selection steps as desired to collect a set of selections that comprise a substantially complete set of descriptors of an associated property listing;
means for storing said one or more records locally;
means to edit any of said stored records;
means to delete one or more of said stored records;
said at least one record including a hierarchically arranged plurality of descriptors for describing one or more real estate entities; and
a communications link for transmitting the records for storage in a central database. - View Dependent Claims (29, 30, 31)
-
-
32. A computer-implemented data management method for managing information relating to entities, comprising, providing on a computer system, at least one table for a plurality of records, each of said plurality of records having an address field and a descriptor;
- and controlling the entry of new records in said table so that said address fields for all of said plurality of records define a semantic hierarchy among said plurality of records in said table.
- View Dependent Claims (33, 34, 35, 36, 37, 38)
-
39. A computer system for implementing a data management method of managing information relating to entities, comprising:
-
a processor; and
a memory under control of said processor, with computer instructions for causing said processor to perform the steps of;
providing, on said computer system, at least one table for a plurality of records, each of said plurality of records having an address field and a descriptor; and
controlling the entry of new records in said table so that said address fields for all of said plurality of records define a semantic hierarchy among said plurality of records in said table. - View Dependent Claims (40, 41, 42, 43, 44, 45)
-
-
46. A computer program product for enabling a computer system to implement a data management method of managing information relating to entities, comprising:
-
a computer readable medium, and computer instructions, on said computer readable medium, adapted to cause a computer to perform the steps of;
providing, on said computer system, at least one table for a plurality of records, each of said plurality of records having an address field and a descriptor; and
controlling the entry of new records in said table so that said address fields for all of said plurality of records define a semantic hierarchy among said plurality of records in said table. - View Dependent Claims (47, 48, 49, 50, 51, 52)
-
-
53. A computer-implemented method of obtaining listing information, relating to at least one property, for a real-estate database, the method comprising:
-
at said property, entering property specific information into a portable computing device;
communicating said the property specific information from said portable computing device to a server computer system;
adding, on said computer system, said property specific information as new records in a table having a plurality of records, each of said plurality of records including an address field and a descriptor; and
controlling the entry of said new records in said table so that said address fields for all of said plurality of records define a semantic hierarchy among said plurality of records in said table;
wherein;
said address field comprises a hierarchically ordered set of identifiers;
said controlling of said entry of said new records includes, for each said property;
providing a highest level record in said table, and providing a plurality of records in aid table semantically below said highest level record, each having said address field and said descriptor;
for each given record other than ones of said plurality of records having said highest level, the semantic meaning of said descriptor is based on a set of records in said table semantically above said given record; and
a particular record is a member of said set of records semantically above said given record when all of said identifiers of said particular record appear identically in the same positions in said address field of said given record but said given record has at least one identifier not appearing identically in the same position in said address field of said particular record.
-
Specification