Source: http://www.google.de/patents/US20040143588?hl=de
Timestamp: 2013-05-21 22:37:30
Document Index: 388979504

Matched Legal Cases: ['art 700', 'art 700', 'art 700', 'art 800', 'art 800', 'art 800', 'art 800']

Patent US20040143588 - Database model system and method - Google PatenteSuche Bilder Maps Play YouTube News Gmail Drive Mehr » Erweiterte Patentsuche | Webprotokoll | Anmelden Erweiterte Patentsuche PatenteA database model system and method are provided that permit changes to the data model, such as the addition, deletion, or modification of attributes, through changes to the data rather than to the fundamental data model schema. A method of structuring a database comprises providing a category table,...http://www.google.de/patents/US20040143588?utm_source=gb-gplus-sharePatent US20040143588 - Database model system and method Ver�ffentlichungsnummerUS20040143588 A1PublikationstypAnmeldung Ver�ffentlichungsdatum22. Juli 2004Eingetragen29. Dez. 2003 Priorit�tsdatum31. Aug. 2000Auch ver�ffentlicht unterUS6694490US6990640US20040010760US20040090848 Ver�ffentlichungsnummerUS 2004/0143588 A1US2004/0143588A1 ErfinderNorman RussellUrspr�nglich Bevollm�chtigterRussell Norman Robert US-Klassifikation1/1707/999.1Internationale KlassifikationG11C7/00H01L27/10G11C5/00G06F17/50G06F12/06G11C29/00G06F7/00 UnternehmensklassifikationG11C5/04G11C29/88 Europ�ische KlassifikationG11C 5/04Referenzen Referenziert von (8)Externe LinksUSPTO USPTO-Zuordnung EspacenetDatabase model system and methodUS 20040143588 A1 Zusammenfassung A database model system and method are provided that permit changes to the data model, such as the addition, deletion, or modification of attributes, through changes to the data rather than to the fundamental data model schema. A method of structuring a database comprises providing a category table, a content table containing content corresponding to categories in the category table, and a category contents table containing a mapping scheme that maps content contained in the content table to categories in the category table. An attributes table containing attributes for an application utilizing the database and an attributes values table containing values corresponding to attributes in the attributes table are also provided. Zeichnungen(22) Anspr�che
[0059] Content types table 438 describes the type of content stored by contents table 432. For example, a text document, an image, and a manual would be type classified as .doc, GIF, and .PDF, respectively. Contents table 432 comprises any content that describes or supports a product, category, or subject, with the actual content located in content values table 424. Thus, content table 432 defines a placeholder for the content but does not actually store the content. [0060] In some implementations (e.g., Oracle 8.0), this technique improves the speed of searching and retrieving data from the database. There should be a one-to-one relationship between contents table 432 and content values table 424. Content, for example, may include documents, images, lists, spreadsheets, drawings, manuals, video, or audio. Content properties such as name or description are represented in the relationship of content table 432 to attribute values table 402. Content is classified into the appropriate product, category, and/or subject categories by the relationship of contents table 432 to category contents table 404. [0061] Content relationships table 408 describes the relationship among contents. For example, a document may be comprised of multiple pieces of content (i.e., chunked), which may include images or common paragraphs shared by other documents. Content relationship types table 416 defines how or why content is related to another piece of content. For example, content may be converted from existing content (e.g., text document converted to HTML). This type may be defined as converted. Another example would be a logo that is associated with several pieces of content (e.g., HP logo used in various documents). This type may be defined as chunked. [0062] Category contents table 404 maps a piece of content to its proper location or locations in the category (e.g., product or subject) index and defines relationships between categories and content. For example, a document that describes how to ensure that a telephone line is properly inserted into a facsimile machine may be located in various product hierarchy locations such as shown below (see also description in reference to FIG. 3c. for an exemplary hierarchical relationship). [0063] Parameter names table 418 defines the name of a parameter based on a specified parameter type and may also be defined for a specified language. Application parameter types table 426 is used to group parameter types such as hypertext markup language (HTML) errors, HTML constants, and system constants. Parameter values table 410 defines a value for the parameter that is named by parameter names table 418. Examples of parameter names and values are shown below. [0064] Application areas table 440 is used to define areas (e.g., content, categories, templates, or template methods) of an application utilizing database model 400 that may be referenced by database model 400. Attributes table 442 describes the attributes, within the limits set forth in application areas table 440, that can be defined for an application utilizing database model 400. For example, attributes may include access control lists, display, language, release date, and author. Attribute areas table 434 defines the area of an application utilizing database model 400 that is allowed to use each attribute. For example, a language attribute would apply to areas including content, categories, and templates, while an operating system attribute would apply only to the content area. Attribute pre-defined value table 428 holds all pre-defined enumerated values for a specified attribute, because an attribute or attribute area may have one or more values pre-defined in an enumerated list. [0065] Attribute values table 402 contains values assigned to the attributes specified for the related tables via a foreign key. A value is assigned to the attribute and specified as either a category, category type, content, content type, category content, parameter name, or template. The value may come from a pre-defined list (i.e., attribute pre-defined value table 428) or be user-defined (one of the value attributes). Various database rules may be required regarding attribute values (e.g., see Appendix B). [0066] The content for database model 400 may be displayed using templates to construct the web pages. In general, the templates are generated and represent the intended layout of a desired page type. After the layout has been drafted using any HTML authoring tool, the dynamic content of the page is identified and substituted by CDS specific tags which allow access to the database and provide control mechanisms. When a page is generated, the HTML generator finds these specific tags and replaces them with content from the database. Appendix G provides further details of the dynamic HTML template interpreter. [0067] Template types table 420 defines a category for a presentation template. Examples of template types are content template, category template, standard error template, and navigation template. Templates table 412 defines the template (i.e., name of the template and the template source) that is used to define how content and product/subject categories are presented. For example, when a product category/index or a product content (e.g., documents) is presented on the World Wide Web (WWW), a template is used to define how this information is formatted for presentation and may also be used to define what information is presented. [0068] Presentation methods table 406 defines the template(s) used to display a piece of content or category. A piece of content or category may have many templates defined for it, but based on pre-defined criteria, only one of the templates will be used to present the content or category. Attributes associated with the presentation method are used to resolve the ambiguity as to what template to use when presenting a content or a category that has two or more templates. For example, a support document for changing a toner cartridge may be presented a certain way for commercial users and in a different way for home users. Therefore, a presentation template must be associated to the content for each presentation method. The presentation method used for a template (e.g., commercial or home user) can be determined by the relationship of the presentation methods table 406 to attribute values table 402. Presentation methods may have any number of pre-defined attributes associated with them. [0069]FIG. 5 is a block diagram of a computer system 500 for an exemplary network application utilizing the database model of FIG. 4. Computer system 500 comprises a plurality of user terminals 502 that access a web server 506 through a network 504, such as the Internet. A firewall 508 provides security and isolation through which web server 506 communicates with a database server 510. Database server 510 is connected to a database 512 utilizing database model 400. Database server 510 is also connected to one or more administrator terminals 514 and various other computers 516, 518, 520 that may comprise servers or computer systems that provide various services or information for database server 510. [0070] A user may access various content or information by utilizing user terminal 502, which may include a desktop computer, a laptop computer, a personal digital assistant, or a telephone such as a cellular telephone with a display. For example, user terminal 502 may employ a web browser to communicate through network 504. Web server 506 comprises an HP-UX 11 operating system, an Oracle application server 4.0, an Oracle application server's spyglass listener for use as the web listener, and Net 8 for communication with database 512. The Oracle application server is responsible for spawning off server applications to support the Internet publishing architecture application, such as an HTML template interpreter that communicates with database 512 using Net 8. The template interpreter is a cartridge of the Oracle application server and is responsible for preparing and presenting content to users, typically by the use of templates, as described in greater detail below in reference to FIG. 6. Also, note that the names Oracle and HP, along with various related products listed herein, are registered Trademarks of Oracle Corporation of Redwood Shores, Calif., and Hewlett Packard of Palo Alto, Calif., respectively. [0071] Database server 510 hosts an HP-UX 11 operating system, an Oracle 8.0.5 database management system, and Net 8.0 for communication with server 506 (e.g., Web Server and Oracle Application Server) through firewall 508. One or more administrator terminals 514 allow for the maintenance of the product and navigation information along with other components of computer system 500. Computer 516 provides new or updated content and computer 518 uses an application such as DeltaLoader to extract the content from computer 516 and load the information into database 512 through database server 510. Computer system 500 may also use one or more remote terminals such as computer 520 to provide required product information such as product name, series, family, and ID. For more detailed information for computer system 500, such as multi-language support, please refer to Appendix A. [0072] Data maintained in database 512 includes templates, structured data, and unstructured data. In general, a template will be required to display data (e.g., structured or unstructured) to a user. FIG. 6 is an exemplary template 600 for displaying content by utilizing the database model of FIG. 4. Template 600 illustrates the principle of nesting templates within templates so that templates can be designed with modularity and re-use in mind. [0073] Template 600 comprises a top banner template 602, a navigation template 604, a bottom banner template 606, along with content 608. Top banner template 602 displays top banner content including the HP logo. Navigation template 604 displays navigation content, while bottom banner template 606 displays bottom banner content. Content 608 displays the content for template 600, which in this case is an exemplary support document on print quality troubleshooting. For example, the exemplary Internet publishing architecture, utilizing computer system 500 and the data and table structure of database model 400, may serve all content and navigation pages dynamically through the use of templates to provide web pages with the requested content to a user through the network. The requests may also be directed to static/dynamic HTML pages or to images or other multi-media items such as portable document format (PDF) files. The process of generating a web page using a template is described in detail in Appendix G. [0074]FIG. 7 is a flowchart 700 for an exemplary data model table structure, in accordance with some embodiments of the present invention. Flowchart 700 provides the basic steps for creating a database model that provides a basic, generic structure of exemplary table structure 200 of FIG. 2a. Step 702 creates a data objects table that includes attributes that generally are unlikely to be changed and specific instances of these attributes. Step 704 creates an attributes table that includes properties regarding attributes in the data objects table of step 702. Step 706 creates an attributes value table that includes the actual values of the properties for the specified attributes corresponding to certain specific instances of the attributes. Therefore, flowchart 700 provides a generic, flexible, and expandable database model applicable to many types of database applications. [0075]FIG. 8 is a flowchart 800 for an exemplary data model table structure, in accordance with some embodiments of the present invention. Flowchart 800 provides the basic steps for creating a database model that provides a basic, generic structure of exemplary table structure 300 of FIG. 3a. Step 802 creates a categories table that includes categories for the subject matter of the database. Step 804 creates a contents table that contains any content necessary to describe or support a category in the categories table of step 802. Step 806 creates a category contents table that provides a mapping scheme that maps a portion of content from the contents table of step 804 to its place in the category index corresponding to the categories table of step 802. Step 808 creates an attributes table that includes all attributes defined for the database. Step 810 creates an attributes values table that includes values assigned to an attribute specified through one of the related tables of flowchart 800. Step 812 creates a category relationships table 812, which may be optional, that describes how categories relate to each other along with corresponding relationship rules. Therefore, flowchart 800 provides a generic, flexible, and expandable database model applicable to many types of database applications. [0076] It should be understood from the description herein that the database model system and method in accordance with an embodiment of the present invention provides many advantages over traditional database modeling schemes. The database model system and method, for example, provides flexibility and the ability to change or modify aspects of the data model by the modification of data rather than through fundamental data model schema changes. The database model may be incorporated into a computer system, for example, to deliver web pages to users on the computer network (e.g., WWW users on the Internet). For example, these web pages may be product pages, navigation pages, or pages with support documents, with requests made by users via a uniform resource locator (URL) using a hypertext transfer protocol (HTTP). This is but one example of the use of the database model and does not limit the application scope as the database model is useful for any type of database modeling and has application identical to or beyond that of the traditional data model. [0077] Embodiments described above illustrate but do not limit the invention. It should also be understood that numerous modifications and variations are possible in accordance with the principles of the present invention. For example, while categories of HP products were illustrated in an exemplary embodiment, the present invention is not limited to this type of embodiment and it should be understood that any type of data may be modeled. Accordingly, the scope of the invention is defined only by the following claims. Referenziert von Zitiert von PatentEingetragen Ver�ffentlichungsdatum Antragsteller TitelUS752312011. M�rz 200521. Apr. 2009Fuji Xerox Co., Ltd.Recording medium in which document management program is stored, document management method, and document management apparatusUS759064727. Mai 200515. Sept. 2009Rage Frameworks, IncMethod for extracting, interpreting and standardizing tabular data from unstructured documentsUS773001730. M�rz 20071. Juni 2010Google Inc.Open profile content identificationUS78665428. Juni 200611. Jan. 2011International Business Machines CorporationSystem and method for resolving identities that are indefinitely resolvableUS832146230. M�rz 200727. Nov. 2012Google Inc.Custodian based content identificationUS834116918. M�rz 201025. Dez. 2012Google Inc.Open profile content identificationUS2010012830226. Nov. 200827. Mai 2010Xerox CorporationException page programming for banner sheetsWO2008121989A131. M�rz 20089. Okt. 2008Annau, Thomas M.Related entity content identificationDrehenOriginalbildGoogle-Startseite - Sitemap - USPTO-Bulk-Downloads - Datenschutzerkl�rung - Nutzungsbedingungen - �ber Google Patente - Feedback gebenDaten bereitgestellt von IFI CLAIMS Patent Services.© 2012 Google