[go: up one dir, main page]

WO2009018644A1 - Optimisation, gestion et maintenance d'une base de données d'une communauté - Google Patents

Optimisation, gestion et maintenance d'une base de données d'une communauté Download PDF

Info

Publication number
WO2009018644A1
WO2009018644A1 PCT/CA2007/001362 CA2007001362W WO2009018644A1 WO 2009018644 A1 WO2009018644 A1 WO 2009018644A1 CA 2007001362 W CA2007001362 W CA 2007001362W WO 2009018644 A1 WO2009018644 A1 WO 2009018644A1
Authority
WO
WIPO (PCT)
Prior art keywords
data
source database
client
record
database
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Ceased
Application number
PCT/CA2007/001362
Other languages
English (en)
Inventor
Timothy A. Kennaley
Richard J. Mutton
Kevin P. Breese
John L. Dunn
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
BREKEN TECHNOLOGIES GROUP
Original Assignee
BREKEN TECHNOLOGIES GROUP
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by BREKEN TECHNOLOGIES GROUP filed Critical BREKEN TECHNOLOGIES GROUP
Priority to PCT/CA2007/001362 priority Critical patent/WO2009018644A1/fr
Publication of WO2009018644A1 publication Critical patent/WO2009018644A1/fr
Anticipated expiration legal-status Critical
Ceased legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00—Commerce
    • G06Q30/02—Marketing; Price estimation or determination; Fundraising
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/10—Office automation; Time management

Definitions

  • 1 he present invention relates to community directories and more particularly to community directories used by communities for development
  • a business directory database is one of the kev expectations of economic developers in a municipality or other communities It provides a vehicle by which individuals and businesses from anywhere can obtain useful and relevant information pertaining to businesses m a municipality and pertaining to the municipality itself In order for a municipality to progress and grow it is -very important to develop a sophisticated business directory database m order to promote regional development by attracting new businesses into the region and also to help promote and develop existing local businesses in the region so that local business prospers and remains in the region
  • Chamber of Commerce or Tourism Board Such information is typically the best economic and related demographic data relevant to a region, however, it is not complete and often does not have information that is useful and necessary for businesses wishing to move into a region, such as SIC codes, annual revenues, and so on Furthei. this data accumulation and management tends to be done by m-house staff or contracted to third parties to do community surveying and to develop a custom software solution to house this data Accordingly, this method of gathering and maintaining information is very expensive and most municipalities cannot afford to assemble and maintain a useful current business directory database, due to the amount of w ork and expense Indeed, many municipalities v irtually ignore the development of a business directory database since they cannot afford to develop and maintain a high quality current business directory database.
  • the present invention provides a computer implemented method of operating a municipal or community database
  • This embodiment provides a first source database having data fields, which contain data representative of a plurality of client records for a plurality of clients in a community
  • a second source database has data fields which contain data representative of a plurality of entity records for a plurality of entities in the community
  • At least some of the clients of the first source data base are common with corresponding entities in the second source database
  • Data is compared in a predetermined client record in the first source database with at least one of the entity records in the second source database to determine a correspondence there between
  • the present invention provides a computer implemented method of operating a community database said method comprising the steps of
  • An embodiment further comprises the step of collecting a client fee from one or more of the clients, wherein the client fee is graduated according to a level of service provided to the client
  • An embodiment further comprises the steps of prov iding a second interface for one or more users for performing one or more search engine functions in the client records receiv ing a search inquiry from at least one of the users, and presenting a listing of client records relev ant to the search inquiry
  • An embodiment further comprises the step of collecting a user fee from end users, wherein the user fee is graduated according to a level of service provided to the user
  • An embodiment fui ther comprises the step of ⁇ ro ⁇ idmg a date and or time stamp for each reconciled client record updating the date and or time stamp after an update to the client record and organizing the listing of records in an order according to a value for each date and 01 time stamp
  • An embodiment further comprises the steps of dispatching a plurality of surv ey messages to a corresponding plurality of clients prov iding in each survey message a plurality of answ er fields to receive data from the corresponding client receiving a reply survev, message from at least one of said corresponding clients and updating a corresponding client record according to data in one or more of the answer fields
  • An embodiment further comprises the steps of prov iding a portal for the community, and prov iding the first and/or second interfaces w ith a skin to correspond visually with the portal
  • An embodiment further comprises the step of prov iding each client record with a plurality of filter fields a first of the fields corresponding to a first group of users and a second of the field corresponding to a second group of users, and permitting access to a selected portion of the data in the client record by users according to the first and/or second filter values
  • An embodiment fuither comprises the step of dispatching an update message to one or more users the update message containing data representative oi a message that a client recoid has been updated, and or data representative of the updated client record
  • the method lurther comprises the steps of dispatching a query message to select a field value corresponding either to a field value in the client record or a corresponding field value in a corresponding entity record and in the event of an affirmativ e response to the query message, reconciling the field value for the client record and storing a selection value in a selection field representative thereof
  • the method further comprises the steps of reading the selection value and reconciling the field v alue for the predetermined client record according to the selection value
  • the query message is dispatched to a client and or a user and/or an agent of the community, such as for example, an economic developer an employee or contractor of the economic developer or the like
  • An embodiment further comprises the steps of providing the client record with at least one first coordinate field containing data representative of first client coordinate data according to the first filter, and at least one second coordinate field containing second client coordinate data accoiding to the second filter
  • the first client coordinate data may include such things as account information and'or password information and other information relevant to one subgroup of the community, such as for example a chamber of commerce of a municipality while the second coordinate data may include account information and/or password information relev ant to another subgroup of the community, such as for example an economic developer or other service organization in the municipality
  • a computer implemented system for operating a municipal database comprising -first source database means hav ing data fields therein said data fields containing data representative of a pluiahtv of client records for a plurality of clients in a community
  • -second source database means ha ⁇ mg data fields therein said data fields containing data representative of a plurality of entity records for a plurality of entities in the community , wherein at least some of the clients of the first source data base are common with corresponding entities in the second source database,
  • comparing means for comparing the data for each client record in said first source database means with the data for at least one of the entity records m said second source database means to determine a correspondence between a predetermined client record and a corresponding entity record said comparing means being operable to
  • the present invention provides a computer implemented method of operating a municipal database said method comprising the steps of
  • the method further comprises the step of pro ⁇ iding a first interface for a client to access and/or update a corresponding client record
  • the method further comprises the step of verifying a proposed update to a client record by the client
  • the method further comprises the step of approving a proposed update to a client record by the client
  • the method further comprises the step of collecting a client fee from one or more of the clients, wherein the client fee is graduated according to a level of sen ice provided to the client
  • the method further comprises the step of pro ⁇ iding a second interface for performing one or more search engine functions in the client records for one or more users
  • the method further comprises the step of collecting a user fee from end useis. wherein the user fee is graduated according to a level of service provided to the user
  • the method further comprises the steps of receiving a search inquiry from a user, and presenting a listing of client records relevant to the search inquiry
  • the method further comprises the step of pro ⁇ iding a date and or time stamp for each of the client records and updating the date and or time stamp after an update to the client record
  • the method further comprises the step of organizing the listing of records in an order according to a ⁇ alue for each date and or time stamp
  • the method further comprises the step of issuing an invitation to a client to review and/or update a corresponding client record
  • the method further comprises the steps ot dispatching a plurality of sun ey messages to a co ⁇ espondmg plurality of clients providing m each sun ey message a plurality of answer fields to receive data from the corresponding client, and receiving a reply survey message from at least one of said corresponding clients
  • the method further comprises the step of updating a corresponding client record according to data m one or more of the answer fields
  • the method further comprises the steps of prov iding a portal for the municipality, and providing the first and/or second interfaces w ith a skin to correspond visually with the portal
  • the method further comprises the step of providing each client record with a user access filter field providing a filter value to the field, and permitting access to the data in the client record by users corresponding to the filter value
  • the method further comprises the step of providing each client record w ith a plurality of filter fields, a first of the fields corresponding to a first group of users, and a second of the filters corresponding to a second group of users, and permitting access to the data in the client record by users corresponding to the first and or second filter values
  • the method furthei comprises the step of dispatching an update message to one or more useis the update message containing data representative of a message that a client record has been updated and/or data representative of the updated client record
  • the present invention pro ⁇ ides a computer implemented system for operating a municipal database, comprising
  • first source database means having data fields therein said data fields containing data representative of a plurality of client records for a plurality of clients in a municipality
  • -second source database means having data fields therein said data fields containing data representative of a plurality of entity records for a plurality of entities in the municipality, wherein at least some of the clients of the first source data base are common with corresponding entities in the second source database
  • -comparing means for comparing the data for each client record in said first source database means v ⁇ ith the data for at least one of the entity records in said second source database means to determine a match between each client record and a corresponding entity record
  • -data reconciliation means for reconciling with each match the data in corresponding client and entity records to generate a reconciled client record
  • a method of creating a database containing data from at least two source databases that are organized under mutually incompatible protocols comprising the steps of providing a first source database hav ing data fields therein each addressable under a first data protocol, providing a second source database hav ing data fields therein each addressable under a second data piotocol, wherein the first and second data protocols are incompatible one with the other transforming the data in at least one of the first source database and the second source database to conform to a standard protocol comparing the data in each record in the first source database w ith at least one of the records in the second source database to determine a correspondence between each record in the first source database with at least one of the records in the second source database for each correspondence reconciling the data in the first source database and the second source database m order to optimize each field of data in each record, and storing the optimized data for each record as a record in a resulting master database
  • a method of creating a database containing data from at least two source databases comprising the steps of providing a first source database hav ing data fields therein providing a second source database hav ing data fields therein, w herein the first and second databases are incompatible one with the other, comparing the data in each record in the first source database with at least one of the records in the second source database to determine a correspondence between each record in the first source database with at least one of the records in the second source database for each correspondence, reconciling the data in the first source database and the second source database in order to optimize each field of data in each record and storing the optimized data for each record as a record in a resulting master database
  • a method of creating a database for use by a municipality, and containing data from at least two source databases comprising the steps of providing a first source database having data fields therein the data fields containing data related to the municipality and having been collected by the municipality, providing a second source database having data fields therein the data fields containing data related to the municipality, comparing the data in each record in the first source database with at least one of the records in the second source database to determine a correspondence betw een each record in the first source database with at least one of the records in the second source database, for each correspondence reconciling the data in the first source database and the second source database in order to optimize each field of data in each record and storing the optimized data for each recoid as a record in a resulting master database
  • a method of providing results from a database comprising the steps of providing a mastei database hav ing data fields therein the database containing records related to clients and wherein the client records hav e been updated from data received directly from the clients and wherein each the client record has a time stamp associated with it ieceivmg a search inquiry from a user related to the client records in the master database comparing the search inquirv to the client records in the master database, identifying the records in the master database that match the inquir> and presenting the identified client records from the master database in order of recency as determined by the date stamp
  • a method of operating a municipal database comprising the steps of providing a master database having data fields therein and wherein the data fields containing data related to the municipality receiv ing clients related to the municipal database providing each client with a client record in the master database and v erify ing and updating, as necessary the client record for each client
  • a method of operating a database comprising the steps of providing a master database having data fields therein, receiv ing clients related to the database, providing each client with a client record in the master database v e ⁇ fymg and updating as necessary, the client record for each client wherein each the client record has a time stamp associated with it, which time stamp is updated when the client record is updated and presenting the identified records from the source database in order of recency as determined bv the date stamp upon receipt of a search inquiry from a user related to the records in the master database
  • a method of operating a municipal database for use by a municipality, and containing data from at least two source databases comprising the steps of: providing a first source database having data fields therein, the data fields containing data related to the municipality and having been collected by the municipality; providing a second source database having data fields therein, the data fields containing data related to the municipality; comparing the data in each record
  • a method of generating revenue from activities associated with a municipality comprising the steps of: providing a master database having data fields therein, and wherein the data fields contain data related to the municipality; receiving clients related to the municipal database; providing each client with a client record in the master database; and, collecting a client fee from each the client having the client record in the master database.
  • the present invention provides a computer program product encoded in a computer readable or executable medium or signal including a plurality of computer executable steps for a computer to create a database containing data originating from at least two source databases that are organized under mutually incompatible protocols, said method comprising the steps of:
  • the present inv ention provides a system for creating a database containing data originating from at least two source databases that are organized under mutually incompatible protocols comprising the steps of
  • the present invention provides a server system for creating a database containing data originating from at least two source databases that are organized under mutually incompatible protocols comprising the steps of
  • first and second data protocols are incompatible one with the other, means for tiansiorming the data in at least one of said first source database and said second source database to conform to a standard protocol
  • the present invention provides a computei progiam product encoded in a computer readable oi executable medium oi signal including a pluiahty of computer executable steps for a computer to create a database containing data originating from at least two source databases that are organized under mutually incompatible protocols said method comprising the steps of
  • the present invention provides a system for creating a database containing data originating from at least two source databases that are organized under mutually incompatible protocols, comprising the steps of
  • first and second data protocols are incompatible one with the other, means for transforming the data m at least one of said first source database and said second source database to conform to a standard protocol
  • the present invention provides a server system ior creating a database containing data originating from at least two source databases that are organized under mutually incompatible protocols comprising the steps of
  • the present invention provides a computer terminal system for use on a network for maintaining a database containing data originating from at least two source databases that are organized under mutually incompatible protocols comprising one or more of
  • transformation means for transforming the data in at least one of said first source database and said second source database to conform to a standard protocol - comparison means for comparing the data in each record in said first source database w ith at least one of the records in said second source database to determine a correspondence between each record in said first source database with at least one of the records in said second source database
  • the present invention provides a method of creating a database containing data from at least two source databases the method comprising the steps of
  • the method includes, after the reconciling step, the step of updating the data in the at least one field in the system formatted database
  • the present invention provides a computer terminal system for use on a network for maintaining a database containing data originating from at least two source databases that are organized under mutually incompatible protocols, comprising one or more of
  • first storage means for providing a first source database having data fields therein each addressable under a first data protocol
  • first and second data protocols are incompatible one with the other, - transformation means for transforming the data in at least one of said first source database and said second source database to conform to a standard protocol
  • the present invention pro ⁇ ides a method of creating a database containing data from at least two source databases the method comprising the steps of
  • a community database system comprising: a computer system providing an online business directory; means for accessing a first source database having data fields therein, said data fields containing data representative of a plurality of client records for a plurality of clients in a community; means for accessing a second source database having data fields therein, said data fields containing data representative of a plurality of entity records for a plurality of entities in the community , wherein at least some of the clients of the first source data base are common with corresponding entities in the second source database; comparing means for comparing the data for each client record in said first source database means with the data for at least one of the entity records in said second source database means to determine a correspondence between a predetermined client record and a corresponding entity record; said comparing means being operable to: scrub the data in said first source database and said second source database and indexing the data by setting the data to a comparison standard; compare data in a predetermined client record in the first source database with at least one of the entity records in the second source database
  • the means for accessing said first and second source databases are secure data links.
  • a further aspect ol the present invention pi o ⁇ ides a method of operating a community database said method comprising the steps of accessing a first source database ha ⁇ ing data fields therein said data fields containing data representative oi a pluiahty of client records for a plurality of clients in a community accessing a second source database having data fields therein said data fields containing data representativ e of a plurality of entity records for a plurality of entities in the community v ⁇ herein at least some of the clients of the first source data base are common with corresponding entities in the second source database comparing data in a predetermined client record from the first source database w ith at least one of the entity records from the second source database to deteimine a correspondence there between, including the steps of assigning a weighting value to the fields for the predetermined client record from the first source database and to the fields of at least one predetermined entity record from the second source database calculating a percentage
  • a further aspect of the present invention provides a computer-readable medium having computer-executable instructions on it to cause the computer system to perform the method described
  • Yet another aspect of the present invention provides a method of operating a community database said method comprising the steps of accessing a first source database via a secure data link said first source database having data fields therein said data fields containing data representative of a plurality of client records for a plurality of clients in a community accessing a second source database via a secure data link, said second source database having data fields therein said data fields containing data representative of a plurality of entity records for a plurality of entities in the community wheiein at least some of the clients of the first source data base are common with corresponding entities in the second source database comparing data in a predetermined client record from the first source database with at least one of the entity records from the second source database to determine a correspondence there between including the steps of assigning a weighting value to the fields for the predetermined client record from the first source database and to the fields of at least one predetermined entity record from the second source database calculating a peicentage ⁇ alue of a portion of the data m a field from the first
  • While the system is applicable to business directories for communities such as municipalities and regions it may also be useful for other directories needing one or more of the features described herein, including othei communities such as professional associations government organizations business enterprises such as retail organizations which provide portal access both for suppliers and customers and the like
  • Figure 1 is an overall diagrammatic v iew of a database management system
  • Figure 2 is an overall diagrammatic v iew of the hardware and net w oiks used by system of figure 1 ,
  • Figure 3 is a representation of a first source database for use in the system of figure 1 ,
  • Figure 4 is a representation of the first source database after a first manipulation
  • Figures 5a and 5b are representations of the first source database of figure 4 after a second manipulation
  • Figures 6a and 6b are representations of a second source database for use in the system of figure 1 ,
  • Figure 7 is a chart showing a portion of a data reconciliation function
  • Figure 8a, 8b 8c and 8d are representations of a master database for use in the system of figure 1 ,
  • Figure 9 is a flow chart of a data reconciliation portion of the system of figure 1 .
  • Figure 10 is a flowchart of a data maintenance process of the system of figure 1 Figure 1 I A is a computer screen printout of an Internet page used by a user searching for information in the database of the system of figure 1 , showing a first skin;
  • Figure 1 I B is a computer screen printout of an Internet page used by a user searching for information in the database of the system of figure 1 , showing a second skin;
  • Figure 12A is a computer screen printout from the software accessing the database of the system of figure 1, showing a first level of service;
  • Figure 12B is a computer screen printout from the software accessing the database of the system of figure 1, showing a second level of service;
  • Figure 12C is a computer screen printout from the software accessing the database of the system of figure 1 , showing a third level of service.
  • the system provides a number of functions to assemble the database which requires relatively little effort by a representative of a municipality, such as an economic development department or organization related to the municipality (hereinafter referred to as an Fconomic Developer ) 1 he svstem prov ides a number of subroutines which are operable to organize the one or more databases using a standard format thereby to undertake a record by record comparison of the databases, then to resolv e conflicts in the data in order to assemble a master database
  • the system then makes use of communications between business entities and other community partners whose data may or may not be in one or more records on the database to maintain the integrity of the database For example the community partners may participate for reasons other than to contribute data to the database
  • the system employs a computer system 10 providing an online business directory 12 which draws from one or more source data bases 14 from a variety of sources by way of a secure data link 16
  • the system provides a front end portal 18 to provide information for a municipality as well as to one or more search engine functions for various third parties to accumulate data from the directory 12
  • the system also prov ides a portal 20 for various community partners whose data is contained in the directory or who have a stake in the ongoing activities of the economic dev elopment effort
  • the system also provides a portal 22 for the business entities or clients, who are featured in the business directory
  • system 10 is resident m an architecture 24 which includes a pair of redundant firewall modules 26 28 which themselves hav e an access port to the internet a remote server module 30 to run a plurality of applications for carrying out the method herein, as will be desciibed
  • a pair of backup server modules 32 34 is also prov ided to provide backup functions for applications for carrying out the method herein as well as a host sen er module 36 also to run a plurality of applications
  • a test terminal module is provided at 38 to allow for ongoing testing of the system
  • the modules communicate with one another on a local area network under a number of well known protocols, through a w ired physical link via a hub module 40
  • a fu st source database (Figuie 3) is prov ided, having data fields therein each addressable under a first data protocol
  • the step oi providing a first source database includes collecting data from the municipality 1 ypically, the best economic and related demographic data relevant to a region come from a Chamber oi Commerce or
  • the first and second data protocols are usually incompatible one with the other Further, the first and second databases may also themselves be incompatible one with the other
  • the data in at least one of the first source database and the second source database are transformed to conform to a standard protocol, as will now be discussed in greater detail 1 he data in each record of the second database are compared in the first system formatted source database of figures Sa and 5b with at least one of the records in the second source database to determine a correspondence betw een each record m the first source database with at least one of the records in the second source database
  • the data in the first source database and the second source database are reconciled in order to optimize each held of data in each record
  • the resulting optimized data for each record are stored as a record in a resulting master database, as can be best seen in Figures 8a to 8d
  • the master database has data fields therein which fields contain records related to clients
  • new businesses have been added
  • the entry for ' Sneider Foods now has additional information (phone numbers)
  • the step of reconciling the data in the first source database and the second source database includes scrubbing and transforming the data in the first source database and the second source database as is partially shown between figures 4 , 5a and 5b
  • the data are manipulated into the system format that will allow reconciliation to continue Specifically, the fields in the first source database ( Figures 5a and 5b) and the second source database ( Figures 6a and 6b) are identified If anv information in these fields is concatenated (meaning connected or linked in a series) it is separated into the appropriate fields in the master database ( Figures 8a to 8d) 1 he step of identifying the fields of the first source database and the second source database may also comprise a user defined matching process m the event that fields cannot automatically be identified
  • the step of reconciling the data in the first source database and the second source database includes indexing the data by setting the data to a comparison standard Typically all of the letters in the data are capitalized and short forms of words are amended to their short or full form (e g St is amended to read Street or vice xersa)
  • the step of reconciling the data in the first source database and the second source database may also include assigning a weighting value to the fields in the first source database and the second source database as can be best seen in Figure 7
  • a possible weight is assigned to each data field For example weights of 6, 4 and 3 are shown 1 he portion of the data in the data field of the first source database that matches the data m the data field oi the second source database is calculated and expressed as a percentage Peicentage matches of 50%, 0% and 100% are shown
  • a field ⁇ alue is calculated as the product of the possible weight and the percentage value for each data field for each particular record The field values of all of the data fields for the particular record are summed to create a match value
  • the system is operable to query a user to resoh e a conflict
  • the system may consider two entries where, in case, the member s name is CIBC and in the other CANADIAN IMPLRIAL BANK OF COMMFRCF
  • the sv stem will look at the entities and "weight ' the name field as a zero If the address and phone number fields are equal, then the system reports these two entries represent a potential match and will then check a name association table for a reference for a resolution If none exists, the system will pose the question "is CIBC equal to the CANADIAN IMPFRIAL BANK OF COMMLRCL and will learn from the answ er, so that, m the affirmative, the name CIBC will be associated, in memory, in the name association table with CANADIAN IMPERIAL BANK OF COMMERCF
  • the filter may be an allocation code relating to a different organization, a region field, a province/state code and a country code
  • the filter may be an allocation code relating to a different organization, a region field, a province/state code and a country code
  • phase 1 is employed by depressing, in one example a button labelled "build seed data set to transform a new dataset into a comparison dataset which imports the scrubbed data into a format that can be compared then build a current data set
  • the data is compared between a new record in a new dataset and each record in the comparison dataset
  • the weighting is then applied.
  • the new record is considered a "New' record
  • the match weight is anything above 10 then the new record is considered to be a match with another record in the system
  • it may be beneficial to raise the minimum level from 3 to 4 which may ha ⁇ e the effect of missing a few matches but has the benefit of cutting down the number of records that we have to look at manually Therefore in this case accuracy can be traded off against processing speed
  • This is applicable in some rural areas where the system may faces matches of a common postal code applied to a common rural route whereas an increase of the minimum le ⁇ el to 4 may eliminate this match and the new record would indeed be considered new
  • the match ⁇ alue is 6
  • a user defined sensitiv ity can be created that classifies a value of 3 or less as no match a value from 4 through 10 as a possible match and a value of greater than 10 as a positive match
  • an appropriate action can be performed For instance if there is a positive match the data values that match l OO'O can be stored in the appropriate field in the master database For other matches that are not 100%, a user could define which data value is correct
  • the system 10 may acquire or accumulate intelligence of probable versus possible matches for example by having the ability to analyze the cost/accuracy impact by moving from one minimum level to another that is by saving a given amount of time but by losing a given amount of accuracy
  • That time/accuracy balance may also be of value depending on the type of database being imported For example, if the data base is a manufacturer's database the Economic Developer may be more interested in 100 percent accuracy than in saving time whereas if the database relates to sen ice clubs, the Economic Developer may be more interested in saving importing time at the expense of lower accuracy
  • the first and second source databases will contain data regarding existing business entities and or clients oi the economic development department in the municipality
  • the databases may also include records not attributable to any one existing business entitv and or client but may contain general demographic data on such things as numbers of schools, religious institutions profiles of the workforce and the like, as may be available from government sources such as Statistics Canada and the like In this case this general demographic data may be made organized according to a set of fields unique to that general demographic data as desired
  • the business directory may be used bv different organizations for independent functions and will involve recording perhaps different data for the same member'
  • a client in the business directory is a member of a Chamber of Commerce and a Service Organization
  • the chamber of commerce may use the business directory to store such things as the members Chamber account membership number and perhaps a password for secure access to a private page available only to members
  • the Service Organization may have the same information on the same member but the information for the chamber is inaccessible to the sen ice organization
  • the Economic Developer may retain employee and revenue information for that member which is off limits to both the chamber of commerce and the serv ice club And yet in all cases, the business directory would normally have one record or entry for that member with data fields containing the required data for all three collectively
  • Clients are permitted and indeed encouraged to update the master database records directly themsehes in order to keep the records in the master database current
  • the client records are updated from data received directly from the clients, typically in real time oxer the Internet or by anv other suitable manner
  • an administrator approves the updates to the master database from the clients in order to preclude unacceptable data from being entered into the database
  • a reminder e-mail or a message in some other appropriate format such as cell phone text messaging instant messaging of the type known under the well known trade name MSN or for that matter a paper letter a phone call either pre-retorded or otherwise a facsimile by fixed or stationary de ⁇ ices such as telephones cell phones desktop and laptop computers, personal digital assistants (or PDA s) such as those under the trade names PAI M and RIM BLACKBERRY or the like is sent out to clients having out of date data on the master database
  • PDA s personal digital assistants
  • the system 10 also provides a method ol providing results from a database
  • a search inquiry from a user related to the client records in the master database
  • the search mquirv is compared to the client records in the master database and the records in the master database that match the inquiry are identified
  • the identified client records from the master database are presented in an order of recency as determined by the date stamp
  • clients w ho have updated their data most recently are presented first in response to a search inquiry thus providing incentive for clients to keep their data records current in the master database
  • Further such database updates from the clients are forwarded to community partners for example organizations such as Chambers of Commerce BI A s Tourism Associations and other groups that represent numbers of businesses
  • each record of the master database is presented on a web page that is created for each client.
  • Each client has a choice of a basic web page an enhanced web page or a complete web page as discussed more fully below
  • a user doing a search inquiry is linked to the appropriate web pages corresponding to the results of the search
  • the system 10 also allows for the creation of a survey related in some manner to the data in the database
  • the survey is sent to at least some of clients in the database as appropriate 1 he answer fields in the survey are linked to the master database such that the master database is updated using the results of the survey
  • the survey function is useful because it permits representatives in the municipality to create their own surveys within the system which can be useful to add missing information in the data and ask additional questions that are not in our mam set of data relating to data that already exits in the database for example for additional clarification qualification or the like
  • the survey might be used by a municipality to determine certain demographic information on a particulai request
  • a company referred to herein as a Site Selector
  • a representative of the municipality looking at the database sees that there is no data on the demographics of red meat eaters in that region
  • the representative implements a survey to the businesses in the region to determine the number of
  • the system may also be used to ensure that different subsets of data are maintained by the appropriate person or group of persons or automatic subroutine
  • the representativ e sets the system up by prov iding the email addresses of individuals in the community responsible for helping maintain data (referred to as data gatherers)
  • a representative of the local Utilities Commission for example may be responsible tor information about the power grid whereas someone from the local Human Resources Development may be responsible for providing information about labour and wage rates
  • the system may also be used to allow Economic Developers to collect information from the community in a standardized format specifically the International Economic Development Council's set of economic development data standards
  • a Site Selector they can remain anonymous if they w ish) looking to relocate or open a businesses w ill put down some basic criteria for the type of city they are looking to relocate to for example population needs airport etc They will also be able to request and rank other information from the data standard
  • the Site Selector When the Site Selector submits their request the applicable data gatherers (or for that matter businesses or other organizations participating in the system) may be notified as needed If they choose to respond the Survey system is operable to automatically send a questionnaire to those responsible for data requesting the specific information that the Site Selector is looking for 1 he information is automaticalh assembled and returned to the Site Selector Those who respond can also see where the v ha ⁇ e placed ⁇ s then competition
  • the system may be equipped with one or more search engine functions in order for users to access data m one or more of the records
  • a portion of the records of the master database can be marked as confidential
  • the records may be accessible only to users of a predetermined security clearance level For instance, a member of the general public may not be given access to records relating to employee members at business in a particular region whereas a member of a company considering establishing a presence in a municipal area may be given such clearance
  • the system provides a method of operating a municipal database
  • the operation of a municipal database permits the collecting of a client fee from each the client hav ing the client record in the master database, and also the collecting of a user lee from end users
  • the client fees are graduated according to a level of service prov ided to the client
  • the basic bronze le ⁇ el of serv ice as shown in Figure 12A provides for a basic web page that is linked to if it is identified in response to a search inquiry 1 his basis web page provides fundamental information about the business, such as business name address, telephone number, facsimile number contacts type of business year established, and recency oi information There are also links to contact information and a map
  • the enhanced silver level of serv ice as shown m Figure 12B provides for an enhanced web page that is linked to if it is identified in response to a search inquiry This enhanced web page has the information shown in the basis web page, and additionally has an enticing header about the
  • users could be charged user fees These user fees could also be graduated according to a level of service provided to the user
  • the present invention also provides a method of generating revenue from activities associated with a municipality
  • the skin or "look and feel ' of the database software can be created to appear similar to a corresponding web page on the portal of the municipality, two examples of which are shown in Figures 1 IA and 1 IB
  • Skin creation involves the replication of the look and feel of the Municipality web site, preferably using a templated structure
  • the present invention provides a municipal database that is affordable to acquire and maintain, a municipal database wherein the data are kept current by end users, a municipal database wherein the data are complete and accurate, a method of operating a municipal database wherein search results from the database are presented in a order of recency of update, a municipal database wherein revenue is generated for the municipality, all of which features are unknown in the prior art.
  • This system lends itself to providing windows and or views to other systems and applications that can be seen without having to leave the system. Parameters can also be passed from this system to automatically leverage the third party system. For instance GlS applications, like MapPoint, where parameters are passed through custom connectors to display an accurate location map. Third party websites complete with all of there specific functionality can also be leveraged directly through this system. Supporting links may also be made readily available where it is appropriate that the user actually leave the system.
  • the systems described herein may include a programmed logic controller or some other form of controller. It may be included in a software program configured to run on a general purpose computer, such as personal computer, or on a more substantial computer mainframe, which is operable to work within a network, for client records to be uploaded to a central database.
  • the network may thus involve several general purpose computers, for example those sold under the trade names APPLE "” or IBM “”, or clones thereof, which are programmed with operating systems known by the trade names WINDOWS "", LINUX or other well known or lesser known equivalents of these.
  • the system may involve pre-programmed software using a number of possible languages or a custom designed version of a programming software sold under the trade name ACCESS " n or similar programming software.
  • the computer network may be a wired local area network, or a wide area network such as the Internet, or a combination of the two, with or without added security, authentication protocols, or under "peer-to-peer” or “client-server” or other networking architectures.
  • the network may also be a wireless network or a combination of wired and wireless networks.
  • the wireless network may operate under frequencies such as those dubbed 'radio frequency' or "RF" using protocols such as the 802.1 1 , TCP/IP, BLUE TOOTH and the like, or other well known Internet, wireless, satellite or cell packet protocols.
  • the system may, alternatively, include a single custom built computer which is dedicated to the function of the system alone. T he individual components shown in outline or designated b ⁇ blocks in the attached Draw ings are all well-known in the computer programming arts, and their specific construction and operation are not critical to the operation or best mode for carrying out the invention

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Strategic Management (AREA)
  • Physics & Mathematics (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Human Resources & Organizations (AREA)
  • Economics (AREA)
  • General Business, Economics & Management (AREA)
  • Marketing (AREA)
  • Development Economics (AREA)
  • Tourism & Hospitality (AREA)
  • Data Mining & Analysis (AREA)
  • Accounting & Taxation (AREA)
  • Quality & Reliability (AREA)
  • Finance (AREA)
  • Game Theory and Decision Science (AREA)
  • Operations Research (AREA)
  • Software Systems (AREA)
  • Probability & Statistics with Applications (AREA)
  • Mathematical Physics (AREA)
  • Educational Administration (AREA)
  • Fuzzy Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Computational Linguistics (AREA)
  • Databases & Information Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

L'invention concerne un rocédé de création d'une base de données et de production de résultats à partir d'une base de données, à utiliser par une municipalité, et exploitant une base de données de communauté, comprenant les étapes consistant à : fournir une première et une deuxième base de données sources adressables sous un premier et un deuxième protocole respectif, lesdits protocoles étant incompatibles entre eux, transformer, comparer et rapprocher les données des première et deuxième bases de données sources afin d'optimiser chaque champ de données dans chaque enregistrement, et stocker les données optimisées pour chaque enregistrement sous la forme d'un enregistrement dans une base de données maîtresse de résultat. Les enregistrements émanant de recherches sont présentés par ordre de chronologique. La présente invention concerne également un procédé de génération de revenus à partir d'activités associées à une communauté.
PCT/CA2007/001362 2007-08-07 2007-08-07 Optimisation, gestion et maintenance d'une base de données d'une communauté Ceased WO2009018644A1 (fr)

Priority Applications (1)

Application Number Priority Date Filing Date Title
PCT/CA2007/001362 WO2009018644A1 (fr) 2007-08-07 2007-08-07 Optimisation, gestion et maintenance d'une base de données d'une communauté

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
PCT/CA2007/001362 WO2009018644A1 (fr) 2007-08-07 2007-08-07 Optimisation, gestion et maintenance d'une base de données d'une communauté

Publications (1)

Publication Number Publication Date
WO2009018644A1 true WO2009018644A1 (fr) 2009-02-12

Family

ID=40340901

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CA2007/001362 Ceased WO2009018644A1 (fr) 2007-08-07 2007-08-07 Optimisation, gestion et maintenance d'une base de données d'une communauté

Country Status (1)

Country Link
WO (1) WO2009018644A1 (fr)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8843501B2 (en) 2011-02-18 2014-09-23 International Business Machines Corporation Typed relevance scores in an identity resolution system
EP2659393A4 (fr) * 2010-12-29 2015-08-19 Nokia Technologies Oy Procédé, appareil, système et produit-programme d'ordinateur permettant de gérer des données dans une base de données
CN111522870A (zh) * 2020-04-09 2020-08-11 咪咕文化科技有限公司 数据库访问方法、中间件和可读存储介质

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6931419B1 (en) * 2000-02-11 2005-08-16 Hallmark Cards Incorporated Data management system for automatically accessing, maintaining, propagating user data among plurality of communities, each of which contains plurality of members
WO2005096167A1 (fr) * 2004-03-29 2005-10-13 Edward Cox Repertoire electronique oriente communaute et systeme et procede de developpement d'entreprises
US7136880B2 (en) * 2000-07-20 2006-11-14 Market Models, Inc. Method and apparatus for compiling business data
US20060291492A1 (en) * 2005-02-11 2006-12-28 Nugara Daniel M P Method and Apparatus for Publishing a Community Based Directory and of Offering Associated Community Based Services

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6931419B1 (en) * 2000-02-11 2005-08-16 Hallmark Cards Incorporated Data management system for automatically accessing, maintaining, propagating user data among plurality of communities, each of which contains plurality of members
US7136880B2 (en) * 2000-07-20 2006-11-14 Market Models, Inc. Method and apparatus for compiling business data
WO2005096167A1 (fr) * 2004-03-29 2005-10-13 Edward Cox Repertoire electronique oriente communaute et systeme et procede de developpement d'entreprises
US20060291492A1 (en) * 2005-02-11 2006-12-28 Nugara Daniel M P Method and Apparatus for Publishing a Community Based Directory and of Offering Associated Community Based Services

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP2659393A4 (fr) * 2010-12-29 2015-08-19 Nokia Technologies Oy Procédé, appareil, système et produit-programme d'ordinateur permettant de gérer des données dans une base de données
US8843501B2 (en) 2011-02-18 2014-09-23 International Business Machines Corporation Typed relevance scores in an identity resolution system
US8856144B2 (en) 2011-02-18 2014-10-07 International Business Machines Corporation Typed relevance scores in an identity resolution system
CN111522870A (zh) * 2020-04-09 2020-08-11 咪咕文化科技有限公司 数据库访问方法、中间件和可读存储介质
CN111522870B (zh) * 2020-04-09 2023-12-08 咪咕文化科技有限公司 数据库访问方法、中间件和可读存储介质

Similar Documents

Publication Publication Date Title
US7266566B1 (en) Database management system
US6385620B1 (en) System and method for the management of candidate recruiting information
US8156105B2 (en) Rapid item data entry for physical items in the control of a user in an item data management server
Bradley Sampling for Internet surveys. An examination of respondent selection for Internet research
US7962347B2 (en) Advisor referral
US7254573B2 (en) System and method for identifying alternate contact information in a database related to entity, query by identifying contact information of a different type than was in query which is related to the same entity
US8346782B2 (en) Method and system of information matching in electronic commerce website
US20030061232A1 (en) Method and system for processing business data
US20030167197A1 (en) Customer relationship measurement and management system and method
US20160171557A1 (en) Customer Insight System Architecture
US20120331561A1 (en) Method of and Systems for Privacy Preserving Mobile Demographic Measurement of Individuals, Groups and Locations Over Time and Space
CN103593798A (zh) 在基于网络的拍卖工具内辅助交易的方法和装置
Proehl et al. Topics and applied theories in it service management
AU2008200194B2 (en) Street Quality Assessment Method and System
CN101013491A (zh) 一种实现商品信息汇集并按价格排名竞争发布的方法
Ng et al. An intelligent agent for web advertisements
WO2009018644A1 (fr) Optimisation, gestion et maintenance d'une base de données d'une communauté
US8856094B2 (en) Remote segmentation system and method
Butters What features in a Portal?
US7859550B2 (en) Item data management over a data network for physical items in the control of a user
Burke et al. URLs in the OPAC: integrating or disintegrating research libraries' catalogs
US20240095795A1 (en) Property lead finder systems and methods of its use
Bhardwaj et al. Use of electronic information resources in libraries
Simon Using administrative data for constructing sampling frames and replacing data collected through surveys
Kribel et al. Internet and e-commerce service adoption by the Slovenian travel agencies: a comparative view

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 07800430

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

32PN Ep: public notification in the ep bulletin as address of the adressee cannot be established

Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205A DATED 13.04.10)

122 Ep: pct application non-entry in european phase

Ref document number: 07800430

Country of ref document: EP

Kind code of ref document: A1