Eureka AIR delivers breakthrough ideas for toughest innovation challenges, trusted by R&D personnel around the world.

Managing data with flexible schema

A mode and data technology, applied in the field of managing data with flexible modes, can solve problems such as query performance degradation and inapplicability

Active Publication Date: 2017-03-01
MICROSOFT TECH LICENSING LLC
View PDF5 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Specifically, query performance has been found to degrade dynamically when queries go beyond simple predicate selection, and their execution plans involve a large number of joins on key-value stores
Also, key-value pairs are not suitable for those applications where data normalization cannot be omitted

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Managing data with flexible schema
  • Managing data with flexible schema
  • Managing data with flexible schema

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] The subject matter described herein will now be discussed with reference to a few example embodiments. It will be appreciated that these embodiments are discussed merely for the purpose of enabling those skilled in the art to better understand and thus implement the subject matter described herein, without implying any limitation on the scope of the subject matter.

[0020] As used herein, the term "comprising" and variations thereof are to be understood as open-ended terms meaning "including but not limited to". The term "or" is to be read as "and / or" unless the context clearly dictates otherwise. The term "based on" is to be understood as "based at least in part on". The terms "one embodiment" and "an embodiment" are to be read as "at least one embodiment." The term "another embodiment" is to be understood as "at least one other embodiment". The following may contain other definitions, both explicit and implicit.

[0021] figure 1 Illustrated is an example of a c...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The subject matter described herein relates to managing data with flexible schema. A method, computer storage medium, and system are provided for managing data with flexible schema. The method comprises providing a logical view for logical tables of a database; and managing mappings between the logical tables and a physical table according to predefined mapping constraints, each of the logical table mapped as a part of the physical table. The mapping constraints at least specify that (i) a logical column in the logical tables is mapped to at least one physical column in the physical table, and (ii) distinct logical columns in one of the logical tables are mapped to distinct physical columns in the physical table. As a result, schema evolution may be done with minimized data migration.

Description

Background technique [0001] A database schema is an organization of data that defines how the database is structured. For example, in a relational database, a schema specifies how data is stored and managed by defining tables, fields, relationships, views, indexes, functions, queues, triggers, types, and other aspects. For semi-structured data, multi-tenant databases, and many other scenarios it is desirable to manage data with a flexible schema. [0002] Currently, various applications with flexible schemas suffer from the problem that schemas are often not well defined and may evolve over time. Traditional databases such as Structured Query Language (SQL) databases have difficulty supporting efficient schema evolution. As is known, schema evolution may require renormalization and table repartitioning, for example, when evolving a one-to-one relationship to a many-to-one relationship. Table repartitioning is time consuming due to data migration from old tables to new table...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/211G06F16/213G06F16/217G06F16/23
Inventor 陈亮P·A·贝恩斯泰因
Owner MICROSOFT TECH LICENSING LLC
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com