227 results about "Database design" patented technology

A system and method lets a user create or import ontologies and create databases and related application software. These databases can be specially tuned to suit a particular need, and each comes with the same error-detection rules to keep the data clean. Such databases may be searched based on meaning, rather than on words-that-begin-with-something. And multiple databases, if generated from the same basic ontology can communicate with each other without any additional effort. Ontology management and generation tools enable enterprises to create databases that use ontologies to improve data integration, maintainability, quality, and flexibility. Only the relevant aspects of the ontology are targeted, extracting out a sub-model that has the power of the full ontology restricted to objects of interest for the application domain. To increase performance and add desired database characteristics, this sub-model is translated into a database system. Java-based object-oriented and relational application program interfaces (APIs) are then generated from this translation, providing application developers with an API that exactly reflects the entity types and relations (classes and methods) that are represented by the database. This generation approach essentially turns the ontology into a set of integrated and efficient databases.

A method and system for maintaining medical items is provided. The system includes a medical database structure, a medical database utility configured to maintain medical database contents by organizing medical information into levels, and a user interface component configured to enable a user to access the medical database utility. The medical database utility provides a user with an ability to access the user's collections of settings in the medical database, the user's collection of settings maintained separately from settings accessible by other users. The method stores medical data items in a database configured with multiple levels of organization, establishes a logical relationship between medical data items at each level of organization, presents a user with available medical system choices at each level of organization, and enables the user to select from among the available medical system choices presented at each level of organization.

An automated physical database design tool may provide an integrated physical design recommendation for horizontal partitioning, indexes and indexed views, all three features being tuned together (in concert). Manageability requirements may be specified when optimizing for performance. User-specified configuration may enable the specification of a partial physical design without materialization of the physical design. The tuning process may be performed for a production server but may be conducted substantially on a test server. Secondary indexes may be suggested for XML columns. Tuning of a database may be invoked by any owner of a database. Usage of objects may be evaluated and a recommendation for dropping unused objects may be issued. Reports may be provided concerning the count and percentage of queries in the workload that reference a particular database, and / or the count and percentage of queries in the workload that reference a particular table or column. A feature may be provided whereby a weight may be associated with each statement in the workload, enabling relative importance of particular statements to be specified. An in-row length for a column may be specified. If a value for the column exceeds the specified in-row length for that column, the portion of the value not exceeding the specified in-row length may be stored in the row while the portion of the value exceeding the specified in-row length may be stored in an overflow area. Rebuild and reorganization recommendations may be generated.

An authoring tool (or process) to facilitate the performance of an annotation function and an indexing function. The annotation function may generate informational annotations and word annotations to a database design schema (e.g., an entity-relationship diagram or “ERD”). The indexing function may analyze the words of the annotations by classifying the words in accordance with a concordance and dictionary, and assign a normalized weight to each word of each of the annotations based on the classification(s) of the word(s) of the annotation. A query translator (or query translation process) to (i) accept a natural language query from a user interface process, (ii) convert the natural language query to a formal command query (e.g., an SQL query) using the indexed annotations generated by the authoring tool and the database design schema, and (iii) present the formal command query to a database management process for interrogating the relational database.

An authoring tool (or process) to facilitate the performance of an annotation function and an indexing function. The annotation function may generate informational annotations and word annotations to a database design schema (e.g., an entity-relationship diagram or “ERD”). The indexing function may analyze the words of the annotations by classifying the words in accordance with a concordance and dictionary, and assign a normalized weight to each word of each of the annotations based on the classification(s) of the word(s) of the annotation. A query translator (or query translation process) to (i) accept a natural language query from a user interface process, (ii) convert the natural language query to a formal command query (e.g., an SQL query) using the indexed annotations generated by the authoring tool and the database design schema, and (iii) present the formal command query to a database management process for interrogating the relational database.

An authoring tool (or process) to facilitate the performance of an annotation function and an indexing function. The annotation function may generate informational annotations and word annotations to a database design schema (e.g., an entity-relationship diagram or “ERD”). The indexing function may analyze the words of the annotations by classifying the words in accordance with a concordance and dictionary, and assign a normalized weight to each word of each of the annotations based on the classification(s) of the word(s) of the annotation. A query translator (or query translation process) to (i) accept a natural language query from a user interface process, (ii) convert the natural language query to a formal command query (e.g., an SQL query) using the indexed annotations generated by the authoring tool and the database design schema, and (iii) present the formal command query to a database management process for interrogating the relational database.

An authoring tool (or process) to facilitate the performance of an annotation function and an indexing function. The annotation function may generate informational annotations and word annotations to a database design schema (e.g., an entity-relationship diagram or “ERD”). The indexing function may analyze the words of the annotations by classifying the words in accordance with a concordance and dictionary, and assign a normalized weight to each word of each of the annotations based on the classification(s) of the word(s) of the annotation.A query translator (or query translation process) to (i) accept a natural language query from a user interface process, (ii) convert the natural language query to a formal command query (e.g., an SQL query) using the indexed annotations generated by the authoring tool and the database design schema, and (iii) present the formal command query to a database management process for interrogating the relational database.

The invention relates to a method for migrating data from a non-relational database to a relational database. The method comprises the following steps: connecting the non-relational database needing data migration, and obtaining table information in the database; selecting a table needing data migration and a database mode definition method, wherein the selectable database mode definition method comprises user definition, union set compatibility, intersection compatibility, and first article data; guiding the information from the non-relational database to a defined xml document; converting the database design mode of the non-relational database to a design mode of the corresponding relational database; connecting the corresponding relational database, and setting up a corresponding data table according to the database design mode in the xml document; setting up a corresponding index according to index information in the index element. The method for migrating data solves the problems of a denormalization design, non-modeling and special data types when data are migrated from the non-relational database (such as a MonogDB) to the relational database.

A computer implemented data processor system automatically disambiguates a contextual meaning of natural language symbols to enable precise meanings to be stored for later retrieval from a natural language database, so that natural language database design is automatic, to enable flexible and efficient natural language interfaces to computers, household appliances and hand-held devices.

Internal communications within components of an automated physical database design tool may be conducted in a data description language such as XML. Inputs to and outputs from the automated physical database design tool may also be presented in the data description language (e.g., XML). The communications, inputs and outputs may comply with a schema for the data description language. The schema may be written in a schema language such as XSD. Inputs presented in the data description language may comprise tuning options. Outputs may comprise a proposed physical design for a database and reports.

A method, apparatus, and computer instructions for selecting and recommending of clustering indexes are provided. Baseline run time cost estimates are calculated based on database designs. Workload benefit of a candidate clustering design is calculated and compared to the baseline costs. If the workload benefit outweighs the baseline costs, clustering dimension solutions originated from the record identifier (RID) based index are identified. A clustering design is selected based on the identified clustering dimension solutions and the total number of recommended clustering dimensions for a given table. Based on the number of dimensions observed, either a multidimensional clustering solution or a RID based clustering index is recommended.

The invention discloses a code generation method and device based on a maven plug-in and a freemarker template. The method comprises the steps that data and the template are prepared, namely, .hbm.xml files are written or generated according to a data base design file or a data base table, and the template is written according to the characteristics of items and freemarker template grammar; the maven plug-in is called to carry out the logical operation to generate codes, namely, the maven plug-in which encapsulates arithmetic logic generated by the codes is called, and logic operation and code generation are carried out according to the .hbm.xml files prepared in the first step and freemarker template files; the codes are generated, namely, macro is applied to the code template to generate a target code of an MVC three-layer structure. The code generation method and device based on the maven plug-in and the freemarker template solve the problem that duplicated codes are automatically generated in the developing process, and can be customized under the actual condition according to the template and improve production efficiency; because automatic code generation and a common construction tool maven are bound, the universality and the usability of the device are improved.

A method for evaluating a lightning / HIRF protection effectiveness of a vehicle design is provided. The method is performed using a computer system coupled to a database. The method includes storing in the database design service life goals and critical characteristics for at least one lightning / HIRF protection component. The method also includes storing in the database a potential for degradation of the at least one component. The potential for degradation is based at least partially on a position where the component is to be installed. The method also includes determining continued functionality of the at least one component using the computer system to compare the vehicle design to the stored design service life goals.

A method of marketing goods and / or services using discount purchasing incentives. The method provides customized discount coupon cards, books, or similar media, designed and arranged to carry and display a list of participating vendors, the cards containing a number of opportunities to redeem or otherwise utilize the designated discount at each respective vendor's place of business, or website. A graphical user interface and plurality of coupon carrying media support the ability of a consumer to personally customize any number of discounted purchase offers by choosing from a list of categories and sub-categories of manufacturer or retailer discount offers displayed on a network, such as the world wide web. After selecting offers that have been posted by local or national merchants, the specific discount information may be transmitted to an offer database, whereupon customized discount coupon cards, books, or other offer carrying media may be created for distribution to the consumer. Each customized card, or book etc., may be designed to display the specific offers chosen by the consumer and is transmitted to an in-house or outsourced printer, or encoder, for creation. The consumer's choices, geographic location, and other demographic information may be stored in a selections database designed to transmit the coupon utilization and ultimate sales information back to the manufacturers and retailers that provided the original discount offers.

This invention discloses a method and a system for realizing matched ring-back sound service including the following steps: a management node stores the designed information including a calling ring-back sound, a called ring-back sound and its priority in a database assigned by a user, when a call request appears between a first user and a second user, a second node restrains the traditional sound and sends an IAM message attached with the calling and called numbers to a service function unit, which picks up the numbers and inquires the database designed by the user to get the information should be played after receiving the IAM message, the database utilizes said numbers to determine the index number should be played to search it to be played to the calling user.

A database design modeling system for managing data facets for design scenarios as a collection of hierarchical unitized data alternatives is provided. The database design model allows for easy access to data while providing a single persistant location for any one specific data record, thereby reducing any problems associated with conventional data duplication. Further, all data stored within the database is unitized thus eliminating the need for the user to do the unit mapping. According to one aspect of the present invention, a Relational Database Management System (RDBMS) modeling system can be constructed that allows for exercising multiple “What if?” scenarios with minimal user intervention and errors by 1) storing data using a normalized hierarchical storage structure, 2) providing data address indirection means to access data available from a multitude of data sources, 3) providing an object model to leverage programmable support to the orthogonal data views, and 4) providing a GIS client user interface allowing the user to construct a scenario and to view scenario results.

A computer implemented data processor system automatically disambiguates a contextual meaning of natural language symbols to enable precise meanings to be stored for later retrieval from a natural language database, so that natural language database design is automatic, to enable flexible and efficient natural language interfaces to computers, household appliances and hand-held devices.

A process is disclosed for using the computer for physical database design, which is based on transaction workload, and minimizes the cost of retrieval and modification for a set of transactions on a database.

Provided is a visual modeling platform based on unified constraint of normal data elements. The platform comprises a data exchange layer for the modeling platform to transmit data, a model layer undergoing unified constraint and application of the normal data elements, an operation control layer for executing model construction, model maintenance, model storage, model loading and model instantiation and a view layer for visually displaying model elements in the data elements. The platform can generate a data model based on a target database management system, can establish an application model for an application program and can perform unified management of various data sources of a large system. The platform can support various hardware environments, is compatible with various operating systems and supports database design tools of various target database management systems.

The invention relates to strip mine's slope beside hill optimization. It belongs to strip mine's slope beside hill engineering technology field. Its steps are: build GIS data module; build side slope stabilization three dimension limit balance analysis module based GIS; realize arithmetic of three dimension module based on GIS and side slope optimization. Adopting GIS space analysis function, engineering geology, geography condition and hydrogeology information relative to side slope stabilization is presented into data structure, database design, space data analysis method etc. in GIS data model. Information relative to side slope of stratum, structure face, water table etc are presented through GIS data layer. All input data are converted in form of grid. The data are ground height, vergence direction, tile angle, ground water, ground floor, slip surface and physical mechanics parameters of space distribution. Each three dimension grid column unit can descript a kind of geography information relative to stabilization analysis of ground, stratum, slip surface etc. Adopting the invention, side slope can be optimized to reduce amount of ripping rock and production shell-exploit rate.

The invention provides an on-line monitoring system of a transformer winding. The on-line monitoring system of the transformer winding is used for accomplishing 24-way voltage and current signal conditioning, data acquisition, signal processing, reactance calculation and communication with a backstage control cabinet of the transformer winding based on a computer real-time data acquisition system. The 24-way voltage and current signal conditioning comprises 12-way voltage connection and conditioning and 12-way current connection and conditioning. Three American national instrument data acquisition cards PCI 6220 are used for synchronously collecting all signals in data acquisition. The on-line monitoring system of the transformer winding has the advantages of being capable of monitoring deformation of a winding by calculating short-circuit reactance of the winding of a main transformer of the converting station on line and in real time, providing important reference for maintenance of the converting station, applicable to field application, and being capable of being actually used in long-term operation, capable of providing rich monitoring functions which comprise input and output of effective values of voltage and current, wave form data, tendency charts of the reactance and the like, capable of providing flexible inquiry statistics based on designs of databases, and capable of enabling a user to review historical operation through rich and various data display forms.

A database for design of an integrated circuit device having data stored therein in a flexibly utilizable state, and a method for designing an integrated circuit device using such a database. A virtual core database (VCDB) for storing design data and a VCDB management system (VCDBMS) as a control system are provided. The VCDB includes virtual core (VC) clusters, test vector clusters, and purpose-specific function testing models. The VCDB also includes a system testing database having shared test clusters and peripheral model clusters. The VCDBMS includes a function testing assist section for generating test scenarios, the purpose-specific function testing models, system testing models, and the like, a VC interface synthesis section, and the like.

A simplified software solution framework facilitating rapid development of automated solutions is introduced. The main concept behind the framework is a simplified approach towards database design with entities having concatenated character separated (CSV) strings of foreign keys pointing to the primary keys of their related child entities. This representation is applicable to all types of database relationships including one-to-many and many-to-many relationships, thus eliminating the need for junction tables.The resulting encapsulation of the database entity with data and its relationships brings about cohesiveness among the data layer, business layer and presentation layer of the application. A framework with the new approach demonstrates how domain objects can flow across application layers in their own swim-lanes with minimal interference among each other.

The invention discloses a database dynamic management method based on XML (extensible markup language) metadata. The method comprises the following steps: 1, organizing an XML storage structure and defining XML node information including user-defined business rules; 2, building a metadata analysis engine; 3, building a business dispatch execution engine; 4, building an interface for calling data by an external program; 5, and importing and exporting business data. The whole database structure is described from the perspective of businesses, all metadata in a database and the whole structure are stored in an XML, and by the analysis engine and the execution engine which are combined with the structure, the database can be directly operated by the substituted engines; the design process of the system database is simplified, the flexibility and the expansibility of the database design are simultaneously enhanced, the integration with the outer system is better, and great convenience is provided for data exchange, particularly complicated business data exchange.

The invention discloses a cloud computing SaaS (Software as a Service) service mode-based electric energy quality auxiliary service system and an implementation method thereof, and relates to the technical fields of power engineering, computer software engineering and database design. A cloud computing SaaS service mode is introduced into a solution for an electric energy quality auxiliary service problem; the cloud computing SaaS service mode-based electric energy quality auxiliary service system is constructed and implemented; and customized configuration of an electric energy quality auxiliary service sharing example under the cloud computing SaaS service mode is realized by using an Agent technology, so that different electric energy quality auxiliary service request providing services can be realized by setting one electric energy quality auxiliary service example in the system. The variation of the service can be flexibly adapted without changing a main frame of the service system, the workload of the service provider is effectively reduced, and the cost of providing various items of auxiliary service is saved; the resource reusability and the integral efficiency of the system are improved; and the system has higher extensibility.