US20110213799A1 - System and method for managing context-rich database - Google Patents

Abstract

A system and method for processing records in a database. The method includes calculating, by a processor, a source quality for each source in the database based on records associated with the source. The method includes applying, by a processor, user preferences corresponding with a user request to search the database, where the user request comprises a source quality range, and a query expression. The method further includes determining, by a processor, the records in the database that satisfy the user request, where the determined records match the source quality range.

Description

CROSS REFERENCE TO RELATED APPLICATIONS
• This application is a divisional of U.S. application Ser. No. 11/656,885, filed Jan. 22, 2007, entitled SYSTEM AND METHOD FOR MANAGING CONTEXT-RICH DATABASE, which claims the benefit of U.S. Provisional Patent Application No. 60/760,729 filed on Jan. 20, 2006 entitled “SYSTEM AND METHOD FOR INFORMATION RETRIEVAL”, and U.S. Provisional Patent Application No. 60/760,751 filed on Jan. 20, 2006 entitled “SYSTEM AND METHOD FOR STANDARDIZING THE DESCRIPTION OF INFORMATION”, all of which are incorporated herein by reference in their entirety.
• This application is related to U.S. application Ser. No. 11/625,761, filed on Jan. 22, 2007, and titled “SYSTEM AND METHOD FOR CONTEXT-RICH DATABASE OPTIMIZED FOR PROCESSING OF CONCEPTS” which is hereby incorporated by reference in its entirety.
BACKGROUND
• 1. Field of the Invention
• The invention relates to databases, and in particular, to a multi-contextual, multi-dimensional database optimized for processing of concepts.
• 2. Description of the Related Technology
• Conventional databases are typically designed with a single purpose in mind, within a closed system. There is a growing interest in the marketplace to share data in order to have multiple systems interoperate and, in some cases, benefit from a larger body of experience.FIG. 1A illustrates the limited record/field structure of a conventional database record and the limited number of associations possible from records lacking contextual robustness and depth.
• Much research has been done over the years to solve the challenge of a uniform representation of human knowledge. Solutions ranging from fixed taxonomies and ontologies to the more recent specification for the Semantic Web have made noble attempts at overcoming these challenges, but important gaps remain. Persistent problems can be summarized as follows:
• • 1. Knowledge is created, recorded, transmitted, interpreted and classified by different people in different languages with different biases and using different methodologies thus resulting in inaccuracies and inconsistencies.
  • 2. The vast majority of knowledge is expressed in free-form prose language convenient for human interpretation but lacking the structure and consistency needed for accurate machine processing. Current knowledge tends to be represented in a one-dimensional expression where the author makes a number of assumptions about the interpreter.
  • 3. There is no international standard or guideline for expressing the objects and ideas in our world and therefore no way to reconcile the myriad ways a single idea may be represented.
  • 4. As a result of the foregoing, the vast majority of information/knowledge in existence today is either inaccurate, incomplete or both. As a result, true industry-wide or global collaboration on projects ranging from drug discovery to homeland security is effectively prevented.
  • 5. There are several reasons for this shortcoming: a) very few people have the training of an Information Scientist capable of capturing the multidimensional complexity of knowledge; and b) even with such training, the process has been extremely onerous and slow using current methods.
  • 6. Compounding on these challenges is the fact that both new knowledge creation and the velocity of change is increasing exponentially.
  • 7. Even though an abundance of sophisticated database technology is available today, improved data mining and analysis is impossible until the quality and integrity of data can be resolved.
SUMMARY OF CERTAIN INVENTIVE ASPECTS
• The system, method, and devices of the invention each have several aspects, no single one of which is solely responsible for its desirable attributes. Without limiting the scope of this invention, its more prominent features will now be briefly discussed.
• In one aspect, there is a computer-implemented method of processing records in a database, the method comprising a) calculating, by a processor, a source quality for each source in the database based on records associated with the source; b) applying, by a processor, user preferences corresponding with a user request to search the database, wherein the user request comprises a source quality range, and a query expression; and c) determining, by a processor, the records in the database that satisfy the user request, wherein the determined records match the source quality range.
• In another aspect, there is a computer-implemented system for processing records in a database, the system comprising means, operable on a processor, for calculating a source quality for each source in the database based on records associated with the source; means, operable on a processor, for applying user preferences corresponding with a user request to search the database, wherein the user request comprises a source quality range, and a query expression; and means, operable on a processor, for determining the records in the database that satisfy the user request, wherein the determined records match the source quality range.
• In another aspect, there is a computer-implemented system for processing records in a database, the system comprising a memory; and a processor configured to calculate a source quality for each source in the database based on records associated with the source; apply user preferences corresponding with a user request to search the database, wherein the user request comprises a source quality range, and a query expression; and determine the records in the database that satisfy the user request, wherein the determined records match the source quality range.
• In yet another aspect, there is a computer-implemented method of processing records in a database. The method comprises evaluating, by a processor, all records in the database that are associated with a same phenomenon or object. The method further comprises applying, by a processor, user preferences corresponding with a user request. The method further comprises determining, by a processor, the records in the database that satisfy the user request.
BRIEF DESCRIPTION OF THE DRAWINGS
• FIG. 1A is a diagram showing a conventional database record which is inherently designed for a very narrow purpose and therefore is limited in its ability to provide value in data mining.
• FIG. 1B is a diagram of a contextual data cluster or repository which contains broad contextual information.
• FIG. 2 is a block diagram illustrating the neutral nature of the context-rich data repository where interoperability and data sharing take precedence over form, and highlighting that information can morph into different forms depending upon the task at hand.
• FIG. 3 is a diagram illustrating the contextual complexity of information on a typical medicine vial having references to chemicals, product codes, manufacturers, retailers, usage instructions, safety notices, laws, visual elements, etc.
• FIG. 4 is a block diagram of an embodiment of an example context-rich data repository system having an input management subsystem and a query management subsystem.
• FIG. 5 is a block diagram of an embodiment of system software modules and data resources used by the system shown inFIG. 4.
• FIG. 6 is an overview illustrating one embodiment of a system for data management.
• FIG. 7 is an example illustrating the process of mapping unstructured data into a context-rich data structure.
• FIG. 8 is an example of the subject-specific template.
• FIG. 9 is an example illustrating the process of calculating a qualitative score for each entity based on all records associated with that entity.
• FIG. 10 is an example illustrating the process of calculating a qualitative score for each record based on all parameters included in that record.
• FIG. 11 is an example illustrating the process of scoring each entry within a record.
• FIG. 12 is an example illustrating a table which may be used in the process of mapping unstructured data into a context-rich data structure.
• FIG. 13 is an example of a user query message.
• FIG. 14 is an example illustrating the process of retrieving data based upon user-designated quality parameters.
• FIG. 15 is a flowchart of one embodiment of a method of formatting unstructured data.
• FIG. 16 is a flowchart of an embodiment of the structured data entry module shown inFIG. 6.
• FIG. 17 is a flowchart of one embodiment of a method of linking a data object to one or more templates.
• FIG. 18 is a flowchart of one embodiment of a method of evaluating the quality of a data object.
• FIG. 19 is a flowchart of one embodiment of a method of adding contextual data to a data object.
• FIG. 20 is a flowchart of one embodiment of a method of searching a database based on a user quest.
• FIG. 21 is a flowchart of one embodiment of a method of generating query syntax based on a user query message.
• FIG. 22 is a flowchart of one embodiment of a method of interacting with a user to narrow a search result.
DETAILED DESCRIPTION OF CERTAIN INVENTIVE EMBODIMENTS
• The following detailed description of certain embodiments presents various descriptions of specific embodiments of the invention. However, the invention can be embodied in a multitude of different ways as defined and covered by the claims. In this description, reference is made to the drawings wherein like parts are designated with like numerals throughout.
• The terminology used in the description presented herein is not intended to be interpreted in any limited or restrictive manner, simply because it is being utilized in conjunction with a detailed description of certain specific embodiments of the invention. Furthermore, embodiments of the invention may include several novel features, no single one of which is solely responsible for its desirable attributes or which is essential to practicing the inventions herein described.
• This system builds on the premise that mankind will never agree on a single definition of anything. Broad collaboration will always result in a multitude of data sets describing the same experiment or object—each claiming to be the definitive representation. Likewise, there will always be a multitude of definitions or classifications each vying to be the authority. The prevailing approach to database design or data mining today is to restrict input data sources as a means of overcoming this problem. As a result, not only do designers unwittingly introduce a bias that affects all system results, but they effectively ignore the inherent volatility of information: it is in a constant state of update, addition and revision.
• In contrast, the system and method described herein embraces the aforementioned social and cultural aberrations by describing a system that performs the equivalent of an Esperanto language, optimized for machine rather than human processing of complex, imperfect data sets. Further, the system provides a logical mechanism for storing a multitude of related versions of a concept and the means for resolving disparities in a common fashion, thus constricting ambiguity to a minimum. The potential benefits from this invention are immeasurable. Traditionally, researchers have been largely relegated to data mining information generated within their own limited domain without the benefit of understanding the related successes and failures of other comparable international efforts. This system provides a foundation for the creation and maintenance of a single body of human knowledge and experience—thus increasing by several orders of magnitude, the velocity and efficiency of innovation and learning.
• The system is focused on solving the Achilles heel of machine analysis of knowledge—the creation of a universal knowledge repository, such as a multidimensional, context-rich database or data structure, that reflects the nature of the real world. The system describes methods for taking advantage of the fact that any given concept may be represented in a hundred different ways. Rather than selecting one record as “authoritative” like conventional methods, this system analyzes all the versions in a multi-step process to distill the raw material to a series of unique patterns representing human concepts optimized for machine analysis. Each record is analyzed for its relative context in the source document, subject-matter templates, semantic trees and other source documents to build a statistical model representing the aggregation of all perspectives on the topic. This process effectively produces a single abstracted answer with the highest confidence level.
• The system applies to both physical and virtual objects (e.g., a book and a digital file) as well as ideas or language elements (e.g., concepts, nouns, verbs, adjectives). Data records can be imported from, or exported to a multitude of static or linked file formats such as: text, MS Word, hypertext markup language (HTML), extensible markup language (XML), and symbolic link (SYLK). Rather than attempting to force the world into a single view, the system supports multiple perspectives/values for any given object and provides the consumer/user with a way for dynamically setting filters based on variables such as information source, source authority, record robustness, timeliness, statistical performance, popularity, etc.
• Example uses are as follows:
• • 1. A global catalog of all manufactured products, specifications, sources, terms of business, product text, prices, vendors, etc.
  • 2. A global knowledgebase of all counter-terrorism sensors, surveillance, and warnings
  • 3. A global knowledgebase containing all known life-forms and their attributes: cells, genes, organisms, animals, etc.
  • 4. A global knowledgebase containing all known body functions, observation ranges, symptoms, attributes, therapies
• Referring toFIG. 1B, a diagram of a context-rich data cluster orrepository110 will be described. The context-rich data repository110 contains broad contextual information and has multiple-dimensions. Thedata repository110 has unlimited associations and no-predefined purpose. Thedata repository110 can be considered as a virtual entity having multiple records describing and referring to a same object or phenomenon so as to generate a complete definition with various perspectives.
• Referring toFIG. 2, the neutral nature of a context-rich data repository200 is illustrated where interoperability and data sharing take precedence over form. Information can morph into different forms depending upon the task at hand. For example, data associated with a physical object, such as amedicine vial210, can be embodied as a self-containeddata object220, a record in arelational database230, or aweb page240.
• Each record in thesystem data repository200 can include the following features (Entries are either selected from a predefined list of valid terms or validated against a criteria):
• • 1. A unique resource identifier code, such as a universally unique identifier (UUID) or digital object identifier (DOI)
  • 2. One or more fields that represent other coding equivalents (e.g., Social Security number (SSN), international standard book number (ISBN))
  • 3. One or more fields that represent the authority of the information source
  • 4. Data origination specifications (device model, serial number, range, etc.)
  • 5. One or more fields that represent permissions (users, user groups, operating systems, software, search spyders)
  • 6. One or more fields that represent a language equivalents (translations)
  • 7. One or more fields that represent the local measurement conversion of the data
  • 8. One or more fields that represent the observable characteristics and equivalents/observations (visual images: a) front and b) rear, video, radar, IR, sound)
  • 9. One or more fields that represent the physical parameters (length, height, width, diameter, weight, etc.)
  • 10. One or more fields that represent the substance/composition makeup (ingredients, atomic elements, cell structure)
  • 11. One or more fields that represent the relationship to other things (master, sub-assembly, component)
  • 12. One or more fields that represent the economic context (suppliers, buyers, prices)
  • 13. One or more fields that represent the social context (environmental, safety, disclosure)
  • 14. One or more fields that represent the political context (laws, regulations)
  • 15. One or more fields that represent the associated time, date, and location of the event or phenomenon
• Each field in the system data repository can include one or more attributes that:
• • 1. represent the primary name
  • 2. are synonymous with primary name
  • 3. represent the privacy level
  • 4. represent the user rights (actions) and level
  • 5. represent the access/security level
  • 6. represent the qualitative rating level
  • 7. represent the hierarchical inheritance/tree position in a taxonomy or ontology
  • 8. represent the version of the data
  • 9. represent the valid date range of the data
  • 10. contain a dynamic link to external data
  • 11. represent a digital signature that authenticates the data
  • 12. represent the permission level for search engine spyder access
  • 13. represent the data entry person's identification
  • 14. represent the data entry date, time and place
• In thedata repository200, fields, records and clusters may be delimited by symbols or advanced syntax like XML. The specification shows a flattened, expanded record but implementation is preferred in a relational or linked structure. Each data entry preferably includes attributes clarifying information relevant to interoperability, e.g., format, rate, measurement system, data type, etc.
• Referring toFIG. 3,data elements320 associated with theexample medicine vial210, shown inFIG. 2, will now be described.FIG. 3 illustrates the contextual complexity of information on a typical medicine vial. Information regarding a universal product code (UPC) barcode, brand name, plant identifier, serial number, size, weight, product count, radio frequency identification (RFID) code, ingredients, dosage, instructions, and warning text can all be associated with themedicine vial210. As long as the vial is in existence, all its data elements are living links to multiple dynamic entities. Currently, there is no efficient means for validating or researching most of the information represented on the vial. This system would effectively provide a single resource capable of answering any consumer need related to the product, from ordering a refill to overdose intervention.
• Referring toFIG. 4, an embodiment of an example context-richdata repository system400 will be described. Thesystem400 includes a context-rich data repository410 in communication with aninput management subsystem420 and aquery management subsystem430. Thedata repository410 further connects via a network, such as a wide-area network, the Internet, or other types of networks, to lists, ontologies and/ortaxonomies414. Theinput management subsystem420 further connects directly or by use of aweb crawler422 via thenetwork412 toauthors424,devices426,public databases428 andprivate databases429. Thequery management subsystem430 further connects directly or via thenetwork412 to auser432, acomputing system434 and asearch engine436. Operation of thesystem400 will be described herein below.
• Referring toFIG. 5, anembodiment500 of system software modules and data resources used by thesystem400 shown inFIG. 4 will be described. In certain embodiments, aserver510 can include theinput management subsystem420, thequery management subsystem430, and the context-rich data repository410 shown inFIG. 4. Adata entry module535 associated with theserver510 is connected via thenetwork412 to aworkstation515.External data sources520 connect via thenetwork412 to an import/data parser module540 associated with theserver510.External requestors525 connect via thenetwork412 to a datarequest evaluation module560 associated with theserver510. A controller orprocessor530 in theserver510 operates on thedata entry module535, the import/data parser module540, the datarequest evaluation module560, and also a context-rich mapping module545, aqualitative assessment module550, astatistical analysis module555, aresource interface module565, and anaccounting module570. Theresource interface module565 is in communication with and provides value lists572, user profiles andrights574, international information (e.g., language and measure equivalents)576,templates578,ontologies580 andresponses582. The functions and processing performed by these modules will be described herein below.
• FIG. 6 is an overview illustrating one embodiment of a system for data management. Depending on the embodiment, certain modules may be removed or merged together.
• The system may comprise a parseunstructured data module610 configured to map unstructured data into data organized in a context-rich data structure. The system may comprise a structureddata entry module620 configured to receive data input from a source which is compatible with a context-rich data structure. The source could be, for example, a user.
• The system may comprise a subjecttemplate resource module630 configured to receive data organized from the parseunstructured data module610 and the structureddata entry module620. The subjecttemplate resource module630 is configured to look up each element of the object in one or more topic structures such as ontologies, taxonomies, or lists related to the selected template. The upper and lower tree elements for each word are retrieved and stored as a reference to the word along with an identification of what resource is used for the match. A contextualization process is run to calculate results for the newly acquired subject terms. Each calculated context value resulting from the foregoing processes is then compared to each field of the template in order to determine the probability of a match with previously analyzed objects of the same meaning.
• The system may comprise aqualitative assessment module650 configured to receive input from the subjecttemplate resource module630 and then look up the recorded attributes in a table for each category in order to calculate a qualitative score for such things as sources, authors or other deterministic variables.
• The system may comprise a context-rich mapping module660 configured to receive input from thequalitative assessment module650 and then add further information into the structured data.
• The system may comprise auniversal knowledge repository670 configured to store data in the form of context-rich data clusters that have a logical structure that facilitates efficient access by any one of many data retrieval engines such as: data mining tools, relational databases, multi-dimensional databases, etc. Theuniversal knowledge repository670 may be configured to receive structured data from the context-rich mapping module660. The data stored in theuniversal knowledge repository670 may be accessed by other modules. Theuniversal knowledge repository670 may be any suitable software or hardware for data storage. In one embodiment, theuniversal knowledge repository670 is a database.
• The system may comprise asearch module690 configured to access theuniversal knowledge repository670 for a search directly or via a network. Thesearch module690 may be any tools or programs suitable for returning a set of search results by searching a database based on a user query request, including search engines provided by Google Inc., Microsoft or Verity.
• The system may comprise afilter module680 in connection with theuniversal knowledge repository670 and thesearch module690, all connected directly or via a network. Thefilter module680 is configured to interpret user preferences from a user message that indicates how to manage ambiguous data sets, and then provide the query syntax containing relevant variables for thesearch module690.
• The system may comprise aninteraction module692 in communication with theuniversal knowledge repository670 and thesearch module690, all connected directly or via a network. Theinteraction module692 is configured to interact with a user to narrow a search result returned by thesearch module690.
• The system may comprise a datarequest evaluation module694 configured to receive a user query and return a final search result to the user. The data requestevaluation module694 is configured to manage requests for access to and delivery of data stored in theuniversal knowledge repository670 by communicating to thefilter module680 and/or thesearch module690.
• The system may comprise anaccounting module640 configured to communicate with other modules in the system to track user activities such as data submission and for administrative purposes such as billing, credit, or reporting. The accounting module may be useful for, for example, applications where searching or data entry is a service for fee or where detailed user auditing is required.
• The system may be implemented in any suitable software or hardware. In an exemplary embodiment, the system may be implemented in one or more software applications. Each module may run on any suitable general purpose single- or multi-chip microprocessor, or any suitable special purpose microprocessor such as a digital signal processor, microcontroller, or a programmable gate array. The system may further comprise a memory for data storage. The processor may visit the memory, for example, in the process of performing any of the modules discussed here.
• FIG. 7 is an example illustrating the process of mapping unstructured data into a context-rich data structure. In the example, the unstructured data comes from a webpage including paragraphs, sentences, and source author. Many other instances or sources of the same phenomenon may be later incorporated in the parallel structure. The unstructured data is converted into a context-rich data structure by applying a series of processes with the help of at least one or more of the following: subject-specific template, language index, Webster's taxonomy, IEEE ontology, semantic web ontology, and a set of lists.
• FIG. 8 is an example of the subject-specific template. The template is divided into a set of field groups including, but not limited to, identification, subject, physical, observable, economic, and social. Each field includes a list of associated items describing the source or usage context of the field.
• FIG. 9 is an example illustrating the process of calculating a qualitative score for each entity based on all records associated with that entity. An entity can be anything that may influence the data, such as: source organization, source person, source device, etc. The table records the score of each past transaction indicating, for example, the completeness, integrity, and the popularity. Each transaction may have a unique record identification number and associated with one entity identification. The bottom of the scorecard summarizes the total score associated with a particular entity based on the score of all transactions associated with that entity.
• FIG. 10 is an example illustrating the process of calculating a qualitative score for each record based on all parameters included in that record. In the example, each record includes parameters A, B, C, . . . , G. A score is given in the table for each parameter. By simply adding the score for each parameter within a record, the score of the record is determined. It will be appreciated that other mathematical approaches may be taken to determine the score of a record based on scores for parameters of that record.
• FIG. 11 is an example illustrating the process of scoring each entry within a record. Each record includes a set of entries such as SOURCE, SYSTEM, DATA, or AUTHOR. The qualitative attributes such as A1-A3 associated with each entry is read and a score is calculated for each entry.
• FIG. 12 is an example illustrating a table which may be used in the process of mapping unstructured data into a context-rich data structure. Such a process will be described in further detail with regard toFIG. 19. The mapping table includes entries including Primary Source, Secondary Sources, Parallel Syntax, and Template Reference. Each entry may include multiple elements each of which has a corresponding confidence score (e.g., the qualitative score).
• FIG. 13 is an example of a user query message. The query message includes, for example, requestor identification code used to link the user to his personal profile and accounting log, template identification code, response identification code, query expression, source quality range or other quality preference variables, and render level preference.
• FIG. 14 is an example illustrating the process of retrieving data based upon user-designated quality parameters. In the example, user A restricts searches in his query to only the highest level of classification authority whose credentials are the highest scoring. However, user B is more interested in a broader scope and specifies in his query that a median value for all sources is preferred.
• FIG. 15 is a flowchart of one embodiment of a method of formatting unstructured data. The exemplary method may be performed, for example, by the parse unstructured data module as described inFIG. 6. Depending on the embodiment, certain steps of the method may be removed, merged together, or rearranged in order.
• In the exemplary method, a data stream is received and then parsed into one or more grammatical elements (e.g. word, sentence, paragraph, etc.), assigned a unique identification code and attributes as to what other elements it is a member of (e.g. a word is a member of a sentence, a paragraph and a page). Depending upon the origin of the data, other key field may be extracted such as: source, date, author, descriptive markup language (e.g. XML, HTML, SGML), etc. Each element is stored in a suitable memory structure together with associated links.
• The method starts at ablock1510, where an input data string or stream is parsed into one or more grammatical objects (e.g. word, sentence, paragraph, etc.). The input data string may be received, for example, from an external web crawler, a data stream such as RSS, or a conventional file transfer protocol. A reference to the location of each grammatical object within the data string is stored. A unique identification number is assigned to each object and stored in memory.
• Next at ablock1520, words within each grammatical object are looked up in the index to determine equivalents to one or more words. The equivalent may include, for example, synonym in the same language or a word or word group in a foreign language having equivalent meaning. In one example, English is used as the system reference language and the data being parsed is French. Each word is looked up in all foreign language indexes to determine the best translation and then a pointer to each language equivalent word is stored. In one embodiment, numbers, measures, and all other non-Grammatik objects are converted using the respective cultural indexes.
• Moving to ablock1530, each word is statistically analyzed to determine a probability score indicating how close the word is related to each subject matter field. A series of statistical routines are applied to each element parsed in the previous processes in order to calculate results that uniquely reflect the word positions and relative associations within the object. This result is then compared to an archive of subject matter specific templates that contain similar context-values of other known objects that belong to the subject field represented by the template. If the match results in a probability result over a certain threshold, a link is established in both the record of the object and in the template. The pointer to each word is then stored in at least one subject matter index.
• Next at ablock1540, a value is stored for each attribute within each object. The attributes of each object may include, e.g., source, author, date, time, location, version, security level, and user permissions. In one embodiment, not all attributes within an object have a value stored. One or more attributes may be left unassigned.
• Referring toFIG. 16, a flowchart of an embodiment of a process performed by the structureddata entry module620 shown inFIG. 6 will be described.FIGS. 6,8,9,10,11 and12 are also referred to in the discussion of the structureddata entry module620.
• Process620 begins at a start state and moves tostate1610 where a user logs on to the system (e.g.,server510,FIG. 5), registers a user profile and provides credentials if applicable. The qualitative process described below depends in part upon the quality of the credentials presented or recorded into the profile with regard to the source entity, data generation device or software, author, etc., and can include:
• • a. Measurement equipment brand, model, serial, specifications
  • b. Transaction data
  • c. Software package, version, routine
  • d. Information retrieved from an external source file/system, e.g., prices, inventory levels, sensor values.
• Proceeding tostate1615,process620 starts an accounting log. In some applications, data entry is a service for fee or where detailed user auditing is required. The Accounting module640 (FIG. 6) is responsible for tracking user activity and data submissions for later billing, credit or reporting. Continuing atstate1620, based upon the profile and credentials presented above, an access control subsystem sets user level, rights and permissions that regulate what type of data may be entered or edited, what can be seen and what related activities are provided. Advancing tostate1625,process620 looks up the user identification (ID) in the index to determine what actions are allowed. Based upon the profile, the system presents the user with a list of subject areas he or she is permitted to enter.
• Proceeding tostate1630,process620 generates a new record or copies/inherits from an existing record and, atstate1635, assigns a unique identification code to the record. Continuing atstate1640,process620 stores, in certain embodiments, the user ID, date, time and location for each data modification.
• Advancing tostate1645,process620 calls upon the Subject Template and Resource module630 (FIG. 6) to present the user with a data entry form derived from the subject specific template (e.g.,FIG. 8) selected above. Each field of the form may potentially discipline the user input to valid data ranges or other performance standards. The process continues by looking up each element of data entry in one or more topic structures such as ontologies, taxonomies or lists related to the selected template. The upper and lower tree elements for each word are retrieved and stored as a reference to the word along with an identification of what resource was used for the match. A Contextualization process then calculates results for the newly acquired subject terms. Each calculated context-value resulting from the foregoing processes is then compared to each field of the template in order to determine the probability of a match with previously analyzed objects of the same meaning. Templates are designed to capture a context-rich data structure and include such resources as:
• • source identity, location, file format and size
  • Higher, lower and equivalent subject classifications together with a reference to source
  • Observable records (e.g., photos, videos, radar signature, IR, temperature, etc.)
  • Physical measures (e.g., height, weight, depth, latitude, atomic mass, chemical structure, etc.)
  • Economic variables (e.g., price, stock, manufacturer names, retailer names).
    At the completion ofstate1645,process620 moves tostate1650 where an Internationalization process loads each word entered in the form, looks it up in all foreign language indexes to determine the best translation and then stores a pointer to each language equivalent word. Numbers, measures, and all other non-grammatic objects are converted using the respective cultural indexes.
• Proceeding tostate1655, processing moves to the Qualitative Assessment module650 (FIG. 6) where the recorded attributes are looked up in a table for each category in order to calculate a qualitative score. See alsoFIGS. 9-11. In an example, the source of the information in the object comes from a French government agency with a high score indicating that the source has been authenticated, the data is valid and previous experience has been of high quality. The score is returned for association with the element and the source table is updated.
• Proceeding tostate1660, processing continues at the Context-rich Mapping module660 (FIG. 6) that loads each word for every field in the current form being processed into the primary source record of a mapping table along with the associated qualitative scores. See alsoFIG. 12. This repeats for each subsequent word and/or element contained in the form. The module then proceeds to load contents into secondary source records if they exist at this time. Otherwise the module loads contents into parallel syntax records corresponding to each source field and organized by the relevant hierarchical location in the subject tree. For example, the first primary source word would be looked up in the first topic tree, retrieve the next highest term (along with the tree ID and quality attribute) and place it in the first parallel syntax record in a position associated with the first primary source word. Lastly, the module loads the calculated results from template analysis in the corresponding fields for each primary source element. At the completion ofstate1660,process620 ends at an end state.
• FIG. 17 is a flowchart of one embodiment of a method of linking a data object to one or more templates. The exemplary method may be performed, for example, by the subject template and resources module as described inFIG. 6. Depending on the embodiment, certain steps of the method may be removed, merged together, or rearranged in order.
• The method looks up each element of the parsed object in one or more topic structures such as ontologies, taxonomies or lists related to the selected template. An example of the template is illustrated inFIG. 8. The upper and lower tree elements for each word are retrieved and stored as a reference to the word along with an identification of what resource was used for the match. A contextualization process is run to calculate results for the newly acquired subject terms. Each calculated context-value resulting from the foregoing processes is then compared to each field of the template in order to determine the probability of a match with previously analyzed objects of the same meaning. In one embodiment, templates are designed to capture a context-rich data structure to include such resources as: a) source identity, location, file format and size; b) higher, lower and equivalent subject classifications together with a reference to source; c) observable records (e.g. photos, videos, radar signature, IR, temperature, etc.); d) physical measures (e.g. height, weight, depth, latitude, atomic mass, chemical structure etc.); and e) economic variables (e.g. price, stock, manufacturer names, retailer names).
• The method starts at ablock1710, where a first object is loaded. Next at ablock1720, each object is looked up in template index to identify one or more related templates. Moving to ablock1730, a reference link is established between an object and each related template. Next at ablock1740, the results fromblock1730 are compared to values stored in the index of subject templates.
• If a match is found at ablock1750, the method moves to ablock1760. At theblock1760, the associates are stored with both the template and the object before the method moves next to block1770. If no match is found atblock1750, the method jumps to block1770.
• Next atblock1770, statistical analysis of each object in relation to another object is performed. The analysis result is then stored in the index with pointers to the objects. As described earlier, each object could be, e.g., a word, a sentence, a paragraph, an article, and so on.
• Moving to ablock1780, mathematical analysis is performed of other objects in the associated template. Again, the analysis result is stored in the index with pointers to the objects. In one embodiment, pointers to templates are stored as parallel syntax for each object.
• Next at ablock1790, a word is looked up from the container in a semantic tree to retrieve upper and lower tree elements for storage or association with the word. The semantic tree could be, for example, several different ontologies or taxonomies.
• FIG. 18 is a flowchart of one embodiment of a method of evaluating the quality of a data object. The exemplary method may be performed, for example, by the qualitative assessment module as described inFIG. 6. Depending on the embodiment, certain steps of the method may be removed, merged together, or rearranged in order. The method of evaluating the quality of a data object is further illustrated earlier inFIGS. 9-11.
• In the method, the attributes recorded in the object are looked up in a table for each category in order to calculate a qualitative score. In one example, the source of the information in the object comes from a French government agency with a high score indicating that the source has been authenticated, the data is valid, and has been of high quality in past experience. The score is returned for association with the element and the source table is updated.
• The method starts ablock1820, where an object is loaded. Moving to ablock1830, the object is looked up in associated table. The table could be, for example, SOURCE, SYSTEM, DATA, or AUTHOR. Next at ablock1840, attributes associated with the object is read. In one embodiment, a mathematical function is applied to generate a score. In another embodiment, a stored score is retrieved.
• Last at ablock1850, the score/value associated with the object is returned. In one embodiment, the score/value indicates the quality of the data object.
• FIG. 19 is a flowchart of one embodiment of a method of adding contextual data to a data object. The exemplary method may be performed, for example, by the context-rich mapping module as described inFIG. 6. Depending on the embodiment, certain steps of the method may be removed, merged together, or rearranged in order.
• In this method, the first word of the first element of the current object is first loaded into the Primary Source record of a mapping table, such as the mapping table illustrated inFIG. 12, along with the associated qualitative scores. The same process is repeated for each subsequent word and/or element contained in the object. The foregoing fields are also loaded into Secondary Source records if such data exists at this time. Otherwise these fields are loaded into Parallel Syntax records corresponding to each Source field and organized by the relevant hierarchical location in the subject tree. Lastly, the calculated results from Template analysis are loaded in the corresponding fields for each Primary Source element.
• The method starts at ablock1910, where, for each object, source values of the object and of parallel syntaxes are analyzed to generate unique string values, which are indicative of a narrow meaning or concept. Each parallel syntax expresses a different level of abstraction from the primary source. In one example, it may be possible to have several source documents that appear to present conflicting information but following the process described here, the second highest parallel syntax might reveal that all the documents merely express the same idea in different terms. The concept strings are then stored in the index.
• Moving to ablock1920, a parallel syntax record is created for each object where each source word has parallel field entry.
• Moving to ablock1930, context-rich data clusters are created as concatenated strings of delimited values or references that group contextual data related to the object into logical structures. The logical structures may be, for example, a field, a record, a document, URLs, a file or a stream.
• Next at ablock1940, the context-rich data cluster may optionally be exported to a data exchange format (e.g., XML, HTML, RTF, DBF, PDF). In the data exchange format, reference links are retrieved together with page layout/rendering, attributes.
• FIG. 20 is a flowchart of one embodiment of a method of searching a database based on a user quest. The exemplary method may be performed, for example, by the data request evaluation module as described inFIG. 6. Depending on the embodiment, certain steps of the method may be removed, merged together, or rearranged in order.
• The method starts at ablock2010, where a user query message is received and loaded. The user query message may be in various formats. In the exemplary embodiment, the message is in the format of the request message illustrated inFIG. 13.
• Moving to ablock2020, message fields are parsed according to the message format and stored in a registry.
• Next at ablock2030, each parsed field is loaded and a lookup is performed in the profile database. In the profile database, a requestor identification number is linked to an authorized person or entity. Based on the requestor identification number provided in the user query message, parameters related to a particular use may be determined, such as security level, render level preference, permissions, and billing rate. The render level preference indicates the depth or robustness of information desired for the application. Depending upon the user permissions and render level preference, a query reply may contain several words or several terabytes.
• In another embodiment, the parsed message may further comprise one or more of the following: a template identification code, a response identification, a query expression, a set of source quality parameters. The template identification code indicates if the search query is to be directed to a specific element of a subject-matter specific template. The response identification refers to specific information needed to send a reply to the requesting party. The query expression may be any one of many query syntaxes in use such as SQL. The set of source quality parameters indicates how the raw data will be filtered prior to conducting the query so as to conform with the requesting party's qualitative restrictions. The qualitative restrictions may pertain to, for example, source, author, data, system, etc.
• One example is illustrated earlier inFIG. 14. In that example, one user might restrict searches to only the highest level of classification authority whose credentials are the highest scoring while another user might be more interested in a broader scope and request that a median value for all sources is preferred.
• Moving to ablock2040, the template identification code is looked up if it is provided in the user query message. A template corresponding to the template identification code is then retrieved.
• Next at ablock2050, certain user variables (e.g., source quality) are loaded into the query filter.
• Moving to ablock2060, the user query message and filter variables are sent to a search module such as thesearch module690 as described earlier inFIG. 6. The search module may be any tools or programs suitable for returning a set of search results by searching a database based on a user query request, including the search engine provided by Google Inc.
• Next at ablock2070, search results are received from the search module. In one embodiment, a determination is made as to whether the received search results reflect two or more plausible search paths matching different subject templates.
• Moving to ablock2080, the user query and its results are logged into the requestor's profile and the template profile for tracking.
• Next at ablock2090, the results are forwarded to the user in accordance with the user's preferences. In some cases, additional user input is required in order to further refine the search result to a single subject area.
• FIG. 21 is a flowchart of one embodiment of a method of generating query syntax based on a user query message. The exemplary method may be performed, for example, by the filter module as described inFIG. 6. Depending on the embodiment, certain steps of the method may be removed, merged together, or rearranged in order. In one embodiment, the query syntax is then sent to a search module as input for a search operation.
• The method starts at ablock2110, where one or more user filter parameters are received from a parsed user query message. Next at ablock2120, a table may be created for storing each filter parameter. Moving to ablock2130, each filter parameter value is looked up in the parameter index to determine proper query syntax in order to achieve the desired search result. Next at ablock2140, the syntax message is passed to the search module as described inFIG. 6.
• FIG. 22 is a flowchart of one embodiment of a method of interacting with a user to narrow a search result. The exemplary method may be performed, for example, by the interaction module as described inFIG. 6. Depending on the embodiment, certain steps of the method may be removed, merged together, or rearranged in order.
• The method starts at ablock2210, where a query reply including a search result is received from a search module (e.g., thesearch module690 inFIG. 6). Next at ablock2220, the result is parsed to determine the number and quality of the subject trees.
• Moving to ablock2230, it is determined whether there are less than two subject trees. If the answer atblock2230 is yes, the method moves to ablock2280. If the answer atblock2230 is no, the method then moves to ablock2240.
• Next atblock2240, the user profiler associated with the user issuing this query and templates are evaluated to determine which subject trees have the highest probability of satisfying the user query. Moving to ablock2250, a message is sent to the user requesting him to select one of the trees representing a path, for example, which is most likely to narrow the search result. Next at ablock2260, a reply is received from the user and a new search query is generated based on the current user query and the user reply. Moving to ablock2270, the new query is sent to the search module and the method moves back toblock2220.
• Atblock2280, it is determined whether the matches in the search result exceed a user-defined preference. If the answer atblock2280 is yes, the method goes back toblock2220. Otherwise, the method moves to ablock2290.
• Atblock2290, a final search result is forwarded to the user. The final search result may be narrower than the original search result included in the query reply from the search module.
• Next at ablock2292, information related to the current search is stored in user profile and subject matter profile for future reference.
Application Example
• One example embodiment of the system would be the creation of a comprehensive, industry-wide database with full transparency. One of the main inhibitors to free trade is the imperfect availability of real-time commerce information. Referring to the domestic grocery industry as an example, many participants up and down the value chain from consumer to manufacturer make daily decisions with impartial information. A consumer who wants to purchase a list of products at the lowest possible price can rarely afford to comparison shop every product on the list. The industry exploits this fact by running promotions on certain products to draw a consumer in the door on the expectation of making up the difference with higher margins on other products.
• All parties stand to gain if this system were implemented. To illustrate the point, this discussion focuses on the consumer-retailer benefits, but it will become apparent that it is equally applicable to other value chain participants as well. A service provider operating the system400 (FIG. 4) would contact all retailers in a given region and notify them of the opportunity to make their product information directly accessible to the public in order to facilitate their shopping needs. Five retailers decide to participate and arrange to have theirproprietary databases429 connect via a network to theinput management system420. As each provider has previously registered with the service provider, they connect to the structured data entry module620 (FIG. 6) where the system authenticates the connection and logs them into theaccounting module640 where they may be assessed a fee for using the system. As each retailer has its own proprietary system, thesubject template module630 retrieves both a template for each retailer and a template for each product group contained in the retailer's database. Products may be stored with different formats in different fields and spelled or described in different ways. Moreover, stock level and pricing may be expressed in incompatible ways. The retailer specific template directs the system into how to parse the proprietary information, and a product template similar toFIG. 8 aids the system in classification and linkage to contextual records, like manufacturer resources (recipes, photos promotions), government warnings or recent news articles about the product. Thequalitative assessment module650 evaluates each data entry for quality and records scores for the retailer, its computer system and software and the operator in charge, as outlined inFIGS. 9,10 and11. Finally, the context-rich mapping module660 maps each data element using a method similar to that shown inFIG. 12 where each primary element is assigned one or more parallel records that reflect duplicate information or semantic equivalents as determined from external resources similar to that shown inFIG. 7.
• The end result of the above process is a real-time knowledge repository that provides consumers with near perfect insight into what products are available on the best terms from a retailer. Moreover, the context-rich mapping and subject specific template has created associations for each product record so that consumers can instantly see which retailer is the best for their specific shopping list taking in consideration special offers from related parties, available stock, and other incentives.
• A consumer might access thesystem400 shown inFIG. 4 via apublic search engine436 like Google. An example search for ‘peanut butter’ (seeFIG. 13) might take the consumer to the data request evaluation module694 (FIG. 6) where a cookie in her browser would trigger heruser account640 and her preference for restricting searches to high-authority data sources within her zip of 92109 similar to that shown inFIG. 14. The user preferences would be forwarded to thefilter module680, combined with the search query and passed to thesearch module690. The resulting matches would contain more than one category and pass the interaction module692 a user question to choose from ‘peanut spread’ or ‘peanut butter cookies’ or ‘peanut butter ice cream’. The user's response would then be forwarded back to the search module and the final result returned to the user.
CONCLUSION
• The foregoing description details certain embodiments of the invention. It will be appreciated, however, that no matter how detailed the foregoing appears in text, the invention may be practiced in many ways. It should be noted that the use of particular terminology when describing certain features or aspects of the invention should not be taken to imply that the terminology is being re-defined herein to be restricted to including any specific characteristics of the features or aspects of the invention with which that terminology is associated.
• While the above detailed description has shown, described, and pointed out novel features of the invention as applied to various embodiments, it will be understood that various omissions, substitutions, and changes in the form and details of the device or process illustrated may be made by those skilled in the technology without departing from the spirit of the invention. The scope of the invention is indicated by the appended claims rather than by the foregoing description. All changes which come within the meaning and range of equivalency of the claims are to be embraced within their scope.

Claims (14)

1. A computer-implemented method of processing records in a database, the method comprising:

a) calculating, by a processor, a source quality for each source in the database based on records associated with the source;

b) applying, by a processor, user preferences corresponding with a user request to search the database, wherein the user request comprises a source quality range, and a query expression; and

c) determining, by a processor, the records in the database that satisfy the user request, wherein the determined records match the source quality range.

2. The method ofclaim 1, additionally comprising storing the process of acts a), b) and c) for later reference.

3. The method ofclaim 1, wherein the user request further comprises a template identification code, wherein a search identified by the query expression is directed to a specific element of a subject-matter specific template represented by the template identification code.

4. The method ofclaim 1, wherein the user request further comprises a render level preference indicating the depth of information desired by the user request.

5. The method ofclaim 1, wherein the source quality comprises scores representing completeness, integrity and popularity, and wherein the source quality is periodically updated as new records are added into the database.

6. The method ofclaim 5, wherein popularity comprises preference associated with an object by a plurality of sources.

7. The method ofclaim 5, wherein popularity comprises preference associated with a phenomenon by a plurality of sources.

8. The method ofclaim 1, wherein the user request further comprises at least one of the following: an authentication and permissions.

9. The method ofclaim 1, additionally comprising calculating an author quality for each author in the database.

10. The method ofclaim 9, wherein the user request comprises qualitative restrictions for an author.

11. A computer-implemented system for processing records in a database, the system comprising:

means, operable on a processor, for calculating a source quality for each source in the database based on records associated with the source;

means, operable on a processor, for applying user preferences corresponding with a user request to search the database, wherein the user request comprises a source quality range, and a query expression; and

means, operable on a processor, for determining the records in the database that satisfy the user request, wherein the determined records match the source quality range.

12. A computer-implemented system for processing records in a database, the system comprising:

a memory; and

a processor configured to:

calculate a source quality for each source in the database based on records associated with the source;

apply user preferences corresponding with a user request to search the database, wherein the user request comprises a source quality range, and a query expression; and

determine the records in the database that satisfy the user request, wherein the determined records match the source quality range.

13. A computer-implemented method of processing records in a database, the method comprising:

a) evaluating, by a processor, all records in the database that are associated with a same phenomenon or object;

b) applying, by a processor, user preferences corresponding with a user request; and

c) determining, by a processor, the records in the database that satisfy the user request.

14. The method ofclaim 13, additionally comprising storing the process of acts a), b) and c) for later reference.

Images