WO2016138614A1 - Gestion d'interrogations de base de données par rapport à de grands ensembles de données - Google Patents
Gestion d'interrogations de base de données par rapport à de grands ensembles de données Download PDFInfo
- Publication number
- WO2016138614A1 WO2016138614A1 PCT/CN2015/073489 CN2015073489W WO2016138614A1 WO 2016138614 A1 WO2016138614 A1 WO 2016138614A1 CN 2015073489 W CN2015073489 W CN 2015073489W WO 2016138614 A1 WO2016138614 A1 WO 2016138614A1
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- data
- chunks
- data chunks
- groupings
- query
- Prior art date
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2471—Distributed queries
Definitions
- Enterprises for example, companies, educational entities, government entities, and the like often operate hundreds or thousands of computers and computing systems for their employees, students and affiliates. Often such computers and computer systems are operated at various enterprise locations, or often such computers or computer systems are operated at large data centers. Many enterprises store and process data via data storage and processing services providers operating remotely from the enterprise where data storage, data processing and online services are provided at the remote services provider over a distributed computing network such as the Internet.
- an enterprise sends data queries to the services provider for running various processing jobs against the enterprise’s data and systems stored and operated at the services provider or at an associated services provider data center.
- the query submitted by the enterprise includes query logic created by the enterprise so that the enterprise may perform self-service queries on the enterprise’s data and subscribed-to systems at the services provider or data center.
- an enterprise may send a data query to a large data center/services provider for running a report detailing the various computer operating systems in use by thousands or even millions of its customers who have logged into an online software service. Such a report may be needed by the enterprise for properly managing its computing resources.
- data associated with such large numbers of users or systems can overwhelm the databases, database services and processing functionalities of the services provider to which the data query is sent.
- data queries applied against such large datasets take excessive amounts of time to process or fail altogether due to limitations in the resources of the receiving services provider.
- large data files or datasets received at a storage repository are separated into a number of data segments or chunks. Groupings of subsets of the data segments or chunks (e.g., groupings of three chunks) are stored at each of multiple servers (e.g., each of 12 servers operating in a server cluster) .
- results of the query process are returned back to a primary server. Duplicate results are discarded, and remaining results are aggregated. A report then may be generated from the aggregated results and may be passed back to the querying enterprise.
- Fig. 1 is a simplified block diagram of one example of a system architecture for processing data queries against large data files or datasets separated into smaller data chunks.
- Fig. 2A illustrates a large data file or dataset separated into data chunks against which data queries may be processed.
- Fig. 2B illustrates one example of a system architecture for processing multiple data chunks at corresponding servers.
- Fig. 3 is a flowchart of an example method for processing a data query against a large data file or dataset separated into smaller data chunks.
- Fig. 4 is a block diagram illustrating example physical components of a computing device with which aspects of the present invention may be practiced.
- Figs. 5A and 5B are simplified block diagrams of a mobile computing device with which aspects of the present invention may be practiced.
- Fig. 6 is a simplified block diagram of a distributed computing system in which aspects of the present invention may be practiced.
- aspects of the present invention are directed to scaling out and managing database queries to large data files or datasets.
- Large data files or datasets received at a storage repository are separated into a number of data segments or chunks. Groupings of the data segments or chunks are stored at each of multiple servers.
- Data queries received for processing against the data files or datasets are passed to each server and are simultaneously run against the smaller data segments/chunks groupings at each server.
- Results of the query process are returned back to a primary server. Duplicate results are discarded, and remaining results are aggregated for reporting back to the querying party (e.g., enterprise or other individual or entity) .
- the querying party e.g., enterprise or other individual or entity
- system architecture 100 for uploading and downloading data files, datasets, queries and responses to queries between a source (e.g., enterprise, individual or other entity) and a services provider or associated data center is illustrated and described.
- the system architecture 100 is comprised of various example computing components for passing data, queries and responsive information between a variety of source computing systems (or individual computers) to a variety of destination locations such as data centers and services providers.
- a data center 105 is illustrative of a data center operated by an enterprise or individual or entity subscriber of services (hereafter “enterprise” or “subscribers) that may need to upload data of various types, including production and test queries, to a data center or services provider (hereafter “data center” or “services provider” ) at which uploaded data and queries may be stored and/or processed.
- the data center 105 may house hundreds, thousands or more individual computers or computing systems 110 on which may be stored data of a variety of data types that may be processed using a variety of different computing processes, for example, a variety of software applications.
- each of the computing devices 110 may include computers of various types, for example, server computers, for storing user data in databases, electronic mail systems, document management systems, and the like, and the computing systems 110 may be used for running a variety of computing system software applications, for example, database applications, electronic mail systems applications, web services applications, online software provision applications, productivity applications, data management system applications, telecommunications applications, and the like.
- computing system software applications for example, database applications, electronic mail systems applications, web services applications, online software provision applications, productivity applications, data management system applications, telecommunications applications, and the like.
- the data center 105 is also illustrative of one of many data centers that may be co-located, or that may be located at different locations and that may be associated with each other via various transmission systems for passing data between disparate data centers.
- the data center 105 is illustrated as a data center in which numerous computer systems 110 may be located for provision of data and services, as described above, the data center 105 is equally illustrative of an entity, such as a company, educational entity, government entity or a single computing device, for example, a desktop, laptop, tablet, handheld, or other computing device operated by an individual user from which user data and/or computer system production and test queries may be uploaded to a services provider.
- each computing device 110 is associated with an uploader module 115 that is operative for uploading user and/or system data and production or test queries from each associated computer/computing system 110.
- the data uploader and downloader may be identical modules and are only designated as uploader versus downloader based on the direction of the data movement.
- an uploader module 115 may be installed on each associated computer/computing system 110 or may be accessed by each computer/computing system 110.
- the data uploader or downloader (hereafter also referred to as “data loader” ) 115 may utilize various data reader, data transformation and data export plug-in modules required for different types of data reading, transformation and export.
- a services provider which needs to receive transformed data from various computing devices operated at a data center 105 may provide data reader plug-ins, data transformation plug-ins, and data export plug-ins for use by data loader modules 115 for reading, transforming and exporting data according to their individual needs.
- a configuration file or instructions may be provided to a given data uploader for providing processing information to the uploader.
- an uploader module may be configured to send a data file, dataset and/or associated data query directly to a primary server 220-275 (described below with reference to Fig. 2B) for processing as described herein.
- the configuration file may provide the uploader module or direct the uploader to a data export plug-in module that will allow/cause the uploader to pass data and queries to a required primary server for processing.
- an edge router 120 is illustrative of a typical router device for passing queries from a given uploader module to systems external to the data center 105.
- the edge router 120 may be responsible for ensuring that data passed from a given data center 105 is properly passed to a desired destination system component, for example, that packetized data passing from the uploader module is properly routed to a correct destination component of the system 100.
- the edge router 135 is illustrative or a receiving edge router through which queries may be passed to a proxy service 140 (described below) responsible for ensuring received data and/or queries are properly authenticated prior to allowing received data and/or queries to be passed to one or more destination storage repositories 145a-c at the services provider 107.
- the distributed computing network 125 (illustrated in Fig. 1 as a dotted line) is illustrative of any network such as the Internet or an intranet through which data may be passed from the data center to components external to the data center such as destination storage repositories 145a-c of the secure data management center/repository, described below.
- the proxy service 140 may perform a number of functions.
- the proxy service 140 may serve as an authentication point for authenticating data and queries passing to/from a potentially unsecure enterprise and to a secure data center or services provider 107 at which the data and/or queries may be processed.
- the proxy service may include or may be able to read an export plug-in module for causing data and data queries to be distributed directly to a specified server 220-275 for processing, as described below with reference to Figs. 2A-3.
- functionality for separating a large data file or dataset into smaller data segments or chunks and for grouping the data segments or chunks for processing at a server 220-275 may be operated at the proxy service.
- the storage repositories 145a-c are illustrative of any data storage repository that may be authorized to receive data or queries uploaded via the uploader modules 115.
- the destination storage repositories 145a-c may be associated with a secure data management center/repository of a services provider for receiving, storing and analyzing data (in response to one or more production or test queries) associated with computing systems and software services provided for subscribers of the services provider.
- the data repository 145a may serve as a primary secure data receiving repository for a services provider.
- Access points 152, 154 and 156 represent access points at the data repository 145a through which data and queries may be passed from the proxy service 140 for uploading data to one or more specific data locations 160, or for passing data or queries through one or more specific data access points 158, 162 for passing the data to other data repositories 145b, 145c.
- the data repository 145a may also house a cluster or collection of servers at which grouping of data segments or data chunks may be stored and processed by a received query. As should be appreciated, however, such a cluster or collection of servers may be operated at any component of the services provider 107, including the repositories 145b-c, described below.
- the data repository 145b may be designated for receiving and analyzing user data and systems data, as well as, various queries associated with one or more services or data types.
- the data repository 145b is illustrative of a cloud services system operated at the secure data management center/repository 144 of a given services provider.
- a scheduler module 166 is illustrative of a software module or device operative for scheduling data uploads and downloads to and from the data repository 145b.
- a pumper module 168 is illustrative of a software module or device operative for distributing data to and from components of the data repository 145b.
- An analytics module 170 is illustrative of a software module or device operative for outputting and/or displaying or otherwise presenting data from the storage repository 145b.
- the destination storage repository 145c is illustrative of another component of the services provider 107.
- the destination storage repository 145c may be in the form of a database system operated at the services provider 107.
- a scheduler module 166 is illustrative of a software module or device operative for scheduling data uploads and downloads to and from the data repository 145c.
- a pumper module 168 is illustrative of a software module or device operative for distributing data to and from components of the data repository 145c.
- a analytics module 170 is illustrative of a software module or device operative for outputting and/or displaying or otherwise presenting data from the storage repository 145c.
- components of the services provider and the individual components 145a, 145b, 145c are for purposes of example and illustration only and are not limiting of various other components or systems that may be operated as part of the secure data management center/repository to which data may be uploaded or from which data may be downloaded from/to an external (and potentially unsecure) data generator/user.
- components of the secure data management center/repository 107 may provide for online software and data management provision, for example, provision of word processing services, slide presentation application services, database application services, spreadsheet application services, telecommunications application services, and the like provided to various users via one or more online software application services and data management systems.
- Fig. 2A illustrates a large data file or dataset separated into data segments or data chunks against which data queries may be processed.
- a large data file or dataset to which data queries may be applied may be stored at a data center and/or services provider.
- a given data file 210 as illustrated in Fig. 2A, may include hundreds of gigabytes or more of data stored at a data center 145a-c, as illustrated and described above with reference to Fig. 1, associated with various operations of a given enterprise.
- the data file 210 may include data representing login data, usage data, authentication data, and the like for thousands or millions of computers or computer users managed by a given enterprise.
- the enterprise for which the data is stored may pass a data query to the storage repository requesting various aggregations, calculations and/or computations to be run on the data file 210.
- a stored database function may be operated at the storage repository 145a, and data queries passed to the storage repository from the requesting enterprise may pass query parameters, for example, computations or questions to be applied to the data contained in the data file 210, for causing reporting to be generated for passing back to the requesting enterprise.
- a requesting enterprise may pass a data query having parameters calling for a computation of the numbers of its customers logging in to its systems using each of many different computer operating systems for allowing the enterprise to assess and manage its resources.
- parameters calling for a computation of the numbers of its customers logging in to its systems using each of many different computer operating systems for allowing the enterprise to assess and manage its resources.
- the data file 210 may be separated into a number of data segments or data chunks, for example, 12 data chunks 215, as illustrated in Fig. 2A.
- the data file may be broken into a number of identically sized data segments or chunks (hereafter referred to as “data segments” or “data chunks” to mean a portion or subset of a given dataset or data file) , or the data file may be broken into separate data segments or chunks at logical breaking points wherein each of the data segments or chunks are different file sizes. That is, as should be appreciated, one data chunk may include a certain category or type of data, a second data chunk may include a second category or type of data, and so on where the total of all the data segments or chunks comprises the total data file or dataset.
- the data chunks separated from the data file 210 may be grouped into data chunk groupings, and each data chunk grouping may be stored at a different server, for example, servers comprising a server cluster at the storage repository 145a-c, illustrated and described above with reference to Fig. 1.
- the data chunk groupings are organized such that the data chunks placed in each data chunk grouping overlap with succeeding data chunks so that when the data chunk groupings are processed for a received data query at each of the separate servers, each data chunk is processed multiple times (at least two or more times) across the set of servers.
- each data chunk will be processed multiple times across the set of servers. For example, for the 12 data chunk arrangement and 12 server arrangement illustrated in Fig. 2A, each data chunk 1-12 will be processed three times across the set of servers 1-12.
- the query logic fails at any given server 1-12, or if a malfunction of the server computing system occurs at a given server, then the processing applied or attempted to be applied to the data chunks at that server may be discarded, and because of the redundancy of processing applied to each chunk in parallel at each of the servers 1-12, reliability of processing of each data chunk is ensured.
- the separation of a data file 210 into 12 data chunks 215, and the processing of data chunks in three chunk groupings at 12 separate servers is for purposes of example and illustration only and is not limiting of other data file separation, chunk groupings, and server arrangements that may be utilized.
- a data file could be separated into 15 data chunks, and data chunks could be grouped into four chunk groupings that could then be run on 15 servers for achieving a similar redundancy and reliability outcome.
- separating a large data file or dataset into segments or chunks that are then processed in separate servers such that each data segment or chunk is processed at least more than once is a key to ensuring processing of smaller amounts of data at each server and to ensuring that each segment or chunk of data is indeed processed.
- Fig. 2B illustrates one example of a system architecture for processing multiple data chunks at corresponding servers.
- a number of data centers 105a-n are illustrated from which data files or datasets, as well as, data queries to be operated against data files or datasets may be passed across a distributed computing network 125 through a proxy service 140 for storage at various storage repository servers 220-275 at a storage repository 145a of a large data center or services provider, as illustrated and described above with reference to Fig. 1.
- Access points 152, 154, 156 are illustrative of access points that may be utilized for receiving the datasets and data queries from the proxy service 140 and for directing the data files and data queries to each of the servers 220-275.
- a dataset grouping and distribution module 218, illustrated in Fig. 2B is software module or device operative for breaking a received data file into data chunks, and for distributing groupings of data chunks to each of the servers 220-275, as described above with reference to Fig. 2A.
- the dataset grouping and distribution module 218 may be operated at the storage repository 145a with access to each of the servers 220-275, or it may be operated at one of the servers 220-275 for receiving, separating, grouping and distributing data chunks to other servers 220-275 for processing.
- the dataset grouping and distribution module 218 may be operated at the proxy service 140, and an associated upload plug-in module may be operated at the proxy service 140 for automatically passing each chunk grouping to a prescribed server 220-275 for processing, as described above with reference to Fig. 2A.
- the access points 152, 154, 156 may include the dataset grouping and distribution module 218 breaking the received data file into data chunks and for grouping the data chunks for distribution to each of the servers 220-275.
- the dataset grouping and distribution module 218 may be maintained at a given data center 105a-n by a querying enterprise, and each data chunk grouping may be passed to respective servers 220-275 at the receiving data center and/or services provider via the proxy service 140, as described above with reference to Fig. 1.
- each data chunk grouping is passed to and stored at a respective server 220-275, as illustrated at the data repository 145a.
- the numbered boxes illustrated in each of the servers 220-275 are illustrative of different data chunks comprising data chunk groupings, as illustrated and described above with reference to Fig. 2A.
- a database function 219 (represented by the character “F” in each server) is stored at each of the servers 220-275 for receiving data queries of various types for processing the data chunk groupings stored at each respective server.
- the functions stored at each server 220-275 are identical for a given data type or data query type so that a data query passed to each stored function may be operated in an identical fashion to the same data query passed to each other server in the server grouping or cluster 220-275.
- any number of functions may be stored at each of the servers 220-275 for receiving and processing data queries against data chunk groupings, as described herein.
- each data query may be configured for passing to a designated server 220-275 that may operate as a primary server 220-275 for the received data query.
- the primary server 220-275 may then distribute the received data query to each of the other servers 220-275 so that the data query is received and distributed to each of the servers 220-275 for processing against the data chunk groupings, as described above.
- any of the servers 220-275 may be designated as a primary server for different data queries. That is, by designating different servers 220-275 as primary servers for different data queries, the processing resources and requirements associated with receiving and processing data queries is spread across different servers 220-275 so that no one server is overwhelmed with processing received data queries.
- Fig. 3 is a flowchart of an example method for processing a data query against a large data file or dataset separated into smaller data segments or chunks.
- the routine 300 begins at start operation 305 and proceeds to operation 310 where a stored function is uploaded to a server cluster comprised of a number of servers onto which a data file or dataset 210 has been loaded or will be loaded at operation 315 from a given enterprise or data center and to which one or more data queries may be applied for allowing a querying enterprise to perform various types of processing and for obtaining various types of reporting on the uploaded data file or dataset.
- the data file or dataset uploaded by the enterprise is separated into data chunks, as illustrated and described above with reference to Fig. 2A.
- the data chunks are organized into data chunk groupings that may be stored at each of a set of servers 220-275 for processing, as described above with reference to Fig. 2B.
- the chunks groupings are stored at separate servers 220-275, as illustrated and described above with reference to Figs. 2A and 2B.
- the uploaded data files and/or datasets may be separated into separate data chunks and organized into data chunk groupings via software applications and/or devices operated at the data center and/or services provider at which the data is to be stored and processed or at the proxy service 140, or at the data centers 105a-n from which the data was originally uploaded.
- a data query directed to the received data file or dataset is received at the storage repository 145a-n from a querying enterprise for processing a given set of data query parameters against the stored data file or dataset that has been separated and organized into data chunk groupings at each of the servers 220-275.
- the data query along with any data query parameters is uploaded to a primary server 220-275 from which the data query may be distributed to each of the servers 220-275 for operation against the data chunk groupings stored at each respective server.
- the received data query is distributed by the primary server to each server receiving data chunk groupings.
- the data query is run at each server on each data chunk grouping.
- results of the running of the data query at each server on each data chunk grouping are returned to the primary server from which the data queries were distributed to each of the other servers 220-275.
- duplicate results are discarded. That is, as described above with reference to Fig. 2A, because the data chunk groupings are comprised of overlapping combinations of data chunks, each data chunk is passed to multiple data servers and is processed multiple times by the same data query. Thus, if every server 220-275 and every data query applied to the data chunk groupings stored at the respective servers 220-275 are operating properly, then results may be returned for each instance of the data chunk stored with a data chunk grouping at each server 220-275. That is, referring back to Fig. 2A, a given data chunk, for example, data chunk 2 would be processed three times at three different servers, and results for the processing of this server against data chunk 2 would be returned to the primary server at operation 360. Thus, before the results of the processing of each data chunk are aggregated, duplicate results are discarded.
- the query results are aggregated so that a single query result is aggregated for each data chunk to generate an aggregation of query results for the entire data file of dataset.
- the results of the received query may be provided to the requesting enterprise in any format or report type or report template prescribed by the requesting enterprise.
- the aggregated query results may be separated into chunks and may be queried against for yet additional analysis of a data file comprised of aggregated query results from the starting data file. That is, the process described herein may be applied to any data file or data set that is considered to be too large for processing as a single file at a single server.
- the routine 300 ends at operation 395.
- a large data file or dataset (e.g., comprised of potentially many gigabytes or more of raw data) may be separated into smaller data segments or chunks that then may be organized in overlapping data chunk groupings so that each data chunk grouping may be processed at a separate server by the same data query.
- a given data server malfunctions, or if data stored at a given data server becomes corrupted, the reliability of the results of the data queries operated against the data chunk groupings will remain high, because the data queries will be run against duplicate data chunks causing a return of duplicate results which may be discarded after ensuring that data results are in fact returned for all data chunks.
- an aggregated result for application of the received data query may be processed against a very large data file or dataset, and the reliability of the returned results may be maintained at a very high level.
- program modules include routines, programs, components, data structures, and other types of structures that perform particular tasks or implement particular abstract data types.
- the embodiments and functionalities described herein may operate via a multitude of computing systems including, without limitation, desktop computer systems, wired and wireless computing systems, mobile computing systems (e.g., mobile telephones, netbooks, tablet or slate type computers, notebook computers, and laptop computers) , hand-held devices, multiprocessor systems, microprocessor-based or programmable consumer electronics, minicomputers, and mainframe computers.
- desktop computer systems e.g., desktop computer systems, wired and wireless computing systems, mobile computing systems (e.g., mobile telephones, netbooks, tablet or slate type computers, notebook computers, and laptop computers) , hand-held devices, multiprocessor systems, microprocessor-based or programmable consumer electronics, minicomputers, and mainframe computers.
- mobile computing systems e.g., mobile telephones, netbooks, tablet or slate type computers, notebook computers, and laptop computers
- hand-held devices e.g., hand-held devices
- multiprocessor systems e.g., microprocessor-based or programmable consumer electronics, minicomputers,
- embodiments and functionalities described herein may operate over distributed systems (e.g., cloud-based computing systems) , where application functionality, memory, data storage and retrieval and various processing functions may be operated remotely from each other over a distributed computing network, such as the Internet or an intranet.
- a distributed computing network such as the Internet or an intranet.
- User interfaces and information of various types may be displayed via on-board computing device displays or via remote display units associated with one or more computing devices. For example user interfaces and information of various types may be displayed and interacted with on a wall surface onto which user interfaces and information of various types are projected.
- Interaction with the multitude of computing systems with which embodiments of the invention may be practiced include, keystroke entry, touch screen entry, voice or other audio entry, gesture entry where an associated computing device is equipped with detection (e.g., camera) functionality for capturing and interpreting user gestures for controlling the functionality of the computing device, and the like.
- detection e.g., camera
- Figures 4-6 and the associated descriptions provide a discussion of a variety of operating environments in which embodiments of the invention may be practiced.
- the devices and systems illustrated and discussed with respect to Figures 4-6 are for purposes of example and illustration and are not limiting of a vast number of computing device configurations that may be utilized for practicing embodiments of the invention, described herein.
- FIG. 4 is a block diagram illustrating physical components (i.e., hardware) of a computing device 400 with which embodiments of the invention may be practiced.
- the computing device components described below may be suitable for the computing devices 110, 115, 145, described above.
- the computing device 400 may include at least one processing unit 402 and a system memory 404.
- the system memory 404 may comprise, but is not limited to, volatile storage (e.g., random access memory) , non-volatile storage (e.g., read-only memory) , flash memory, or any combination of such memories.
- the system memory 404 may include an operating system 405 and one or more program modules 406 suitable for running software applications 450.
- the operating system 405 may be suitable for controlling the operation of the computing device 400.
- embodiments of the invention may be practiced in conjunction with a graphics library, other operating systems, or any other application program and is not limited to any particular application or system.
- This basic configuration is illustrated in Figure 4 by those components within a dashed line 408.
- the computing device 400 may have additional features or functionality.
- the computing device 400 may also include additional data storage devices (removable and/or non-removable) such as, for example, magnetic disks, optical disks, or tape.
- additional storage is illustrated in Figure 4 by a removable storage device 409 and a non-removable storage device 410.
- program modules 406 may perform processes including, but not limited to, one or more of the stages of the method 300 illustrated in Figure 3.
- Other program modules that may be used in accordance with embodiments of the present invention and may include applications such as electronic mail and contacts applications, word processing applications, spreadsheet applications, database applications, slide presentation applications, drawing or computer-aided application programs, etc.
- embodiments of the invention may be practiced in an electrical circuit comprising discrete electronic elements, packaged or integrated electronic chips containing logic gates, a circuit utilizing a microprocessor, or on a single chip containing electronic elements or microprocessors.
- embodiments of the invention may be practiced via a system-on-a-chip (SOC) where each or many of the components illustrated in Figure 4 may be integrated onto a single integrated circuit.
- SOC system-on-a-chip
- Such an SOC device may include one or more processing units, graphics units, communications units, system virtualization units and various application functionality all of which are integrated (or “burned” ) onto the chip substrate as a single integrated circuit.
- the functionality, described herein, with respect to providing an activity stream across multiple workloads may be operated via application-specific logic integrated with other components of the computing device 400 on the single integrated circuit (chip) .
- Embodiments of the invention may also be practiced using other technologies capable of performing logical operations such as, for example, AND, OR, and NOT, including but not limited to mechanical, optical, fluidic, and quantum technologies.
- embodiments of the invention may be practiced within a general purpose computer or in any other circuits or systems.
- the computing device 400 may also have one or more input device (s) 412 such as a keyboard, a mouse, a pen, a sound input device, a touch input device, etc.
- the output device (s) 414 such as a display, speakers, a printer, etc. may also be included.
- the aforementioned devices are examples and others may be used.
- the computing device 400 may include one or more communication connections 416 allowing communications with other computing devices 418. Examples of suitable communication connections 416 include, but are not limited to, RF transmitter, receiver, and/or transceiver circuitry; universal serial bus (USB) , parallel, and/or serial ports.
- USB universal serial bus
- Computer readable media may include computer storage media.
- Computer storage media may include volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information, such as computer readable instructions, data structures, or program modules.
- the system memory 404, the removable storage device 409, and the non-removable storage device 410 are all computer storage media examples (i.e., memory storage.
- Computer storage media may include RAM, ROM, electrically erasable read-only memory (EEPROM) , flash memory or other memory technology, CD-ROM, digital versatile disks (DVD) or other optical storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other article of manufacture which can be used to store information and which can be accessed by the computing device 400. Any such computer storage media may be part of the computing device 400. Computer storage media does not include a carrier wave or other propagated or modulated data signal.
- Communication media may be embodied by computer readable instructions, data structures, program modules, or other data in a modulated data signal, such as a carrier wave or other transport mechanism, and includes any information delivery media.
- modulated data signal may describe a signal that has one or more characteristics set or changed in such a manner as to encode information in the signal.
- communication media may include wired media such as a wired network or direct-wired connection, and wireless media such as acoustic, radio frequency (RF) , infrared, and other wireless media.
- RF radio frequency
- FIGS 5A and 5B illustrate a mobile computing device 500, for example, a mobile telephone, a smart phone, a tablet personal computer, a laptop computer, and the like, with which embodiments of the invention may be practiced.
- a mobile computing device 500 for implementing the embodiments is illustrated.
- the mobile computing device 500 is a handheld computer having both input elements and output elements.
- the mobile computing device 500 typically includes a display 505 and one or more input buttons 510 that allow the user to enter information into the mobile computing device 500.
- the display 505 of the mobile computing device 500 may also function as an input device (e.g., a touch screen display) . If included, an optional side input element 515 allows further user input.
- the side input element 515 may be a rotary switch, a button, or any other type of manual input element.
- mobile computing device 500 may incorporate more or less input elements.
- the display 505 may not be a touch screen in some embodiments.
- the mobile computing device 500 is a portable phone system, such as a cellular phone.
- the mobile computing device 500 may also include an optional keypad 535.
- Optional keypad 535 may be a physical keypad or a “soft” keypad generated on the touch screen display.
- the output elements include the display 505 for showing a graphical user interface (GUI) , a visual indicator 520 (e.g., a light emitting diode) , and/or an audio transducer 525 (e.g., a speaker) .
- GUI graphical user interface
- the mobile computing device 500 incorporates a vibration transducer for providing the user with tactile feedback.
- the mobile computing device 500 incorporates peripheral device port 540, such as an audio input (e.g., a microphone jack) , an audio output (e.g., a headphone jack) , and a video output (e.g., a HDMI port) for sending signals to or receiving signals from an external device.
- FIG. 5B is a block diagram illustrating the architecture of one embodiment of a mobile computing device. That is, the mobile computing device 500 can incorporate a system (i.e., an architecture) 502 to implement some embodiments.
- the system 502 is implemented as a “smart phone” capable of running one or more applications (e.g., browser, e-mail, calendaring, contact managers, messaging clients, games, and media clients/players) .
- the system 502 is integrated as a computing device, such as an integrated personal digital assistant (PDA) and wireless phone.
- PDA personal digital assistant
- One or more application programs 550 may be loaded into the memory 562 and run on or in association with the operating system 564. Examples of the application programs include phone dialer programs, electronic communication applications, personal information management (PIM) programs, word processing programs, spreadsheet programs, Internet browser programs, messaging programs, and so forth.
- the system 502 also includes a non-volatile storage area 568 within the memory 562. The non-volatile storage area 568 may be used to store persistent information that should not be lost if the system 502 is powered down.
- the application programs 550 may use and store information in the non-volatile storage area 568, such as e-mail or other messages used by an e-mail application, and the like.
- a synchronization application (not shown) also resides on the system 502 and is programmed to interact with a corresponding synchronization application resident on a host computer to keep the information stored in the non-volatile storage area 568 synchronized with corresponding information stored at the host computer.
- other applications may be loaded into the memory 562 and run on the mobile computing device 500.
- the system 502 has a power supply 570, which may be implemented as one or more batteries.
- the power supply 570 might further include an external power source, such as an AC adapter or a powered docking cradle that supplements or recharges the batteries.
- the system 502 may also include a radio 572 that performs the function of transmitting and receiving radio frequency communications.
- the radio 572 facilitates wireless connectivity between the system 502 and the “outside world, ” via a communications carrier or service provider. Transmissions to and from the radio 572 are conducted under control of the operating system 564. In other words, communications received by the radio 572 may be disseminated to the application programs 550 via the operating system 564, and vice versa.
- the visual indicator 520 may be used to provide visual notifications and/or an audio interface 574 may be used for producing audible notifications via the audio transducer 525.
- the visual indicator 520 is a light emitting diode (LED) and the audio transducer 525 is a speaker.
- LED light emitting diode
- the LED may be programmed to remain on indefinitely until the user takes action to indicate the powered-on status of the device.
- the audio interface 574 is used to provide audible signals to and receive audible signals from the user.
- the audio interface 574 may also be coupled to a microphone to receive audible input, such as to facilitate a telephone conversation.
- the microphone may also serve as an audio sensor to facilitate control of notifications, as will be described below.
- the system 502 may further include a video interface 576 that enables an operation of an on-board camera 530 to record still images, video stream, and the like.
- a mobile computing device 500 implementing the system 502 may have additional features or functionality.
- the mobile computing device 500 may also include additional data storage devices (removable and/or non-removable) such as, magnetic disks, optical disks, or tape.
- additional storage is illustrated in Figure 5B by the non-volatile storage area 568.
- Data/information generated or captured by the mobile computing device 500 and stored via the system 502 may be stored locally on the mobile computing device 500, as described above, or the data may be stored on any number of storage media that may be accessed by the device via the radio 572 or via a wired connection between the mobile computing device 500 and a separate computing device associated with the mobile computing device 500, for example, a server computer in a distributed computing network, such as the Internet.
- a server computer in a distributed computing network such as the Internet.
- data/information may be accessed via the mobile computing device 500 via the radio 572 or via a distributed computing network.
- data/information may be readily transferred between computing devices for storage and use according to well-known data/information transfer and storage means, including electronic mail and collaborative data/information sharing systems.
- Figure 6 illustrates one embodiment of the architecture of a system for providing the functionality described herein across components of a distributed computing environment.
- Content developed, interacted with, or edited in association with the applications described above may be stored in different communication channels or other storage types.
- various documents may be stored using a directory service 622, a web portal 624, a mailbox service 626, an instant messaging store 628, or a social networking site 630.
- the application 450 e.g., an electronic communication application
- a server 615 may provide the functionality to clients 605a-c and 110.
- the server 615 may be a web server providing the application functionality described herein over the web.
- the server 615 may provide the application functionality over the web to clients 605a-c and 110 through a network 125, 610.
- a computing devices 110 may be implemented and embodied in a personal computer 605a, a tablet computing device 605b and/or a mobile computing device 605c (e.g., a smart phone) , or other computing device. Any of these embodiments of the client computing device may obtain content from the store 616.
- Embodiments of the present invention are described above with reference to block diagrams and/or operational illustrations of methods, systems, and computer program products according to embodiments of the invention.
- the functions/acts noted in the blocks may occur out of the order as shown in any flowchart.
- two blocks shown in succession may in fact be executed substantially concurrently or the blocks may sometimes be executed in the reverse order, depending upon the functionality/acts involved.
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
La présente invention concerne une mise à l'échelle et une gestion d'interrogations de base de données par rapport à de grands fichiers de données ou ensembles de données. De grands fichiers de données ou ensembles de données reçus au niveau d'un référentiel de mémorisation sont divisés en un certain nombre de segments ou blocs de données. Des groupements de sous-ensembles des segments ou blocs de données sont mémorisés au niveau de chaque serveur parmi de multiples serveurs. Lorsqu'une interrogation de données est reçue de l'entreprise en vue d'un traitement par rapport au fichier de données ou ensemble de données, l'interrogation est transmise à chaque serveur et est exécutée simultanément par rapport aux groupements de blocs de données plus petits au niveau de chaque serveur. Les résultats du traitement d'interrogation sont renvoyés à un serveur primaire. Des résultats en double sont éliminés, et les résultats restants sont agrégés. Un rapport peut ensuite être généré à partir des résultats agrégés et peut être renvoyé à l'entreprise d'interrogation.
Priority Applications (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
PCT/CN2015/073489 WO2016138614A1 (fr) | 2015-03-02 | 2015-03-02 | Gestion d'interrogations de base de données par rapport à de grands ensembles de données |
CN201580021377.8A CN106233287B (zh) | 2015-03-02 | 2015-03-02 | 对大型数据集的数据库查询的管理 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
PCT/CN2015/073489 WO2016138614A1 (fr) | 2015-03-02 | 2015-03-02 | Gestion d'interrogations de base de données par rapport à de grands ensembles de données |
Publications (1)
Publication Number | Publication Date |
---|---|
WO2016138614A1 true WO2016138614A1 (fr) | 2016-09-09 |
Family
ID=56849209
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/CN2015/073489 WO2016138614A1 (fr) | 2015-03-02 | 2015-03-02 | Gestion d'interrogations de base de données par rapport à de grands ensembles de données |
Country Status (2)
Country | Link |
---|---|
CN (1) | CN106233287B (fr) |
WO (1) | WO2016138614A1 (fr) |
Families Citing this family (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111400427A (zh) * | 2019-01-02 | 2020-07-10 | 阿里巴巴集团控股有限公司 | 数据存储、查询方法、装置和计算设备 |
US11005654B2 (en) * | 2019-05-14 | 2021-05-11 | Google Llc | Outsourcing exponentiation in a private group |
CN112115420A (zh) * | 2020-09-21 | 2020-12-22 | 携程计算机技术(上海)有限公司 | 基于离散分组的数据统计方法、系统、设备及存储介质 |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6772166B1 (en) * | 1998-10-02 | 2004-08-03 | Ncr Corporation | SQL-based analytic algorithm for clustering |
CN101496012A (zh) * | 2006-07-26 | 2009-07-29 | 微软公司 | 非常大数据库上的数据处理 |
CN101908075A (zh) * | 2010-08-17 | 2010-12-08 | 上海云数信息科技有限公司 | 基于sql的并行计算系统及方法 |
US20100332791A1 (en) * | 2009-06-25 | 2010-12-30 | Yu Xu | System, method, and computer-readable medium for optimizing processing of group-by queries featuring maximum or minimum equality conditions in a parallel processing system |
CN103473334A (zh) * | 2013-09-18 | 2013-12-25 | 浙江中控技术股份有限公司 | 数据存储、查询方法及系统 |
Family Cites Families (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9081829B2 (en) * | 2011-10-05 | 2015-07-14 | Cumulus Systems Incorporated | System for organizing and fast searching of massive amounts of data |
CN103473271B (zh) * | 2013-08-20 | 2017-09-26 | 苏州迈科网络安全技术股份有限公司 | 一种针对大量数据的优化储存方法 |
-
2015
- 2015-03-02 WO PCT/CN2015/073489 patent/WO2016138614A1/fr active Application Filing
- 2015-03-02 CN CN201580021377.8A patent/CN106233287B/zh active Active
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6772166B1 (en) * | 1998-10-02 | 2004-08-03 | Ncr Corporation | SQL-based analytic algorithm for clustering |
CN101496012A (zh) * | 2006-07-26 | 2009-07-29 | 微软公司 | 非常大数据库上的数据处理 |
US20100332791A1 (en) * | 2009-06-25 | 2010-12-30 | Yu Xu | System, method, and computer-readable medium for optimizing processing of group-by queries featuring maximum or minimum equality conditions in a parallel processing system |
CN101908075A (zh) * | 2010-08-17 | 2010-12-08 | 上海云数信息科技有限公司 | 基于sql的并行计算系统及方法 |
CN103473334A (zh) * | 2013-09-18 | 2013-12-25 | 浙江中控技术股份有限公司 | 数据存储、查询方法及系统 |
Also Published As
Publication number | Publication date |
---|---|
CN106233287A (zh) | 2016-12-14 |
CN106233287B (zh) | 2019-07-02 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US10394827B2 (en) | Discovering enterprise content based on implicit and explicit signals | |
US11418592B2 (en) | Uploading user and system data from a source location to a destination location | |
US20150058681A1 (en) | Monitoring, detection and analysis of data from different services | |
US20160070764A1 (en) | Distant content discovery | |
US20140372369A1 (en) | Managing Changes to Shared Electronic Documents Using Change History | |
EP3114566B1 (fr) | Enregistrement en double d'informations locales sur les lieux dans un système informatique basé sur un cloud | |
US20160110406A1 (en) | Validation of data across multiple data stores | |
US12001398B2 (en) | Electronic communication and file reference association | |
AU2016285676A1 (en) | Privacy enhanced personal search index | |
CN109313589B (zh) | 实现与外部功能的交互 | |
WO2016138614A1 (fr) | Gestion d'interrogations de base de données par rapport à de grands ensembles de données | |
US20160292289A1 (en) | Merged and actionable history feed | |
US10614063B2 (en) | Streaming records from parallel batched database access | |
US20180069774A1 (en) | Monitoring and reporting transmission and completeness of data upload from a source location to a destination location | |
WO2016138616A1 (fr) | Gestion de soumission de tâches d'interrogation de données | |
US11784888B2 (en) | Frequency-based sorting algorithm for feature sparse NLP datasets | |
US20190079986A1 (en) | Synchronizing non-file content stored on a collaborative workspace environment | |
US11250074B2 (en) | Auto-generation of key-value clusters to classify implicit app queries and increase coverage for existing classified queries | |
CN107210992B (zh) | 在安全数据系统和外部数据系统之间上传和下载数据 | |
US11886913B2 (en) | Decentralized data platform | |
US11373003B2 (en) | Mitigating inadvertent user information collection in telemetry data |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
121 | Ep: the epo has been informed by wipo that ep was designated in this application |
Ref document number: 15883671 Country of ref document: EP Kind code of ref document: A1 |
|
NENP | Non-entry into the national phase |
Ref country code: DE |
|
122 | Ep: pct application non-entry in european phase |
Ref document number: 15883671 Country of ref document: EP Kind code of ref document: A1 |