285 results about "Database engine" patented technology

Various embodiments of the present invention are directed to a storage platform comprising a database engine, a data store, an application programming interface. The data store is implemented on the database engine for storing data therein, and the data store implements a data model that supports the organization, searching, sharing, synchronization, and security of data stored in the data store. Specific types of data are described in schemas. The application programming interface enables application programs to access services and capabilities of the storage platform and to access the data described in the schemas. The storage platform supports interoperability with existing file systems, enables users and systems to synchronize data stored in different instances of the data store, and provides the ability for application programs to be notified about and to track changes made to the data in the data store.

The present invention relates to a subscription modeling system and methodology. A query processor receives subscription query and subscriber information and transforms the query and subscriber information into data. An index component propagates at least one database with the transformed data; and a matching component that associates the transformed data with event data to generate a database of notification data that can be delivered to subscribers. The invention provides for abstracting subscription and subscriber information (as well as event information if desired) to high-level classes (e.g., data fields)—thus the invention provides for modeling such notification related information as data. Subscription applications can thus be developed at high levels wherein complex subscription queries and subscriber information can be defined as data fields for example. Databases in accordance with the data fields can be propagated with subscription / subscriber specific information. The present invention takes advantages of the processing power associated with database engines (e.g., SQL server) to generate notifications via performing a join operation on the databases (e.g., subscription database(s), subscriber database(s) and event database(s)). Accordingly, notifications are generated en masse as compared to per subscription per subscriber. Thus the present invention provides for a highly scalable and efficient notification system.

A column-store database computer system responsive to database requests for the update and retrieval of data from within a stable data table providing for the storage of database tuples within a column-store organized database structure. A positional delta tree data structure is implemented in the memory space of the computer system and is operatively coupled in an update data transfer path between a database engine interface and the stable data table. The positional delta tree data structure includes a differential data storage layer operative to store differential update data values in positionally defined relative reference to database tuples stored by the stable data table.

A computer-implemented method for encoding a handwritten stroke set, each of the handwritten stroke set being representative of a constituent stroke of an ideographic character, to obtain an encoded input sequence. The method includes ascertaining a shape of a first stroke of the handwritten stroke set and ascertaining one of a location information and a size information pertaining to the first stroke. The method further includes assigning a first code to the encoded input sequence responsive to a determination of the shape of the first stroke and a determination of the one of the location information and the size information of the first stroke. The first code is predefined to represent the shape of the first stroke and the one of the location information and the size information of the first stroke. The first code is sufficiently unique to distinguish the first code from other codes representing other permutations of shape and the one of the location information and the size information of the first stroke.

An improved system and method for recovery from failure of a storage server in a distributed column chunk data store is provided. A distributed column chunk data store may be provided by multiple storage servers operably coupled to a network. A storage server provided may include a database engine for partitioning a data table into the column chunks for distributing across multiple storage servers, a storage shared memory for storing the column chunks during processing of semantic operations performed on the column chunks, and a storage services manager for striping column chunks of a partitioned data table across multiple storage servers. Any data table may be flexibly partitioned into column chunks using one or more columns with various partitioning methods. Storage servers may then fail and column chunks may be recreated from parity column chunks and redistributed among the remaining storage servers in the column chunk data store.

The method, apparatus and system are provided for obtaining information regarding compliance with local laws via client computers to upload information to a centralized server preferably over a wide area network. The data is obtained through interaction with a client device and the data is stored on a server. The server has access to a database engine which provides triggering and alarming capabilities for the tracking of applicable dates and events. The server system is provided with software and / or hardware necessary to perform manipulation of the data provided by the client and enable reconfiguration of the data for investigative and reporting purposes.

A database system may include a database service and a separate distributed storage service. The database service (or a database engine head node thereof) may be responsible for query parsing, optimization, and execution, transactionality, and consistency, while the storage service may be responsible for generating data pages from redo log records and for durability of those data pages. For example, in response to a write request directed to a particular data page, the database engine head node may generate a redo log record and send it, but not the data page, to a storage service node. The storage service node may store the redo log record and return a write acknowledgement to the database service prior to applying the redo log record. The server node may apply the redo log record and other redo log records to a previously stored version of the data page to create a current version.

To maintain the integrity and operability of enterprise database systems, queries intended for a particular database engine are intercepted, preferably by a separate processing system, prior to being acted upon by the database engine. The query is evaluated to determine its projected impact on available database system resources. The variables evaluated include user rights, administrator-imposed limits to searches, the amount of presently-available system resources, the cost of query and the like. If the query's potential impact does not surpass a predetermined threshold, it is submitted to the search engine. If the query is too resource-intensive or costly, the query may be (i) optimized by a query-optimization system, (ii) stored until more system resources are available, or (iii) rejected.

A system for calculating analytics uses a relational database to store inputs, calculates results, and stores them in cache. The system also includes an access layer that provides a unified view of the data in server. A dynamic access layer is generated at runtime to run an analytic to provide a flexible framework for creating business logic.

A method and system for stress testing database storage. Stress testing software generates read and / or write commands to a database engine. Preferably, the read and write commands adhere to a desired ratio of reads to writes. The commands are interpreted by the database engine. The database engine issues read and / or write instructions to a database storage system. Multiple instances of the stress testing software may be spawned against a plurality of databases in order to achieve a desired aggregate rate of operations to the database storage system. Performance measurements of the database storage system are obtained and may be used for evaluation of the database storage system. Advantageously, the performance of a database storage system may be tested and measured without the encumbrances of transaction processing overhead due to actual database processing.

A method for attaching a tag to digital data provided from a digital device in a digital data management system includes the steps of: attaching the tag to the digital data automatically according to attributes and contents of the digital data. Moreover, a system for managing digital data produced in a digital device includes: a transceiver for transmitting and receiving the digital data; a database for storing and managing the digital data; and a database engine including a processing unit for automatically extracting a tag from the digital data and then assigning the tag to the digital data. By using the method and the system, a user manages the digital data and shares them with other users. The notable effect is that it provides various tag information in a useful form to the users.

The assembly and communications of a generic reporting engine for offering clinical structured reports using the Internet in an encrypted manner is provided. This method of rendering structured reports employs a DICOM Structured Reporting (SR) software database engine that maps clinical report data into a clinical structured reporting data format using a Report Editor Plug-in which is responsible for constructing the report editor GUI, for parsing the DICOM SR report to show it in the Report Editor window and to store the report content created in the GUI to the DICOM SR format. The report engine can be configured with any number of software plug-ins, so totally different ways of acquiring user input may be implemented. The current invention implements the software plug-ins using a tree-like GUI. The current implementation of this plug-in is based on DICOM SR pull model which is considered more feasible to control its presentation form, but the reporting engine allows for implementation of push model report editor plug-ins. Nothing in this novel approach to clinical reporting prevents the application from implementing a report editor from editing any DICOM SR report in a generic way, like recognizing a report from voice dictation. The Reporting Engine of the present invention provides a way for the plug-ins to recognize if they are able to open the report or not. It can be done either by software plug-ins' report introspection or the process is configurable in the using the invention's reporting engine. The novel reporting engine provides a way of configuring a Report Editor Plug-in, so with one generic plug-in one may have many report templates just by configuring the plug-in. The currently implemented plug-in uses this possibility to define the report definition and GUI tree in a configuration file.

An improved system and method for query processing in a distributed column chunk data store is provided. A distributed column chunk data store may be provided by multiple storage servers operably coupled to a network. A storage server provided may include a database engine for partitioning a data table into the column chunks for distributing across multiple storage servers, a storage shared memory for storing the column chunks during processing of semantic operations performed on the column chunks, and a storage services manager for striping column chunks of a partitioned data table across multiple storage servers. Query processing may be performed by storage servers or query processing servers operably coupled by a network to storage servers in the column chunk data store. To do so, a hierarchy of servers may be dynamically determined to process execution steps of a query transformed for distributed processing.

An improved system and method for compression in a distributed column chunk data store is provided. A distributed column chunk data store may be provided by multiple storage servers operably coupled to a network. A storage server provided may include a database engine for partitioning a data table into the column chunks for distributing across multiple storage servers, a storage shared memory for storing the column chunks during processing of semantic operations performed on the column chunks, and a storage services manager for striping column chunks of a partitioned data table across multiple storage servers. Any data table may be flexibly partitioned into column chunks using one or more columns with various partitioning methods. Domain specific compression may be applied to a column chunk to reduce storage requirements of column chunks and increase transmission speeds for sending column chunks between storage servers.

A method for accessing information on a network is disclosed. The network comprises a first system and a second system. The method comprises allowing the first system to submit a query to the second system, processing the query with the second system, wherein the second system utilizes information not residing on the second system to process the query and utilizing the second system to return a result of the processed query to the first system. Through the use of the method in accordance with the present invention, the more traditional function of the server database, which is a data storage and access facility, is decoupled from the database engine. Consequently, the server system only acts on data that it is provided access to via a system that is connected to the server system. Accordingly, no information concerning the database (i.e. data or metadata) exists on the server system.

A self-healing database engine and optimizer framework support automatically responding to execution errors to allow continued execution of a query plan. Upon encountering an execution error, the database engine automatically initiates a rebuilding of the query plan and executes the rebuilt execution plan. If an error is encountered in the rebuilt query plan then the query implementation methods are analyzed. If a query function is identified for which an alternative implementation method is available, then this alternative implementation method is substituted to create a new query plan. The new query plan is then executed to determine if the error is corrected.

A system and method for searching and matching products based on color using a universal color system comprises a plurality of processor based client devices, each client device uniquely associated with a user, a database engine comprising a plurality of products reverse mapped and organized in accordance with the hexadecimal color codes of the universal color system, and a processor based server. The server receives a color-based search query comprising user's color selection from a client device associated with a user over a communications network. The user's color selection comprises at least one hexadecimal color code of the universal color system. A color engine of the server searches the database engine for products having the hexadecimal color codes with a predetermined range of the hexadecimal color code of the user's color selection, and transmits the search result to the client device associated with the user over the communications network.

The invention discloses a method for recording event logs and a database engine, and belongs to the technical field of databases. The method includes the steps that an SQL request is received; according to the SQL request, data pages corresponding to the SQL request are modified; corresponding event logs are generated for the modification; the event logs are partitioned to obtain a plurality of log segments, the log segments are written into a plurality of buffer queues, and the log segments in the buffer queues are written into a log file. The database engine comprises a receiving module, a modifying module, a generating module and writing-in module. According to the method for recording event logs and the database engine, the event logs can be recorded in parallel; due to the fact that the buffer queues are multiple and written into the log file in a parallel processing mode, not only is the lock granularity of the event log buffer queues reduced, but also the speed for writing the log file into a disk is greatly increased, the performance of a database system is improved, and user experience is improved.

An improved system and method for compression in a distributed column chunk data store is provided. A distributed column chunk data store may be provided by multiple storage servers operably coupled to a network. A storage server provided may include a database engine for partitioning a data table into the column chunks for distributing across multiple storage servers, a storage shared memory for storing the column chunks during processing of semantic operations performed on the column chunks, and a storage services manager for striping column chunks of a partitioned data table across multiple storage servers. Any data table may be flexibly partitioned into column chunks using one or more columns with various partitioning methods. Domain specific compression may be applied to a column chunk to reduce storage requirements of column chunks and increase transmission speeds for sending column chunks between storage servers.

A database engine facing multiple tenancies and data accessing method thereof are provided. The method of the invention includes: receiving a data access request of tenancy; determining the tenancy entity corresponding to the tenancy, wherein multiple tenancy entities share one logic table in the database; processing the data access request of the tenancy according to the configuration information of the tenancy entity. The invention introduces the concept of tenancy entity to the database: a plurality of tenancy entities shares one logic table such that the development and management costs are reduced; meanwhile, every tenancy entity has independent database access account number such that the security problem of the database access is solved; when the tenancy request comes, the data access request of the tenancy is processed according to the authority of the account number of the tenancy. Due to the introduced concept of the tenancy entity in the invention, the data of the tenancy is physically separated from each other and thus it is possible to improve performance, excellent isolation and expandability; and it is possible to realize the service quality management for the tenancy at the same time.

The invention discloses a component-oriented multi-language collaborative development device, method and system. According to the method, multiple engines are concentrated under an MVC software system architecture to be constructed; rapid construction of business logic, establishment of a database table and an access system and visual composition of an interface UI are realized through a business logic engine, a database engine, a form engine, etc.; the development process is based on a data layer process, a business layer process and an interface layer process; and multi-person online collaborative programming can be realized through an architecture of a client server. On the basis of component orientation, software fine-grained reuse can be done, a product can be developed through a business custom system, the software development cycle is greatly shortened, working efficiency is improved, and human cost is reduced.

A distributed, object-oriented database engine utilizing independent, intelligent processing nodes as a cooperative, massively parallel system with redundancy and fault tolerance. Instead of using traditional methods of parallelism as found in most distributed databases, the invention utilizes a messaging system and a series of message processing nodes to determine where attributes and data files associated with objects are stored. The architecture is loosely coupled, each node independently determining if it manages or routes storage and retrieval requests.

The invention discloses an automated development platform based on model configuration, comprising a visualization work engine module and a database engine. For the visualization work engine module, the inside is divided according to system implementation functions, each divided part contains foreground and background related logics, the visualization work engine module works according to an agile developing model, and loose coupling is carried out among the parts; the database engine comprises a database connection manager, a sql manager, a things manager and an external interface, and is used for creating and managing database connections and maintaining data persistence; the sql manager is used for generating a corresponding sql object according to a data model configured by a user and transmitting the sql object to a tbl class in the visualization work engine module, and the tbl class executes the sql and makes corresponding response; and the platform automatically generates corresponding pages according to the configured data model, realizes insert, delete, update and select of simple functions, improves development efficiency and reduces workload of development.

An improved system and method for adding a storage server in a distributed column chunk data store is provided. A distributed column chunk data store may be provided by multiple storage servers operably coupled to a network. A storage server provided may include a database engine for partitioning a data table into the column chunks for distributing across multiple storage servers, a storage shared memory for storing the column chunks during processing of semantic operations performed on the column chunks, and a storage services manager for striping column chunks of a partitioned data table across multiple storage servers. Any data table may be flexibly partitioned into column chunks using one or more columns with various partitioning methods. Additional storage servers may then be added and column chunks may be redistributed among the storage servers in the column chunk data store.